CREATE TABLE tx_trajet_intermediaire (id INT AUTO_INCREMENT NOT NULL, tx_place_id INT DEFAULT NULL, tx_trajet_id INT DEFAULT NULL, trjd_desc VARCHAR(255) DEFAULT NULL, trjd_ranking INT DEFAULT NULL, INDEX IDX_317960B458DA626 (tx_place_id), INDEX IDX_317960B4BB7CAE1A (tx_trajet_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE tx_trajet_intermediaire ADD CONSTRAINT FK_317960B458DA626 FOREIGN KEY (tx_place_id) REFERENCES tx_place (id);
ALTER TABLE tx_trajet_intermediaire ADD CONSTRAINT FK_317960B4BB7CAE1A FOREIGN KEY (tx_trajet_id) REFERENCES tx_trajet (id);