-- phpMyAdmin SQL Dump -- version 4.6.6deb5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Oct 26, 2020 at 08:22 PM -- Server version: 5.7.31-0ubuntu0.18.04.1 -- PHP Version: 7.4.11 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `dreamamerica_booking_system_dev` -- -- -------------------------------------------------------- -- -- Table structure for table `api_token` -- CREATE TABLE `api_token` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `client_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `client_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refresh_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `access_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` int(10) UNSIGNED DEFAULT NULL, `updated_by` int(10) UNSIGNED DEFAULT NULL, `source` int(10) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `attachmentable` -- CREATE TABLE `attachmentable` ( `id` int(10) UNSIGNED NOT NULL, `attachmentable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `attachmentable_id` int(10) UNSIGNED NOT NULL, `attachment_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `attachments` -- CREATE TABLE `attachments` ( `id` int(10) UNSIGNED NOT NULL, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, `original_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `mime` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `extension` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `size` bigint(20) NOT NULL DEFAULT '0', `sort` int(11) NOT NULL DEFAULT '0', `path` text COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `alt` text COLLATE utf8mb4_unicode_ci, `hash` text COLLATE utf8mb4_unicode_ci, `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public', `user_id` bigint(20) UNSIGNED DEFAULT NULL, `group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2020_10_22_085846_create_table_user_type', 1), (5, '2014_10_12_200000_add_two_factor_columns_to_users_table', 2), (6, '2019_12_14_000001_create_personal_access_tokens_table', 2), (7, '2020_10_22_120839_create_sessions_table', 2), (8, '2015_04_12_000000_create_orchid_users_table', 3), (9, '2015_10_19_214424_create_orchid_roles_table', 3), (10, '2015_10_19_214425_create_orchid_role_users_table', 3), (11, '2016_08_07_125128_create_orchid_attachmentstable_table', 3), (12, '2017_09_17_125801_create_notifications_table', 3), (13, '2020_05_21_100000_create_teams_table', 4), (14, '2020_05_21_200000_create_team_user_table', 4), (15, '2020_10_26_101339_create_api_token_table', 5); -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- CREATE TABLE `notifications` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_id` bigint(20) UNSIGNED NOT NULL, `data` text COLLATE utf8mb4_unicode_ci NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('admin@techloyce.com', '$2y$10$HC2IU8Qe18d0G0BpsoCRvOEr7B2bChzwrGetVcK/.7Cw/3KOVVxHG', '2020-10-22 08:06:29'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(10) UNSIGNED NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `permissions` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `role_users` -- CREATE TABLE `role_users` ( `user_id` bigint(20) UNSIGNED NOT NULL, `role_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` text COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('ujdm17SXA0uynPfpCICfCHBvRiu7X0WEV9Sa0wid', NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.83 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMjlXa2I3WjM5eXNWam4xN1RJdUh5UE43aXRuVFpvNW9EZFo5UzZmbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC90ZXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1603718593), ('Y4kktJ587fv3VqluXbrT541OCwgBO713bswuC6R1', 1, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.83 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiV1hHWWZnZGdORWlSdUpuMmt6djY0N3ZzN1o2YllORVFOU0M5THRDRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9pdGVtcy9vdXRzdGFuZGluZy9iZWZvcmVfZGQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTAkamR4VHNROHFvM281TGN5QkJEMzVSLmdvWHcyRGJpb3RGZ2l4ZW9kc0tXZTNVMGlWcVNneDYiO3M6MjE6InBhc3N3b3JkX2hhc2hfc2FuY3R1bSI7czo2MDoiJDJ5JDEwJGpkeFRzUThxbzNvNUxjeUJCRDM1Ui5nb1h3MkRiaW90RmdpeGVvZHNLV2UzVTBpVnFTZ3g2Ijt9', 1603700943); -- -------------------------------------------------------- -- -- Table structure for table `teams` -- CREATE TABLE `teams` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `personal_team` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `team_user` -- CREATE TABLE `team_user` ( `id` bigint(20) UNSIGNED NOT NULL, `team_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `two_factor_secret` text COLLATE utf8mb4_unicode_ci, `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci, `user_type_id` int(10) UNSIGNED NOT NULL, `created_by` int(10) UNSIGNED DEFAULT NULL, `updated_by` int(10) UNSIGNED DEFAULT NULL, `source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `permissions` json DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `uuid`, `name`, `first_name`, `last_name`, `email`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `user_type_id`, `created_by`, `updated_by`, `source`, `remember_token`, `created_at`, `updated_at`, `permissions`) VALUES (1, 'e39ef466-44c2-49fa-94af-7191383f18b1', 'Admin', 'Ali', 'Raza', 'admin@techloyce.com', NULL, '$2y$10$jdxTsQ8qo3o5LcyBBD35R.goXw2DbiotFgixeodsKWe3U0iVqSgx6', NULL, NULL, 1, 1, 1, 'seeder_class', 'NHDAz4QGurpDAmWfWiJkKVedHcA0W2FBaA9YvERUzZ4WSbkHN7DlYH6b1e3d', '2020-10-22 06:30:12', '2020-10-22 06:30:12', NULL), (2, 'ca94dd08-2917-4f17-bc5a-d8b91a7c27e9', 'Client', 'Ali', 'Raza', 'client@techloyce.com', NULL, '$2y$10$aP9qUZOMRnsiQCbZZXNN7.6jV900Keeip6pfG2PPi2C5Fbu7sOXda', NULL, NULL, 2, 1, 1, 'seeder_class', NULL, '2020-10-22 06:30:12', '2020-10-22 06:30:12', NULL); -- -------------------------------------------------------- -- -- Table structure for table `user_type` -- CREATE TABLE `user_type` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_by` int(10) UNSIGNED DEFAULT NULL, `updated_by` int(10) UNSIGNED DEFAULT NULL, `source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `api_token` -- ALTER TABLE `api_token` ADD PRIMARY KEY (`id`); -- -- Indexes for table `attachmentable` -- ALTER TABLE `attachmentable` ADD PRIMARY KEY (`id`), ADD KEY `attachmentable_attachmentable_type_attachmentable_id_index` (`attachmentable_type`,`attachmentable_id`), ADD KEY `attachmentable_attachment_id_foreign` (`attachment_id`); -- -- Indexes for table `attachments` -- ALTER TABLE `attachments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`), ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_slug_unique` (`slug`); -- -- Indexes for table `role_users` -- ALTER TABLE `role_users` ADD PRIMARY KEY (`user_id`,`role_id`), ADD KEY `role_users_role_id_foreign` (`role_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `teams` -- ALTER TABLE `teams` ADD PRIMARY KEY (`id`), ADD KEY `teams_user_id_index` (`user_id`); -- -- Indexes for table `team_user` -- ALTER TABLE `team_user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `team_user_team_id_user_id_unique` (`team_id`,`user_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_uuid_unique` (`uuid`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `user_type` -- ALTER TABLE `user_type` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_type_uuid_unique` (`uuid`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `api_token` -- ALTER TABLE `api_token` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `attachmentable` -- ALTER TABLE `attachmentable` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `attachments` -- ALTER TABLE `attachments` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `teams` -- ALTER TABLE `teams` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `team_user` -- ALTER TABLE `team_user` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `user_type` -- ALTER TABLE `user_type` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `attachmentable` -- ALTER TABLE `attachmentable` ADD CONSTRAINT `attachmentable_attachment_id_foreign` FOREIGN KEY (`attachment_id`) REFERENCES `attachments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `role_users` -- ALTER TABLE `role_users` ADD CONSTRAINT `role_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `role_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;