Friendpaste

--- 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
a	b
	0	+	CREATE TABLE `events_schedule` (
	0	+	`schedule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	0	+	`course_id` bigint(20) unsigned NOT NULL,
	0	+	`date_start` date NOT NULL,
	0	+	`date_end` date NOT NULL,
	0	+	`event_time` varchar(100) NOT NULL DEFAULT '',
	0	+	PRIMARY KEY (`schedule_id`),
	0	+	KEY `Index_2` (`date_start`,`date_end`) USING BTREE,
	0	+	KEY `Index_3` (`date_end`,`date_start`) USING BTREE,
	0	+	KEY `Index_4` (`course_id`,`date_start`,`date_end`) USING BTREE,
	0	+	KEY `Index_5` (`course_id`,`date_end`,`date_start`)
	0	+	) ENGINE=InnoDB AUTO_INCREMENT=66489 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT
...