1234567891011121314151617181920212223242526272829303132333435 |
- 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;
|