Salary Market

use  socle;

alter table company drop column countryCode;

CREATE TABLE company_country (

    id INT AUTO_INCREMENT PRIMARY KEY,

    companyId INT NOT NULL,

    countryCode VARCHAR(255) NOT NULL,

    FOREIGN KEY (companyId) REFERENCES company(id) ON DELETE CASCADE ON UPDATE CASCADE,

    FOREIGN KEY (countryCode) REFERENCES solution_setting_country(code) ON DELETE CASCADE ON UPDATE CASCADE,

    UNIQUE (companyId, countryCode)

);

-- add to the first company solution countries and cities