Quick Search:

Mode

Context

Displaying 3 lines of context. None | Less | More | Full

Other Diffs

Ignore

Blank Lines Whitespace:

Diff

831
  
857
  
857
  
oscommerce.sql
_> 1 -# $Id: oscommerce.sql 831 2006-08-29 12:48:40Z hpdl $
   1+# $Id: oscommerce.sql 857 2006-08-29 22:44:05Z hpdl $
22 #
  33 # osCommerce, Open Source E-Commerce Solutions
  44 # http://www.oscommerce.com
      
 !
 
…
11711171 INSERT INTO osc_weight_classes_rules VALUES (4, 2, '0.4535');
  11721172 INSERT INTO osc_weight_classes_rules VALUES (4, 3, '16.0000');
  11731173 
<> 1174 -# USA
  1175 -INSERT INTO osc_zones VALUES (1,223,'AL','Alabama');
  1176 -INSERT INTO osc_zones VALUES (2,223,'AK','Alaska');
  1177 -INSERT INTO osc_zones VALUES (3,223,'AS','American Samoa');
  1178 -INSERT INTO osc_zones VALUES (4,223,'AZ','Arizona');
  1179 -INSERT INTO osc_zones VALUES (5,223,'AR','Arkansas');
  1180 -INSERT INTO osc_zones VALUES (6,223,'AF','Armed Forces Africa');
  1181 -INSERT INTO osc_zones VALUES (7,223,'AA','Armed Forces Americas');
  1182 -INSERT INTO osc_zones VALUES (8,223,'AC','Armed Forces Canada');
  1183 -INSERT INTO osc_zones VALUES (9,223,'AE','Armed Forces Europe');
  1184 -INSERT INTO osc_zones VALUES (10,223,'AM','Armed Forces Middle East');
  1185 -INSERT INTO osc_zones VALUES (11,223,'AP','Armed Forces Pacific');
  1186 -INSERT INTO osc_zones VALUES (12,223,'CA','California');
  1187 -INSERT INTO osc_zones VALUES (13,223,'CO','Colorado');
  1188 -INSERT INTO osc_zones VALUES (14,223,'CT','Connecticut');
  1189 -INSERT INTO osc_zones VALUES (15,223,'DE','Delaware');
  1190 -INSERT INTO osc_zones VALUES (16,223,'DC','District of Columbia');
  1191 -INSERT INTO osc_zones VALUES (17,223,'FM','Federated States Of Micronesia');
  1192 -INSERT INTO osc_zones VALUES (18,223,'FL','Florida');
  1193 -INSERT INTO osc_zones VALUES (19,223,'GA','Georgia');
  1194 -INSERT INTO osc_zones VALUES (20,223,'GU','Guam');
  1195 -INSERT INTO osc_zones VALUES (21,223,'HI','Hawaii');
  1196 -INSERT INTO osc_zones VALUES (22,223,'ID','Idaho');
  1197 -INSERT INTO osc_zones VALUES (23,223,'IL','Illinois');
  1198 -INSERT INTO osc_zones VALUES (24,223,'IN','Indiana');
  1199 -INSERT INTO osc_zones VALUES (25,223,'IA','Iowa');
  1200 -INSERT INTO osc_zones VALUES (26,223,'KS','Kansas');
  1201 -INSERT INTO osc_zones VALUES (27,223,'KY','Kentucky');
  1202 -INSERT INTO osc_zones VALUES (28,223,'LA','Louisiana');
  1203 -INSERT INTO osc_zones VALUES (29,223,'ME','Maine');
  1204 -INSERT INTO osc_zones VALUES (30,223,'MH','Marshall Islands');
  1205 -INSERT INTO osc_zones VALUES (31,223,'MD','Maryland');
  1206 -INSERT INTO osc_zones VALUES (32,223,'MA','Massachusetts');
  1207 -INSERT INTO osc_zones VALUES (33,223,'MI','Michigan');
  1208 -INSERT INTO osc_zones VALUES (34,223,'MN','Minnesota');
  1209 -INSERT INTO osc_zones VALUES (35,223,'MS','Mississippi');
  1210 -INSERT INTO osc_zones VALUES (36,223,'MO','Missouri');
  1211 -INSERT INTO osc_zones VALUES (37,223,'MT','Montana');
  1212 -INSERT INTO osc_zones VALUES (38,223,'NE','Nebraska');
  1213 -INSERT INTO osc_zones VALUES (39,223,'NV','Nevada');
  1214 -INSERT INTO osc_zones VALUES (40,223,'NH','New Hampshire');
  1215 -INSERT INTO osc_zones VALUES (41,223,'NJ','New Jersey');
  1216 -INSERT INTO osc_zones VALUES (42,223,'NM','New Mexico');
  1217 -INSERT INTO osc_zones VALUES (43,223,'NY','New York');
  1218 -INSERT INTO osc_zones VALUES (44,223,'NC','North Carolina');
  1219 -INSERT INTO osc_zones VALUES (45,223,'ND','North Dakota');
  1220 -INSERT INTO osc_zones VALUES (46,223,'MP','Northern Mariana Islands');
  1221 -INSERT INTO osc_zones VALUES (47,223,'OH','Ohio');
  1222 -INSERT INTO osc_zones VALUES (48,223,'OK','Oklahoma');
  1223 -INSERT INTO osc_zones VALUES (49,223,'OR','Oregon');
  1224 -INSERT INTO osc_zones VALUES (50,223,'PW','Palau');
  1225 -INSERT INTO osc_zones VALUES (51,223,'PA','Pennsylvania');
  1226 -INSERT INTO osc_zones VALUES (52,223,'PR','Puerto Rico');
  1227 -INSERT INTO osc_zones VALUES (53,223,'RI','Rhode Island');
  1228 -INSERT INTO osc_zones VALUES (54,223,'SC','South Carolina');
  1229 -INSERT INTO osc_zones VALUES (55,223,'SD','South Dakota');
  1230 -INSERT INTO osc_zones VALUES (56,223,'TN','Tennessee');
  1231 -INSERT INTO osc_zones VALUES (57,223,'TX','Texas');
  1232 -INSERT INTO osc_zones VALUES (58,223,'UT','Utah');
  1233 -INSERT INTO osc_zones VALUES (59,223,'VT','Vermont');
  1234 -INSERT INTO osc_zones VALUES (60,223,'VI','Virgin Islands');
  1235 -INSERT INTO osc_zones VALUES (61,223,'VA','Virginia');
  1236 -INSERT INTO osc_zones VALUES (62,223,'WA','Washington');
  1237 -INSERT INTO osc_zones VALUES (63,223,'WV','West Virginia');
  1238 -INSERT INTO osc_zones VALUES (64,223,'WI','Wisconsin');
  1239 -INSERT INTO osc_zones VALUES (65,223,'WY','Wyoming');
   1174+# Australia
   1175+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'ACT','Australian Capital Territory');
   1176+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'NSW','New South Wales');
   1177+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'NT','Northern Territory');
   1178+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'QLD','Queensland');
   1179+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'SA','South Australia');
   1180+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'TAS','Tasmania');
   1181+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'VIC','Victoria');
   1182+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (13,'WA','Western Australia');
