lampenstarlampenstar MemberComments: 405 Received thanks: 23 Member since: February 2011 edited October 2011
hallo zusammen, kann mir jemand sagen wo es diese datenbanktabelle zum download gibt?

+++++
s_core_countries
+++++

wir haben am Anfang der Shop Eröffnung alle Länder gelöscht um besseren überblick zu bekommen... und nie gedacht das wir mal in alle Länder Europas senden wollen :-)
jetzt ist es soweit...

Comments

  • lampenstarlampenstar MemberComments: 405 Received thanks: 23 Member since: February 2011
    hab´s bereits gelöst :-)

    sehr nette Seite... so kann man schnell eine Datenbank füllen :-)
    -> http://countrylist.net/
  • technikexperttechnikexpert MemberComments: 118 Received thanks: 9 edited October 2011 Member since: March 2011
    --
    -- Tabellenstruktur für Tabelle `s_core_countries`
    --
    
    CREATE TABLE IF NOT EXISTS `s_core_countries` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `countryname` varchar(255) NOT NULL,
      `countryiso` varchar(255) NOT NULL,
      `countryarea` varchar(35) NOT NULL,
      `countryen` varchar(70) NOT NULL,
      `position` int(1) NOT NULL,
      `notice` text NOT NULL,
      `shippingfree` double NOT NULL,
      `taxfree` int(1) NOT NULL,
      `taxfree_ustid` int(1) NOT NULL,
      `taxfree_ustid_checked` int(1) NOT NULL,
      `active` int(1) NOT NULL DEFAULT '1',
      `iso3` char(3) NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `iso3` (`iso3`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
    
    --
    -- Daten für Tabelle `s_core_countries`
    --
    
    INSERT INTO `s_core_countries` (`id`, `countryname`, `countryiso`, `countryarea`, `countryen`, `position`, `notice`, `shippingfree`, `taxfree`, `taxfree_ustid`, `taxfree_ustid_checked`, `active`, `iso3`) VALUES
    (2, 'Deutschland', 'DE', 'deutschland', 'GERMANY', 0, '', 0, 0, 0, 0, 1, 'DEU'),
    (3, 'Arabische Emirate', 'AE', 'welt', 'ARAB EMIRATES', 1, '', 0, 0, 0, 0, 1, 'ARE'),
    (4, 'Australien', 'AU', 'welt', 'AUSTRALIA', 2, '', 0, 0, 0, 0, 1, 'AUS'),
    (5, 'Belgien', 'BE', 'europa', 'BELGIUM', 18, '', 0, 0, 1, 0, 1, 'BEL'),
    (7, 'Dänemark', 'DK', 'europa', 'DENMARK', 21, '', 0, 0, 1, 0, 1, 'DNK'),
    (8, 'Finnland', 'FI', 'europa', 'FINLAND', 40, '', 0, 0, 1, 0, 1, 'FIN'),
    (9, 'Frankreich', 'FR', 'europa', 'FRANCE', 41, '', 0, 0, 1, 0, 1, 'FRA'),
    (10, 'Griechenland', 'GR', 'europa', 'GREECE', 50, '', 0, 0, 1, 0, 1, 'GRC'),
    (11, 'Großbritannien', 'GB', 'europa', 'GREAT BRITAIN', 51, '', 0, 0, 1, 0, 1, 'GBR'),
    (12, 'Irland', 'IE', 'europa', 'IRELAND', 60, '', 0, 0, 1, 0, 1, 'IRL'),
    (13, 'Island', 'IS', 'europa', 'ICELAND', 61, '', 0, 0, 1, 0, 1, 'ISL'),
    (14, 'Italien', 'IT', 'europa', 'ITALY', 62, '', 0, 0, 1, 0, 1, 'ITA'),
    (15, 'Japan', 'JP', 'welt', 'JAPAN', 70, '', 0, 0, 0, 0, 1, 'JPN'),
    (16, 'Kanada', 'CA', 'welt', 'CANADA', 80, '', 0, 0, 0, 0, 1, 'CAN'),
    (18, 'Luxemburg', 'LU', 'europa', 'LUXEMBOURG', 92, '', 0, 0, 1, 0, 1, 'LUX'),
    (20, 'Namibia', 'NA', 'welt', 'NAMIBIA', 100, '', 0, 0, 0, 0, 1, 'NAM'),
    (21, 'Niederlande', 'NL', 'europa', 'NETHERLANDS', 101, '', 0, 0, 1, 0, 1, 'NLD'),
    (22, 'Norwegen', 'NO', 'europa', 'NORWAY', 102, '', 0, 0, 1, 0, 1, 'NOR'),
    (23, 'Österreich', 'AT', 'europa', 'AUSTRIA', 170, '', 0, 0, 1, 0, 1, 'AUT'),
    (24, 'Portugal', 'PT', 'europa', 'PORTUGAL', 111, '', 0, 0, 1, 0, 1, 'PRT'),
    (25, 'Schweden', 'SE', 'europa', 'SWEDEN', 140, '', 0, 0, 1, 0, 1, 'SWE'),
    (26, 'Schweiz', 'CH', 'europa', 'SWITZERLAND', 141, '', 0, 1, 0, 0, 1, 'CHE'),
    (27, 'Spanien', 'ES', 'europa', 'SPAIN', 143, '', 0, 0, 1, 0, 1, 'ESP'),
    (28, 'USA', 'US', 'welt', 'USA', 35, '', 0, 1, 0, 0, 1, 'USA'),
    (29, 'Liechtenstein', 'LI', 'welt', 'LIECHTENSTEIN', 91, '', 0, 0, 0, 0, 1, 'LIE'),
    (30, 'Polen', 'PL', 'europa', 'POLAND', 110, '', 0, 0, 1, 0, 1, 'POL'),
    (31, 'Ungarn', 'HU', 'europa', 'HUNGARY', 161, '', 0, 0, 1, 0, 1, 'HUN'),
    (32, 'Türkei', 'TR', 'welt', 'TURKEY', 32, '', 0, 0, 0, 0, 1, 'TUR'),
    (33, 'Tschechien', 'CZ', 'europa', 'CZECH REPUBLIC', 150, '', 0, 0, 1, 0, 1, 'CZE'),
    (34, 'Slowakei', 'SK', 'europa', 'SLOVAKIA', 142, '', 0, 0, 1, 0, 1, 'SVK'),
    (35, 'Rumänien', 'RO', 'europa', 'ROMANIA', 120, '', 0, 0, 1, 0, 1, 'ROU'),
    (36, 'Brasilien', 'BR', 'welt', 'BRAZIL', 4, '', 0, 0, 0, 0, 1, 'BRA'),
    (37, 'Israel', 'IL', 'welt', 'ISRAEL', 14, '', 0, 0, 0, 0, 1, 'ISR'),
    (38, 'Ukraine', 'UA', 'welt', 'UKRAINE', 160, '', 0, 1, 0, 0, 1, 'UKR'),
    (39, 'Estland', 'EE', 'europa', 'ESTONIA', 30, '', 0, 0, 1, 0, 1, 'EST'),
    (40, 'Russland', 'RU', 'welt', 'RUSSIA', 121, '', 0, 1, 0, 0, 1, 'RUS'),
    (41, 'Lettland', 'LV', 'europa', 'Latvia', 90, '', 0, 0, 1, 0, 1, 'LVA'),
    (42, 'Bulgarien', 'BG', 'europa', 'BULGARIA', 19, '', 0, 0, 1, 0, 1, 'BGR'),
    (43, 'Aland', 'AX', 'europa', 'Åland Islands', 3, '', 0, 0, 0, 0, 1, 'ALA'),
    (44, 'Albanien', 'AL', 'europa', 'Albania', 4, '', 0, 0, 0, 0, 1, 'ALB'),
    (45, 'Andorra', 'AD', 'europa', 'Andorra', 8, '', 0, 0, 0, 0, 1, 'AND'),
    (46, 'Bosnien und Herzegowina', 'BA', 'europa', 'Bosnia And Herzegovina', 31, '', 0, 0, 0, 0, 1, 'BIH'),
    (47, 'Färöer', 'FO', 'europa', 'Faroe Islands', 58, '', 0, 0, 0, 0, 1, 'FRO'),
    (48, 'Georgien', 'GE', 'europa', 'Georgia', 67, '', 0, 0, 0, 0, 1, 'GEO'),
    (49, 'Guernsey, Vogtei', 'GG', 'europa', 'Guernsey', 76, '', 0, 0, 0, 0, 1, 'GGY'),
    (50, 'Jersey', 'JE', 'europa', 'Jersey', 96, '', 0, 0, 0, 0, 1, 'JEY'),
    (51, 'Kanarische Inseln', 'IC', 'europa', 'Canary Islands ', 102, '', 0, 0, 0, 0, 1, ''),
    (52, 'Kroatien', 'HR', 'europa', 'Croatia', 116, '', 0, 0, 0, 0, 1, 'HRV'),
    (53, 'Litauen', 'LT', 'europa', 'Lithuania', 126, '', 0, 0, 1, 0, 1, 'LTU'),
    (54, 'Malta', 'MT', 'europa', 'Malta', 134, '', 0, 0, 1, 0, 1, 'MLT'),
    (55, 'Mazedonien', 'MK', 'europa', 'Macedonia, The Former Yugoslav Republic Of', 141, '', 0, 0, 0, 0, 1, 'MKD'),
    (56, 'Moldawien', 'MD', 'europa', 'Moldova', 144, '', 0, 0, 0, 0, 1, 'MDA'),
    (57, 'Monaco', 'MC', 'europa', 'Monaco', 145, '', 0, 0, 0, 0, 1, 'MCO'),
    (58, 'San Marino', 'SM', 'europa', 'San Marino', 186, '', 0, 0, 0, 0, 1, 'SMR'),
    (59, 'Serbien und Montenegro', 'CS', 'europa', 'Serbia and Montenegro ', 192, '', 0, 0, 0, 0, 1, 'SCG'),
    (60, 'Slowenien', 'SI', 'europa', 'Slovenia', 198, '', 0, 0, 1, 0, 1, 'SVN'),
    (61, 'Svalbard und Jan Mayen', 'SJ', 'europa', 'Svalbard And Jan Mayen', 210, '', 0, 0, 0, 0, 1, 'SJM'),
    (62, 'Vatikanstadt', 'VA', 'europa', 'Holy See (vatican City State)', 236, '', 0, 0, 0, 0, 1, 'VAT'),
    (63, 'Weißrussland', 'BY', 'europa', 'Belarus', 244, '', 0, 0, 0, 0, 1, 'BLR'),
    (64, 'Afghanistan', 'AF', 'welt', 'Afghanistan', 1, '', 0, 1, 0, 0, 1, 'AFG'),
    (65, 'Ägypten', 'EG', 'welt', 'Egypt', 2, '', 0, 1, 0, 0, 1, 'EGY'),
    (66, 'Algerien', 'DZ', 'welt', 'Algeria', 5, '', 0, 1, 0, 0, 1, 'DZA'),
    (67, 'Amerikanisch-Samoa', 'AS', 'welt', 'American Samoa', 6, '', 0, 1, 0, 0, 1, 'ASM'),
    (68, 'Amerikanische Jungferninseln', 'VI', 'welt', 'Virgin Islands, U.s.', 7, '', 0, 1, 0, 0, 1, 'VIR'),
    (69, 'Angola', 'AO', 'welt', 'Angola', 9, '', 0, 1, 0, 0, 1, 'AGO'),
    (70, 'Anguilla', 'AI', 'welt', 'Anguilla', 10, '', 0, 1, 0, 0, 1, 'AIA'),
    (71, 'Antarktis', 'AQ', 'welt', 'Antarctica', 11, '', 0, 1, 0, 0, 1, 'ATA'),
    (72, 'Antigua und Barbuda', 'AG', 'welt', 'Antigua And Barbuda', 12, '', 0, 1, 0, 0, 1, 'ATG'),
    (73, 'Äquatorialguinea, Republik', 'GQ', 'welt', 'Equatorial Guinea', 13, '', 0, 1, 0, 0, 1, 'GNQ'),
    (74, 'Argentinien', 'AR', 'welt', 'Argentina', 14, '', 0, 1, 0, 0, 1, 'ARG'),
    (75, 'Armenien', 'AM', 'welt', 'Armenia', 15, '', 0, 1, 0, 0, 1, 'ARM'),
    (76, 'Aruba', 'AW', 'welt', 'Aruba', 16, '', 0, 1, 0, 0, 1, 'ABW'),
    (77, 'Ascension', 'AC', 'welt', 'Ascension', 17, '', 0, 1, 0, 0, 1, 'ASC'),
    (78, 'Aserbaidschan', 'AZ', 'welt', 'Azerbaijan', 18, '', 0, 1, 0, 0, 1, 'AZE'),
    (79, 'Äthiopien', 'ET', 'welt', 'Ethiopia', 19, '', 0, 1, 0, 0, 1, 'ETH'),
    (80, 'Bahamas', 'BS', 'welt', 'Bahamas', 21, '', 0, 1, 0, 0, 1, 'BHS'),
    (81, 'Bahrain', 'BH', 'welt', 'Bahrain', 22, '', 0, 1, 0, 0, 1, 'BHR'),
    (82, 'Bangladesch', 'BD', 'welt', 'Bangladesh', 23, '', 0, 1, 0, 0, 1, 'BGD'),
    (83, 'Barbados', 'BB', 'welt', 'Barbados', 24, '', 0, 1, 0, 0, 1, 'BRB'),
    (84, 'Belize', 'BZ', 'welt', 'Belize', 26, '', 0, 1, 0, 0, 1, 'BLZ'),
    (85, 'Benin', 'BJ', 'welt', 'Benin', 27, '', 0, 1, 0, 0, 1, 'BEN'),
    (86, 'Bermuda', 'BM', 'welt', 'Bermuda', 28, '', 0, 1, 0, 0, 1, 'BMU'),
    (87, 'Bhutan', 'BT', 'welt', 'Bhutan', 29, '', 0, 1, 0, 0, 1, 'BTN'),
    (88, 'Bolivien', 'BO', 'welt', 'Bolivia', 30, '', 0, 1, 0, 0, 1, 'BOL'),
    (89, 'Botswana', 'BW', 'welt', 'Botswana', 32, '', 0, 1, 0, 0, 1, 'BWA'),
    (90, 'Bouvetinsel', 'BV', 'welt', 'Bouvet Island', 33, '', 0, 1, 0, 0, 1, 'BVT'),
    (91, 'Britische Jungferninseln', 'VG', 'welt', 'Virgin Islands, British', 35, '', 0, 1, 0, 0, 1, 'VGB'),
    (92, 'Britisches Territorium im Indischen Ozean', 'IO', 'welt', 'British Indian Ocean Territory', 36, '', 0, 1, 0, 0, 1, 'IOT'),
    (93, 'Brunei', 'BN', 'welt', 'Brunei Darussalam', 37, '', 0, 1, 0, 0, 1, 'BRN'),
    (94, 'Burkina Faso', 'BF', 'welt', 'Burkina Faso', 39, '', 0, 1, 0, 0, 1, 'BFA'),
    (95, 'Burundi', 'BI', 'welt', 'Burundi', 40, '', 0, 1, 0, 0, 1, 'BDI'),
    (96, 'Chile', 'CL', 'welt', 'Chile', 41, '', 0, 1, 0, 0, 1, 'CHL'),
    (97, 'China, Volksrepublik', 'CN', 'welt', 'China', 42, '', 0, 1, 0, 0, 1, 'CHN'),
    (98, 'Cookinseln', 'CK', 'welt', 'Cook Islands', 43, '', 0, 1, 0, 0, 1, 'COK'),
    (99, 'Costa Rica', 'CR', 'welt', 'Costa Rica', 44, '', 0, 1, 0, 0, 1, 'CRI'),
    (100, 'Cote d''Ivoire', 'CI', 'welt', 'CÔte D''ivoire', 45, '', 0, 1, 0, 0, 1, 'CIV'),
    (101, 'Die Kronkolonie St. Helena und Nebengebiete', 'SH', 'welt', 'Saint Helena', 47, '', 0, 1, 0, 0, 1, 'SHN'),
    (102, 'Diego Garcia', 'DG', 'welt', 'Diego Garcia', 48, '', 0, 1, 0, 0, 1, 'DGA'),
    (103, 'Dominica', 'DM', 'welt', 'Dominica', 49, '', 0, 1, 0, 0, 1, 'DMA'),
    (104, 'Dominikanische Republik', 'DO', 'welt', 'Dominican Republic', 50, '', 0, 1, 0, 0, 1, 'DOM'),
    (105, 'Dschibuti', 'DJ', 'welt', 'Djibouti', 51, '', 0, 1, 0, 0, 1, 'DJI'),
    (106, 'Ecuador', 'EC', 'welt', 'Ecuador', 52, '', 0, 1, 0, 0, 1, 'ECU'),
    (107, 'El Salvador', 'SV', 'welt', 'El Salvador', 53, '', 0, 1, 0, 0, 1, 'SLV'),
    (108, 'Eritrea', 'ER', 'welt', 'Eritrea', 54, '', 0, 1, 0, 0, 1, 'ERI'),
    (109, 'Falklandinseln', 'FK', 'welt', 'Falkland Islands (malvinas)', 57, '', 0, 1, 0, 0, 1, 'FLK'),
    (110, 'Fidschi', 'FJ', 'welt', 'Fiji', 59, '', 0, 1, 0, 0, 1, 'FJI'),
    (111, 'Französisch-Guayana', 'GF', 'welt', 'French Guiana', 62, '', 0, 1, 0, 0, 1, 'GUF'),
    (112, 'Französisch-Polynesien', 'PF', 'welt', 'French Polynesia', 63, '', 0, 1, 0, 0, 1, 'PYF'),
    (113, 'Gabun', 'GA', 'welt', 'Gabon', 65, '', 0, 1, 0, 0, 1, 'GAB'),
    (114, 'Gambia', 'GM', 'welt', 'Gambia', 66, '', 0, 1, 0, 0, 1, 'GMB'),
    (115, 'Ghana, Republik', 'GH', 'welt', 'Ghana', 68, '', 0, 1, 0, 0, 1, 'GHA'),
    (116, 'Gibraltar', 'GI', 'welt', 'Gibraltar', 69, '', 0, 1, 0, 0, 1, 'GIB'),
    (117, 'Grenada', 'GD', 'welt', 'Grenada', 70, '', 0, 1, 0, 0, 1, 'GRD'),
    (118, 'Grönland', 'GL', 'welt', 'Greenland', 72, '', 0, 1, 0, 0, 1, 'GRL'),
    (119, 'Guadeloupe', 'GP', 'welt', 'Guadeloupe', 73, '', 0, 1, 0, 0, 1, 'GLP'),
    (120, 'Guam', 'GU', 'welt', 'Guam', 74, '', 0, 1, 0, 0, 1, 'GUM'),
    (121, 'Guatemala', 'GT', 'welt', 'Guatemala', 75, '', 0, 1, 0, 0, 1, 'GTM'),
    (122, 'Guinea, Republik', 'GN', 'welt', 'Guinea', 77, '', 0, 1, 0, 0, 1, 'GIN'),
    (123, 'Guinea-Bissau, Republik', 'GW', 'welt', 'Guinea-bissau', 78, '', 0, 1, 0, 0, 1, 'GNB'),
    (124, 'Guyana', 'GY', 'welt', 'Guyana', 79, '', 0, 1, 0, 0, 1, 'GUY'),
    (125, 'Haiti', 'HT', 'welt', 'Haiti', 80, '', 0, 1, 0, 0, 1, 'HTI'),
    (126, 'Heard und McDonaldinseln', 'HM', 'welt', 'Heard Island And Mcdonald Islands', 81, '', 0, 1, 0, 0, 1, 'HMD'),
    (127, 'Honduras', 'HN', 'welt', 'Honduras', 82, '', 0, 1, 0, 0, 1, 'HND'),
    (128, 'Hongkong', 'HK', 'welt', 'Hong Kong', 83, '', 0, 1, 0, 0, 1, 'HKG'),
    (129, 'Indien', 'IN', 'welt', 'India', 84, '', 0, 1, 0, 0, 1, 'IND'),
    (130, 'Indonesien', 'ID', 'welt', 'Indonesia', 85, '', 0, 1, 0, 0, 1, 'IDN'),
    (131, 'Insel Man', 'IM', 'welt', 'Isle Of Man', 86, '', 0, 1, 0, 0, 1, 'IMN'),
    (132, 'Irak', 'IQ', 'welt', 'Iraq', 87, '', 0, 1, 0, 0, 1, 'IRQ'),
    (133, 'Iran', 'IR', 'welt', 'Iran, Islamic Republic Of', 88, '', 0, 1, 0, 0, 1, 'IRN'),
    (134, 'Jamaika', 'JM', 'welt', 'Jamaica', 93, '', 0, 1, 0, 0, 1, 'JAM'),
    (135, 'Jemen', 'YE', 'welt', 'Yemen', 95, '', 0, 1, 0, 0, 1, 'YEM'),
    (136, 'Jordanien', 'JO', 'welt', 'Jordan', 97, '', 0, 1, 0, 0, 1, 'JOR'),
    (137, 'Kaimaninseln', 'KY', 'welt', 'Cayman Islands', 98, '', 0, 1, 0, 0, 1, 'CYM'),
    (138, 'Kambodscha', 'KH', 'welt', 'Cambodia', 99, '', 0, 1, 0, 0, 1, 'KHM'),
    (139, 'Kamerun', 'CM', 'welt', 'Cameroon', 100, '', 0, 1, 0, 0, 1, 'CMR'),
    (140, 'Kap Verde, Republik', 'CV', 'welt', 'Cape Verde', 103, '', 0, 1, 0, 0, 1, 'CPV'),
    (141, 'Kasachstan', 'KZ', 'welt', 'Kazakhstan', 104, '', 0, 1, 0, 0, 1, 'KAZ'),
    (142, 'Katar', 'QA', 'welt', 'Qatar', 105, '', 0, 1, 0, 0, 1, 'QAT'),
    (143, 'Kenia', 'KE', 'welt', 'Kenya', 106, '', 0, 1, 0, 0, 1, 'KEN'),
    (144, 'Kirgisistan', 'KG', 'welt', 'Kyrgyzstan', 107, '', 0, 1, 0, 0, 1, 'KGZ'),
    (145, 'Kiribati', 'KI', 'welt', 'Kiribati', 108, '', 0, 1, 0, 0, 1, 'KIR'),
    (146, 'Kokosinseln', 'CC', 'welt', 'Cocos (keeling) Islands', 109, '', 0, 1, 0, 0, 1, 'CCK'),
    (147, 'Kolumbien', 'CO', 'welt', 'Colombia', 110, '', 0, 1, 0, 0, 1, 'COL'),
    (148, 'Kongo, Demokratische Republik', 'CD', 'welt', 'Congo, The Democratic Republic Of The', 112, '', 0, 1, 0, 0, 1, 'COD'),
    (149, 'Kongo, Republik', 'CG', 'welt', 'Congo', 113, '', 0, 1, 0, 0, 1, 'COG'),
    (150, 'Korea, Demokratische Volkrepublik', 'KP', 'welt', 'Korea, Democratic People''s Republic Of', 114, '', 0, 1, 0, 0, 1, 'PRK'),
    (151, 'Korea, Republik', 'KR', 'welt', 'Korea, Republic Of', 115, '', 0, 1, 0, 0, 1, 'KOR'),
    (152, 'Kuba', 'CU', 'welt', 'Cuba', 117, '', 0, 1, 0, 0, 1, 'CUB'),
    (153, 'Kuwait', 'KW', 'welt', 'Kuwait', 118, '', 0, 1, 0, 0, 1, 'KWT'),
    (154, 'Laos', 'LA', 'welt', 'Lao People''s Democratic Republic', 119, '', 0, 1, 0, 0, 1, 'LAO'),
    (155, 'Lesotho', 'LS', 'welt', 'Lesotho', 120, '', 0, 1, 0, 0, 1, 'LSO'),
    (156, 'Libanon', 'LB', 'welt', 'Lebanon', 122, '', 0, 1, 0, 0, 1, 'LBN'),
    (157, 'Liberia, Republik', 'LR', 'welt', 'Liberia', 123, '', 0, 1, 0, 0, 1, 'LBR'),
    (158, 'Libyen', 'LY', 'welt', 'Libyan Arab Jamahiriya', 124, '', 0, 1, 0, 0, 1, 'LBY'),
    (159, 'Macao', 'MO', 'welt', 'Macao', 128, '', 0, 1, 0, 0, 1, 'MAC'),
    (160, 'Madagaskar, Republik', 'MG', 'welt', 'Madagascar', 129, '', 0, 1, 0, 0, 1, 'MDG'),
    (161, 'Malawi, Republik', 'MW', 'welt', 'Malawi', 130, '', 0, 1, 0, 0, 1, 'MWI'),
    (162, 'Malaysia', 'MY', 'welt', 'Malaysia', 131, '', 0, 1, 0, 0, 1, 'MYS'),
    (163, 'Malediven', 'MV', 'welt', 'Maldives', 132, '', 0, 1, 0, 0, 1, 'MDV'),
    (164, 'Mali, Republik', 'ML', 'welt', 'Mali', 133, '', 0, 1, 0, 0, 1, 'MLI'),
    (165, 'Marokko', 'MA', 'welt', 'Morocco', 135, '', 0, 1, 0, 0, 1, 'MAR'),
    (166, 'Marshallinseln', 'MH', 'welt', 'Marshall Islands', 136, '', 0, 1, 0, 0, 1, 'MHL'),
    (167, 'Martinique', 'MQ', 'welt', 'Martinique', 137, '', 0, 1, 0, 0, 1, 'MTQ'),
    (168, 'Mauretanien', 'MR', 'welt', 'Mauritania', 138, '', 0, 1, 0, 0, 1, 'MRT'),
    (169, 'Mauritius, Republik', 'MU', 'welt', 'Mauritius', 139, '', 0, 1, 0, 0, 1, 'MUS'),
    (170, 'Mayotte', 'YT', 'welt', 'Mayotte', 140, '', 0, 1, 0, 0, 1, 'MYT'),
    (171, 'Mexiko', 'MX', 'welt', 'Mexico', 142, '', 0, 1, 0, 0, 1, 'MEX'),
    (172, 'Mikronesien, Föderierte Staaten von', 'FM', 'welt', 'Micronesia, Federated States Of', 143, '', 0, 1, 0, 0, 1, 'FSM'),
    (173, 'Mongolei', 'MN', 'welt', 'Mongolia', 146, '', 0, 1, 0, 0, 1, 'MNG'),
    (174, 'Montserrat', 'MS', 'welt', 'Montserrat', 147, '', 0, 1, 0, 0, 1, 'MSR'),
    (175, 'Mosambik', 'MZ', 'welt', 'Mozambique', 148, '', 0, 1, 0, 0, 1, 'MOZ'),
    (176, 'Myanmar', 'MM', 'welt', 'Myanmar', 149, '', 0, 1, 0, 0, 1, 'MMR'),
    (177, 'Nauru', 'NR', 'welt', 'Nauru', 151, '', 0, 1, 0, 0, 1, 'NRU'),
    (178, 'Nepal', 'NP', 'welt', 'Nepal', 152, '', 0, 1, 0, 0, 1, 'NPL'),
    (179, 'Neukaledonien', 'NC', 'welt', 'New Caledonia', 153, '', 0, 1, 0, 0, 1, 'NCL'),
    (180, 'Neuseeland', 'NZ', 'welt', 'New Zealand', 154, '', 0, 1, 0, 0, 1, 'NZL'),
    (181, 'Nicaragua', 'NI', 'welt', 'Nicaragua', 156, '', 0, 1, 0, 0, 1, 'NIC'),
    (182, 'Niederländische Antillen', 'AN', 'welt', 'Netherlands Antilles', 158, '', 0, 1, 0, 0, 1, 'ANT'),
    (183, 'Niger', 'NE', 'welt', 'Niger', 159, '', 0, 1, 0, 0, 1, 'NER'),
    (184, 'Nigeria', 'NG', 'welt', 'Nigeria', 160, '', 0, 1, 0, 0, 1, 'NGA'),
    (185, 'Niue', 'NU', 'welt', 'Niue', 161, '', 0, 1, 0, 0, 1, 'NIU'),
    (186, 'Nördliche Marianen', 'MP', 'welt', 'Northern Mariana Islands', 162, '', 0, 1, 0, 0, 1, 'MNP'),
    (187, 'Norfolkinsel', 'NF', 'welt', 'Norfolk Island', 163, '', 0, 1, 0, 0, 1, 'NFK'),
    (188, 'Oman', 'OM', 'welt', 'Oman', 165, '', 0, 1, 0, 0, 1, 'OMN'),
    (189, 'Pakistan', 'PK', 'welt', 'Pakistan', 167, '', 0, 1, 0, 0, 1, 'PAK'),
    (190, 'Palästinensische Autonomiegebiete', 'PS', 'welt', 'Palestinian Territory, Occupied', 168, '', 0, 1, 0, 0, 1, 'PSE'),
    (191, 'Palau', 'PW', 'welt', 'Palau', 169, '', 0, 1, 0, 0, 1, 'PLW'),
    (192, 'Panama', 'PA', 'welt', 'Panama', 170, '', 0, 1, 0, 0, 1, 'PAN'),
    (193, 'Papua-Neuguinea', 'PG', 'welt', 'Papua New Guinea', 171, '', 0, 1, 0, 0, 1, 'PNG'),
    (194, 'Paraguay', 'PY', 'welt', 'Paraguay', 172, '', 0, 1, 0, 0, 1, 'PRY'),
    (195, 'Peru', 'PE', 'welt', 'Peru', 173, '', 0, 1, 0, 0, 1, 'PER'),
    (196, 'Philippinen', 'PH', 'welt', 'Philippines', 174, '', 0, 1, 0, 0, 1, 'PHL'),
    (197, 'Pitcairninseln', 'PN', 'welt', 'Pitcairn', 175, '', 0, 1, 0, 0, 1, 'PCN'),
    (198, 'Puerto Rico', 'PR', 'welt', 'Puerto Rico', 178, '', 0, 1, 0, 0, 1, 'PRI'),
    (199, 'Réunion', 'RE', 'welt', 'RÉunion', 179, '', 0, 1, 0, 0, 1, 'REU'),
    (200, 'Ruanda, Republik', 'RW', 'welt', 'Rwanda', 180, '', 0, 1, 0, 0, 1, 'RWA'),
    (201, 'Salomonen', 'SB', 'welt', 'Solomon Islands', 183, '', 0, 1, 0, 0, 1, 'SLB'),
    (202, 'Sambia, Republik', 'ZM', 'welt', 'Zambia', 184, '', 0, 1, 0, 0, 1, 'ZMB'),
    (203, 'Samoa', 'WS', 'welt', 'Samoa', 185, '', 0, 1, 0, 0, 1, 'WSM'),
    (204, 'São Tomé und Príncipe', 'ST', 'welt', 'Sao Tome And Principe', 187, '', 0, 1, 0, 0, 1, 'STP'),
    (205, 'Saudi-Arabien, Königreich', 'SA', 'welt', 'Saudi Arabia', 188, '', 0, 1, 0, 0, 1, 'SAU'),
    (206, 'Senegal', 'SN', 'welt', 'Senegal', 191, '', 0, 1, 0, 0, 1, 'SEN'),
    (207, 'Seychellen, Republik der', 'SC', 'welt', 'Seychelles', 193, '', 0, 1, 0, 0, 1, 'SYC'),
    (208, 'Sierra Leone, Republik', 'SL', 'welt', 'Sierra Leone', 194, '', 0, 1, 0, 0, 1, 'SLE'),
    (209, 'Simbabwe, Republik', 'ZW', 'welt', 'Zimbabwe', 195, '', 0, 1, 0, 0, 1, 'ZWE'),
    (210, 'Singapur', 'SG', 'welt', 'Singapore', 196, '', 0, 1, 0, 0, 1, 'SGP'),
    (211, 'Somalia, Demokratische Republik', 'SO', 'welt', 'Somalia', 199, '', 0, 1, 0, 0, 1, 'SOM'),
    (212, 'Sri Lanka', 'LK', 'welt', 'Sri Lanka', 201, '', 0, 1, 0, 0, 1, 'LKA'),
    (213, 'St. Kitts und Nevis', 'KN', 'welt', 'Saint Kitts And Nevis', 202, '', 0, 1, 0, 0, 1, 'KNA'),
    (214, 'St. Lucia', 'LC', 'welt', 'Saint Lucia', 203, '', 0, 1, 0, 0, 1, 'LCA'),
    (215, 'St. Pierre und Miquelon', 'PM', 'welt', 'Saint Pierre And Miquelon', 204, '', 0, 1, 0, 0, 1, 'SPM'),
    (216, 'St. Vincent und die Grenadinen (GB)', 'VC', 'welt', 'Saint Vincent And The Grenadines', 205, '', 0, 1, 0, 0, 1, 'VCT'),
    (217, 'Südafrika, Republik', 'ZA', 'welt', 'South Africa', 206, '', 0, 1, 0, 0, 1, 'ZAF'),
    (218, 'Sudan', 'SD', 'welt', 'Sudan', 207, '', 0, 1, 0, 0, 1, 'SDN'),
    (219, 'Südgeorgien und die Südlichen Sandwichinseln', 'GS', 'welt', 'South Georgia And The South Sandwich Islands', 208, '', 0, 1, 0, 0, 1, 'SGS'),
    (220, 'Suriname', 'SR', 'welt', 'Suriname', 209, '', 0, 1, 0, 0, 1, 'SUR'),
    (221, 'Swasiland', 'SZ', 'welt', 'Swaziland', 211, '', 0, 1, 0, 0, 1, 'SWZ'),
    (222, 'Syrien', 'SY', 'welt', 'Syrian Arab Republic', 212, '', 0, 1, 0, 0, 1, 'SYR'),
    (223, 'Tadschikistan', 'TJ', 'welt', 'Tajikistan', 213, '', 0, 1, 0, 0, 1, 'TJK'),
    (224, 'Taiwan', 'TW', 'welt', 'Taiwan, Province Of China', 214, '', 0, 1, 0, 0, 1, 'TWN'),
    (225, 'Tansania, Vereinigte Republik', 'TZ', 'welt', 'Tanzania, United Republic Of', 215, '', 0, 1, 0, 0, 1, 'TZA'),
    (226, 'Thailand', 'TH', 'welt', 'Thailand', 216, '', 0, 1, 0, 0, 1, 'THA'),
    (227, 'Timor-Leste, Demokratische Republik', 'TL', 'welt', 'Timor-leste', 217, '', 0, 1, 0, 0, 1, 'TLS'),
    (228, 'Togo, Republik', 'TG', 'welt', 'Togo', 218, '', 0, 1, 0, 0, 1, 'TGO'),
    (229, 'Tokelau', 'TK', 'welt', 'Tokelau', 219, '', 0, 1, 0, 0, 1, 'TKL'),
    (230, 'Tonga', 'TO', 'welt', 'Tonga', 220, '', 0, 1, 0, 0, 1, 'TON'),
    (231, 'Trinidad und Tobago', 'TT', 'welt', 'Trinidad And Tobago', 221, '', 0, 1, 0, 0, 1, 'TTO'),
    (232, 'Tristan da Cunha', 'TA', 'welt', 'Tristan da Cunha', 222, '', 0, 1, 0, 0, 1, 'TAA'),
    (233, 'Tschad, Republik', 'TD', 'welt', 'Chad', 223, '', 0, 1, 0, 0, 1, 'TCD'),
    (234, 'Tunesien', 'TN', 'welt', 'Tunisia', 225, '', 0, 1, 0, 0, 1, 'TUN'),
    (235, 'Turkmenistan', 'TM', 'welt', 'Turkmenistan', 227, '', 0, 1, 0, 0, 1, 'TKM'),
    (236, 'Turks- und Caicosinseln', 'TC', 'welt', 'Turks And Caicos Islands', 228, '', 0, 1, 0, 0, 1, 'TCA'),
    (237, 'Tuvalu', 'TV', 'welt', 'Tuvalu', 229, '', 0, 1, 0, 0, 1, 'TUV'),
    (238, 'Uganda, Republik', 'UG', 'welt', 'Uganda', 230, '', 0, 1, 0, 0, 1, 'UGA'),
    (239, 'Uruguay', 'UY', 'welt', 'Uruguay', 233, '', 0, 1, 0, 0, 1, 'URY'),
    (240, 'Usbekistan', 'UZ', 'welt', 'Uzbekistan', 234, '', 0, 1, 0, 0, 1, 'UZB'),
    (241, 'Vanuatu', 'VU', 'welt', 'Vanuatu', 235, '', 0, 1, 0, 0, 1, 'VUT'),
    (242, 'Venezuela', 'VE', 'welt', 'Venezuela', 237, '', 0, 1, 0, 0, 1, 'VEN'),
    (243, 'Vietnam', 'VN', 'welt', 'Viet Nam', 241, '', 0, 1, 0, 0, 1, 'VNM'),
    (244, 'Wallis und Futuna', 'WF', 'welt', 'Wallis And Futuna', 242, '', 0, 1, 0, 0, 1, 'WLF'),
    (245, 'Weihnachtsinsel', 'CX', 'welt', 'Christmas Island', 243, '', 0, 1, 0, 0, 1, 'CXR'),
    (246, 'Westsahara', 'EH', 'welt', 'Western Sahara', 245, '', 0, 1, 0, 0, 1, 'ESH'),
    (247, 'Zentralafrikanische Republik', 'CF', 'welt', 'Central African Republic', 246, '', 0, 1, 0, 0, 1, 'CAF'),
    (248, 'Zypern, Republik', 'CY', 'welt', 'Cyprus', 247, '', 0, 1, 1, 0, 1, 'CYP');
    
    Thanked by 1Gizmodo
  • yshieldyshield MemberComments: 12 Received thanks: 2 Member since: September 2011
    Hallo Technikexpert und/oder die anderen Profis hier!

    Bitte bitte um kurze Hilfe, wie ich Deine Tabelle in meine Datenbank bekomme! Hab den MYSQLDUMPER installiert. Tabelle "s_core_countries" auch gefunden. Was muss ich oben in das SQL Feld oben eingeben, damit dann alle Länder drinstehen?

    Vielen Dank Euch allen!
    Christian.
  • technikexperttechnikexpert MemberComments: 118 Received thanks: 9 Member since: March 2011
    1. Tabelle s_core_countries sichern.
    2. Tabelle s_core_countries leeren
    3. In phpmyadmin oben genanntes code ausführen.
  • schreibwaren-ihleeschreibwaren-ihlee MemberComments: 107 Received thanks: 3 Member since: May 2013

    Hallo,

    alles gemacht, wird auch dementsprechend angezeigt, einzig ist die Vorauswahl Ukraine und nicht Deutschland bzw. Land*

    Bei der Lieferadresse zeigt es Land* an, bei der Rechnungsadresse in der Dropdown "Ukraine". Wo kann ich das ändern das da auch Land* oder Deutschland als erstes angezeigt wird?

     

    Tommy

Sign In or Register to comment.