CREATE TABLE tx_trajet_collectif (id INT AUTO_INCREMENT NOT NULL, tx_zone_id_depart INT DEFAULT NULL, tx_zone_id_arrive INT DEFAULT NULL, trj_name VARCHAR(100) DEFAULT NULL, trj_date DATE DEFAULT NULL, trj_heure_depart TIME DEFAULT NULL, trj_heure_arrivee TIME DEFAULT NULL, trj_nbr_place INT NOT NULL, trj_prix_place DOUBLE PRECISION DEFAULT NULL, INDEX IDX_4BB6A392CA1337AF (tx_zone_id_depart), INDEX IDX_4BB6A392E2D8914B (tx_zone_id_arrive), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE tx_trajet_collectif ADD CONSTRAINT FK_4BB6A392CA1337AF FOREIGN KEY (tx_zone_id_depart) REFERENCES tx_zone (id) ON DELETE CASCADE;
ALTER TABLE tx_trajet_collectif ADD CONSTRAINT FK_4BB6A392E2D8914B FOREIGN KEY (tx_zone_id_arrive) REFERENCES tx_zone (id) ON DELETE CASCADE;
