BEGIN;

--

-- insert additional custom name-scrub mappings

--

-- add some custom country alternate names that we need

INSERT INTO alt_country

    (country, alternatename)

    VALUES

    ('Central African Republic', 'Central African Repu')

  , ('British Virgin Islands', 'Virgin Islands (U.K.)')

  , ('Democratic Republic of the Congo', 'Congo, The Democratic Republic of the')

  , ('Falkland Islands', 'Falkland Isl')

  , ('Falkland Islands', 'Falkland Islands (Malvinas)')

  , ('Faroe Islands', 'Faeroe Isl.')

  , ('French Guiana', 'Guyana Francesa')

  , ('Iran', 'Iran, Islamic Republic of')

  , ('Mexico', E'Mexico\rMexico')

  , ('Nicaragua', 'Ncaragua')

  , ('Norfolk Island', 'Norfolk Isl')

  , ('North Korea', 'Korea, Democratic People''s Republic of')

  , ('Solomon Islands', 'Solomon Isl')

  , ('South Georgia and the South Sandwich Islands', 'South Georgia and the South Sand')

  , ('South Korea', 'Korea (Republic of)')

  , ('South Korea', 'Korea, Republic of')

  , ('U.S. Virgin Islands', 'US Virgin Islands')

  , ('U.S. Virgin Islands', 'Virgin Islands (U.S.)')

  , ('United States', 'ESTADOS UNIDOS DE AMERICA')

  , ('United States', 'EUA')

  , ('Vietnam', 'VIETNAM [Socialist Republic of V')

;

COMMIT;