
-- 新增国家地区预置数据版本信息及多语言信息


DELETE FROM T_BD_PRESET_VERSION WHERE FID = 1073001332698305539;
INSERT INTO T_BD_PRESET_VERSION(FID,FCREATETIME,FSOURCE,FVERSIONNUM,FISSENDTOADMIN,FCREATORID,FISUPDATE) VALUES (1073001332698305539,{ts'2023-08-10 12:00:00'},'bd_country','country-202308-10','0',1,'0'); 


DELETE FROM T_BD_PRESET_VERSION_L WHERE FPKID = '1BSMOBEUE9SD';
INSERT INTO T_BD_PRESET_VERSION_L(FID,FPKID,FLOCALEID,FGUIDEINFO) VALUES (1073001332698305539,'1BSMOBEUE9SD','zh_CN',
'<p>本更新基于《GB_T 2659.1-2022 世界各国和地区及其行政区划名称代码 第1部分：国家和地区代码》较之前版本更新内容主要如下：
<p style="text-indent: 2em">1. 更新若干国家或地区的简称；
<p style="text-indent: 2em">2. 更新若干国家或地区的全称；</p>
请根据您的实际使用情况和当前数据，使用本向导查阅更新内容并自主选择要更新的数据执行操作。');



-- 1.更新国家和地区预置数据中文名称/中文全称 45条

update t_bd_country_preset set fname = '委内瑞拉玻利瓦尔共和国', ffullname = '委内瑞拉玻利瓦尔共和国' where fid = 804166864136576000;
update t_bd_country_preset_l set fname = '委内瑞拉玻利瓦尔共和国', ffullname = '委内瑞拉玻利瓦尔共和国' where  fid = 804166864136576000 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '波斯尼亚和黑塞哥维那' where fid = 804166864178519040;
update t_bd_country_preset_l set fname = '波斯尼亚和黑塞哥维那' where  fid = 804166864178519040 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '圣基茨和尼维斯' where fid = 804166864186907649;
update t_bd_country_preset_l set ffullname = '圣基茨和尼维斯' where  fid = 804166864186907649 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '巴林王国' where fid = 804166864195296256;
update t_bd_country_preset_l set ffullname = '巴林王国' where  fid = 804166864195296256 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '科摩罗联盟' where fid = 804166864220461056;
update t_bd_country_preset_l set ffullname = '科摩罗联盟' where  fid = 804166864220461056 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '索马里联邦共和国' where fid = 804166864245627904;
update t_bd_country_preset_l set ffullname = '索马里联邦共和国' where  fid = 804166864245627904 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '利比亚国' where fid = 804166864245627905;
update t_bd_country_preset_l set ffullname = '利比亚国' where  fid = 804166864245627905 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '多米尼加' where fid = 804166864245627906;
update t_bd_country_preset_l set fname = '多米尼加' where  fid = 804166864245627906 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '蒙古国' where fid = 804166864262404097;
update t_bd_country_preset_l set fname = '蒙古国' where  fid = 804166864262404097 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '福克兰群岛(又称马尔维纳斯群岛)', ffullname = '福克兰群岛(又称马尔维纳斯群岛)' where fid = 804166864270793728;
update t_bd_country_preset_l set fname = '福克兰群岛(又称马尔维纳斯群岛)', ffullname = '福克兰群岛(又称马尔维纳斯群岛)' where  fid = 804166864270793728 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '巴勒斯坦国' where fid = 804166864270793729;
update t_bd_country_preset_l set fname = '巴勒斯坦国' where  fid = 804166864270793729 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '圣赫勒拿-阿森松-特里斯坦-达库尼亚', ffullname = '圣赫勒拿-阿森松-特里斯坦-达库尼亚' where fid = 804166864304347137;
update t_bd_country_preset_l set fname = '圣赫勒拿-阿森松-特里斯坦-达库尼亚', ffullname = '圣赫勒拿-阿森松-特里斯坦-达库尼亚' where  fid = 804166864304347137 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '阿富汗伊斯兰共和国' where fid = 804166864329512960;
update t_bd_country_preset_l set ffullname = '阿富汗伊斯兰共和国' where  fid = 804166864329512960 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '俄罗斯' where fid = 804166864346291200;
update t_bd_country_preset_l set fname = '俄罗斯' where  fid = 804166864346291200 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '科科斯(基灵)群岛', ffullname = '科科斯(基灵)群岛' where fid = 804166864354678784;
update t_bd_country_preset_l set fname = '科科斯(基灵)群岛', ffullname = '科科斯(基灵)群岛' where  fid = 804166864354678784 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '瑞典' where fid = 804166864354678785;
update t_bd_country_preset_l set ffullname = '瑞典' where  fid = 804166864354678785 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '北马其顿', ffullname = '北马其顿共和国' where fid = 804166864363067392;
update t_bd_country_preset_l set fname = '北马其顿', ffullname = '北马其顿共和国' where  fid = 804166864363067392 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '中非共和国' where fid = 804166864363068416;
update t_bd_country_preset_l set fname = '中非共和国' where  fid = 804166864363068416 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '巴哈马国' where fid = 804166864396621824;
update t_bd_country_preset_l set ffullname = '巴哈马国' where  fid = 804166864396621824 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '密克罗尼西亚' where fid = 804166864396622849;
update t_bd_country_preset_l set fname = '密克罗尼西亚' where  fid = 804166864396622849 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '文莱达鲁萨兰国' where fid = 804166864413399040;
update t_bd_country_preset_l set ffullname = '文莱达鲁萨兰国' where  fid = 804166864413399040 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '塞尔维亚共和国' where fid = 804166864505673728;
update t_bd_country_preset_l set ffullname = '塞尔维亚共和国' where  fid = 804166864505673728 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '特克斯和凯科斯群岛' where fid = 804166864514063361;
update t_bd_country_preset_l set fname = '特克斯和凯科斯群岛' where  fid = 804166864514063361 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '南苏丹共和国' where fid = 804166864522450944;
update t_bd_country_preset_l set ffullname = '南苏丹共和国' where  fid = 804166864522450944 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '多民族玻利维亚国' where fid = 804166864522450945;
update t_bd_country_preset_l set ffullname = '多民族玻利维亚国' where  fid = 804166864522450945 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '圣马丁(荷兰属)', ffullname = '圣马丁(荷兰属)' where fid = 804166864530839553;
update t_bd_country_preset_l set fname = '圣马丁(荷兰属)', ffullname = '圣马丁(荷兰属)' where  fid = 804166864530839553 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '安圭拉岛(英)', ffullname = '安圭拉岛(英)' where fid = 804166864556005376;
update t_bd_country_preset_l set fname = '安圭拉岛(英)', ffullname = '安圭拉岛(英)' where  fid = 804166864556005376 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '冈比亚' where fid = 804166864564393985;
update t_bd_country_preset_l set fname = '冈比亚' where  fid = 804166864564393985 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '奥兰群岛(芬兰自治省)', ffullname = '奥兰群岛(芬兰自治省)' where fid = 1063655077895497728;
update t_bd_country_preset_l set fname = '奥兰群岛(芬兰自治省)', ffullname = '奥兰群岛(芬兰自治省)' where  fid = 1063655077895497728 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '博奈尔岛、圣尤斯特歇斯岛和萨巴岛', ffullname = '博奈尔岛、圣尤斯特歇斯岛和萨巴岛' where fid = 1063655077912275969;
update t_bd_country_preset_l set fname = '博奈尔岛、圣尤斯特歇斯岛和萨巴岛', ffullname = '博奈尔岛、圣尤斯特歇斯岛和萨巴岛' where  fid = 1063655077912275969 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '布韦岛', ffullname = '布韦岛' where fid = 1063655077912274945;
update t_bd_country_preset_l set fname = '布韦岛', ffullname = '布韦岛' where  fid = 1063655077912274945 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '英属印度洋领地', ffullname = '英属印度洋领地' where fid = 1063655077912275970;
update t_bd_country_preset_l set fname = '英属印度洋领地', ffullname = '英属印度洋领地' where  fid = 1063655077912275970 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '法属南部领地', ffullname = '法属南部领地' where fid = 1063655077912275971;
update t_bd_country_preset_l set fname = '法属南部领地', ffullname = '法属南部领地' where  fid = 1063655077912275971 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '根西岛', ffullname = '根西岛' where fid = 1063655077912275972;
update t_bd_country_preset_l set fname = '根西岛', ffullname = '根西岛' where  fid = 1063655077912275972 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '赫德岛和麦克唐纳群岛 ', ffullname = '赫德岛和麦克唐纳群岛 ' where fid = 1063655077912274948;
update t_bd_country_preset_l set fname = '赫德岛和麦克唐纳群岛 ', ffullname = '赫德岛和麦克唐纳群岛 ' where  fid = 1063655077912274948 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '泽西岛', ffullname = '泽西岛' where fid = 1063655077920664577;
update t_bd_country_preset_l set fname = '泽西岛', ffullname = '泽西岛' where  fid = 1063655077920664577 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '北马里亚纳群岛' where fid = 1063655077920663554;
update t_bd_country_preset_l set fname = '北马里亚纳群岛' where  fid = 1063655077920663554 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '皮特凯恩岛', ffullname = '皮特凯恩岛' where fid = 1063655077920664579;
update t_bd_country_preset_l set fname = '皮特凯恩岛', ffullname = '皮特凯恩岛' where  fid = 1063655077920664579 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '圣马丁(法属)', ffullname = '圣马丁(法属)' where fid = 1063655077920664580;
update t_bd_country_preset_l set fname = '圣马丁(法属)', ffullname = '圣马丁(法属)' where  fid = 1063655077920664580 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '南乔治亚岛和南桑威奇群岛', ffullname = '南乔治亚岛和南桑威奇群岛' where fid = 1063655077920664581;
update t_bd_country_preset_l set fname = '南乔治亚岛和南桑威奇群岛', ffullname = '南乔治亚岛和南桑威奇群岛' where  fid = 1063655077920664581 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '斯瓦尔巴和扬马延', ffullname = '斯瓦尔巴和扬马延' where fid = 1063655077920663557;
update t_bd_country_preset_l set fname = '斯瓦尔巴和扬马延', ffullname = '斯瓦尔巴和扬马延' where  fid = 1063655077920663557 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '香港(中国特别行政区)', ffullname = '中国香港特别行政区' where fid = 1000003;
update t_bd_country_preset_l set fname = '香港(中国特别行政区)', ffullname = '中国香港特别行政区' where  fid = 1000003 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '澳门(中国特别行政区)', ffullname = '中国澳门特别行政区' where fid = 1000004;
update t_bd_country_preset_l set fname = '澳门(中国特别行政区)', ffullname = '中国澳门特别行政区' where  fid = 1000004 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set fname = '台湾(中国的省)', ffullname = '台湾(中国的省)' where fid = 1000005;
update t_bd_country_preset_l set fname = '台湾(中国的省)', ffullname = '台湾(中国的省)' where  fid = 1000005 and flocaleid = 'zh_CN' ;
update t_bd_country_preset set ffullname = '日本国' where fid = 1000009;
update t_bd_country_preset_l set ffullname = '日本国' where  fid = 1000009 and flocaleid = 'zh_CN' ;













