· 4 years ago · May 17, 2021, 03:28 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.4.18-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table covid_data_analysis.categories
15CREATE TABLE IF NOT EXISTS `categories` (
16 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
17 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
18 `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
19 `created_at` timestamp NULL DEFAULT NULL,
20 `updated_at` timestamp NULL DEFAULT NULL,
21 `deleted_at` timestamp NULL DEFAULT NULL,
22 PRIMARY KEY (`id`),
23 UNIQUE KEY `categories_name_unique` (`name`),
24 UNIQUE KEY `categories_slug_unique` (`slug`)
25) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
26
27-- Data exporting was unselected.
28
29-- Dumping structure for table covid_data_analysis.category_resource
30CREATE TABLE IF NOT EXISTS `category_resource` (
31 `resource_id` bigint(20) unsigned NOT NULL,
32 `category_id` bigint(20) unsigned NOT NULL,
33 KEY `resource_id_fk_3842264` (`resource_id`),
34 KEY `category_id_fk_3842264` (`category_id`),
35 CONSTRAINT `category_id_fk_3842264` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
36 CONSTRAINT `resource_id_fk_3842264` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE
37) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
38
39-- Data exporting was unselected.
40
41-- Dumping structure for table covid_data_analysis.cities
42CREATE TABLE IF NOT EXISTS `cities` (
43 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
44 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
45 `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
46 `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
47 `population` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
48 `state_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
49 `country_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
50 `created_at` timestamp NULL DEFAULT NULL,
51 `updated_at` timestamp NULL DEFAULT NULL,
52 `deleted_at` timestamp NULL DEFAULT NULL,
53 PRIMARY KEY (`id`)
54) ENGINE=InnoDB AUTO_INCREMENT=146070 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
55
56-- Data exporting was unselected.
57
58-- Dumping structure for table covid_data_analysis.city_state
59CREATE TABLE IF NOT EXISTS `city_state` (
60 `state_id` bigint(20) unsigned NOT NULL,
61 `city_id` bigint(20) unsigned NOT NULL,
62 KEY `state_id_fk_3831853` (`state_id`),
63 KEY `city_id_fk_3831853` (`city_id`),
64 CONSTRAINT `city_id_fk_3831853` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE,
65 CONSTRAINT `state_id_fk_3831853` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE
66) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
67
68-- Data exporting was unselected.
69
70-- Dumping structure for table covid_data_analysis.countries
71CREATE TABLE IF NOT EXISTS `countries` (
72 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
73 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
74 `capital` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
75 `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
76 `phone_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
77 `region` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
78 `subregion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
79 `created_at` timestamp NULL DEFAULT NULL,
80 `updated_at` timestamp NULL DEFAULT NULL,
81 `deleted_at` timestamp NULL DEFAULT NULL,
82 PRIMARY KEY (`id`),
83 UNIQUE KEY `countries_code_unique` (`code`)
84) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
85
86-- Data exporting was unselected.
87
88-- Dumping structure for table covid_data_analysis.country_state
89CREATE TABLE IF NOT EXISTS `country_state` (
90 `country_id` bigint(20) unsigned NOT NULL,
91 `state_id` bigint(20) unsigned NOT NULL,
92 KEY `country_id_fk_3831852` (`country_id`),
93 KEY `state_id_fk_3831852` (`state_id`),
94 CONSTRAINT `country_id_fk_3831852` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
95 CONSTRAINT `state_id_fk_3831852` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE
96) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
97
98-- Data exporting was unselected.
99
100-- Dumping structure for table covid_data_analysis.media
101CREATE TABLE IF NOT EXISTS `media` (
102 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
103 `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
104 `model_id` bigint(20) unsigned NOT NULL,
105 `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
106 `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
107 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
108 `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
109 `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
110 `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
111 `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
112 `size` bigint(20) unsigned NOT NULL,
113 `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
114 `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
115 `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
116 `order_column` int(10) unsigned DEFAULT NULL,
117 `created_at` timestamp NULL DEFAULT NULL,
118 `updated_at` timestamp NULL DEFAULT NULL,
119 PRIMARY KEY (`id`),
120 KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
121) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
122
123-- Data exporting was unselected.
124
125-- Dumping structure for table covid_data_analysis.migrations
126CREATE TABLE IF NOT EXISTS `migrations` (
127 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
128 `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
129 `batch` int(11) NOT NULL,
130 PRIMARY KEY (`id`)
131) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
132
133-- Data exporting was unselected.
134
135-- Dumping structure for table covid_data_analysis.new_reqs
136CREATE TABLE IF NOT EXISTS `new_reqs` (
137 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
138 `model` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
139 `data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
140 `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
141 `status` int(11) DEFAULT NULL,
142 `admin_message` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
143 `created_at` timestamp NULL DEFAULT NULL,
144 `updated_at` timestamp NULL DEFAULT NULL,
145 `deleted_at` timestamp NULL DEFAULT NULL,
146 `email_id` bigint(20) unsigned NOT NULL,
147 PRIMARY KEY (`id`),
148 KEY `email_fk_3915753` (`email_id`),
149 CONSTRAINT `email_fk_3915753` FOREIGN KEY (`email_id`) REFERENCES `users` (`id`)
150) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
151
152-- Data exporting was unselected.
153
154-- Dumping structure for table covid_data_analysis.oauth_access_tokens
155CREATE TABLE IF NOT EXISTS `oauth_access_tokens` (
156 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
157 `user_id` bigint(20) unsigned DEFAULT NULL,
158 `client_id` bigint(20) unsigned NOT NULL,
159 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
160 `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
161 `revoked` tinyint(1) NOT NULL,
162 `created_at` timestamp NULL DEFAULT NULL,
163 `updated_at` timestamp NULL DEFAULT NULL,
164 `expires_at` datetime DEFAULT NULL,
165 PRIMARY KEY (`id`),
166 KEY `oauth_access_tokens_user_id_index` (`user_id`)
167) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
168
169-- Data exporting was unselected.
170
171-- Dumping structure for table covid_data_analysis.oauth_auth_codes
172CREATE TABLE IF NOT EXISTS `oauth_auth_codes` (
173 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
174 `user_id` bigint(20) unsigned NOT NULL,
175 `client_id` bigint(20) unsigned NOT NULL,
176 `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
177 `revoked` tinyint(1) NOT NULL,
178 `expires_at` datetime DEFAULT NULL,
179 PRIMARY KEY (`id`),
180 KEY `oauth_auth_codes_user_id_index` (`user_id`)
181) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
182
183-- Data exporting was unselected.
184
185-- Dumping structure for table covid_data_analysis.oauth_clients
186CREATE TABLE IF NOT EXISTS `oauth_clients` (
187 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
188 `user_id` bigint(20) unsigned DEFAULT NULL,
189 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
190 `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
191 `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
192 `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
193 `personal_access_client` tinyint(1) NOT NULL,
194 `password_client` tinyint(1) NOT NULL,
195 `revoked` tinyint(1) NOT NULL,
196 `created_at` timestamp NULL DEFAULT NULL,
197 `updated_at` timestamp NULL DEFAULT NULL,
198 PRIMARY KEY (`id`),
199 KEY `oauth_clients_user_id_index` (`user_id`)
200) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
201
202-- Data exporting was unselected.
203
204-- Dumping structure for table covid_data_analysis.oauth_personal_access_clients
205CREATE TABLE IF NOT EXISTS `oauth_personal_access_clients` (
206 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
207 `client_id` bigint(20) unsigned NOT NULL,
208 `created_at` timestamp NULL DEFAULT NULL,
209 `updated_at` timestamp NULL DEFAULT NULL,
210 PRIMARY KEY (`id`)
211) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
212
213-- Data exporting was unselected.
214
215-- Dumping structure for table covid_data_analysis.oauth_refresh_tokens
216CREATE TABLE IF NOT EXISTS `oauth_refresh_tokens` (
217 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
218 `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
219 `revoked` tinyint(1) NOT NULL,
220 `expires_at` datetime DEFAULT NULL,
221 PRIMARY KEY (`id`),
222 KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
223) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
224
225-- Data exporting was unselected.
226
227-- Dumping structure for table covid_data_analysis.password_resets
228CREATE TABLE IF NOT EXISTS `password_resets` (
229 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
230 `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
231 `created_at` timestamp NULL DEFAULT NULL,
232 KEY `password_resets_email_index` (`email`)
233) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
234
235-- Data exporting was unselected.
236
237-- Dumping structure for table covid_data_analysis.permissions
238CREATE TABLE IF NOT EXISTS `permissions` (
239 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
240 `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
241 `created_at` timestamp NULL DEFAULT NULL,
242 `updated_at` timestamp NULL DEFAULT NULL,
243 `deleted_at` timestamp NULL DEFAULT NULL,
244 PRIMARY KEY (`id`)
245) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
246
247-- Data exporting was unselected.
248
249-- Dumping structure for table covid_data_analysis.permission_role
250CREATE TABLE IF NOT EXISTS `permission_role` (
251 `role_id` bigint(20) unsigned NOT NULL,
252 `permission_id` bigint(20) unsigned NOT NULL,
253 KEY `role_id_fk_3767138` (`role_id`),
254 KEY `permission_id_fk_3767138` (`permission_id`),
255 CONSTRAINT `permission_id_fk_3767138` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
256 CONSTRAINT `role_id_fk_3767138` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
257) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
258
259-- Data exporting was unselected.
260
261-- Dumping structure for table covid_data_analysis.personal_access_tokens
262CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
263 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
264 `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
265 `tokenable_id` bigint(20) unsigned NOT NULL,
266 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
267 `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
268 `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
269 `last_used_at` timestamp NULL DEFAULT NULL,
270 `created_at` timestamp NULL DEFAULT NULL,
271 `updated_at` timestamp NULL DEFAULT NULL,
272 PRIMARY KEY (`id`),
273 UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
274 KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
275) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
276
277-- Data exporting was unselected.
278
279-- Dumping structure for table covid_data_analysis.resources
280CREATE TABLE IF NOT EXISTS `resources` (
281 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
282 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
283 `phone_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
284 `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
285 `address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
286 `details` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
287 `note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
288 `up_vote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
289 `down_vote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
290 `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
291 `created_at` timestamp NULL DEFAULT NULL,
292 `updated_at` timestamp NULL DEFAULT NULL,
293 `deleted_at` timestamp NULL DEFAULT NULL,
294 `city_id` bigint(20) unsigned NOT NULL,
295 `country_id` bigint(20) unsigned DEFAULT NULL,
296 `state_id` bigint(20) unsigned DEFAULT NULL,
297 PRIMARY KEY (`id`),
298 KEY `city_fk_3768866` (`city_id`),
299 KEY `country_fk_3775707` (`country_id`),
300 KEY `state_fk_3775708` (`state_id`),
301 CONSTRAINT `city_fk_3768866` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
302 CONSTRAINT `country_fk_3775707` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
303 CONSTRAINT `state_fk_3775708` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`)
304) ENGINE=InnoDB AUTO_INCREMENT=264 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
305
306-- Data exporting was unselected.
307
308-- Dumping structure for table covid_data_analysis.resource_sub_category
309CREATE TABLE IF NOT EXISTS `resource_sub_category` (
310 `resource_id` bigint(20) unsigned NOT NULL,
311 `sub_category_id` bigint(20) unsigned NOT NULL,
312 KEY `resource_id_fk_3890450` (`resource_id`),
313 KEY `sub_category_id_fk_3890450` (`sub_category_id`),
314 CONSTRAINT `resource_id_fk_3890450` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE,
315 CONSTRAINT `sub_category_id_fk_3890450` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE
316) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
317
318-- Data exporting was unselected.
319
320-- Dumping structure for table covid_data_analysis.roles
321CREATE TABLE IF NOT EXISTS `roles` (
322 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
323 `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
324 `created_at` timestamp NULL DEFAULT NULL,
325 `updated_at` timestamp NULL DEFAULT NULL,
326 `deleted_at` timestamp NULL DEFAULT NULL,
327 PRIMARY KEY (`id`)
328) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
329
330-- Data exporting was unselected.
331
332-- Dumping structure for table covid_data_analysis.role_user
333CREATE TABLE IF NOT EXISTS `role_user` (
334 `user_id` bigint(20) unsigned NOT NULL,
335 `role_id` bigint(20) unsigned NOT NULL,
336 KEY `user_id_fk_3767147` (`user_id`),
337 KEY `role_id_fk_3767147` (`role_id`),
338 CONSTRAINT `role_id_fk_3767147` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
339 CONSTRAINT `user_id_fk_3767147` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
340) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
341
342-- Data exporting was unselected.
343
344-- Dumping structure for table covid_data_analysis.states
345CREATE TABLE IF NOT EXISTS `states` (
346 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
347 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
348 `country_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
349 `state_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
350 `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
351 `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
352 `created_at` timestamp NULL DEFAULT NULL,
353 `updated_at` timestamp NULL DEFAULT NULL,
354 `deleted_at` timestamp NULL DEFAULT NULL,
355 PRIMARY KEY (`id`)
356) ENGINE=InnoDB AUTO_INCREMENT=4868 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
357
358-- Data exporting was unselected.
359
360-- Dumping structure for table covid_data_analysis.sub_categories
361CREATE TABLE IF NOT EXISTS `sub_categories` (
362 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
363 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
364 `extra` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
365 `created_at` timestamp NULL DEFAULT NULL,
366 `updated_at` timestamp NULL DEFAULT NULL,
367 `category_id` bigint(20) unsigned DEFAULT NULL,
368 PRIMARY KEY (`id`),
369 KEY `category_fk_3885046` (`category_id`),
370 CONSTRAINT `category_fk_3885046` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
371) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
372
373-- Data exporting was unselected.
374
375-- Dumping structure for table covid_data_analysis.users
376CREATE TABLE IF NOT EXISTS `users` (
377 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
378 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
379 `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
380 `email_verified_at` datetime DEFAULT NULL,
381 `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
382 `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
383 `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
384 `provider_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
385 `two_factor` tinyint(1) DEFAULT 0,
386 `two_factor_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
387 `two_factor_expires_at` datetime DEFAULT NULL,
388 `created_at` timestamp NULL DEFAULT NULL,
389 `updated_at` timestamp NULL DEFAULT NULL,
390 `deleted_at` timestamp NULL DEFAULT NULL,
391 PRIMARY KEY (`id`),
392 UNIQUE KEY `users_email_unique` (`email`)
393) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
394
395-- Data exporting was unselected.
396
397/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
398/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
399/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;