20241230_sql.sql 949 B

123456789101112131415161718192021
  1. ALTER TABLE `base_student_assessment_inspection`
  2. CHANGE `class_ids` `class_ids` VARCHAR(30) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '班级Ids(多选)';
  3. -- 增加菜单地址字段长度
  4. ALTER TABLE `base_student_assessment_student_relation`
  5. ADD COLUMN `delete_mark` INT DEFAULT 0 NULL AFTER `score`,
  6. ADD COLUMN `enabled_mark` INT DEFAULT 1 NULL AFTER `delete_mark`;
  7. -- 增加菜单地址字段长度
  8. ALTER TABLE `xjr_menu`
  9. CHANGE `path` `path` VARCHAR(500) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '地址',
  10. CHANGE `iframe_src` `iframe_src` VARCHAR(500) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '外链地址';
  11. ALTER TABLE `wf_teacher_course_time`
  12. ADD COLUMN `file_id` BIGINT NULL COMMENT '上传的文件(xjr_file[floder_id])' AFTER `create_date`;
  13. ALTER TABLE `base_student_assessment_student_relation`
  14. ADD COLUMN `modify_date` DATETIME DEFAULT NULL;