12401183 
<>  1184+# Austria
   1185+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'BL','Burgenland');
   1186+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'KN','Kärnten');
   1187+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'OO','Oberösterreich');
   1188+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'NO','Niederösterreich');
   1189+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'SB','Salzburg');
   1190+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'ST','Steiermark');
   1191+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'TI','Tirol');
   1192+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'VB','Voralberg');
   1193+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (14,'WI','Wien');
   1194+
12411195 # Canada
<> 1242 -INSERT INTO osc_zones VALUES (66,38,'AB','Alberta');
  1243 -INSERT INTO osc_zones VALUES (67,38,'BC','British Columbia');
  1244 -INSERT INTO osc_zones VALUES (68,38,'MB','Manitoba');
  1245 -INSERT INTO osc_zones VALUES (69,38,'NL','Newfoundland and Labrador');
  1246 -INSERT INTO osc_zones VALUES (70,38,'NB','New Brunswick');
  1247 -INSERT INTO osc_zones VALUES (71,38,'NS','Nova Scotia');
  1248 -INSERT INTO osc_zones VALUES (72,38,'NT','Northwest Territories');
  1249 -INSERT INTO osc_zones VALUES (73,38,'NU','Nunavut');
  1250 -INSERT INTO osc_zones VALUES (74,38,'ON','Ontario');
  1251 -INSERT INTO osc_zones VALUES (75,38,'PE','Prince Edward Island');
  1252 -INSERT INTO osc_zones VALUES (76,38,'QC','Quebec');
  1253 -INSERT INTO osc_zones VALUES (77,38,'SK','Saskatchewan');
  1254 -INSERT INTO osc_zones VALUES (78,38,'YT','Yukon Territory');
   1196+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'AB','Alberta');
   1197+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'BC','British Columbia');
   1198+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'MB','Manitoba');
   1199+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NL','Newfoundland and Labrador');
   1200+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NB','New Brunswick');
   1201+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NT','Northwest Territories');
   1202+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NS','Nova Scotia');
   1203+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'NU','Nunavut');
   1204+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'ON','Ontario');
   1205+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'PE','Prince Edward Island');
   1206+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'QC','Quebec');
   1207+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'SK','Saskatchewan');
   1208+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (38,'YT','Yukon Territory');
