Skip to content

Instantly share code, notes, and snippets.

@fiee
Last active July 17, 2023 14:04
Show Gist options
  • Save fiee/259744 to your computer and use it in GitHub Desktop.
Save fiee/259744 to your computer and use it in GitHub Desktop.
table of information about all countries of the world (German names)
CREATE TABLE adressen.land
(
isocode_2 character(2) not null, -- ISO 3166 ALPHA-2
isocode_3 character(3) not null, -- ISO 3166 ALPHA-3
name character varying not null, -- deutscher Name des Landes (international besser via ISO-Code ankoppeln!) // German name of the country
vorwahl integer default null, -- internationale Vorwahl // international phone code
null_bei_vorwahl boolean default FALSE, -- muss man die Null der Ortsvorwahl auch nach der internationalen Vorwahl wählen? // must one dial zero between international and local phone code?
vorwahl_lokal boolean default FALSE, -- muss man vor Ort die Vorwahl wählen? // must one dial the local phone code also locally?
tld character varying default NULL, -- Top Level Domain
kfz character varying default NULL, -- KFZ-Kennzeichen // car code
laenge_plz integer default NULL, -- maximale Länge inkl. Trennzeichen // length of ZIP
regex_plz character varying default NULL, -- regulärer Ausdruck zur Prüfung der PLZ / regular expression to test the ZIP
ausblenden boolean default FALSE, -- interne Markierung // internal mark "unimportant country"
geaendert timestamp with time zone DEFAULT current_timestamp, // change date
CONSTRAINT land_pkey PRIMARY KEY (isocode_2),
CONSTRAINT land_isocode3 UNIQUE (isocode_3)
)
WITH (
OIDS=TRUE
);
#ALTER TABLE adressen.land OWNER TO postgres;
COMMENT ON TABLE adressen.land IS 'Informationen über Länder.';
begin;
insert into adressen.land
(isocode_2, isocode_3, name, vorwahl, null_bei_vorwahl, vorwahl_lokal, tld, kfz, laenge_plz, regex_plz, ausblenden, geaendert)
values
('AC','ASC','Ascension',247,FALSE,FALSE,'ac','GB',8,'ASCN \\d\\w{2}',TRUE,NOW()),
('AD','AND','Andorra',376,FALSE,FALSE,'ad','AND',NULL,NULL,FALSE,NOW()),
('AE','ARE','Vereinigte Arabische Emirate',971,FALSE,FALSE,'ae','UAE',0,NULL,FALSE,NOW()),
('AF','AFG','Afghanistan',93,FALSE,FALSE,'af','AFG',0,NULL,FALSE,NOW()),
('AG','ATG','Antigua und Barbuda',1268,FALSE,FALSE,'ag','AG',0,NULL,FALSE,NOW()),
('AI','AIA','Anguilla',1264,FALSE,FALSE,'ai','AXA',NULL,NULL,FALSE,NOW()),
('AL','ALB','Albanien',355,FALSE,FALSE,'al','AL',0,NULL,FALSE,NOW()),
('AM','ARM','Armenien',374,FALSE,FALSE,'am','ARM',6,'\\d{6}',FALSE,NOW()),
-- ('AN','ANT','Niederländische Antillen',599,FALSE,FALSE,'an','AN',NULL,NULL,FALSE,NOW()), -- obsolete since 2010-10-10; 599 = Curaçao
('AO','AGO','Angola',244,FALSE,FALSE,'ao','ANG',0,NULL,FALSE,NOW()),
('AQ','ATA','Antarktis',NULL,FALSE,FALSE,'aq',NULL,NULL,NULL,TRUE,NOW()),
('AR','ARG','Argentinien',54,FALSE,FALSE,'ar','RA',8,'\\w\\d{4}\\w{3}',FALSE,NOW()),
('AS','ASM','Amerikanisch-Samoa',1684,FALSE,FALSE,'as','USA',10,NULL,TRUE,NOW()),
('AT','AUT','Österreich',43,FALSE,FALSE,'at','A',4,'\\d{4}',FALSE,NOW()),
('AU','AUS','Australien',61,FALSE,FALSE,'au','AUS',4,'\\d{4}',FALSE,NOW()),
('AW','ABW','Aruba',297,FALSE,FALSE,'aw','ARU',NULL,NULL,FALSE,NOW()),
('AX','ALA','Åland',35818,FALSE,FALSE,'ax','AX',NULL,NULL,FALSE,NOW()), -- zu Finnland
('AZ','AZE','Aserbaidschan',994,FALSE,FALSE,'az','AZ',6,'\\d{6}',FALSE,NOW()),
('BA','BIH','Bosnien und Herzegowina',387,FALSE,FALSE,'ba','BIH',5,'\\d{5}',FALSE,NOW()),
('BB','BRB','Barbados',1246,FALSE,FALSE,'bb','BDS',0,NULL,FALSE,NOW()),
('BD','BGD','Bangladesch',880,FALSE,FALSE,'bd','BD',4,'\\d{4}',FALSE,NOW()),
('BE','BEL','Belgien',32,FALSE,TRUE,'be','B',4,'\\d{4}',FALSE,NOW()),
('BF','BFA','Burkina Faso',226,FALSE,FALSE,'bf','BF',0,NULL,FALSE,NOW()),
('BG','BGR','Bulgarien',359,FALSE,FALSE,'bg','BG',4,'\\d{4}',FALSE,NOW()),
('BH','BHR','Bahrain',973,FALSE,FALSE,'bh','BRN',4,'\\d{3,4}',FALSE,NOW()),
('BI','BDI','Burundi',257,FALSE,FALSE,'bi','RU',NULL,NULL,FALSE,NOW()),
('BJ','BEN','Benin',229,FALSE,FALSE,'bj','BJ',0,NULL,FALSE,NOW()),
('BL','BLM','Saint-Barthélemy',590,FALSE,FALSE,'bl',NULL,NULL,NULL,TRUE,NOW()), -- TLD also fr, gp
('BM','BMU','Bermuda',1241,FALSE,FALSE,'bm',NULL,5,'\\w{2} [\\d\\w]{2}',TRUE,NOW()),
('BN','BRN','Brunei',673,FALSE,FALSE,'bn','BRU',6,'\\w{2}\\d{4}',FALSE,NOW()),
('BO','BOL','Bolivien',591,FALSE,FALSE,'bo','BOL',0,NULL,FALSE,NOW()),
('BR','BRA','Brasilien',55,FALSE,FALSE,'br','BR',8,'\\d{5}-\\d{3}',FALSE,NOW()),
('BS','BHS','Bahamas',1242,FALSE,FALSE,'bs','BS',0,NULL,FALSE,NOW()),
('BT','BTN','Bhutan',975,FALSE,FALSE,'bt','BHT',0,NULL,FALSE,NOW()),
('BV','BVT','Bouvetinsel',NULL,FALSE,FALSE,'bv',NULL,NULL,NULL,TRUE,NOW()), -- not inhabited, Norway
('BW','BWA','Botswana',267,FALSE,FALSE,'bw','RB',0,NULL,FALSE,NOW()),
('BY','BLR','Belarus',375,FALSE,FALSE,'by','BY',6,'\\d{6}',FALSE,NOW()),
('BZ','BLZ','Belize',501,FALSE,FALSE,'bz','BZ',0,NULL,FALSE,NOW()),
('CA','CAN','Kanada',1,FALSE,FALSE,'ca','CDN',7,'[ABCEGHJKLMNPRSTVXY]\\d\\w \\d\\w\\d',FALSE,NOW()),
('CC','CCK','Kokosinseln',61,FALSE,FALSE,'cc','AUS',4,NULL,TRUE,NOW()),
('CD','COD','Kongo, Demokratische Republik (ehem. Zaire)',243,FALSE,FALSE,'cd',NULL,0,NULL,TRUE,NOW()),
('CF','CAF','Zentralafrikanische Republik',236,FALSE,FALSE,'cf',NULL,0,NULL,TRUE,NOW()),
('CG','COG','Republik Kongo',242,FALSE,FALSE,'cg','RCB',NULL,NULL,FALSE,NOW()),
('CH','CHE','Schweiz',41,FALSE,TRUE,'ch','CH',4,'\\d{4}',FALSE,NOW()),
('CI','CIV','Côte d''Ivoire (Elfenbeinküste)',225,FALSE,FALSE,'ci','CI',NULL,NULL,FALSE,NOW()),
('CK','COK','Cookinseln',682,FALSE,FALSE,'ck',NULL,NULL,NULL,TRUE,NOW()),
('CL','CHL','Chile',56,FALSE,FALSE,'cl','RCH',7,'(\\d{7})?',FALSE,NOW()),
('CM','CMR','Kamerun',237,FALSE,FALSE,'cm','CAM',0,NULL,FALSE,NOW()),
('CN','CHN','China, Volksrepublik',86,FALSE,FALSE,'cn','RC',6,'\\d{6}',FALSE,NOW()),
('CO','COL','Kolumbien',57,FALSE,FALSE,'co','CO',0,NULL,FALSE,NOW()),
('CR','CRI','Costa Rica',506,FALSE,FALSE,'cr','CR',4,'\\d{4}',FALSE,NOW()),
('CU','CUB','Kuba',53,FALSE,FALSE,'cu','C',8,'CP \\d{5}',FALSE,NOW()),
('CV','CPV','Kap Verde',238,FALSE,FALSE,'cv','CV',4,'\\d{4}',FALSE,NOW()),
('CW','CUW','Curaçao',5999,FALSE,FALSE,'cw','NA',0,'',FALSE,NOW()), -- postcode might be like NL, didn’t find any; TLD still also .na
('CX','CXR','Weihnachtsinsel',61,FALSE,FALSE,'cx','AUS',4,NULL,TRUE,NOW()),
('CY','CYP','Zypern',357,FALSE,FALSE,'cy','CY',4,'\\d{4}',FALSE,NOW()),
('CZ','CZE','Tschechien',420,FALSE,TRUE,'cz','CZ',6,'[1-7]\\d{2} \\d{2}',FALSE,NOW()),
('DE','DEU','Deutschland',49,FALSE,FALSE,'de','D',5,'\\d{5}',FALSE,NOW()),
('DJ','DJI','Dschibuti',253,FALSE,FALSE,'dj','DJI',0,NULL,FALSE,NOW()),
('DK','DNK','Dänemark',45,FALSE,TRUE,'dk','DK',4,'\\d{4}',FALSE,NOW()),
('DM','DMA','Dominica',1767,FALSE,FALSE,'dm','WD',0,NULL,FALSE,NOW()),
('DO','DOM','Dominikanische Republik',1,FALSE,FALSE,'do','DOM',10,'(\\d{5}-\\d{4})?',FALSE,NOW()), -- phone codes 1-809, -829, -849
('DZ','DZA','Algerien',213,FALSE,FALSE,'dz','DZ',5,'\\d{5}',FALSE,NOW()),
('EC','ECU','Ecuador',593,FALSE,FALSE,'ec','EC',6,'\\w\\d{4}\\w',FALSE,NOW()),
('EE','EST','Estland',372,FALSE,TRUE,'ee','EST',5,'\\d{5}',FALSE,NOW()),
('EG','EGY','Ägypten',20,FALSE,FALSE,'eg','ET',5,'\\d{5}',FALSE,NOW()),
('EH','ESH','Westsahara (DARS)',NULL,FALSE,FALSE,'eh','SH',NULL,NULL,TRUE,NOW()), -- Marokko?
('ER','ERI','Eritrea',291,FALSE,FALSE,'er','ER',0,NULL,FALSE,NOW()),
('ES','ESP','Spanien',34,FALSE,TRUE,'es','E',5,'\\d{5}',FALSE,NOW()),
('ET','ETH','Äthiopien',251,FALSE,FALSE,'et','ETH',4,'\\d{4}',FALSE,NOW()),
('FI','FIN','Finnland',358,FALSE,FALSE,'fi','FIN',5,'\\d{5}',FALSE,NOW()),
('FJ','FJI','Fidschi',679,FALSE,FALSE,'fj','FJI',0,NULL,FALSE,NOW()),
('FK','FLK','Falklandinseln',500,FALSE,FALSE,'fk','GB',8,'FIQQ \\d\\w{2',TRUE,NOW()),
('FM','FSM','Mikronesien',691,FALSE,FALSE,'fm','FSM',10,NULL,FALSE,NOW()),
('FO','FRO','Färöer',298,FALSE,FALSE,'fo','FO',4,NULL,FALSE,NOW()),
('FR','FRA','Frankreich',33,FALSE,TRUE,'fr','F',5,'\\d{5}',FALSE,NOW()),
('GA','GAB','Gabun',241,FALSE,FALSE,'ga','G',2,'\\d{2}',FALSE,NOW()),
('GB','GBR','Großbritannien',44,FALSE,FALSE,'uk','GB',8,'\\w[\\w\\d]{2,4} \\d\\w{2}',FALSE,NOW()),
('GD','GRD','Grenada',1473,FALSE,FALSE,'gd','WG',0,NULL,FALSE,NOW()),
('GE','GEO','Georgien',995,FALSE,FALSE,'ge','GE',4,'\\d{4}',FALSE,NOW()),
-- ('GE','GEO','Abchasien',7,FALSE,FALSE,'ge','GE',4,'\\d{4}',TRUE,NOW()), -- officially still part of Georgia
-- ('GE','GEO','Südossetien',995,FALSE,FALSE,'ge','GE',4,'\\d{4}',TRUE,NOW()), -- officially still part of Georgia
('GF','GUF','Französisch-Guayana',594,FALSE,FALSE,'gf','F',5,NULL,TRUE,NOW()),
('GG','GGY','Guernsey',44,FALSE,FALSE,'gg','GBG',6,'GY \\d\\w{2',FALSE,NOW()),
('GH','GHA','Ghana',233,FALSE,FALSE,'gh','GH',0,NULL,FALSE,NOW()),
('GI','GIB','Gibraltar',350,FALSE,FALSE,'gi','GBZ',NULL,NULL,FALSE,NOW()),
('GL','GRL','Grönland',299,FALSE,FALSE,'gl','KN',4,NULL,FALSE,NOW()),
('GM','GMB','Gambia',220,FALSE,FALSE,'gm','WAG',0,NULL,FALSE,NOW()),
('GN','GIN','Guinea',224,FALSE,FALSE,'gn','RG',0,NULL,FALSE,NOW()),
('GP','GLP','Guadeloupe',590,FALSE,FALSE,'gp','F',5,NULL,TRUE,NOW()),
('GQ','GNQ','Äquatorialguinea',240,FALSE,FALSE,'gq','GQ',NULL,NULL,FALSE,NOW()),
('GR','GRC','Griechenland',30,FALSE,TRUE,'gr','GR',6,'\\d{3} \\d{2}',FALSE,NOW()),
('GS','SGS','Südgeorgien und die Südlichen Sandwichinseln',NULL,FALSE,FALSE,'gs','GB',8,'SIQQ \\d\\w{2',TRUE,NOW()), -- hardly inhabited
('GT','GTM','Guatemala',502,FALSE,FALSE,'gt','GCA',5,'\\d{5}',FALSE,NOW()),
('GU','GUM','Guam',1671,FALSE,FALSE,'gu','USA',10,NULL,TRUE,NOW()),
('GW','GNB','Guinea-Bissau',245,FALSE,FALSE,'gw','GUB',4,'\\d{4}',FALSE,NOW()),
('GY','GUY','Guyana',592,FALSE,FALSE,'gy','GUY',0,NULL,FALSE,NOW()),
('HK','HKG','Hongkong',852,FALSE,FALSE,'hk','HK',0,NULL,FALSE,NOW()),
('HM','HMD','Heard und McDonaldinseln',NULL,FALSE,FALSE,'hm',NULL,NULL,NULL,TRUE,NOW()), -- not inhabited
('HN','HND','Honduras',504,FALSE,FALSE,'hn','HN',6,'\\w{2}\\d{4}',FALSE,NOW()),
('HR','HRV','Kroatien',385,FALSE,FALSE,'hr','HR',6,'\\d{2} ?\\d{3}',FALSE,NOW()),
('HT','HTI','Haiti',509,FALSE,FALSE,'ht','RH',4,'\\d{4}',FALSE,NOW()),
('HU','HUN','Ungarn',36,FALSE,FALSE,'hu','H',4,'\\d{4}',FALSE,NOW()),
('ID','IDN','Indonesien',62,FALSE,FALSE,'id','RI',5,'\\d{5}',FALSE,NOW()),
('IE','IRL','Irland',353,FALSE,FALSE,'ie','IRL',0,NULL,FALSE,NOW()),
('IL','ISR','Israel',972,FALSE,FALSE,'il','IL',5,'\\d{5}',FALSE,NOW()),
('IM','IMN','Insel Man',44,FALSE,FALSE,'im','GB',6,'IM \\d\\w{2',TRUE,NOW()),
('IN','IND','Indien',91,FALSE,FALSE,'in','IND',6,'\\d{6}',FALSE,NOW()),
('IO','IOT','Britisches Territorium im Indischen Ozean',246,FALSE,FALSE,'io','GB',8,'BBND 1ZZ',TRUE,NOW()), -- ISO codes questionable, maybe VGB, military only
('IQ','IRQ','Irak',964,FALSE,FALSE,'iq','IRQ',0,NULL,FALSE,NOW()),
('IR','IRN','Iran',98,FALSE,FALSE,'ir','IR',5,'\\d{5}',FALSE,NOW()),
('IS','ISL','Island',354,FALSE,FALSE,'is','IS',3,'\\d{3}',FALSE,NOW()),
('IT','ITA','Italien',39,TRUE,TRUE,'it','I',5,'\\d{5}',FALSE,NOW()),
('JE','JEY','Jersey',44,FALSE,FALSE,'je','GBJ',6,'JE \\d\\w{2',FALSE,NOW()),
('JM','JAM','Jamaika',1876,FALSE,FALSE,'jm','JA',0,NULL,FALSE,NOW()),
('JO','JOR','Jordanien',962,FALSE,FALSE,'jo','JOR',5,'\\d{5}',FALSE,NOW()),
('JP','JPN','Japan',81,FALSE,FALSE,'jp','J',8,'??\\d{3}-\\d{4}',FALSE,NOW()),
('KE','KEN','Kenia',254,FALSE,FALSE,'ke','EAK',5,'\\d{5}',FALSE,NOW()),
('KG','KGZ','Kirgisistan',996,FALSE,FALSE,'kg','KS',6,'\\d{6}',FALSE,NOW()),
('KH','KHM','Kambodscha',855,FALSE,FALSE,'kh','K',5,'\\d{5}',FALSE,NOW()),
('KI','KIR','Kiribati',686,FALSE,FALSE,'ki','KIR',0,NULL,FALSE,NOW()),
('KM','COM','Komoren',269,FALSE,FALSE,'km','COM',0,NULL,FALSE,NOW()),
('KN','KNA','St. Kitts und Nevis',1869,FALSE,FALSE,'kn','KAN',0,NULL,FALSE,NOW()),
('KP','PRK','Korea, Demokratische Volksrepublik (Nordkorea)',850,FALSE,FALSE,'kp','KP',0,NULL,FALSE,NOW()),
('KR','KOR','Korea, Republik (Südkorea)',82,FALSE,FALSE,'kr','ROK',7,'\\d{3}-\\d{3}',FALSE,NOW()),
('KS','KOS','Kosovo',383,FALSE,FALSE,'ks','KOS',5,'\\d{5}',FALSE,NOW()), -- ISO-Codes ERFUNDEN!
('KW','KWT','Kuwait',965,FALSE,FALSE,'kw','KWT',5,'\\d{5}',FALSE,NOW()),
('KY','CYM','Kaimaninseln',1345,FALSE,FALSE,'ky',NULL,NULL,NULL,TRUE,NOW()),
('KZ','KAZ','Kasachstan',7,FALSE,FALSE,'kz','KZ',6,'\\d{6}',FALSE,NOW()),
('LA','LAO','Laos',856,FALSE,FALSE,'la','LAO',5,'\\d{5}',FALSE,NOW()),
('LB','LBN','Libanon',961,FALSE,FALSE,'lb','RL',9,'\\d{4}( \\d{4})?',FALSE,NOW()),
('LC','LCA','St. Lucia',1758,FALSE,FALSE,'lc','WL',0,NULL,FALSE,NOW()),
('LI','LIE','Liechtenstein',423,FALSE,FALSE,'li','FL',4,'94[89]\\d',FALSE,NOW()),
('LK','LKA','Sri Lanka',94,FALSE,FALSE,'lk','CL',5,'\\d{5}',FALSE,NOW()),
('LR','LBR','Liberia',231,FALSE,FALSE,'lr','LB',4,'\\d{4}',FALSE,NOW()),
('LS','LSO','Lesotho',266,FALSE,FALSE,'ls','LS',3,'\\d{3}',FALSE,NOW()),
('LT','LTU','Litauen',370,FALSE,FALSE,'lt','LT',4,'\\d{4}',FALSE,NOW()),
('LU','LUX','Luxemburg',352,FALSE,FALSE,'lu','L',4,'\\d{4}',FALSE,NOW()),
('LV','LVA','Lettland',371,FALSE,FALSE,'lv','LV',7,'LV-\\d{4}',FALSE,NOW()),
('LY','LBY','Libyen',218,FALSE,FALSE,'ly','LAR',0,NULL,FALSE,NOW()),
('MA','MAR','Marokko',212,FALSE,FALSE,'ma','MA',5,'\\d{5}',FALSE,NOW()),
('MC','MCO','Monaco',377,FALSE,FALSE,'mc','MC',5,'98000',FALSE,NOW()),
('MD','MDA','Moldawien',373,FALSE,FALSE,'md','MD',4,'\\d{4}',FALSE,NOW()),
('ME','MNE','Montenegro',382,FALSE,FALSE,'me','MNE',NULL,NULL,FALSE,NOW()),
('MG','MDG','Madagaskar',261,FALSE,FALSE,'mg','RM',3,'\\d{3}',FALSE,NOW()),
('MH','MHL','Marshallinseln',692,FALSE,FALSE,'mh','MH',10,NULL,FALSE,NOW()),
('MK','MKD','Mazedonien',389,FALSE,FALSE,'mk','MK',4,'\\d{4}',FALSE,NOW()),
('ML','MLI','Mali',223,FALSE,FALSE,'ml','RMM',0,NULL,FALSE,NOW()),
('MM','MMR','Myanmar',95,FALSE,FALSE,'mm','MYA',5,'\\d{5}',FALSE,NOW()),
('MN','MNG','Mongolei',976,FALSE,FALSE,'mn','MGL',6,'\\d{6}',FALSE,NOW()),
('MO','MAC','Macau',853,FALSE,FALSE,'mo',NULL,NULL,NULL,TRUE,NOW()),
('MP','MNP','Nördliche Marianen',1670,FALSE,FALSE,'mp','USA',10,NULL,TRUE,NOW()),
('MQ','MTQ','Martinique',596,FALSE,FALSE,'mq','F',5,NULL,TRUE,NOW()),
('MR','MRT','Mauretanien',222,FALSE,FALSE,'mr','RIM',0,NULL,FALSE,NOW()),
('MS','MSR','Montserrat',1664,FALSE,FALSE,'ms',NULL,NULL,NULL,TRUE,NOW()),
('MT','MLT','Malta',356,FALSE,FALSE,'mt','M',7,'\\w{3} \\d{2,3}',FALSE,NOW()),
('MU','MUS','Mauritius',230,FALSE,FALSE,'mu','MS',8,'(\\d{3}\\w{2}\\d{3})?',FALSE,NOW()),
('MV','MDV','Malediven',960,FALSE,FALSE,'mv','MV',5,'\\d{5}',FALSE,NOW()),
('MW','MWI','Malawi',265,FALSE,FALSE,'mw','MW',0,NULL,FALSE,NOW()),
('MX','MEX','Mexiko',52,FALSE,FALSE,'mx','MEX',5,'\\d{5}',FALSE,NOW()),
('MY','MYS','Malaysia',60,FALSE,FALSE,'my','MAL',7,'(\\d{7})?',FALSE,NOW()),
('MZ','MOZ','Mosambik',258,FALSE,FALSE,'mz','MOC',5,'\\d{5}',FALSE,NOW()),
('NA','NAM','Namibia',264,FALSE,FALSE,'na','NAM',0,NULL,FALSE,NOW()),
('NC','NCL','Neukaledonien',687,FALSE,FALSE,'nc','NCL',5,NULL,FALSE,NOW()),
('NE','NER','Niger',227,FALSE,FALSE,'ne','RN',4,'\\d{4}',FALSE,NOW()),
('NF','NFK','Norfolkinsel',6723,FALSE,FALSE,'nf','AUS',4,NULL,TRUE,NOW()),
('NG','NGA','Nigeria',234,FALSE,FALSE,'ng','NGR',6,'\\d{6}',FALSE,NOW()),
('NI','NIC','Nicaragua',505,FALSE,FALSE,'ni','NIC',14,'(\\w{4}-)?\\d{3}-\\d{3}-\\d',FALSE,NOW()),
('NL','NLD','Niederlande',31,FALSE,FALSE,'nl','NL',6,'\\d{4} \\w{2}',FALSE,NOW()),
('NO','NOR','Norwegen',47,FALSE,TRUE,'no','N',4,'\\d{4}',FALSE,NOW()),
('NP','NPL','Nepal',977,FALSE,FALSE,'np','NEP',5,'\\d{5}',FALSE,NOW()),
('NR','NRU','Nauru',674,FALSE,FALSE,'nr','NAU',0,NULL,FALSE,NOW()),
('NU','NIU','Niue',683,FALSE,FALSE,'nu',NULL,NULL,NULL,TRUE,NOW()),
('NZ','NZL','Neuseeland',64,FALSE,FALSE,'nz','NZ',4,'(\\d{4})?',FALSE,NOW()),
('OM','OMN','Oman',968,FALSE,FALSE,'om','OM',3,'\\d{3}',FALSE,NOW()),
('PA','PAN','Panama',507,FALSE,FALSE,'pa','PA',0,NULL,FALSE,NOW()),
('PE','PER','Peru',51,FALSE,FALSE,'pe','PE',7,'(\\w{2} \\d{4})?',FALSE,NOW()),
('PF','PYF','Französisch-Polynesien',689,FALSE,FALSE,'pf','F',5,NULL,TRUE,NOW()),
('PG','PNG','Papua-Neuguinea',675,FALSE,FALSE,'pg','PNG',3,'\\d{3}',FALSE,NOW()),
('PH','PHL','Philippinen',63,FALSE,FALSE,'ph','RP',4,'\\d{4}',FALSE,NOW()),
('PK','PAK','Pakistan',92,FALSE,FALSE,'pk','PK',5,'\\d{5}',FALSE,NOW()),
('PL','POL','Polen',48,FALSE,TRUE,'pl','PL',6,'\\d{2}-\\d{3}',FALSE,NOW()),
('PM','SPM','Saint-Pierre und Miquelon',508,FALSE,FALSE,'pm','F',5,NULL,TRUE,NOW()),
('PN','PCN','Pitcairninseln',649,FALSE,FALSE,'pn','GB',8,'PCRN \\d\\w{2',TRUE,NOW()),
('PR','PRI','Puerto Rico',1787,FALSE,FALSE,'pr','PRI',10,NULL,FALSE,NOW()),
('PS','PSE','Palästinensische Autonomiegebiete',970,FALSE,FALSE,'ps',NULL,NULL,NULL,FALSE,NOW()),
('PT','PRT','Portugal',351,TRUE,TRUE,'pt','P',8,'\\d{4}-\\d{3}',FALSE,NOW()),
('PW','PLW','Palau',680,FALSE,FALSE,'pw','PAL',10,NULL,FALSE,NOW()),
('PY','PRY','Paraguay',595,FALSE,FALSE,'py','PY',4,'\\d{4}',FALSE,NOW()),
('QA','QAT','Katar',974,FALSE,FALSE,'qa','Q',0,NULL,FALSE,NOW()),
('RE','REU','Réunion',262,FALSE,FALSE,'re','F',5,NULL,TRUE,NOW()),
('RO','ROU','Rumänien',40,FALSE,FALSE,'ro','RO',7,'\\d{7}',FALSE,NOW()),
('RS','SRB','Serbien',381,FALSE,FALSE,'rs','SRB',4,'\\d{4}',FALSE,NOW()),
('RU','RUS','Russland',7,FALSE,FALSE,'ru','RUS',6,'\\d{6}',FALSE,NOW()),
('RW','RWA','Ruanda',250,FALSE,FALSE,'rw','RWA',0,NULL,FALSE,NOW()),
('SA','SAU','Saudi-Arabien',966,FALSE,FALSE,'sa','KSA',5,'\\d{5}',FALSE,NOW()),
('SB','SLB','Salomonen',677,FALSE,FALSE,'sb','SOL',0,NULL,FALSE,NOW()),
('SC','SYC','Seychellen',248,FALSE,FALSE,'sc','SY',0,NULL,FALSE,NOW()),
('SD','SDN','Sudan',249,FALSE,FALSE,'sd','SUD',5,'\\d{5}',FALSE,NOW()),
('SE','SWE','Schweden',46,FALSE,FALSE,'se','S',6,'\\d{3} \\d{2}',FALSE,NOW()),
('SG','SGP','Singapur',65,FALSE,FALSE,'sg','SGP',6,'\\d{6}',FALSE,NOW()),
('SH','SHN','St. Helena',290,FALSE,FALSE,'sh','GB',8,'STHL \\d\\w{2',TRUE,NOW()),
('SI','SVN','Slowenien',386,FALSE,FALSE,'si','SLO',4,'\\d{4}',FALSE,NOW()),
('SJ','SJM','Svalbard und Jan Mayen (Spitzbergen)',47,FALSE,FALSE,'sj','ZN',NULL,NULL,TRUE,NOW()),
('SK','SVK','Slowakei',421,FALSE,FALSE,'sk','SK',6,'[890]\\d{2} \\d{2}',FALSE,NOW()),
('SL','SLE','Sierra Leone',232,FALSE,FALSE,'sl','WAL',0,NULL,FALSE,NOW()),
('SM','SMR','San Marino',378,FALSE,FALSE,'sm','RSM',0,NULL,FALSE,NOW()),
('SN','SEN','Senegal',221,FALSE,FALSE,'sn','SN',0,NULL,FALSE,NOW()),
('SO','SOM','Somalia',252,FALSE,FALSE,'so','SO',0,NULL,FALSE,NOW()),
('SR','SUR','Suriname',597,FALSE,FALSE,'sr','SME',0,NULL,FALSE,NOW()),
('ST','STP','São Tomé und Príncipe',239,FALSE,FALSE,'st','STP',0,NULL,FALSE,NOW()),
('SV','SLV','El Salvador',503,FALSE,FALSE,'sv','ES',7,'CP \\d{4}',FALSE,NOW()),
('SX','SXM','Sint Maarten',1721,FALSE,FALSE,'sx','AN',0,'',FALSE,NOW()), -- postcode might be like NL, didn’t find any
('SY','SYR','Syrien',963,FALSE,FALSE,'sy','SYR',4,'(\\d{4})?',FALSE,NOW()),
('SZ','SWZ','Swasiland',268,FALSE,FALSE,'sz','SD',4,'\\w\\d{3}',FALSE,NOW()),
('TC','TCA','Turks- und Caicosinseln',1649,FALSE,FALSE,'tc','GB',8,'TKCA \\d\\w{2',TRUE,NOW()),
('TD','TCD','Tschad',235,FALSE,FALSE,'td','TD',0,NULL,FALSE,NOW()),
('TF','ATF','Französische Süd- und Antarktisgebiete',262,FALSE,FALSE,'tf','F',0,NULL,TRUE,NOW()),
('TG','TGO','Togo',228,FALSE,FALSE,'tg','RT',0,NULL,FALSE,NOW()),
('TH','THA','Thailand',66,FALSE,FALSE,'th','T',5,'\\d{5}',FALSE,NOW()),
('TJ','TJK','Tadschikistan',992,FALSE,FALSE,'tj','TJ',6,'\\d{6}',FALSE,NOW()),
('TK','TKL','Tokelau',690,FALSE,FALSE,'tk',NULL,NULL,NULL,TRUE,NOW()),
('TL','TLS','Osttimor',670,FALSE,FALSE,'tl','TL',NULL,NULL,FALSE,NOW()),
('TM','TKM','Turkmenistan',993,FALSE,FALSE,'tm','TM',6,'\\d{6}',FALSE,NOW()),
('TN','TUN','Tunesien',216,FALSE,FALSE,'tn','TN',4,'\\d{4}',FALSE,NOW()),
('TO','TON','Tonga',676,FALSE,FALSE,'to','TON',0,NULL,FALSE,NOW()),
('TR','TUR','Türkei',90,FALSE,FALSE,'tr','TR',5,'\\d{5}',FALSE,NOW()),
('TT','TTO','Trinidad und Tobago',1868,FALSE,FALSE,'tt','TT',0,NULL,FALSE,NOW()),
('TV','TUV','Tuvalu',688,FALSE,FALSE,'tv','TUV',0,NULL,FALSE,NOW()),
('TW','TWN','Taiwan',886,FALSE,FALSE,'tw','RC',NULL,NULL,FALSE,NOW()),
('TZ','TZA','Tansania',255,FALSE,FALSE,'tz','EAT',0,NULL,FALSE,NOW()),
('UA','UKR','Ukraine',380,FALSE,FALSE,'ua','UA',5,'\\d{5}',FALSE,NOW()),
('UG','UGA','Uganda',256,FALSE,FALSE,'ug','EAU',0,NULL,FALSE,NOW()),
('UM','UMI','United States Minor Outlying Islands',1,FALSE,FALSE,'um','USA',NULL,NULL,TRUE,NOW()),
('US','USA','Vereinigte Staaten von Amerika',1,FALSE,FALSE,'us','USA',10,'([A-Z]{2} {1,2})?\\d{5}(-\\d{4})?',FALSE,NOW()),
('UY','URY','Uruguay',598,FALSE,FALSE,'uy','ROU',5,'\\d{5}',FALSE,NOW()),
('UZ','UZB','Usbekistan',998,FALSE,FALSE,'uz','UZ',6,'\\d{6}',FALSE,NOW()),
('VA','VAT','Vatikanstadt',379,FALSE,FALSE,'va','V',5,'00120',TRUE,NOW()),
('VC','VCT','St. Vincent und die Grenadinen',1784,FALSE,FALSE,'vc','WV',0,NULL,FALSE,NOW()),
('VE','VEN','Venezuela',58,FALSE,FALSE,'ve','YV',4,'\\d{4}',FALSE,NOW()),
('VG','VGB','Britische Jungferninseln',1284,FALSE,FALSE,'vg','VG',NULL,NULL,TRUE,NOW()),
('VI','VIR','Amerikanische Jungferninseln',1340,FALSE,FALSE,'vi','USA',10,NULL,TRUE,NOW()),
('VN','VNM','Vietnam',84,FALSE,FALSE,'vn','VN',6,'\\d{5,6}',FALSE,NOW()),
('VU','VUT','Vanuatu',678,FALSE,FALSE,'vu','VAN',0,NULL,FALSE,NOW()),
('WF','WLF','Wallis und Futuna',681,FALSE,FALSE,'wf','F',5,NULL,TRUE,NOW()),
('WS','WSM','Samoa',685,FALSE,FALSE,'ws','WS',0,NULL,FALSE,NOW()),
('YE','YEM','Jemen',967,FALSE,FALSE,'ye','YEM',0,NULL,FALSE,NOW()),
('YT','MYT','Mayotte',262,FALSE,FALSE,'yt','F',5,NULL,TRUE,NOW()),
('ZA','ZAF','Südafrika',27,FALSE,FALSE,'za','ZA',4,'\\d{4}',FALSE,NOW()),
('ZM','ZMB','Sambia',260,FALSE,FALSE,'zm','Z',5,'\\d{5}',FALSE,NOW()),
('ZW','ZWE','Simbabwe',263,FALSE,FALSE,'zw','ZW',0,NULL,FALSE,NOW())
;
@fiee
Copy link
Author

fiee commented Sep 21, 2015

Fixed a bunch of errors today (2015-09-21)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment