zeus_r6 Posted March 14, 2016 Share Posted March 14, 2016 During the initial store creation, all state zones except home state were deleted out of the DB. Does anybody happen to have a query to put all US states back in? Thanks! Link to comment Share on other sites More sharing options...
♥14steve14 Posted March 14, 2016 Share Posted March 14, 2016 Can you not use part of the db install that comes with a standard install package. REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Guest Posted March 14, 2016 Share Posted March 14, 2016 Here is the zones db from an initial 234 install Table CREATE TABLE `zones` ( `zone_id` INT(11) NOT NULL AUTO_INCREMENT, `zone_country_id` INT(11) NOT NULL, `zone_code` VARCHAR(32) NOT NULL COLLATE 'utf8_unicode_ci', `zone_name` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci', PRIMARY KEY (`zone_id`), INDEX `idx_zones_country_id` (`zone_country_id`) ) COLLATE='utf8_unicode_ci' ENGINE=MyISAM AUTO_INCREMENT=182 ; Data INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (1, 223, 'AL', 'Alabama'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (2, 223, 'AK', 'Alaska'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (3, 223, 'AS', 'American Samoa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (4, 223, 'AZ', 'Arizona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (5, 223, 'AR', 'Arkansas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (6, 223, 'AF', 'Armed Forces Africa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (7, 223, 'AA', 'Armed Forces Americas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (8, 223, 'AC', 'Armed Forces Canada'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (9, 223, 'AE', 'Armed Forces Europe'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (10, 223, 'AM', 'Armed Forces Middle East'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (11, 223, 'AP', 'Armed Forces Pacific'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (12, 223, 'CA', 'California'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (13, 223, 'CO', 'Colorado'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (14, 223, 'CT', 'Connecticut'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (15, 223, 'DE', 'Delaware'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (16, 223, 'DC', 'District of Columbia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (17, 223, 'FM', 'Federated States Of Micronesia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (18, 223, 'FL', 'Florida'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (19, 223, 'GA', 'Georgia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (20, 223, 'GU', 'Guam'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (21, 223, 'HI', 'Hawaii'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (22, 223, 'ID', 'Idaho'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (23, 223, 'IL', 'Illinois'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (24, 223, 'IN', 'Indiana'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (25, 223, 'IA', 'Iowa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (26, 223, 'KS', 'Kansas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (27, 223, 'KY', 'Kentucky'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (28, 223, 'LA', 'Louisiana'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (29, 223, 'ME', 'Maine'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (30, 223, 'MH', 'Marshall Islands'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (31, 223, 'MD', 'Maryland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (32, 223, 'MA', 'Massachusetts'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (33, 223, 'MI', 'Michigan'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (34, 223, 'MN', 'Minnesota'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (35, 223, 'MS', 'Mississippi'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (36, 223, 'MO', 'Missouri'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (37, 223, 'MT', 'Montana'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (38, 223, 'NE', 'Nebraska'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (39, 223, 'NV', 'Nevada'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (40, 223, 'NH', 'New Hampshire'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (41, 223, 'NJ', 'New Jersey'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (42, 223, 'NM', 'New Mexico'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (43, 223, 'NY', 'New York'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (44, 223, 'NC', 'North Carolina'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (45, 223, 'ND', 'North Dakota'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (46, 223, 'MP', 'Northern Mariana Islands'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (47, 223, 'OH', 'Ohio'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (48, 223, 'OK', 'Oklahoma'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (49, 223, 'OR', 'Oregon'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (50, 223, 'PW', 'Palau'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (51, 223, 'PA', 'Pennsylvania'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (52, 223, 'PR', 'Puerto Rico'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (53, 223, 'RI', 'Rhode Island'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (54, 223, 'SC', 'South Carolina'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (55, 223, 'SD', 'South Dakota'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (56, 223, 'TN', 'Tennessee'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (57, 223, 'TX', 'Texas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (58, 223, 'UT', 'Utah'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (59, 223, 'VT', 'Vermont'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (60, 223, 'VI', 'Virgin Islands'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (61, 223, 'VA', 'Virginia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (62, 223, 'WA', 'Washington'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (63, 223, 'WV', 'West Virginia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (64, 223, 'WI', 'Wisconsin'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (65, 223, 'WY', 'Wyoming'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (66, 38, 'AB', 'Alberta'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (67, 38, 'BC', 'British Columbia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (68, 38, 'MB', 'Manitoba'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (69, 38, 'NF', 'Newfoundland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (70, 38, 'NB', 'New Brunswick'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (71, 38, 'NS', 'Nova Scotia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (72, 38, 'NT', 'Northwest Territories'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (73, 38, 'NU', 'Nunavut'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (74, 38, 'ON', 'Ontario'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (75, 38, 'PE', 'Prince Edward Island'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (76, 38, 'QC', 'Quebec'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (77, 38, 'SK', 'Saskatchewan'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (78, 38, 'YT', 'Yukon Territory'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (79, 81, 'NDS', 'Niedersachsen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (80, 81, 'BAW', 'Baden-Württemberg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (81, 81, 'BAY', 'Bayern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (82, 81, 'BER', 'Berlin'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (83, 81, 'BRG', 'Brandenburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (84, 81, 'BRE', 'Bremen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (85, 81, 'HAM', 'Hamburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (86, 81, 'HES', 'Hessen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (87, 81, 'MEC', 'Mecklenburg-Vorpommern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (88, 81, 'NRW', 'Nordrhein-Westfalen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (89, 81, 'RHE', 'Rheinland-Pfalz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (90, 81, 'SAR', 'Saarland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (91, 81, 'SAS', 'Sachsen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (92, 81, 'SAC', 'Sachsen-Anhalt'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (93, 81, 'SCN', 'Schleswig-Holstein'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (94, 81, 'THE', 'Thüringen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (95, 14, 'WI', 'Wien'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (96, 14, 'NO', 'Niederösterreich'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (97, 14, 'OO', 'Oberösterreich'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (98, 14, 'SB', 'Salzburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (99, 14, 'KN', 'Kärnten'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (100, 14, 'ST', 'Steiermark'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (101, 14, 'TI', 'Tirol'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (102, 14, 'BL', 'Burgenland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (103, 14, 'VB', 'Voralberg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (104, 204, 'AG', 'Aargau'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (105, 204, 'AI', 'Appenzell Innerrhoden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (106, 204, 'AR', 'Appenzell Ausserrhoden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (107, 204, 'BE', 'Bern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (108, 204, 'BL', 'Basel-Landschaft'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (109, 204, 'BS', 'Basel-Stadt'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (110, 204, 'FR', 'Freiburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (111, 204, 'GE', 'Genf'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (112, 204, 'GL', 'Glarus'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (113, 204, 'JU', 'Graubünden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (114, 204, 'JU', 'Jura'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (115, 204, 'LU', 'Luzern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (116, 204, 'NE', 'Neuenburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (117, 204, 'NW', 'Nidwalden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (118, 204, 'OW', 'Obwalden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (119, 204, 'SG', 'St. Gallen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (120, 204, 'SH', 'Schaffhausen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (121, 204, 'SO', 'Solothurn'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (122, 204, 'SZ', 'Schwyz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (123, 204, 'TG', 'Thurgau'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (124, 204, 'TI', 'Tessin'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (125, 204, 'UR', 'Uri'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (126, 204, 'VD', 'Waadt'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (127, 204, 'VS', 'Wallis'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (128, 204, 'ZG', 'Zug'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (129, 204, 'ZH', 'Zürich'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (130, 195, 'A Coruña', 'A Coruña'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (131, 195, 'Alava', 'Alava'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (132, 195, 'Albacete', 'Albacete'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (133, 195, 'Alicante', 'Alicante'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (134, 195, 'Almeria', 'Almeria'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (135, 195, 'Asturias', 'Asturias'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (136, 195, 'Avila', 'Avila'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (137, 195, 'Badajoz', 'Badajoz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (138, 195, 'Baleares', 'Baleares'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (139, 195, 'Barcelona', 'Barcelona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (140, 195, 'Burgos', 'Burgos'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (141, 195, 'Caceres', 'Caceres'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (142, 195, 'Cadiz', 'Cadiz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (143, 195, 'Cantabria', 'Cantabria'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (144, 195, 'Castellon', 'Castellon'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (145, 195, 'Ceuta', 'Ceuta'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (146, 195, 'Ciudad Real', 'Ciudad Real'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (147, 195, 'Cordoba', 'Cordoba'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (148, 195, 'Cuenca', 'Cuenca'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (149, 195, 'Girona', 'Girona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (150, 195, 'Granada', 'Granada'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (151, 195, 'Guadalajara', 'Guadalajara'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (152, 195, 'Guipuzcoa', 'Guipuzcoa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (153, 195, 'Huelva', 'Huelva'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (154, 195, 'Huesca', 'Huesca'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (155, 195, 'Jaen', 'Jaen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (156, 195, 'La Rioja', 'La Rioja'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (157, 195, 'Las Palmas', 'Las Palmas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (158, 195, 'Leon', 'Leon'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (159, 195, 'Lleida', 'Lleida'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (160, 195, 'Lugo', 'Lugo'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (161, 195, 'Madrid', 'Madrid'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (162, 195, 'Malaga', 'Malaga'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (163, 195, 'Melilla', 'Melilla'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (164, 195, 'Murcia', 'Murcia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (165, 195, 'Navarra', 'Navarra'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (166, 195, 'Ourense', 'Ourense'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (167, 195, 'Palencia', 'Palencia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (168, 195, 'Pontevedra', 'Pontevedra'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (169, 195, 'Salamanca', 'Salamanca'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (171, 195, 'Segovia', 'Segovia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (172, 195, 'Sevilla', 'Sevilla'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (173, 195, 'Soria', 'Soria'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (174, 195, 'Tarragona', 'Tarragona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (175, 195, 'Teruel', 'Teruel'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (176, 195, 'Toledo', 'Toledo'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (177, 195, 'Valencia', 'Valencia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (178, 195, 'Valladolid', 'Valladolid'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (179, 195, 'Vizcaya', 'Vizcaya'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (180, 195, 'Zamora', 'Zamora'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (181, 195, 'Zaragoza', 'Zaragoza'); Link to comment Share on other sites More sharing options...
zeus_r6 Posted March 15, 2016 Author Share Posted March 15, 2016 Here is the zones db from an initial 234 install Table CREATE TABLE `zones` ( `zone_id` INT(11) NOT NULL AUTO_INCREMENT, `zone_country_id` INT(11) NOT NULL, `zone_code` VARCHAR(32) NOT NULL COLLATE 'utf8_unicode_ci', `zone_name` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci', PRIMARY KEY (`zone_id`), INDEX `idx_zones_country_id` (`zone_country_id`) ) COLLATE='utf8_unicode_ci' ENGINE=MyISAM AUTO_INCREMENT=182 ; Data INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (1, 223, 'AL', 'Alabama'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (2, 223, 'AK', 'Alaska'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (3, 223, 'AS', 'American Samoa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (4, 223, 'AZ', 'Arizona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (5, 223, 'AR', 'Arkansas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (6, 223, 'AF', 'Armed Forces Africa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (7, 223, 'AA', 'Armed Forces Americas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (8, 223, 'AC', 'Armed Forces Canada'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (9, 223, 'AE', 'Armed Forces Europe'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (10, 223, 'AM', 'Armed Forces Middle East'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (11, 223, 'AP', 'Armed Forces Pacific'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (12, 223, 'CA', 'California'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (13, 223, 'CO', 'Colorado'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (14, 223, 'CT', 'Connecticut'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (15, 223, 'DE', 'Delaware'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (16, 223, 'DC', 'District of Columbia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (17, 223, 'FM', 'Federated States Of Micronesia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (18, 223, 'FL', 'Florida'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (19, 223, 'GA', 'Georgia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (20, 223, 'GU', 'Guam'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (21, 223, 'HI', 'Hawaii'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (22, 223, 'ID', 'Idaho'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (23, 223, 'IL', 'Illinois'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (24, 223, 'IN', 'Indiana'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (25, 223, 'IA', 'Iowa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (26, 223, 'KS', 'Kansas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (27, 223, 'KY', 'Kentucky'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (28, 223, 'LA', 'Louisiana'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (29, 223, 'ME', 'Maine'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (30, 223, 'MH', 'Marshall Islands'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (31, 223, 'MD', 'Maryland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (32, 223, 'MA', 'Massachusetts'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (33, 223, 'MI', 'Michigan'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (34, 223, 'MN', 'Minnesota'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (35, 223, 'MS', 'Mississippi'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (36, 223, 'MO', 'Missouri'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (37, 223, 'MT', 'Montana'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (38, 223, 'NE', 'Nebraska'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (39, 223, 'NV', 'Nevada'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (40, 223, 'NH', 'New Hampshire'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (41, 223, 'NJ', 'New Jersey'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (42, 223, 'NM', 'New Mexico'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (43, 223, 'NY', 'New York'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (44, 223, 'NC', 'North Carolina'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (45, 223, 'ND', 'North Dakota'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (46, 223, 'MP', 'Northern Mariana Islands'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (47, 223, 'OH', 'Ohio'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (48, 223, 'OK', 'Oklahoma'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (49, 223, 'OR', 'Oregon'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (50, 223, 'PW', 'Palau'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (51, 223, 'PA', 'Pennsylvania'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (52, 223, 'PR', 'Puerto Rico'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (53, 223, 'RI', 'Rhode Island'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (54, 223, 'SC', 'South Carolina'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (55, 223, 'SD', 'South Dakota'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (56, 223, 'TN', 'Tennessee'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (57, 223, 'TX', 'Texas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (58, 223, 'UT', 'Utah'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (59, 223, 'VT', 'Vermont'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (60, 223, 'VI', 'Virgin Islands'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (61, 223, 'VA', 'Virginia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (62, 223, 'WA', 'Washington'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (63, 223, 'WV', 'West Virginia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (64, 223, 'WI', 'Wisconsin'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (65, 223, 'WY', 'Wyoming'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (66, 38, 'AB', 'Alberta'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (67, 38, 'BC', 'British Columbia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (68, 38, 'MB', 'Manitoba'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (69, 38, 'NF', 'Newfoundland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (70, 38, 'NB', 'New Brunswick'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (71, 38, 'NS', 'Nova Scotia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (72, 38, 'NT', 'Northwest Territories'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (73, 38, 'NU', 'Nunavut'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (74, 38, 'ON', 'Ontario'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (75, 38, 'PE', 'Prince Edward Island'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (76, 38, 'QC', 'Quebec'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (77, 38, 'SK', 'Saskatchewan'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (78, 38, 'YT', 'Yukon Territory'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (79, 81, 'NDS', 'Niedersachsen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (80, 81, 'BAW', 'Baden-Württemberg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (81, 81, 'BAY', 'Bayern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (82, 81, 'BER', 'Berlin'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (83, 81, 'BRG', 'Brandenburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (84, 81, 'BRE', 'Bremen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (85, 81, 'HAM', 'Hamburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (86, 81, 'HES', 'Hessen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (87, 81, 'MEC', 'Mecklenburg-Vorpommern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (88, 81, 'NRW', 'Nordrhein-Westfalen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (89, 81, 'RHE', 'Rheinland-Pfalz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (90, 81, 'SAR', 'Saarland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (91, 81, 'SAS', 'Sachsen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (92, 81, 'SAC', 'Sachsen-Anhalt'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (93, 81, 'SCN', 'Schleswig-Holstein'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (94, 81, 'THE', 'Thüringen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (95, 14, 'WI', 'Wien'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (96, 14, 'NO', 'Niederösterreich'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (97, 14, 'OO', 'Oberösterreich'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (98, 14, 'SB', 'Salzburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (99, 14, 'KN', 'Kärnten'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (100, 14, 'ST', 'Steiermark'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (101, 14, 'TI', 'Tirol'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (102, 14, 'BL', 'Burgenland'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (103, 14, 'VB', 'Voralberg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (104, 204, 'AG', 'Aargau'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (105, 204, 'AI', 'Appenzell Innerrhoden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (106, 204, 'AR', 'Appenzell Ausserrhoden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (107, 204, 'BE', 'Bern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (108, 204, 'BL', 'Basel-Landschaft'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (109, 204, 'BS', 'Basel-Stadt'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (110, 204, 'FR', 'Freiburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (111, 204, 'GE', 'Genf'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (112, 204, 'GL', 'Glarus'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (113, 204, 'JU', 'Graubünden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (114, 204, 'JU', 'Jura'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (115, 204, 'LU', 'Luzern'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (116, 204, 'NE', 'Neuenburg'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (117, 204, 'NW', 'Nidwalden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (118, 204, 'OW', 'Obwalden'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (119, 204, 'SG', 'St. Gallen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (120, 204, 'SH', 'Schaffhausen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (121, 204, 'SO', 'Solothurn'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (122, 204, 'SZ', 'Schwyz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (123, 204, 'TG', 'Thurgau'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (124, 204, 'TI', 'Tessin'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (125, 204, 'UR', 'Uri'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (126, 204, 'VD', 'Waadt'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (127, 204, 'VS', 'Wallis'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (128, 204, 'ZG', 'Zug'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (129, 204, 'ZH', 'Zürich'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (130, 195, 'A Coruña', 'A Coruña'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (131, 195, 'Alava', 'Alava'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (132, 195, 'Albacete', 'Albacete'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (133, 195, 'Alicante', 'Alicante'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (134, 195, 'Almeria', 'Almeria'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (135, 195, 'Asturias', 'Asturias'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (136, 195, 'Avila', 'Avila'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (137, 195, 'Badajoz', 'Badajoz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (138, 195, 'Baleares', 'Baleares'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (139, 195, 'Barcelona', 'Barcelona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (140, 195, 'Burgos', 'Burgos'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (141, 195, 'Caceres', 'Caceres'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (142, 195, 'Cadiz', 'Cadiz'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (143, 195, 'Cantabria', 'Cantabria'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (144, 195, 'Castellon', 'Castellon'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (145, 195, 'Ceuta', 'Ceuta'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (146, 195, 'Ciudad Real', 'Ciudad Real'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (147, 195, 'Cordoba', 'Cordoba'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (148, 195, 'Cuenca', 'Cuenca'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (149, 195, 'Girona', 'Girona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (150, 195, 'Granada', 'Granada'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (151, 195, 'Guadalajara', 'Guadalajara'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (152, 195, 'Guipuzcoa', 'Guipuzcoa'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (153, 195, 'Huelva', 'Huelva'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (154, 195, 'Huesca', 'Huesca'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (155, 195, 'Jaen', 'Jaen'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (156, 195, 'La Rioja', 'La Rioja'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (157, 195, 'Las Palmas', 'Las Palmas'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (158, 195, 'Leon', 'Leon'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (159, 195, 'Lleida', 'Lleida'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (160, 195, 'Lugo', 'Lugo'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (161, 195, 'Madrid', 'Madrid'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (162, 195, 'Malaga', 'Malaga'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (163, 195, 'Melilla', 'Melilla'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (164, 195, 'Murcia', 'Murcia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (165, 195, 'Navarra', 'Navarra'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (166, 195, 'Ourense', 'Ourense'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (167, 195, 'Palencia', 'Palencia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (168, 195, 'Pontevedra', 'Pontevedra'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (169, 195, 'Salamanca', 'Salamanca'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (171, 195, 'Segovia', 'Segovia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (172, 195, 'Sevilla', 'Sevilla'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (173, 195, 'Soria', 'Soria'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (174, 195, 'Tarragona', 'Tarragona'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (175, 195, 'Teruel', 'Teruel'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (176, 195, 'Toledo', 'Toledo'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (177, 195, 'Valencia', 'Valencia'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (178, 195, 'Valladolid', 'Valladolid'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (179, 195, 'Vizcaya', 'Vizcaya'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (180, 195, 'Zamora', 'Zamora'); INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (181, 195, 'Zaragoza', 'Zaragoza'); The store is 2.3.3 Will this be the same? Link to comment Share on other sites More sharing options...
Guest Posted March 15, 2016 Share Posted March 15, 2016 I am not 100% certain as I do not have the 2.3.3 installed to confirm. Though I am not aware of any changes to this table. Link to comment Share on other sites More sharing options...
♥14steve14 Posted March 15, 2016 Share Posted March 15, 2016 If you go to https://www.oscommerce.com/Products scroll to near the bottom of the page and you will be able to download all the different versions of oscommerce and get the correct sql files from the install package. REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.