Trang chủ Khám phá Trợ giúp
Đăng nhập
examcloud-DevOps
/
examcloud-upgrade
2
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu kéo về 0 Wiki
Tree: 2ff30a371e
Branches Tags
examcloud-upgra...
/
upgrade-202005
/
mysql脚本.sql

mysql脚本.sql 6.7 KB
Lịch sử Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465 
  1. -- 修改权限组表
    2. 

  2. ALTER TABLE EC_B_PRIVILEGE_GROUP DROP INDEX UK_fsdvgdf02vmgi4nuq3k7hxbgy;
    3. 

  3. ALTER TABLE EC_B_PRIVILEGE_GROUP DROP INDEX UK_gtfc2sf4qnyb50v8wavhutcdy;
    4. 

  4. ALTER TABLE EC_B_PRIVILEGE_GROUP ADD type VARCHAR(50) NOT NULL;
    5. 

  5. ALTER TABLE EC_B_PRIVILEGE_GROUP ADD root_org_id BIGINT NULL;
    6. 

  6. ALTER TABLE EC_B_PRIVILEGE_GROUP ADD CONSTRAINT IDX_B_PRI_G_002001 UNIQUE (`code`);  
    7. 

  7. ALTER TABLE EC_B_PRIVILEGE_GROUP ADD CONSTRAINT IDX_B_PRI_G_002002 UNIQUE (root_org_id,type); 
    8. 

  8. 

  9. -- 权限组表更新数据
    10. 

  10. UPDATE ec_b_privilege_group set type='ADMIN_MENU' where id in (0,1,2,3,4,5,7) and 1=2;
    11. 

  11. UPDATE ec_b_privilege_group set type='FUNCTION' where id in (8);
    12. 

  12. UPDATE ec_b_privilege_group set type='DATA_ACCESS' where id in (9);
    13. 

  13. 

  14. -- 权限组表新增数据
    15. 

  15. INSERT INTO `ec_b_privilege_group`(`id`, `creation_time`, `update_time`, `code`, `name`, `type`, `root_org_id`, `ext1`, `ext2`, `ext3`, `ext4`, `ext5`) VALUES (10, '2020-03-26 15:02:16', '2020-03-26 15:02:16', 'STUDENT_CLIENT_MENU', '考生端菜单', 'STUDENT_CLIENT_MENU', NULL, 'menu', NULL, NULL, NULL, NULL);
    16. 

  16. 

  17. -- 权限表新增数据
    18. 

  18. INSERT INTO `ec_b_privilege`(`id`, `creation_time`, `update_time`, `code`, `description`, `ext1`, `ext2`, `ext3`, `ext4`, `ext5`, `group_id`, `name`, `parent_id`, `weight`) VALUES (6542, '2020-03-26 15:24:04', '2020-03-26 15:43:33', 'stu_online_exam', '在线考试', 'ONLINE', NULL, NULL, NULL, NULL, 10, '在线考试', NULL, 6);
    19. 

  19. INSERT INTO `ec_b_privilege`(`id`, `creation_time`, `update_time`, `code`, `description`, `ext1`, `ext2`, `ext3`, `ext4`, `ext5`, `group_id`, `name`, `parent_id`, `weight`) VALUES (6543, '2020-03-26 15:25:05', '2020-03-26 15:29:24', 'stu_online_homework', '在线作业', NULL, NULL, NULL, NULL, NULL, 10, '在线作业', NULL, 5);
    20. 

  20. INSERT INTO `ec_b_privilege`(`id`, `creation_time`, `update_time`, `code`, `description`, `ext1`, `ext2`, `ext3`, `ext4`, `ext5`, `group_id`, `name`, `parent_id`, `weight`) VALUES (6544, '2020-03-26 15:26:10', '2020-03-26 15:29:29', 'stu_online_practice', '在线练习', NULL, NULL, NULL, NULL, NULL, 10, '在线练习', NULL, 4);
    21. 

  21. INSERT INTO `ec_b_privilege`(`id`, `creation_time`, `update_time`, `code`, `description`, `ext1`, `ext2`, `ext3`, `ext4`, `ext5`, `group_id`, `name`, `parent_id`, `weight`) VALUES (6545, '2020-03-26 15:26:39', '2020-03-26 15:29:53', 'stu_offline_exam', '离线考试', NULL, NULL, NULL, NULL, NULL, 10, '离线考试', NULL, 3);
    22. 

  22. INSERT INTO `ec_b_privilege`(`id`, `creation_time`, `update_time`, `code`, `description`, `ext1`, `ext2`, `ext3`, `ext4`, `ext5`, `group_id`, `name`, `parent_id`, `weight`) VALUES (6546, '2020-03-26 15:27:05', '2020-03-26 15:30:00', 'stu_notice', '公告通知', NULL, NULL, NULL, NULL, NULL, 10, '公告通知', NULL, 2);
    23. 

  23. INSERT INTO `ec_b_privilege`(`id`, `creation_time`, `update_time`, `code`, `description`, `ext1`, `ext2`, `ext3`, `ext4`, `ext5`, `group_id`, `name`, `parent_id`, `weight`) VALUES (6547, '2020-03-26 15:28:55', '2020-03-26 15:30:05', 'stu_modify_pwd', '修改密码', NULL, NULL, NULL, NULL, NULL, 10, '修改密码', NULL, 1);
    24. 

  24. 

  25. 

  26. 

  27. -- 添加违纪类型表
    28. 

  28. CREATE TABLE `ec_oe_illegally_type`  (
    29. 

  29.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    30. 

  30.   `creation_time` datetime(0) NOT NULL,
    31. 

  31.   `update_time` datetime(0) NOT NULL,
    32. 

  32.   `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    33. 

  33.   `data_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    34. 

  34.   `enable` bit(1) NOT NULL,
    35. 

  35.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    36. 

  36.   `root_org_id` bigint(20) NOT NULL,
    37. 

  37.   `sort_no` int(11) NOT NULL,
    38. 

  38.   PRIMARY KEY (`id`) USING BTREE,
    39. 

  39.   UNIQUE INDEX `IDX_E_O_I_T_001`(`root_org_id`, `code`) USING BTREE
    40. 

  40. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
    41. 

  41. 

  42. -- 初始化违纪类型表
    43. 

  43. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (1, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'POWER_FAILURE', 'SYSTEM', b'1', '断电', -1, 7);
    44. 

  44. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (2, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'MACHINE_STOPPAGE', 'SYSTEM', b'1', '机器故障', -1, 9);
    45. 

  45. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (5, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'OTHER', 'SYSTEM', b'1', '其他', -1, 10);
    46. 

  46. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (6, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'CHEAT', 'SYSTEM', b'1', '作弊', -1, 1);
    47. 

  47. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (7, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'NOT_ONESELF', 'SYSTEM', b'1', '他人替考', -1, 2);
    48. 

  48. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (8, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'ACTION_FAILURE', 'SYSTEM', b'1', '指定动作失败', -1, 4);
    49. 

  49. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (9, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'WITHOUT_ACTION', 'SYSTEM', b'1', '未进行人脸指定动作检测', -1, 8);
    50. 

  50. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (10, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'BATCH_PASS', 'SYSTEM', b'1', '批量审核通过', -1, 6);
    51. 

  51. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (11, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'BATCH_NOTPASS', 'SYSTEM', b'1', '批量审核不通过', -1, 5);
    52. 

  52. INSERT INTO `ec_oe_illegally_type`(`id`, `creation_time`, `update_time`, `code`, `data_category`, `enable`, `name`, `root_org_id`, `sort_no`) VALUES (12, '2020-03-17 11:48:49', '2020-03-17 11:48:49', 'NOT_ONESELF_OF_PHOTO', 'SYSTEM', b'1', '相片替考', -1, 3);
    53. 

  53. 

  54. -- 考生表新加字段
    55. 

  55. ALTER TABLE ec_oe_exam_student ADD reexamine_type VARCHAR(50) NULL;
    56. 

  56. ALTER TABLE ec_oe_exam_student ADD reexamine_detail VARCHAR(200) NULL;
    57. 

  57. 

  58. -- 考试记录表新加字段
    59. 

  59. ALTER TABLE ec_oe_exam_record_data ADD reexamine_type VARCHAR(50) NULL;
    60. 

  60. ALTER TABLE ec_oe_exam_record_data ADD reexamine_detail VARCHAR(200) NULL;
    61. 

  61. 

  62. -- 审核表新加违纪类型字段
    63. 

  63. ALTER TABLE ec_oe_exam_audit ADD illegally_type_id BIGINT NULL;
    64. 

  64. 

  65.