UPDATE `sys_action` SET `action` = 'submitted' WHERE `objectType` IN ('attend', 'leave', 'lieu', 'makeup', 'overtime', 'refund') AND `action` = 'commited'; UPDATE `sys_entry` SET `login` = CONCAT('../', `code`, '/') WHERE `code` IN ('crm', 'oa', 'proj', 'doc', 'cash', 'team'); UPDATE `sys_user` SET `admin` = 'no' WHERE `admin` = 'common'; ALTER TABLE `sys_user` CHANGE `admin` `admin` enum('no','super') NOT NULL DEFAULT 'no';