-- 地址预置字段表
-- 示例
--DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 686960188820822016;
--insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`) 
--values('686960188820822016','NUMBER','FType','FBaseType',1,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 10);

--DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '04C4J3ZYSDK3';
--insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('04C4J3ZYSDK3','686960188820822016','zh_CN',' ',' ');


-- 1028973702068313088-countryid-国家或地区-基础资料+bd_country-0-10
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313088;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313088','countryid','2','bd_country',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 10);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPGZZI/P2H';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPGZZI/P2H','1028973702068313088','zh_CN','国家或地区',' ');


-- 1028973702068313089-admindivisionid1-行政区划1级-基础资料+bd_admindivision-1-20
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313089;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313089','admindivisionid1','2','bd_admindivision',1,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 20);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UM';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UM','1028973702068313089','zh_CN','行政区划1级',' ');


-- 1028973702068313090-admindivisionid2-行政区划2级-基础资料+bd_admindivision-2-30
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313090;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313090','admindivisionid2','2','bd_admindivision',2,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 30);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UN';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UN','1028973702068313090','zh_CN','行政区划2级',' ');


-- 1028973702068313091-admindivisionid3-行政区划3级-基础资料+bd_admindivision-3-40
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313091;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313091','admindivisionid3','2','bd_admindivision',3,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 40);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UO';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UO','1028973702068313091','zh_CN','行政区划3级',' ');


-- 1028973702068313092-admindivisionid4-行政区划4级-基础资料+bd_admindivision-4-50
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313092;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313092','admindivisionid4','2','bd_admindivision',4,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 50);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UP';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UP','1028973702068313092','zh_CN','行政区划4级',' ');


-- 1028973702068313093-admindivisionid5-行政区划5级-基础资料+bd_admindivision-5-60
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313093;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313093','admindivisionid5','2','bd_admindivision',5,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 60);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UQ';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UQ','1028973702068313093','zh_CN','行政区划5级',' ');


-- 1028973702068313094-admindivisionid6-行政区划6级-基础资料+bd_admindivision-6-70
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313094;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313094','admindivisionid6','2','bd_admindivision',6,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 70);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UR';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UR','1028973702068313094','zh_CN','行政区划6级',' ');


-- 1028973702068313095-street1-街道-文本+ -0- 80
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313095;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313095','street1','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 80);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8US';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8US','1028973702068313095','zh_CN','街道',' ');


-- 1028973702068313096-street2-街道补充信息-文本+ -0-130
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313096;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313096','street2','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 130);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UT';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UT','1028973702068313096','zh_CN','街道补充信息',' ');


-- 1028973702068313097-housenum-门牌号-文本+ -0-90
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313097;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313097','housenum','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 90);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UU';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UU','1028973702068313097','zh_CN','门牌号',' ');


-- 1028973702068313098-housenum2-门牌号补充信息-文本+ -0-140
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313098;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313098','housenum2','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 140);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UV';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UV','1028973702068313098','zh_CN','门牌号补充信息',' ');


-- 1028973702068313099-building-大厦-文本+ -0-100
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313099;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313099','building','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 100);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UW';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UW','1028973702068313099','zh_CN','大厦',' ');


-- 1028973702068313100-floor-楼层-文本+ -0-110
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313100;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313100','floor','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 110);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UX';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UX','1028973702068313100','zh_CN','楼层',' ');


-- 1028973702068313101-roomnum-房间号-文本+ -0-120
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313101;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313101','roomnum','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 120);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UY';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UY','1028973702068313101','zh_CN','房间号',' ');


-- 1028973702068313102-postcode1-邮编1-文本+ -0-150
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313102;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313102','postcode1','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 150);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8UZ';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8UZ','1028973702068313102','zh_CN','邮编1',' ');


-- 1028973702068313103-postcode2-邮编2-文本+ -0-160
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313103;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313103','postcode2','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 160);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V+';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V+','1028973702068313103','zh_CN','邮编2',' ');


-- 1028973702068313104-postcode3-邮编3-文本+ -0-170
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313104;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313104','postcode3','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 170);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V/';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V/','1028973702068313104','zh_CN','邮编3',' ');


-- 1028973702068313105-postcodeext-邮编1扩展-文本+ -0-180
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313105;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313105','postcodeext','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 180);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V0';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V0','1028973702068313105','zh_CN','邮编1扩展',' ');


-- 1028973702068313106-pobox-PO Box-文本+ -0-190
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313106;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313106','pobox','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 190);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V1';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V1','1028973702068313106','zh_CN','PO Box',' ');


-- 1028973702068313107-address1-自定义地址字段1-文本+ -0-200
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028973702068313107;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028973702068313107','address1','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 200);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V2';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V2','1028973702068313107','zh_CN','自定义地址字段1',' ');


-- 1028974367184266240-address2-自定义地址字段2-文本+ -0-210
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028974367184266240;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028974367184266240','address2','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 210);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V3';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V3','1028974367184266240','zh_CN','自定义地址字段2',' ');


-- 1028974367184266241-address3-自定义地址字段3-文本+ -0-220
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028974367184266241;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028974367184266241','address3','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 220);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V4';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V4','1028974367184266241','zh_CN','自定义地址字段3',' ');


-- 1028974367184266242-address4-自定义地址字段4-文本+ -0-230
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028974367184266242;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028974367184266242','address4','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 230);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V5';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V5','1028974367184266242','zh_CN','自定义地址字段4',' ');


-- 1028974367184266243-address5-自定义地址字段5-文本+ -0-240
DELETE FROM T_CTS_ADDRPRECONFIG WHERE FID = 1028974367184266243;
insert into `t_cts_addrpreconfig` (`FID`, `FNUMBER`, `FType`, `FBaseType`, `FAdminLevel`, `FCREATORID`, `FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`, `FSEQ`)
values('1028974367184266243','address5','1',' ',0,'1',{ts'2020-11-20 09:00:00'},'1',{ts'2020-11-20 09:00:00'},'0',NULL, 240);

DELETE FROM T_CTS_ADDRPRECONFIG_L WHERE FPKID = '17CPHOP//8V6';
insert into `t_cts_addrpreconfig_l` (`FPKID`,`FID`, `FLOCALEID`, `FNAME`, `FDESCRIPTION`) values('17CPHOP//8V6','1028974367184266243','zh_CN','自定义地址字段5',' ');

