Project

General

Profile

1 11495 psarando
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;