Les régions ainsi que les départements français ont été revus et corrigés.
Pour la mise à jour, injecter via sql les données ci-dessous".
Code: Select all
--
-- Contenu de la table `zone`
--
DELETE FROM `zone` WHERE `zone`.`country_id` = 073;
DELETE FROM `zone` WHERE `zone`.`country_id` = 074;
INSERT INTO `zone` (`zone_id`, `country_id`, `code`, `name`) VALUES
(1091, 73, 'AL', 'Alsace'),
(1092, 73, 'AQ', 'Aquitaine'),
(1093, 73, 'AU', 'Auvergne'),
(1094, 73, 'RI', 'Basse-Normandie'),
(1095, 73, 'BR', 'Bretagne'),
(1096, 73, 'BU', 'Bourgogne'),
(1097, 73, 'CE', 'Centre'),
(1098, 73, 'CH', 'Champagne-Ardenne'),
(1099, 73, 'CO', 'Corse'),
(1100, 73, 'FR', 'Franche-Comté'),
(1101, 73, 'NR', 'Haute-Normandie'),
(1102, 73, 'PA', 'Ile-de-France'),
(1103, 73, 'LA', 'Languedoc-Roussillon'),
(1104, 73, 'LI', 'Limousin'),
(1105, 73, 'LO', 'Lorraine'),
(1106, 73, 'MI', 'Midi-Pyrenées'),
(1107, 73, 'NO', 'Nord-Pas-de-Calais'),
(1108, 73, 'WE', 'Pays-de-Loire'),
(1109, 73, 'PI', 'Picardie'),
(1110, 73, 'PO', 'Poitou-Charente'),
(1111, 73, 'PR', 'Provence'),
(1112, 73, 'RH', 'Rhône-Alpes'),
(1113, 74, 'Et', 'Etranger'),
(1114, 74, '01', 'Ain'),
(1115, 74, '02', 'Aisne'),
(1116, 74, '03', 'Allier'),
(1117, 74, '04', 'Alpes-de-Haute-Provence'),
(1118, 74, '05', 'Hautes-Alpes'),
(1119, 74, '06', 'Alpes-Maritimes'),
(1120, 74, '07', 'Ardèche'),
(1121, 74, '08', 'Ardennes'),
(1122, 74, '09', 'Ariège'),
(1123, 74, '10', 'Aube'),
(1124, 74, '11', 'Aude'),
(1125, 74, '12', 'Aveyron'),
(1126, 74, '13', 'Bouches-du-Rhône'),
(1127, 74, '14', 'Calvados'),
(1128, 74, '15', 'Cantal'),
(1129, 74, '16', 'Charente'),
(1130, 74, '17', 'Charente-Maritime'),
(1131, 74, '18', 'Cher'),
(1132, 74, '19', 'Corrèze'),
(1133, 74, '2A', 'Corse-du-Sud'),
(1134, 74, '2B', 'Haute-Corse'),
(1135, 74, '21', 'Côte-d''Or'),
(1136, 74, '22', 'Côtes-d''Armor'),
(1137, 74, '23', 'Creuse'),
(1138, 74, '24', 'Dordogne'),
(1139, 74, '25', 'Doubs'),
(1140, 74, '26', 'Drôme'),
(1141, 74, '27', 'Eure'),
(1142, 74, '28', 'Eure-et-Loir'),
(1143, 74, '29', 'Finistère'),
(1144, 74, '30', 'Gard'),
(1145, 74, '31', 'Haute-Garonne'),
(1146, 74, '32', 'Gers'),
(1147, 74, '33', 'Gironde'),
(1148, 74, '34', 'Hérault'),
(1149, 74, '35', 'Ille-et-Vilaine'),
(1150, 74, '36', 'Indre'),
(1151, 74, '37', 'Indre-et-Loire'),
(1152, 74, '38', 'Isère'),
(1153, 74, '39', 'Jura'),
(1154, 74, '40', 'Landes'),
(1155, 74, '41', 'Loir-et-Cher'),
(1156, 74, '42', 'Loire'),
(1157, 74, '43', 'Haute-Loire'),
(1158, 74, '44', 'Loire-Atlantique'),
(1159, 74, '45', 'Loiret'),
(1160, 74, '46', 'Lot'),
(1161, 74, '47', 'Lot-et-Garonne'),
(1162, 74, '48', 'Lozère'),
(1163, 74, '49', 'Maine-et-Loire'),
(1164, 74, '50', 'Manche'),
(1165, 74, '51', 'Marne'),
(1166, 74, '52', 'Haute-Marne'),
(1167, 74, '53', 'Mayenne'),
(1168, 74, '54', 'Meurthe-et-Moselle'),
(1169, 74, '55', 'Meuse'),
(1170, 74, '56', 'Morbihan'),
(1171, 74, '57', 'Moselle'),
(1172, 74, '58', 'Nièvre'),
(1173, 74, '59', 'Nord'),
(1174, 74, '60', 'Oise'),
(1175, 74, '61', 'Orne'),
(1176, 74, '62', 'Pas-de-Calais'),
(1177, 74, '63', 'Puy-de-Dôme'),
(1178, 74, '64', 'Pyrénées-Atlantiques'),
(1179, 74, '65', 'Hautes-Pyrénées'),
(1180, 74, '66', 'Pyrénées-Orientales'),
(1181, 74, '67', 'Bas-Rhin'),
(1182, 74, '68', 'Haut-Rhin'),
(1183, 74, '69', 'Rhône'),
(1184, 74, '70', 'Haute-Saône'),
(1185, 74, '71', 'Saône-et-Loire'),
(1186, 74, '72', 'Sarthe'),
(1187, 74, '73', 'Savoie'),
(1188, 74, '74', 'Haute-Savoie'),
(1189, 74, '75', 'Paris'),
(1190, 74, '76', 'Seine-Maritime'),
(1191, 74, '77', 'Seine-et-Marne'),
(1192, 74, '78', 'Yvelines'),
(1193, 74, '79', 'Deux Sèvres'),
(1194, 74, '80', 'Somme'),
(1195, 74, '81', 'Tarn'),
(1196, 74, '82', 'Tarn-et-Garonne'),
(1197, 74, '83', 'Var'),
(1198, 74, '84', 'Vaucluse'),
(1199, 74, '85', 'Vendée'),
(1200, 74, '86', 'Vienne'),
(1201, 74, '87', 'Haute-Vienne'),
(1202, 74, '88', 'Vosges'),
(1203, 74, '89', 'Yonne'),
(1204, 74, '90', 'Territoire-de-Belfort'),
(1205, 74, '91', 'Essonne'),
(1206, 74, '92', 'Hauts-de-Seine'),
(1207, 74, '93', 'Seine-St-Denis'),
(1208, 74, '94', 'Val-de-Marne'),
(1209, 74, '95', 'Val-d''Oise');
