--- Revision None +++ Revision 323262366162 @@ -0,0 +1,12 @@ +CREATE TABLE `events_schedule` ( + `schedule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, + `course_id` bigint(20) unsigned NOT NULL, + `date_start` date NOT NULL, + `date_end` date NOT NULL, + `event_time` varchar(100) NOT NULL DEFAULT '', + PRIMARY KEY (`schedule_id`), + KEY `Index_2` (`date_start`,`date_end`) USING BTREE, + KEY `Index_3` (`date_end`,`date_start`) USING BTREE, + KEY `Index_4` (`course_id`,`date_start`,`date_end`) USING BTREE, + KEY `Index_5` (`course_id`,`date_end`,`date_start`) +) ENGINE=InnoDB AUTO_INCREMENT=66489 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT