-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Aug 22, 2022 at 03:07 PM -- Server version: 5.7.36 -- PHP Version: 8.0.13 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: `poolmate_admin_database` -- -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; CREATE TABLE IF NOT EXISTS `migrations` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 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, '2023_10_23_054059_create_permission_tables', 2); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; CREATE TABLE IF NOT EXISTS `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; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; CREATE TABLE IF NOT EXISTS `permissions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `permission` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `routes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `permissions` (`id`, `role_id`, `permission`, `routes`, `created_at`, `updated_at`) VALUES (23, 1, 'roles', 'roles.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (24, 1, 'roles', 'roles.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (25, 1, 'roles', 'roles.store', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (26, 1, 'roles', 'roles.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (27, 1, 'roles', 'roles.update', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (28, 1, 'roles', 'roles.delete', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (29, 1, 'admins', 'admin.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (30, 1, 'admins', 'admin.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (31, 1, 'admins', 'admin.store', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (32, 1, 'admins', 'admin.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (33, 1, 'admins', 'admin.update', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (34, 1, 'admins', 'admin.delete', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (35, 1, 'users', 'user.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (36, 1, 'users', 'user.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (37, 1, 'users', 'user.view', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (41, 1, 'documents', 'document.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (42, 1, 'documents', 'document.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (43, 1, 'documents', 'document.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (45, 1, 'reports', 'user.report', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (47, 1, 'reports', 'ride.report', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (49, 1, 'reports', 'transaction.report', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (53, 1, 'ride_order', 'order.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (54, 1, 'ride_order', 'order.view', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (65, 1, 'vehicle-type', 'vehicle.type.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (66, 1, 'vehicle-type', 'vehicle.type.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (67, 1, 'vehicle-type', 'vehicle.type.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (72, 1, 'cms', 'cms.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (73, 1, 'cms', 'cms.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (74, 1, 'cms', 'cms.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (79, 1, 'on-board', 'onboard.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (80, 1, 'on-board', 'onboard.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (81, 1, 'faq', 'faq.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (82, 1, 'faq', 'faq.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (83, 1, 'faq', 'faq.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (86, 1, 'tax', 'tax.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (87, 1, 'tax', 'tax.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (88, 1, 'tax', 'tax.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (93, 1, 'currency', 'currency.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (94, 1, 'currency', 'currency.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (95, 1, 'currency', 'currency.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (96, 1, 'language', 'language.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (97, 1, 'language', 'language.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (98, 1, 'language', 'language.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (100, 1, 'payout-request', 'payout-request', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (102, 1, 'users-wallet-transaction', 'user.wallet.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (103, 1, 'global-setting', 'global-setting', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (104, 1, 'admin-commission', 'admin-commision', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (105, 1, 'payment-method', 'payment-method', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (106, 1, 'homepageTemplate', 'home-page', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (107, 1, 'header-template', 'header', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (108, 1, 'footer-template', 'footer', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (109, 1, 'privacy', 'privacy', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (110, 1, 'terms', 'terms', '2023-12-04 10:37:46', '2023-12-04 10:37:46'), (557, 1, 'users', 'user.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (563, 1, 'documents', 'document.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (568, 1, 'vehicle-type', 'vehicle.type.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (570, 1, 'cms', 'cms.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (572, 1, 'faq', 'faq.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (574, 1, 'tax', 'tax.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (576, 1, 'currency', 'currency.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (577, 1, 'language', 'language.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'), (860, 1, 'notification-setting', 'notification-setting', '2024-06-06 10:27:37', '2024-06-06 10:27:37'), (861, 1, 'vehicle-brand', 'vehicle.brand.list', '2024-06-06 10:28:06', '2024-06-06 10:28:06'), (862, 1, 'vehicle-brand', 'vehicle.brand.create', '2024-06-06 10:28:38', '2024-06-06 10:28:38'), (863, 1, 'vehicle-brand', 'vehicle.brand.edit', '2024-06-06 10:29:11', '2024-06-06 10:29:11'), (864, 1, 'vehicle-brand', 'vehicle.brand.delete', '2024-06-06 10:29:35', '2024-06-06 10:29:35'), (865, 1, 'vehicle-model', 'vehicle.model.list', '2024-06-06 10:29:59', '2024-06-06 10:29:59'), (866, 1, 'vehicle-model', 'vehicle.model.create', '2024-06-06 10:30:24', '2024-06-06 10:30:24'), (867, 1, 'vehicle-model', 'vehicle.model.edit', '2024-06-06 10:30:44', '2024-06-06 10:30:44'), (868, 1, 'vehicle-model', 'vehicle.model.delete', '2024-06-06 10:31:05', '2024-06-06 10:31:05'), (869, 1, 'approve_users', 'approve.user.list', '2024-06-18 06:22:42', '2024-06-18 06:22:42'), (870, 1, 'pending_users', 'pending.user.list', '2024-06-18 06:23:05', '2024-06-18 06:23:05'), (875, 1, 'complaint-subject', 'complaint.subject.list', '2024-06-24 06:19:43', '2024-06-24 06:19:43'), (876, 1, 'complaint-subject', 'complaint.subject.create', '2024-06-24 06:20:02', '2024-06-24 06:20:02'), (877, 1, 'complaint-subject', 'complaint.subject.edit', '2024-06-24 06:20:22', '2024-06-24 06:20:22'), (878, 1, 'dynamic-notification', 'dynamic.notification.list', '2024-06-24 06:20:43', '2024-06-24 06:20:43'), (879, 1, 'dynamic-notification', 'dynamic.notification.edit', '2024-06-24 06:21:03', '2024-06-24 06:21:03'), (880, 1, 'complaints', 'complaints.list', '2024-06-24 06:21:26', '2024-06-24 06:21:26'), (881, 1, 'user-ride-detail', 'user.ride.detail', '2024-06-24 06:21:45', '2024-06-24 06:21:45'), (882, 1, 'complaints', 'complaints.edit', '2024-06-24 12:30:41', '2024-06-24 12:30:41'), (883, 1, 'complaints', 'complaints.delete', '2024-06-24 12:31:02', '2024-06-24 12:31:02'), (884, 1, 'complaint-subject', 'complaint.subject.delete', '2024-06-24 12:33:47', '2024-06-24 12:33:47'), (885, 1, 'ride_order', 'order.delete', '2024-06-24 12:41:49', '2024-06-24 12:41:49'), (1203, 1, 'email-template', 'email.template.index', '2024-07-01 12:22:25', '2024-07-01 12:22:25'), (1204, 1, 'email-template', 'email.template.save', '2024-07-01 12:22:41', '2024-07-01 12:22:41'), (1206, 1, 'advertise-setting', 'advertise-setting', '2024-11-14 08:10:48', '2024-11-14 08:10:48'), (1207, 1, 'user-documents', 'user.document.list', '2024-11-20 05:54:09', '2024-11-20 05:54:09'), (1208, 1, 'user-documents', 'user.document.edit', '2024-11-20 05:54:09', '2024-11-20 05:54:09'), (1240, 1, 'supportHistory', 'supportHistory.list', '2025-07-07 13:02:18', '2025-07-07 13:02:18'), (1241, 1, 'users', 'users.chat', '2025-07-07 13:04:04', '2025-07-07 13:04:04'), (1244, 1, 'sos', 'sos.list', '2025-07-10 04:53:45', '2025-07-10 04:53:45'), (1245, 1, 'sos', 'sos.edit', '2025-07-10 04:54:15', '2025-07-10 04:54:15'), (1246, 1, 'sos', 'sos.delete', '2025-07-10 04:54:38', '2025-07-10 04:54:38'), (1340, 1, 'maintenance-setting', 'maintenance-setting', '2023-12-04 10:37:46', '2023-12-04 10:37:46'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; CREATE TABLE IF NOT EXISTS `roles` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `role_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `roles` (`id`, `role_name`, `created_at`, `updated_at`) VALUES (1, 'Super Administrator', '2023-11-27 05:10:43', '2023-11-27 06:36:20'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `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, `role_id` int(15) NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role_id`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Super Admin', 'admin@poolmate.com', NULL, '$2y$10$4D/Oi3x7gxPwZ/zxCKtgCOlPNujUnUER0vkMjQ0moL7l3cAJwTIJa', 1, 'zUMdz3RMe8UY6NMTsSscn1I12GDXcfJIDH4cjKjRmykMPkzKyoTkYkAdg2IO', '2022-02-26 12:22:29', '2022-03-02 08:48:06'); 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 */;