Und für die Schweiz bräuchte ich noch die französischen Bezeichnungen der Kantone (sofern diese sich unterscheiden). Hier mal die deutschen Bezeichnungen:
Code: INSERT INTO country_state VALUES (204, 240, 'AG', 'Aargau', 0.0); INSERT INTO country_state VALUES (205, 240, 'AI', 'Appenzell Innerrhoden', 0.0); INSERT INTO country_state VALUES (206, 240, 'AR', 'Appenzell Ausserrhoden', 0.0); INSERT INTO country_state VALUES (207, 240, 'BE', 'Bern', 0.0); INSERT INTO country_state VALUES (208, 240, 'BL', 'Basel-Landschaft', 0.0); INSERT INTO country_state VALUES (209, 240, 'BS', 'Basel-Stadt', 0.0); INSERT INTO country_state VALUES (210, 240, 'FR', 'Freiburg', 0.0); INSERT INTO country_state VALUES (211, 240, 'GE', 'Genf', 0.0); INSERT INTO country_state VALUES (212, 240, 'GL', 'Glarus', 0.0); INSERT INTO country_state VALUES (213, 240, 'JU', 'Graubünden', 0.0); INSERT INTO country_state VALUES (214, 240, 'JU', 'Jura', 0.0); INSERT INTO country_state VALUES (215, 240, 'LU', 'Luzern', 0.0); INSERT INTO country_state VALUES (216, 240, 'NE', 'Neuenburg', 0.0); INSERT INTO country_state VALUES (217, 240, 'NW', 'Nidwalden', 0.0); INSERT INTO country_state VALUES (218, 240, 'OW', 'Obwalden', 0.0); INSERT INTO country_state VALUES (219, 240, 'SG', 'St. Gallen', 0.0); INSERT INTO country_state VALUES (220, 240, 'SH', 'Schaffhausen', 0.0); INSERT INTO country_state VALUES (221, 240, 'SO', 'Solothurn', 0.0); INSERT INTO country_state VALUES (222, 240, 'SZ', 'Schwyz', 0.0); INSERT INTO country_state VALUES (223, 240, 'TG', 'Thurgau', 0.0); INSERT INTO country_state VALUES (224, 240, 'TI', 'Tessin', 0.0); INSERT INTO country_state VALUES (225, 240, 'UR', 'Uri', 0.0); INSERT INTO country_state VALUES (226, 240, 'VD', 'Waadt', 0.0); INSERT INTO country_state VALUES (227, 240, 'VS', 'Wallis', 0.0); INSERT INTO country_state VALUES (228, 240, 'ZG', 'Zug', 0.0); INSERT INTO country_state VALUES (229, 240, 'ZH', 'Zürich', 0.0);
|