/*对公包销单工作流预置数据1*/
-- ----------------------------

-- Records of t_wf_model

-- ----------------------------

  DELETE FROM t_wf_model WHERE fid='709140875434833920';

  INSERT INTO t_wf_model (FID, FVERSION, FMODIFYDATE, FPNGID, FTYPE, FOPERATION, FCREATEDATE, FNUMBER, FDEPLOYMENTID, FBPMNXMLID, FGRAPHID, FENTRABILL, FPARENTPROCID, FMODIFIERID, FORGUNITID, FCATEGORY, FCREATORID, FENTRABILLID, FPUBLISH) VALUES ('709140875434833920', ' ', {ts'2019-10-29 22:26:12'}, '0', 'AuditFlow', 'submit', {ts'2019-10-29 22:26:12'}, 'Proc_er_publicreimbursebill_audit_1', '0', '709140879083878400', '0', 'er_publicreimbursebill', '0', '1', '1', '404194390785943552', '1', '6B2CW570E+4', '0');



-- ----------------------------

-- Records of t_wf_model_l

-- ----------------------------

  DELETE FROM t_wf_model_l WHERE fpkid='0AV6W1I=+C+7';

  INSERT INTO t_wf_model_l (FID, FPKID, FLOCALEID, FDESCRIPTION, FNAME) VALUES ('709140875434833920', '0AV6W1I=+C+7', 'zh_CN', ' ', '对公报销单审批流程');



-- ----------------------------

-- Records of t_wf_proccate

-- ----------------------------

  DELETE FROM t_wf_proccate WHERE fid='404194390785943552';

  INSERT INTO t_wf_proccate (FID, FMODIFYDATE, FMODIFIER, FISLEAF, FCREATEDATE, FPARENTID, FCREATER, FAPPLICATIONID, FNUMBER) (SELECT '404194390785943552', {ts'2018-07-12 16:22:06'}, '1250', '1', {ts'2018-07-12 16:22:06'}, '330957102636178432', '1250', '10MYBGBYHXDU', 'EM' FROM DUAL WHERE NOT EXISTS (select 1 from t_wf_proccate where fapplicationid='10MYBGBYHXDU'));



-- ----------------------------

-- Records of t_wf_proccate_l

-- ----------------------------

  DELETE FROM t_wf_proccate_l WHERE fpkid='/8MEZL08SBAG';

  INSERT INTO t_wf_proccate_l (FID, FPKID, FLOCALEID, FDESCRIPTION, FNAME) (SELECT '404194390785943552', '/8MEZL08SBAG', 'zh_CN', '费用核算、商旅结算', '费用' FROM DUAL WHERE EXISTS (select 1 from t_wf_proccate where fid='404194390785943552'));



-- ----------------------------

-- Records of t_wf_proccate

-- ----------------------------

  DELETE FROM t_wf_proccate WHERE fid='330957102636178432';

  INSERT INTO t_wf_proccate (FID, FMODIFYDATE, FMODIFIER, FISLEAF, FCREATEDATE, FPARENTID, FCREATER, FAPPLICATIONID, FNUMBER) (SELECT '330957102636178432', {ts'2018-04-02 15:12:41'}, '1', '0', {ts'2018-04-02 15:12:41'}, '10000', '1', '83bfebc8000002ac', 'FI' FROM DUAL WHERE NOT EXISTS (select 1 from t_wf_proccate where fapplicationid='83bfebc8000002ac'));



-- ----------------------------

-- Records of t_wf_proccate_l

-- ----------------------------

  DELETE FROM t_wf_proccate_l WHERE fpkid='11PMZTA6KOUV';

  INSERT INTO t_wf_proccate_l (FID, FPKID, FLOCALEID, FDESCRIPTION, FNAME) (SELECT '330957102636178432', '11PMZTA6KOUV', 'zh_CN', ' ', '财务云' FROM DUAL WHERE EXISTS (select 1 from t_wf_proccate where fid='330957102636178432'));



  update t_wf_model set fcategory = (select fid from t_wf_proccate where fapplicationid = '10MYBGBYHXDU') where fid = '709140875434833920';


update t_wf_proccate set fparentid = '330957102636178432' where fid = '404194390785943552';


-- ----------------------------

-- Records of t_wf_gebytearray

-- ----------------------------

  DELETE FROM t_wf_gebytearray WHERE fid='709140879083878400';

  INSERT INTO t_wf_gebytearray (FID, FCONTENT, FGENERATED, FNAME, FDEPLOYMENTID, FCURRENTLANGUAGE) VALUES ('709140879083878400', ' ', '0', 'Proc_er_publicreimbursebill_audit_1.graph_json', '0', 'zh_CN');



-- ----------------------------

-- Records of t_wf_gebytearray_l

-- ----------------------------

  DELETE FROM t_wf_gebytearray_l WHERE fpkid='0AV6W1GSZP7R';

  INSERT INTO t_wf_gebytearray_l (FID, FPKID, FLOCALEID, FCONTENT) VALUES ('709140879083878400', '0AV6W1GSZP7R', 'zh_CN', ' ');



-- ----------------------------

-- Records of t_wf_billsubjectmodel

-- ----------------------------