12551209 
<>  1210+# Chile
   1211+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AI','Aisén del General Carlos Ibañez');
   1212+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AN','Antofagasta');
   1213+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AT','Atacama');
   1214+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'BI','Biobío');
   1215+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'CO','Coquimbo');
   1216+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'AR','La Araucanía');
   1217+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'LI','Libertador Bernardo O\'Higgins');
   1218+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'LL','Los Lagos');
   1219+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'MA','Magallanes y de la Antartica');
   1220+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'ML','Maule');
   1221+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'RM','Region Metropolitana de Santiago');
   1222+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'TA','Tarapacá');
   1223+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (43,'VA','Valparaíso');
   1224+
12561225 # Germany
<> 1257 -INSERT INTO osc_zones VALUES (79,81,'NDS','Niedersachsen');
  1258 -INSERT INTO osc_zones VALUES (80,81,'BAW','Baden-Württemberg');
  1259 -INSERT INTO osc_zones VALUES (81,81,'BAY','Bayern');
  1260 -INSERT INTO osc_zones VALUES (82,81,'BER','Berlin');
  1261 -INSERT INTO osc_zones VALUES (83,81,'BRG','Brandenburg');
  1262 -INSERT INTO osc_zones VALUES (84,81,'BRE','Bremen');
  1263 -INSERT INTO osc_zones VALUES (85,81,'HAM','Hamburg');
  1264 -INSERT INTO osc_zones VALUES (86,81,'HES','Hessen');
  1265 -INSERT INTO osc_zones VALUES (87,81,'MEC','Mecklenburg-Vorpommern');
  1266 -INSERT INTO osc_zones VALUES (88,81,'NRW','Nordrhein-Westfalen');
  1267 -INSERT INTO osc_zones VALUES (89,81,'RHE','Rheinland-Pfalz');
  1268 -INSERT INTO osc_zones VALUES (90,81,'SAR','Saarland');
  1269 -INSERT INTO osc_zones VALUES (91,81,'SAS','Sachsen');
  1270 -INSERT INTO osc_zones VALUES (92,81,'SAC','Sachsen-Anhalt');
  1271 -INSERT INTO osc_zones VALUES (93,81,'SCN','Schleswig-Holstein');
  1272 -INSERT INTO osc_zones VALUES (94,81,'THE','Thüringen');
   1226+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BAW','Baden-Württemberg');
   1227+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BAY','Bayern');
   1228+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BER','Berlin');
   1229+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BRG','Brandenburg');
   1230+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'BRE','Bremen');
   1231+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'HAM','Hamburg');
   1232+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'HES','Hessen');
   1233+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'MEC','Mecklenburg-Vorpommern');
   1234+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'NDS','Niedersachsen');
   1235+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'NRW','Nordrhein-Westfalen');
   1236+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'RHE','Rheinland-Pfalz');
   1237+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'SAR','Saarland');
   1238+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'SAS','Sachsen');
   1239+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'SAC','Sachsen-Anhalt');
   1240+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'SCN','Schleswig-Holstein');
   1241+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (81,'THE','Thüringen');
