osC v2.3.1 French provinces in Native French needed!

[Guest]

Hi

 

Has anyone got a full French Provinces/Cities database file would like to share?

 

I had German, French, English installed on osC v2.3.1 but there was no SQL file for french language for their cities.

 

Can anyone share one?

 

THanks

[foxp2]

#France
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '01', 'Ain');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '02', 'Aisne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '03', 'Allier');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '04', 'Alpes de Haute-Provence');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '05', 'Hautes-Alpes');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '06', 'Alpes-Maritimes');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '07', 'Ardêche');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '08', 'Ardennes');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '09', 'Ariège');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '10', 'Aube');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '11', 'Aude');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '12', 'Aveyron');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '13', 'Bouches-du-Rhône');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '14', 'Calvados');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '15', 'Cantal');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '16', 'Charente');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '17', 'Charente-Maritime');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '18', 'Cher');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '19', 'Corrèze');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('74', '2A', 'Corse-du-Sud');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('74', '2B', 'Haute-Corse');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '21', 'Côte-d\'Or');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '22', 'Côtes d\'Armor');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '23', 'Creuse');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '24', 'Dordogne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '25', 'Doubs');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '26', 'Drôme');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '27', 'Eure');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '28', 'Eure-Et-Loir');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '29', 'Finistère');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '30', 'Gard');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '31', 'Haute-Garonne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '32', 'Gers');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '33', 'Gironde');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '34', 'Herault');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '35', 'Île-et-Vilaine');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '36', 'Indre');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '37', 'Indre-et-Loire');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '38', 'Isère');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '39', 'Jura');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '40', 'Landes');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '41', 'Loir-et-Cher');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '42', 'Loire');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '43', 'Haute-Loire');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '44', 'Loire-Atlantique');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '45', 'Loiret');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '46', 'Lot');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '47', 'Lot-et-Garonne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '48', 'Lozère');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '49', 'Maine-et-Loire');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '50', 'Manche');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '51', 'Marne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '52', 'Haute-Marne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '53', 'Mayenne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '54', 'Meurthe-et-Mozelle');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '55', 'Meuse');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '56', 'Morbihan');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '57', 'Mozelle');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '58', 'Nièvre');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '59', 'Nord');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '60', 'Oise');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '61', 'Orne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '62', 'Pas-de-Calais');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '63', 'Puy-de-Dôme');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '64', 'Pyrénées-Atlantiques');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '65', 'Hautes-Pyrénées');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '66', 'Pyrénées-Orientales');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '67', 'Bas-Rhin');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '68', 'Haut-Rhin');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '69', 'Rhône');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '70', 'Haute-Saône');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '71', 'Saône-et-Loire');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '72', 'Sarthe');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '73', 'Savoie');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '74', 'Haute-Savoie');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '75', 'Paris');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '76', 'Seine-Maritime');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '77', 'Seine-et-Marne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '78', 'Yvelynes');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '79', 'Deux-Sèvres');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '80', 'Somme');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '81', 'Tarn');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '82', 'Tarn-et-Garonne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '83', 'Var');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '84', 'Haut-Var');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '85', 'Vaucluse');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '86', 'Vienne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '87', 'Haute-Vienne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '88', 'Vosges');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '89', 'Yonne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '90', 'Territoire-de-Belfort');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '91', 'Essonne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '92', 'Hauts-de-Seine');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '93', 'Seine-Saint-Denis');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '94', 'Val-de-Marne');INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES ('73', '95', 'Val-de-d\'Oise');