- -- 为新库设置 WAIT 节点的 max_round
- UPDATE IGNORE company_workflow_lobster_node SET max_round=60 WHERE node_code='WAIT_DAILY' AND workflow_id=(SELECT id FROM company_workflow_lobster WHERE template_code='TRAVEL_TOP_SALES_001' AND del_flag=0 LIMIT 1);
- UPDATE IGNORE company_workflow_lobster_node SET max_round=120 WHERE node_code='WAIT_MONTHLY' AND workflow_id=(SELECT id FROM company_workflow_lobster WHERE template_code='TRAVEL_TOP_SALES_001' AND del_flag=0 LIMIT 1);
|