upgrade20240717.sql 1.3 KB

1234567891011121314151617
  1. alter table jetplasma_eco
  2. add child_type varchar(200) null comment '变更种类' after item_type;
  3. 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);
  4. 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);
  5. alter table jetplasma_demo_execute
  6. add approve_status int(1) null comment '审核状态:1 - 创建, 2 - 审核中 3 - 已审核, 4 - 审核未通过' after attachment;
  7. drop view if exists jetplasma_demo_execute_view;
  8. create view jetplasma_demo_execute_view as
  9. 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;
  10. update jetplasma_demo_execute set approve_status = 1;
  11. alter table jetplasma_demo_execute_progress
  12. add approve_status int(1) null comment '审核状态:1 - 创建, 2 - 审核中 3 - 已审核, 4 - 审核未通过' after report;