CREATE TABLE tx_cms (id INT AUTO_INCREMENT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE tx_cms_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT DEFAULT NULL, cmst_title VARCHAR(255) NOT NULL, cmst_content LONGTEXT NOT NULL, cmst_slug VARCHAR(255) NOT NULL, locale VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_9F9753EC86A085A0 (cmst_slug), INDEX IDX_9F9753EC2C2AC5D3 (translatable_id), UNIQUE INDEX tx_cms_translation_unique_translation (translatable_id, locale), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE tx_cms_translation ADD CONSTRAINT FK_9F9753EC2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES tx_cms (id) ON DELETE CASCADE;
