-- if cities table primary key is not auto increment
ALTER TABLE cities
MODIFY COLUMN id INT AUTO_INCREMENT;

--if spaces table primary key is not auto increment
ALTER TABLE spaces
MODIFY COLUMN id INT AUTO_INCREMENT;

-- Add youtube_url column in spaces table
ALTER TABLE spaces
ADD youtube_url VARCHAR(255) DEFAULT '';

-- Add contact details column in spaces table
ALTER TABLE spaces
ADD state VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD country VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD zip_code VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD contact_name VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD contact_mobile VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD contact_email VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD alternate_contact_name VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD  alternate_contact_email VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD alternate_contact_mobile VARCHAR(255) DEFAULT '';

ALTER TABLE spaces
ADD contact_city_name VARCHAR(255) DEFAULT '';

---Proposals table 
CREATE TABLE proposals(
  id INT PRIMARY KEY AUTO_INCREMENT,
  lead_id INT,
  spaces_data JSON
);

--- 20 june managers table
ALTER TABLE managers
ADD profile_image VARCHAR(555) DEFAULT '';

UPDATE managers SET id = 14 WHERE id = 1;


ALTER TABLE managers
MODIFY COLUMN id INT AUTO_INCREMENT;