-- 人员信息清除方案预置

-- 主表
DELETE FROM T_SEC_UserInfoCleanScheme WHERE FID = 1692874349519880192;
INSERT INTO T_SEC_UserInfoCleanScheme(FID,FRETAINDAY,FRULE,FDISABLEDATE,FMASTERID,FSTATUS,FDESC,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1692874349519880192,180,'{"filterRow":[{"id":"3E/14P2/BYNF","leftBracket":"(","compareType":"105","fieldName":"enable","rightBracket":"","logic":"1","value":[{"id":"3E/14P2/B605","value":"0"}],"baseDataIds":[]},{"id":"3E/14P2/BYNG","leftBracket":"","compareType":"105","fieldName":"isforbidden","rightBracket":")","logic":"0","value":[{"id":"3E/14P2/B606","value":"1"}],"baseDataIds":[]}],"forList":false}',NULL,1692874349519880192,'C','预置方案','DP-20230707-001','人员敏感信息清除配置',{ts'2023-07-07  00:00:00'},13466739,'0',{ts'2023-07-10  00:00:00'},13466739,0); 

-- 多语言表
DELETE FROM T_SEC_UserInfoCleanScheme_l WHERE FPKID = '3DRE349WW3KJ';
INSERT INTO T_SEC_UserInfoCleanScheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692874349519880192,'3DRE349WW3KJ','zh_CN','人员敏感信息清除配置'); 
DELETE FROM T_SEC_UserInfoCleanScheme_l WHERE FPKID = '3DRE349WW3KK';
INSERT INTO T_SEC_UserInfoCleanScheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692874349519880192,'3DRE349WW3KK','zh_TW','人員敏感信息清除配置'); 

--清除内容分录表
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635008;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'birthday',1723979227310635008,1); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635009;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'country',1723979227310635009,2); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635010;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'gender',1723979227310635010,3); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635011;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'phone',1723979227310635011,4); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635012;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'simplepinyin',1723979227310635012,5); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635013;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'idcard',1723979227310635013,6); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635014;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'contact',1723979227310635014,7); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635015;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'picturefield',1723979227310635015,8); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635016;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'fullpinyin',1723979227310635016,9); 
DELETE FROM T_SEC_UserInfoClnSchEntry WHERE FENTRYID = 1723979227310635017;
INSERT INTO T_SEC_UserInfoClnSchEntry(FID,FFIELDNUMBER,FENTRYID,FSEQ) VALUES (1692874349519880192,'email',1723979227310635017,10); 
