Salary Market

use socle;

ALTER TABLE prospecting_company

CHANGE businessSector businessSectorCode VARCHAR(255) NOT NULL,

CHANGE country countryCode VARCHAR(255) NOT NULL,

ADD CONSTRAINT fk_business_sector_code FOREIGN KEY (businessSectorCode)

  REFERENCES solution_setting_business_sector(code)

  ON DELETE CASCADE ON UPDATE CASCADE,

ADD CONSTRAINT fk_country_code FOREIGN KEY (countryCode)

  REFERENCES solution_setting_country(code)

  ON DELETE CASCADE ON UPDATE CASCADE;