6ZNAUPmz

1create database if not exists `worktern`;
2
3CREATE TABLE `users` (
4  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
5  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
6  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
7  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
8  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
9  `email_verified_at` timestamp NULL DEFAULT NULL,
10  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
11  `account_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
12  `bio` text COLLATE utf8mb4_unicode_ci,
13  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
14  `no_of_employees` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15  `department_in_company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
16  `email_verification_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
17  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
18  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
19  `created_at` timestamp NULL DEFAULT NULL,
20  `updated_at` timestamp NULL DEFAULT NULL,
21  PRIMARY KEY (`id`),
22  UNIQUE KEY `users_email_unique` (`email`)
23) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
24
25
26CREATE TABLE `password_resets` (
27  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
28  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
29  `created_at` timestamp NULL DEFAULT NULL,
30  KEY `password_resets_email_index` (`email`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;