Fehlzuordnung Staaten-Regionen

Betrifft modified eCommerce Shopsoftware Version <=1.04

Durch eine Aktualisierung von Staaten ist eine Fehlzuordnung in der Länderliste, Regionen-Staaten, aufgetreten. Ob eure Version betroffen ist erkennt ihr daran ob die Regionen der Schweiz unter Swaziland (Afrika) zu finden sind. Mit folgenden SQL-Anweisungen wird das Problem behoben:

 delete from countries;
 INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1','1');
 INSERT INTO countries VALUES (2,'Albania','AL','ALB','1','1');
 INSERT INTO countries VALUES (3,'Algeria','DZ','DZA','1','1');
 INSERT INTO countries VALUES (4,'American Samoa','AS','ASM','1','1');
 INSERT INTO countries VALUES (5,'Andorra','AD','AND','1','1');
 INSERT INTO countries VALUES (6,'Angola','AO','AGO','1','1');
 INSERT INTO countries VALUES (7,'Anguilla','AI','AIA','1','1');
 INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA','1','1');
 INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG','1','1');
 INSERT INTO countries VALUES (10,'Argentina','AR','ARG','1','1');
 INSERT INTO countries VALUES (11,'Armenia','AM','ARM','1','1');
 INSERT INTO countries VALUES (12,'Aruba','AW','ABW','1','1');
 INSERT INTO countries VALUES (13,'Australia','AU','AUS','1','1');
 INSERT INTO countries VALUES (14,'Austria','AT','AUT','5','1');
 INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE','1','1');
 INSERT INTO countries VALUES (16,'Bahamas','BS','BHS','1','1');
 INSERT INTO countries VALUES (17,'Bahrain','BH','BHR','1','1');
 INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD','1','1');
 INSERT INTO countries VALUES (19,'Barbados','BB','BRB','1','1');
 INSERT INTO countries VALUES (20,'Belarus','BY','BLR','1','1');
 INSERT INTO countries VALUES (21,'Belgium','BE','BEL','1','1');
 INSERT INTO countries VALUES (22,'Belize','BZ','BLZ','1','1');
 INSERT INTO countries VALUES (23,'Benin','BJ','BEN','1','1');
 INSERT INTO countries VALUES (24,'Bermuda','BM','BMU','1','1');
 INSERT INTO countries VALUES (25,'Bhutan','BT','BTN','1','1');
 INSERT INTO countries VALUES (26,'Bolivia','BO','BOL','1','1');
 INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1','1');
 INSERT INTO countries VALUES (28,'Botswana','BW','BWA','1','1');
 INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT','1','1');
 INSERT INTO countries VALUES (30,'Brazil','BR','BRA','1','1');
 INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1','1');
 INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN','1','1');
 INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR','1','1');
 INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA','1','1');
 INSERT INTO countries VALUES (35,'Burundi','BI','BDI','1','1');
 INSERT INTO countries VALUES (36,'Cambodia','KH','KHM','1','1');
 INSERT INTO countries VALUES (37,'Cameroon','CM','CMR','1','1');
 INSERT INTO countries VALUES (38,'Canada','CA','CAN','1','1');
 INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV','1','1');
 INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM','1','1');
 INSERT INTO countries VALUES (41,'Central African Republic','CF','CAF','1','1');
 INSERT INTO countries VALUES (42,'Chad','TD','TCD','1','1');
 INSERT INTO countries VALUES (43,'Chile','CL','CHL','1','1');
 INSERT INTO countries VALUES (44,'China','CN','CHN','1','1');
 INSERT INTO countries VALUES (45,'Christmas Island','CX','CXR','1','1');
 INSERT INTO countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','1','1');
 INSERT INTO countries VALUES (47,'Colombia','CO','COL','1','1');
 INSERT INTO countries VALUES (48,'Comoros','KM','COM','1','1');
 INSERT INTO countries VALUES (49,'Congo','CG','COG','1','1');
 INSERT INTO countries VALUES (50,'Cook Islands','CK','COK','1','1');
 INSERT INTO countries VALUES (51,'Costa Rica','CR','CRI','1','1');
 INSERT INTO countries VALUES (52,'Cote D\'Ivoire','CI','CIV','1','1');
 INSERT INTO countries VALUES (53,'Croatia','HR','HRV','1','1');
 INSERT INTO countries VALUES (54,'Cuba','CU','CUB','1','1');
 INSERT INTO countries VALUES (55,'Cyprus','CY','CYP','1','1');
 INSERT INTO countries VALUES (56,'Czech Republic','CZ','CZE','1','1');
 INSERT INTO countries VALUES (57,'Denmark','DK','DNK','1','1');
 INSERT INTO countries VALUES (58,'Djibouti','DJ','DJI','1','1');
 INSERT INTO countries VALUES (59,'Dominica','DM','DMA','1','1');
 INSERT INTO countries VALUES (60,'Dominican Republic','DO','DOM','1','1');
 INSERT INTO countries VALUES (61,'East Timor','TP','TMP','1','1');
 INSERT INTO countries VALUES (62,'Ecuador','EC','ECU','1','1');
 INSERT INTO countries VALUES (63,'Egypt','EG','EGY','1','1');
 INSERT INTO countries VALUES (64,'El Salvador','SV','SLV','1','1');
 INSERT INTO countries VALUES (65,'Equatorial Guinea','GQ','GNQ','1','1');
 INSERT INTO countries VALUES (66,'Eritrea','ER','ERI','1','1');
 INSERT INTO countries VALUES (67,'Estonia','EE','EST','1','1');
 INSERT INTO countries VALUES (68,'Ethiopia','ET','ETH','1','1');
 INSERT INTO countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','1','1');
 INSERT INTO countries VALUES (70,'Faroe Islands','FO','FRO','1','1');
 INSERT INTO countries VALUES (71,'Fiji','FJ','FJI','1','1');
 INSERT INTO countries VALUES (72,'Finland','FI','FIN','1','1');
 INSERT INTO countries VALUES (73,'France','FR','FRA','1','1');
 INSERT INTO countries VALUES (74,'France, Metropolitan','FX','FXX','1','1');
 INSERT INTO countries VALUES (75,'French Guiana','GF','GUF','1','1');
 INSERT INTO countries VALUES (76,'French Polynesia','PF','PYF','1','1');
 INSERT INTO countries VALUES (77,'French Southern Territories','TF','ATF','1','1');
 INSERT INTO countries VALUES (78,'Gabon','GA','GAB','1','1');
 INSERT INTO countries VALUES (79,'Gambia','GM','GMB','1','1');
 INSERT INTO countries VALUES (80,'Georgia','GE','GEO','1','1');
 INSERT INTO countries VALUES (81,'Germany','DE','DEU','5','1');
 INSERT INTO countries VALUES (82,'Ghana','GH','GHA','1','1');
 INSERT INTO countries VALUES (83,'Gibraltar','GI','GIB','1','1');
 INSERT INTO countries VALUES (84,'Greece','GR','GRC','1','1');
 INSERT INTO countries VALUES (85,'Greenland','GL','GRL','1','1');
 INSERT INTO countries VALUES (86,'Grenada','GD','GRD','1','1');
 INSERT INTO countries VALUES (87,'Guadeloupe','GP','GLP','1','1');
 INSERT INTO countries VALUES (88,'Guam','GU','GUM','1','1');
 INSERT INTO countries VALUES (89,'Guatemala','GT','GTM','1','1');
 INSERT INTO countries VALUES (90,'Guinea','GN','GIN','1','1');
 INSERT INTO countries VALUES (91,'Guinea-bissau','GW','GNB','1','1');
 INSERT INTO countries VALUES (92,'Guyana','GY','GUY','1','1');
 INSERT INTO countries VALUES (93,'Haiti','HT','HTI','1','1');
 INSERT INTO countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','1','1');
 INSERT INTO countries VALUES (95,'Honduras','HN','HND','1','1');
 INSERT INTO countries VALUES (96,'Hong Kong','HK','HKG','1','1');
 INSERT INTO countries VALUES (97,'Hungary','HU','HUN','1','1');
 INSERT INTO countries VALUES (98,'Iceland','IS','ISL','1','1');
 INSERT INTO countries VALUES (99,'India','IN','IND','1','1');
 INSERT INTO countries VALUES (100,'Indonesia','ID','IDN','1','1');
 INSERT INTO countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','1','1');
 INSERT INTO countries VALUES (102,'Iraq','IQ','IRQ','1','1');
 INSERT INTO countries VALUES (103,'Ireland','IE','IRL','1','1');
 INSERT INTO countries VALUES (104,'Israel','IL','ISR','1','1');
 INSERT INTO countries VALUES (105,'Italy','IT','ITA','1','1');
 INSERT INTO countries VALUES (106,'Jamaica','JM','JAM','1','1');
 INSERT INTO countries VALUES (107,'Japan','JP','JPN','1','1');
 INSERT INTO countries VALUES (108,'Jordan','JO','JOR','1','1');
 INSERT INTO countries VALUES (109,'Kazakhstan','KZ','KAZ','1','1');
 INSERT INTO countries VALUES (110,'Kenya','KE','KEN','1','1');
 INSERT INTO countries VALUES (111,'Kiribati','KI','KIR','1','1');
 INSERT INTO countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','1','1');
 INSERT INTO countries VALUES (113,'Korea, Republic of','KR','KOR','1','1');
 INSERT INTO countries VALUES (114,'Kuwait','KW','KWT','1','1');
 INSERT INTO countries VALUES (115,'Kyrgyzstan','KG','KGZ','1','1');
 INSERT INTO countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO','1','1');
 INSERT INTO countries VALUES (117,'Latvia','LV','LVA','1','1');
 INSERT INTO countries VALUES (118,'Lebanon','LB','LBN','1','1');
 INSERT INTO countries VALUES (119,'Lesotho','LS','LSO','1','1');
 INSERT INTO countries VALUES (120,'Liberia','LR','LBR','1','1');
 INSERT INTO countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','1','1');
 INSERT INTO countries VALUES (122,'Liechtenstein','LI','LIE','1','1');
 INSERT INTO countries VALUES (123,'Lithuania','LT','LTU','1','1');
 INSERT INTO countries VALUES (124,'Luxembourg','LU','LUX','1','1');
 INSERT INTO countries VALUES (125,'Macau','MO','MAC','1','1');
 INSERT INTO countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','1','1');
 INSERT INTO countries VALUES (127,'Madagascar','MG','MDG','1','1');
 INSERT INTO countries VALUES (128,'Malawi','MW','MWI','1','1');
 INSERT INTO countries VALUES (129,'Malaysia','MY','MYS','1','1');
 INSERT INTO countries VALUES (130,'Maldives','MV','MDV','1','1');
 INSERT INTO countries VALUES (131,'Mali','ML','MLI','1','1');
 INSERT INTO countries VALUES (132,'Malta','MT','MLT','1','1');
 INSERT INTO countries VALUES (133,'Marshall Islands','MH','MHL','1','1');
 INSERT INTO countries VALUES (134,'Martinique','MQ','MTQ','1','1');
 INSERT INTO countries VALUES (135,'Mauritania','MR','MRT','1','1');
 INSERT INTO countries VALUES (136,'Mauritius','MU','MUS','1','1');
 INSERT INTO countries VALUES (137,'Mayotte','YT','MYT','1','1');
 INSERT INTO countries VALUES (138,'Mexico','MX','MEX','1','1');
 INSERT INTO countries VALUES (139,'Micronesia, Federated States of','FM','FSM','1','1');
 INSERT INTO countries VALUES (140,'Moldova, Republic of','MD','MDA','1','1');
 INSERT INTO countries VALUES (141,'Monaco','MC','MCO','1','1');
 INSERT INTO countries VALUES (142,'Mongolia','MN','MNG','1','1');
 INSERT INTO countries VALUES (143,'Montserrat','MS','MSR','1','1');
 INSERT INTO countries VALUES (144,'Morocco','MA','MAR','1','1');
 INSERT INTO countries VALUES (145,'Mozambique','MZ','MOZ','1','1');
 INSERT INTO countries VALUES (146,'Myanmar','MM','MMR','1','1');
 INSERT INTO countries VALUES (147,'Namibia','NA','NAM','1','1');
 INSERT INTO countries VALUES (148,'Nauru','NR','NRU','1','1');
 INSERT INTO countries VALUES (149,'Nepal','NP','NPL','1','1');
 INSERT INTO countries VALUES (150,'Netherlands','NL','NLD','1','1');
 INSERT INTO countries VALUES (151,'Netherlands Antilles','AN','ANT','1','1');
 INSERT INTO countries VALUES (152,'New Caledonia','NC','NCL','1','1');
 INSERT INTO countries VALUES (153,'New Zealand','NZ','NZL','1','1');
 INSERT INTO countries VALUES (154,'Nicaragua','NI','NIC','1','1');
 INSERT INTO countries VALUES (155,'Niger','NE','NER','1','1');
 INSERT INTO countries VALUES (156,'Nigeria','NG','NGA','1','1');
 INSERT INTO countries VALUES (157,'Niue','NU','NIU','1','1');
 INSERT INTO countries VALUES (158,'Norfolk Island','NF','NFK','1','1');
 INSERT INTO countries VALUES (159,'Northern Mariana Islands','MP','MNP','1','1');
 INSERT INTO countries VALUES (160,'Norway','NO','NOR','1','1');
 INSERT INTO countries VALUES (161,'Oman','OM','OMN','1','1');
 INSERT INTO countries VALUES (162,'Pakistan','PK','PAK','1','1');
 INSERT INTO countries VALUES (163,'Palau','PW','PLW','1','1');
 INSERT INTO countries VALUES (164,'Panama','PA','PAN','1','1');
 INSERT INTO countries VALUES (165,'Papua New Guinea','PG','PNG','1','1');
 INSERT INTO countries VALUES (166,'Paraguay','PY','PRY','1','1');
 INSERT INTO countries VALUES (167,'Peru','PE','PER','1','1');
 INSERT INTO countries VALUES (168,'Philippines','PH','PHL','1','1');
 INSERT INTO countries VALUES (169,'Pitcairn','PN','PCN','1','1');
 INSERT INTO countries VALUES (170,'Poland','PL','POL','1','1');
 INSERT INTO countries VALUES (171,'Portugal','PT','PRT','1','1');
 INSERT INTO countries VALUES (172,'Puerto Rico','PR','PRI','1','1');
 INSERT INTO countries VALUES (173,'Qatar','QA','QAT','1','1');
 INSERT INTO countries VALUES (174,'Reunion','RE','REU','1','1');
 INSERT INTO countries VALUES (175,'Romania','RO','ROM','1','1');
 INSERT INTO countries VALUES (176,'Russian Federation','RU','RUS','1','1');
 INSERT INTO countries VALUES (177,'Rwanda','RW','RWA','1','1');
 INSERT INTO countries VALUES (178,'Saint Kitts and Nevis','KN','KNA','1','1');
 INSERT INTO countries VALUES (179,'Saint Lucia','LC','LCA','1','1');
 INSERT INTO countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT','1','1');
 INSERT INTO countries VALUES (181,'Samoa','WS','WSM','1','1');
 INSERT INTO countries VALUES (182,'San Marino','SM','SMR','1','1');
 INSERT INTO countries VALUES (183,'Sao Tome and Principe','ST','STP','1','1');
 INSERT INTO countries VALUES (184,'Saudi Arabia','SA','SAU','1','1');
 INSERT INTO countries VALUES (185,'Senegal','SN','SEN','1','1');
 INSERT INTO countries VALUES (186,'Seychelles','SC','SYC','1','1');
 INSERT INTO countries VALUES (187,'Sierra Leone','SL','SLE','1','1');
 INSERT INTO countries VALUES (188,'Singapore','SG','SGP', '4','1');
 INSERT INTO countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK','1','1');
 INSERT INTO countries VALUES (190,'Slovenia','SI','SVN','1','1');
 INSERT INTO countries VALUES (191,'Solomon Islands','SB','SLB','1','1');
 INSERT INTO countries VALUES (192,'Somalia','SO','SOM','1','1');
 INSERT INTO countries VALUES (193,'South Africa','ZA','ZAF','1','1');
 INSERT INTO countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS','1','1');
 INSERT INTO countries VALUES (195,'Spain','ES','ESP','3','1');
 INSERT INTO countries VALUES (196,'Sri Lanka','LK','LKA','1','1');
 INSERT INTO countries VALUES (197,'St. Helena','SH','SHN','1','1');
 INSERT INTO countries VALUES (198,'St. Pierre and Miquelon','PM','SPM','1','1');
 INSERT INTO countries VALUES (199,'Sudan','SD','SDN','1','1');
 INSERT INTO countries VALUES (200,'Suriname','SR','SUR','1','1');
 INSERT INTO countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM','1','1');
 INSERT INTO countries VALUES (202,'Swaziland','SZ','SWZ','1','1');
 INSERT INTO countries VALUES (203,'Sweden','SE','SWE','1','1');
 INSERT INTO countries VALUES (204,'Switzerland','CH','CHE','1','1');
 INSERT INTO countries VALUES (205,'Syrian Arab Republic','SY','SYR','1','1');
 INSERT INTO countries VALUES (206,'Taiwan','TW','TWN','1','1');
 INSERT INTO countries VALUES (207,'Tajikistan','TJ','TJK','1','1');
 INSERT INTO countries VALUES (208,'Tanzania, United Republic of','TZ','TZA','1','1');
 INSERT INTO countries VALUES (209,'Thailand','TH','THA','1','1');
 INSERT INTO countries VALUES (210,'Togo','TG','TGO','1','1');
 INSERT INTO countries VALUES (211,'Tokelau','TK','TKL','1','1');
 INSERT INTO countries VALUES (212,'Tonga','TO','TON','1','1');
 INSERT INTO countries VALUES (213,'Trinidad and Tobago','TT','TTO','1','1');
 INSERT INTO countries VALUES (214,'Tunisia','TN','TUN','1','1');
 INSERT INTO countries VALUES (215,'Turkey','TR','TUR','1','1');
 INSERT INTO countries VALUES (216,'Turkmenistan','TM','TKM','1','1');
 INSERT INTO countries VALUES (217,'Turks and Caicos Islands','TC','TCA','1','1');
 INSERT INTO countries VALUES (218,'Tuvalu','TV','TUV','1','1');
 INSERT INTO countries VALUES (219,'Uganda','UG','UGA','1','1');
 INSERT INTO countries VALUES (220,'Ukraine','UA','UKR','1','1');
 INSERT INTO countries VALUES (221,'United Arab Emirates','AE','ARE','1','1');
 INSERT INTO countries VALUES (222,'United Kingdom','GB','GBR','1','1');
 INSERT INTO countries VALUES (223,'United States','US','USA', '2','1');
 INSERT INTO countries VALUES (224,'United States Minor Outlying Islands','UM','UMI','1','1');
 INSERT INTO countries VALUES (225,'Uruguay','UY','URY','1','1');
 INSERT INTO countries VALUES (226,'Uzbekistan','UZ','UZB','1','1');
 INSERT INTO countries VALUES (227,'Vanuatu','VU','VUT','1','1');
 INSERT INTO countries VALUES (228,'Vatican City State (Holy See)','VA','VAT','1','1');
 INSERT INTO countries VALUES (229,'Venezuela','VE','VEN','1','1');
 INSERT INTO countries VALUES (230,'Viet Nam','VN','VNM','1','1');
 INSERT INTO countries VALUES (231,'Virgin Islands (British)','VG','VGB','1','1');
 INSERT INTO countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR','1','1');
 INSERT INTO countries VALUES (233,'Wallis and Futuna Islands','WF','WLF','1','1');
 INSERT INTO countries VALUES (234,'Western Sahara','EH','ESH','1','1');
 INSERT INTO countries VALUES (235,'Yemen','YE','YEM','1','1');
 # BOF - Tomcraft - 2010-07-02 - Deleted Yugoslavia
 #INSERT INTO countries VALUES (236,'Yugoslavia','YU','YUG','1','1');
 # EOF - Tomcraft - 2010-07-02 - Deleted Yugoslavia
 INSERT INTO countries VALUES (237,'Zaire','ZR','ZAR','1','1');
 INSERT INTO countries VALUES (238,'Zambia','ZM','ZMB','1','1');
 INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1','1');
 # BOF - Tomcraft - 2010-07-02 - Added Serbia & Montenegro
 INSERT INTO countries VALUES (240, 'Serbia', 'RS', 'SRB', 1, 1);
 INSERT INTO countries VALUES (241, 'Montenegro', 'ME', 'MNE', 1, 1);
 # EOF - Tomcraft - 2010-07-02 - Added Serbia & Montenegro