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
);