DELETE FROM t_perm_roleperm WHERE FROLEID IN('0KF7KTPK48NB');
INSERT INTO t_perm_roleperm(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FROLEID,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES ('2QDWJ1PHSOWJ',NULL,0,'0',NULL,'0KF7KTPK48NB',' ',' ',0,' '); 
DELETE FROM t_perm_rolepermdetial WHERE FBIZAPPID='eae607fb000152ac' AND FENTITYTYPEID='pur_deliveryschedule' AND FPERMITEMID='2PTGV+L1GB4C' AND FROLEID='0KF7KTPK48NB';
INSERT INTO t_perm_rolepermdetial(FID,FENTRYID,FSEQ,FCONTROLMODE,FPERMITEMID,FINHERITMODE,FENTITYTYPEID,FBIZAPPID,FROLEID) VALUES ('2QDWJ1PHSOWJ','2QDWJ1PLC/TF',0,' ','2PTGV+L1GB4C',' ','pur_deliveryschedule','eae607fb000152ac','0KF7KTPK48NB');
DELETE FROM t_perm_rolepermdetial WHERE FBIZAPPID='eae607fb000152ac' AND FENTITYTYPEID='pur_deliveryschedule' AND FPERMITEMID='47150e89000000ac' AND FROLEID='0KF7KTPK48NB';
INSERT INTO t_perm_rolepermdetial(FID,FENTRYID,FSEQ,FCONTROLMODE,FPERMITEMID,FINHERITMODE,FENTITYTYPEID,FBIZAPPID,FROLEID) VALUES ('2QDWJ1PHSOWJ','2QDWJ1PLC/TG',0,' ','47150e89000000ac',' ','pur_deliveryschedule','eae607fb000152ac','0KF7KTPK48NB');

UPDATE t_perm_rolepermdetial SET FID = '2QDWJ1PHSOWJ' WHERE FROLEID = '0KF7KTPK48NB';


DELETE FROM t_perm_roleperm WHERE FROLEID IN('0KF19V=6MYXS');
INSERT INTO t_perm_roleperm(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FROLEID,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES ('2QDWJFC=U14C',NULL,0,'0',NULL,'0KF19V=6MYXS',' ',' ',0,' '); 
DELETE FROM t_perm_rolepermdetial WHERE FBIZAPPID='eae607fb000152ac' AND FENTITYTYPEID='pur_deliveryschedule' AND FPERMITEMID='2PTGV+L1GB4C' AND FROLEID='0KF19V=6MYXS';
INSERT INTO t_perm_rolepermdetial(FID,FENTRYID,FSEQ,FCONTROLMODE,FPERMITEMID,FINHERITMODE,FENTITYTYPEID,FBIZAPPID,FROLEID) VALUES ('2QDWJFC=U14C','2QDWJFCDHK2C',0,' ','2PTGV+L1GB4C',' ','pur_deliveryschedule','eae607fb000152ac','0KF19V=6MYXS');
DELETE FROM t_perm_rolepermdetial WHERE FBIZAPPID='eae607fb000152ac' AND FENTITYTYPEID='pur_deliveryschedule' AND FPERMITEMID='47150e89000000ac' AND FROLEID='0KF19V=6MYXS';
INSERT INTO t_perm_rolepermdetial(FID,FENTRYID,FSEQ,FCONTROLMODE,FPERMITEMID,FINHERITMODE,FENTITYTYPEID,FBIZAPPID,FROLEID) VALUES ('2QDWJFC=U14C','2QDWJFCDHK2D',0,' ','47150e89000000ac',' ','pur_deliveryschedule','eae607fb000152ac','0KF19V=6MYXS');

UPDATE t_perm_rolepermdetial SET FID = '2QDWJFC=U14C' WHERE FROLEID = '0KF19V=6MYXS';