-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `poolmate_admin_database`
--

-- --------------------------------------------------------

--
-- Table structure for table `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`
--

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 `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 `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');
COMMIT;

