Salary Market

use socle;

ALTER TABLE company_activities

DROP COLUMN description;

CREATE TABLE company_activities_translate (

	id  INT AUTO_INCREMENT PRIMARY KEY,

	description VARCHAR(255),

	activityId INT NOT NULL,

	languageId INT NOT NULL,

	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,     

	updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

	FOREIGN KEY (languageId) REFERENCES languages(id) ON DELETE CASCADE ON UPDATE CASCADE,

	FOREIGN KEY (activityId) REFERENCES company_activities(id) ON DELETE CASCADE ON UPDATE CASCADE

);