/
region_dep_fr.sql
135 lines (130 loc) · 8.49 KB
/
region_dep_fr.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
SET NAMES utf8mb4;
CREATE TABLE `adverts_departement` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_date` datetime(6) NOT NULL,
`region_id` bigint(20) NOT NULL,
`number` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`),
KEY `adverts_departement_region_id_548821bc_fk_adverts_region_id` (`region_id`),
CONSTRAINT `adverts_departement_region_id_548821bc_fk_adverts_region_id` FOREIGN KEY (`region_id`) REFERENCES `adverts_region` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `adverts_departement` (`id`, `title`, `slug`, `created_date`, `region_id`, `number`) VALUES
(1, 'Ain', 'ain', '2022-02-22 16:54:11.837774', 1, '01'),
(2, 'Allier', 'allier', '2022-02-22 16:58:15.775283', 1, '03'),
(3, 'Ardèche', 'ardeche', '2022-02-22 16:59:09.605234', 1, '07'),
(4, 'Cantal', 'cantal', '2022-02-22 17:00:44.430380', 1, '15'),
(5, 'Drôme', 'drome', '2022-02-22 17:01:04.709720', 1, '26'),
(6, 'Isère', 'isere', '2022-02-22 17:01:21.835269', 1, '38'),
(7, 'Loire', 'loire', '2022-02-22 17:01:35.608881', 1, '42'),
(8, 'Haute-Loire', 'haute-loire', '2022-02-22 17:01:53.629696', 1, '43'),
(9, 'Puy-de-Dôme', 'puy-de-dome', '2022-02-22 17:02:15.660689', 1, '63'),
(10, 'Rhône', 'rhone', '2022-02-22 17:03:48.195667', 1, '69'),
(11, 'Savoie', 'savoie', '2022-02-22 17:04:05.395339', 1, '73'),
(12, 'Haute-Savoie', 'haute-savoie', '2022-02-22 17:04:22.693649', 1, '74'),
(13, 'Côte-d\'Or', 'cote-d-or', '2022-02-22 17:05:20.411429', 2, '21'),
(14, 'Doubs', 'doubs', '2022-02-22 17:05:37.323263', 2, '25'),
(15, 'Jura', 'jura', '2022-02-22 18:03:11.007128', 2, '39'),
(16, 'Nièvre', 'nievre', '2022-02-22 18:10:19.249818', 2, '58'),
(17, 'Haute-Saône', 'haute-saone', '2022-02-22 18:11:06.194864', 2, '70'),
(18, 'Saône-et-Loire', 'saone-et-loire', '2022-02-22 18:11:29.800485', 2, '71'),
(19, 'Yonne', 'yonne', '2022-02-22 18:11:47.393293', 2, '89'),
(20, 'Territoire de Belfort', 'territoire-de-belfort', '2022-02-22 18:12:09.616540', 2, '90'),
(21, 'Côtes-d\'Armor', 'cotes-d-armor', '2022-02-22 18:13:21.293630', 3, '22'),
(22, 'Finistère', 'finistere', '2022-02-22 18:23:45.108558', 3, '29'),
(23, 'Ille-et-Vilaine', 'ille-et-vilaine', '2022-02-22 18:27:03.824747', 3, '35'),
(24, 'Morbihan', 'morbihan', '2022-02-22 18:27:18.427511', 3, '56'),
(25, 'Cher', 'cher', '2022-02-22 18:27:50.230801', 4, '18'),
(26, 'Eure-et-Loire', 'eure-et-loire', '2022-02-22 18:28:32.491181', 4, '28'),
(27, 'Indre', 'indre', '2022-02-22 18:29:10.713618', 4, '36'),
(28, 'Indre-et-Loire', 'indre-et-loire', '2022-02-22 18:30:57.819232', 4, '37'),
(29, 'Loir-et-Cher', 'loir-et-cher', '2022-02-22 18:31:23.978062', 4, '41'),
(30, 'Loiret', 'loiret', '2022-02-22 18:31:48.317330', 4, '45'),
(31, 'Corse-du-Sud', 'corse-du-sud', '2022-02-22 18:32:21.617132', 5, '2A'),
(32, 'Haute-Corse', 'haute-corse', '2022-02-22 18:32:41.795497', 5, '2B'),
(33, 'Ardennes', 'ardennes', '2022-02-22 18:33:27.859535', 6, '08'),
(34, 'Aube', 'aube', '2022-02-22 18:33:54.481024', 6, '10'),
(35, 'Marne', 'marne', '2022-02-22 18:34:07.097897', 6, '51'),
(36, 'Haute-Marne', 'haute-marne', '2022-02-22 18:34:31.479390', 6, '52'),
(37, 'Meurthe-et-Moselle', 'meurthe-et-moselle', '2022-02-22 18:35:05.181584', 6, '54'),
(38, 'Meuse', 'meuse', '2022-02-22 18:36:08.224164', 6, '55'),
(39, 'Moselle', 'moselle', '2022-02-22 18:36:29.888441', 6, '57'),
(40, 'Bas-Rhin', 'bas-rhin', '2022-02-22 18:36:54.694592', 6, '67'),
(41, 'Haut-Rhin', 'haut-rhin', '2022-02-22 18:37:44.691314', 6, '68'),
(42, 'Vosges', 'vosges', '2022-02-22 18:38:48.800650', 6, '88'),
(43, 'Aisne', 'aisne', '2022-02-22 18:39:28.070117', 7, '02'),
(44, 'Nord', 'nord', '2022-02-22 18:40:19.774798', 7, '59'),
(45, 'Oise', 'oise', '2022-02-22 18:40:34.290445', 7, '60'),
(46, 'Pas-de-Calais', 'pas-de-calais', '2022-02-22 18:41:26.552790', 7, '62'),
(47, 'Somme', 'somme', '2022-02-22 18:42:32.698986', 7, '80'),
(48, 'Paris', 'paris', '2022-02-22 18:44:44.601066', 8, '75'),
(49, 'Seine-et-Marne', 'seine-et-marne', '2022-02-22 18:45:01.405814', 8, '77'),
(50, 'Yvelines', 'yvelines', '2022-02-22 18:45:14.529021', 8, '78'),
(51, 'Essonne', 'essonne', '2022-02-22 18:45:37.158879', 8, '91'),
(52, 'Hauts-de-Seine', 'hauts-de-seine', '2022-02-22 18:45:55.842132', 8, '92'),
(53, 'Seine-Saint-Denis', 'seine-saint-denis', '2022-02-22 18:46:15.943457', 8, '93'),
(54, 'Val-de-Marne', 'val-de-marne', '2022-02-22 18:46:39.480831', 8, '94'),
(55, 'Val-d\'Oise', 'val-d-oise', '2022-02-22 18:47:04.174875', 8, '95'),
(56, 'Calvados', 'calvados', '2022-02-22 18:47:34.637181', 9, '14'),
(57, 'Eure', 'eure', '2022-02-22 18:47:49.331457', 9, '27'),
(58, 'Manche', 'manche', '2022-02-22 18:48:03.370100', 9, '50'),
(59, 'Orne', 'orne', '2022-02-22 18:48:22.355176', 9, '61'),
(60, 'Seine-Maritime', 'seine-maritime', '2022-02-22 18:48:41.835476', 9, '76'),
(61, 'Charente', 'charente', '2022-02-23 13:40:40.116435', 10, '16'),
(62, 'Charente-Maritime', 'charente-maritime', '2022-02-23 13:41:03.236854', 10, '17'),
(63, 'Corrèze', 'correze', '2022-02-23 13:41:18.703099', 10, '19'),
(64, 'Creuse', 'creuse', '2022-02-23 13:42:24.460991', 10, '23'),
(65, 'Dordogne', 'dordogne', '2022-02-23 13:42:41.417443', 10, '24'),
(66, 'Gironde', 'gironde', '2022-02-23 13:42:55.408539', 10, '33'),
(67, 'Landes', 'landes', '2022-02-23 13:43:11.236601', 10, '40'),
(68, 'Lot-et-Garonne', 'lot-et-garonne', '2022-02-23 13:43:54.518730', 10, '47'),
(69, 'Pyrénées-Atlantiques', 'pyrenees-atlantiques', '2022-02-23 13:44:23.399977', 10, '64'),
(70, 'Deux-Sèvres', 'deux-sevres', '2022-02-23 13:44:49.851856', 10, '79'),
(71, 'Vienne', 'vienne', '2022-02-23 13:45:06.791668', 10, '86'),
(72, 'Haute-Vienne', 'haute-vienne', '2022-02-23 13:45:30.826955', 10, '87'),
(73, 'Ariège', 'ariege', '2022-02-23 13:45:53.883986', 11, '09'),
(74, 'Aude', 'aude', '2022-02-23 13:46:06.415549', 11, '11'),
(75, 'Aveyron', 'aveyron', '2022-02-23 13:46:18.358217', 11, '12'),
(76, 'Gard', 'gard', '2022-02-23 13:46:33.510003', 11, '30'),
(77, 'Haute-Garonne', 'haute-garonne', '2022-02-23 13:46:54.292988', 11, '31'),
(78, 'Gers', 'gers', '2022-02-23 13:47:07.091189', 11, '32'),
(79, 'Hérault', 'herault', '2022-02-23 13:47:20.846481', 11, '34'),
(80, 'Lot', 'lot', '2022-02-23 13:47:37.621573', 11, '46'),
(81, 'Lozère', 'lozere', '2022-02-23 13:49:08.191488', 11, '48'),
(82, 'Hautes-Pyrénées', 'hautes-pyrenees', '2022-02-23 13:49:38.372998', 11, '65'),
(83, 'Pyrénées-Orientales', 'pyrenees-orientales', '2022-02-23 13:50:03.299386', 11, '66'),
(84, 'Tarn', 'tarn', '2022-02-23 13:50:17.298787', 11, '81'),
(85, 'Tarn-et-Garonne', 'tarn-et-garonne', '2022-02-23 13:51:06.808708', 11, '82'),
(86, 'Loire-Atlantique', 'loire-atlantique', '2022-02-23 13:52:31.933981', 12, '44'),
(87, 'Maine-et-Loire', 'maine-et-loire', '2022-02-23 13:52:56.915792', 12, '49'),
(88, 'Mayenne', 'mayenne', '2022-02-23 13:53:12.088091', 12, '53'),
(89, 'Sarthe', 'sarthe', '2022-02-23 13:53:25.658551', 12, '72'),
(90, 'Vendée', 'vendee', '2022-02-23 13:53:40.382809', 12, '85');
CREATE TABLE `adverts_region` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_date` datetime(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `adverts_region` (`id`, `title`, `slug`, `created_date`) VALUES
(1, 'Auvergne-Rhône-Alpes', 'auvergne-rhone-alpes', '2022-02-22 12:29:28.708909'),
(2, 'Bourgogne-Franche-Comté', 'bourgogne-franche-comte', '2022-02-22 13:07:11.291667'),
(3, 'Bretagne', 'bretagne', '2022-02-22 13:10:49.428157'),
(4, 'Centre-Val de Loire', 'centre-val-de-loire', '2022-02-22 13:20:15.033266'),
(5, 'Corse', 'corse', '2022-02-22 13:20:24.844881'),
(6, 'Grand Est', 'grand-est', '2022-02-22 13:20:39.637865'),
(7, 'Hauts-de-France', 'hauts-de-france', '2022-02-22 13:20:55.619107'),
(8, 'Ile-de-France', 'ile-de-france', '2022-02-22 13:21:19.821229'),
(9, 'Normandie', 'normandie', '2022-02-22 13:21:41.150604'),
(10, 'Nouvelle-Aquitaine', 'nouvelle-aquitaine', '2022-02-22 13:22:03.894626'),
(11, 'Occitanie', 'occitanie', '2022-02-22 13:22:25.130422'),
(12, 'Pays de la Loire', 'pays-de-la-loire', '2022-02-22 15:35:43.937396'),
(13, 'Provence-Alpes-Côte d’Azur', 'provence-alpes-cote-d-azur', '2022-02-22 15:36:18.725486');