DELETE FROM t_bd_preset_version WHERE FID = 100002;
INSERT INTO t_bd_preset_version(FID,FCREATORID,FISSENDTOADMIN,FSOURCE,FVERSIONNUM,FCREATETIME,FISUPDATE) VALUES (100002,1,'0','bd_admindivision','admindivision-202308-14',{ts'2023-08-14 00:00:00'},'0'); 

DELETE FROM t_bd_preset_version_l WHERE FPKID = '100002';
INSERT INTO t_bd_preset_version_l(FID,FPKID,FLOCALEID,FGUIDEINFO) VALUES (100002,'100002','zh_CN','<p>本更新基于中华人民共和国民政部于2023年4月3日发布的行政区划数据（县级及以上）。较之前版本，更新内容主要如下：<p style="text-indent: 2em">1. 修正部分更名的行政区划或区划代码（2条），西藏自治区撤销错那县设立县级错那市，西藏自治区撤销米林县设立县级米林市<p style="text-indent: 2em">2. 新增行政区划（1条），新疆维吾尔自治区设立县级白杨市 </p> 请根据您的实际使用情况和当前数据，使用本向导查阅更新内容并自主选择要更新的数据执行操作。'); 

-- 区划代码前四位、省、市、县(第一个字)相同区划代码更新  更新fareacode、fname、ffullname、fdescription、ffullspell、fsimplespell,需要人工确认,尤其全拼，简拼 
UPDATE  T_BD_ADMINDIVISIONPRE SET FAREACODE = '540481',FNAME = '米林市',FFULLNAME = '西藏自治区_林芝市_米林市',FDESCRIPTION = '米林',FFULLSPELL = 'Milin City',FSIMPLESPELL = 'MLS' WHERE FID = 3387;
UPDATE  T_BD_ADMINDIVISIONPRE_L SET FNAME='米林市',FFULLNAME='西藏自治区_林芝市_米林市',FDESCRIPTION='米林' WHERE FID = 3387 AND FLOCALEID = 'zh_CN';
UPDATE  T_BD_ADMINDIVISIONPRE SET FAREACODE = '540581',FNAME = '错那市',FFULLNAME = '西藏自治区_山南市_错那市',FDESCRIPTION = '错那',FFULLSPELL = 'Cona City',FSIMPLESPELL = 'CNS' WHERE FID = 3342;
UPDATE  T_BD_ADMINDIVISIONPRE_L SET FNAME='错那市',FFULLNAME='西藏自治区_山南市_错那市',FDESCRIPTION='错那' WHERE FID = 3342 AND FLOCALEID = 'zh_CN';

-- 新增行政区划数据 
DELETE FROM T_BD_ADMINDIVISIONPRE WHERE FID = 98317;
INSERT INTO T_BD_ADMINDIVISIONPRE(FFULLSPELL,FCOUNTRYID,FDESCRIPTION,FMASTERID,FADMINDIVISIONLVID,FCREATETIME,FAREACODE,FENABLE,FLEVEL,FLONGNUMBER,FFULLNAME,FISSYSTEM,FDISABLERID,FID,FCITYNUMBER,FDISABLEDATE,FPARENTID,FISCITY,FSTATUS,FNUMBER,FNAME,FISLEAF,FMODIFIERID,FMODIFYTIME,FSIMPLESPELL,FCREATORID)VALUES ('Baiyang City',1000001,'白杨',98317,2,{ts'2023-08-07 17:22:17'},'659012','1',2,'003152.659012','新疆维吾尔自治区_白杨市','1',0,98317,' ',NULL,3152,'1','C','659012','白杨市','1',0,{ts'2023-08-07 17:22:17'},'BYS',1); 
DELETE FROM T_BD_ADMINDIVISIONPRE_L WHERE FPKID  = '98316';
INSERT INTO T_BD_ADMINDIVISIONPRE_L(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (98317,'98316','白杨市',' ','新疆维吾尔自治区_白杨市','白杨','zh_CN');