Revision 323262366162 () - Diff

Link to this snippet: https://friendpaste.com/1HrC0L62hFR4DghE6ypIRp
Embed:
1
2
3
4
5
6
7
8
9
10
11
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