12731242 
<> 1274 -# Austria
  1275 -INSERT INTO osc_zones VALUES (95,14,'WI','Wien');
  1276 -INSERT INTO osc_zones VALUES (96,14,'NO','Niederösterreich');
  1277 -INSERT INTO osc_zones VALUES (97,14,'OO','Oberösterreich');
  1278 -INSERT INTO osc_zones VALUES (98,14,'SB','Salzburg');
  1279 -INSERT INTO osc_zones VALUES (99,14,'KN','Kärnten');
  1280 -INSERT INTO osc_zones VALUES (100,14,'ST','Steiermark');
  1281 -INSERT INTO osc_zones VALUES (101,14,'TI','Tirol');
  1282 -INSERT INTO osc_zones VALUES (102,14,'BL','Burgenland');
  1283 -INSERT INTO osc_zones VALUES (103,14,'VB','Voralberg');
  1284 -
  1285 -# Swizterland
  1286 -INSERT INTO osc_zones VALUES (104,204,'AG','Aargau');
  1287 -INSERT INTO osc_zones VALUES (105,204,'AI','Appenzell Innerrhoden');
  1288 -INSERT INTO osc_zones VALUES (106,204,'AR','Appenzell Ausserrhoden');
  1289 -INSERT INTO osc_zones VALUES (107,204,'BE','Bern');
  1290 -INSERT INTO osc_zones VALUES (108,204,'BL','Basel-Landschaft');
  1291 -INSERT INTO osc_zones VALUES (109,204,'BS','Basel-Stadt');
  1292 -INSERT INTO osc_zones VALUES (110,204,'FR','Freiburg');
  1293 -INSERT INTO osc_zones VALUES (111,204,'GE','Genf');
  1294 -INSERT INTO osc_zones VALUES (112,204,'GL','Glarus');
  1295 -INSERT INTO osc_zones VALUES (113,204,'JU','Graubünden');
  1296 -INSERT INTO osc_zones VALUES (114,204,'JU','Jura');
  1297 -INSERT INTO osc_zones VALUES (115,204,'LU','Luzern');
  1298 -INSERT INTO osc_zones VALUES (116,204,'NE','Neuenburg');
  1299 -INSERT INTO osc_zones VALUES (117,204,'NW','Nidwalden');
  1300 -INSERT INTO osc_zones VALUES (118,204,'OW','Obwalden');
  1301 -INSERT INTO osc_zones VALUES (119,204,'SG','St. Gallen');
  1302 -INSERT INTO osc_zones VALUES (120,204,'SH','Schaffhausen');
  1303 -INSERT INTO osc_zones VALUES (121,204,'SO','Solothurn');
  1304 -INSERT INTO osc_zones VALUES (122,204,'SZ','Schwyz');
  1305 -INSERT INTO osc_zones VALUES (123,204,'TG','Thurgau');
  1306 -INSERT INTO osc_zones VALUES (124,204,'TI','Tessin');
  1307 -INSERT INTO osc_zones VALUES (125,204,'UR','Uri');
  1308 -INSERT INTO osc_zones VALUES (126,204,'VD','Waadt');
  1309 -INSERT INTO osc_zones VALUES (127,204,'VS','Wallis');
  1310 -INSERT INTO osc_zones VALUES (128,204,'ZG','Zug');
  1311 -INSERT INTO osc_zones VALUES (129,204,'ZH','Zürich');
  1312 -
13131243 # Spain
  13141244 INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (195,'A Coruña','A Coruña');
  13151245 INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alava','Alava');
      
 !
 
…
13631293 INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (195,'Vizcaya','Vizcaya');
  13641294 INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zamora','Zamora');
  13651295 INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zaragoza','Zaragoza');
