20250307_sql.sql 685 B

1234567891011121314
  1. ALTER TABLE `banding_task_class_student`
  2. ADD COLUMN `is_report` INT NULL AFTER `status`;
  3. ALTER TABLE `base_new_student`
  4. ADD COLUMN `is_report` INT COMMENT '是否可以分班(0:否,1:是)';
  5. ALTER TABLE `base_new_student`
  6. ADD COLUMN `remarks` VARCHAR(250) COMMENT '备注';
  7. ALTER TABLE `base_new_student`
  8. ADD COLUMN `operate_mode` INT COMMENT '分班类型(1:自动分班 2:手动分班)';
  9. ALTER TABLE `base_new_student`
  10. CHANGE `status` `status` INT DEFAULT 0 NULL COMMENT '班级状态(0:未分配, 1:已分配)',
  11. CHANGE `is_can_banding` `is_can_banding` INT DEFAULT 1 NULL COMMENT '是否可以分班(0:否,1:是)';