Created
March 5, 2016 15:13
-
-
Save luelista/508deae244721a82beb7 to your computer and use it in GitHub Desktop.
MySQL table with list of all (most?) countries of the world
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- -------------------------------------------------------- | |
| -- Host: xx | |
| -- Server Version: xx | |
| -- Server Betriebssystem: xx | |
| -- HeidiSQL Version: 9.3.0.4984 | |
| -- -------------------------------------------------------- | |
| /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | |
| /*!40101 SET NAMES utf8mb4 */; | |
| /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; | |
| /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; | |
| -- Exportiere Struktur von Tabelle adr_land | |
| CREATE TABLE IF NOT EXISTS `adr_land` ( | |
| `iso31661_alpha2` varchar(2) NOT NULL, | |
| `iso31661_alpha3` varchar(3) NOT NULL, | |
| `iso31661_number` varchar(3) NOT NULL, | |
| `common_name` varchar(100) NOT NULL, | |
| `old_post_code` varchar(3) NOT NULL, | |
| `tld` varchar(20) NOT NULL, | |
| `telephone_code` varchar(50) NOT NULL, | |
| `formal_name` varchar(255) NOT NULL, | |
| `type` varchar(255) NOT NULL, | |
| `subtype` varchar(255) NOT NULL, | |
| `sovereignty` varchar(255) NOT NULL, | |
| `capital` varchar(255) NOT NULL, | |
| `currency_code` varchar(20) NOT NULL, | |
| `currency_name` varchar(255) NOT NULL, | |
| `german_name` varchar(100) DEFAULT NULL, | |
| PRIMARY KEY (`iso31661_alpha2`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Länder'; | |
| -- Exportiere Daten aus Tabelle adr_land: ~241 rows (ungefähr) | |
| /*!40000 ALTER TABLE `adr_land` DISABLE KEYS */; | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('', '', '', '(not available)', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '(nicht verfügbar)'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AC', 'ASC', '', 'Ascension', '', '.ac', '247', '', 'Proto Dependency', 'Dependency of Saint Helena', 'United Kingdom', 'Georgetown', 'SHP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AD', 'AND', '20', 'Andorra', 'AND', '.ad', '376', 'Principality of Andorra', 'Independent State', '', '', 'Andorra la Vella', 'EUR', 'Euro', 'Andorra'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AE', 'ARE', '784', 'United Arab Emirates', 'UAE', '.ae', '971', 'United Arab Emirates', 'Independent State', '', '', 'Abu Dhabi', 'AED', 'Dirham', 'Vereinigte Arabische Emirate'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AF', 'AFG', '4', 'Afghanistan', '', '.af', '93', 'Islamic State of Afghanistan', 'Independent State', '', '', 'Kabul', 'AFN', 'Afghani', 'Afghanistan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AG', 'ATG', '28', 'Antigua and Barbuda', '', '.ag', '267', '', 'Independent State', '', '', 'Saint John\'s', 'XCD', 'Dollar', 'Antigua und Barbuda'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AI', 'AIA', '660', 'Anguilla', '', '.ai', '263', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'The Valley', 'XCD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AL', 'ALB', '8', 'Albania', '', '.al', '355', 'Republic of Albania', 'Independent State', '', '', 'Tirana', 'ALL', 'Lek', 'Albanien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AM', 'ARM', '51', 'Armenia', '', '.am', '374', 'Republic of Armenia', 'Independent State', '', '', 'Yerevan', 'AMD', 'Dram', 'Armenien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AN', 'ANT', '530', 'Netherlands Antilles', '', '.an', '599', '', 'Proto Dependency', '', 'Netherlands', 'Willemstad', 'ANG', 'Guilder', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AO', 'AGO', '24', 'Angola', '', '.ao', '244', 'Republic of Angola', 'Independent State', '', '', 'Luanda', 'AOA', 'Kwanza', 'Angola'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AQ', 'ATA', '10', 'British Antarctic Territory', '', '.aq', '', '', 'Antarctic Territory', 'Overseas Territory', 'United Kingdom', '', '', '', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AR', 'ARG', '32', 'Argentina', '', '.ar', '54', 'Argentine Republic', 'Independent State', '', '', 'Buenos Aires', 'ARS', 'Peso', 'Argentinien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AS', 'ASM', '16', 'American Samoa', '', '.as', '683', 'Territory of American Samoa', 'Dependency', 'Territory', 'United States', 'Pago Pago', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AT', 'AUT', '40', 'Austria', 'A', '.at', '43', 'Republic of Austria', 'Independent State', '', '', 'Vienna', 'EUR', 'Euro', 'Österreich'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AU', 'AUS', '36', 'Australia', 'AUS', '.au', '', 'Commonwealth of Australia', 'Independent State', '', '', 'Canberra', 'AUD', 'Dollar', 'Australien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AW', 'ABW', '533', 'Aruba', '', '.aw', '297', '', 'Proto Dependency', '', 'Netherlands', 'Oranjestad', 'AWG', 'Guilder', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AX', 'ALA', '248', 'Aland', 'AX', '.ax', '340', '', 'Proto Dependency', '', 'Finland', 'Mariehamn', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('AZ', 'AZE', '31', 'Nagorno-Karabakh', '', '.az', '277', 'Nagorno-Karabakh Republic', 'Proto Independent State', '', '', 'Stepanakert', 'AMD', 'Dram', 'Aserbaidschan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BA', 'BIH', '70', 'Bosnia and Herzegovina', '', '.ba', '387', '', 'Independent State', '', '', 'Sarajevo', 'BAM', 'Marka', 'Bosnien und Herzegowina'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BB', 'BRB', '52', 'Barbados', '', '.bb', '245', '', 'Independent State', '', '', 'Bridgetown', 'BBD', 'Dollar', 'Barbados'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BD', 'BGD', '50', 'Bangladesh', '', '.bd', '880', 'People\'s Republic of Bangladesh', 'Independent State', '', '', 'Dhaka', 'BDT', 'Taka', 'Bangladesch'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BE', 'BEL', '56', 'Belgium', 'B', '.be', '32', 'Kingdom of Belgium', 'Independent State', '', '', 'Brussels', 'EUR', 'Euro', 'Belgien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BF', 'BFA', '854', 'Burkina Faso', '', '.bf', '226', '', 'Independent State', '', '', 'Ouagadougou', 'XOF', 'Franc', 'Burkina Faso'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BG', 'BGR', '100', 'Bulgaria', 'BG', '.bg', '359', 'Republic of Bulgaria', 'Independent State', '', '', 'Sofia', 'BGN', 'Lev', 'Bulgarien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BH', 'BHR', '48', 'Bahrain', '', '.bh', '973', 'Kingdom of Bahrain', 'Independent State', '', '', 'Manama', 'BHD', 'Dinar', 'Bahrain'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BI', 'BDI', '108', 'Burundi', '', '.bi', '257', 'Republic of Burundi', 'Independent State', '', '', 'Bujumbura', 'BIF', 'Franc', 'Burundi'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BJ', 'BEN', '204', 'Benin', '', '.bj', '229', 'Republic of Benin', 'Independent State', '', '', 'Porto-Novo', 'XOF', 'Franc', 'Benin'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BM', 'BMU', '60', 'Bermuda', '', '.bm', '440', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Hamilton', 'BMD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BN', 'BRN', '96', 'Brunei', '', '.bn', '673', 'Negara Brunei Darussalam', 'Independent State', '', '', 'Bandar Seri Begawan', 'BND', 'Dollar', 'Brunei'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BO', 'BOL', '68', 'Bolivia', '', '.bo', '591', 'Republic of Bolivia', 'Independent State', '', '', 'La Paz (administrative/legislative) and Sucre (judical)', 'BOB', 'Boliviano', 'Bolivien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BR', 'BRA', '76', 'Brazil', '', '.br', '55', 'Federative Republic of Brazil', 'Independent State', '', '', 'Brasilia', 'BRL', 'Real', 'Brasilien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BS', 'BHS', '44', 'Bahamas, The', '', '.bs', '241', 'Commonwealth of The Bahamas', 'Independent State', '', '', 'Nassau', 'BSD', 'Dollar', 'Bahamas'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BT', 'BTN', '64', 'Bhutan', '', '.bt', '975', 'Kingdom of Bhutan', 'Independent State', '', '', 'Thimphu', 'BTN', 'Ngultrum', 'Bhutan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BV', 'BVT', '74', 'Bouvet Island', '', '.bv', '', '', 'Dependency', 'Territory', 'Norway', '', '', '', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BW', 'BWA', '72', 'Botswana', '', '.bw', '267', 'Republic of Botswana', 'Independent State', '', '', 'Gaborone', 'BWP', 'Pula', 'Botswana'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BY', 'BLR', '112', 'Belarus', '', '.by', '375', 'Republic of Belarus', 'Independent State', '', '', 'Minsk', 'BYR', 'Ruble', 'Weißrussland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('BZ', 'BLZ', '84', 'Belize', '', '.bz', '501', '', 'Independent State', '', '', 'Belmopan', 'BZD', 'Dollar', 'Belize'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CA', 'CAN', '124', 'Canada', 'CDN', '.ca', '1', '', 'Independent State', '', '', 'Ottawa', 'CAD', 'Dollar', 'Kanada'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CC', 'CCK', '166', 'Cocos (Keeling) Islands', '', '.cc', '61', 'Territory of Cocos (Keeling) Islands', 'Dependency', 'External Territory', 'Australia', 'West Island', 'AUD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CD', 'COD', '180', 'Congo, (Congo – Kinshasa)', '', '.cd', '243', 'Democratic Republic of the Congo', 'Independent State', '', '', 'Kinshasa', 'CDF', 'Franc', 'Kongo, Demokratische Republik'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CF', 'CAF', '140', 'Central African Republic', '', '.cf', '236', '', 'Independent State', '', '', 'Bangui', 'XAF', 'Franc', 'Zentralafrikanische Republik'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CG', 'COG', '178', 'Congo, (Congo – Brazzaville)', '', '.cg', '242', 'Republic of the Congo', 'Independent State', '', '', 'Brazzaville', 'XAF', 'Franc', 'Kongo, Republik'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CH', 'CHE', '756', 'Switzerland', 'CH', '.ch', '41', 'Swiss Confederation', 'Independent State', '', '', 'Bern', 'CHF', 'Franc', 'Schweiz'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CI', 'CIV', '384', 'Cote d\'Ivoire (Ivory Coast)', '', '.ci', '225', 'Republic of Cote d\'Ivoire', 'Independent State', '', '', 'Yamoussoukro', 'XOF', 'Franc', 'Elfenbeinküste'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CK', 'COK', '184', 'Cook Islands', '', '.ck', '682', '', 'Dependency', 'Self-Governing in Free Association', 'New Zealand', 'Avarua', 'NZD', 'Dollar', 'Cookinseln'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CL', 'CHL', '152', 'Chile', '', '.cl', '56', 'Republic of Chile', 'Independent State', '', '', 'Santiago (administrative/judical) and Valparaiso (legislative)', 'CLP', 'Peso', 'Chile'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CM', 'CMR', '120', 'Cameroon', '', '.cm', '237', 'Republic of Cameroon', 'Independent State', '', '', 'Yaounde', 'XAF', 'Franc', 'Kamerun'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CN', 'CHN', '156', 'China, People\'s Republic of', '', '.cn', '86', 'People\'s Republic of China', 'Independent State', '', '', 'Beijing', 'CNY', 'Yuan Renminbi', 'Volksrepublik China'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CO', 'COL', '170', 'Colombia', '', '.co', '57', 'Republic of Colombia', 'Independent State', '', '', 'Bogota', 'COP', 'Peso', 'Kolumbien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CR', 'CRI', '188', 'Costa Rica', '', '.cr', '506', 'Republic of Costa Rica', 'Independent State', '', '', 'San Jose', 'CRC', 'Colon', 'Costa Rica'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CU', 'CUB', '192', 'Cuba', '', '.cu', '53', 'Republic of Cuba', 'Independent State', '', '', 'Havana', 'CUP', 'Peso', 'Kuba'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CV', 'CPV', '132', 'Cape Verde', '', '.cv', '238', 'Republic of Cape Verde', 'Independent State', '', '', 'Praia', 'CVE', 'Escudo', 'Kap Verde'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CX', 'CXR', '162', 'Christmas Island', '', '.cx', '61', 'Territory of Christmas Island', 'Dependency', 'External Territory', 'Australia', 'The Settlement (Flying Fish Cove)', 'AUD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CY', 'CYP', '196', 'Cyprus', 'CY', '.cy', '357', 'Republic of Cyprus', 'Independent State', '', '', 'Nicosia', 'CYP', 'Pound', 'Zypern'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('CZ', 'CZE', '203', 'Czech Republic', 'CZ', '.cz', '420', '', 'Independent State', '', '', 'Prague', 'CZK', 'Koruna', 'Tschechien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('DE', 'DEU', '276', 'Germany', 'D', '.de', '49', 'Federal Republic of Germany', 'Independent State', '', '', 'Berlin', 'EUR', 'Euro', 'Deutschland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('DJ', 'DJI', '262', 'Djibouti', '', '.dj', '253', 'Republic of Djibouti', 'Independent State', '', '', 'Djibouti', 'DJF', 'Franc', 'Dschibuti'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('DK', 'DNK', '208', 'Denmark', 'DK', '.dk', '45', 'Kingdom of Denmark', 'Independent State', '', '', 'Copenhagen', 'DKK', 'Krone', 'Dänemark'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('DM', 'DMA', '212', 'Dominica', '', '.dm', '766', 'Commonwealth of Dominica', 'Independent State', '', '', 'Roseau', 'XCD', 'Dollar', 'Dominica'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('DO', 'DOM', '214', 'Dominican Republic', '', '.do', '1809;1829', '', 'Independent State', '', '', 'Santo Domingo', 'DOP', 'Peso', 'Dominikanische Republik'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('DZ', 'DZA', '12', 'Algeria', '', '.dz', '213', 'People\'s Democratic Republic of Algeria', 'Independent State', '', '', 'Algiers', 'DZD', 'Dinar', 'Algerien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('EC', 'ECU', '218', 'Ecuador', '', '.ec', '593', 'Republic of Ecuador', 'Independent State', '', '', 'Quito', 'USD', 'Dollar', 'Ecuador'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('EE', 'EST', '233', 'Estonia', 'EST', '.ee', '372', 'Republic of Estonia', 'Independent State', '', '', 'Tallinn', 'EEK', 'Kroon', 'Estland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('EG', 'EGY', '818', 'Egypt', '', '.eg', '20', 'Arab Republic of Egypt', 'Independent State', '', '', 'Cairo', 'EGP', 'Pound', 'Ägypten'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ER', 'ERI', '232', 'Eritrea', '', '.er', '291', 'State of Eritrea', 'Independent State', '', '', 'Asmara', 'ERN', 'Nakfa', 'Eritrea'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ES', 'ESP', '724', 'Spain', 'E', '.es', '34', 'Kingdom of Spain', 'Independent State', '', '', 'Madrid', 'EUR', 'Euro', 'Spanien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ET', 'ETH', '231', 'Ethiopia', '', '.et', '251', 'Federal Democratic Republic of Ethiopia', 'Independent State', '', '', 'Addis Ababa', 'ETB', 'Birr', 'Äthiopien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('FI', 'FIN', '246', 'Finland', 'FIN', '.fi', '358', 'Republic of Finland', 'Independent State', '', '', 'Helsinki', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('FJ', 'FJI', '242', 'Fiji', '', '.fj', '679', 'Republic of the Fiji Islands', 'Independent State', '', '', 'Suva', 'FJD', 'Dollar', 'Fidschi'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('FK', 'FLK', '238', 'Falkland Islands (Islas Malvinas)', '', '.fk', '500', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Stanley', 'FKP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('FM', 'FSM', '583', 'Micronesia', '', '.fm', '691', 'Federated States of Micronesia', 'Independent State', '', '', 'Palikir', 'USD', 'Dollar', 'Mikronesien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('FO', 'FRO', '234', 'Faroe Islands', 'FO', '.fo', '298', '', 'Proto Dependency', '', 'Denmark', 'Torshavn', 'DKK', 'Krone', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('FR', 'FRA', '250', 'France', 'FR', '.fr', '33', 'French Republic', 'Independent State', '', '', 'Paris', 'EUR', 'Euro', 'Frankreich'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GA', 'GAB', '266', 'Gabon', '', '.ga', '241', 'Gabonese Republic', 'Independent State', '', '', 'Libreville', 'XAF', 'Franc', 'Gabun'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GB', 'GBR', '826', 'United Kingdom', 'GB', '.uk', '44', 'United Kingdom of Great Britain and Northern Ireland', 'Independent State', '', '', 'London', 'GBP', 'Pound', 'Vereinigtes Königreich'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GD', 'GRD', '308', 'Grenada', '', '.gd', '472', '', 'Independent State', '', '', 'Saint George\'s', 'XCD', 'Dollar', 'Grenada'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GF', 'GUF', '254', 'French Guiana', '', '.gf', '594', 'Overseas Region of Guiana', 'Proto Dependency', 'Overseas Region', 'France', 'Cayenne', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GG', 'GGY', '831', 'Guernsey', '', '.gg', '44', 'Bailiwick of Guernsey', 'Dependency', 'Crown Dependency', 'United Kingdom', 'Saint Peter Port', 'GGP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GH', 'GHA', '288', 'Ghana', '', '.gh', '233', 'Republic of Ghana', 'Independent State', '', '', 'Accra', 'GHC', 'Cedi', 'Ghana'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GI', 'GIB', '292', 'Gibraltar', '', '.gi', '350', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Gibraltar', 'GIP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GL', 'GRL', '304', 'Greenland', '', '.gl', '299', '', 'Proto Dependency', '', 'Denmark', 'Nuuk (Godthab)', 'DKK', 'Krone', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GM', 'GMB', '270', 'Gambia, The', '', '.gm', '220', 'Republic of The Gambia', 'Independent State', '', '', 'Banjul', 'GMD', 'Dalasi', 'Gambia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GN', 'GIN', '324', 'Guinea', '', '.gn', '224', 'Republic of Guinea', 'Independent State', '', '', 'Conakry', 'GNF', 'Franc', 'Guinea'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GP', 'GLP', '312', 'Guadeloupe', '', '.gp', '590', 'Overseas Region of Guadeloupe', 'Proto Dependency', 'Overseas Region', 'France', 'Basse-Terre', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GQ', 'GNQ', '226', 'Equatorial Guinea', '', '.gq', '240', 'Republic of Equatorial Guinea', 'Independent State', '', '', 'Malabo', 'XAF', 'Franc', 'Äquatorialguinea'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GR', 'GRC', '300', 'Greece', 'GR', '.gr', '30', 'Hellenic Republic', 'Independent State', '', '', 'Athens', 'EUR', 'Euro', 'Griechenland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GS', 'SGS', '239', 'South Georgia & South Sandwich Islands', '', '.gs', '', '', 'Dependency', 'Overseas Territory', 'United Kingdom', '', '', '', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GT', 'GTM', '320', 'Guatemala', '', '.gt', '502', 'Republic of Guatemala', 'Independent State', '', '', 'Guatemala', 'GTQ', 'Quetzal', 'Guatemala'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GU', 'GUM', '316', 'Guam', '', '.gu', '670', 'Territory of Guam', 'Dependency', 'Territory', 'United States', 'Hagatna', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GW', 'GNB', '624', 'Guinea-Bissau', '', '.gw', '245', 'Republic of Guinea-Bissau', 'Independent State', '', '', 'Bissau', 'XOF', 'Franc', 'Guinea-Bissau'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('GY', 'GUY', '328', 'Guyana', '', '.gy', '592', 'Co-operative Republic of Guyana', 'Independent State', '', '', 'Georgetown', 'GYD', 'Dollar', 'Guyana'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('HK', 'HKG', '344', 'Hong Kong', '', '.hk', '852', 'Hong Kong Special Administrative Region', 'Proto Dependency', 'Special Administrative Region', 'China', '', 'HKD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('HM', 'HMD', '334', 'Heard Island and McDonald Islands', '', '.hm', '', 'Territory of Heard Island and McDonald Islands', 'Dependency', 'External Territory', 'Australia', '', '', '', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('HN', 'HND', '340', 'Honduras', '', '.hn', '504', 'Republic of Honduras', 'Independent State', '', '', 'Tegucigalpa', 'HNL', 'Lempira', 'Honduras'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('HR', 'HRV', '191', 'Croatia', 'CRO', '.hr', '385', 'Republic of Croatia', 'Independent State', '', '', 'Zagreb', 'HRK', 'Kuna', 'Kroatien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('HT', 'HTI', '332', 'Haiti', '', '.ht', '509', 'Republic of Haiti', 'Independent State', '', '', 'Port-au-Prince', 'HTG', 'Gourde', 'Haiti'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('HU', 'HUN', '348', 'Hungary', 'H', '.hu', '36', 'Republic of Hungary', 'Independent State', '', '', 'Budapest', 'HUF', 'Forint', 'Ungarn'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ID', 'IDN', '360', 'Indonesia', '', '.id', '62', 'Republic of Indonesia', 'Independent State', '', '', 'Jakarta', 'IDR', 'Rupiah', 'Indonesien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IE', 'IRL', '372', 'Ireland', '', '.ie', '353', '', 'Independent State', '', '', 'Dublin', 'EUR', 'Euro', 'Irland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IL', 'ISR', '376', 'Israel', '', '.il', '972', 'State of Israel', 'Independent State', '', '', 'Jerusalem', 'ILS', 'Shekel', 'Israel'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IM', 'IMN', '833', 'Isle of Man', '', '.im', '44', '', 'Dependency', 'Crown Dependency', 'United Kingdom', 'Douglas', 'IMP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IN', 'IND', '356', 'India', '', '.in', '91', 'Republic of India', 'Independent State', '', '', 'New Delhi', 'INR', 'Rupee', 'Indien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IO', 'IOT', '86', 'British Indian Ocean Territory', '', '.io', '246', '', 'Dependency', 'Overseas Territory', 'United Kingdom', '', '', '', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IQ', 'IRQ', '368', 'Iraq', '', '.iq', '964', 'Republic of Iraq', 'Independent State', '', '', 'Baghdad', 'IQD', 'Dinar', 'Irak'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IR', 'IRN', '364', 'Iran', '', '.ir', '98', 'Islamic Republic of Iran', 'Independent State', '', '', 'Tehran', 'IRR', 'Rial', 'Iran'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IS', 'ISL', '352', 'Iceland', '', '.is', '354', 'Republic of Iceland', 'Independent State', '', '', 'Reykjavik', 'ISK', 'Krona', 'Island'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('IT', 'ITA', '380', 'Italy', 'I', '.it', '39', 'Italian Republic', 'Independent State', '', '', 'Rome', 'EUR', 'Euro', 'Italien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('JE', 'JEY', '832', 'Jersey', '', '.je', '44', 'Bailiwick of Jersey', 'Dependency', 'Crown Dependency', 'United Kingdom', 'Saint Helier', 'JEP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('JM', 'JAM', '388', 'Jamaica', '', '.jm', '875', '', 'Independent State', '', '', 'Kingston', 'JMD', 'Dollar', 'Jamaika'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('JO', 'JOR', '400', 'Jordan', '', '.jo', '962', 'Hashemite Kingdom of Jordan', 'Independent State', '', '', 'Amman', 'JOD', 'Dinar', 'Jordanien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('JP', 'JPN', '392', 'Japan', 'J', '.jp', '81', '', 'Independent State', '', '', 'Tokyo', 'JPY', 'Yen', 'Japan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KE', 'KEN', '404', 'Kenya', '', '.ke', '254', 'Republic of Kenya', 'Independent State', '', '', 'Nairobi', 'KES', 'Shilling', 'Kenia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KG', 'KGZ', '417', 'Kyrgyzstan', '', '.kg', '996', 'Kyrgyz Republic', 'Independent State', '', '', 'Bishkek', 'KGS', 'Som', 'Kirgisistan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KH', 'KHM', '116', 'Cambodia', '', '.kh', '855', 'Kingdom of Cambodia', 'Independent State', '', '', 'Phnom Penh', 'KHR', 'Riels', 'Kambodscha'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KI', 'KIR', '296', 'Kiribati', '', '.ki', '686', 'Republic of Kiribati', 'Independent State', '', '', 'Tarawa', 'AUD', 'Dollar', 'Kiribati'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KM', 'COM', '174', 'Comoros', '', '.km', '269', 'Union of Comoros', 'Independent State', '', '', 'Moroni', 'KMF', 'Franc', 'Komoren'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KN', 'KNA', '659', 'Saint Kitts and Nevis', '', '.kn', '868', 'Federation of Saint Kitts and Nevis', 'Independent State', '', '', 'Basseterre', 'XCD', 'Dollar', 'St. Kitts und Nevis'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KP', 'PRK', '408', 'Korea, North', '', '.kp', '850', 'Democratic People\'s Republic of Korea', 'Independent State', '', '', 'Pyongyang', 'KPW', 'Won', 'Korea, Nord'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KR', 'KOR', '410', 'Korea, South', '', '.kr', '82', 'Republic of Korea', 'Independent State', '', '', 'Seoul', 'KRW', 'Won', 'Korea, Süd'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KW', 'KWT', '414', 'Kuwait', '', '.kw', '965', 'State of Kuwait', 'Independent State', '', '', 'Kuwait', 'KWD', 'Dinar', 'Kuwait'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KY', 'CYM', '136', 'Cayman Islands', '', '.ky', '344', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'George Town', 'KYD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('KZ', 'KAZ', '398', 'Kazakhstan', '', '.kz', '7', 'Republic of Kazakhstan', 'Independent State', '', '', 'Astana', 'KZT', 'Tenge', 'Kasachstan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LA', 'LAO', '418', 'Laos', '', '.la', '856', 'Lao People\'s Democratic Republic', 'Independent State', '', '', 'Vientiane', 'LAK', 'Kip', 'Laos'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LB', 'LBN', '422', 'Lebanon', '', '.lb', '961', 'Lebanese Republic', 'Independent State', '', '', 'Beirut', 'LBP', 'Pound', 'Libanon'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LC', 'LCA', '662', 'Saint Lucia', '', '.lc', '757', '', 'Independent State', '', '', 'Castries', 'XCD', 'Dollar', 'St. Lucia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LI', 'LIE', '438', 'Liechtenstein', 'FL', '.li', '423', 'Principality of Liechtenstein', 'Independent State', '', '', 'Vaduz', 'CHF', 'Franc', 'Liechtenstein'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LK', 'LKA', '144', 'Sri Lanka', '', '.lk', '94', 'Democratic Socialist Republic of Sri Lanka', 'Independent State', '', '', 'Colombo (administrative/judical) and Sri Jayewardenepura Kotte (legislative)', 'LKR', 'Rupee', 'Sri Lanka'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LR', 'LBR', '430', 'Liberia', '', '.lr', '231', 'Republic of Liberia', 'Independent State', '', '', 'Monrovia', 'LRD', 'Dollar', 'Liberia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LS', 'LSO', '426', 'Lesotho', '', '.ls', '266', 'Kingdom of Lesotho', 'Independent State', '', '', 'Maseru', 'LSL', 'Loti', 'Lesotho'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LT', 'LTU', '440', 'Lithuania', 'LT', '.lt', '370', 'Republic of Lithuania', 'Independent State', '', '', 'Vilnius', 'LTL', 'Litas', 'Litauen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LU', 'LUX', '442', 'Luxembourg', 'L', '.lu', '352', 'Grand Duchy of Luxembourg', 'Independent State', '', '', 'Luxembourg', 'EUR', 'Euro', 'Luxemburg'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LV', 'LVA', '428', 'Latvia', 'LV', '.lv', '371', 'Republic of Latvia', 'Independent State', '', '', 'Riga', 'LVL', 'Lat', 'Lettland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('LY', 'LBY', '434', 'Libya', '', '.ly', '218', 'Great Socialist People\'s Libyan Arab Jamahiriya', 'Independent State', '', '', 'Tripoli', 'LYD', 'Dinar', 'Libyen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MA', 'MAR', '504', 'Morocco', '', '.ma', '212', 'Kingdom of Morocco', 'Independent State', '', '', 'Rabat', 'MAD', 'Dirham', 'Marokko'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MC', 'MCO', '492', 'Monaco', 'MC', '.mc', '377', 'Principality of Monaco', 'Independent State', '', '', 'Monaco', 'EUR', 'Euro', 'Monaco'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MD', 'MDA', '498', 'Pridnestrovie (Transnistria)', '', '.md', '160', 'Pridnestrovian Moldavian Republic', 'Proto Independent State', '', '', 'Tiraspol', '', 'Ruple', 'Moldawien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ME', 'MNE', '499', 'Montenegro', '', '.me and .yu', '382', 'Republic of Montenegro', 'Independent State', '', '', 'Podgorica', 'EUR', 'Euro', 'Montenegro'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MG', 'MDG', '450', 'Madagascar', '', '.mg', '261', 'Republic of Madagascar', 'Independent State', '', '', 'Antananarivo', 'MGA', 'Ariary', 'Madagaskar'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MH', 'MHL', '584', 'Marshall Islands', '', '.mh', '692', 'Republic of the Marshall Islands', 'Independent State', '', '', 'Majuro', 'USD', 'Dollar', 'Marshallinseln'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MK', 'MKD', '807', 'Macedonia', 'MK', '.mk', '389', 'Republic of Macedonia', 'Independent State', '', '', 'Skopje', 'MKD', 'Denar', 'Mazedonien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ML', 'MLI', '466', 'Mali', '', '.ml', '223', 'Republic of Mali', 'Independent State', '', '', 'Bamako', 'XOF', 'Franc', 'Mali'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MM', 'MMR', '104', 'Myanmar (Burma)', '', '.mm', '95', 'Union of Myanmar', 'Independent State', '', '', 'Naypyidaw', 'MMK', 'Kyat', 'Myanmar'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MN', 'MNG', '496', 'Mongolia', '', '.mn', '976', '', 'Independent State', '', '', 'Ulaanbaatar', 'MNT', 'Tugrik', 'Mongolei'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MO', 'MAC', '446', 'Macau', '', '.mo', '853', 'Macau Special Administrative Region', 'Proto Dependency', 'Special Administrative Region', 'China', 'Macau', 'MOP', 'Pataca', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MP', 'MNP', '580', 'Northern Mariana Islands', '', '.mp', '669', 'Commonwealth of The Northern Mariana Islands', 'Dependency', 'Commonwealth', 'United States', 'Saipan', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MQ', 'MTQ', '474', 'Martinique', '', '.mq', '596', 'Overseas Region of Martinique', 'Proto Dependency', 'Overseas Region', 'France', 'Fort-de-France', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MR', 'MRT', '478', 'Mauritania', '', '.mr', '222', 'Islamic Republic of Mauritania', 'Independent State', '', '', 'Nouakchott', 'MRO', 'Ouguiya', 'Mauretanien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MS', 'MSR', '500', 'Montserrat', '', '.ms', '663', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Plymouth', 'XCD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MT', 'MLT', '470', 'Malta', '', '.mt', '356', 'Republic of Malta', 'Independent State', '', '', 'Valletta', 'MTL', 'Lira', 'Malta'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MU', 'MUS', '480', 'Mauritius', '', '.mu', '230', 'Republic of Mauritius', 'Independent State', '', '', 'Port Louis', 'MUR', 'Rupee', 'Mauritius'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MV', 'MDV', '462', 'Maldives', '', '.mv', '960', 'Republic of Maldives', 'Independent State', '', '', 'Male', 'MVR', 'Rufiyaa', 'Malediven'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MW', 'MWI', '454', 'Malawi', '', '.mw', '265', 'Republic of Malawi', 'Independent State', '', '', 'Lilongwe', 'MWK', 'Kwacha', 'Malawi'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MX', 'MEX', '484', 'Mexico', '', '.mx', '52', 'United Mexican States', 'Independent State', '', '', 'Mexico', 'MXN', 'Peso', 'Mexiko'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MY', 'MYS', '458', 'Malaysia', '', '.my', '60', '', 'Independent State', '', '', 'Kuala Lumpur (legislative/judical) and Putrajaya (administrative)', 'MYR', 'Ringgit', 'Malaysia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('MZ', 'MOZ', '508', 'Mozambique', '', '.mz', '258', 'Republic of Mozambique', 'Independent State', '', '', 'Maputo', 'MZM', 'Meticail', 'Mosambik'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NA', 'NAM', '516', 'Namibia', '', '.na', '264', 'Republic of Namibia', 'Independent State', '', '', 'Windhoek', 'NAD', 'Dollar', 'Namibia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NC', 'NCL', '540', 'New Caledonia', '', '.nc', '687', '', 'Dependency', 'Sui generis Collectivity', 'France', 'Noumea', 'XPF', 'Franc', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NE', 'NER', '562', 'Niger', '', '.ne', '227', 'Republic of Niger', 'Independent State', '', '', 'Niamey', 'XOF', 'Franc', 'Niger'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NF', 'NFK', '574', 'Norfolk Island', '', '.nf', '672', 'Territory of Norfolk Island', 'Dependency', 'External Territory', 'Australia', 'Kingston', 'AUD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NG', 'NGA', '566', 'Nigeria', '', '.ng', '234', 'Federal Republic of Nigeria', 'Independent State', '', '', 'Abuja', 'NGN', 'Naira', 'Nigeria'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NI', 'NIC', '558', 'Nicaragua', '', '.ni', '505', 'Republic of Nicaragua', 'Independent State', '', '', 'Managua', 'NIO', 'Cordoba', 'Nicaragua'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NL', 'NLD', '528', 'Netherlands', 'NL', '.nl', '31', 'Kingdom of the Netherlands', 'Independent State', '', '', 'Amsterdam (administrative) and The Hague (legislative/judical)', 'EUR', 'Euro', 'Niederlande'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NO', 'NOR', '578', 'Norway', 'N', '.no', '47', 'Kingdom of Norway', 'Independent State', '', '', 'Oslo', 'NOK', 'Krone', 'Norwegen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NP', 'NPL', '524', 'Nepal', '', '.np', '977', '', 'Independent State', '', '', 'Kathmandu', 'NPR', 'Rupee', 'Nepal'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NR', 'NRU', '520', 'Nauru', '', '.nr', '674', 'Republic of Nauru', 'Independent State', '', '', 'Yaren', 'AUD', 'Dollar', 'Nauru'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NU', 'NIU', '570', 'Niue', '', '.nu', '683', '', 'Dependency', 'Self-Governing in Free Association', 'New Zealand', 'Alofi', 'NZD', 'Dollar', 'Niue'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('NZ', 'NZL', '554', 'New Zealand', 'NZ', '.nz', '64', '', 'Independent State', '', '', 'Wellington', 'NZD', 'Dollar', 'Neuseeland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('OM', 'OMN', '512', 'Oman', '', '.om', '968', 'Sultanate of Oman', 'Independent State', '', '', 'Muscat', 'OMR', 'Rial', 'Oman'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PA', 'PAN', '591', 'Panama', '', '.pa', '507', 'Republic of Panama', 'Independent State', '', '', 'Panama', 'PAB', 'Balboa', 'Panama'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PE', 'PER', '604', 'Peru', '', '.pe', '51', 'Republic of Peru', 'Independent State', '', '', 'Lima', 'PEN', 'Sol', 'Peru'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PG', 'PNG', '598', 'Papua New Guinea', '', '.pg', '675', 'Independent State of Papua New Guinea', 'Independent State', '', '', 'Port Moresby', 'PGK', 'Kina', 'Papua-Neuguinea'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PH', 'PHL', '608', 'Philippines', '', '.ph', '63', 'Republic of the Philippines', 'Independent State', '', '', 'Manila', 'PHP', 'Peso', 'Philippinen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PK', 'PAK', '586', 'Pakistan', '', '.pk', '92', 'Islamic Republic of Pakistan', 'Independent State', '', '', 'Islamabad', 'PKR', 'Rupee', 'Pakistan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PL', 'POL', '616', 'Poland', 'PL', '.pl', '48', 'Republic of Poland', 'Independent State', '', '', 'Warsaw', 'PLN', 'Zloty', 'Polen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PM', 'SPM', '666', 'Saint Pierre and Miquelon', '', '.pm', '508', 'Territorial Collectivity of Saint Pierre and Miquelon', 'Dependency', 'Overseas Collectivity', 'France', 'Saint-Pierre', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PN', 'PCN', '612', 'Pitcairn Islands', '', '.pn', '', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Adamstown', 'NZD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PR', 'PRI', '630', 'Puerto Rico', '', '.pr', '1787;1939', 'Commonwealth of Puerto Rico', 'Dependency', 'Commonwealth', 'United States', 'San Juan', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PT', 'PRT', '620', 'Portugal', 'P', '.pt', '351', 'Portuguese Republic', 'Independent State', '', '', 'Lisbon', 'EUR', 'Euro', 'Portugal'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PW', 'PLW', '585', 'Palau', '', '.pw', '680', 'Republic of Palau', 'Independent State', '', '', 'Melekeok', 'USD', 'Dollar', 'Palau'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('PY', 'PRY', '600', 'Paraguay', '', '.py', '595', 'Republic of Paraguay', 'Independent State', '', '', 'Asuncion', 'PYG', 'Guarani', 'Paraguay'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('QA', 'QAT', '634', 'Qatar', '', '.qa', '974', 'State of Qatar', 'Independent State', '', '', 'Doha', 'QAR', 'Rial', 'Katar'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('RE', 'REU', '638', 'Reunion', '', '.re', '262', 'Overseas Region of Reunion', 'Proto Dependency', 'Overseas Region', 'France', 'Saint-Denis', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('RO', 'ROU', '642', 'Romania', 'RO', '.ro', '40', '', 'Independent State', '', '', 'Bucharest', 'RON', 'Leu', 'Rumänien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('RS', 'SRB', '688', 'Serbia', 'RS', '.rs;.yu', '381', 'Republic of Serbia', 'Independent State', '', '', 'Belgrade', 'RSD', 'Dinar', 'Serbien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('RU', 'RUS', '643', 'Russia', 'RUS', '.ru;.su', '7', 'Russian Federation', 'Independent State', '', '', 'Moscow', 'RUB', 'Ruble', 'Russland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('RW', 'RWA', '646', 'Rwanda', '', '.rw', '250', 'Republic of Rwanda', 'Independent State', '', '', 'Kigali', 'RWF', 'Franc', 'Ruanda'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SA', 'SAU', '682', 'Saudi Arabia', '', '.sa', '966', 'Kingdom of Saudi Arabia', 'Independent State', '', '', 'Riyadh', 'SAR', 'Rial', 'Saudi-Arabien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SB', 'SLB', '90', 'Solomon Islands', '', '.sb', '677', '', 'Independent State', '', '', 'Honiara', 'SBD', 'Dollar', 'Salomonen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SC', 'SYC', '690', 'Seychelles', '', '.sc', '248', 'Republic of Seychelles', 'Independent State', '', '', 'Victoria', 'SCR', 'Rupee', 'Seychellen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SD', 'SDN', '736', 'Sudan', '', '.sd', '249', 'Republic of the Sudan', 'Independent State', '', '', 'Khartoum', 'SDD', 'Dinar', 'Sudan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SE', 'SWE', '752', 'Sweden', 'S', '.se', '46', 'Kingdom of Sweden', 'Independent State', '', '', 'Stockholm', 'SEK', 'Kronoa', 'Schweden'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SG', 'SGP', '702', 'Singapore', '', '.sg', '65', 'Republic of Singapore', 'Independent State', '', '', 'Singapore', 'SGD', 'Dollar', 'Singapur'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SH', 'SHN', '654', 'Saint Helena', '', '.sh', '290', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Jamestown', 'SHP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SI', 'SVN', '705', 'Slovenia', 'SLO', '.si', '386', 'Republic of Slovenia', 'Independent State', '', '', 'Ljubljana', 'EUR', 'Euro', 'Slowenien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SJ', 'SJM', '744', 'Svalbard', '', '.sj', '47', '', 'Proto Dependency', '', 'Norway', 'Longyearbyen', 'NOK', 'Krone', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SK', 'SVK', '703', 'Slovakia', 'SK', '.sk', '421', 'Slovak Republic', 'Independent State', '', '', 'Bratislava', 'SKK', 'Koruna', 'Slowakei'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SL', 'SLE', '694', 'Sierra Leone', '', '.sl', '232', 'Republic of Sierra Leone', 'Independent State', '', '', 'Freetown', 'SLL', 'Leone', 'Sierra Leone'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SM', 'SMR', '674', 'San Marino', 'RSM', '.sm', '378', 'Republic of San Marino', 'Independent State', '', '', 'San Marino', 'EUR', 'Euro', 'San Marino'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SN', 'SEN', '686', 'Senegal', '', '.sn', '221', 'Republic of Senegal', 'Independent State', '', '', 'Dakar', 'XOF', 'Franc', 'Senegal'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SO', 'SOM', '706', 'Somalia', '', '.so', '252', '', 'Independent State', '', '', 'Mogadishu', 'SOS', 'Shilling', 'Somalia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SR', 'SUR', '740', 'Suriname', '', '.sr', '597', 'Republic of Suriname', 'Independent State', '', '', 'Paramaribo', 'SRD', 'Dollar', 'Suriname'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ST', 'STP', '678', 'Sao Tome and Principe', '', '.st', '239', 'Democratic Republic of Sao Tome and Principe', 'Independent State', '', '', 'Sao Tome', 'STD', 'Dobra', 'São Tomé und Príncipe'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SV', 'SLV', '222', 'El Salvador', '', '.sv', '503', 'Republic of El Salvador', 'Independent State', '', '', 'San Salvador', 'USD', 'Dollar', 'El Salvador'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SY', 'SYR', '760', 'Syria', '', '.sy', '963', 'Syrian Arab Republic', 'Independent State', '', '', 'Damascus', 'SYP', 'Pound', 'Syrien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('SZ', 'SWZ', '748', 'Swaziland', '', '.sz', '268', 'Kingdom of Swaziland', 'Independent State', '', '', 'Mbabane (administrative) and Lobamba (legislative)', 'SZL', 'Lilangeni', 'Swasiland'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TA', 'TAA', '', 'Tristan da Cunha', '', '', '290', '', 'Proto Dependency', 'Dependency of Saint Helena', 'United Kingdom', 'Edinburgh', 'SHP', 'Pound', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TC', 'TCA', '796', 'Turks and Caicos Islands', '', '.tc', '648', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Grand Turk', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TD', 'TCD', '148', 'Chad', '', '.td', '235', 'Republic of Chad', 'Independent State', '', '', 'N\'Djamena', 'XAF', 'Franc', 'Tschad'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TG', 'TGO', '768', 'Togo', '', '.tg', '228', 'Togolese Republic', 'Independent State', '', '', 'Lome', 'XOF', 'Franc', 'Togo'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TH', 'THA', '764', 'Thailand', '', '.th', '66', 'Kingdom of Thailand', 'Independent State', '', '', 'Bangkok', 'THB', 'Baht', 'Thailand'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TJ', 'TJK', '762', 'Tajikistan', '', '.tj', '992', 'Republic of Tajikistan', 'Independent State', '', '', 'Dushanbe', 'TJS', 'Somoni', 'Tadschikistan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TK', 'TKL', '772', 'Tokelau', '', '.tk', '690', '', 'Dependency', 'Territory', 'New Zealand', '', 'NZD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TL', 'TLS', '626', 'Timor-Leste (East Timor)', '', '.tp;.tl', '670', 'Democratic Republic of Timor-Leste', 'Independent State', '', '', 'Dili', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TM', 'TKM', '795', 'Turkmenistan', '', '.tm', '993', '', 'Independent State', '', '', 'Ashgabat', 'TMM', 'Manat', 'Turkmenistan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TN', 'TUN', '788', 'Tunisia', 'TN', '.tn', '216', 'Tunisian Republic', 'Independent State', '', '', 'Tunis', 'TND', 'Dinar', 'Tunesien'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TO', 'TON', '776', 'Tonga', '', '.to', '676', 'Kingdom of Tonga', 'Independent State', '', '', 'Nuku\'alofa', 'TOP', 'Pa\'anga', 'Tonga'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TR', 'TUR', '792', 'Turkey', 'TR', '.tr', '90', 'Republic of Turkey', 'Independent State', '', '', 'Ankara', 'TRY', 'Lira', 'Türkei'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TT', 'TTO', '780', 'Trinidad and Tobago', '', '.tt', '867', 'Republic of Trinidad and Tobago', 'Independent State', '', '', 'Port-of-Spain', 'TTD', 'Dollar', 'Trinidad und Tobago'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TV', 'TUV', '798', 'Tuvalu', '', '.tv', '688', '', 'Independent State', '', '', 'Funafuti', 'AUD', 'Dollar', 'Tuvalu'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TW', 'TWN', '158', 'China, Republic of (Taiwan)', '', '.tw', '886', 'Republic of China', 'Proto Independent State', '', '', 'Taipei', 'TWD', 'Dollar', 'Republik China'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('TZ', 'TZA', '834', 'Tanzania', '', '.tz', '255', 'United Republic of Tanzania', 'Independent State', '', '', 'Dar es Salaam (administrative/judical) and Dodoma (legislative)', 'TZS', 'Shilling', 'Tansania'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('UA', 'UKR', '804', 'Ukraine', '', '.ua', '380', '', 'Independent State', '', '', 'Kiev', 'UAH', 'Hryvnia', 'Ukraine'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('UG', 'UGA', '800', 'Uganda', '', '.ug', '256', 'Republic of Uganda', 'Independent State', '', '', 'Kampala', 'UGX', 'Shilling', 'Uganda'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('US', 'USA', '840', 'United States', 'USA', '.us', '1', 'United States of America', 'Independent State', '', '', 'Washington', 'USD', 'Dollar', 'Vereinigte Staaten'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('UY', 'URY', '858', 'Uruguay', '', '.uy', '598', 'Oriental Republic of Uruguay', 'Independent State', '', '', 'Montevideo', 'UYU', 'Peso', 'Uruguay'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('UZ', 'UZB', '860', 'Uzbekistan', '', '.uz', '998', 'Republic of Uzbekistan', 'Independent State', '', '', 'Tashkent', 'UZS', 'Som', 'Usbekistan'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('VA', 'VAT', '336', 'Vatican City', 'SCV', '.va', '379', 'State of the Vatican City', 'Independent State', '', '', 'Vatican City', 'EUR', 'Euro', 'Vatikanstadt'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('VC', 'VCT', '670', 'Saint Vincent and the Grenadines', '', '.vc', '783', '', 'Independent State', '', '', 'Kingstown', 'XCD', 'Dollar', 'St. Vincent und die Grenadinen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('VE', 'VEN', '862', 'Venezuela', '', '.ve', '58', 'Bolivarian Republic of Venezuela', 'Independent State', '', '', 'Caracas', 'VEB', 'Bolivar', 'Venezuela'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('VG', 'VGB', '92', 'British Virgin Islands', '', '.vg', '283', '', 'Dependency', 'Overseas Territory', 'United Kingdom', 'Road Town', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('VI', 'VIR', '850', 'U.S. Virgin Islands', '', '.vi', '339', 'United States Virgin Islands', 'Dependency', 'Territory', 'United States', 'Charlotte Amalie', 'USD', 'Dollar', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('VN', 'VNM', '704', 'Vietnam', '', '.vn', '84', 'Socialist Republic of Vietnam', 'Independent State', '', '', 'Hanoi', 'VND', 'Dong', 'Vietnam'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('VU', 'VUT', '548', 'Vanuatu', '', '.vu', '678', 'Republic of Vanuatu', 'Independent State', '', '', 'Port-Vila', 'VUV', 'Vatu', 'Vanuatu'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('WF', 'WLF', '876', 'Wallis and Futuna', '', '.wf', '681', 'Collectivity of the Wallis and Futuna Islands', 'Dependency', 'Overseas Collectivity', 'France', 'Mata\'utu', 'XPF', 'Franc', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('WS', 'WSM', '882', 'Samoa', '', '.ws', '685', 'Independent State of Samoa', 'Independent State', '', '', 'Apia', 'WST', 'Tala', 'Samoa'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('YE', 'YEM', '887', 'Yemen', '', '.ye', '967', 'Republic of Yemen', 'Independent State', '', '', 'Sanaa', 'YER', 'Rial', 'Jemen'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('YT', 'MYT', '175', 'Mayotte', '', '.yt', '262', 'Departmental Collectivity of Mayotte', 'Dependency', 'Overseas Collectivity', 'France', 'Mamoudzou', 'EUR', 'Euro', NULL); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ZA', 'ZAF', '710', 'South Africa', '', '.za', '27', 'Republic of South Africa', 'Independent State', '', '', 'Pretoria (administrative), Cape Town (legislative), and Bloemfontein (judical)', 'ZAR', 'Rand', 'Südafrika'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ZM', 'ZMB', '894', 'Zambia', '', '.zm', '260', 'Republic of Zambia', 'Independent State', '', '', 'Lusaka', 'ZMK', 'Kwacha', 'Sambia'); | |
| INSERT INTO `adr_land` (`iso31661_alpha2`, `iso31661_alpha3`, `iso31661_number`, `common_name`, `old_post_code`, `tld`, `telephone_code`, `formal_name`, `type`, `subtype`, `sovereignty`, `capital`, `currency_code`, `currency_name`, `german_name`) VALUES | |
| ('ZW', 'ZWE', '716', 'Zimbabwe', '', '.zw', '263', 'Republic of Zimbabwe', 'Independent State', '', '', 'Harare', 'ZWD', 'Dollar', 'Simbabwe'); | |
| /*!40000 ALTER TABLE `adr_land` ENABLE KEYS */; | |
| /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; | |
| /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */; | |
| /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alter table adr_land add german_name varchar(100); | |
| update adr_land set german_name="Abchasien" where iso31661_alpha2="" limit 1; | |
| update adr_land set german_name="Afghanistan" where iso31661_alpha2="AF" limit 1; | |
| update adr_land set german_name="Ägypten" where iso31661_alpha2="EG" limit 1; | |
| update adr_land set german_name="Albanien" where iso31661_alpha2="AL" limit 1; | |
| update adr_land set german_name="Algerien" where iso31661_alpha2="DZ" limit 1; | |
| update adr_land set german_name="Andorra" where iso31661_alpha2="AD" limit 1; | |
| update adr_land set german_name="Angola" where iso31661_alpha2="AO" limit 1; | |
| update adr_land set german_name="Antigua und Barbuda" where iso31661_alpha2="AG" limit 1; | |
| update adr_land set german_name="Äquatorialguinea" where iso31661_alpha2="GQ" limit 1; | |
| update adr_land set german_name="Argentinien" where iso31661_alpha2="AR" limit 1; | |
| update adr_land set german_name="Armenien" where iso31661_alpha2="AM" limit 1; | |
| update adr_land set german_name="Aserbaidschan" where iso31661_alpha2="AZ" limit 1; | |
| update adr_land set german_name="Äthiopien" where iso31661_alpha2="ET" limit 1; | |
| update adr_land set german_name="Australien" where iso31661_alpha2="AU" limit 1; | |
| update adr_land set german_name="Bahamas" where iso31661_alpha2="BS" limit 1; | |
| update adr_land set german_name="Bahrain" where iso31661_alpha2="BH" limit 1; | |
| update adr_land set german_name="Bangladesch" where iso31661_alpha2="BD" limit 1; | |
| update adr_land set german_name="Barbados" where iso31661_alpha2="BB" limit 1; | |
| update adr_land set german_name="Belgien" where iso31661_alpha2="BE" limit 1; | |
| update adr_land set german_name="Belize" where iso31661_alpha2="BZ" limit 1; | |
| update adr_land set german_name="Benin" where iso31661_alpha2="BJ" limit 1; | |
| update adr_land set german_name="Bergkarabach" where iso31661_alpha2="" limit 1; | |
| update adr_land set german_name="Bhutan" where iso31661_alpha2="BT" limit 1; | |
| update adr_land set german_name="Bolivien" where iso31661_alpha2="BO" limit 1; | |
| update adr_land set german_name="Bosnien und Herzegowina" where iso31661_alpha2="BA" limit 1; | |
| update adr_land set german_name="Botswana" where iso31661_alpha2="BW" limit 1; | |
| update adr_land set german_name="Brasilien" where iso31661_alpha2="BR" limit 1; | |
| update adr_land set german_name="Brunei" where iso31661_alpha2="BN" limit 1; | |
| update adr_land set german_name="Bulgarien" where iso31661_alpha2="BG" limit 1; | |
| update adr_land set german_name="Burkina Faso" where iso31661_alpha2="BF" limit 1; | |
| update adr_land set german_name="Burundi" where iso31661_alpha2="BI" limit 1; | |
| update adr_land set german_name="Chile" where iso31661_alpha2="CL" limit 1; | |
| update adr_land set german_name="Republik China" where iso31661_alpha2="TW" limit 1; | |
| update adr_land set german_name="Volksrepublik China" where iso31661_alpha2="CN" limit 1; | |
| update adr_land set german_name="Cookinseln" where iso31661_alpha2="CK" limit 1; | |
| update adr_land set german_name="Costa Rica" where iso31661_alpha2="CR" limit 1; | |
| update adr_land set german_name="Dänemark" where iso31661_alpha2="DK" limit 1; | |
| update adr_land set german_name="Deutschland" where iso31661_alpha2="DE" limit 1; | |
| update adr_land set german_name="Dominica" where iso31661_alpha2="DM" limit 1; | |
| update adr_land set german_name="Dominikanische Republik" where iso31661_alpha2="DO" limit 1; | |
| update adr_land set german_name="Dschibuti" where iso31661_alpha2="DJ" limit 1; | |
| update adr_land set german_name="Ecuador" where iso31661_alpha2="EC" limit 1; | |
| update adr_land set german_name="El Salvador" where iso31661_alpha2="SV" limit 1; | |
| update adr_land set german_name="Elfenbeinküste" where iso31661_alpha2="CI" limit 1; | |
| update adr_land set german_name="Eritrea" where iso31661_alpha2="ER" limit 1; | |
| update adr_land set german_name="Estland" where iso31661_alpha2="EE" limit 1; | |
| update adr_land set german_name="Fidschi" where iso31661_alpha2="FJ" limit 1; | |
| update adr_land set german_name="Finnland" where iso31661_alpha2="FI (SF)" limit 1; | |
| update adr_land set german_name="Frankreich" where iso31661_alpha2="FR" limit 1; | |
| update adr_land set german_name="Gabun" where iso31661_alpha2="GA" limit 1; | |
| update adr_land set german_name="Gambia" where iso31661_alpha2="GM" limit 1; | |
| update adr_land set german_name="Georgien" where iso31661_alpha2="GE" limit 1; | |
| update adr_land set german_name="Ghana" where iso31661_alpha2="GH" limit 1; | |
| update adr_land set german_name="Grenada" where iso31661_alpha2="GD" limit 1; | |
| update adr_land set german_name="Griechenland" where iso31661_alpha2="GR" limit 1; | |
| update adr_land set german_name="Guatemala" where iso31661_alpha2="GT" limit 1; | |
| update adr_land set german_name="Guinea" where iso31661_alpha2="GN" limit 1; | |
| update adr_land set german_name="Guinea-Bissau" where iso31661_alpha2="GW" limit 1; | |
| update adr_land set german_name="Guyana" where iso31661_alpha2="GY" limit 1; | |
| update adr_land set german_name="Haiti" where iso31661_alpha2="HT" limit 1; | |
| update adr_land set german_name="Honduras" where iso31661_alpha2="HN" limit 1; | |
| update adr_land set german_name="Indien" where iso31661_alpha2="IN" limit 1; | |
| update adr_land set german_name="Indonesien" where iso31661_alpha2="ID" limit 1; | |
| update adr_land set german_name="Irak" where iso31661_alpha2="IQ" limit 1; | |
| update adr_land set german_name="Iran" where iso31661_alpha2="IR" limit 1; | |
| update adr_land set german_name="Irland" where iso31661_alpha2="IE" limit 1; | |
| update adr_land set german_name="Island" where iso31661_alpha2="IS" limit 1; | |
| update adr_land set german_name="Israel" where iso31661_alpha2="IL" limit 1; | |
| update adr_land set german_name="Italien" where iso31661_alpha2="IT" limit 1; | |
| update adr_land set german_name="Jamaika" where iso31661_alpha2="JM" limit 1; | |
| update adr_land set german_name="Japan" where iso31661_alpha2="JP" limit 1; | |
| update adr_land set german_name="Jemen" where iso31661_alpha2="YE" limit 1; | |
| update adr_land set german_name="Jordanien" where iso31661_alpha2="JO" limit 1; | |
| update adr_land set german_name="Kambodscha" where iso31661_alpha2="KH" limit 1; | |
| update adr_land set german_name="Kamerun" where iso31661_alpha2="CM" limit 1; | |
| update adr_land set german_name="Kanada" where iso31661_alpha2="CA" limit 1; | |
| update adr_land set german_name="Kap Verde" where iso31661_alpha2="CV" limit 1; | |
| update adr_land set german_name="Kasachstan" where iso31661_alpha2="KZ" limit 1; | |
| update adr_land set german_name="Katar" where iso31661_alpha2="QA" limit 1; | |
| update adr_land set german_name="Kenia" where iso31661_alpha2="KE" limit 1; | |
| update adr_land set german_name="Kirgisistan" where iso31661_alpha2="KG" limit 1; | |
| update adr_land set german_name="Kiribati" where iso31661_alpha2="KI" limit 1; | |
| update adr_land set german_name="Kolumbien" where iso31661_alpha2="CO" limit 1; | |
| update adr_land set german_name="Komoren" where iso31661_alpha2="KM" limit 1; | |
| update adr_land set german_name="Kongo, Demokratische Republik" where iso31661_alpha2="CD" limit 1; | |
| update adr_land set german_name="Kongo, Republik" where iso31661_alpha2="CG" limit 1; | |
| update adr_land set german_name="Korea, Nord" where iso31661_alpha2="KP" limit 1; | |
| update adr_land set german_name="Korea, Süd" where iso31661_alpha2="KR" limit 1; | |
| update adr_land set german_name="Kosovo" where iso31661_alpha2="" limit 1; | |
| update adr_land set german_name="Kroatien" where iso31661_alpha2="HR" limit 1; | |
| update adr_land set german_name="Kuba" where iso31661_alpha2="CU" limit 1; | |
| update adr_land set german_name="Kuwait" where iso31661_alpha2="KW" limit 1; | |
| update adr_land set german_name="Laos" where iso31661_alpha2="LA" limit 1; | |
| update adr_land set german_name="Lesotho" where iso31661_alpha2="LS" limit 1; | |
| update adr_land set german_name="Lettland" where iso31661_alpha2="LV" limit 1; | |
| update adr_land set german_name="Libanon" where iso31661_alpha2="LB" limit 1; | |
| update adr_land set german_name="Liberia" where iso31661_alpha2="LR" limit 1; | |
| update adr_land set german_name="Libyen" where iso31661_alpha2="LY" limit 1; | |
| update adr_land set german_name="Liechtenstein" where iso31661_alpha2="LI" limit 1; | |
| update adr_land set german_name="Litauen" where iso31661_alpha2="LT" limit 1; | |
| update adr_land set german_name="Luxemburg" where iso31661_alpha2="LU" limit 1; | |
| update adr_land set german_name="Madagaskar" where iso31661_alpha2="MG" limit 1; | |
| update adr_land set german_name="Malawi" where iso31661_alpha2="MW" limit 1; | |
| update adr_land set german_name="Malaysia" where iso31661_alpha2="MY" limit 1; | |
| update adr_land set german_name="Malediven" where iso31661_alpha2="MV" limit 1; | |
| update adr_land set german_name="Mali" where iso31661_alpha2="ML" limit 1; | |
| update adr_land set german_name="Malta" where iso31661_alpha2="MT" limit 1; | |
| update adr_land set german_name="Marokko" where iso31661_alpha2="MA" limit 1; | |
| update adr_land set german_name="Marshallinseln" where iso31661_alpha2="MH" limit 1; | |
| update adr_land set german_name="Mauretanien" where iso31661_alpha2="MR" limit 1; | |
| update adr_land set german_name="Mauritius" where iso31661_alpha2="MU" limit 1; | |
| update adr_land set german_name="Mazedonien" where iso31661_alpha2="MK" limit 1; | |
| update adr_land set german_name="Mexiko" where iso31661_alpha2="MX" limit 1; | |
| update adr_land set german_name="Mikronesien" where iso31661_alpha2="FM" limit 1; | |
| update adr_land set german_name="Moldawien" where iso31661_alpha2="MD" limit 1; | |
| update adr_land set german_name="Monaco" where iso31661_alpha2="MC" limit 1; | |
| update adr_land set german_name="Mongolei" where iso31661_alpha2="MN" limit 1; | |
| update adr_land set german_name="Montenegro" where iso31661_alpha2="ME" limit 1; | |
| update adr_land set german_name="Mosambik" where iso31661_alpha2="MZ" limit 1; | |
| update adr_land set german_name="Myanmar" where iso31661_alpha2="MM" limit 1; | |
| update adr_land set german_name="Namibia" where iso31661_alpha2="NA" limit 1; | |
| update adr_land set german_name="Nauru" where iso31661_alpha2="NR" limit 1; | |
| update adr_land set german_name="Nepal" where iso31661_alpha2="NP" limit 1; | |
| update adr_land set german_name="Neuseeland" where iso31661_alpha2="NZ" limit 1; | |
| update adr_land set german_name="Nicaragua" where iso31661_alpha2="NI" limit 1; | |
| update adr_land set german_name="Niederlande" where iso31661_alpha2="NL" limit 1; | |
| update adr_land set german_name="Niger" where iso31661_alpha2="NE" limit 1; | |
| update adr_land set german_name="Nigeria" where iso31661_alpha2="NG" limit 1; | |
| update adr_land set german_name="Niue" where iso31661_alpha2="NU" limit 1; | |
| update adr_land set german_name="Nordzypern" where iso31661_alpha2="" limit 1; | |
| update adr_land set german_name="Norwegen" where iso31661_alpha2="NO" limit 1; | |
| update adr_land set german_name="Oman" where iso31661_alpha2="OM" limit 1; | |
| update adr_land set german_name="Österreich" where iso31661_alpha2="AT" limit 1; | |
| update adr_land set german_name="Osttimor / Timor-Leste" where iso31661_alpha2="TL (TP)" limit 1; | |
| update adr_land set german_name="Pakistan" where iso31661_alpha2="PK" limit 1; | |
| update adr_land set german_name="Palästina" where iso31661_alpha2="PS" limit 1; | |
| update adr_land set german_name="Palau" where iso31661_alpha2="PW" limit 1; | |
| update adr_land set german_name="Panama" where iso31661_alpha2="PA" limit 1; | |
| update adr_land set german_name="Papua-Neuguinea" where iso31661_alpha2="PG" limit 1; | |
| update adr_land set german_name="Paraguay" where iso31661_alpha2="PY" limit 1; | |
| update adr_land set german_name="Peru" where iso31661_alpha2="PE" limit 1; | |
| update adr_land set german_name="Philippinen" where iso31661_alpha2="PH" limit 1; | |
| update adr_land set german_name="Polen" where iso31661_alpha2="PL" limit 1; | |
| update adr_land set german_name="Portugal" where iso31661_alpha2="PT" limit 1; | |
| update adr_land set german_name="Ruanda" where iso31661_alpha2="RW" limit 1; | |
| update adr_land set german_name="Rumänien" where iso31661_alpha2="RO" limit 1; | |
| update adr_land set german_name="Russland" where iso31661_alpha2="RU" limit 1; | |
| update adr_land set german_name="Salomonen" where iso31661_alpha2="SB" limit 1; | |
| update adr_land set german_name="Sambia" where iso31661_alpha2="ZM" limit 1; | |
| update adr_land set german_name="Samoa" where iso31661_alpha2="WS" limit 1; | |
| update adr_land set german_name="San Marino" where iso31661_alpha2="SM" limit 1; | |
| update adr_land set german_name="São Tomé und Príncipe" where iso31661_alpha2="ST" limit 1; | |
| update adr_land set german_name="Saudi-Arabien" where iso31661_alpha2="SA" limit 1; | |
| update adr_land set german_name="Schweden" where iso31661_alpha2="SE" limit 1; | |
| update adr_land set german_name="Schweiz" where iso31661_alpha2="CH" limit 1; | |
| update adr_land set german_name="Senegal" where iso31661_alpha2="SN" limit 1; | |
| update adr_land set german_name="Serbien" where iso31661_alpha2="RS" limit 1; | |
| update adr_land set german_name="Seychellen" where iso31661_alpha2="SC" limit 1; | |
| update adr_land set german_name="Sierra Leone" where iso31661_alpha2="SL" limit 1; | |
| update adr_land set german_name="Simbabwe" where iso31661_alpha2="ZW" limit 1; | |
| update adr_land set german_name="Singapur" where iso31661_alpha2="SG" limit 1; | |
| update adr_land set german_name="Slowakei" where iso31661_alpha2="SK" limit 1; | |
| update adr_land set german_name="Slowenien" where iso31661_alpha2="SI" limit 1; | |
| update adr_land set german_name="Somalia" where iso31661_alpha2="SO" limit 1; | |
| update adr_land set german_name="Somaliland" where iso31661_alpha2="" limit 1; | |
| update adr_land set german_name="Spanien" where iso31661_alpha2="ES" limit 1; | |
| update adr_land set german_name="Sri Lanka" where iso31661_alpha2="LK" limit 1; | |
| update adr_land set german_name="St. Kitts und Nevis" where iso31661_alpha2="KN" limit 1; | |
| update adr_land set german_name="St. Lucia" where iso31661_alpha2="LC" limit 1; | |
| update adr_land set german_name="St. Vincent und die Grenadinen" where iso31661_alpha2="VC" limit 1; | |
| update adr_land set german_name="Südafrika" where iso31661_alpha2="ZA" limit 1; | |
| update adr_land set german_name="Sudan" where iso31661_alpha2="SD" limit 1; | |
| update adr_land set german_name="Südossetien" where iso31661_alpha2="" limit 1; | |
| update adr_land set german_name="Südsudan" where iso31661_alpha2="SS" limit 1; | |
| update adr_land set german_name="Suriname" where iso31661_alpha2="SR" limit 1; | |
| update adr_land set german_name="Swasiland" where iso31661_alpha2="SZ" limit 1; | |
| update adr_land set german_name="Syrien" where iso31661_alpha2="SY" limit 1; | |
| update adr_land set german_name="Tadschikistan" where iso31661_alpha2="TJ" limit 1; | |
| update adr_land set german_name="Tansania" where iso31661_alpha2="TZ" limit 1; | |
| update adr_land set german_name="Thailand" where iso31661_alpha2="TH" limit 1; | |
| update adr_land set german_name="Togo" where iso31661_alpha2="TG" limit 1; | |
| update adr_land set german_name="Tonga" where iso31661_alpha2="TO" limit 1; | |
| update adr_land set german_name="Transnistrien" where iso31661_alpha2="" limit 1; | |
| update adr_land set german_name="Trinidad und Tobago" where iso31661_alpha2="TT" limit 1; | |
| update adr_land set german_name="Tschad" where iso31661_alpha2="TD" limit 1; | |
| update adr_land set german_name="Tschechien" where iso31661_alpha2="CZ" limit 1; | |
| update adr_land set german_name="Tunesien" where iso31661_alpha2="TN" limit 1; | |
| update adr_land set german_name="Türkei" where iso31661_alpha2="TR" limit 1; | |
| update adr_land set german_name="Turkmenistan" where iso31661_alpha2="TM" limit 1; | |
| update adr_land set german_name="Tuvalu" where iso31661_alpha2="TV" limit 1; | |
| update adr_land set german_name="Uganda" where iso31661_alpha2="UG" limit 1; | |
| update adr_land set german_name="Ukraine" where iso31661_alpha2="UA" limit 1; | |
| update adr_land set german_name="Ungarn" where iso31661_alpha2="HU" limit 1; | |
| update adr_land set german_name="Uruguay" where iso31661_alpha2="UY" limit 1; | |
| update adr_land set german_name="Usbekistan" where iso31661_alpha2="UZ" limit 1; | |
| update adr_land set german_name="Vanuatu" where iso31661_alpha2="VU" limit 1; | |
| update adr_land set german_name="Vatikanstadt" where iso31661_alpha2="VA" limit 1; | |
| update adr_land set german_name="Venezuela" where iso31661_alpha2="VE" limit 1; | |
| update adr_land set german_name="Vereinigte Arabische Emirate" where iso31661_alpha2="AE" limit 1; | |
| update adr_land set german_name="Vereinigte Staaten" where iso31661_alpha2="US" limit 1; | |
| update adr_land set german_name="Vereinigtes Königreich" where iso31661_alpha2="GB (UK)" limit 1; | |
| update adr_land set german_name="Vietnam" where iso31661_alpha2="VN" limit 1; | |
| update adr_land set german_name="Weißrussland" where iso31661_alpha2="BY" limit 1; | |
| update adr_land set german_name="Westsahara" where iso31661_alpha2="EH" limit 1; | |
| update adr_land set german_name="Zentralafrikanische Republik" where iso31661_alpha2="CF" limit 1; | |
| update adr_land set german_name="Zypern" where iso31661_alpha2="CY" limit 1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment