CREATE TABLE affiliate_countries ( id int(11) NOT NULL auto_increment, name varchar(64) NOT NULL default '', lang tinyint(3) unsigned default NULL, country_key int(11) unsigned default NULL, PRIMARY KEY  (id));
INSERT INTO affiliate_countries VALUES (1,'Afghanistan',1,1);
INSERT INTO affiliate_countries VALUES (2,'Albania',1,2);
INSERT INTO affiliate_countries VALUES (3,'Algeria',1,3);
INSERT INTO affiliate_countries VALUES (4,'American Samoa',1,4);
INSERT INTO affiliate_countries VALUES (5,'Andorra',1,5);
INSERT INTO affiliate_countries VALUES (6,'Angola',1,6);
INSERT INTO affiliate_countries VALUES (7,'Anguilla',1,7);
INSERT INTO affiliate_countries VALUES (8,'Antigua and Barbuda',1,8);
INSERT INTO affiliate_countries VALUES (9,'Argentina',1,9);
INSERT INTO affiliate_countries VALUES (10,'Armenia',1,10);
INSERT INTO affiliate_countries VALUES (11,'Aruba',1,11);
INSERT INTO affiliate_countries VALUES (12,'Australia',1,12);
INSERT INTO affiliate_countries VALUES (13,'Austria',1,13);
INSERT INTO affiliate_countries VALUES (14,'Azerbaijan',1,14);
INSERT INTO affiliate_countries VALUES (15,'Bahamas',1,15);
INSERT INTO affiliate_countries VALUES (16,'Bahrain',1,16);
INSERT INTO affiliate_countries VALUES (17,'Bangladesh',1,17);
INSERT INTO affiliate_countries VALUES (18,'Barbados',1,18);
INSERT INTO affiliate_countries VALUES (19,'Belarus',1,19);
INSERT INTO affiliate_countries VALUES (20,'Belgium',1,20);
INSERT INTO affiliate_countries VALUES (21,'Belize',1,21);
INSERT INTO affiliate_countries VALUES (22,'Benin',1,22);
INSERT INTO affiliate_countries VALUES (23,'Bermuda',1,23);
INSERT INTO affiliate_countries VALUES (24,'Bhutan',1,24);
INSERT INTO affiliate_countries VALUES (25,'Bolivia',1,25);
INSERT INTO affiliate_countries VALUES (26,'Bosnia and Herzegovina',1,26);
INSERT INTO affiliate_countries VALUES (27,'Botswana',1,27);
INSERT INTO affiliate_countries VALUES (28,'Brazil',1,28);
INSERT INTO affiliate_countries VALUES (29,'British Indian Ocean Territory',1,29);
INSERT INTO affiliate_countries VALUES (30,'Brunei Darussalam',1,30);
INSERT INTO affiliate_countries VALUES (31,'Bulgaria',1,31);
INSERT INTO affiliate_countries VALUES (32,'Burkina Faso',1,32);
INSERT INTO affiliate_countries VALUES (33,'Burundi',1,33);
INSERT INTO affiliate_countries VALUES (34,'Cambodia',1,34);
INSERT INTO affiliate_countries VALUES (35,'Cameroon',1,35);
INSERT INTO affiliate_countries VALUES (36,'Canada',1,36);
INSERT INTO affiliate_countries VALUES (37,'Cape Verde',1,37);
INSERT INTO affiliate_countries VALUES (38,'Cayman Islands',1,38);
INSERT INTO affiliate_countries VALUES (39,'Central African Republic',1,39);
INSERT INTO affiliate_countries VALUES (40,'Chad',1,40);
INSERT INTO affiliate_countries VALUES (41,'Chile',1,41);
INSERT INTO affiliate_countries VALUES (42,'China',1,42);
INSERT INTO affiliate_countries VALUES (43,'Christmas Island',1,43);
INSERT INTO affiliate_countries VALUES (44,'Cocos (Keeling) Islands',1,44);
INSERT INTO affiliate_countries VALUES (45,'Colombia',1,45);
INSERT INTO affiliate_countries VALUES (46,'Comoros',1,46);
INSERT INTO affiliate_countries VALUES (47,'Congo',1,47);
INSERT INTO affiliate_countries VALUES (48,'Congo, The Democratic Republic of the',1,48);
INSERT INTO affiliate_countries VALUES (49,'Cook Islands',1,49);
INSERT INTO affiliate_countries VALUES (50,'Costa Rica',1,50);
INSERT INTO affiliate_countries VALUES (51,'Cote d\'Ivoire',1,51);
INSERT INTO affiliate_countries VALUES (52,'Croatia',1,52);
INSERT INTO affiliate_countries VALUES (53,'Cuba',1,53);
INSERT INTO affiliate_countries VALUES (54,'Cyprus',1,54);
INSERT INTO affiliate_countries VALUES (55,'Czech Republic',1,55);
INSERT INTO affiliate_countries VALUES (56,'Denmark',1,56);
INSERT INTO affiliate_countries VALUES (57,'Djibouti',1,57);
INSERT INTO affiliate_countries VALUES (58,'Dominica',1,58);
INSERT INTO affiliate_countries VALUES (59,'Dominican Republic',1,59);
INSERT INTO affiliate_countries VALUES (60,'East Timor',1,60);
INSERT INTO affiliate_countries VALUES (61,'Ecuador',1,61);
INSERT INTO affiliate_countries VALUES (62,'Egypt',1,62);
INSERT INTO affiliate_countries VALUES (63,'El Salvador',1,63);
INSERT INTO affiliate_countries VALUES (64,'Equatorial Guinea',1,64);
INSERT INTO affiliate_countries VALUES (65,'Eritrea',1,65);
INSERT INTO affiliate_countries VALUES (66,'Estonia',1,66);
INSERT INTO affiliate_countries VALUES (67,'Ethiopia',1,67);
INSERT INTO affiliate_countries VALUES (68,'Falkland Islands (Malvinas)',1,68);
INSERT INTO affiliate_countries VALUES (69,'Faroe Islands',1,69);
INSERT INTO affiliate_countries VALUES (70,'Fiji',1,70);
INSERT INTO affiliate_countries VALUES (71,'Finland',1,71);
INSERT INTO affiliate_countries VALUES (72,'France',1,72);
INSERT INTO affiliate_countries VALUES (73,'French Guiana',1,73);
INSERT INTO affiliate_countries VALUES (74,'French Polynesia',1,74);
INSERT INTO affiliate_countries VALUES (75,'Gabon',1,75);
INSERT INTO affiliate_countries VALUES (76,'Gambia',1,76);
INSERT INTO affiliate_countries VALUES (77,'Georgia',1,77);
INSERT INTO affiliate_countries VALUES (78,'Germany',1,78);
INSERT INTO affiliate_countries VALUES (79,'Ghana',1,79);
INSERT INTO affiliate_countries VALUES (80,'Gibraltar',1,80);
INSERT INTO affiliate_countries VALUES (81,'Greece',1,81);
INSERT INTO affiliate_countries VALUES (82,'Greenland',1,82);
INSERT INTO affiliate_countries VALUES (83,'Grenada',1,83);
INSERT INTO affiliate_countries VALUES (84,'Guadeloupe',1,84);
INSERT INTO affiliate_countries VALUES (85,'Guam',1,85);
INSERT INTO affiliate_countries VALUES (86,'Guatemala',1,86);
INSERT INTO affiliate_countries VALUES (87,'Guinea',1,87);
INSERT INTO affiliate_countries VALUES (88,'Guinea-Bissau',1,88);
INSERT INTO affiliate_countries VALUES (89,'Guyana',1,89);
INSERT INTO affiliate_countries VALUES (90,'Haiti',1,90);
INSERT INTO affiliate_countries VALUES (91,'Heard Island and McDonald Islands',1,91);
INSERT INTO affiliate_countries VALUES (92,'Holy See (Vatican City State)',1,92);
INSERT INTO affiliate_countries VALUES (93,'Honduras',1,93);
INSERT INTO affiliate_countries VALUES (94,'Hong Kong',1,94);
INSERT INTO affiliate_countries VALUES (95,'Hungary',1,95);
INSERT INTO affiliate_countries VALUES (96,'Iceland',1,96);
INSERT INTO affiliate_countries VALUES (97,'India',1,97);
INSERT INTO affiliate_countries VALUES (98,'Indonesia',1,98);
INSERT INTO affiliate_countries VALUES (99,'Iran, Islamic Republic of',1,99);
INSERT INTO affiliate_countries VALUES (100,'Iraq',1,100);
INSERT INTO affiliate_countries VALUES (101,'Ireland',1,101);
INSERT INTO affiliate_countries VALUES (102,'Israel',1,102);
INSERT INTO affiliate_countries VALUES (103,'Italy',1,103);
INSERT INTO affiliate_countries VALUES (104,'Jamaica',1,104);
INSERT INTO affiliate_countries VALUES (105,'Japan',1,105);
INSERT INTO affiliate_countries VALUES (106,'Jordan',1,106);
INSERT INTO affiliate_countries VALUES (107,'Kazakstan',1,107);
INSERT INTO affiliate_countries VALUES (108,'Kenya',1,108);
INSERT INTO affiliate_countries VALUES (109,'Kiribati',1,109);
INSERT INTO affiliate_countries VALUES (110,'Korea, Democratic People\'s Republic of',1,110);
INSERT INTO affiliate_countries VALUES (111,'Korea, Republic of',1,111);
INSERT INTO affiliate_countries VALUES (112,'Kuwait',1,112);
INSERT INTO affiliate_countries VALUES (113,'Kyrgyzstan',1,113);
INSERT INTO affiliate_countries VALUES (114,'Lao People\'s Democratic Republic',1,114);
INSERT INTO affiliate_countries VALUES (115,'Latvia',1,115);
INSERT INTO affiliate_countries VALUES (116,'Lebanon',1,116);
INSERT INTO affiliate_countries VALUES (117,'Lesotho',1,117);
INSERT INTO affiliate_countries VALUES (118,'Liberia',1,118);
INSERT INTO affiliate_countries VALUES (119,'Libyan Arab Jamahiriya',1,119);
INSERT INTO affiliate_countries VALUES (120,'Liechtenstein',1,120);
INSERT INTO affiliate_countries VALUES (121,'Lithuania',1,121);
INSERT INTO affiliate_countries VALUES (122,'Luxembourg',1,122);
INSERT INTO affiliate_countries VALUES (123,'Macedonia',1,123);
INSERT INTO affiliate_countries VALUES (124,'Madagascar',1,124);
INSERT INTO affiliate_countries VALUES (125,'Malawi',1,125);
INSERT INTO affiliate_countries VALUES (126,'Malaysia',1,126);
INSERT INTO affiliate_countries VALUES (127,'Maldives',1,127);
INSERT INTO affiliate_countries VALUES (128,'Mali',1,128);
INSERT INTO affiliate_countries VALUES (129,'Malta',1,129);
INSERT INTO affiliate_countries VALUES (130,'Marshall Islands',1,130);
INSERT INTO affiliate_countries VALUES (131,'Martinique',1,131);
INSERT INTO affiliate_countries VALUES (132,'Mauritania',1,132);
INSERT INTO affiliate_countries VALUES (133,'Mauritius',1,133);
INSERT INTO affiliate_countries VALUES (134,'Mayotte',1,134);
INSERT INTO affiliate_countries VALUES (135,'Mexico',1,135);
INSERT INTO affiliate_countries VALUES (136,'Micronesia, Federated States of',1,136);
INSERT INTO affiliate_countries VALUES (137,'Moldova, Republic of',1,137);
INSERT INTO affiliate_countries VALUES (138,'Monaco',1,138);
INSERT INTO affiliate_countries VALUES (139,'Mongolia',1,139);
INSERT INTO affiliate_countries VALUES (140,'Montserrat',1,140);
INSERT INTO affiliate_countries VALUES (141,'Morocco',1,141);
INSERT INTO affiliate_countries VALUES (142,'Mozambique',1,142);
INSERT INTO affiliate_countries VALUES (143,'Myanmar',1,143);
INSERT INTO affiliate_countries VALUES (144,'Namibia',1,144);
INSERT INTO affiliate_countries VALUES (145,'Nauru',1,145);
INSERT INTO affiliate_countries VALUES (146,'Nepal',1,146);
INSERT INTO affiliate_countries VALUES (147,'Netherlands',1,147);
INSERT INTO affiliate_countries VALUES (148,'Netherlands Antilles',1,148);
INSERT INTO affiliate_countries VALUES (149,'New Caledonia',1,149);
INSERT INTO affiliate_countries VALUES (150,'New Zealand',1,150);
INSERT INTO affiliate_countries VALUES (151,'Nicaragua',1,151);
INSERT INTO affiliate_countries VALUES (152,'Niger',1,152);
INSERT INTO affiliate_countries VALUES (153,'Nigeria',1,153);
INSERT INTO affiliate_countries VALUES (154,'Niue',1,154);
INSERT INTO affiliate_countries VALUES (155,'Norfolk Island',1,155);
INSERT INTO affiliate_countries VALUES (156,'Northern Mariana Islands',1,156);
INSERT INTO affiliate_countries VALUES (157,'Norway',1,157);
INSERT INTO affiliate_countries VALUES (158,'Oman',1,158);
INSERT INTO affiliate_countries VALUES (159,'Pakistan',1,159);
INSERT INTO affiliate_countries VALUES (160,'Palau',1,160);
INSERT INTO affiliate_countries VALUES (161,'Palestinian Territory, Occupied',1,161);
INSERT INTO affiliate_countries VALUES (162,'Panama',1,162);
INSERT INTO affiliate_countries VALUES (163,'Papua New Guinea',1,163);
INSERT INTO affiliate_countries VALUES (164,'Paraguay',1,164);
INSERT INTO affiliate_countries VALUES (165,'Peru',1,165);
INSERT INTO affiliate_countries VALUES (166,'Philippines',1,166);
INSERT INTO affiliate_countries VALUES (167,'Pitcairn Islands',1,167);
INSERT INTO affiliate_countries VALUES (168,'Poland',1,168);
INSERT INTO affiliate_countries VALUES (169,'Portugal',1,169);
INSERT INTO affiliate_countries VALUES (170,'Puerto Rico',1,170);
INSERT INTO affiliate_countries VALUES (171,'Qatar',1,171);
INSERT INTO affiliate_countries VALUES (172,'Reunion',1,172);
INSERT INTO affiliate_countries VALUES (173,'Romania',1,173);
INSERT INTO affiliate_countries VALUES (174,'Russian Federation',1,174);
INSERT INTO affiliate_countries VALUES (175,'Rwanda',1,175);
INSERT INTO affiliate_countries VALUES (176,'Saint Helena',1,176);
INSERT INTO affiliate_countries VALUES (177,'Saint Kitts and Nevis',1,177);
INSERT INTO affiliate_countries VALUES (178,'Saint Lucia',1,178);
INSERT INTO affiliate_countries VALUES (179,'Saint Pierre and Miquelon',1,179);
INSERT INTO affiliate_countries VALUES (180,'Saint Vincent and the Grenadines',1,180);
INSERT INTO affiliate_countries VALUES (181,'Samoa',1,181);
INSERT INTO affiliate_countries VALUES (182,'San Marino',1,182);
INSERT INTO affiliate_countries VALUES (183,'Sao Tome and Principe',1,183);
INSERT INTO affiliate_countries VALUES (184,'Saudi Arabia',1,184);
INSERT INTO affiliate_countries VALUES (185,'Senegal',1,185);
INSERT INTO affiliate_countries VALUES (186,'Serbia and Montenegro',1,186);
INSERT INTO affiliate_countries VALUES (187,'Seychelles',1,187);
INSERT INTO affiliate_countries VALUES (188,'Sierra Leone',1,188);
INSERT INTO affiliate_countries VALUES (189,'Singapore',1,189);
INSERT INTO affiliate_countries VALUES (190,'Slovakia',1,190);
INSERT INTO affiliate_countries VALUES (191,'Slovenia',1,191);
INSERT INTO affiliate_countries VALUES (192,'Solomon Islands',1,192);
INSERT INTO affiliate_countries VALUES (193,'Somalia',1,193);
INSERT INTO affiliate_countries VALUES (194,'South Africa',1,194);
INSERT INTO affiliate_countries VALUES (195,'South Georgia and the South Sandwich Islands',1,195);
INSERT INTO affiliate_countries VALUES (196,'Spain',1,196);
INSERT INTO affiliate_countries VALUES (197,'Sri Lanka',1,197);
INSERT INTO affiliate_countries VALUES (198,'Sudan',1,198);
INSERT INTO affiliate_countries VALUES (199,'Suriname',1,199);
INSERT INTO affiliate_countries VALUES (200,'Swaziland',1,200);
INSERT INTO affiliate_countries VALUES (201,'Sweden',1,201);
INSERT INTO affiliate_countries VALUES (202,'Switzerland',1,202);
INSERT INTO affiliate_countries VALUES (203,'Syrian Arab Republic',1,203);
INSERT INTO affiliate_countries VALUES (204,'Taiwan',1,204);
INSERT INTO affiliate_countries VALUES (205,'Tajikistan',1,205);
INSERT INTO affiliate_countries VALUES (206,'Tanzania, United Republic of',1,206);
INSERT INTO affiliate_countries VALUES (207,'Thailand',1,207);
INSERT INTO affiliate_countries VALUES (208,'Togo',1,208);
INSERT INTO affiliate_countries VALUES (209,'Tokelau',1,209);
INSERT INTO affiliate_countries VALUES (210,'Tonga',1,210);
INSERT INTO affiliate_countries VALUES (211,'Trinidad and Tobago',1,211);
INSERT INTO affiliate_countries VALUES (212,'Tunisia',1,212);
INSERT INTO affiliate_countries VALUES (213,'Turkey',1,213);
INSERT INTO affiliate_countries VALUES (214,'Turkmenistan',1,214);
INSERT INTO affiliate_countries VALUES (215,'Turks and Caicos Islands',1,215);
INSERT INTO affiliate_countries VALUES (216,'Tuvalu',1,216);
INSERT INTO affiliate_countries VALUES (217,'Uganda',1,217);
INSERT INTO affiliate_countries VALUES (218,'Ukraine',1,218);
INSERT INTO affiliate_countries VALUES (219,'United Arab Emirates',1,219);
INSERT INTO affiliate_countries VALUES (220,'United Kingdom',1,220);
INSERT INTO affiliate_countries VALUES (221,'United States',1,221);
INSERT INTO affiliate_countries VALUES (222,'Uruguay',1,222);
INSERT INTO affiliate_countries VALUES (223,'Uzbekistan',1,223);
INSERT INTO affiliate_countries VALUES (224,'Vanuatu',1,224);
INSERT INTO affiliate_countries VALUES (225,'Venezuela',1,225);
INSERT INTO affiliate_countries VALUES (226,'Vietnam',1,226);
INSERT INTO affiliate_countries VALUES (227,'Virgin Islands, British',1,227);
INSERT INTO affiliate_countries VALUES (228,'Virgin Islands, U.S.',1,228);
INSERT INTO affiliate_countries VALUES (229,'Wallis and Futuna',1,229);
INSERT INTO affiliate_countries VALUES (230,'Yemen',1,230);
INSERT INTO affiliate_countries VALUES (231,'Zambia',1,231);
INSERT INTO affiliate_countries VALUES (232,'Zimbabwe',1,232);
INSERT INTO affiliate_countries VALUES (233,'Afghanistan',2,1);
INSERT INTO affiliate_countries VALUES (234,'Albanien',2,2);
INSERT INTO affiliate_countries VALUES (235,'Algerien',2,3);
INSERT INTO affiliate_countries VALUES (236,'Amerikanisch-Samoa',2,4);
INSERT INTO affiliate_countries VALUES (237,'Andorra',2,5);
INSERT INTO affiliate_countries VALUES (238,'Angola',2,6);
INSERT INTO affiliate_countries VALUES (239,'Anguilla',2,7);
INSERT INTO affiliate_countries VALUES (240,'Antigua und Barbuda',2,8);
INSERT INTO affiliate_countries VALUES (241,'Argentinien',2,9);
INSERT INTO affiliate_countries VALUES (242,'Armenien',2,10);
INSERT INTO affiliate_countries VALUES (243,'Aruba',2,11);
INSERT INTO affiliate_countries VALUES (244,'Australien',2,12);
INSERT INTO affiliate_countries VALUES (245,'Österreich',2,13);
INSERT INTO affiliate_countries VALUES (246,'Aserbaidschan',2,14);
INSERT INTO affiliate_countries VALUES (247,'Bahamas',2,15);
INSERT INTO affiliate_countries VALUES (248,'Bahrain',2,16);
INSERT INTO affiliate_countries VALUES (249,'Bangladesh',2,17);
INSERT INTO affiliate_countries VALUES (250,'Barbados',2,18);
INSERT INTO affiliate_countries VALUES (251,'Weißrussland',2,19);
INSERT INTO affiliate_countries VALUES (252,'Belgien',2,20);
INSERT INTO affiliate_countries VALUES (253,'Belize',2,21);
INSERT INTO affiliate_countries VALUES (254,'Benin',2,22);
INSERT INTO affiliate_countries VALUES (255,'Bermuda',2,23);
INSERT INTO affiliate_countries VALUES (256,'Bhutan',2,24);
INSERT INTO affiliate_countries VALUES (257,'Bolivien',2,25);
INSERT INTO affiliate_countries VALUES (258,'Bosnien Herzegowina',2,26);
INSERT INTO affiliate_countries VALUES (259,'Botswana',2,27);
INSERT INTO affiliate_countries VALUES (260,'Brasilien',2,28);
INSERT INTO affiliate_countries VALUES (261,'British Indian Ocean Territory',2,29);
INSERT INTO affiliate_countries VALUES (262,'Brunei',2,30);
INSERT INTO affiliate_countries VALUES (263,'Bulgarien',2,31);
INSERT INTO affiliate_countries VALUES (264,'Burkina Faso',2,32);
INSERT INTO affiliate_countries VALUES (265,'Burundi',2,33);
INSERT INTO affiliate_countries VALUES (266,'Kambodscha',2,34);
INSERT INTO affiliate_countries VALUES (267,'Kamerun',2,35);
INSERT INTO affiliate_countries VALUES (268,'Kanada',2,36);
INSERT INTO affiliate_countries VALUES (269,'Kap Verde',2,37);
INSERT INTO affiliate_countries VALUES (270,'Cayman-Inseln',2,38);
INSERT INTO affiliate_countries VALUES (271,'Zentralafrikanische Republik',2,39);
INSERT INTO affiliate_countries VALUES (272,'Tschad',2,40);
INSERT INTO affiliate_countries VALUES (273,'Chile',2,41);
INSERT INTO affiliate_countries VALUES (274,'China',2,42);
INSERT INTO affiliate_countries VALUES (275,'Weihnachtsinseln',2,43);
INSERT INTO affiliate_countries VALUES (276,'Cocos (Keeling) Inseln',2,44);
INSERT INTO affiliate_countries VALUES (277,'Kolumbien',2,45);
INSERT INTO affiliate_countries VALUES (278,'Komoren',2,46);
INSERT INTO affiliate_countries VALUES (279,'Kongo',2,47);
INSERT INTO affiliate_countries VALUES (280,'Kongo, Dem. Rep.',2,48);
INSERT INTO affiliate_countries VALUES (281,'Cookinseln',2,49);
INSERT INTO affiliate_countries VALUES (282,'Costa Rica',2,50);
INSERT INTO affiliate_countries VALUES (283,'Elfenbeinküste',2,51);
INSERT INTO affiliate_countries VALUES (284,'Kroatien',2,52);
INSERT INTO affiliate_countries VALUES (285,'Kuba',2,53);
INSERT INTO affiliate_countries VALUES (286,'Zypern',2,54);
INSERT INTO affiliate_countries VALUES (287,'Tschechische Republik',2,55);
INSERT INTO affiliate_countries VALUES (288,'Dänemark',2,56);
INSERT INTO affiliate_countries VALUES (289,'Djibouti',2,57);
INSERT INTO affiliate_countries VALUES (290,'Dominica',2,58);
INSERT INTO affiliate_countries VALUES (291,'Dominikanische Republik',2,59);
INSERT INTO affiliate_countries VALUES (292,'Ost-Timor',2,60);
INSERT INTO affiliate_countries VALUES (293,'Ecuador',2,61);
INSERT INTO affiliate_countries VALUES (294,'Ägypten',2,62);
INSERT INTO affiliate_countries VALUES (295,'El Salvador',2,63);
INSERT INTO affiliate_countries VALUES (296,'Äquatorial-Guinea',2,64);
INSERT INTO affiliate_countries VALUES (297,'Eritrea',2,65);
INSERT INTO affiliate_countries VALUES (298,'Estland',2,66);
INSERT INTO affiliate_countries VALUES (299,'Äthiopien',2,67);
INSERT INTO affiliate_countries VALUES (300,'Falkland Inseln',2,68);
INSERT INTO affiliate_countries VALUES (301,'Färöer Inseln',2,69);
INSERT INTO affiliate_countries VALUES (302,'Fidschi Inseln',2,70);
INSERT INTO affiliate_countries VALUES (303,'Finnland',2,71);
INSERT INTO affiliate_countries VALUES (304,'Frankreich',2,72);
INSERT INTO affiliate_countries VALUES (305,'Französisch-Guyana',2,73);
INSERT INTO affiliate_countries VALUES (306,'Französisch-Polynesien',2,74);
INSERT INTO affiliate_countries VALUES (307,'Gabon',2,75);
INSERT INTO affiliate_countries VALUES (308,'Gambia',2,76);
INSERT INTO affiliate_countries VALUES (309,'Georgien',2,77);
INSERT INTO affiliate_countries VALUES (310,'Deutschland',2,78);
INSERT INTO affiliate_countries VALUES (311,'Ghana',2,79);
INSERT INTO affiliate_countries VALUES (312,'Gibraltar',2,80);
INSERT INTO affiliate_countries VALUES (313,'Griechenland',2,81);
INSERT INTO affiliate_countries VALUES (314,'Grönland',2,82);
INSERT INTO affiliate_countries VALUES (315,'Grenada',2,83);
INSERT INTO affiliate_countries VALUES (316,'Guadeloupe',2,84);
INSERT INTO affiliate_countries VALUES (317,'Guam',2,85);
INSERT INTO affiliate_countries VALUES (318,'Guatemala',2,86);
INSERT INTO affiliate_countries VALUES (319,'Guinea',2,87);
INSERT INTO affiliate_countries VALUES (320,'Guinea-Bissau',2,88);
INSERT INTO affiliate_countries VALUES (321,'Guyana',2,89);
INSERT INTO affiliate_countries VALUES (322,'Haiti',2,90);
INSERT INTO affiliate_countries VALUES (323,'Heard Island und McDonald Islands',2,91);
INSERT INTO affiliate_countries VALUES (324,'Vatikanstadt',2,92);
INSERT INTO affiliate_countries VALUES (325,'Honduras',2,93);
INSERT INTO affiliate_countries VALUES (326,'Hong Kong',2,94);
INSERT INTO affiliate_countries VALUES (327,'Ungarn',2,95);
INSERT INTO affiliate_countries VALUES (328,'Island',2,96);
INSERT INTO affiliate_countries VALUES (329,'Indien',2,97);
INSERT INTO affiliate_countries VALUES (330,'Indonesien',2,98);
INSERT INTO affiliate_countries VALUES (331,'Iran',2,99);
INSERT INTO affiliate_countries VALUES (332,'Irak',2,100);
INSERT INTO affiliate_countries VALUES (333,'Irland',2,101);
INSERT INTO affiliate_countries VALUES (334,'Israel',2,102);
INSERT INTO affiliate_countries VALUES (335,'Italien',2,103);
INSERT INTO affiliate_countries VALUES (336,'Jamaika',2,104);
INSERT INTO affiliate_countries VALUES (337,'Japan',2,105);
INSERT INTO affiliate_countries VALUES (338,'Jordanien',2,106);
INSERT INTO affiliate_countries VALUES (339,'Kasachstan',2,107);
INSERT INTO affiliate_countries VALUES (340,'Kenia',2,108);
INSERT INTO affiliate_countries VALUES (341,'Kiribati',2,109);
INSERT INTO affiliate_countries VALUES (342,'Korea North',2,110);
INSERT INTO affiliate_countries VALUES (343,'Korea South',2,111);
INSERT INTO affiliate_countries VALUES (344,'Kuwait',2,112);
INSERT INTO affiliate_countries VALUES (345,'Kirgistan',2,113);
INSERT INTO affiliate_countries VALUES (346,'Laos',2,114);
INSERT INTO affiliate_countries VALUES (347,'Lettland',2,115);
INSERT INTO affiliate_countries VALUES (348,'Libanon',2,116);
INSERT INTO affiliate_countries VALUES (349,'Lesotho',2,117);
INSERT INTO affiliate_countries VALUES (350,'Liberia',2,118);
INSERT INTO affiliate_countries VALUES (351,'Libyen',2,119);
INSERT INTO affiliate_countries VALUES (352,'Liechtenstein',2,120);
INSERT INTO affiliate_countries VALUES (353,'Litauen',2,121);
INSERT INTO affiliate_countries VALUES (354,'Luxemburg',2,122);
INSERT INTO affiliate_countries VALUES (355,'Mazedonien',2,123);
INSERT INTO affiliate_countries VALUES (356,'Madagaskar',2,124);
INSERT INTO affiliate_countries VALUES (357,'Malawi',2,125);
INSERT INTO affiliate_countries VALUES (358,'Malaysia',2,126);
INSERT INTO affiliate_countries VALUES (359,'Malediven',2,127);
INSERT INTO affiliate_countries VALUES (360,'Mali',2,128);
INSERT INTO affiliate_countries VALUES (361,'Malta',2,129);
INSERT INTO affiliate_countries VALUES (362,'Marshall-Inseln',2,130);
INSERT INTO affiliate_countries VALUES (363,'Martinique',2,131);
INSERT INTO affiliate_countries VALUES (364,'Mauretanien',2,132);
INSERT INTO affiliate_countries VALUES (365,'Mauritius',2,133);
INSERT INTO affiliate_countries VALUES (366,'Mayotte',2,134);
INSERT INTO affiliate_countries VALUES (367,'Mexiko',2,135);
INSERT INTO affiliate_countries VALUES (368,'Mikronesien',2,136);
INSERT INTO affiliate_countries VALUES (369,'Moldawien',2,137);
INSERT INTO affiliate_countries VALUES (370,'Monaco',2,138);
INSERT INTO affiliate_countries VALUES (371,'Mongolei',2,139);
INSERT INTO affiliate_countries VALUES (372,'Montserrat',2,140);
INSERT INTO affiliate_countries VALUES (373,'Marokko',2,141);
INSERT INTO affiliate_countries VALUES (374,'Mosambik',2,142);
INSERT INTO affiliate_countries VALUES (375,'Myanmar (Burma)',2,143);
INSERT INTO affiliate_countries VALUES (376,'Namibia',2,144);
INSERT INTO affiliate_countries VALUES (377,'Nauru',2,145);
INSERT INTO affiliate_countries VALUES (378,'Nepal',2,146);
INSERT INTO affiliate_countries VALUES (379,'Niederlande',2,147);
INSERT INTO affiliate_countries VALUES (380,'Niederländisch-Antillen',2,148);
INSERT INTO affiliate_countries VALUES (381,'Neukaledonien',2,149);
INSERT INTO affiliate_countries VALUES (382,'Neuseeland',2,150);
INSERT INTO affiliate_countries VALUES (383,'Nicaragua',2,151);
INSERT INTO affiliate_countries VALUES (384,'Niger',2,152);
INSERT INTO affiliate_countries VALUES (385,'Nigeria',2,153);
INSERT INTO affiliate_countries VALUES (386,'Niue',2,154);
INSERT INTO affiliate_countries VALUES (387,'Norfolk-Inseln',2,155);
INSERT INTO affiliate_countries VALUES (388,'Nördliche Marianen',2,156);
INSERT INTO affiliate_countries VALUES (389,'Norwegen',2,157);
INSERT INTO affiliate_countries VALUES (390,'Oman',2,158);
INSERT INTO affiliate_countries VALUES (391,'Pakistan',2,159);
INSERT INTO affiliate_countries VALUES (392,'Palau',2,160);
INSERT INTO affiliate_countries VALUES (393,'Gaza Streifen',2,161);
INSERT INTO affiliate_countries VALUES (394,'Panama',2,162);
INSERT INTO affiliate_countries VALUES (395,'Papua-Neuguinea',2,163);
INSERT INTO affiliate_countries VALUES (396,'Paraguay',2,164);
INSERT INTO affiliate_countries VALUES (397,'Peru',2,165);
INSERT INTO affiliate_countries VALUES (398,'Philippinen',2,166);
INSERT INTO affiliate_countries VALUES (399,'Pitcairn Inseln',2,167);
INSERT INTO affiliate_countries VALUES (400,'Polen',2,168);
INSERT INTO affiliate_countries VALUES (401,'Portugal',2,169);
INSERT INTO affiliate_countries VALUES (402,'Puerto Rico',2,170);
INSERT INTO affiliate_countries VALUES (403,'Qatar',2,171);
INSERT INTO affiliate_countries VALUES (404,'Reunion',2,172);
INSERT INTO affiliate_countries VALUES (405,'Rumänien',2,173);
INSERT INTO affiliate_countries VALUES (406,'Russische Föderation',2,174);
INSERT INTO affiliate_countries VALUES (407,'Ruanda',2,175);
INSERT INTO affiliate_countries VALUES (408,'Saint Helena',2,176);
INSERT INTO affiliate_countries VALUES (409,'Saint Kitts und Nevis',2,177);
INSERT INTO affiliate_countries VALUES (410,'Saint Lucia',2,178);
INSERT INTO affiliate_countries VALUES (411,'Saint-Pierre-et-Miquelon',2,179);
INSERT INTO affiliate_countries VALUES (412,'Saint Vincent und die Grenadinen',2,180);
INSERT INTO affiliate_countries VALUES (413,'Samoa',2,181);
INSERT INTO affiliate_countries VALUES (414,'San Marino',2,182);
INSERT INTO affiliate_countries VALUES (415,'São Tomé und Príncipe',2,183);
INSERT INTO affiliate_countries VALUES (416,'Saudi-Arabien',2,184);
INSERT INTO affiliate_countries VALUES (417,'Senegal',2,185);
INSERT INTO affiliate_countries VALUES (418,'Serbien und Montenegro',2,186);
INSERT INTO affiliate_countries VALUES (419,'Seychellen',2,187);
INSERT INTO affiliate_countries VALUES (420,'Sierra Leone',2,188);
INSERT INTO affiliate_countries VALUES (421,'Singapur',2,189);
INSERT INTO affiliate_countries VALUES (422,'Slowakei',2,190);
INSERT INTO affiliate_countries VALUES (423,'Slovenien',2,191);
INSERT INTO affiliate_countries VALUES (424,'Solomonen Inseln',2,192);
INSERT INTO affiliate_countries VALUES (425,'Somalia',2,193);
INSERT INTO affiliate_countries VALUES (426,'Südafrika',2,194);
INSERT INTO affiliate_countries VALUES (427,'Südgeorgien und Sandwich-Inseln',2,195);
INSERT INTO affiliate_countries VALUES (428,'Spanien',2,196);
INSERT INTO affiliate_countries VALUES (429,'Sri Lanka',2,197);
INSERT INTO affiliate_countries VALUES (430,'Sudan',2,198);
INSERT INTO affiliate_countries VALUES (431,'Surinam',2,199);
INSERT INTO affiliate_countries VALUES (432,'Swaziland',2,200);
INSERT INTO affiliate_countries VALUES (433,'Schweden',2,201);
INSERT INTO affiliate_countries VALUES (434,'Schweiz',2,202);
INSERT INTO affiliate_countries VALUES (435,'Syrien',2,203);
INSERT INTO affiliate_countries VALUES (436,'Taiwan',2,204);
INSERT INTO affiliate_countries VALUES (437,'Tadschikistan',2,205);
INSERT INTO affiliate_countries VALUES (438,'Tansania',2,206);
INSERT INTO affiliate_countries VALUES (439,'Thailand',2,207);
INSERT INTO affiliate_countries VALUES (440,'Togo',2,208);
INSERT INTO affiliate_countries VALUES (441,'Tokelau',2,209);
INSERT INTO affiliate_countries VALUES (442,'Tonga',2,210);
INSERT INTO affiliate_countries VALUES (443,'Trinidad und Tobago',2,211);
INSERT INTO affiliate_countries VALUES (444,'Tunesien',2,212);
INSERT INTO affiliate_countries VALUES (445,'Türkei',2,213);
INSERT INTO affiliate_countries VALUES (446,'Turkmenistan',2,214);
INSERT INTO affiliate_countries VALUES (447,'Turks-und Caicosinseln',2,215);
INSERT INTO affiliate_countries VALUES (448,'Tuvalu',2,216);
INSERT INTO affiliate_countries VALUES (449,'Uganda',2,217);
INSERT INTO affiliate_countries VALUES (450,'Ukraine',2,218);
INSERT INTO affiliate_countries VALUES (451,'Vereinigte Arabische Emirate',2,219);
INSERT INTO affiliate_countries VALUES (452,'Grossbritanien',2,220);
INSERT INTO affiliate_countries VALUES (453,'USA',2,221);
INSERT INTO affiliate_countries VALUES (454,'Uruguay',2,222);
INSERT INTO affiliate_countries VALUES (455,'Usbekistan',2,223);
INSERT INTO affiliate_countries VALUES (456,'Vanuatu',2,224);
INSERT INTO affiliate_countries VALUES (457,'Venezuela',2,225);
INSERT INTO affiliate_countries VALUES (458,'Vietnam',2,226);
INSERT INTO affiliate_countries VALUES (459,'Jungferninseln',2,227);
INSERT INTO affiliate_countries VALUES (460,'Virgin Inseln',2,228);
INSERT INTO affiliate_countries VALUES (461,'Wallis und Futuna',2,229);
INSERT INTO affiliate_countries VALUES (462,'Jemen',2,230);
INSERT INTO affiliate_countries VALUES (463,'Sambia',2,231);
INSERT INTO affiliate_countries VALUES (464,'Zimbabwe',2,232);