/*关联权限项 预置脚本*/

-- 动态表单 hpdi_bizdatabillchoicetpl 作为 hpdi_bizdatabill 的权限项关联对象的预置数据 （BT-01072276）
DELETE FROM t_hrcs_permrelat WHERE FID = 1597024726901882880;
INSERT INTO t_hrcs_permrelat(FID,FCREATETIME,FPERMITEMID,FMODIFIERID,FMODIFYTIME,FAPPID,FDESCRIPTION,FCREATORID,FENTITYTYPEID) VALUES (1597024726901882880,{ts'2023-01-13  00:00:00'},'QXX0002',13466739,{ts'2023-01-13  00:00:00'},'0NXW1VOPH+QV',' ',13466739,'hpdi_bizdatabill');
DELETE FROM t_hrcs_permrelat WHERE FID = 1596572945105426432;
INSERT INTO t_hrcs_permrelat(FID,FCREATETIME,FPERMITEMID,FMODIFIERID,FMODIFYTIME,FAPPID,FDESCRIPTION,FCREATORID,FENTITYTYPEID) VALUES (1596572945105426432,{ts'2023-01-12  00:00:00'},'HRQXX0213',13466739,{ts'2023-01-13  00:00:00'},'0NXW1VOPH+QV',' ',13466739,'hpdi_bizdatabill');

DELETE FROM t_hrcs_permrelat_l WHERE FPKID in ('3/566VKF/MRX', '3/566VKF/MRY', '3/3/SQNF5UT6', '3/3/SQNF5UT7');

DELETE FROM t_hrcs_permrelatentry WHERE FENTRYID = 1597024726901882881;
INSERT INTO t_hrcs_permrelatentry(FID,FISSYSPRESET,FPERMITEMID,FENTRYID,FSEQ,FAPPID,FENTITYTYPEID) VALUES (1597024726901882880,'1','QXX0001',1597024726901882881,1,'0NXW1VOPH+QV','hpdi_bizdatabillchoicetpl');
DELETE FROM t_hrcs_permrelatentry WHERE FENTRYID = 1596572945105426433;
INSERT INTO t_hrcs_permrelatentry(FID,FISSYSPRESET,FPERMITEMID,FENTRYID,FSEQ,FAPPID,FENTITYTYPEID) VALUES (1596572945105426432,'1','QXX0001',1596572945105426433,1,'0NXW1VOPH+QV','hpdi_bizdatabillchoicetpl');

DELETE FROM t_hrcs_permrelatcfg WHERE FID = 1597019196233924608;
INSERT INTO t_hrcs_permrelatcfg(FID,FCREATETIME,FISSYSPRESET,FPERMITEMID,FMODIFIERID,FMODIFYTIME,FAPPID,FISASSIGN,FCREATORID,FENTITYTYPEID) VALUES (1597019196233924608,{ts'2023-01-13  00:00:00'},'1','47150e89000000ac',13466739,{ts'2023-01-13  00:00:00'},'0NXW1VOPH+QV','0',0,'hpdi_bizdatabillchoicetpl');
