DELETE FROM t_privacy_data_tag_tpl WHERE FID = 1505066171630626816;
INSERT INTO t_privacy_data_tag_tpl(FID,FMODIFYDATE,FMODIFIER,FCREATEDATE,FCREATER,FSTATUS,FNUMBER,FNAME) VALUES (1505066171630626816,{ts'2023-07-12  00:00:00'},1,{ts'2023-07-12  00:00:00'},1,'C','PRIVACY_TAG_PRE_BOS','数据安全标签预置_平台'); 
DELETE FROM t_privacy_data_tag_tpl_l WHERE FID = 1505066171630626816 ;
DELETE FROM t_privacy_data_tag_tpl_l WHERE FPKID = '2PVM4F5ZNYLO';
INSERT INTO t_privacy_data_tag_tpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1505066171630626816,'2PVM4F5ZNYLO','zh_CN','数据安全标签预置_平台'); 
DELETE FROM t_privacy_data_field_tpl WHERE FID = 1505066171630626816 ;
DELETE FROM t_privacy_data_field_tpl WHERE FENTRYID = 1505066171630626817;
INSERT INTO t_privacy_data_field_tpl(FID,FFIELD_NAME,FFIELD_IDENT,FTABLE_NAME,FAPP_NUMBER,FDATATAGID,FENTRYID,FFIELD_DESC,FENTITY_NAME,FAPP_ROUTE,FFIELD_TYPE,FCLOUD_NAME,FENTITY_NUMBER,FAPP_NAME,FSEQ,FCLOUD_NUMBER) VALUES (1505066171630626816,'fphone','phone','t_SEC_User','83bfebc8000037ac',NULL,1505066171630626817,'手机','人员','sys','12','基础服务云','bos_user','企业建模',1,'0QLCSO6KKZC9'); 
DELETE FROM t_privacy_data_field_tpl WHERE FENTRYID = 1505066171630626819;
INSERT INTO t_privacy_data_field_tpl(FID,FFIELD_NAME,FFIELD_IDENT,FTABLE_NAME,FAPP_NUMBER,FDATATAGID,FENTRYID,FFIELD_DESC,FENTITY_NAME,FAPP_ROUTE,FFIELD_TYPE,FCLOUD_NAME,FENTITY_NUMBER,FAPP_NAME,FSEQ,FCLOUD_NUMBER) VALUES (1505066171630626816,'femail','email','t_SEC_User','83bfebc8000037ac',NULL,1505066171630626819,'邮箱','人员','sys','12','基础服务云','bos_user','企业建模',2,'0QLCSO6KKZC9'); 
DELETE FROM t_privacy_data_field_tpl WHERE FENTRYID = 1505066171630626818;
INSERT INTO t_privacy_data_field_tpl(FID,FFIELD_NAME,FFIELD_IDENT,FTABLE_NAME,FAPP_NUMBER,FDATATAGID,FENTRYID,FFIELD_DESC,FENTITY_NAME,FAPP_ROUTE,FFIELD_TYPE,FCLOUD_NAME,FENTITY_NUMBER,FAPP_NAME,FSEQ,FCLOUD_NUMBER) VALUES (1505066171630626816,'fidcard','idcard','t_SEC_User','83bfebc8000037ac',NULL,1505066171630626818,'身份证号','人员','sys','12','基础服务云','bos_user','企业建模',3,'0QLCSO6KKZC9'); 
DELETE FROM t_privacy_data_field_tpl WHERE FENTRYID = 1726013090199288834;
INSERT INTO t_privacy_data_field_tpl(FID,FFIELD_NAME,FFIELD_IDENT,FTABLE_NAME,FAPP_NUMBER,FDATATAGID,FENTRYID,FFIELD_DESC,FENTITY_NAME,FAPP_ROUTE,FFIELD_TYPE,FCLOUD_NAME,FENTITY_NUMBER,FAPP_NAME,FSEQ,FCLOUD_NUMBER) VALUES (1505066171630626816,'fcontact','contact','t_sec_usercontact','83bfebc8000037ac',NULL,1726013090199288834,'联系方式','人员','sys','12','基础服务云','bos_user','企业建模',4,'0QLCSO6KKZC9'); 
DELETE FROM t_privacy_data_field_tpl WHERE FENTRYID = 1726017657376914433;
INSERT INTO t_privacy_data_field_tpl(FID,FFIELD_NAME,FFIELD_IDENT,FTABLE_NAME,FAPP_NUMBER,FDATATAGID,FENTRYID,FFIELD_DESC,FENTITY_NAME,FAPP_ROUTE,FFIELD_TYPE,FCLOUD_NAME,FENTITY_NUMBER,FAPP_NAME,FSEQ,FCLOUD_NUMBER) VALUES (1505066171630626816,' ','phone','T_SEC_BizPartnerUser','83bfebc8000037ac',NULL,1726017657376914433,'手机','商务伙伴用户','sys','12','基础服务云','bos_bizpartneruser','企业建模',6,'0QLCSO6KKZC9'); 
DELETE FROM t_privacy_data_field_tpl WHERE FENTRYID = 1726017657376914436;
INSERT INTO t_privacy_data_field_tpl(FID,FFIELD_NAME,FFIELD_IDENT,FTABLE_NAME,FAPP_NUMBER,FDATATAGID,FENTRYID,FFIELD_DESC,FENTITY_NAME,FAPP_ROUTE,FFIELD_TYPE,FCLOUD_NAME,FENTITY_NUMBER,FAPP_NAME,FSEQ,FCLOUD_NUMBER) VALUES (1505066171630626816,' ','email','T_SEC_BizPartnerUser','83bfebc8000037ac',NULL,1726017657376914436,'邮箱','商务伙伴用户','sys','12','基础服务云','bos_bizpartneruser','企业建模',7,'0QLCSO6KKZC9'); 
DELETE FROM t_privacy_data_field_tpl WHERE FENTRYID = 1733968126074213376;
INSERT INTO t_privacy_data_field_tpl(FID,FFIELD_NAME,FFIELD_IDENT,FTABLE_NAME,FAPP_NUMBER,FDATATAGID,FENTRYID,FFIELD_DESC,FENTITY_NAME,FAPP_ROUTE,FFIELD_TYPE,FCLOUD_NAME,FENTITY_NUMBER,FAPP_NAME,FSEQ,FCLOUD_NUMBER) VALUES (1505066171630626816,'fgender','gender','t_SEC_User','83bfebc8000037ac',NULL,1733968126074213376,'性别','人员','sys','12','基础服务云','bos_user','企业建模',5,'0QLCSO6KKZC9'); 
DELETE FROM t_privacy_config_tpl WHERE FID = 1769505269252896768;
INSERT INTO t_privacy_config_tpl(FID,FMODIFYDATE,FSCHEME_NAME,FCREATEDATE,FMASTERID,FMESSAGECHANNEL,FMODIFIER,FSCHEME_STATUS,FTEMPLATE,FSCHEME_CODE,FCREATER,FSCHEME_DESC,FDATALABELID) VALUES (1769505269252896768,{ts'2023-07-12  00:00:00'},'隐私方案预置_平台',{ts'2023-07-12  00:00:00'},1769505269252896768,' ',1,'1',' ','PRIVACY_SCHE_PRE_BOS',1,'隐私方案预置_平台',1505066171630626816); 
DELETE FROM t_privacy_config_tpl_l WHERE FID = 1769505269252896768 ;
DELETE FROM t_privacy_config_tpl_l WHERE FPKID = '3JBIFN8/ZK2H';
INSERT INTO t_privacy_config_tpl_l(FID,FSCHEME_NAME,FPKID,FLOCALEID) VALUES (1769505269252896768,'隐私方案预置_平台','3JBIFN8/ZK2H','zh_CN'); 
DELETE FROM t_privacy_desen_tpl WHERE FID = 1769505269252896768 ;
DELETE FROM t_privacy_desen_tpl WHERE FENTRYID = 1769505272289572869;
INSERT INTO t_privacy_desen_tpl(FID,FDENSEFIELDLOCALE,FDENSE_TABLE_NAME,FDENSE_FIELD_IDENT,FDESENSITIZ_STATUS,FENTRYID,FDENSE_ENTITY_NUMBER,FDENSE_APP_NUMBER,FDENSE_ENTITY_NAME,FDESENSITIZE_TYPE,FDENSE_FIELD_LOCALE,FDESENSITIZE_RULE,FLABELID,FDENSE_CLOUD_NUMBER,FDENSE_FIELD_TYPE,FPLUGIN,FDENSE_FIELD_DESC,FSEQ,FDENSE_FIELD_NAME,FDENSE_APP_NAME,FDENSE_CLOUD_NAME) VALUES (1769505269252896768,' ','t_sec_usercontact','contact','1',1769505272289572869,'bos_user','83bfebc8000037ac','人员','SYSTEM',' ','3F/1JS0F926C',1726013090199288834,'0QLCSO6KKZC9','12',' ','联系方式',4,'fcontact','企业建模','基础服务云'); 
DELETE FROM t_privacy_desen_tpl WHERE FENTRYID = 1769505272289572872;
INSERT INTO t_privacy_desen_tpl(FID,FDENSEFIELDLOCALE,FDENSE_TABLE_NAME,FDENSE_FIELD_IDENT,FDESENSITIZ_STATUS,FENTRYID,FDENSE_ENTITY_NUMBER,FDENSE_APP_NUMBER,FDENSE_ENTITY_NAME,FDESENSITIZE_TYPE,FDENSE_FIELD_LOCALE,FDESENSITIZE_RULE,FLABELID,FDENSE_CLOUD_NUMBER,FDENSE_FIELD_TYPE,FPLUGIN,FDENSE_FIELD_DESC,FSEQ,FDENSE_FIELD_NAME,FDENSE_APP_NAME,FDENSE_CLOUD_NAME) VALUES (1769505269252896768,' ','t_SEC_User','gender','1',1769505272289572872,'bos_user','83bfebc8000037ac','人员','SYSTEM',' ','3F/1JS0BMO+V',1733968126074213376,'0QLCSO6KKZC9','12',' ','性别',5,'fgender','企业建模','基础服务云'); 
DELETE FROM t_privacy_desen_tpl WHERE FENTRYID = 1769505272289572866;
INSERT INTO t_privacy_desen_tpl(FID,FDENSEFIELDLOCALE,FDENSE_TABLE_NAME,FDENSE_FIELD_IDENT,FDESENSITIZ_STATUS,FENTRYID,FDENSE_ENTITY_NUMBER,FDENSE_APP_NUMBER,FDENSE_ENTITY_NAME,FDESENSITIZE_TYPE,FDENSE_FIELD_LOCALE,FDESENSITIZE_RULE,FLABELID,FDENSE_CLOUD_NUMBER,FDENSE_FIELD_TYPE,FPLUGIN,FDENSE_FIELD_DESC,FSEQ,FDENSE_FIELD_NAME,FDENSE_APP_NAME,FDENSE_CLOUD_NAME) VALUES (1769505269252896768,' ','t_SEC_User','email','1',1769505272289572866,'bos_user','83bfebc8000037ac','人员','SYSTEM',' ','3F/1JS0F926C',1505066171630626819,'0QLCSO6KKZC9','12',' ','邮箱',2,'femail','企业建模','基础服务云'); 
DELETE FROM t_privacy_desen_tpl WHERE FENTRYID = 1769505272289572867;
INSERT INTO t_privacy_desen_tpl(FID,FDENSEFIELDLOCALE,FDENSE_TABLE_NAME,FDENSE_FIELD_IDENT,FDESENSITIZ_STATUS,FENTRYID,FDENSE_ENTITY_NUMBER,FDENSE_APP_NUMBER,FDENSE_ENTITY_NAME,FDESENSITIZE_TYPE,FDENSE_FIELD_LOCALE,FDESENSITIZE_RULE,FLABELID,FDENSE_CLOUD_NUMBER,FDENSE_FIELD_TYPE,FPLUGIN,FDENSE_FIELD_DESC,FSEQ,FDENSE_FIELD_NAME,FDENSE_APP_NAME,FDENSE_CLOUD_NAME) VALUES (1769505269252896768,' ','t_SEC_User','phone','1',1769505272289572867,'bos_user','83bfebc8000037ac','人员','SYSTEM',' ','3F/1JS05CULU',1505066171630626817,'0QLCSO6KKZC9','12',' ','手机',1,'fphone','企业建模','基础服务云'); 
DELETE FROM t_privacy_desen_tpl WHERE FENTRYID = 1769505272289572868;
INSERT INTO t_privacy_desen_tpl(FID,FDENSEFIELDLOCALE,FDENSE_TABLE_NAME,FDENSE_FIELD_IDENT,FDESENSITIZ_STATUS,FENTRYID,FDENSE_ENTITY_NUMBER,FDENSE_APP_NUMBER,FDENSE_ENTITY_NAME,FDESENSITIZE_TYPE,FDENSE_FIELD_LOCALE,FDESENSITIZE_RULE,FLABELID,FDENSE_CLOUD_NUMBER,FDENSE_FIELD_TYPE,FPLUGIN,FDENSE_FIELD_DESC,FSEQ,FDENSE_FIELD_NAME,FDENSE_APP_NAME,FDENSE_CLOUD_NAME) VALUES (1769505269252896768,' ','t_SEC_User','idcard','1',1769505272289572868,'bos_user','83bfebc8000037ac','人员','SYSTEM',' ','3F/1JS0IWHCW',1505066171630626818,'0QLCSO6KKZC9','12',' ','身份证号',3,'fidcard','企业建模','基础服务云'); 
DELETE FROM t_privacy_desen_tpl WHERE FENTRYID = 1769505272289572871;
INSERT INTO t_privacy_desen_tpl(FID,FDENSEFIELDLOCALE,FDENSE_TABLE_NAME,FDENSE_FIELD_IDENT,FDESENSITIZ_STATUS,FENTRYID,FDENSE_ENTITY_NUMBER,FDENSE_APP_NUMBER,FDENSE_ENTITY_NAME,FDESENSITIZE_TYPE,FDENSE_FIELD_LOCALE,FDESENSITIZE_RULE,FLABELID,FDENSE_CLOUD_NUMBER,FDENSE_FIELD_TYPE,FPLUGIN,FDENSE_FIELD_DESC,FSEQ,FDENSE_FIELD_NAME,FDENSE_APP_NAME,FDENSE_CLOUD_NAME) VALUES (1769505269252896768,' ','T_SEC_BizPartnerUser','email','1',1769505272289572871,'bos_bizpartneruser','83bfebc8000037ac','商务伙伴用户','SYSTEM',' ','3F/1JS0F926C',1726017657376914436,'0QLCSO6KKZC9','12',' ','邮箱',7,' ','企业建模','基础服务云'); 
DELETE FROM t_privacy_desen_tpl WHERE FENTRYID = 1769505272289572870;
INSERT INTO t_privacy_desen_tpl(FID,FDENSEFIELDLOCALE,FDENSE_TABLE_NAME,FDENSE_FIELD_IDENT,FDESENSITIZ_STATUS,FENTRYID,FDENSE_ENTITY_NUMBER,FDENSE_APP_NUMBER,FDENSE_ENTITY_NAME,FDESENSITIZE_TYPE,FDENSE_FIELD_LOCALE,FDESENSITIZE_RULE,FLABELID,FDENSE_CLOUD_NUMBER,FDENSE_FIELD_TYPE,FPLUGIN,FDENSE_FIELD_DESC,FSEQ,FDENSE_FIELD_NAME,FDENSE_APP_NAME,FDENSE_CLOUD_NAME) VALUES (1769505269252896768,' ','T_SEC_BizPartnerUser','phone','1',1769505272289572870,'bos_bizpartneruser','83bfebc8000037ac','商务伙伴用户','SYSTEM',' ','3F/1JS05CULU',1726017657376914433,'0QLCSO6KKZC9','12',' ','手机',6,' ','企业建模','基础服务云'); 
DELETE FROM t_privacy_encrypt_tpl WHERE FID = 1769505269252896768 ;
DELETE FROM t_privacy_encrypt_tpl WHERE FENTRYID = 1769505272289573891;
INSERT INTO t_privacy_encrypt_tpl(FID,FVERSION,FENCRYPT_CLOUD_NAME,FENCRYPT_CLOUD_NUMBER,FENCRYPT_STATUS,FENTRYID,FENCRYPT_ENTITY_NUMBER,FENCRYPT_FIELD_DESC,FENCRYPT_SCHEMEID,FENCRYPT_TABLE_NAME,FENCRYPT_ENTITY_NAME,FAPP_ROUTE,FENCRYPT_APP_NUMBER,FLABELID,FENCRYPT_FIELD_NAME,FENCRYPT_ALGORITHM,FENCRYPT_APP_NAME,FENCRYPT_FIELD_IDENT,FSEQ,FENCRYPT_FIELD_TYPE) VALUES (1769505269252896768,1,'基础服务云','0QLCSO6KKZC9','1',1769505272289573891,'bos_user','联系方式',NULL,'t_sec_usercontact','人员','sys','83bfebc8000037ac',1726013090199288834,'fcontact','1832555652921283584','企业建模','contact',4,'12'); 
DELETE FROM t_privacy_encrypt_tpl WHERE FENTRYID = 1769505272289573892;
INSERT INTO t_privacy_encrypt_tpl(FID,FVERSION,FENCRYPT_CLOUD_NAME,FENCRYPT_CLOUD_NUMBER,FENCRYPT_STATUS,FENTRYID,FENCRYPT_ENTITY_NUMBER,FENCRYPT_FIELD_DESC,FENCRYPT_SCHEMEID,FENCRYPT_TABLE_NAME,FENCRYPT_ENTITY_NAME,FAPP_ROUTE,FENCRYPT_APP_NUMBER,FLABELID,FENCRYPT_FIELD_NAME,FENCRYPT_ALGORITHM,FENCRYPT_APP_NAME,FENCRYPT_FIELD_IDENT,FSEQ,FENCRYPT_FIELD_TYPE) VALUES (1769505269252896768,1,'基础服务云','0QLCSO6KKZC9','1',1769505272289573892,'bos_user','性别',NULL,'t_SEC_User','人员','sys','83bfebc8000037ac',1733968126074213376,'fgender','1832555652921283584','企业建模','gender',5,'12'); 
DELETE FROM t_privacy_encrypt_tpl WHERE FENTRYID = 1769505272289573889;
INSERT INTO t_privacy_encrypt_tpl(FID,FVERSION,FENCRYPT_CLOUD_NAME,FENCRYPT_CLOUD_NUMBER,FENCRYPT_STATUS,FENTRYID,FENCRYPT_ENTITY_NUMBER,FENCRYPT_FIELD_DESC,FENCRYPT_SCHEMEID,FENCRYPT_TABLE_NAME,FENCRYPT_ENTITY_NAME,FAPP_ROUTE,FENCRYPT_APP_NUMBER,FLABELID,FENCRYPT_FIELD_NAME,FENCRYPT_ALGORITHM,FENCRYPT_APP_NAME,FENCRYPT_FIELD_IDENT,FSEQ,FENCRYPT_FIELD_TYPE) VALUES (1769505269252896768,1,'基础服务云','0QLCSO6KKZC9','1',1769505272289573889,'bos_user','手机',NULL,'t_SEC_User','人员','sys','83bfebc8000037ac',1505066171630626817,'fphone','1832555652921283584','企业建模','phone',1,'12'); 
DELETE FROM t_privacy_encrypt_tpl WHERE FENTRYID = 1769505272289573890;
INSERT INTO t_privacy_encrypt_tpl(FID,FVERSION,FENCRYPT_CLOUD_NAME,FENCRYPT_CLOUD_NUMBER,FENCRYPT_STATUS,FENTRYID,FENCRYPT_ENTITY_NUMBER,FENCRYPT_FIELD_DESC,FENCRYPT_SCHEMEID,FENCRYPT_TABLE_NAME,FENCRYPT_ENTITY_NAME,FAPP_ROUTE,FENCRYPT_APP_NUMBER,FLABELID,FENCRYPT_FIELD_NAME,FENCRYPT_ALGORITHM,FENCRYPT_APP_NAME,FENCRYPT_FIELD_IDENT,FSEQ,FENCRYPT_FIELD_TYPE) VALUES (1769505269252896768,1,'基础服务云','0QLCSO6KKZC9','1',1769505272289573890,'bos_user','身份证号',NULL,'t_SEC_User','人员','sys','83bfebc8000037ac',1505066171630626818,'fidcard','1832555652921283584','企业建模','idcard',3,'12'); 
DELETE FROM t_privacy_encrypt_tpl WHERE FENTRYID = 1769505272289573888;
INSERT INTO t_privacy_encrypt_tpl(FID,FVERSION,FENCRYPT_CLOUD_NAME,FENCRYPT_CLOUD_NUMBER,FENCRYPT_STATUS,FENTRYID,FENCRYPT_ENTITY_NUMBER,FENCRYPT_FIELD_DESC,FENCRYPT_SCHEMEID,FENCRYPT_TABLE_NAME,FENCRYPT_ENTITY_NAME,FAPP_ROUTE,FENCRYPT_APP_NUMBER,FLABELID,FENCRYPT_FIELD_NAME,FENCRYPT_ALGORITHM,FENCRYPT_APP_NAME,FENCRYPT_FIELD_IDENT,FSEQ,FENCRYPT_FIELD_TYPE) VALUES (1769505269252896768,1,'基础服务云','0QLCSO6KKZC9','1',1769505272289573888,'bos_user','邮箱',NULL,'t_SEC_User','人员','sys','83bfebc8000037ac',1505066171630626819,'femail','1832555652921283584','企业建模','email',2,'12'); 

--更改ftype为自动升级
update t_privacy_data_tag_tpl set ftype = '1' where FID = 1505066171630626816;