婺城服务漏洞更新
修复方案
小版本：漏洞临时专用分支 1.0.4-SNAPSHOT【可升级】
此分支大量更新了依赖组件的版本号，并升级了 Spring 和 Spring Security 版本，会照成 /actuator/health/liveness 服务监控探针失效。
- 创建 tianyin-boot 分支 1.0.4-SNAPSHOT，更新各类依赖组件
- Spring 升级到 5.3.39，Spring Security 升级到 5.8.16
- 其他各类组件进行版本升级
- 创建 tianyin-cloud 分支 1.0.4-SNAPSHOT
- spring-cloud-alibaba 升级到 2.2.11
- spring-cloud-deployer 升级到 2.3.1.RELEASE
- spring-cloud-netflix 升级到 2.2.10.RELEASE
- spring-cloud-netflix-eureka 升级到 3.1.8
- spring-cloud-openfeign 升级到 2.2.9.RELEASE
- spring-cloud-function 升级到 3.1.7
小版本：天音自用分支 Hoxton.x.20240823-SNAPSHOT【可升级】
此分支，合并了 1.0.4-SNAPSHOT 分支中大量更新的依赖组件的版本，Spring 和 Spring Security 版本依旧保持在旧版本，存在安全漏洞，但 /actuator/health/liveness 服务监控探针可用，目前暂用于天音自己的生产环境。
- 更新 tianyin-boot 分支 2.3.x-SNAPSHOT，合并 1.0.4-SNAPSHOT 分支更新的各类依赖组件
- Spring ，Spring Security 暂未升级
- 其他各类组件进行版本升级
- 更新 tianyin-cloud 分支 Hoxton.x.20240823-SNAPSHOT
- spring-cloud-alibaba 升级到 2.2.11
- spring-cloud-deployer 升级到 2.3.1.RELEASE
- spring-cloud-netflix 升级到 2.2.10.RELEASE
- spring-cloud-netflix-eureka 升级到 3.1.8
- spring-cloud-openfeign 升级到 2.2.9.RELEASE
- spring-cloud-function 升级到 3.1.7
大版本：全面升级 JDk 17, 分支 2021.0.x-SNAPSHOT【测试中】
此分支，合并了 1.0.4-SNAPSHOT 分支中大量更新的依赖组件的版本，Spring 和 Spring Security 版本升级到最新版本，修复当下所有安全漏洞。
- 更新 tianyin-boot 分支 2.7.x-SNAPSHOT，合并 1.0.4-SNAPSHOT 分支更新的各类依赖组件
- Spring ，Spring Security 升级到最新版本
- 其他各类组件进行版本升级
- 更新 tianyin-cloud 分支 2021.0.x-SNAPSHOT
2、修复结果
数据中台【万大龙】：
- 1、数据中台 Admin: aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-dw-admin:ty-base-1.0.1
- 2、数据中台API：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-dw-api:ty-base-1.0.0
- 3、数据标准服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-dw-standard:ty-base-v1.0.1
- 4、数据接口服务：处理中
业务中台【万大龙】：
- 1、API网关服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-gateway:v1.0.1-api-fixcev
- 2、安全审计服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-logs:ty-base-v1.0.2
- 3、三方对接服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-third:ty-base-v1.0.3
- 4、消息中心服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-inform:ty-v1.0.1
- 5、文档信息服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-mindoc:ty-base-v1.0.3
- 6、xxl-job-admin 服务：
业务中台【郭冠华】：
- 3、业务接口服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-openapi:ty-base-v1.1.0-safefix
- 1、认证授权服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-authz:ty-base-v1.0.7.2-safefix
- 2、用户中心服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-user:ty-base-v1.0.6.1-safefix
- 3、组织中枢服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-rbac:ty-base-v1.0.6.1-safefix
- 4、个人门户服务 aiban-docker.pkg.coding.net/biz-portal/docker/tianyin-edu-portal:ty-base-v2.0.2-safefix
- 6、应用中心服务： aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-app:ty-base-v2.1.1-safefix
- 7、数据同步服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-datasync:sync_bingjiang_2.0_safefix
- 8、局校一体化平台-评价标准服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-evaluation:ty-base-v1.0.5-1018-safefix
- 9、异步任务服务：aiban-docker.pkg.coding.net/dongyangxiangmu/dongyang/tianyin-edu-task:ty-base-v2.1.3
- 10、Cas认证服务：jhwc-base-v1.0.2.1-safefix
成长档案【郭冠华】：
- 报告单网关：aiban-docker.pkg.coding.net/growth-portfolio/docker/tianyin-portfolio-gateway:test
- 报告单授权：aiban-docker.pkg.coding.net/growth-portfolio/docker/tianyin-portfolio-auth:v2.0_250307_safeFix
- 报告单任务：aiban-docker.pkg.coding.net/growth-portfolio/docker/tianyin-portfolio-task:v5.0_safeFix
- 报告单三方对接：aiban-docker.pkg.coding.net/growth-portfolio/docker/tianyin-portfolio-third:v2.0.1_250307_safeFix
- 报告单后台：aiban-docker.pkg.coding.net/growth-portfolio/docker/tianyin-portfolio-admin-v2:v6.3_250307_safeFix
tianyin-portfolio-third 修改配置 ——————————————-
exposedMiniourl 修改为 exposedUrl
oss:
cloud:
bucket: growth-saas
## local,fdfs,oss-aliyun,oss-tencent,oss-baidu,oss-huawei,oss-minio 指定存储方式
storeChannel: oss-minioNewOA 评价【汪安乐】：
婺城升级
sql 脚本
-- Script generated by MySQL Compare 1.0.1.4 on 2025/3/11 10:57:20
SET @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @ORIGINAL_SQL_MODE=@@SQL_MODE, SQL_MODE='ALLOW_INVALID_DATES,NO_AUTO_VALUE_ON_ZERO,NO_AUTO_CREATE_USER';
SET @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @ORIGINAL_SQL_MODE=@@SQL_MODE, SQL_MODE='ALLOW_INVALID_DATES,NO_AUTO_VALUE_ON_ZERO,NO_AUTO_CREATE_USER';
CREATE TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_0` (
`id` bigint(20) NOT NULL,
`dimension_id` bigint(20) NOT NULL COMMENT '维度编号',
`dimension_name` varchar(20) NOT NULL COMMENT '维度',
`level_name` varchar(20) NOT NULL COMMENT '等级',
`level_id` bigint(20) NOT NULL COMMENT '维度等级编号',
`min` decimal(11,2) NOT NULL DEFAULT 0.00 COMMENT '最小',
`max` decimal(11,2) NOT NULL DEFAULT 0.00 COMMENT '最大',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除 1.删除 0.正常',
`create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP COMMENT '更新时间',
`create_user` varchar(36) NULL COMMENT '创建人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB row_format=DYNAMIC COMMENT='维度统计等级关系表';
INSERT INTO `ty_evaluation_jhwch`.`RG_TEMP_1046981153_0`(`id`,`dimension_id`,`dimension_name`,`level_name`,`level_id`,`min`,`max`,`school_code`,`is_deleted`,`create_time`,`update_time`,`create_user`) SELECT `id`,`dimension_id`,`dimension_name`,`level_name`,`level_id`,`min`,`max`,`school_code`,`is_deleted`,`create_time`,`update_time`,`create_user` FROM `ty_evaluation_jhwch`.`pj_dimension_level_setting`;
DROP TABLE `ty_evaluation_jhwch`.`pj_dimension_level_setting`;
ALTER TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_0` RENAME TO `pj_dimension_level_setting`;
CREATE INDEX `idx_school_pid` ON `ty_evaluation_jhwch`.`pj_dimension_item`(`school_code`, `pids`);
CREATE INDEX `idx_school_pidid` ON `ty_evaluation_jhwch`.`pj_dimension_item`(`school_code`, `pid`);
CREATE TABLE `ty_evaluation_jhwch`.`pj_encourage_award` (
`id` bigint(20) NOT NULL COMMENT 'ID',
`honor_name` varchar(50) NOT NULL COMMENT '名称',
`order_by` int(3) NULL DEFAULT '999' COMMENT '显示顺序',
`status` tinyint(2) NULL DEFAULT 1 COMMENT '状态（0:禁用|1:可用）',
`data_model` text NULL COMMENT '奖状包含的文字模块json，xsmc：包含学生姓名，bjmc：选择班级名称',
`background_url` varchar(300) NULL COMMENT '奖状背景图',
`view_model` text NULL COMMENT '奖状单页组合的原始Json数据',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`is_deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除（0:未删除,1:已删除）',
`creator` bigint(12) NULL DEFAULT 0 COMMENT '创建人ID',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modifyer` bigint(12) NULL COMMENT '修改人ID',
`modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '修改时间',
`system_model` int(11) NOT NULL DEFAULT '0' COMMENT '是否学校系统模板',
PRIMARY KEY (`id`),
KEY `idx_xx_zt_del`(`school_code`, `status`, `is_deleted`) COMMENT '激励体系奖状表索引'
) ENGINE=InnoDB COMMENT='激励体系奖状表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_encourage_award_relation` (
`id` bigint(20) NOT NULL COMMENT 'ID',
`award_id` bigint(20) NOT NULL COMMENT '奖状id',
`encourage_id` bigint(20) NOT NULL COMMENT '激励体系id',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`is_deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除（0:未删除,1:已删除）',
`creator` bigint(12) NULL DEFAULT 0 COMMENT '创建人ID',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modifyer` bigint(12) NULL COMMENT '修改人ID',
`modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`),
KEY `idx_xx_jlid_del`(`encourage_id`, `school_code`, `is_deleted`) COMMENT '激励体系奖状关系表索引'
) ENGINE=InnoDB COMMENT='激励体系奖状关系表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_encourage_award_underlay` (
`id` bigint(20) NOT NULL COMMENT 'ID',
`name` varchar(50) NOT NULL COMMENT '底图名称',
`user_id` varchar(40) NULL COMMENT '所属用户',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`url` text NOT NULL COMMENT '上传的图片地址',
`is_deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除（0:未删除,1:已删除）',
`creator` bigint(12) NULL DEFAULT 0 COMMENT '创建人ID',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modifyer` bigint(12) NULL COMMENT '修改人ID',
`modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT='激励体系奖状我的底图表';
CREATE INDEX `idx_school_student_class` ON `ty_evaluation_jhwch`.`pj_encourage_result`(`school_code`, `student_id`, `class_code`);
CREATE TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_1` (
`id` bigint(20) NOT NULL auto_increment COMMENT '关系表主键ID',
`evaluation_id` bigint(20) NULL COMMENT '评价项编号',
`addition_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '权益主键',
`addition_name` varchar(20) NULL COMMENT '权益名称',
`addition_type` tinyint(4) NULL COMMENT '1权益 2惩罚',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除 1.删除 0.正常',
`create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP COMMENT '更新时间',
`create_user` varchar(36) NULL COMMENT '创建人',
`during_type` tinyint(4) NULL COMMENT '持续单位 1日 2周 4月 5学期',
`during` int(255) NULL COMMENT '持续时间',
`reward` decimal(10,2) NULL DEFAULT 0.00 COMMENT '奖惩值',
`offset_object` varchar(256) NULL COMMENT '抵消关联项',
`offset_type` tinyint(4) NULL DEFAULT 0 COMMENT '抵消枚举类型',
PRIMARY KEY (`id`),
KEY `idx_school_evaluation`(`school_code`, `evaluation_id`)
) ENGINE=InnoDB row_format=COMPACT COMMENT='评价项权益信息';
INSERT INTO `ty_evaluation_jhwch`.`RG_TEMP_1046981153_1`(`id`,`evaluation_id`,`addition_id`,`addition_name`,`addition_type`,`school_code`,`is_deleted`,`create_time`,`update_time`,`create_user`,`during_type`,`during`,`reward`,`offset_object`,`offset_type`) SELECT `id`,`evaluation_id`,`addition_id`,`addition_name`,`addition_type`,`school_code`,`is_deleted`,`create_time`,`update_time`,`create_user`,`during_type`,`during`,`reward`,`offset_object`,`offset_type` FROM `ty_evaluation_jhwch`.`pj_evaluation_addition`;
DROP TABLE `ty_evaluation_jhwch`.`pj_evaluation_addition`;
ALTER TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_1` RENAME TO `pj_evaluation_addition`;
CREATE TABLE `ty_evaluation_jhwch`.`pj_encourage_result_new` (
`id` bigint(20) NOT NULL COMMENT 'ID',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`school_year` varchar(20) NOT NULL COMMENT '学年',
`term` varchar(20) NOT NULL COMMENT '学期',
`grade_code` varchar(40) NULL COMMENT '年级代码',
`class_code` varchar(40) NULL COMMENT '班级代码',
`student_id` varchar(36) NOT NULL COMMENT '学生id',
`rule_item_id` bigint(20) NOT NULL COMMENT '评价体系ID（关联 pj_v2_rule_item 表的ID）',
`encourage_system_id` bigint(20) NOT NULL COMMENT '激励体系ID（关联 pj_encourage_system 表的ID）',
`encourage_item_id` bigint(20) NOT NULL COMMENT '激励项ID（关联 pj_encourage_item 表的ID）',
`condition_limit` tinyint(2) NULL DEFAULT 1 COMMENT '获得条件限定（1:全部达成,2:任意一项达成）',
`condition_amount` bigint(20) NOT NULL COMMENT '本次激励结果满足的条件数量',
`amount` bigint(20) NOT NULL COMMENT '本次激励结果激励项获得的数量',
`is_deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除（0:未删除,1:已删除）',
`creator` bigint(12) NULL DEFAULT 0 COMMENT '创建人ID',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modifyer` bigint(12) NULL COMMENT '修改人ID',
`modify_time` timestamp NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
KEY `idx_full`(`school_code`, `school_year`, `term`, `grade_code`, `class_code`, `student_id`, `encourage_item_id`, `is_deleted`) COMMENT '激励结果索引',
KEY `idx_item_id`(`school_code`, `encourage_system_id`, `encourage_item_id`, `student_id`, `is_deleted`) COMMENT '激励结果索引',
KEY `idx_pj_encourage_result_student_code`(`school_code`, `school_year`, `term`, `student_id`, `encourage_system_id`),
KEY `idx_school_student_class`(`school_code`, `student_id`, `class_code`)
) ENGINE=InnoDB COMMENT='激励结果记录表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_evaluation_done_rate` (
`id` bigint(20) NOT NULL COMMENT 'id',
`evaluation_id` bigint(20) NOT NULL COMMENT '活动主键',
`rate` decimal(10,2) NULL DEFAULT 0.00 COMMENT '完成率',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除 1.删除 0.正常',
`create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP COMMENT '更新时间',
UNIQUE KEY `pj_evaluation_done_rate_pk`(`evaluation_id`,`school_code`),
PRIMARY KEY (`id`),
KEY `idx_school_task`(`school_code`, `evaluation_id`)
) ENGINE=InnoDB COMMENT='评价项任务完成率';
CREATE TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_2` (
`id` bigint(20) NOT NULL,
`evaluation_id` bigint(20) NOT NULL COMMENT '评价项ID',
`moral` tinyint(4) NOT NULL COMMENT '德育类别',
`add_time` datetime NULL DEFAULT 'CURRENT_TIMESTAMP',
PRIMARY KEY (`id`),
KEY `index_evaluation_moral`(`evaluation_id`, `moral`)
) ENGINE=InnoDB row_format=COMPACT COMMENT='评价项德育类别关系表';
INSERT INTO `ty_evaluation_jhwch`.`RG_TEMP_1046981153_2`(`id`,`evaluation_id`,`moral`,`add_time`) SELECT `id`,`evaluation_id`,`moral`,NULL FROM `ty_evaluation_jhwch`.`pj_evaluation_moral`;
DROP TABLE `ty_evaluation_jhwch`.`pj_evaluation_moral`;
ALTER TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_2` RENAME TO `pj_evaluation_moral`;
CREATE TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_3` (
`id` bigint(20) NOT NULL COMMENT '主键id',
`personal_evaluation_id` bigint(20) NULL COMMENT '个人评价项id',
`class_standard_evaluation_id` bigint(20) NULL COMMENT '班标点评项编号',
`class_evaluation_id` bigint(20) NULL COMMENT '班级评价项id',
`school_code` varchar(20) NOT NULL COMMENT '学校代码',
`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除 1.删除 0.正常',
`create_time` datetime NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '创建时间',
`update_time` datetime NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '更新时间',
`create_user` varchar(36) NULL COMMENT '创建人',
PRIMARY KEY (`id`),
KEY `idx_school_class_stand`(`class_standard_evaluation_id`, `school_code`),
KEY `idx_school_xb`(`personal_evaluation_id`, `school_code`)
) ENGINE=InnoDB row_format=COMPACT;
INSERT INTO `ty_evaluation_jhwch`.`RG_TEMP_1046981153_3`(`id`,`personal_evaluation_id`,`class_standard_evaluation_id`,`class_evaluation_id`,`school_code`,`is_deleted`,`create_time`,`update_time`,`create_user`) SELECT `id`,`personal_evaluation_id`,`class_standard_evaluation_id`,`class_evaluation_id`,`school_code`,`is_deleted`,`create_time`,`update_time`,`create_user` FROM `ty_evaluation_jhwch`.`pj_evaluation_relation`;
DROP TABLE `ty_evaluation_jhwch`.`pj_evaluation_relation`;
ALTER TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_3` RENAME TO `pj_evaluation_relation`;
CREATE TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_4` (
`id` bigint(20) NOT NULL COMMENT 'id',
`school_code` varchar(32) NULL COMMENT '学校代码',
`group_id` bigint(20) NULL COMMENT '组别id',
`object_id` bigint(20) NULL COMMENT '关联id,点评项id',
`is_deleted` char(1) NULL DEFAULT '0' COMMENT '是否删除1删除，0未删除',
`create_time` datetime NULL COMMENT '创建时间',
`update_time` datetime NULL COMMENT '修改时间',
`group_type_id` bigint(20) NULL COMMENT '组别类型id',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_pj_evaluation_student_group_dianping`(`object_id`,`group_id`)
) ENGINE=InnoDB row_format=COMPACT;
INSERT INTO `ty_evaluation_jhwch`.`RG_TEMP_1046981153_4`(`id`,`school_code`,`group_id`,`object_id`,`is_deleted`,`create_time`,`update_time`,`group_type_id`) SELECT `id`,`school_code`,`group_id`,`object_id`,`is_deleted`,`create_time`,`update_time`,`group_type_id` FROM `ty_evaluation_jhwch`.`pj_evaluation_student_group_dianping`;
DROP TABLE `ty_evaluation_jhwch`.`pj_evaluation_student_group_dianping`;
ALTER TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_4` RENAME TO `pj_evaluation_student_group_dianping`;
CREATE TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_5` (
`id` bigint(20) NOT NULL,
`group_id` bigint(20) NULL COMMENT '组别id',
`school_code` varchar(16) NULL COMMENT '学校代码',
`teacher_id` varchar(64) NULL COMMENT '教师id',
`is_deleted` char(1) NULL DEFAULT '0' COMMENT '是否删除0未删除，1已删除',
`create_time` datetime NULL COMMENT '创建时间',
`update_time` datetime NULL COMMENT '最后修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_pj_evaluation_student_group_teacher`(`teacher_id`,`group_id`) COMMENT 'teacher约束',
KEY `idx_school_group_user`(`school_code`, `group_id`, `teacher_id`)
) ENGINE=InnoDB row_format=COMPACT;
INSERT INTO `ty_evaluation_jhwch`.`RG_TEMP_1046981153_5`(`id`,`group_id`,`school_code`,`teacher_id`,`is_deleted`,`create_time`,`update_time`) SELECT `id`,`group_id`,`school_code`,`teacher_id`,`is_deleted`,`create_time`,`update_time` FROM `ty_evaluation_jhwch`.`pj_evaluation_student_group_teacher`;
DROP TABLE `ty_evaluation_jhwch`.`pj_evaluation_student_group_teacher`;
ALTER TABLE `ty_evaluation_jhwch`.`RG_TEMP_1046981153_5` RENAME TO `pj_evaluation_student_group_teacher`;
ALTER TABLE `ty_evaluation_jhwch`.`pj_evaluation_download_task`
MODIFY COLUMN `file_path` varchar(512) NULL COMMENT '文件存储路径'
, MODIFY COLUMN `file_url` varchar(768) NULL COMMENT '文件访问url';
CREATE INDEX `idx_evaluation_record_id` ON `ty_evaluation_jhwch`.`pj_evaluation_extra_number`(`evaluation_record_id`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_evaluation_item`
MODIFY COLUMN `class_code` varchar(2000) NULL COMMENT '班级代码'
, MODIFY COLUMN `tag_type` tinyint(4) NULL DEFAULT 0 COMMENT '上行归类-240520,1-课堂表现;2作业表现;0-其他'
, MODIFY COLUMN `school_year` varchar(24) NULL COMMENT '记录所属学年'
, MODIFY COLUMN `school_term` varchar(8) NULL COMMENT '记录所属学期';
CREATE INDEX `idx_school_scope` ON `ty_evaluation_jhwch`.`pj_evaluation_item`(`school_code`, `scope`, `create_time`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_evaluation_item_category`
MODIFY COLUMN `school_year` varchar(20) NULL COMMENT '所属学年'
, MODIFY COLUMN `term` varchar(20) NULL COMMENT '所属学期';
DROP INDEX `i_school_role` ON `ty_evaluation_jhwch`.`pj_evaluation_item_jurisdiction`;
CREATE INDEX `i_school_role` ON `ty_evaluation_jhwch`.`pj_evaluation_item_jurisdiction`(`school_code`, `is_deleted`, `type`, `jurisdiction_id`);
CREATE INDEX `idx_school_sub` ON `ty_evaluation_jhwch`.`pj_evaluation_item_jurisdiction`(`school_code`, `subject_id`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_evaluation_qr_record`
MODIFY COLUMN `teacher_name` varchar(36) NULL DEFAULT '学校' COMMENT '教职工姓名';
ALTER TABLE `ty_evaluation_jhwch`.`pj_evaluation_qr_record` ADD UNIQUE KEY `uinx_qrid_jzg_num`(`qr_id`,`teacher_name`,`qr_num`) COMMENT '约束-防止重复兑换';
CREATE INDEX `idx_school_stu_ac_them` ON `ty_evaluation_jhwch`.`pj_evaluation_stamper_user_record`(`school_code`, `stu_code`, `activity_id`, `theme_activity_id`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_evaluation_student_group`
MODIFY COLUMN `ver` tinyint(4) NULL DEFAULT 2 COMMENT '版本默认为1'
, MODIFY COLUMN `group_code` varchar(20) NULL COMMENT '团体编号';
CREATE INDEX `pj_evaluation_student_group_group_type_school_code_index` ON `ty_evaluation_jhwch`.`pj_evaluation_student_group`(`group_type`, `school_code`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_goods`
ADD COLUMN `version` int(11) NULL DEFAULT '0'
, ADD COLUMN `max_stock` int(11) NOT NULL DEFAULT '0' COMMENT 'shou''do';
CREATE INDEX `ix_no_school` ON `ty_evaluation_jhwch`.`pj_goods_order`(`order_no`, `school_code`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_growth_complete`
ADD COLUMN `xn` varchar(20) NULL COMMENT '学年'
, ADD COLUMN `xq` varchar(10) NULL COMMENT '01 上学期 02下学期';
ALTER TABLE `ty_evaluation_jhwch`.`pj_growth_template`
MODIFY COLUMN `alias_name` text NULL COMMENT '别名数据 json';
ALTER TABLE `ty_evaluation_jhwch`.`pj_growth_template_page_result`
MODIFY COLUMN `column_value` int(4) NULL COMMENT '格子所填值';
DROP INDEX `pj_growth_template_page_result_school_code_IDX` ON `ty_evaluation_jhwch`.`pj_growth_template_page_result`;
CREATE INDEX `pj_growth_template_page_result_school_code_IDX` ON `ty_evaluation_jhwch`.`pj_growth_template_page_result`(`is_deleted`, `grade_code`, `module_id`, `school_code`);
DROP INDEX `pj_growth_template_page_result_template_id_IDX` ON `ty_evaluation_jhwch`.`pj_growth_template_page_result`;
CREATE INDEX `pj_growth_template_page_result_template_id_IDX` ON `ty_evaluation_jhwch`.`pj_growth_template_page_result`(`is_deleted`, `template_page_id`, `module_id`, `column_id`, `template_id`);
CREATE INDEX `index_1` ON `ty_evaluation_jhwch`.`pj_growth_template_page_result`(`is_deleted`, `template_id`, `column_id`, `template_page_id`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_ioc_school`
ADD COLUMN `face_update_time` datetime NULL COMMENT '上次同步人脸时间'
, ADD COLUMN `create_time` datetime NULL DEFAULT 'CURRENT_TIMESTAMP'
, ADD COLUMN `update_time` datetime NULL DEFAULT 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP;
CREATE INDEX `idx_school_medium` ON `ty_evaluation_jhwch`.`pj_medium_dimension_relation`(`school_code`, `medium_id`);
CREATE INDEX `idx_time_uty_nstatus` ON `ty_evaluation_jhwch`.`pj_notification`(`start_time`, `end_time`, `user_type`, `notice_status`);
CREATE INDEX `idx_role_school` ON `ty_evaluation_jhwch`.`pj_role_student_group_permission`(`role_id`, `school_code`);
CREATE TABLE `ty_evaluation_jhwch`.`pj_self_report_honor` (
`id` bigint(20) NOT NULL auto_increment,
`honor_name` varchar(16) NULL COMMENT '特长荣誉名称',
`honor_config` text NULL COMMENT '特长荣誉获得条件 json 字段 {
"compareType":"gt",
"range":"total",
"value":"5"
}',
`create_by` bigint(20) NULL COMMENT '创建人id',
`update_by` bigint(20) NULL COMMENT '更新人id',
`create_time` timestamp NULL,
`update_time` timestamp NULL,
`deleted` smallint(1) NULL DEFAULT 0 COMMENT '删除标识 1-已删除 0-未删除',
`school_code` varchar(255) NULL COMMENT '学校代码',
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT='申报方案表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_self_report_honor_record` (
`id` bigint(20) NOT NULL auto_increment,
`student_name` varchar(255) NOT NULL COMMENT '学生姓名',
`student_id` bigint(20) NOT NULL COMMENT '学生id',
`class_name` varchar(255) NULL COMMENT '班级名称',
`class_id` varchar(128) NOT NULL COMMENT '班级id',
`grade_name` varchar(255) NULL COMMENT '年级名称',
`grade_id` varchar(128) NULL COMMENT '年级id',
`plan_id` bigint(20) NULL COMMENT '奖励方案id',
`school_code` varchar(255) NOT NULL COMMENT '学校代码',
`xn` varchar(55) NOT NULL COMMENT '学年',
`xq` varchar(55) NOT NULL COMMENT '学期',
`honor_name` varchar(50) NOT NULL COMMENT '荣誉名称',
`honor_id` bigint(20) NOT NULL COMMENT '荣誉id',
`create_time` timestamp NULL,
`update_time` timestamp NULL,
`create_by` bigint(20) NULL,
`update_by` bigint(20) NULL,
`deleted` smallint(1) NULL DEFAULT 0 COMMENT '删除标识 1-已删除 0-未删除',
PRIMARY KEY (`id`),
KEY `index_xn_stu`(`xn`, `xq`, `student_id`)
) ENGINE=InnoDB COMMENT='申报荣誉获得记录表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_self_report_plan_rule` (
`id` bigint(20) NOT NULL auto_increment,
`reward_name` varchar(16) NOT NULL COMMENT '奖励名称',
`reward_value` decimal(10,2) NOT NULL COMMENT '奖励值',
`sort` int(4) NULL DEFAULT '1' COMMENT '排序字段',
`plan_id` bigint(20) NOT NULL COMMENT '所属方案id',
`school_code` varchar(255) NULL COMMENT '学校代码',
`create_by` bigint(20) NULL COMMENT '创建人',
`update_by` bigint(20) NULL COMMENT '修改人',
`create_time` timestamp NULL,
`update_time` timestamp NULL,
`deleted` smallint(1) NULL DEFAULT 0 COMMENT '删除标识',
PRIMARY KEY (`id`),
KEY `index_plan`(`plan_id`)
) ENGINE=InnoDB COMMENT='申报奖励方案规则表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_self_report_record` (
`id` bigint(20) NOT NULL auto_increment,
`student_id` varchar(50) NULL COMMENT '学生id',
`student_name` varchar(255) NULL COMMENT '学生姓名',
`class_name` varchar(255) NULL COMMENT '班级名称',
`class_id` varchar(50) NULL COMMENT '班级id',
`grade_name` varchar(255) NULL COMMENT '年级名称',
`grade_id` bigint(20) NULL COMMENT '年级id',
`grade_code` varchar(20) NULL COMMENT '年级编码',
`dimension_id` bigint(20) NULL COMMENT '维度id ',
`dimension_desc` varchar(255) NULL COMMENT '维度描述',
`status` smallint(1) NULL DEFAULT 1 COMMENT '状态 1-未审核 2-已审核通过 3-已打回',
`report_column_info` text NULL COMMENT '申报填写栏目信息 json ',
`report_content` text NULL COMMENT '申报填写内容',
`image_urls` text NULL COMMENT '图片地址 多个以，分开',
`task_id` bigint(20) NULL COMMENT '任务id',
`school_code` varchar(255) NULL COMMENT '学校代码',
`create_by` bigint(20) NULL,
`update_by` bigint(20) NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL on update CURRENT_TIMESTAMP,
`deleted` smallint(1) NULL DEFAULT 0,
`plan_id` bigint(20) NULL COMMENT '方案id',
`plan_name` varchar(255) NULL COMMENT '方案名称',
`rule_id` bigint(20) NULL COMMENT '方案规则id',
`rule_name` varchar(255) NULL COMMENT '方案规则名称',
`reward_value` decimal(10,2) NULL COMMENT '奖励值',
`evaluation_record_id` bigint(20) NULL COMMENT '关联综评记录id',
`gain_level` int(11) NULL COMMENT '成果水平',
`process_level` int(11) NULL COMMENT '过程表现',
`course_id` varchar(512) NULL COMMENT '关联课程',
PRIMARY KEY (`id`),
KEY `index_task`(`status`, `task_id`)
) ENGINE=InnoDB;
CREATE TABLE `ty_evaluation_jhwch`.`pj_self_report_reward_plan` (
`id` bigint(20) NOT NULL auto_increment,
`plan_name` varchar(16) NOT NULL COMMENT '奖励方案名称',
`sort` int(2) NOT NULL COMMENT '排序字段',
`in_system` smallint(1) NULL DEFAULT 0 COMMENT '1-系统类别 0-自定义类别',
`create_by` bigint(20) NULL COMMENT '创建人id',
`update_by` bigint(20) NULL COMMENT '更新人id',
`create_time` timestamp NULL,
`update_time` timestamp NULL,
`deleted` smallint(1) NULL DEFAULT 0 COMMENT '删除标识 1-已删除 0-未删除',
`school_code` varchar(128) NOT NULL COMMENT '学校代码',
`honor_ids` varchar(255) NULL COMMENT '荣誉id数据 多个以，分开',
PRIMARY KEY (`id`),
KEY `index_school`(`school_code`, `sort`)
) ENGINE=InnoDB COMMENT='申报方案表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_self_report_task` (
`id` bigint(20) NOT NULL auto_increment,
`task_name` varchar(32) NOT NULL COMMENT '任务名称',
`task_remark` text NULL COMMENT '任务描述 富文本框',
`publish_object_type` int(2) NOT NULL DEFAULT '1' COMMENT '发布对象类别 1-全校 2-班级',
`publish_object_value` text NULL COMMENT '班级id 多个以,分开',
`dimension_ids` text NULL COMMENT '发布维度id 多个以,分开',
`plan_id` bigint(20) NOT NULL COMMENT '方案id',
`plan_name` varchar(255) NULL COMMENT '方案名称',
`start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '任务开始时间',
`end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '任务结束时间',
`frequency` int(2) NULL DEFAULT '0' COMMENT '提交频次 默认为0 为0时表示无限制',
`submission_method` varchar(64) NULL DEFAULT '2' COMMENT '指定提交方式。1-无限制 2-图片 多个以,隔开',
`audit_teacher_ids` text NULL COMMENT '审核老师 id 多个以,隔开 默认班主任角色可以审核本班',
`school_code` varchar(128) NOT NULL COMMENT '学校代码',
`create_by` bigint(20) NULL,
`update_by` datetime NULL,
`create_time` timestamp NULL,
`update_time` timestamp NULL,
`deleted` smallint(1) NULL DEFAULT 0,
`report_num` int(8) NULL DEFAULT '0' COMMENT '申报数',
`review_num` int(8) NULL DEFAULT '0' COMMENT '审核数',
`version` int(8) NULL DEFAULT '1' COMMENT '版本号',
`create_name` varchar(64) NULL COMMENT '创建人',
`dimension_desc` text NULL COMMENT '维度信息描述值',
`publish_object_desc` text NULL COMMENT '发布对象文本描述值',
`xn` varchar(50) NOT NULL,
`xq` varchar(50) NOT NULL,
`evaluation_item_id` bigint(20) NULL COMMENT '关联综评的活动id',
`course_id` text NULL COMMENT '课程主键',
`course_name` text NULL COMMENT '课程名称',
`gain_level` tinyint(4) NULL DEFAULT 0 COMMENT '成果水平 0无 1ABC 2ABCD 3三星 4五星 5优良合 6优良合待',
`process_level` tinyint(4) NULL DEFAULT 0 COMMENT '过程表现 0无 1ABC 2ABCD 3三星 4五星 5优良合 6优良合待',
`type` int(11) NULL DEFAULT '1' COMMENT '1 默认 自主申报 2特长申报',
`head_teacher_audit` int(11) NOT NULL DEFAULT '1' COMMENT '班主任能否审核 1是 0否',
PRIMARY KEY (`id`),
KEY `index_school`(`start_time`, `end_time`, `school_code`)
) ENGINE=InnoDB COMMENT='申报任务 表';
CREATE TABLE `ty_evaluation_jhwch`.`pj_self_report_task_column` (
`id` bigint(20) NOT NULL auto_increment,
`column_name` varchar(255) NULL COMMENT '任务填写栏目名称',
`task_id` bigint(20) NULL COMMENT '申报任务id',
`column_length` int(4) NULL DEFAULT '30' COMMENT '申报填写内容 长度限制',
`column_type` int(2) NULL DEFAULT '1' COMMENT '申报填写内容栏目类型 1-input 2-radio',
`school_code` varchar(255) NULL COMMENT '学校代码',
`create_by` bigint(20) NULL,
`update_by` bigint(20) NULL,
`create_time` timestamp NULL,
`update_time` timestamp NULL,
`deleted` smallint(1) NULL DEFAULT 0,
`column_option` text NULL COMMENT '选项',
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT='申报任务填写栏目表';
CREATE INDEX `idx_usercode_school` ON `ty_evaluation_jhwch`.`pj_user_role`(`user_id`, `school_code`);
ALTER TABLE `ty_evaluation_jhwch`.`pj_user_status`
MODIFY COLUMN `copy_medal_num` decimal(10,2) NULL DEFAULT 0.00 COMMENT '副本可用一级勋章数量';
CREATE INDEX `idx_school` ON `ty_evaluation_jhwch`.`pj_v2_medium`(`school_code`);
DROP INDEX `rule_id` ON `ty_evaluation_jhwch`.`pj_v2_rule_dimension`;
CREATE INDEX `rule_id` ON `ty_evaluation_jhwch`.`pj_v2_rule_dimension`(`rule_id`, `is_delete`, `id`);
CREATE INDEX `idx_plan_pids` ON `ty_evaluation_jhwch`.`pj_v2_rule_dimension`(`rule_id`, `pids`);
CREATE INDEX `idx_rule_pid` ON `ty_evaluation_jhwch`.`pj_v2_rule_dimension`(`rule_id`, `parent_id`);
CREATE INDEX `pj_v2_rule_dimension_rule_id_index` ON `ty_evaluation_jhwch`.`pj_v2_rule_dimension`(`rule_id`);
CREATE INDEX `idx_week_teacher` ON `ty_evaluation_jhwch`.`pj_week_teacher`(`week_id`, `teacher_id`);
SET FOREIGN_KEY_CHECKS=@ORIGINAL_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@ORIGINAL_UNIQUE_CHECKS;
SET SQL_MODE=@ORIGINAL_SQL_MODE;ALTER TABLE `ty_admin_jhwch`.`jc_bjsj`
ADD COLUMN `banji` int(11) NULL COMMENT '年级下的班级号';
ALTER TABLE `ty_admin_jhwch`.`jc_rykp`
MODIFY COLUMN `kh` varchar(50) NULL COMMENT '卡号'
, ADD COLUMN `id` int(11) NOT NULL auto_increment;
ALTER TABLE `ty_admin_jhwch`.`jc_rykp` DROP PRIMARY KEY;
ALTER TABLE `ty_admin_jhwch`.`jc_rykp` ADD PRIMARY KEY (`id`);
CREATE INDEX `idx_yh_xx` ON `ty_admin_jhwch`.`jc_rykp`(`rybh`, `xxdm`);
ALTER TABLE `ty_admin_jhwch`.`jc_xsjbsj`
ADD COLUMN `bnzw` varchar(500) NULL DEFAULT '' COMMENT '班内职务'
, ADD COLUMN `jmsfzjh` varchar(60) NULL COMMENT '加密身份证件号';
CREATE INDEX `ix_xsjbsj_username` ON `ty_admin_jhwch`.`jc_xsjbsj`(`username`, `cjsj`, `scbs`);
ALTER TABLE `ty_admin_jhwch`.`jc_xxjbsj`
MODIFY COLUMN `jyj_id` varchar(128) NULL COMMENT '教育局id'''
, MODIFY COLUMN `xxbsm` varchar(100) NULL COMMENT '学校标识码，指由教育部按照国家标准及编码规则编制，赋予每个学校（机构）在全国范围内唯一的、始终不变的识别标识码'
, MODIFY COLUMN `sfsxsj` int(2) NULL DEFAULT '0' COMMENT '是否上行数据（1:是，0:否）'
, MODIFY COLUMN `sxsjpt` varchar(100) NULL COMMENT '数据上行平台编码（参见，数据上行平台信息表）'
, ADD COLUMN `tyshxydm` varchar(120) NULL COMMENT '统一社会信用代码';
CREATE INDEX `idx_xxbsm` ON `ty_admin_jhwch`.`jc_xxjbsj`(`xxbsm`);
镜像版本：
- ace-auth: aiban-docker.pkg.coding.net/smart-oa/docker/ace-auth-server:v2.9.18.5-jhwc √
- OA用户信息管理(tianyin-ace-admin-deploy): aiban-docker.pkg.coding.net/smart-oa/docker/ace-admin:v2.9.19.8-jhwc √
- 综合评价服务(tianyin-evaluation-base-deploy) aiban-docker.pkg.coding.net/evaluation/docker/tianyin-evaluation-base:wcq-250306 √
- 综合评价-定时任务服务(tianyin-evaluation-job-deploy) aiban-docker.pkg.coding.net/evaluation/docker/tianyin-evaluation-job:v2.11.7-jhwc √
- 综合评价-激励体系服务(tianyin-evaluation-encourage-deploy) aiban-docker.pkg.coding.net/evaluation/docker/tianyin-evaluation-encourage:v2.11.0.7-jhwc √
- 智慧校园-服务网关（tianyin-smart-gateway-deploy） aiban-docker.pkg.coding.net/smart-oa/docker/tianyin-smart-gateway:v2.11.4.4-jhwc √
- 综合评价-统计分析服务（tianyin-evaluation-statistics-deploy） aiban-docker.pkg.coding.net/evaluation/docker/tianyin-evaluation-statistics:v2.9.49_jhwch √
- 综合评价服务点评中心服务(tianyin-evaluation-evaluate-deploy) aiban-docker.pkg.coding.net/evaluation/docker/tianyin-evaluation-evaluate:wcq-250306 √
- 综合评价-开放接口服务(tianyin-evaluation-openapi-deploy) aiban-docker.pkg.coding.net/evaluation/docker/tianyin-evaluation-openapi:v1.1.2_jhwch √
- OA基础数据服务(tianyin-smart-base-deploy) aiban-docker.pkg.coding.net/smart-oa/docker/smart-base:wcq-250306 √
- OA用户认证服务（tianyin-ace-auth-server-deploy）aiban-docker.pkg.coding.net/smart-oa/docker/ace-auth-server:v2.9.18.5-jhwc √
- 综合评价-活动服务 （tianyin-evaluation-activity-deploy ）aiban-docker.pkg.coding.net/evaluation/docker/tianyin-evaluation-activity:v2.12.1-jhwc √
作者：杭州天音 创建时间：2025-03-10 14:18
最后编辑：杭州天音 更新时间：2025-06-09 11:42
最后编辑：杭州天音 更新时间：2025-06-09 11:42
