53 lines
2.2 KiB
SQL
53 lines
2.2 KiB
SQL
-- =============================================
|
||
-- 2026-07-14 表字段变更增量脚本
|
||
-- 执行: mysql -u<user> -p<db> < increment-org-personnel-leader-flags-20260714.sql
|
||
-- =============================================
|
||
|
||
SET NAMES utf8mb4;
|
||
|
||
-- =============================================
|
||
-- org_personnel 表
|
||
-- =============================================
|
||
|
||
-- 1. 新增 技术负责人/过程控制负责人 标识字段
|
||
ALTER TABLE `org_personnel`
|
||
ADD COLUMN `technical_director_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否技术负责人(0否1是)' AFTER `proof_material_url`,
|
||
ADD COLUMN `process_control_leader_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否过程控制负责人(0否1是)' AFTER `technical_director_flag`;
|
||
|
||
-- 2. title_name → title_code
|
||
ALTER TABLE `org_personnel` CHANGE COLUMN `title_name` `title_code` varchar(50) DEFAULT NULL COMMENT '职称';
|
||
|
||
-- 3. 新增 基础学科专业id
|
||
ALTER TABLE `org_personnel`
|
||
ADD COLUMN `basic_discipline_major_id` bigint DEFAULT NULL COMMENT '基础学科专业id' AFTER `major`;
|
||
|
||
-- =============================================
|
||
-- qual_filing_personnel 表
|
||
-- =============================================
|
||
|
||
-- 4. title_name → title_code
|
||
ALTER TABLE `qual_filing_personnel` CHANGE COLUMN `title_name` `title_code` varchar(50) DEFAULT NULL COMMENT '职称';
|
||
|
||
-- =============================================
|
||
-- qual_filing_personnel_change 表
|
||
-- =============================================
|
||
|
||
-- 5. title_name → title_code（如表已存在）
|
||
ALTER TABLE `qual_filing_personnel_change` CHANGE COLUMN `title_name` `title_code` varchar(50) DEFAULT NULL COMMENT '职称';
|
||
|
||
-- =============================================
|
||
-- qual_filing 表
|
||
-- =============================================
|
||
|
||
-- 6. 新增 预警状态字段
|
||
ALTER TABLE `qual_filing`
|
||
ADD COLUMN `alert_status` varchar(50) DEFAULT NULL COMMENT '预警状态' AFTER `apply_type_name`;
|
||
|
||
-- =============================================
|
||
-- qual_filing_change 表
|
||
-- =============================================
|
||
|
||
-- 7. 新增 预警状态字段
|
||
ALTER TABLE `qual_filing_change`
|
||
ADD COLUMN `alert_status` varchar(50) DEFAULT NULL COMMENT '预警状态' AFTER `filing_status_name`;
|