ALTER TABLE `eb_attendance_shift` ADD `types` INT NOT NULL DEFAULT '0' COMMENT '班次类型:0、正常;1、休息;2、默认' AFTER `uid`; UPDATE `eb_attendance_shift` SET `types` = 1 WHERE `eb_attendance_shift`.`id` = 1; UPDATE `eb_attendance_shift` SET `types` = 2 WHERE `eb_attendance_shift`.`id` = 2; ALTER TABLE `eb_attendance_whitelist` ADD `entid` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '关联企业id' AFTER `id`;