Prodtrace/source_code/jetplasma-service/sql/online_sql/upgrade_20250109.sql

alter table jetplasma_alteration_apply
    add to_eco varchar(1) null comment '是否已转ECO Y - 是，N - 否' after attachment;

alter table jetplasma_alteration_apply
    add to_ecn varchar(1) null comment '是否已转ECN Y - 是，N - 否' after to_eco;

update jetplasma_alteration_apply set to_eco='Y' where id in (select alteration_id from jetplasma_eco);
update jetplasma_alteration_apply set to_eco='N' where id not in (select alteration_id from jetplasma_eco);

update jetplasma_alteration_apply set to_ecn='Y' where id in (select alteration_id from jetplasma_ecn);
update jetplasma_alteration_apply set to_ecn='N' where to_ecn is null;

alter table jetplasma_eco
    add to_ecn varchar(1) null comment '已转ECN Y - 是，N - 否' after confirm;

update jetplasma_eco set to_ecn='Y' where id in (select eco_id from jetplasma_ecn);
update jetplasma_eco set to_ecn='N' where id not in (select eco_id from jetplasma_ecn);

drop view if exists jetplasma_eco_view;
CREATE VIEW jetplasma_eco_view AS
select e.*, jaa.apply_user, jaa.apply_depart from jetplasma_eco e left join jetplasma_alteration_apply jaa on e.alteration_id = jaa.id;

create table jetplasma_record_modify_hist (
    `id`  bigint(20)      not null auto_increment primary key comment '主键ID',
    `approve_id` bigint(20) not null comment '审批编号',
    `approve_type` varchar(40) not null comment '审批类型',
    `business_id` bigint(20) not null comment '业务编号',
    `content` longtext not null comment '修改内容',
    `modify_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
    `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'
) engine=innodb comment = '表记录值修改记录';

INSERT INTO jetplasma.sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) VALUES ('审批修改日志', 2013, 4, 'change/log', 'flow/changeLog/index', '', 1, 0, 'C', '0', '0', 'jetplasma:change:log', 'message', 'admin', '2024-12-25 11:14:10', 'admin', '2024-12-25 11:15:58', '');
alter table flow_definition
    add enable_update tinyint not null default 0 comment '是否允许审批表单, 1 - 是 ， 0 - 否' after auto_pass;