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