api/src/main/resources/sqlScript/20240618_sql.sql

-- 给每个绑定考勤规则的用户增加考勤相关状态
ALTER TABLE `attendance_user_relation`   
  ADD COLUMN `attendance_status` VARCHAR(20) DEFAULT 0  NULL COMMENT '考勤状态' AFTER `attendance_rule_category_id`,
  ADD COLUMN `attendance_time` DATETIME NULL   COMMENT '最新考勤时间' AFTER `attendance_status`;

ALTER TABLE `attendance_user_relation`   
  ADD COLUMN `attendance_mode` VARCHAR(20) DEFAULT 0  NULL COMMENT '考勤方式',
  ADD COLUMN `car_number` VARCHAR(20) NULL COMMENT '车牌号' AFTER `attendance_mode`;


ALTER TABLE wf_textbook_subscription_item
    ADD instockroom_num INT DEFAULT 0 NULL COMMENT '当前征订任务征订项已经入库数量';
ALTER TABLE wf_textbook_subscription_item
    ADD alteration_type INT DEFAULT 0 NULL COMMENT '变更类型（0：未变更，1：变更征订数量，2：变更课程）';
ALTER TABLE wf_textbook_subscription_item
    CHANGE instockroom_num in_stockroom_num INT DEFAULT 0 NULL COMMENT '当前征订任务征订项已经入库数量';