--流程库(如:approval-apass5-test)内置apaas流程:1应用申请流程2:云资源申请流程3:能力上下架审批4能力申请流程;5应用上下架审批 INSERT INTO "public"."process_info" ("process_id", "process_name", "process_desc", "process_type", "form_type", "form_id", "form_name", "form_version", "bpmn_xml", "is_released", "released_date", "version", "is_deleted", "created_by", "created_time", "updated_by", "updated_time", "category_id", "category_name", "item_type", "item_value", "cancel_at_will", "withdraw_at_will", "message_type", "message_retry_time", "remote_form_param", "org_id", "data_source", "free_cc", "opinion_required", "system_code" ) VALUES ('Process_202012190004', '应用上下架审批', NULL, 1, '1', NULL, NULL, NULL, ' Flow_1krb6fv Flow_1krb6fv Flow_1s2kck9 Flow_1s2kck9 Flow_0mk6c12 Flow_0mk6c12 Flow_19hu3up Flow_19hu3up ', 0, NULL, NULL, 0, 'admin', '2023-12-19 18:19:05.675663', NULL, NULL, 'bda2e235-e9ab-4358-89fa-6575fc85045f', 'aPaaS流程', '2', '1746af3c-059d-4870-b076-6e78c617a142', '1', '1', NULL, 0, '', '', '1', '1', '1', 'apaas'); INSERT INTO "public"."process_info" ("process_id", "process_name", "process_desc", "process_type", "form_type", "form_id", "form_name", "form_version", "bpmn_xml", "is_released", "released_date", "version", "is_deleted", "created_by", "created_time", "updated_by", "updated_time", "category_id", "category_name", "item_type", "item_value", "cancel_at_will", "withdraw_at_will", "message_type", "message_retry_time", "remote_form_param", "org_id", "data_source", "free_cc", "opinion_required", "system_code" ) VALUES ('Process_202012190005', '应用申请流程', NULL, 1, '1', NULL, NULL, NULL, ' Flow_1c80nlv Flow_1c80nlv Flow_0q4oeoo Flow_0q4oeoo Flow_1ias7d9 Flow_1ias7d9 Flow_0of72pv Flow_0of72pv ', 0, NULL, NULL, 0, 'admin', '2023-12-19 18:20:33.777883', NULL, NULL, 'bda2e235-e9ab-4358-89fa-6575fc85045f', 'aPaaS流程', '2', '1746af3c-059d-4870-b076-6e78c617a142', '1', '1', NULL, 0, '', '', '1', '1', '1', 'apaas'); INSERT INTO "public"."process_info" ("process_id", "process_name", "process_desc", "process_type", "form_type", "form_id", "form_name", "form_version", "bpmn_xml", "is_released", "released_date", "version", "is_deleted", "created_by", "created_time", "updated_by", "updated_time", "category_id", "category_name", "item_type", "item_value", "cancel_at_will", "withdraw_at_will", "message_type", "message_retry_time", "remote_form_param", "org_id", "data_source", "free_cc", "opinion_required", "system_code" ) VALUES ('Process_202012190006', '云资源申请流程', NULL, 1, '1', NULL, NULL, NULL, ' Flow_0tal1n8 Flow_0tal1n8 Flow_0sqi8ia Flow_0sqi8ia Flow_0nrfol5 Flow_0nrfol5 Flow_09zyv13 Flow_09zyv13 ', 0, NULL, NULL, 0, 'admin', '2023-12-19 18:23:16.940132', NULL, NULL, 'bda2e235-e9ab-4358-89fa-6575fc85045f', 'aPaaS流程', '2', '1746af3c-059d-4870-b076-6e78c617a142', '1', '1', NULL, 0, '', '', '1', '1', '1', 'apaas'); INSERT INTO "public"."process_info" ("process_id", "process_name", "process_desc", "process_type", "form_type", "form_id", "form_name", "form_version", "bpmn_xml", "is_released", "released_date", "version", "is_deleted", "created_by", "created_time", "updated_by", "updated_time", "category_id", "category_name", "item_type", "item_value", "cancel_at_will", "withdraw_at_will", "message_type", "message_retry_time", "remote_form_param", "org_id", "data_source", "free_cc", "opinion_required", "system_code" ) VALUES ('Process_202012190002', '能力上下架审批', NULL, 1, '1', NULL, NULL, NULL, ' Flow_0zlqs2t Flow_0zlqs2t Flow_1b5c0hy Flow_1b5c0hy Flow_0rqejsc Flow_0rqejsc Flow_0o74lql Flow_0o74lql ', 0, NULL, NULL, 0, 'admin', '2023-12-19 18:16:24.855316', NULL, NULL, 'bda2e235-e9ab-4358-89fa-6575fc85045f', 'aPaaS流程', '2', '1746af3c-059d-4870-b076-6e78c617a142', '1', '1', NULL, 0, '', '', '1', '1', '1', 'apaas'); INSERT INTO "public"."process_info" ("process_id", "process_name", "process_desc", "process_type", "form_type", "form_id", "form_name", "form_version", "bpmn_xml", "is_released", "released_date", "version", "is_deleted", "created_by", "created_time", "updated_by", "updated_time", "category_id", "category_name", "item_type", "item_value", "cancel_at_will", "withdraw_at_will", "message_type", "message_retry_time", "remote_form_param", "org_id", "data_source", "free_cc", "opinion_required", "system_code" ) VALUES ('Process_202012190003', '能力申请流程', NULL, 1, '1', NULL, NULL, NULL, ' Flow_0mm9ghj Flow_0mm9ghj Flow_1t4b47w Flow_1t4b47w Flow_10mqlyf Flow_10mqlyf Flow_1ypoyj3 Flow_1ypoyj3 ', 0, NULL, NULL, 0, 'admin', '2023-12-19 18:17:48.252655', NULL, NULL, 'bda2e235-e9ab-4358-89fa-6575fc85045f', 'aPaaS流程', '2', '2077e449-c3aa-43b4-aec4-c4a7188ac4b1,1746af3c-059d-4870-b076-6e78c617a142', '1', '1', NULL, 0, '', '', '1', '1', '1', 'apaas'); --process_node_item 流程节点信息录入 INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190002', 0, NULL, 'Activity_0kcbla0', 'userTask', 'operation', '3', '5', NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190002', 0, NULL, 'Activity_0tw704g', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190002', 0, NULL, 'Activity_0tw704g', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190002', 0, NULL, 'Activity_0uv9wi5', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190003', 0, NULL, 'Activity_0rm44je', 'userTask', 'operation', '3', '5', NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190004', 0, NULL, 'Activity_0xjvqpq', 'userTask', 'operation', '3', '5', NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190003', 0, NULL, 'Activity_0gq5d7u', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190003', 0, NULL, 'Activity_0gq5d7u', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190003', 0, NULL, 'Activity_18apocb', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190003', 0, NULL, 'Activity_18apocb', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190004', 0, NULL, 'Activity_19ahs3m', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190004', 0, NULL, 'Activity_19ahs3m', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190004', 0, NULL, 'Activity_18kanz8', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190004', 0, NULL, 'Activity_18kanz8', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190005', 0, NULL, 'Activity_161wjz4', 'userTask', 'operation', '3', '5', NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190005', 0, NULL, 'Activity_1mda02g', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190005', 0, NULL, 'Activity_1mda02g', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190005', 0, NULL, 'Activity_0f1ggjw', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190005', 0, NULL, 'Activity_0f1ggjw', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190006', 0, NULL, 'Activity_0z3nkgi', 'userTask', 'operation', '3', '5', NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190006', 0, NULL, 'Activity_1rbhl7t', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190006', 0, NULL, 'Activity_1rbhl7t', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190006', 0, NULL, 'Activity_12sad97', 'userTask', 'role', '2', 'a57bf411-524a-4385-b984-cf880963c434', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190006', 0, NULL, 'Activity_12sad97', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL); INSERT INTO process_node_item ("process_id", "is_released", "version", "element_id", "element_type", "item_name", "item_type", "item_value", "ext1", "ext2", "ext3", "is_deleted", "approve_type", "timeout", "time_unit", "expire_time", "auto_process_type", "submit_node", "message_type", "agree_name", "reject_name", "fullback_name", "transfer_name", "cc_name", "assign_name", "assign_element" ) VALUES ('Process_202012190002', 0, NULL, 'Activity_0uv9wi5', 'userTask', 'operation', '3', '1,2', NULL, NULL, NULL, 0, 1, 0, 12, NULL, '', NULL, '', '通过', '拒绝', '退回', '转办', '传阅', '指派', NULL);