3.3.0.sql 623 B

12345678910111213
  1. USE teachreport_db;
  2. -- 2023-11-28
  3. ALTER TABLE sys_user
  4. ADD COLUMN ui_setting TEXT NULL COMMENT '阅卷参数' AFTER historic_name,
  5. ADD COLUMN allow_manual_card TINYINT(1) NULL DEFAULT '0' COMMENT '是否允许新增卡格式' AFTER ui_setting;
  6. ALTER TABLE sys_role_privilege
  7. ADD COLUMN school_id BIGINT NULL COMMENT '内置角色,按学校自定义的权限' AFTER enable;
  8. ALTER TABLE basic_school
  9. ADD COLUMN init_password VARCHAR(100) NULL COMMENT '该学校用户的初始密码,默认为12345678' AFTER logo,
  10. CHANGE COLUMN logo logo MEDIUMTEXT NULL DEFAULT NULL COMMENT 'logo' AFTER update_id;