Miscellany

CREATE TABLE IF NOT EXISTS `route` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `carrier_user_id` int(11) NOT NULL,  `departure_station_id` int(11) NOT NULL,  `arrival_station_id` int(11) NOT NULL,  `train_number` varchar(5) NOT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `UNIQ_2C42079F39DF5DD` (`carrier_user_id`),  UNIQUE KEY `UNIQ_2C42079FF134AA1` (`departure_station_id`),  UNIQUE KEY `UNIQ_2C42079766102BE` (`arrival_station_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;