237 lines
24 KiB
SQL
237 lines
24 KiB
SQL
UPDATE `oxcountry` SET `OXTITLE` = 'Deutschland (ohne Inseln)',
|
|
`OXTITLE_1` = 'Germany (except isles)' WHERE `OXID` = 'a7c40f631fc920687.20179984' LIMIT 1 ;
|
|
UPDATE `oxcountry` SET `OXTITLE` = 'Dänemark (ohne Inseln)',
|
|
`OXTITLE_1` = 'Denmark (except isles)' WHERE `OXID` = '8f241f110957e6ef8.56458418' LIMIT 1 ;
|
|
UPDATE `oxcountry` SET `OXTITLE` = 'Estland (ohne Inseln)',
|
|
`OXTITLE_1` = 'Estonia (except isles)' WHERE `OXID` = '8f241f110958b69e4.93886171' LIMIT 1 ;
|
|
UPDATE `oxcountry` SET `OXTITLE` = 'Finnland (ohne Inseln)',
|
|
`OXTITLE_1` = 'Finland (except isles)' WHERE `OXID` = 'a7c40f63293c19d65.37472814' LIMIT 1 ;
|
|
UPDATE `oxcountry` SET `OXTITLE` = 'Frankreich (ohne Inseln)',
|
|
`OXTITLE_1` = 'France (except isles)' WHERE `OXID` = 'a7c40f63272a57296.32117580' LIMIT 1 ;
|
|
UPDATE `oxcountry` SET `OXTITLE` = 'Italien (ohne Inseln)',
|
|
`OXTITLE_1` = 'Italy (except isles)' WHERE `OXID` = 'a7c40f6323c4bfb36.59919433' LIMIT 1 ;
|
|
UPDATE `oxcountry` SET `OXTITLE` = 'Niederlande (ohne Inseln)',
|
|
`OXTITLE_1` = 'Netherlands (except isles)' WHERE `OXID` = 'a7c40f632cdd63c52.64272623' LIMIT 1 ;
|
|
UPDATE `oxcountry` SET `OXTITLE` = 'Schweden (ohne Inseln)',
|
|
`OXTITLE_1` = 'Sweden (except isles)' WHERE `OXID` = 'a7c40f632848c5217.53322339' LIMIT 1 ;
|
|
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('a7c40f631fc920687.20179985', 1, 'Deutschland (nur Inseln)', 'DE', 'DEU', '276', 9999, 'EU1', '', 'Germany (isles only)', '', '', 'EU1', '', '', '', '', '', 1);
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('8f241f110957e6ef8.56458419', 0, 'Dänemark (nur Inseln)', 'DK', 'DNK', '208', 9999, 'Europa', '', 'Denmark (isles only)', '', '', 'Europe', '', '', '', '', '', 0);
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('8f241f110958b69e4.93886172', 0, 'Estland (nur Inseln)', 'EE', 'EST', '233', 9999, 'Rest Europa', '', 'Estonia (isles only)', '', '', 'Rest Europe', '', '', '', '', '', 1);
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('a7c40f63293c19d65.37472815', 0, 'Finnland (nur Inseln)', 'FI', 'FIN', '246', 9999, 'EU2', '', 'Finland (isles only)', '', '', 'EU2', '', '', '', '', '', 1);
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('a7c40f63272a57296.32117581', 0, 'Frankreich (nur Inseln)', 'FR', 'FRA', '250', 9999, 'EU1', '', 'France (isles only)', '', '', 'EU1', '', '', '', '', '', 1);
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('a7c40f6323c4bfb36.59919434', 0, 'Italien (nur Inseln)', 'IT', 'ITA', '380', 9999, 'EU1', '', 'Italy (isles only)', '', '', 'EU1', '', '', '', '', '', 1);
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('a7c40f632cdd63c52.64272624', 0, 'Niederlande (nur Inseln)', 'NL', 'NLD', '528', 9999, 'EU2', '', 'Netherlands (isles only)', '', '', 'EU2', '', '', '', '', '', 1);
|
|
INSERT INTO `oxcountry` (`OXID` ,`OXACTIVE` ,`OXTITLE` ,`OXISOALPHA2` ,`OXISOALPHA3` ,`OXUNNUM3` ,`OXORDER` ,`OXSHORTDESC` ,`OXLONGDESC` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3` ,`OXSHORTDESC_1` ,`OXSHORTDESC_2` ,`OXSHORTDESC_3` ,`OXLONGDESC_1` ,`OXLONGDESC_2` ,`OXLONGDESC_3` ,`OXVATSTATUS`)
|
|
VALUES ('a7c40f632848c5217.53322340', 0, 'Schweden (nur Inseln)', 'SE', 'SWE', '752', 9999, 'EU2', '', 'Sweden (isles only)', '', '', 'EU2', '', '', '', '', '', 1);
|
|
|
|
INSERT INTO `oxstates` (`OXID` ,`OXCOUNTRYID` ,`OXTITLE` ,`OXISOALPHA2` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3`)
|
|
VALUES ('BY-I', 'a7c40f631fc920687.20179985', 'Bayern', 'BY', 'Bavaria', '', '');
|
|
INSERT INTO `oxstates` (`OXID` ,`OXCOUNTRYID` ,`OXTITLE` ,`OXISOALPHA2` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3`)
|
|
VALUES ('HH-I', 'a7c40f631fc920687.20179985', 'Hamburg', 'HH', 'Hamburg', '', '');
|
|
INSERT INTO `oxstates` (`OXID` ,`OXCOUNTRYID` ,`OXTITLE` ,`OXISOALPHA2` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3`)
|
|
VALUES ('MV-I', 'a7c40f631fc920687.20179985', 'Mecklenburg-Vorpommern', 'MV', 'Mecklenburg-Western Pomerania', '', '');
|
|
INSERT INTO `oxstates` (`OXID` ,`OXCOUNTRYID` ,`OXTITLE` ,`OXISOALPHA2` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3`)
|
|
VALUES ('NI-I', 'a7c40f631fc920687.20179985', 'Niedersachsen', 'NI', 'Lower Saxony', '', '');
|
|
INSERT INTO `oxstates` (`OXID` ,`OXCOUNTRYID` ,`OXTITLE` ,`OXISOALPHA2` ,`OXTITLE_1` ,`OXTITLE_2` ,`OXTITLE_3`)
|
|
VALUES ('SH-I', 'a7c40f631fc920687.20179985', 'Schleswig-Holstein', 'SH', 'Schleswig-Holstein', '', '');
|
|
|
|
|
|
# verwendete PLZ mit Ortsangabe, diesen PLZ können noch weitere Orte zugeordnet sein
|
|
# fügen Sie nach Ihrem Bedarf weitere PLZ hinzu oder entfernen Sie diese aus der später aufgeführten Abfrage,
|
|
# bevor Sie diese ausführen
|
|
|
|
CREATE TABLE `d3isles` (
|
|
`OXID` char(32) collate latin1_general_ci NOT NULL,
|
|
`OXCOUNTRYID` char(32) collate latin1_general_ci NOT NULL,
|
|
`OXISLESCOUNTRYID` char(32) collate latin1_general_ci NOT NULL,
|
|
`OXZIPFROM` varchar(16) NOT NULL,
|
|
`OXZIPTO` varchar(16) NOT NULL,
|
|
`OXDESC` varchar(100) NOT NULL,
|
|
PRIMARY KEY (`OXID`)
|
|
) ENGINE=MyISAM COMMENT='Inseln';
|
|
|
|
# Deutschland
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '18565', '18565', 'Fährinsel'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25845', '25847', 'Elisabeth-Sophien-Koog, Pellworm'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25849', '25849', 'Pellworm'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25859', '25859', 'Hooge'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25863', '25863', 'Langeneß'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25869', '25869', 'Gröde'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25929', '25933', 'Föhr'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25938', '25938', 'Wyk, Föhr, Amrum'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25939', '25942', 'Föhr'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25946', '25949', 'Nebel, Amrum'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25952', '25955', 'Amrum'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25961', '25970', 'Westerland'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25980', '25980', 'Westerland'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25985', '25986', 'Sylt (Ost)'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25988', '25990', 'Sylt (Rantrum), Sylt (List)'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25992', '25994', 'Wenningstedt'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '25996', '25999', 'Wenningstedt, Hörnum, Kampen'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '26465', '26465', 'Langeoog'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '26474', '26474', 'Spiekeroog'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '26486', '26486', 'Wangerooge'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '26548', '26548', 'Norderney'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '26571', '26571', 'Juist'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '26579', '26579', 'Baltrum'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '26757', '26757', 'Borkum'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '27498', '27499', 'Helgoland, Hamburg-Insel Neuwerk'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '83209', '83209', 'Herrenchiemsee'),
|
|
(MD5(RAND()), 'a7c40f631fc920687.20179984', 'a7c40f631fc920687.20179985', '83256', '83256', 'Frauenchiemsee');
|
|
|
|
# Dänemark
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '5960', '5960', 'Aero'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '5970', '5970', 'Aero'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '5985', '5985', 'Aero'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '8592', '8592', 'Anholt'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3700', '3700', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3720', '3720', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3730', '3730', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3740', '3740', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3751', '3751', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3760', '3760', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3770', '3770', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3782', '3782', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '3790', '3790', 'Bornholm'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '7884', '7884', 'Fur'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '9940', '9940', 'Laeso'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '9950', '9950', 'Laeso'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '9960', '9960', 'Laeso'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '8305', '8305', 'Samso'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '4592', '4595', 'Sejero'),
|
|
(MD5(RAND()), '8f241f110957e6ef8.56458418', '8f241f110957e6ef8.56458419', '6720', '6720', 'Fano');
|
|
|
|
# Estland
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), '8f241f110958b69e4.93886171', '8f241f110958b69e4.93886172', '92001', '92420', 'Hiluma'),
|
|
(MD5(RAND()), '8f241f110958b69e4.93886171', '8f241f110958b69e4.93886172', '62601', '62601', 'Pilrissaare'),
|
|
(MD5(RAND()), '8f241f110958b69e4.93886171', '8f241f110958b69e4.93886172', '93001', '94702', 'Saaremaa'),
|
|
(MD5(RAND()), '8f241f110958b69e4.93886171', '8f241f110958b69e4.93886172', '91301', '91301', 'Vormsi');
|
|
|
|
# Finnland
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22940', '22940', 'Ava'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22920', '22920', 'Brändo'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22270', '22270', 'Eckerö'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22220', '22220', 'Emkarby'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22830', '22830', 'Enklinge'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22930', '22930', 'Fiskö'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22710', '22710', 'Föglö'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22340', '22340', 'Geta'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22410', '22410', 'Godby'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22130', '22130', 'Gottby'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22240', '22240', 'Hammarland'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22150', '22150', 'Jomala'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22950', '22950', 'Jurmo'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22520', '22520', 'Kastelholm'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22730', '22730', 'Kögar'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22820', '22820', 'Kumlinge'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22840', '22840', 'Lappo'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22610', '22610', 'Lemland'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22630', '22630', 'Lumparland'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22100', '22100', 'Mariehamn'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22320', '22320', 'Ödkarby'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22310', '22310', 'Pälsböle'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22430', '22430', 'Saltvik'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22810', '22810', 'Seglinge'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22720', '22720', 'Sottunga'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22530', '22530', 'Sund'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22330', '22330', 'Tjudö'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22910', '22910', 'Torsholma'),
|
|
(MD5(RAND()), 'a7c40f63293c19d65.37472814', 'a7c40f63293c19d65.37472815', '22550', '22550', 'Vördö');
|
|
|
|
# Frankreich
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17590', '17590', 'Ars en Re/Saint Clément des Baleines'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '56360', '56360', 'Belle lle/Bangor/Locmaria Belle Ile/Le Palais/Sauzon'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '22870', '22870', 'Brehat'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '56590', '56590', 'Groix'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '56780', '56780', 'Ile aux Moines'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '29253', '29253', 'Ile de Batz'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '86350', '86350', 'Ile d\' Yeu'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '29259', '29259', 'Ile de Molene'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '85330', '85330', 'Ile de Noirmoutier'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17670', '17670', 'La Couarde sur Mer'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17630', '17630', 'La Flotte'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17580', '17580', 'Le Bois Plage en Re'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17880', '17880', 'Les portes en Ré'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '29242', '29242', 'Quessant'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17940', '17940', 'Rivbedoux Plage'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17740', '17740', 'Saint Marie en Re'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17630', '17630', 'St. Clement de Baleines'),
|
|
(MD5(RAND()), 'a7c40f63272a57296.32117580', 'a7c40f63272a57296.32117581', '17410', '17410', 'St. Martin de Re');
|
|
|
|
# Italien
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30126', '30126', 'Alberoni/Lido di Venezia/Malamocco'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '98050', '98050', 'Alicudi/Filicudi/Panarea/Stromboli/Valcano'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '80070', '80071', 'Barano d\'Ischia/Buonopane/Fontana/Marina Grande di Capri/Panza/Piedimonto d\'Ischia/Sant\'Angelo/Serrara/ Succhivo/Testaccio d\'Ischia/Anacapri'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '07042', '07042', 'Asinara Cala d\'Oliva'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30012', '30012', 'Burano'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '58010', '58010', 'Campese'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57034', '57034', 'Campo nell\' Elba/Marina di Campo'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '98052', '98052', 'Canneto Lipari'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57031', '57032', 'Capoliveri/Capraia Isola'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '80073', '80073', 'Capri'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '09014', '09014', 'Carloforte'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57037', '57037', 'Carpani/Magazzini/Portoferraio/San Giovanni'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '80074', '80074', 'Casamicciola Terme'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57030', '57030', 'Cavo/Cavoli/Gorgona Isola/La Plla/Marciana/Pogglio/Pomonte/Procchio/San Piero in Campo/Sant\'Ilario/Seccheto'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '91023', '91023', 'Favignana'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '80075', '80075', 'Forio/Monterone'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '58018', '58018', 'Giannutri'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '58012', '58013', 'Giglio Isola/Giglio Porto'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30133', '30133', 'Giudecca/Sacca Fisola'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '80076', '80077', 'Lacco Ameno/Ischia/Ischia Ponte/Ischia Parto/Ischia San Michele/Sant\'Antuono D\'Ischia'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '71040', '71040', 'Isole tremiti/San Domino/San Nicola/Tremiti Isole'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '07024', '07024', 'La Maddalena'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '92010', '92010', 'Lampedusa/Linosa'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57033', '57033', 'Marciana Marina'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '98055', '98055', 'Lipari'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '25050', '25050', 'Monte Isola'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30141', '30141', 'Murano'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '91017', '91017', 'Pantelleria'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '23030', '23030', 'Passo d\'Eira/Passo Foscagno/Trepalle'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30010', '30010', 'Pellestrina/San Peitro in Volta'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '25050', '25050', 'Peschiera Maraglio'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57035', '57035', 'Pianosa Isola'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '04027', '04027', 'Ponza'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57036', '57036', 'Porto Azzurro'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '80079', '80079', 'Procida'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '57038', '57039', 'Rio Marina/Rio Nell\'Elba'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30122', '30122', 'Sant\'Elena'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '90010', '90010', 'Ustica'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30100', '30100', 'Venezia'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30121', '30126', 'Venezia'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30131', '30133', 'Venezia'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30135', '30135', 'Venezia'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '30141', '30141', 'Venezia'),
|
|
(MD5(RAND()), 'a7c40f6323c4bfb36.59919433', 'a7c40f6323c4bfb36.59919434', '04020', '04020', 'Ventotene');
|
|
|
|
# Niederlande
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), 'a7c40f632cdd63c52.64272623', 'a7c40f632cdd63c52.64272624', '9161', '9164', 'Ameland'),
|
|
(MD5(RAND()), 'a7c40f632cdd63c52.64272623', 'a7c40f632cdd63c52.64272624', '9166', '9166', 'Schlermonnikoog'),
|
|
(MD5(RAND()), 'a7c40f632cdd63c52.64272623', 'a7c40f632cdd63c52.64272624', '8881', '8884', 'Terschelling'),
|
|
(MD5(RAND()), 'a7c40f632cdd63c52.64272623', 'a7c40f632cdd63c52.64272624', '8891', '8897', 'Terschelling'),
|
|
(MD5(RAND()), 'a7c40f632cdd63c52.64272623', 'a7c40f632cdd63c52.64272624', '1791', '1797', 'Texel'),
|
|
(MD5(RAND()), 'a7c40f632cdd63c52.64272623', 'a7c40f632cdd63c52.64272624', '8899', '8899', 'Vlieland');
|
|
|
|
# Schweden
|
|
INSERT INTO `d3isles` ( `OXID` , `OXCOUNTRYID` , `OXISLESCOUNTRYID` , `OXZIPFROM` , `OXZIPTO` , `OXDESC` ) VALUES
|
|
(MD5(RAND()), 'a7c40f632848c5217.53322339', 'a7c40f632848c5217.53322340', '43000', '43099', 'Gothenburg archipelago'),
|
|
(MD5(RAND()), 'a7c40f632848c5217.53322339', 'a7c40f632848c5217.53322340', '62000', '62999', 'Gotland'),
|
|
(MD5(RAND()), 'a7c40f632848c5217.53322339', 'a7c40f632848c5217.53322340', '13000', '13099', 'Stockholm archipelago'),
|
|
(MD5(RAND()), 'a7c40f632848c5217.53322339', 'a7c40f632848c5217.53322340', '16400', '16499', 'Stockholm archipelago'),
|
|
(MD5(RAND()), 'a7c40f632848c5217.53322339', 'a7c40f632848c5217.53322340', '18500', '18599', 'Stockholm archipelago');
|