upgrade_20250109.sql 2.2 KB

1234567891011121314151617181920212223242526272829303132333435
  1. alter table jetplasma_alteration_apply
  2. add to_eco varchar(1) null comment '是否已转ECO Y - 是,N - 否' after attachment;
  3. alter table jetplasma_alteration_apply
  4. add to_ecn varchar(1) null comment '是否已转ECN Y - 是,N - 否' after to_eco;
  5. update jetplasma_alteration_apply set to_eco='Y' where id in (select alteration_id from jetplasma_eco);
  6. update jetplasma_alteration_apply set to_eco='N' where id not in (select alteration_id from jetplasma_eco);
  7. update jetplasma_alteration_apply set to_ecn='Y' where id in (select alteration_id from jetplasma_ecn);
  8. update jetplasma_alteration_apply set to_ecn='N' where to_ecn is null;
  9. alter table jetplasma_eco
  10. add to_ecn varchar(1) null comment '已转ECN Y - 是,N - 否' after confirm;
  11. update jetplasma_eco set to_ecn='Y' where id in (select eco_id from jetplasma_ecn);
  12. update jetplasma_eco set to_ecn='N' where id not in (select eco_id from jetplasma_ecn);
  13. drop view if exists jetplasma_eco_view;
  14. CREATE VIEW jetplasma_eco_view AS
  15. select e.*, jaa.apply_user, jaa.apply_depart from jetplasma_eco e left join jetplasma_alteration_apply jaa on e.alteration_id = jaa.id;
  16. create table jetplasma_record_modify_hist (
  17. `id` bigint(20) not null auto_increment primary key comment '主键ID',
  18. `approve_id` bigint(20) not null comment '审批编号',
  19. `approve_type` varchar(40) not null comment '审批类型',
  20. `business_id` bigint(20) not null comment '业务编号',
  21. `content` longtext not null comment '修改内容',
  22. `modify_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
  23. `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'
  24. ) engine=innodb comment = '表记录值修改记录';
  25. 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', '');
  26. alter table flow_definition
  27. add enable_update tinyint not null default 0 comment '是否允许审批表单, 1 - 是 , 0 - 否' after auto_pass;