alter table jetplasma_eco
    add child_type varchar(200) null comment '变更种类' after item_type;

INSERT INTO jetplasma.flow_definition (id, flow_code, flow_name, version, is_publish, from_custom, from_path, create_time, update_time, del_flag, tenant_id) VALUES (9, 'Flow-009', 'DEMO执行审核', '1.0.0', 0, 'N', null, '2024-05-27 16:50:01', '2024-07-15 12:38:14', null, null);
INSERT INTO jetplasma.flow_definition (id, flow_code, flow_name, version, is_publish, from_custom, from_path, create_time, update_time, del_flag, tenant_id) VALUES (10, 'Flow-010', 'DEMO执行进展审核', '1.0.0', 0, 'N', null, '2024-05-27 16:50:01', '2024-07-15 17:04:38', null, null);

alter table jetplasma_demo_execute
    add approve_status int(1) null comment '审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过' after attachment;

drop view if exists jetplasma_demo_execute_view;
create view jetplasma_demo_execute_view as
select e.*, d.customer, d.device_type, d.saler, d.requirements from jetplasma_demo d, jetplasma_demo_execute e where d.id = e.demo_id;

update jetplasma_demo_execute set approve_status = 1;

alter table jetplasma_demo_execute_progress
    add approve_status int(1) null comment '审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过' after report;