CREATE TABLE tx_trajet_collectif_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT DEFAULT NULL, trjt_description_depart LONGTEXT NOT NULL, trjt_description_arrivee LONGTEXT NOT NULL, locale VARCHAR(255) NOT NULL, INDEX IDX_DD8051FF2C2AC5D3 (translatable_id), UNIQUE INDEX tx_trajet_collectif_translation_unique_translation (translatable_id, locale), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE tx_trajet_collectif_translation ADD CONSTRAINT FK_DD8051FF2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES tx_trajet_collectif (id) ON DELETE CASCADE;
