Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
----------------------------------------------------------------------------------------------------
-- More details here : http://growingcookies.com/french-towns-departments-and-regions-january-2018/
-- town table : https://gist.github.com/oanalivia/94fc3aaca90c88bbf8871dbf698637bc
-- department table : https://gist.github.com/oanalivia/040eb8af3d562bf554495de0f1738525/edit
-- region table : https://gist.github.com/oanalivia/0db129e0d66d7371e0f76315326ea82f
-- indexes and constraints : https://gist.github.com/oanalivia/040eb8af3d562bf554495de0f1738525
----------------------------------------------------------------------------------------------------
--
-- Table structure for table `department`
--
CREATE TABLE `department` (
`id` int(11) NOT NULL,
`region_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`postalCode` varchar(16) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `cookiejar_department`
--
INSERT INTO `department` (`id`, `region_id`, `name`, `postalCode`) VALUES
(1, 1, 'Ain', '01'),
(2, 7, 'Aisne', '02'),
(3, 1, 'Allier', '03'),
(4, 13, 'Alpes de Hautes-Provence', '04'),
(5, 13, 'Hautes-Alpes', '05'),
(6, 13, 'Alpes-Maritimes', '06'),
(7, 1, 'Ardèche', '07'),
(8, 6, 'Ardennes', '08'),
(9, 11, 'Ariège', '09'),
(10, 6, 'Aube', '10'),
(11, 11, 'Aude', '11'),
(12, 11, 'Aveyron', '12'),
(13, 13, 'Bouches-du-Rhône', '13'),
(14, 9, 'Calvados', '14'),
(15, 1, 'Cantal', '15'),
(16, 10, 'Charente', '16'),
(17, 10, 'Charente-Maritime', '17'),
(18, 4, 'Cher', '18'),
(19, 10, 'Corrèze', '19'),
(20, 5, 'Corse', '20'),
(21, 2, 'Côte-d\'Or', '21'),
(22, 3, 'Côtes d\'Armor', '22'),
(23, 10, 'Creuse', '23'),
(24, 10, 'Dordogne', '24'),
(25, 2, 'Doubs', '25'),
(26, 1, 'Drôme', '26'),
(27, 9, 'Eure', '27'),
(28, 4, 'Eure-et-Loir', '28'),
(29, 3, 'Finistère', '29'),
(30, 11, 'Gard', '30'),
(31, 11, 'Haute-Garonne', '31'),
(32, 11, 'Gers', '32'),
(33, 10, 'Gironde', '33'),
(34, 11, 'Hérault', '34'),
(35, 3, 'Ille-et-Vilaine', '35'),
(36, 4, 'Indre', '36'),
(37, 4, 'Indre-et-Loire', '37'),
(38, 1, 'Isère', '38'),
(39, 2, 'Jura', '39'),
(40, 10, 'Landes', '40'),
(41, 4, 'Loir-et-Cher', '41'),
(42, 1, 'Loire', '42'),
(43, 1, 'Haute-Loire', '43'),
(44, 12, 'Loire-Atlantique', '44'),
(45, 4, 'Loiret', '45'),
(46, 11, 'Lot', '46'),
(47, 10, 'Lot-et-Garonne', '47'),
(48, 11, 'Lozère', '48'),
(49, 12, 'Maine-et-Loire', '49'),
(50, 9, 'Manche', '50'),
(51, 6, 'Marne', '51'),
(52, 6, 'Haute-Marne', '52'),
(53, 12, 'Mayenne', '53'),
(54, 6, 'Meurthe-et-Moselle', '54'),
(55, 6, 'Meuse', '55'),
(56, 3, 'Morbihan', '56'),
(57, 6, 'Moselle', '57'),
(58, 2, 'Nièvre', '58'),
(59, 7, 'Nord', '59'),
(60, 7, 'Oise', '60'),
(61, 9, 'Orne', '61'),
(62, 7, 'Pas-de-Calais', '62'),
(63, 1, 'Puy-de-Dôme', '63'),
(64, 10, 'Pyrénées-Atlantiques', '64'),
(65, 11, 'Hautes-Pyrénées', '65'),
(66, 11, 'Pyrénées-Orientales', '66'),
(67, 6, 'Bas-Rhin', '67'),
(68, 6, 'Haut-Rhin', '68'),
(69, 1, 'Rhône', '69'),
(70, 2, 'Haute-Saône', '70'),
(71, 2, 'Saône-et-Loire', '71'),
(72, 12, 'Sarthe', '72'),
(73, 1, 'Savoie', '73'),
(74, 1, 'Haute-Savoie', '74'),
(75, 8, 'Paris', '75'),
(76, 9, 'Seine-Maritime', '76'),
(77, 8, 'Seine-et-Marne', '77'),
(78, 8, 'Yvelines', '78'),
(79, 10, 'Deux-Sèvres', '79'),
(80, 7, 'Somme', '80'),
(81, 11, 'Tarn', '81'),
(82, 11, 'Tarn-et-Garonne', '82'),
(83, 13, 'Var', '83'),
(84, 13, 'Vaucluse', '84'),
(85, 12, 'Vendée', '85'),
(86, 10, 'Vienne', '86'),
(87, 10, 'Haute-Vienne', '87'),
(88, 6, 'Vosges', '88'),
(89, 2, 'Yonne', '89'),
(90, 2, 'Territoire-de-Belfort', '90'),
(91, 8, 'Essonne', '91'),
(92, 8, 'Hauts-de-Seine', '92'),
(93, 8, 'Seine-Saint-Denis', '93'),
(94, 8, 'Val-de-Marne', '94'),
(95, 8, 'Val-d\'Oise', '95');
-- --------------------------------------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.