20240528至现在-待升级内容.txt 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  1. release_v5.0.4
  2. ***** ***** ***** ***** ***** ***** *****
  3. 一、数据库变更(!!!任何!!!表或字段的变化罗列此处)
  4. ***** ***** ***** ***** ***** ***** *****
  5. MySql部分
  6. CREATE TABLE ec_oe_reexamine_log (
  7. id bigint(20) NOT NULL AUTO_INCREMENT,
  8. creation_time datetime NOT NULL,
  9. update_time datetime NOT NULL,
  10. exam_id bigint(20) NOT NULL,
  11. exam_student_id bigint(20) NOT NULL,
  12. reexamine_type varchar(50) DEFAULT NULL,
  13. reexamine_detail varchar(200) DEFAULT NULL,
  14. operate_user_id bigint(20) DEFAULT NULL,
  15. operate_user_name varchar(50) DEFAULT NULL,
  16. PRIMARY KEY (id),
  17. KEY IDX_01 (exam_id),
  18. KEY IDX_02 (exam_student_id)
  19. );
  20. DROP TABLE IF EXISTS `ec_e_org_ip`;
  21. CREATE TABLE `ec_e_org_ip` (
  22. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  23. `root_org_id` bigint(20) NOT NULL,
  24. `org_id` bigint(20) NOT NULL,
  25. `ip` varchar(255) NOT NULL,
  26. `creation_by` bigint(20) NOT NULL,
  27. `creation_time` datetime NOT NULL,
  28. `update_by` bigint(20) NOT NULL,
  29. `update_time` datetime NOT NULL,
  30. `remark` varchar(100) DEFAULT NULL,
  31. PRIMARY KEY (`id`),
  32. UNIQUE KEY `IDX_E_ORG_IP_01` (`root_org_id`,`org_id`,`ip`)
  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  34. ALTER TABLE ec_m_mark_work ADD org_enabled bit(1) NOT NULL DEFAULT 0;
  35. ALTER TABLE ec_m_student_paper ADD org_id bigint(20) DEFAULT NULL;
  36. ALTER TABLE ec_m_student_paper ADD exam_id bigint(20) DEFAULT NULL;
  37. ALTER TABLE ec_m_student_paper ADD sum_score double DEFAULT NULL;
  38. ALTER TABLE ec_m_student_paper ADD INDEX IDX_M_S_P_007(`work_id`,`sum_score`);
  39. ALTER TABLE old_ec_m_mark_work ADD org_enabled bit(1) NOT NULL DEFAULT 0;
  40. ALTER TABLE old_ec_m_student_paper ADD org_id bigint(20) DEFAULT NULL;
  41. ALTER TABLE old_ec_m_student_paper ADD exam_id bigint(20) DEFAULT NULL;
  42. ALTER TABLE old_ec_m_student_paper ADD sum_score double DEFAULT NULL;
  43. ALTER TABLE old_ec_m_student_paper ADD INDEX IDX_M_S_P_007(`work_id`,`sum_score`);
  44. ALTER TABLE ec_b_student MODIFY COLUMN identity_number varchar(20) NOT NULL;
  45. ALTER TABLE ec_e_exam_student MODIFY COLUMN identity_number varchar(20) NOT NULL;
  46. ALTER TABLE ec_t_exam_student_tmp MODIFY COLUMN identity_number varchar(20) NOT NULL;
  47. app_device_record renameTo ec_app_device_record
  48. drop tables:
  49. ec_exam_site_batch
  50. ec_test_offline_file
  51. test2022
  52. MongoDB部分
  53. 暂无
  54. Redis部分
  55. 暂无
  56. ***** ***** ***** ***** ***** ***** *****
  57. 二、数据割接部分
  58. ***** ***** ***** ***** ***** ***** *****
  59. 修复错误底照路径规则:
  60. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  61. where root_org_id=0 and photo_path like '0/%';
  62. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  63. where root_org_id=1 and photo_path like '1/%';
  64. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  65. where root_org_id=135 and photo_path like '135/%';
  66. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  67. where root_org_id=137 and photo_path like '137/%';
  68. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  69. where root_org_id=302 and photo_path like '302/%';
  70. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  71. where root_org_id=303 and photo_path like '303/%';
  72. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  73. where root_org_id=371 and photo_path like '371/%';
  74. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  75. where root_org_id=718 and photo_path like '718/%';
  76. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  77. where root_org_id=1226 and photo_path like '1226/%';
  78. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  79. where root_org_id=1347 and photo_path like '1347/%';
  80. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  81. where root_org_id=1348 and photo_path like '1348/%';
  82. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  83. where root_org_id=1350 and photo_path like '1350/%';
  84. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  85. where root_org_id=1384 and photo_path like '1384/%';
  86. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  87. where root_org_id=1385 and photo_path like '1385/%';
  88. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  89. where root_org_id=1387 and photo_path like '1387/%';
  90. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  91. where root_org_id=1388 and photo_path like '1388/%';
  92. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  93. where root_org_id=1627 and photo_path like '1627/%';
  94. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  95. where root_org_id=1769 and photo_path like '1769/%';
  96. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  97. where root_org_id=16198 and photo_path like '16198/%';
  98. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  99. where root_org_id=16801 and photo_path like '16801/%';
  100. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  101. where root_org_id=16816 and photo_path like '16816/%';
  102. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  103. where root_org_id=16915 and photo_path like '16915/%';
  104. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  105. where root_org_id=16923 and photo_path like '16923/%';
  106. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  107. where root_org_id=16924 and photo_path like '16924/%';
  108. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  109. where root_org_id=17068 and photo_path like '17068/%';
  110. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  111. where root_org_id=17141 and photo_path like '17141/%';
  112. update ec_b_student set photo_path = concat('/student_base_photo/',photo_path)
  113. where root_org_id=17172 and photo_path like '17172/%';
  114. ***** ***** ***** ***** ***** ***** *****
  115. 三、配置文件变更
  116. ***** ***** ***** ***** ***** ***** *****
  117. 移除配置项:
  118. $upyun.site.*
  119. $aliyun.site.*
  120. 新增配置项:
  121. examcloud.fss.*
  122. ***** ***** ***** ***** ***** ***** *****
  123. 四、菜单项变更
  124. ***** ***** ***** ***** ***** ***** *****
  125. 考务管理菜单 --> 考试管理 --> 考点IP登记(ip_config 属性1:menu 属性5:/examwork/ip-config)
  126. 考务管理菜单 --> 考试管理 --> 考点IP登记 --> 同步到考试(ORG_IP_CONFIG_SYNC 属性1:button)
  127. 网考管理菜单 --> 网考管理 --> 重考设置记录(reexamine_record 属性1:menu 属性5:/oe/reexamine-record 权重:5)
  128. ***** ***** ***** ***** ***** ***** *****
  129. 五、其它变更(如:系统参数、环境、脚本。。。)
  130. ***** ***** ***** ***** ***** ***** *****
  131. 人脸抓拍比对任务调度参数支持:
  132. {
  133. "maxThreadNum": 2,
  134. "maxErrorNum": 10,
  135. "useBaiduApi": true,
  136. "useLocalBaiduApiForFaceCompare": true,
  137. "useLocalBaiduApiForFaceLiveness": true
  138. }