french_region.sql

----------------------------------------------------------------------------------------------------
-- 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 `region`
--

CREATE TABLE `region` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(16) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `region`
--

INSERT INTO `region` (`id`, `name`, `code`) VALUES
(1, 'Auvergne-Rhône-Alpes', 'FR-ARA'),
(2, 'Bourgogne-Franche-Comté', 'FR-BFC'),
(3, 'Bretagne', 'FR-BRE'),
(4, 'Centre-Val-de-Loire', 'FR-CVL'),
(5, 'Corse', 'FR-COR'),
(6, 'Grand-Est', 'FR-GES'),
(7, 'Hauts-de-France', 'FR-HDF'),
(8, 'Ile-de-France', 'FR-IDF'),
(9, 'Normandie', 'FR-NOR'),
(10, 'Nouvelle-Aquitaine', 'FR-NAQ'),
(11, 'Occitanie', 'FR-OCC'),
(12, 'Pays-de-la-Loire', 'FR-PDL'),
(13, 'Provence-Alpes-Côte-d’Azur', 'FR-PAC');

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