--当前表预制数据
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1010;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1010,' ',{ts'2019-09-06  00:00:00'},1010,' ','1',0,1,NULL,' ','1010_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1020;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1020,' ',{ts'2019-09-06  00:00:00'},1020,' ','1',0,1,NULL,' ','1020_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1030;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1030,' ',{ts'2019-09-06  00:00:00'},1030,' ','1',0,1,NULL,' ','1030_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1040;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1040,' ',{ts'2019-09-06  00:00:00'},1040,' ','1',0,1,NULL,' ','1040_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1050;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1050,' ',{ts'2019-09-06  00:00:00'},1050,' ','1',0,1,NULL,' ','1050_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1060;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1060,' ',{ts'2019-09-06  00:00:00'},1060,' ','1',0,1,NULL,' ','1060_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1070;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1070,' ',{ts'2019-09-06  00:00:00'},1070,' ','1',0,1,NULL,' ','1070_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1080;
INSERT INTO t_hbss_payrollacrelation(FCREATORID,FDISABLERID,FMODIFYTIME,FMASTERID,FNAME,FCREATETIME,FID,FDESCRIPTION,FENABLE,FINDEX,FMODIFIERID,FDISABLEDATE,FSIMPLENAME,FNUMBER,FSTATUS,FISSYSPRESET) VALUES (1,1,{ts'2019-09-06  00:00:00'},1080,' ',{ts'2019-09-06  00:00:00'},1080,' ','1',0,1,NULL,' ','1080_S','C','1'); 
DELETE FROM t_hbss_payrollacrelation WHERE FID = 1090;

--多语言表预制数据
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=MNF7LNCZ';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=MNF7LNCZ','本人',' ',1010,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=MNF7LND+';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=MNF7LND+','本人',' ',1010,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=NIH66JBF';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=NIH66JBF','配偶',' ',1020,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=NIH66JBG';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=NIH66JBG','配偶',' ',1020,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=OAYPT51P';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=OAYPT51P','子女',' ',1030,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=OAYPT51Q';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=OAYPT51Q','子女',' ',1030,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=P7DGTMSC';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=P7DGTMSC','孙子女/外孙子女',' ',1040,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=P7DGTMSD';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=P7DGTMSD','孫子女/外孫子女',' ',1040,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=U1/KQVFB';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=U1/KQVFB','父母',' ',1050,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=U1/KQVFC';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=U1/KQVFC','父母',' ',1050,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=UZJ2URN9';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=UZJ2URN9','祖父母/外祖父母',' ',1060,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=UZJ2URN=';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=UZJ2URN=','祖父母/外祖父母',' ',1060,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=W87WKM0L';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=W87WKM0L','兄弟姐妹',' ',1070,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=W87WKM0M';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=W87WKM0M','兄弟姐妹',' ',1070,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=YJ6DG2X9';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_CN','072=YJ6DG2X9','其他',' ',1080,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=YJ6DG2X=';
INSERT INTO t_hbss_payrollacrelation_l(FLOCALEID,FPKID,FNAME,FSIMPLENAME,FID,FDESCRIPTION) VALUES ('zh_TW','072=YJ6DG2X=','其他',' ',1080,' '); 
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=Z1U/4JFB';
DELETE FROM t_hbss_payrollacrelation_l WHERE FPKID = '072=Z1U/4JFC';


