-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 28, 2008 at 02:59 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
-- Created by Jonathan Petitcolas

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `planete-retraite`
--

-- --------------------------------------------------------

--
-- Table structure for table `departements`
--

CREATE TABLE `departements` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `code` varchar(3) NOT NULL,
  `nom` varchar(25) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`),
  UNIQUE KEY `nom` (`nom`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ;

--
-- Dumping data for table `departements`
--

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