-- encodage : ISO-8859-1 -- -- Structure de la table `Departement` -- DROP TABLE IF EXISTS `Departement`; CREATE TABLE IF NOT EXISTS `Departement` ( `idDepartement` int(10) unsigned NOT NULL auto_increment, `idRegion` int(10) unsigned default NULL, `codeDepartement` varchar(255) default NULL, `nomDepartement` varchar(255) default NULL, PRIMARY KEY (`idDepartement`), UNIQUE KEY `codeDepartement` (`codeDepartement`(2)), KEY `idRegion` (`idRegion`), FULLTEXT KEY `nomDepartement` (`nomDepartement`) ) TYPE=MyISAM AUTO_INCREMENT=98 ; -- -- Contenu de la table `Departement` -- INSERT INTO `Departement` VALUES (1, 1, '67', 'Bas Rhin'); INSERT INTO `Departement` VALUES (2, 1, '68', 'Haut Rhin'); INSERT INTO `Departement` VALUES (3, 2, '24', 'Dordogne'); INSERT INTO `Departement` VALUES (4, 2, '33', 'Gironde'); INSERT INTO `Departement` VALUES (5, 2, '40', 'Landes'); INSERT INTO `Departement` VALUES (6, 2, '47', 'Lot et Garonne'); INSERT INTO `Departement` VALUES (7, 2, '64', 'Pyrénées Atlantiques'); INSERT INTO `Departement` VALUES (8, 3, '03', 'Allier'); INSERT INTO `Departement` VALUES (9, 3, '15', 'Cantal'); INSERT INTO `Departement` VALUES (10, 3, '43', 'Haute Loire'); INSERT INTO `Departement` VALUES (11, 3, '63', 'Puy de Dôme'); INSERT INTO `Departement` VALUES (12, 4, '14', 'Calvados'); INSERT INTO `Departement` VALUES (13, 4, '50', 'Manche'); INSERT INTO `Departement` VALUES (14, 4, '61', 'Orne'); INSERT INTO `Departement` VALUES (15, 5, '21', 'Côte d''or'); INSERT INTO `Departement` VALUES (16, 5, '58', 'Nièvre'); INSERT INTO `Departement` VALUES (17, 5, '71', 'Saône et Loire'); INSERT INTO `Departement` VALUES (18, 5, '89', 'Yonne'); INSERT INTO `Departement` VALUES (19, 6, '22', 'Côte d''Armor'); INSERT INTO `Departement` VALUES (20, 6, '29', 'Finistère'); INSERT INTO `Departement` VALUES (21, 6, '35', 'Ille et Vilaine'); INSERT INTO `Departement` VALUES (22, 6, '56', 'Morbihan'); INSERT INTO `Departement` VALUES (23, 7, '18', 'Cher'); INSERT INTO `Departement` VALUES (24, 7, '36', 'Indre'); INSERT INTO `Departement` VALUES (25, 7, '37', 'Indre et Loire'); INSERT INTO `Departement` VALUES (26, 7, '41', 'Loir et Cher'); INSERT INTO `Departement` VALUES (27, 7, '45', 'Loiret'); INSERT INTO `Departement` VALUES (28, 8, '08', 'Ardennes'); INSERT INTO `Departement` VALUES (29, 8, '10', 'Aube'); INSERT INTO `Departement` VALUES (30, 8, '52', 'Haute Marne'); INSERT INTO `Departement` VALUES (31, 8, '51', 'Marne'); INSERT INTO `Departement` VALUES (32, 9, '2A', 'Corse du Sud'); INSERT INTO `Departement` VALUES (33, 9, '2B', 'Haute Corse'); INSERT INTO `Departement` VALUES (34, 10, '97', 'D.O.M.'); INSERT INTO `Departement` VALUES (35, 11, '25', 'Doubs'); INSERT INTO `Departement` VALUES (36, 11, '90', 'Territoire de Belfort'); INSERT INTO `Departement` VALUES (37, 11, '70', 'Haute Saône'); INSERT INTO `Departement` VALUES (38, 11, '39', 'Jura'); INSERT INTO `Departement` VALUES (39, 12, '27', 'Eure'); INSERT INTO `Departement` VALUES (40, 12, '76', 'Seine Maritime'); INSERT INTO `Departement` VALUES (41, 13, '91', 'Essonne'); INSERT INTO `Departement` VALUES (42, 13, '92', 'Hauts de Seine'); INSERT INTO `Departement` VALUES (43, 13, '75', 'Paris'); INSERT INTO `Departement` VALUES (44, 13, '93', 'Seine Saint-Denis'); INSERT INTO `Departement` VALUES (45, 13, '77', 'Seine et Marne'); INSERT INTO `Departement` VALUES (46, 13, '95', 'Val d''Oise'); INSERT INTO `Departement` VALUES (47, 13, '94', 'Val de Marne'); INSERT INTO `Departement` VALUES (48, 13, '78', 'Yvelines'); INSERT INTO `Departement` VALUES (49, 14, '11', 'Aude'); INSERT INTO `Departement` VALUES (50, 14, '30', 'Gard'); INSERT INTO `Departement` VALUES (51, 14, '34', 'Hérault'); INSERT INTO `Departement` VALUES (52, 14, '48', 'Lozère'); INSERT INTO `Departement` VALUES (53, 14, '66', 'Pyrénées Orientales'); INSERT INTO `Departement` VALUES (54, 15, '19', 'Corrèze'); INSERT INTO `Departement` VALUES (55, 15, '23', 'Creuse'); INSERT INTO `Departement` VALUES (56, 15, '87', 'Haute-Vienne'); INSERT INTO `Departement` VALUES (57, 16, '54', 'Meurthe et Moselle'); INSERT INTO `Departement` VALUES (58, 16, '55', 'Meuse'); INSERT INTO `Departement` VALUES (59, 16, '57', 'Moselle'); INSERT INTO `Departement` VALUES (60, 16, '88', 'Vosges'); INSERT INTO `Departement` VALUES (61, 17, '09', 'Ariège'); INSERT INTO `Departement` VALUES (62, 17, '12', 'Aveyron'); INSERT INTO `Departement` VALUES (63, 17, '32', 'Gers'); INSERT INTO `Departement` VALUES (64, 17, '31', 'Haute-Garonne'); INSERT INTO `Departement` VALUES (65, 17, '46', 'Lot'); INSERT INTO `Departement` VALUES (66, 17, '81', 'Tarn'); INSERT INTO `Departement` VALUES (67, 17, '82', 'Tarn et Garonne'); INSERT INTO `Departement` VALUES (68, 17, '65', 'Hautes-Pyrénées'); INSERT INTO `Departement` VALUES (69, 18, '59', 'Nord'); INSERT INTO `Departement` VALUES (70, 18, '62', 'Pas de Calais'); INSERT INTO `Departement` VALUES (71, 19, '04', 'Alpes de Haute-Provence'); INSERT INTO `Departement` VALUES (72, 19, '06', 'Alpes-Maritimes'); INSERT INTO `Departement` VALUES (73, 19, '13', 'Bouches du Rhône'); INSERT INTO `Departement` VALUES (74, 19, '05', 'Hautes-Alpes'); INSERT INTO `Departement` VALUES (75, 19, '83', 'Var'); INSERT INTO `Departement` VALUES (76, 19, '84', 'Vaucluse'); INSERT INTO `Departement` VALUES (77, 20, '44', 'Loire-Atlantique'); INSERT INTO `Departement` VALUES (78, 20, '49', 'Maine et Loire'); INSERT INTO `Departement` VALUES (79, 20, '53', 'Mayenne'); INSERT INTO `Departement` VALUES (80, 20, '72', 'Sarthe'); INSERT INTO `Departement` VALUES (81, 20, '85', 'Vendée'); INSERT INTO `Departement` VALUES (82, 21, '02', 'Aisne'); INSERT INTO `Departement` VALUES (83, 21, '60', 'Oise'); INSERT INTO `Departement` VALUES (84, 21, '80', 'Somme'); INSERT INTO `Departement` VALUES (85, 22, '16', 'Charente'); INSERT INTO `Departement` VALUES (86, 22, '17', 'Charente-Maritime'); INSERT INTO `Departement` VALUES (87, 22, '79', 'Deux-Sèvres'); INSERT INTO `Departement` VALUES (88, 22, '86', 'Vienne'); INSERT INTO `Departement` VALUES (89, 23, '01', 'Ain'); INSERT INTO `Departement` VALUES (90, 23, '07', 'Ardèche'); INSERT INTO `Departement` VALUES (91, 23, '26', 'Drôme'); INSERT INTO `Departement` VALUES (92, 23, '74', 'Haute-Savoie'); INSERT INTO `Departement` VALUES (93, 23, '38', 'Isère'); INSERT INTO `Departement` VALUES (94, 23, '42', 'Loire'); INSERT INTO `Departement` VALUES (95, 23, '69', 'Rhône'); INSERT INTO `Departement` VALUES (96, 23, '73', 'Savoie'); INSERT INTO `Departement` VALUES (97, 7, '28', 'Eure et Loir'); -- -------------------------------------------------------- -- -- Structure de la table `Region` -- DROP TABLE IF EXISTS `Region`; CREATE TABLE IF NOT EXISTS `Region` ( `idRegion` int(10) unsigned NOT NULL auto_increment, `nomRegion` varchar(255) default NULL, PRIMARY KEY (`idRegion`), FULLTEXT KEY `nomRegion` (`nomRegion`) ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=24 ; -- -- Contenu de la table `Region` -- INSERT INTO `Region` VALUES (1, 'Alsace'); INSERT INTO `Region` VALUES (2, 'Aquitaine'); INSERT INTO `Region` VALUES (3, 'Auvergne'); INSERT INTO `Region` VALUES (4, 'Basse Normandie'); INSERT INTO `Region` VALUES (5, 'Bourgogne'); INSERT INTO `Region` VALUES (6, 'Bretagne'); INSERT INTO `Region` VALUES (7, 'Centre'); INSERT INTO `Region` VALUES (8, 'Champagne-Ardenne'); INSERT INTO `Region` VALUES (9, 'Corse'); INSERT INTO `Region` VALUES (10, 'D.O.M.'); INSERT INTO `Region` VALUES (11, 'Franche Comté'); INSERT INTO `Region` VALUES (12, 'Haute Normandie'); INSERT INTO `Region` VALUES (13, 'Ile de France'); INSERT INTO `Region` VALUES (14, 'Languedoc-Roussillon'); INSERT INTO `Region` VALUES (15, 'Limousin'); INSERT INTO `Region` VALUES (16, 'Lorraine'); INSERT INTO `Region` VALUES (17, 'Midi-Pyrénées'); INSERT INTO `Region` VALUES (18, 'Nord-Pas de Calais'); INSERT INTO `Region` VALUES (20, 'Pays de la Loire'); INSERT INTO `Region` VALUES (21, 'Picardie'); INSERT INTO `Region` VALUES (22, 'Poitou-Charentes'); INSERT INTO `Region` VALUES (19, 'Provence-Alpes-Côte d''Azur'); INSERT INTO `Region` VALUES (23, 'Rhône-Alpes');