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;