<_  1296+
   1297+# Sweden
   1298+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'K','Blekinge län');
   1299+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'W','Dalarnas län');
   1300+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'X','Gävleborgs län');
   1301+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'I','Gotlands län');
   1302+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'N','Hallands län');
   1303+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'Z','Jämtlands län');
   1304+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'F','Jönköpings län');
   1305+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'H','Kalmar län');
   1306+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'G','Kronobergs län');
   1307+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'BD','Norrbottens län');
   1308+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'T','Örebro län');
   1309+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'E','Östergötlands län');
   1310+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'M','Skåne län');
   1311+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'D','Södermanlands län');
   1312+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'AB','Stockholms län');
   1313+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'C','Uppsala län');
   1314+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'S','Värmlands län');
   1315+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'AC','Västerbottens län');
   1316+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'Y','Västernorrlands län');
   1317+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'U','Västmanlands län');
   1318+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (203,'O','Västra Götalands län');
   1319+
   1320+# Swizterland
   1321+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'AG','Aargau');
   1322+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'AR','Appenzell Ausserrhoden');
   1323+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'AI','Appenzell Innerrhoden');
   1324+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'BL','Basel-Landschaft');
   1325+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'BS','Basel-Stadt');
   1326+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'BE','Bern');
   1327+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'FR','Freiburg');
   1328+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'GE','Genf');
   1329+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'GL','Glarus');
   1330+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'JU','Graubünden');
   1331+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'JU','Jura');
   1332+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'LU','Luzern');
   1333+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'NE','Neuenburg');
   1334+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'NW','Nidwalden');
   1335+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'OW','Obwalden');
   1336+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'SH','Schaffhausen');
   1337+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'SZ','Schwyz');
   1338+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'SO','Solothurn');
   1339+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'SG','St. Gallen');
   1340+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'TI','Tessin');
   1341+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'TG','Thurgau');
   1342+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'UR','Uri');
   1343+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'VD','Waadt');
   1344+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'VS','Wallis');
   1345+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'ZG','Zug');
   1346+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (204,'ZH','Zürich');
   1347+
   1348+# USA
   1349+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AL','Alabama');
   1350+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AK','Alaska');
   1351+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AS','American Samoa');
   1352+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AZ','Arizona');
   1353+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AR','Arkansas');
   1354+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AF','Armed Forces Africa');
   1355+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AA','Armed Forces Americas');
   1356+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AC','Armed Forces Canada');
   1357+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AE','Armed Forces Europe');
   1358+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AM','Armed Forces Middle East');
   1359+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'AP','Armed Forces Pacific');
   1360+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'CA','California');
   1361+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'CO','Colorado');
   1362+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'CT','Connecticut');
   1363+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'DE','Delaware');
   1364+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'DC','District of Columbia');
   1365+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'FM','Federated States Of Micronesia');
   1366+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'FL','Florida');
   1367+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'GA','Georgia');
   1368+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'GU','Guam');
   1369+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'HI','Hawaii');
   1370+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'ID','Idaho');
   1371+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'IL','Illinois');
   1372+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'IN','Indiana');
   1373+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'IA','Iowa');
   1374+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'KS','Kansas');
   1375+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'KY','Kentucky');
   1376+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'LA','Louisiana');
   1377+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'ME','Maine');
   1378+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MH','Marshall Islands');
   1379+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MD','Maryland');
   1380+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MA','Massachusetts');
   1381+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MI','Michigan');
   1382+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MN','Minnesota');
   1383+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MS','Mississippi');
   1384+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MO','Missouri');
   1385+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MT','Montana');
   1386+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'NE','Nebraska');
   1387+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'NV','Nevada');
   1388+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'NH','New Hampshire');
   1389+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'NJ','New Jersey');
   1390+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'NM','New Mexico');
   1391+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'NY','New York');
   1392+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'NC','North Carolina');
   1393+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'ND','North Dakota');
   1394+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'MP','Northern Mariana Islands');
   1395+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'OH','Ohio');
   1396+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'OK','Oklahoma');
   1397+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'OR','Oregon');
   1398+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'PW','Palau');
   1399+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'PA','Pennsylvania');
   1400+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'PR','Puerto Rico');
   1401+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'RI','Rhode Island');
   1402+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'SC','South Carolina');
   1403+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'SD','South Dakota');
   1404+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'TN','Tennessee');
   1405+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'TX','Texas');
   1406+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'UT','Utah');
   1407+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'VT','Vermont');
   1408+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'VI','Virgin Islands');
   1409+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'VA','Virginia');
   1410+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'WA','Washington');
   1411+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'WV','West Virginia');
   1412+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'WI','Wisconsin');
   1413+INSERT INTO osc_zones (zone_country_id, zone_code, zone_name) VALUES (223,'WY','Wyoming');