CREATE TABLE IF NOT EXISTS `mylesson` ( `id` int(11) NOT NULL, `dt` date DEFAULT NULL, `lesson_time` varchar(18) NOT NULL, `uid` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sid` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `clscode` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `subcode` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `semester` varchar(16) NOT NULL, `week` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `year` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `title` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `lesson_info1` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info2` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info3` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info4` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info5` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info6` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info7` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info8` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info9` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info10` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info11` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info12` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lesson_info13` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `verify_status` tinyint(4) NOT NULL DEFAULT '0', `verify_by` varchar(100) DEFAULT NULL, `verify_dt` date DEFAULT NULL, `lesson_comment` varchar(100) DEFAULT NULL, `isdel` tinyint(4) NOT NULL DEFAULT '0', `delts` datetime DEFAULT '0000-00-00 00:00:00', `delby` varchar(32) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `mylesson` ADD PRIMARY KEY (`id`);

ALTER TABLE `mylesson` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;