
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
