PROD V(22) ACTUEL » 4_script_alter_prosp.sql
| 1 |
use salarymarket; |
|---|---|
| 2 |
ALTER TABLE prospecting_company |
| 3 |
CHANGE businessSector businessSectorCode VARCHAR(255) NOT NULL, |
| 4 |
CHANGE country countryCode VARCHAR(255) NOT NULL, |
| 5 |
ADD CONSTRAINT fk_business_sector_code FOREIGN KEY (businessSectorCode) |
| 6 |
REFERENCES solution_setting_business_sector(code) |
| 7 |
ON DELETE CASCADE ON UPDATE CASCADE, |
| 8 |
ADD CONSTRAINT fk_country_code FOREIGN KEY (countryCode) |
| 9 |
REFERENCES solution_setting_country(code) |
| 10 |
ON DELETE CASCADE ON UPDATE CASCADE; |