
--  更新历史行政级次的fname

update t_bd_admindivisionlevel set fname = '区、特别行政区' where fname = '市' and fid =  804182102504381440;
update t_bd_admindivisionlevel set fname = '首都、州、州级市' where fname = '市' and fid =  804182107260721152;
update t_bd_admindivisionlevel set fname = '直辖市、省' where fname = '市' and fid =  804182101657132032;
update t_bd_admindivisionlevel set fname = '地区' where fname = '市' and fid =  804182109391428608;
update t_bd_admindivisionlevel set fname = '省' where fname = '市' and fid =  804182104400206848;
update t_bd_admindivisionlevel set fname = '首都、省' where fname = '市' and fid =  804182105020963840;
update t_bd_admindivisionlevel set fname = '联邦区、州' where fname = '市' and fid =  804182106639964160;
update t_bd_admindivisionlevel set fname = '首都联邦区、省、邦' where fname = '市' and fid =  804182108284132352;
update t_bd_admindivisionlevel set fname = '联邦区、州' where fname = '市' and fid =  804182100155571200;
update t_bd_admindivisionlevel set fname = '联邦区、州' where fname = '市' and fid =  804182109097826304;
update t_bd_admindivisionlevel set fname = '区' where fname = '市' and fid =  804182109752138752;
update t_bd_admindivisionlevel set fname = '直辖市、省' where fname = '市' and fid =  804182110926543872;
update t_bd_admindivisionlevel set fname = '邦、中央直辖区、国家首都区' where fname = '市' and fid =  804182111111092224;
update t_bd_admindivisionlevel set fname = '地理区' where fname = '市' and fid =  804182112327441408;
update t_bd_admindivisionlevel set fname = '地区' where fname = '市' and fid =  804182113602509824;
update t_bd_admindivisionlevel set fname = '酋长国' where fname = '市' and fid =  804182113988385792;

update t_bd_admindivisionlevel_l set fname = '区、特别行政区' where fname = '市' and fid =  804182102504381440 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '首都、州、州级市' where fname = '市' and fid =  804182107260721152 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '直辖市、省' where fname = '市' and fid =  804182101657132032 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '地区' where fname = '市' and fid =  804182109391428608 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '省' where fname = '市' and fid =  804182104400206848 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '首都、省' where fname = '市' and fid =  804182105020963840 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '联邦区、州' where fname = '市' and fid =  804182106639964160 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '首都联邦区、省、邦' where fname = '市' and fid =  804182108284132352 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '联邦区、州' where fname = '市' and fid =  804182100155571200 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '联邦区、州' where fname = '市' and fid =  804182109097826304 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '区' where fname = '市' and fid =  804182109752138752 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '直辖市、省' where fname = '市' and fid =  804182110926543872 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '邦、中央直辖区、国家首都区' where fname = '市' and fid =  804182111111092224 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '地理区' where fname = '市' and fid =  804182112327441408 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '地区' where fname = '市' and fid =  804182113602509824 and flocaleid = 'zh_CN';
update t_bd_admindivisionlevel_l set fname = '酋长国' where fname = '市' and fid =  804182113988385792 and flocaleid = 'zh_CN';

-- 删除历史执行
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840505849652113408;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840497291760031744;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840498845263124480;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840501439473702912;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840496860627523584;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840493226749646848;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840495447736250368;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840497719002198016;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840498081539086336;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840499593109499904;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840499959278655488;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840500308053782528;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840500684264101888;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840501093378486272;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840504696134627328;
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1839771476495867904;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840505849652113408;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840497291760031744;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840498845263124480;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840501439473702912;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840496860627523584;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840493226749646848;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840495447736250368;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840497719002198016;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840498081539086336;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840499593109499904;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840499959278655488;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840500308053782528;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840500684264101888;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840501093378486272;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840504696134627328;
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1839771476495867904;


-- 如果历史行政级次不存在，则执行预置的行政级次数据

IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182102504381440) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840505849652113408;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182102504381440)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840505849652113408,804166864178518016,NULL,1840505849652113408,0,'C','0','区、特别行政区','TL001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182107260721152) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840497291760031744;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182107260721152)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840497291760031744,804166864337902593,NULL,1840497291760031744,0,'C','0','首都、州、州级市','HU001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182101657132032) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840498845263124480;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182101657132032)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840498845263124480,804166864144963585,NULL,1840498845263124480,0,'C','0','直辖市、省','KH001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109391428608) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840501439473702912;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109391428608)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840501439473702912,804166864405010432,NULL,1840501439473702912,0,'C','0','地区','PH001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182104400206848) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840496860627523584;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182104400206848)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840496860627523584,804166864245626880,NULL,1840496860627523584,0,'C','0','省','EG001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182105020963840) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840500308053782528;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182105020963840)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840500308053782528,804166864262404097,NULL,1840500308053782528,0,'C','0','首都、省','MN001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182106639964160) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840500684264101888;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182106639964160)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840500684264101888,804166864321125376,NULL,1840500684264101888,0,'C','0','联邦区、州','MX001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182108284132352) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840499959278655488;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182108284132352)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840499959278655488,804166864363067393,NULL,1840499959278655488,0,'C','0','首都联邦区、省、邦','MM001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182100155571200) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1762238634435560448;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182100155571200)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1762238634435560448,804166862903449600,NULL,1762238634435560448,0,'C','0','联邦区、州','BR001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109097826304) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840501093378486272;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109097826304)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840501093378486272,804166864388234241,NULL,1840501093378486272,0,'C','0','联邦区、州','MY001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109752138752) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840493226749646848;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109752138752)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840493226749646848,804166864413399040,NULL,1840493226749646848,0,'C','0','区','BN001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182110926543872) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840499593109499904;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182110926543872)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840499593109499904,804166864438564865,NULL,1840499593109499904,0,'C','0','直辖市、省','LA001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182111111092224) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840498081539086336;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182111111092224)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840498081539086336,804166864446954496,NULL,1840498081539086336,0,'C','0','邦、中央直辖区、国家首都区','IN001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182112327441408) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840497719002198016;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182112327441408)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840497719002198016,804166864480507905,NULL,1840497719002198016,0,'C','0','地理区','ID001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113602509824) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1840504696134627328;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113602509824)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1840504696134627328,804166864514062338,NULL,1840504696134627328,0,'C','0','地区','SA001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113988385792) 
DELETE FROM t_bd_admindivisionlevel WHERE FID = 1839771476495867904;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113988385792)
INSERT INTO t_bd_admindivisionlevel(FID,FCOUNTRYID,FDISABLEDATE,FMASTERID,FPARENTID,FSTATUS,FISCITY,FNAME,FNUMBER,FCREATETIME,FISLEAF,FMODIFIERID,FENABLE,FMODIFYTIME,FLEVEL,FCREATORID,FLONGNUMBER,FDISABLERID,FISSYSTEM) VALUES (1839771476495867904,804166864530839552,NULL,1839771476495867904,0,'C','0','酋长国','AE001',{ts'2023-12-26  00:00:00'},'0',1,'1',{ts'2023-12-26  00:00:00'},1,1,' ',0,'1'); 


IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182102504381440) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840505849652113408;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182102504381440)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840505849652113408,'3S1OLN+LLUWZ','zh_CN',' ',' ',' ','区、特别行政区'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182107260721152) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840497291760031744;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182107260721152)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840497291760031744,'3S1N/9X4W7J1','zh_CN',' ',' ',' ','首都、州、州级市'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182101657132032) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840498845263124480;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182101657132032)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840498845263124480,'3S1N=LDHCKFU','zh_CN',' ',' ',' ','直辖市、省'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109391428608) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840501439473702912;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109391428608)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840501439473702912,'3S1NSHNB83V3','zh_CN',' ',' ',' ','地区'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182104400206848) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840496860627523584;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182104400206848)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840496860627523584,'3S1MY4CLDTT4','zh_CN',' ',' ',' ','省'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182105020963840) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840500308053782528;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182105020963840)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840500308053782528,'3S1NK93D3RJ3','zh_CN',' ',' ',' ','首都、省'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182106639964160) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840500684264101888;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182106639964160)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840500684264101888,'3S1NN//WAG+D','zh_CN',' ',' ',' ','联邦区、州'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182108284132352) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840499959278655488;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182108284132352)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840499959278655488,'3S1NHQ+L8KKD','zh_CN',' ',' ',' ','首都联邦区、省、邦'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182100155571200) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1762238634435560448;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182100155571200)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1762238634435560448,'3IFPPT5EKDVM','zh_CN',' ',' ',' ','联邦区、州'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109097826304) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840501093378486272;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109097826304)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840501093378486272,'3S1NQ+=Q3D5C','zh_CN',' ',' ',' ','联邦区、州'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109752138752) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840493226749646848;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182109752138752)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840493226749646848,'3S1M8NPG20=5','zh_CN',' ',' ',' ','区'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182110926543872) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840499593109499904;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182110926543872)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840499593109499904,'3S1NF0Y=SFIF','zh_CN',' ',' ',' ','直辖市、省'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182111111092224) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840498081539086336;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182111111092224)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840498081539086336,'3S1N50BO0H1L','zh_CN',' ',' ',' ','邦、中央直辖区、国家首都区'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182112327441408) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840497719002198016;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182112327441408)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840497719002198016,'3S1N2DAQ9JM7','zh_CN',' ',' ',' ','地理区'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113602509824) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1840504696134627328;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113602509824)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1840504696134627328,'3S1OD85ORONI','zh_CN',' ',' ',' ','地区'); 
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113988385792) 
DELETE FROM t_bd_admindivisionlevel_l WHERE FID = 1839771476495867904;
IF NOT EXISTS (SELECT 1 FROM t_bd_admindivisionlevel WHERE FID = 804182113988385792)
INSERT INTO t_bd_admindivisionlevel_l(FID,FPKID,FLOCALEID,FDISPLAYNAME,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1839771476495867904,'3S+5DDKHXKE6','zh_CN',' ',' ',' ','酋长国'); 


