|
1
|
BEGIN;
|
|
2
|
|
|
3
|
--
|
|
4
|
-- insert additional custom name-scrub mappings
|
|
5
|
--
|
|
6
|
|
|
7
|
-- add some custom country alternate names that we need
|
|
8
|
INSERT INTO alt_country
|
|
9
|
(country, alternatename)
|
|
10
|
VALUES
|
|
11
|
('Central African Republic', 'Central African Repu')
|
|
12
|
, ('British Virgin Islands', 'Virgin Islands (U.K.)')
|
|
13
|
, ('Democratic Republic of the Congo', 'Congo, The Democratic Republic of the')
|
|
14
|
, ('Falkland Islands', 'Falkland Isl')
|
|
15
|
, ('Falkland Islands', 'Falkland Islands (Malvinas)')
|
|
16
|
, ('Faroe Islands', 'Faeroe Isl.')
|
|
17
|
, ('French Guiana', 'Guyana Francesa')
|
|
18
|
, ('Iran', 'Iran, Islamic Republic of')
|
|
19
|
, ('Mexico', E'Mexico\rMexico')
|
|
20
|
, ('Nicaragua', 'Ncaragua')
|
|
21
|
, ('Norfolk Island', 'Norfolk Isl')
|
|
22
|
, ('North Korea', 'Korea, Democratic People''s Republic of')
|
|
23
|
, ('Solomon Islands', 'Solomon Isl')
|
|
24
|
, ('South Georgia and the South Sandwich Islands', 'South Georgia and the South Sand')
|
|
25
|
, ('South Korea', 'Korea (Republic of)')
|
|
26
|
, ('South Korea', 'Korea, Republic of')
|
|
27
|
, ('U.S. Virgin Islands', 'US Virgin Islands')
|
|
28
|
, ('U.S. Virgin Islands', 'Virgin Islands (U.S.)')
|
|
29
|
, ('United States', 'ESTADOS UNIDOS DE AMERICA')
|
|
30
|
, ('United States', 'EUA')
|
|
31
|
, ('Vietnam', 'VIETNAM [Socialist Republic of V')
|
|
32
|
;
|
|
33
|
|
|
34
|
COMMIT;
|
|
35
|
|
