use socle ;

ALTER TABLE company 
CHANGE COLUMN SIRET taxRegistration VARCHAR(255) NULL,
ADD COLUMN subSectorCode VARCHAR(255) NULL,
ADD CONSTRAINT fk_subSector FOREIGN KEY (subSectorCode) 
REFERENCES solution_setting_sub_sector(code) 
ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE company_users 
ADD COLUMN  poste VARCHAR(255) NULL;

