-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 27. Oktober 2008 um 17:32
-- Server Version: 5.0.32
-- PHP-Version: 5.2.0-8+etch13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `countries`
--

CREATE TABLE IF NOT EXISTS `countries` (
  `countries_id` int(11) NOT NULL auto_increment,
  `countries_name` varchar(64) collate latin1_german1_ci NOT NULL,
  `countries_iso_code_2` char(2) collate latin1_german1_ci NOT NULL,
  `countries_iso_code_3` char(3) collate latin1_german1_ci NOT NULL,
  `address_format_id` int(11) NOT NULL,
  `status` int(1) default '1',
  PRIMARY KEY  (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=240 ;

--
-- Daten für Tabelle `countries`
--

INSERT INTO `countries` (`countries_id`, `countries_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`, `status`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', 1, 1),
(2, 'Albanien', 'AL', 'ALB', 1, 1),
(3, 'Algerien', 'DZ', 'DZA', 1, 1),
(4, 'Amerikanisch-Samoa', 'AS', 'ASM', 1, 1),
(5, 'Andorra', 'AD', 'AND', 1, 1),
(6, 'Angola', 'AO', 'AGO', 1, 1),
(7, 'Anguilla', 'AI', 'AIA', 1, 1),
(8, 'Antarktis', 'AQ', 'ATA', 1, 1),
(9, 'Antigua und Barbuda', 'AG', 'ATG', 1, 1),
(10, 'Argentinien', 'AR', 'ARG', 1, 1),
(11, 'Armenien', 'AM', 'ARM', 1, 1),
(12, 'Aruba', 'AW', 'ABW', 1, 1),
(13, 'Australien', 'AU', 'AUS', 1, 1),
(14, 'Österreich', 'AT', 'AUT', 5, 1),
(15, 'Aserbaidschan', 'AZ', 'AZE', 1, 1),
(16, 'Bahamas', 'BS', 'BHS', 1, 1),
(17, 'Bahrain', 'BH', 'BHR', 1, 1),
(18, 'Bangladesch', 'BD', 'BGD', 1, 1),
(19, 'Barbados', 'BB', 'BRB', 1, 1),
(20, 'Weißrussland', 'BY', 'BLR', 1, 1),
(21, 'Belgien', 'BE', 'BEL', 1, 1),
(22, 'Belize', 'BZ', 'BLZ', 1, 1),
(23, 'Benin', 'BJ', 'BEN', 1, 1),
(24, 'Bermuda', 'BM', 'BMU', 1, 1),
(25, 'Bhutan', 'BT', 'BTN', 1, 1),
(26, 'Bolivien', 'BO', 'BOL', 1, 1),
(27, 'Bosnien und Herzegowina', 'BA', 'BIH', 1, 1),
(28, 'Botsuana', 'BW', 'BWA', 1, 1),
(29, 'Bouvetinsel', 'BV', 'BVT', 1, 1),
(30, 'Brasilien', 'BR', 'BRA', 1, 1),
(31, 'Britisches Territorium im Indischen Ozean', 'IO', 'IOT', 1, 1),
(32, 'Brunei', 'BN', 'BRN', 1, 1),
(33, 'Bulgarien', 'BG', 'BGR', 1, 1),
(34, 'Burkina Faso', 'BF', 'BFA', 1, 1),
(35, 'Burundi', 'BI', 'BDI', 1, 1),
(36, 'Kambodscha', 'KH', 'KHM', 1, 1),
(37, 'Kamerun', 'CM', 'CMR', 1, 1),
(38, 'Kanada', 'CA', 'CAN', 1, 1),
(39, 'Kap Verde', 'CV', 'CPV', 1, 1),
(40, 'Kaimaninseln', 'KY', 'CYM', 1, 1),
(41, 'Zentralafrikanische Republik', 'CF', 'CAF', 1, 1),
(42, 'Tschad', 'TD', 'TCD', 1, 1),
(43, 'Chile', 'CL', 'CHL', 1, 1),
(44, 'China', 'CN', 'CHN', 1, 1),
(45, 'Weihnachtsinsel (Australien)', 'CX', 'CXR', 1, 1),
(46, 'Kokosinseln', 'CC', 'CCK', 1, 1),
(47, 'Kolumbien', 'CO', 'COL', 1, 1),
(48, 'Komoren', 'KM', 'COM', 1, 1),
(49, 'Kongo', 'CG', 'COG', 1, 1),
(50, 'Cookinseln', 'CK', 'COK', 1, 1),
(51, 'Costa Rica', 'CR', 'CRI', 1, 1),
(52, 'Elfenbeinküste', 'CI', 'CIV', 1, 1),
(53, 'Kroatien', 'HR', 'HRV', 1, 1),
(54, 'Kuba', 'CU', 'CUB', 1, 1),
(55, 'Republik Zypern', 'CY', 'CYP', 1, 1),
(56, 'Tschechien', 'CZ', 'CZE', 1, 1),
(57, 'Dänemark', 'DK', 'DNK', 1, 1),
(58, 'Dschibuti', 'DJ', 'DJI', 1, 1),
(59, 'Dominica', 'DM', 'DMA', 1, 1),
(60, 'Dominikanische Republik', 'DO', 'DOM', 1, 1),
(61, 'Osttimor', 'TP', 'TMP', 1, 1),
(62, 'Ecuador', 'EC', 'ECU', 1, 1),
(63, 'Ägypten', 'EG', 'EGY', 1, 1),
(64, 'El Salvador', 'SV', 'SLV', 1, 1),
(65, 'Äquatorialguinea', 'GQ', 'GNQ', 1, 1),
(66, 'Eritrea', 'ER', 'ERI', 1, 1),
(67, 'Estland', 'EE', 'EST', 1, 1),
(68, 'Äthiopien', 'ET', 'ETH', 1, 1),
(69, 'Falklandinseln', 'FK', 'FLK', 1, 1),
(70, 'Färöer', 'FO', 'FRO', 1, 1),
(71, 'Fidschi', 'FJ', 'FJI', 1, 1),
(72, 'Finnland', 'FI', 'FIN', 1, 1),
(73, 'Frankreich', 'FR', 'FRA', 1, 1),
(74, 'Metropolitan-Frankreich', 'FX', 'FXX', 1, 1),
(75, 'Französisch-Guayana', 'GF', 'GUF', 1, 1),
(76, 'Französisch-Polynesien', 'PF', 'PYF', 1, 1),
(77, 'Französische Süd- und Antarktisgebiete', 'TF', 'ATF', 1, 1),
(78, 'Gabun', 'GA', 'GAB', 1, 1),
(79, 'Gambia', 'GM', 'GMB', 1, 1),
(80, 'Georgien', 'GE', 'GEO', 1, 1),
(81, 'Deutschland', 'DE', 'DEU', 5, 1),
(82, 'Ghana', 'GH', 'GHA', 1, 1),
(83, 'Gibraltar', 'GI', 'GIB', 1, 1),
(84, 'Griechenland', 'GR', 'GRC', 1, 1),
(85, 'Grönland', 'GL', 'GRL', 1, 1),
(86, 'Grenada', 'GD', 'GRD', 1, 1),
(87, 'Guadeloupe', 'GP', 'GLP', 1, 1),
(88, 'Guam', 'GU', 'GUM', 1, 1),
(89, 'Guatemala', 'GT', 'GTM', 1, 1),
(90, 'Guinea', 'GN', 'GIN', 1, 1),
(91, 'Guinea-Bissau', 'GW', 'GNB', 1, 1),
(92, 'Guyana', 'GY', 'GUY', 1, 1),
(93, 'Haiti', 'HT', 'HTI', 1, 1),
(94, 'Heard und McDonaldinseln', 'HM', 'HMD', 1, 1),
(95, 'Honduras', 'HN', 'HND', 1, 1),
(96, 'Hong Kong', 'HK', 'HKG', 1, 1),
(97, 'Ungarn', 'HU', 'HUN', 1, 1),
(98, 'Island', 'IS', 'ISL', 1, 1),
(99, 'Indien', 'IN', 'IND', 1, 1),
(100, 'Indonesien', 'ID', 'IDN', 1, 1),
(101, 'Iran', 'IR', 'IRN', 1, 1),
(102, 'Irak', 'IQ', 'IRQ', 1, 1),
(103, 'Irland', 'IE', 'IRL', 1, 1),
(104, 'Israel', 'IL', 'ISR', 1, 1),
(105, 'Italien', 'IT', 'ITA', 1, 1),
(106, 'Jamaika', 'JM', 'JAM', 1, 1),
(107, 'Japan', 'JP', 'JPN', 1, 1),
(108, 'Jordanien', 'JO', 'JOR', 1, 1),
(109, 'Kasachstan', 'KZ', 'KAZ', 1, 1),
(110, 'Kenia', 'KE', 'KEN', 1, 1),
(111, 'Kiribati', 'KI', 'KIR', 1, 1),
(112, 'Nordkorea', 'KP', 'PRK', 1, 1),
(113, 'Südkorea', 'KR', 'KOR', 1, 1),
(114, 'Kuwait', 'KW', 'KWT', 1, 1),
(115, 'Kirgisistan', 'KG', 'KGZ', 1, 1),
(116, 'Laos', 'LA', 'LAO', 1, 1),
(117, 'Lettland', 'LV', 'LVA', 1, 1),
(118, 'Libanon', 'LB', 'LBN', 1, 1),
(119, 'Lesotho', 'LS', 'LSO', 1, 1),
(120, 'Liberia', 'LR', 'LBR', 1, 1),
(121, 'Libyen', 'LY', 'LBY', 1, 1),
(122, 'Liechtenstein', 'LI', 'LIE', 1, 1),
(123, 'Litauen', 'LT', 'LTU', 1, 1),
(124, 'Luxemburg', 'LU', 'LUX', 1, 1),
(125, 'Macao', 'MO', 'MAC', 1, 1),
(126, 'Mazedonien', 'MK', 'MKD', 1, 1),
(127, 'Madagaskar', 'MG', 'MDG', 1, 1),
(128, 'Malawi', 'MW', 'MWI', 1, 1),
(129, 'Malaysia', 'MY', 'MYS', 1, 1),
(130, 'Malediven', 'MV', 'MDV', 1, 1),
(131, 'Mali', 'ML', 'MLI', 1, 1),
(132, 'Malta', 'MT', 'MLT', 1, 1),
(133, 'Marshallinseln', 'MH', 'MHL', 1, 1),
(134, 'Martinique', 'MQ', 'MTQ', 1, 1),
(135, 'Mauretanien', 'MR', 'MRT', 1, 1),
(136, 'Mauritius', 'MU', 'MUS', 1, 1),
(137, 'Mayotte', 'YT', 'MYT', 1, 1),
(138, 'Mexiko', 'MX', 'MEX', 1, 1),
(139, 'Mikronesien, Föderierte Staaten von', 'FM', 'FSM', 1, 1),
(140, 'Moldawien', 'MD', 'MDA', 1, 1),
(141, 'Monaco', 'MC', 'MCO', 1, 1),
(142, 'Mongolei', 'MN', 'MNG', 1, 1),
(143, 'Montserrat', 'MS', 'MSR', 1, 1),
(144, 'Marokko', 'MA', 'MAR', 1, 1),
(145, 'Mosambik', 'MZ', 'MOZ', 1, 1),
(146, 'Myanmar', 'MM', 'MMR', 1, 1),
(147, 'Namibia', 'NA', 'NAM', 1, 1),
(148, 'Nauru', 'NR', 'NRU', 1, 1),
(149, 'Nepal', 'NP', 'NPL', 1, 1),
(150, 'Niederlande', 'NL', 'NLD', 1, 1),
(151, 'Niederländische Antillen', 'AN', 'ANT', 1, 1),
(152, 'Neukaledonien', 'NC', 'NCL', 1, 1),
(153, 'Neuseeland', 'NZ', 'NZL', 1, 1),
(154, 'Nicaragua', 'NI', 'NIC', 1, 1),
(155, 'Niger', 'NE', 'NER', 1, 1),
(156, 'Nigeria', 'NG', 'NGA', 1, 1),
(157, 'Niue', 'NU', 'NIU', 1, 1),
(158, 'Norfolkinsel', 'NF', 'NFK', 1, 1),
(159, 'Nördliche Marianen', 'MP', 'MNP', 1, 1),
(160, 'Norwegen', 'NO', 'NOR', 1, 1),
(161, 'Oman', 'OM', 'OMN', 1, 1),
(162, 'Pakistan', 'PK', 'PAK', 1, 1),
(163, 'Palau', 'PW', 'PLW', 1, 1),
(164, 'Panama', 'PA', 'PAN', 1, 1),
(165, 'Papua-Neuguinea', 'PG', 'PNG', 1, 1),
(166, 'Paraguay', 'PY', 'PRY', 1, 1),
(167, 'Peru', 'PE', 'PER', 1, 1),
(168, 'Philippinen', 'PH', 'PHL', 1, 1),
(169, 'Pitcairninseln', 'PN', 'PCN', 1, 1),
(170, 'Polen', 'PL', 'POL', 1, 1),
(171, 'Portugal', 'PT', 'PRT', 1, 1),
(172, 'Puerto Rico', 'PR', 'PRI', 1, 1),
(173, 'Katar', 'QA', 'QAT', 1, 1),
(174, 'Reunion', 'RE', 'REU', 1, 1),
(175, 'Rumänien', 'RO', 'ROM', 1, 1),
(176, 'Russland', 'RU', 'RUS', 1, 1),
(177, 'Ruanda', 'RW', 'RWA', 1, 1),
(178, 'St. Kitts und Nevis', 'KN', 'KNA', 1, 1),
(179, 'St. Lucia', 'LC', 'LCA', 1, 1),
(180, 'St. Vincent und die Grenadinen', 'VC', 'VCT', 1, 1),
(181, 'Samoa', 'WS', 'WSM', 1, 1),
(182, 'San Marino', 'SM', 'SMR', 1, 1),
(183, 'São Tomé und Príncipe', 'ST', 'STP', 1, 1),
(184, 'Saudi-Arabien', 'SA', 'SAU', 1, 1),
(185, 'Senegal', 'SN', 'SEN', 1, 1),
(186, 'Seychellen', 'SC', 'SYC', 1, 1),
(187, 'Sierra Leone', 'SL', 'SLE', 1, 1),
(188, 'Singapur', 'SG', 'SGP', 4, 1),
(189, 'Slowakei', 'SK', 'SVK', 1, 1),
(190, 'Slowenien', 'SI', 'SVN', 1, 1),
(191, 'Salomonen', 'SB', 'SLB', 1, 1),
(192, 'Somalia', 'SO', 'SOM', 1, 1),
(193, 'Südafrika', 'ZA', 'ZAF', 1, 1),
(194, 'Südgeorgien und die Südlichen Sandwichinseln', 'GS', 'SGS', 1, 1),
(195, 'Spanien', 'ES', 'ESP', 3, 1),
(196, 'Sri Lanka', 'LK', 'LKA', 1, 1),
(197, 'St. Helena', 'SH', 'SHN', 1, 1),
(198, 'Saint-Pierre und Miquelon', 'PM', 'SPM', 1, 1),
(199, 'Sudan', 'SD', 'SDN', 1, 1),
(200, 'Suriname', 'SR', 'SUR', 1, 1),
(201, 'Svalbard und Jan Mayen', 'SJ', 'SJM', 1, 1),
(202, 'Swasiland', 'SZ', 'SWZ', 1, 1),
(203, 'Schweden', 'SE', 'SWE', 1, 1),
(204, 'Schweiz', 'CH', 'CHE', 1, 1),
(205, 'Syrien', 'SY', 'SYR', 1, 1),
(206, 'Taiwan', 'TW', 'TWN', 1, 1),
(207, 'Tadschikistan', 'TJ', 'TJK', 1, 1),
(208, 'Tansania', 'TZ', 'TZA', 1, 1),
(209, 'Thailand', 'TH', 'THA', 1, 1),
(210, 'Togo', 'TG', 'TGO', 1, 1),
(211, 'Tokelau', 'TK', 'TKL', 1, 1),
(212, 'Tonga', 'TO', 'TON', 1, 1),
(213, 'Trinidad und Tobago', 'TT', 'TTO', 1, 1),
(214, 'Tunesien', 'TN', 'TUN', 1, 1),
(215, 'Türkei', 'TR', 'TUR', 1, 1),
(216, 'Turkmenistan', 'TM', 'TKM', 1, 1),
(217, 'Turks- und Caicosinseln', 'TC', 'TCA', 1, 1),
(218, 'Tuvalu', 'TV', 'TUV', 1, 1),
(219, 'Uganda', 'UG', 'UGA', 1, 1),
(220, 'Ukraine', 'UA', 'UKR', 1, 1),
(221, 'Vereinigte Arabische Emirate', 'AE', 'ARE', 1, 1),
(222, 'Vereinigtes Königreich', 'GB', 'GBR', 1, 1),
(223, 'Vereinigte Staaten', 'US', 'USA', 2, 1),
(224, 'United States Minor Outlying Islands', 'UM', 'UMI', 1, 1),
(225, 'Uruguay', 'UY', 'URY', 1, 1),
(226, 'Usbekistan', 'UZ', 'UZB', 1, 1),
(227, 'Vanuatu', 'VU', 'VUT', 1, 1),
(228, 'Vatikanstadt', 'VA', 'VAT', 1, 1),
(229, 'Venezuela', 'VE', 'VEN', 1, 1),
(230, 'Vietnam', 'VN', 'VNM', 1, 1),
(231, 'Jungferninseln, Britische', 'VG', 'VGB', 1, 1),
(232, 'Jungferninseln, Amerikanische', 'VI', 'VIR', 1, 1),
(233, 'Wallis und Futuna', 'WF', 'WLF', 1, 1),
(234, 'Westsahara', 'EH', 'ESH', 1, 1),
(235, 'Jemen', 'YE', 'YEM', 1, 1),
(236, 'Jugoslawien', 'YU', 'YUG', 1, 1),
(237, 'Demokratische Republik Kongo', 'ZR', 'ZAR', 1, 1),
(238, 'Sambia', 'ZM', 'ZMB', 1, 1),
(239, 'Simbabwe', 'ZW', 'ZWE', 1, 1);