Subversion Repositories Applications.papyrus

-- 

-- Structure de la table `gen_departement`

-- 

CREATE TABLE `gen_departement` (

  `gd_id_departement` int(11) NOT NULL default '0',

  `gd_nom` varchar(100) NOT NULL default '',

  `gd_region` int(11) NOT NULL default '900',

  PRIMARY KEY  (`gd_id_departement`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 

-- Contenu de la table `gen_departement`

-- 

INSERT INTO `gen_departement` VALUES (1, 'Ain', 22);

INSERT INTO `gen_departement` VALUES (2, 'Aisne', 19);

INSERT INTO `gen_departement` VALUES (3, 'Allier', 3);

INSERT INTO `gen_departement` VALUES (4, 'Alpes-de-Haute-Provence', 21);

INSERT INTO `gen_departement` VALUES (5, 'Hautes-Alpes', 21);

INSERT INTO `gen_departement` VALUES (6, 'Alpes-Maritimes', 21);

INSERT INTO `gen_departement` VALUES (7, 'Ardèche', 22);

INSERT INTO `gen_departement` VALUES (8, 'Ardennes', 8);

INSERT INTO `gen_departement` VALUES (9, 'Ariège', 16);

INSERT INTO `gen_departement` VALUES (10, 'Aube', 8);

INSERT INTO `gen_departement` VALUES (11, 'Aude', 13);

INSERT INTO `gen_departement` VALUES (12, 'Aveyron', 16);

INSERT INTO `gen_departement` VALUES (13, 'Bouches-du-Rhône', 21);

INSERT INTO `gen_departement` VALUES (14, 'Calvados', 4);

INSERT INTO `gen_departement` VALUES (15, 'Cantal', 3);

INSERT INTO `gen_departement` VALUES (16, 'Charente', 20);

INSERT INTO `gen_departement` VALUES (17, 'Charente-Maritime', 20);

INSERT INTO `gen_departement` VALUES (18, 'Cher', 7);

INSERT INTO `gen_departement` VALUES (19, 'Corrèze', 14);

INSERT INTO `gen_departement` VALUES (20, 'Corse', 9);

INSERT INTO `gen_departement` VALUES (21, 'Côte-d''Or', 5);

INSERT INTO `gen_departement` VALUES (22, 'Côtes-d''Armor', 6);

INSERT INTO `gen_departement` VALUES (23, 'Creuse', 14);

INSERT INTO `gen_departement` VALUES (24, 'Dordogne', 2);

INSERT INTO `gen_departement` VALUES (25, 'Doubs', 10);

INSERT INTO `gen_departement` VALUES (26, 'Drôme', 22);

INSERT INTO `gen_departement` VALUES (27, 'Eure', 11);

INSERT INTO `gen_departement` VALUES (28, 'Eure-et-Loir', 7);

INSERT INTO `gen_departement` VALUES (29, 'Finistère', 6);

INSERT INTO `gen_departement` VALUES (30, 'Gard', 13);

INSERT INTO `gen_departement` VALUES (31, 'Haute-Garonne', 16);

INSERT INTO `gen_departement` VALUES (32, 'Gers', 16);

INSERT INTO `gen_departement` VALUES (33, 'Gironde', 2);

INSERT INTO `gen_departement` VALUES (34, 'Hérault', 13);

INSERT INTO `gen_departement` VALUES (35, 'Ille-et-Vilaine', 6);

INSERT INTO `gen_departement` VALUES (36, 'Indre', 7);

INSERT INTO `gen_departement` VALUES (37, 'Indre-et-Loire', 7);

INSERT INTO `gen_departement` VALUES (38, 'Isère', 22);

INSERT INTO `gen_departement` VALUES (39, 'Jura', 10);

INSERT INTO `gen_departement` VALUES (40, 'Landes', 2);

INSERT INTO `gen_departement` VALUES (41, 'Loir-et-Cher', 7);

INSERT INTO `gen_departement` VALUES (42, 'Loire', 22);

INSERT INTO `gen_departement` VALUES (43, 'Haute-Loire', 3);

INSERT INTO `gen_departement` VALUES (44, 'Loire-Atlantique', 18);

INSERT INTO `gen_departement` VALUES (45, 'Loiret', 7);

INSERT INTO `gen_departement` VALUES (46, 'Lot', 16);

INSERT INTO `gen_departement` VALUES (47, 'Lot-et-Garonne', 2);

INSERT INTO `gen_departement` VALUES (48, 'Lozére', 13);

INSERT INTO `gen_departement` VALUES (49, 'Maine-et-Loire', 18);

INSERT INTO `gen_departement` VALUES (50, 'Manche', 4);

INSERT INTO `gen_departement` VALUES (51, 'Marne', 8);

INSERT INTO `gen_departement` VALUES (52, 'Haute-Marne', 8);

INSERT INTO `gen_departement` VALUES (53, 'Mayenne', 18);

INSERT INTO `gen_departement` VALUES (54, 'Meurthe-et-Moselle', 15);

INSERT INTO `gen_departement` VALUES (55, 'Meuse', 15);

INSERT INTO `gen_departement` VALUES (56, 'Morbihan', 6);

INSERT INTO `gen_departement` VALUES (57, 'Moselle', 15);

INSERT INTO `gen_departement` VALUES (58, 'Nièvre', 5);

INSERT INTO `gen_departement` VALUES (59, 'Nord', 17);

INSERT INTO `gen_departement` VALUES (60, 'Oise', 19);

INSERT INTO `gen_departement` VALUES (61, 'Orne', 4);

INSERT INTO `gen_departement` VALUES (62, 'Pas-de-Calais', 17);

INSERT INTO `gen_departement` VALUES (63, 'Puy-de-Dôme', 3);

INSERT INTO `gen_departement` VALUES (64, 'Pyrénées-Atlantiques', 2);

INSERT INTO `gen_departement` VALUES (65, 'Hautes-Pyrénées', 16);

INSERT INTO `gen_departement` VALUES (66, 'Pyrénées-Orientales', 13);

INSERT INTO `gen_departement` VALUES (67, 'Bas-Rhin', 1);

INSERT INTO `gen_departement` VALUES (68, 'Haut-Rhin', 1);

INSERT INTO `gen_departement` VALUES (69, 'Rhône', 22);

INSERT INTO `gen_departement` VALUES (70, 'Haute-Saône', 10);

INSERT INTO `gen_departement` VALUES (71, 'Saône-et-Loire', 5);

INSERT INTO `gen_departement` VALUES (72, 'Sarthe', 18);

INSERT INTO `gen_departement` VALUES (73, 'Savoie', 22);

INSERT INTO `gen_departement` VALUES (74, 'Haute-Savoie', 22);

INSERT INTO `gen_departement` VALUES (75, 'Paris', 12);

INSERT INTO `gen_departement` VALUES (76, 'Seine-Maritime', 11);

INSERT INTO `gen_departement` VALUES (77, 'Seine-et-Marne', 12);

INSERT INTO `gen_departement` VALUES (78, 'Yvelines', 12);

INSERT INTO `gen_departement` VALUES (79, 'Deux-Sèvres', 20);

INSERT INTO `gen_departement` VALUES (80, 'Somme', 19);

INSERT INTO `gen_departement` VALUES (81, 'Tarn', 16);

INSERT INTO `gen_departement` VALUES (82, 'Tarn-et-Garonne', 16);

INSERT INTO `gen_departement` VALUES (83, 'Var', 21);

INSERT INTO `gen_departement` VALUES (84, 'Vaucluse', 21);

INSERT INTO `gen_departement` VALUES (85, 'Vendée', 18);

INSERT INTO `gen_departement` VALUES (86, 'Vienne', 20);

INSERT INTO `gen_departement` VALUES (87, 'Haute-Vienne', 14);

INSERT INTO `gen_departement` VALUES (88, 'Vosges', 15);

INSERT INTO `gen_departement` VALUES (89, 'Yonne', 5);

INSERT INTO `gen_departement` VALUES (90, 'Territoire-de-Belfort', 10);

INSERT INTO `gen_departement` VALUES (91, 'Essonne', 12);

INSERT INTO `gen_departement` VALUES (92, 'Hauts-de-Seine', 12);

INSERT INTO `gen_departement` VALUES (93, 'Seine-Saint-Denis', 12);

INSERT INTO `gen_departement` VALUES (94, 'Val-de-Marne', 12);

INSERT INTO `gen_departement` VALUES (95, 'Val-d''Oise', 12);

INSERT INTO `gen_departement` VALUES (99, 'Etranger', 900);

INSERT INTO `gen_departement` VALUES (971, 'Guadeloupe', 900);

INSERT INTO `gen_departement` VALUES (972, 'Martinique', 900);

INSERT INTO `gen_departement` VALUES (973, 'Guyane', 900);

INSERT INTO `gen_departement` VALUES (974, 'Réunion', 900);

INSERT INTO `gen_departement` VALUES (975, 'St-Pierre-et-Miquelon', 900);

INSERT INTO `gen_departement` VALUES (976, 'Mayotte', 900);

INSERT INTO `gen_departement` VALUES (980, 'Monaco', 900);

INSERT INTO `gen_departement` VALUES (986, 'Wallis-et-Futuna', 900);

INSERT INTO `gen_departement` VALUES (987, 'Polynésie-Française', 900);

INSERT INTO `gen_departement` VALUES (988, 'Nouvelle-Calédonie', 900);

INSERT INTO `gen_departement` VALUES (900, '', 900);