/*对公包销单工作流预置数据2*/

-- ----------------------------

-- Records of t_wf_model

-- ----------------------------

  DELETE FROM t_wf_model WHERE fid='723856780056091648';

  INSERT INTO t_wf_model (FID, FVERSION, FMODIFYDATE, FPNGID, FTYPE, FOPERATION, FCREATEDATE, FNUMBER, FDEPLOYMENTID, FBPMNXMLID, FGRAPHID, FENTRABILL, FPARENTPROCID, FMODIFIERID, FORGUNITID, FCATEGORY, FCREATORID, FENTRABILLID, FPUBLISH) VALUES ('723856780056091648', ' ', {ts'2019-10-29 22:26:13'}, '0', 'AuditFlow', 'submit', {ts'2019-10-29 22:26:13'}, 'Proc_er_publicreimbursebill_audit_2', '0', '723856786834086912', '0', 'er_publicreimbursebill', '0', '1', '1', '404194390785943552', '1', '6B2CW570E+4', '0');



-- ----------------------------

-- Records of t_wf_model_l

-- ----------------------------

  DELETE FROM t_wf_model_l WHERE fpkid='0AV6W2DZH7UH';

  INSERT INTO t_wf_model_l (FID, FPKID, FLOCALEID, FDESCRIPTION, FNAME) VALUES ('723856780056091648', '0AV6W2DZH7UH', 'zh_CN', ' ', '对公报销单共享审批流程');



-- ----------------------------

-- Records of t_wf_proccate

-- ----------------------------

  DELETE FROM t_wf_proccate WHERE fid='404194390785943552';

  INSERT INTO t_wf_proccate (FID, FMODIFYDATE, FMODIFIER, FISLEAF, FCREATEDATE, FPARENTID, FCREATER, FAPPLICATIONID, FNUMBER) (SELECT '404194390785943552', {ts'2018-07-12 16:22:06'}, '1', '1', {ts'2018-07-12 16:22:06'}, '330957102636178432', '1', '10MYBGBYHXDU', 'EM' FROM DUAL WHERE NOT EXISTS (select 1 from t_wf_proccate where fapplicationid='10MYBGBYHXDU'));



-- ----------------------------

-- Records of t_wf_proccate_l

-- ----------------------------

  DELETE FROM t_wf_proccate_l WHERE fpkid='/8MEZL08SBAG';

  INSERT INTO t_wf_proccate_l (FID, FPKID, FLOCALEID, FDESCRIPTION, FNAME) (SELECT '404194390785943552', '/8MEZL08SBAG', 'zh_CN', '费用核算、商旅结算', '费用' FROM DUAL WHERE EXISTS (select 1 from t_wf_proccate where fid='404194390785943552'));



-- ----------------------------

-- Records of t_wf_proccate

-- ----------------------------

  DELETE FROM t_wf_proccate WHERE fid='330957102636178432';

  INSERT INTO t_wf_proccate (FID, FMODIFYDATE, FMODIFIER, FISLEAF, FCREATEDATE, FPARENTID, FCREATER, FAPPLICATIONID, FNUMBER) (SELECT '330957102636178432', {ts'2018-04-02 15:12:41'}, '100', '0', {ts'2018-04-02 15:12:41'}, '10000', '100', '83bfebc8000002ac', 'FI' FROM DUAL WHERE NOT EXISTS (select 1 from t_wf_proccate where fapplicationid='83bfebc8000002ac'));



-- ----------------------------

-- Records of t_wf_proccate_l

-- ----------------------------

  DELETE FROM t_wf_proccate_l WHERE fpkid='11PMZTA6KOUV';

  INSERT INTO t_wf_proccate_l (FID, FPKID, FLOCALEID, FDESCRIPTION, FNAME) (SELECT '330957102636178432', '11PMZTA6KOUV', 'zh_CN', ' ', '财务云' FROM DUAL WHERE EXISTS (select 1 from t_wf_proccate where fid='330957102636178432'));



  update t_wf_model set fcategory = (select fid from t_wf_proccate where fapplicationid = '10MYBGBYHXDU') where fid = '723856780056091648';


 update t_wf_proccate set fparentid = '330957102636178432' where fid = '404194390785943552';

-- ----------------------------

-- Records of t_wf_gebytearray

-- ----------------------------

  DELETE FROM t_wf_gebytearray WHERE fid='723856786834086912';

  INSERT INTO t_wf_gebytearray (FID, FCONTENT, FGENERATED, FNAME, FDEPLOYMENTID, FCURRENTLANGUAGE) VALUES ('723856786834086912', ' ', '0', 'Proc_er_publicreimbursebill_audit_2.graph_json', '0', 'zh_CN');



-- ----------------------------

-- Records of t_wf_gebytearray_l

-- ----------------------------

  DELETE FROM t_wf_gebytearray_l WHERE fpkid='0AV6W2CYLN0L';

  INSERT INTO t_wf_gebytearray_l (FID, FPKID, FLOCALEID, FCONTENT) VALUES ('723856786834086912', '0AV6W2CYLN0L', 'zh_CN', ' ');



-- ----------------------------

-- Records of t_wf_billsubjectmodel

-- ----------------------------

