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;

