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

START TRANSACTION;



--
-- Database: `goride_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', 1);


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

--
-- 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
(22, 1, 'god-eye', 'map', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(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'),
(38, 1, 'drivers', 'driver.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(39, 1, 'drivers', 'driver.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(40, 1, 'drivers', 'driver.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'),
(44, 1, 'deleted-documents', 'document.deleted', '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'),
(46, 1, 'reports', 'driver.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'),
(48, 1, 'reports', 'intercity.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'),
(50, 1, 'service', 'service.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(51, 1, 'service', 'service.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(52, 1, 'service', 'service.edit', '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'),
(55, 1, 'intercity_service', 'intercity.service.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(56, 1, 'intercity_service', 'intercity.service.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(57, 1, 'intercity_order', 'intercity.order.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(58, 1, 'intercity_order', 'intercity.order.view', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(59, 1, 'freight', 'freight.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(60, 1, 'freight', 'freight.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(61, 1, 'freight', 'freight.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(62, 1, 'airports', 'airports.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(63, 1, 'airports', 'airports.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(64, 1, 'airports', 'airports.edit', '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'),
(68, 1, 'driver-rules', 'rule.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(69, 1, 'driver-rules', 'rule.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(70, 1, 'driver-rules', 'rule.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(71, 1, 'deleted-driver-rules', 'rule.delete.list', '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'),
(75, 1, 'banners', 'banners.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(76, 1, 'banners', 'banners.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(77, 1, 'banners', 'banners.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(78, 1, 'deleted-banner', 'banner.delete.list', '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'),
(84, 1, 'sos', 'sos.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(85, 1, 'sos', 'sos.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'),
(89, 1, 'coupon', 'coupon.list', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(90, 1, 'coupon', 'coupon.create', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(91, 1, 'coupon', 'coupon.edit', '2023-12-04 10:37:46', '2023-12-04 10:37:46'),
(92, 1, 'deleted-coupon', 'coupon.delete.list', '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'),
(99, 1, 'deleted-language', 'language.delete.list', '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'),
(101, 1, 'drivers-wallet-transaction', 'driver.wallet.list', '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'),
(558, 1, 'drivers', 'driver.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'),
(559, 1, 'approve_drivers', 'approve.driver.list', '2023-12-06 13:26:13', '2023-12-06 13:26:13'),
(560, 1, 'approve_drivers', 'approve.driver.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'),
(561, 1, 'pending_drivers', 'pending.driver.list', '2023-12-06 13:26:13', '2023-12-06 13:26:13'),
(562, 1, 'pending_drivers', 'pending.driver.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'),
(564, 1, 'service', 'service.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'),
(565, 1, 'intercity_service', 'intercity.service.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'),
(566, 1, 'freight', 'freight.delete', '2023-12-06 13:26:13', '2023-12-06 13:26:13'),
(567, 1, 'airports', 'airports.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'),
(569, 1, 'driver-rules', 'rule.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'),
(571, 1, 'banners', 'banners.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'),
(573, 1, 'sos', 'sos.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'),
(575, 1, 'coupon', 'coupon.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'),
(730, 1, 'drivers-document', 'driver.document.list', '2023-12-07 06:42:52', '2023-12-07 06:42:52'),
(731, 1, 'drivers-document', 'driver.document.edit', '2023-12-07 06:43:23', '2023-12-07 06:43:23'),
(856, 1, 'zone', 'zone.list', '2024-04-30 08:00:33', '2024-04-30 08:00:33'),
(857, 1, 'zone', 'zone.create', '2024-04-30 08:00:33', '2024-04-30 08:00:33'),
(858, 1, 'zone', 'zone.edit', '2024-04-30 08:00:33', '2024-04-30 08:00:33'),
(859, 1, 'zone', 'zone.delete', '2024-04-30 08:00:33', '2024-04-30 08:00:33'),
(979, 1, 'intercity_order', 'intercity.order.delete', '2024-08-01 13:59:17', '2024-08-01 13:59:17'),
(980, 1, 'ride_order', 'order.delete', '2024-08-01 13:59:43', '2024-08-01 13:59:43');

-- --------------------------------------------------------
--
-- 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;

