-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 30, 2024 at 02:01 PM -- Server version: 10.6.19-MariaDB-ubu2004 -- PHP Version: 8.3.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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: `mimeld_mxzoom` -- -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `media` -- CREATE TABLE `media` ( `id` bigint(20) UNSIGNED NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) UNSIGNED NOT NULL, `uuid` char(36) DEFAULT NULL, `collection_name` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `file_name` varchar(255) NOT NULL, `mime_type` varchar(255) DEFAULT NULL, `disk` varchar(255) NOT NULL, `conversions_disk` varchar(255) DEFAULT NULL, `size` bigint(20) UNSIGNED NOT NULL, `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)), `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)), `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)), `order_column` int(10) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`generated_conversions`)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `media` -- INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `responsive_images`, `order_column`, `created_at`, `updated_at`, `generated_conversions`) VALUES (2, 'App\\Models\\Meeting', 11, '3cbfffc7-4ba1-4f58-b199-5ea35e887b22', 'default', 'qvaZLGxgNmp5kXJvHGqt95L2oeNez4-metaYmFubmVyMS5qcGc=-', 'qvaZLGxgNmp5kXJvHGqt95L2oeNez4-metaYmFubmVyMS5qcGc=-.jpg', 'image/jpeg', 'public', 'public', 432494, '[]', '[]', '[]', 1, '2024-07-17 02:03:46', '2024-07-17 02:03:46', '[]'), (3, 'App\\Models\\Meeting', 15, 'd86fa947-f1e3-4359-88c6-e593f6d6452d', 'default', 'jX4BqYHNfGGn4Rho3t0aZ83J5LHpri-metabG9nbyAoMykucG5n-', 'jX4BqYHNfGGn4Rho3t0aZ83J5LHpri-metabG9nbyAoMykucG5n-.png', 'image/png', 'public', 'public', 8152, '[]', '[]', '[]', 1, '2024-07-17 10:46:29', '2024-07-17 10:46:29', '[]'), (5, 'App\\Models\\Meeting', 16, '9bef9289-3278-44ae-8936-e3d0814c59a7', 'default', 'x6Ugh0iy0NA6c643O43wEjoOjedajV-metaNjM4NTA2MTU1MDk2ODk3ODg2S2NXYk5GLmpwZw==-', 'x6Ugh0iy0NA6c643O43wEjoOjedajV-metaNjM4NTA2MTU1MDk2ODk3ODg2S2NXYk5GLmpwZw==-.jpg', 'image/jpeg', 'public', 'public', 94604, '[]', '[]', '[]', 1, '2024-09-30 07:03:12', '2024-09-30 07:03:12', '[]'), (6, 'App\\Models\\Meeting', 18, 'a370dd39-6daa-4644-abd1-e98a293a9c22', 'default', '9OREgVLP1HCsKjpSMrC81phAAzkWsH-metaVmFzdHUtc2hhc2h0cmExLS5qcGc=-', '9OREgVLP1HCsKjpSMrC81phAAzkWsH-metaVmFzdHUtc2hhc2h0cmExLS5qcGc=-.jpg', 'image/jpeg', 'public', 'public', 146951, '[]', '[]', '[]', 1, '2024-09-30 07:06:28', '2024-09-30 07:06:28', '[]'); -- -------------------------------------------------------- -- -- Table structure for table `meetings` -- CREATE TABLE `meetings` ( `id` bigint(20) UNSIGNED NOT NULL, `meeting_id` varchar(255) NOT NULL, `meeting_title` varchar(255) NOT NULL DEFAULT 'Untitled', `public` tinyint(1) NOT NULL DEFAULT 0, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `formatted_date` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `meetings` -- INSERT INTO `meetings` (`id`, `meeting_id`, `meeting_title`, `public`, `user_id`, `created_at`, `updated_at`, `formatted_date`) VALUES (1, 'knkk3kk4nksd', 'First Meeting', 0, 1, '2020-12-29 11:17:31', '2020-12-29 11:17:31', NULL), (2, 'sdkn2kn4', 'sECOND Meeting', 0, 1, '2020-12-29 11:17:42', '2020-12-29 11:17:42', NULL), (3, 'helloWORLD', 'Pharmacy Busniess', 0, 1, '2021-09-19 13:10:40', '2021-09-19 13:10:40', NULL), (4, 'BannerProb', 'Banner Issues', 1, 2, '2021-09-19 13:12:47', '2021-09-19 13:13:15', NULL), (7, 'YvmSJknjyy', 'Untitled', 1, NULL, '2024-07-17 01:33:10', '2024-07-17 01:33:10', NULL), (8, 'testing', 'TEstX', 0, 1, '2024-07-17 01:34:27', '2024-07-17 01:37:09', NULL), (11, '101010', 'scrum call', 0, 1, '2024-07-17 02:02:49', '2024-07-17 02:02:49', NULL), (12, 'mxzoomx345216', 'reviewing page', 1, 3, '2024-07-17 03:29:24', '2024-07-17 03:29:24', NULL), (13, 'mxzoomxCdJyazwhmw', 'meeting ', 0, 3, '2024-07-17 03:41:59', '2024-09-02 05:32:10', NULL), (14, '1234565', 'democall', 1, NULL, '2024-07-17 10:27:09', '2024-07-17 10:27:09', NULL), (15, '000000', 'scrum call 17/07/24', 1, 1, '2024-07-17 10:46:29', '2024-07-17 10:46:29', NULL), (16, 'mxzoomx123654789', 'Test', 1, 3, '2024-09-30 07:01:43', '2024-09-30 07:01:43', NULL), (17, '741852963', 'Test', 1, NULL, '2024-09-30 07:04:27', '2024-09-30 07:04:27', NULL), (18, 'mxzoomx121212', 'Test', 1, 1, '2024-09-30 07:06:28', '2024-09-30 07:06:28', NULL), (20, 'mxzoomx12365478955', 'Yash', 1, 1, '2024-09-30 07:25:47', '2024-09-30 07:25:47', NULL), (21, 'mxzoomx112233', 'meeting for lunch', 1, 3, '2024-09-30 07:58:14', '2024-09-30 07:58:14', NULL), (22, 'mxzoomx111111', 'takk', 1, 1, '2024-09-30 08:01:30', '2024-09-30 08:01:30', NULL), (23, 'QDYzrD8Ltm', '122', 1, NULL, '2024-09-30 08:44:35', '2024-09-30 08:44:35', NULL), (24, 'r6YzblQR1G', '1222', 1, NULL, '2024-09-30 08:50:48', '2024-09-30 08:50:48', NULL); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) 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, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2020_12_28_104248_create_media_table', 1), (6, '2020_12_28_112724_create_permission_tables', 1), (7, '2020_12_28_173525_create_meetings_table', 1), (8, '2021_01_02_094736_create_settings_table', 1), (9, '2024_07_17_043253_add_formatted_date_to_meetings_table', 2); -- -------------------------------------------------------- -- -- Table structure for table `model_has_permissions` -- CREATE TABLE `model_has_permissions` ( `permission_id` bigint(20) UNSIGNED NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `model_has_roles` -- CREATE TABLE `model_has_roles` ( `role_id` bigint(20) UNSIGNED NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `model_has_roles` -- INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES (1, 'App\\Models\\User', 1), (2, 'App\\Models\\User', 2), (2, 'App\\Models\\User', 3); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `guard_name` varchar(255) 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_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; -- -- Dumping data for table `personal_access_tokens` -- INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES (1, 'App\\Models\\User', 3, 'user', 'f162f37ba8ecfee4a848545624bb1c685c5762191824d42dd151292dcb77fea4', '[\"*\"]', '2024-07-17 03:41:59', NULL, '2024-07-17 03:41:47', '2024-07-17 03:41:59'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `guard_name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1, 'admin', 'web', '2020-12-28 11:57:58', '2020-12-28 11:57:58'), (2, 'subscriber', 'web', '2020-12-28 11:57:58', '2020-12-28 11:57:58'); -- -------------------------------------------------------- -- -- Table structure for table `role_has_permissions` -- CREATE TABLE `role_has_permissions` ( `permission_id` bigint(20) UNSIGNED NOT NULL, `role_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(10) UNSIGNED NOT NULL, `key` varchar(255) NOT NULL, `value` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `key`, `value`) VALUES (1, 'appVerisonCode', '10'), (2, 'appVerison', '2.6.00'), (3, 'websiteName', 'MXZoom'), (4, 'websiteColor', '#1c9dea'), (5, 'countryCode', 'INTERNATIONAL'), (6, 'websiteLogo', '/storage/logos/un37h2M5KPMX8zpsneCJ1I0p1NFsFSx5htrAt91c.png'), (7, 'favicon', '/storage/favicons/atwUQUfJL0IVNLRrdJ1fe0spRhmLNdnTVdgEfi9V.png'), (8, 'loginImage', '/storage/auth/login/ctPNWMxdAs8fg1K5MrX1CgiMQNtftn5xrwojTjtX.png'), (9, 'registerImage', 'https://mxzoomx.atharvatek.com/images/register.jpg'), (10, 'aiChatbot', '0'), (11, 'aiImageGenerator', '0'), (12, 'openAIKey', 'XXXXXXXXXXXX'), (13, 'mandatoryLogin', '0'), (14, 'unauthorizedMeeting', '1'), (15, 'meeting_prefix_id', 'mxzoomx'), (16, 'jitsi_meeting_domain', 'meet.jit.si'), (19, 'fcmServerKey', 'caa7cdc9e6e8d98b5f79c5f74c01dd1049e153719657b6e90d61457ead93226af92a78ba013f7c7a2ad41920490560cb381df253b65f50c39bc498a0'), (20, 'fcmSenderID', '212195725417'), (21, 'fcmAPIKey', 'AIzaSyC1JesV0oTPkwJiYD-r5Q7BUGGknu69SHI'), (22, 'serviceKeyPath', 'vault/firebase_service.json'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `phone`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Admin Account', 'admin@demo.com', NULL, NULL, '$2y$10$irGg8wGaP7nTSzLpHxcH9.fg4Gujnp6y0gSziQjf0ZwPDjGnoaco2', NULL, '2020-12-28 11:14:31', '2020-12-28 11:14:31', NULL), (2, 'Ambrose Temidayo Bako', 'bakoambrose@gmail.com', '+233557484181', NULL, '$2y$10$PXQZtHa6QTnz3LWYuAtBcuRTHquy5eZIOIKxLdTWBoZBc3RNYMijy', NULL, '2020-12-28 11:14:31', '2021-09-19 13:12:23', NULL), (3, 'user', 'user@demo.com', '+918987858486', NULL, '$2y$10$ZECZmK75Bbkg4siKKgPEs.tVOgM/6YKb2oEfOpTTod8FwJ6tHVNfq', NULL, '2024-07-16 05:05:43', '2024-07-16 05:05:43', NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `media` -- ALTER TABLE `media` ADD PRIMARY KEY (`id`), ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`); -- -- Indexes for table `meetings` -- ALTER TABLE `meetings` ADD PRIMARY KEY (`id`), ADD KEY `meetings_user_id_foreign` (`user_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`), ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`), ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`); -- -- 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`); -- -- Indexes for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `role_has_permissions_role_id_foreign` (`role_id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD KEY `settings_key_index` (`key`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `users_phone_unique` (`phone`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `media` -- ALTER TABLE `media` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `meetings` -- ALTER TABLE `meetings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- Constraints for dumped tables -- -- -- Constraints for table `meetings` -- ALTER TABLE `meetings` ADD CONSTRAINT `meetings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; COMMIT; /*!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 */;