ALTER TABLE `ses_sub` ADD `att` VARCHAR(16) NOT NULL;

CREATE TABLE `attcls` ( `id` bigint(20) NOT NULL, `sid` tinyint(4) DEFAULT '0', `stu` varchar(18) COLLATE utf8_unicode_ci DEFAULT NULL, `stuname` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL, `tea` varchar(18) COLLATE utf8_unicode_ci DEFAULT NULL, `teaname` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL, `cls` varchar(18) COLLATE utf8_unicode_ci DEFAULT NULL, `clsname` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL, `sub` varchar(18) COLLATE utf8_unicode_ci DEFAULT NULL, `subname` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL, `year` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `dt` date DEFAULT NULL, `tm` time DEFAULT NULL, `att` tinyint(4) DEFAULT '0', `sta` tinyint(4) DEFAULT '0', `des` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `encounter` int(11) DEFAULT '0', `bilencounter` int(11) DEFAULT '0', `clsnum` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `totalcls` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `adm` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `ts` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `json_data` text CHARACTER SET latin1, `remark` text CHARACTER SET latin1) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `attcls` ADD PRIMARY KEY (`id`),

ALTER TABLE `attcls` ADD KEY `sid` (`sid`),

ALTER TABLE `attcls` ADD KEY `year` (`year`),

ALTER TABLE `attcls` ADD KEY `stu` (`stu`),

ALTER TABLE `attcls` ADD KEY `cls` (`cls`),

ALTER TABLE `attcls` ADD KEY `sub` (`sub`),

ALTER TABLE `attcls` ADD KEY `dt` (`dt`);

ALTER TABLE `attcls` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;