ALTER TABLE blog ADD CONSTRAINT FK_C01551435BBE4F3A FOREIGN KEY (filtrageblog_code) REFERENCES filtrageblog (id);
CREATE INDEX IDX_C01551435BBE4F3A ON blog (filtrageblog_code);
ALTER TABLE carriere ADD titreoffre_en VARCHAR(255) DEFAULT NULL, ADD textoffre_en LONGTEXT DEFAULT NULL, CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE client CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE client ADD CONSTRAINT FK_C744045545D16406 FOREIGN KEY (sourcefiltrageclient_code) REFERENCES filtrageclient (id);
CREATE INDEX IDX_C744045545D16406 ON client (sourcefiltrageclient_code);
ALTER TABLE contact CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE emplyeurcarriere CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE emplyeurcarriere ADD CONSTRAINT FK_A75E18D64F0FCBAD FOREIGN KEY (emplyeur_code) REFERENCES carriere (id);
CREATE INDEX IDX_A75E18D64F0FCBAD ON emplyeurcarriere (emplyeur_code);
ALTER TABLE filiare CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE filtrageblog CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE filtrageclient CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE fournisseur CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE membre_codir ADD role VARCHAR(255) DEFAULT NULL, ADD photo_filename VARCHAR(255) DEFAULT NULL, ADD linkedin_url VARCHAR(500) DEFAULT NULL, DROP poste, DROP photo;
ALTER TABLE newsletter CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE pays CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE project ADD titre_en VARCHAR(255) DEFAULT NULL, ADD description_en LONGTEXT DEFAULT NULL, ADD contexte_en LONGTEXT DEFAULT NULL, ADD problematique_en LONGTEXT DEFAULT NULL, ADD solution_en LONGTEXT DEFAULT NULL, ADD role_stram_en LONGTEXT DEFAULT NULL, ADD kpis_en LONGTEXT DEFAULT NULL, CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);
ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EEAB573D98 FOREIGN KEY (temoignagecode) REFERENCES temoignage (id);
ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EEFE612064 FOREIGN KEY (payercode) REFERENCES pays (id);
ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EE182E5A15 FOREIGN KEY (servicecode) REFERENCES service (id);
ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EEEE192506 FOREIGN KEY (servicecode1) REFERENCES service (id);
ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EE771074BC FOREIGN KEY (servicecode2) REFERENCES service (id);
ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EE17442A FOREIGN KEY (servicecode3) REFERENCES service (id);
ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EE9E73D189 FOREIGN KEY (servicecode4) REFERENCES service (id);
CREATE INDEX IDX_2FB3D0EEAB573D98 ON project (temoignagecode);
CREATE INDEX IDX_2FB3D0EEFE612064 ON project (payercode);
CREATE INDEX IDX_2FB3D0EE182E5A15 ON project (servicecode);
CREATE INDEX IDX_2FB3D0EEEE192506 ON project (servicecode1);
CREATE INDEX IDX_2FB3D0EE771074BC ON project (servicecode2);
CREATE INDEX IDX_2FB3D0EE17442A ON project (servicecode3);
CREATE INDEX IDX_2FB3D0EE9E73D189 ON project (servicecode4);
