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

START TRANSACTION;



--
-- Database: `indianpressnetwo_indian`
--

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint 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 UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_11_28_090759_create_superadmins_table', 1),
(6, '2026_05_08_071021_add_column_to_superadmins_table', 2),
(7, '2026_05_08_072540_create_websitesettings_table', 3),
(8, '2026_05_08_092958_create_tbl_activities_table', 4),
(9, '2026_05_08_093440_create_tbl_logs_table', 5),
(10, '2026_05_08_094943_create_tbl_crud_features_table', 6),
(11, '2026_05_08_095005_create_tbl_permissions_table', 6),
(12, '2026_05_08_101036_create_roles_table', 7);

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `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 `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint 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,
  `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;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `strtotime` 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;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `role`, `user_id`, `status`, `ip`, `strtotime`, `created_at`, `updated_at`) VALUES
(1, 'Superadmin', NULL, '1', NULL, NULL, NULL, NULL),
(2, 'Admin', NULL, '1', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `superadmins`
--

CREATE TABLE `superadmins` (
  `id` bigint UNSIGNED NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exptime` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verift_status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `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 `superadmins`
--

INSERT INTO `superadmins` (`id`, `username`, `firstname`, `lastname`, `mobile`, `email`, `image`, `password`, `token`, `otp`, `exptime`, `role`, `ip`, `verift_status`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Hyper', 'Mahesh', 'Kumawat', '9079282750', 'admin@gmail.com', NULL, '$2y$12$VjYD/G9vXIoGJWjhMAQAJOIBt0WvmnzsVgSJOiEQK45kl.is5vsVu', 'hfcf0b90bb8a9212846b13cea0e3f646', '123456', NULL, '1', NULL, '1', '1', NULL, '2026-05-08 05:59:04');

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

--
-- Table structure for table `tbl_activities`
--

CREATE TABLE `tbl_activities` (
  `id` bigint UNSIGNED NOT NULL,
  `activity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `strtotime` 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;

--
-- Dumping data for table `tbl_activities`
--

INSERT INTO `tbl_activities` (`id`, `activity`, `status`, `ip`, `strtotime`, `created_at`, `updated_at`) VALUES
(1, 'Add\r\n', '1', NULL, NULL, NULL, NULL),
(2, 'View\r\n', '1', NULL, NULL, NULL, NULL),
(3, 'Update\r\n', '1', NULL, NULL, NULL, NULL),
(4, 'Delete\r\n', '1', NULL, NULL, NULL, NULL),
(5, 'Login\r\n', '1', NULL, NULL, NULL, NULL),
(6, 'Superadmin Password Change', '1', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `tbl_crud_features`
--

CREATE TABLE `tbl_crud_features` (
  `id` bigint UNSIGNED NOT NULL,
  `feature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `function_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `strtotime` 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;

--
-- Dumping data for table `tbl_crud_features`
--

INSERT INTO `tbl_crud_features` (`id`, `feature`, `table_name`, `status`, `user_id`, `function_url`, `ip`, `strtotime`, `created_at`, `updated_at`) VALUES
(1, 'Setting', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'Websitesetting', 'websitesettings', '1', NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'Role', 'roles', '1', NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'Admin User', 'superadmins', '1', NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `tbl_logs`
--

CREATE TABLE `tbl_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `activity_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `curd_functions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  `feature_id` int DEFAULT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `table_primary_id` int DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `before` text COLLATE utf8mb4_unicode_ci,
  `after` text COLLATE utf8mb4_unicode_ci,
  `web_url` longtext COLLATE utf8mb4_unicode_ci,
  `date_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `logs_from` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `read_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `notification` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `panel_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `strtotime` 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;

--
-- Dumping data for table `tbl_logs`
--

INSERT INTO `tbl_logs` (`id`, `activity_id`, `curd_functions`, `user_id`, `role_id`, `feature_id`, `table_name`, `table_primary_id`, `description`, `before`, `after`, `web_url`, `date_time`, `status`, `logs_from`, `read_status`, `notification`, `created_by`, `panel_id`, `ip`, `strtotime`, `created_at`, `updated_at`) VALUES
(1, '5', 'Superadmin Login', 1, 1, 0, NULL, NULL, '', NULL, '{\"id\":1,\"username\":\"Hyper\",\"firstname\":\"Mahesh\",\"lastname\":\"Kumawat\",\"mobile\":\"9079282750\",\"email\":\"anjalikumawat960@gmail.com\",\"image\":null,\"password\":\"$2y$12$VjYD\\/G9vXIoGJWjhMAQAJOIBt0WvmnzsVgSJOiEQK45kl.is5vsVu\",\"token\":\"q7ce413eb8ed8cd81cb8170075c47053\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"1\",\"ip\":null,\"verift_status\":\"1\",\"status\":\"1\",\"created_at\":null,\"updated_at\":\"2026-05-08T09:57:08.000000Z\"}', 'https://indianpressnetwork.com/superadmin/login_process', '2026-05-08 15:33:47', '1', '0', '0', '0', NULL, '1', '223.181.43.192', '1778254427', '2026-05-08 10:03:47', '2026-05-08 10:03:47'),
(2, '5', 'Superadmin Login', 1, 1, 0, NULL, NULL, '', NULL, '{\"id\":1,\"username\":\"Hyper\",\"firstname\":\"Mahesh\",\"lastname\":\"Kumawat\",\"mobile\":\"9079282750\",\"email\":\"anjalikumawat960@gmail.com\",\"image\":null,\"password\":\"$2y$12$VjYD\\/G9vXIoGJWjhMAQAJOIBt0WvmnzsVgSJOiEQK45kl.is5vsVu\",\"token\":\"b050ac68aa9446c2bcfee47b869fba2b\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"1\",\"ip\":null,\"verift_status\":\"1\",\"status\":\"1\",\"created_at\":null,\"updated_at\":\"2026-05-08T10:03:53.000000Z\"}', 'https://indianpressnetwork.com/superadmin/login_process', '2026-05-08 16:11:31', '1', '0', '0', '0', NULL, '1', '223.181.43.192', '1778256691', '2026-05-08 10:41:31', '2026-05-08 10:41:31'),
(3, '2', 'Role View', 1, 1, 3, 'roles', NULL, '', '', '', 'https://indianpressnetwork.com/superadmin/role', '2026-05-08 16:47:35', '1', '0', '1', '0', '1', '1', '223.181.43.192', '1778258855', '2026-05-08 11:17:35', '2026-05-08 11:17:35'),
(4, '5', 'Superadmin Login', 2, 2, 0, NULL, NULL, '', NULL, '{\"id\":2,\"username\":\"AnjaliKumawat\",\"firstname\":\"Anjali\",\"lastname\":\"Kumawat\",\"mobile\":\"9024936553\",\"email\":\"kumawatkittu663@gmail.com\",\"image\":\"1778237264image.jpg\",\"password\":\"$2y$12$XN1jbvi8lnAUiok2gbquNeWYO0eBX2cjnXg\\/d.l6DeApSPweKXe2.\",\"token\":\"fee08c9c276735d7cb4bab9a1ac5b7c6\",\"otp\":null,\"exptime\":null,\"role\":\"2\",\"ip\":\"223.181.43.192\",\"verift_status\":\"0\",\"status\":\"1\",\"created_at\":\"2026-05-08T10:47:44.000000Z\",\"updated_at\":\"2026-05-08T11:00:41.000000Z\"}', 'https://indianpressnetwork.com/superadmin/login_process', '2026-05-08 16:48:15', '1', '0', '0', '0', NULL, '1', '223.181.43.192', '1778258895', '2026-05-08 11:18:15', '2026-05-08 11:18:15'),
(5, '5', 'Superadmin Login', 2, 2, 0, NULL, NULL, '', NULL, '{\"id\":2,\"username\":\"AnjaliKumawat\",\"firstname\":\"Anjali\",\"lastname\":\"Kumawat\",\"mobile\":\"9024936553\",\"email\":\"kumawatkittu663@gmail.com\",\"image\":\"1778237264image.jpg\",\"password\":\"$2y$12$XN1jbvi8lnAUiok2gbquNeWYO0eBX2cjnXg\\/d.l6DeApSPweKXe2.\",\"token\":\"Mafb5815482949f67551d0fd9c618dce\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"2\",\"ip\":\"223.181.43.192\",\"verift_status\":\"0\",\"status\":\"1\",\"created_at\":\"2026-05-08T10:47:44.000000Z\",\"updated_at\":\"2026-05-08T11:00:41.000000Z\"}', 'https://indianpressnetwork.com/superadmin/login_process', '2026-05-08 16:48:15', '1', '0', '0', '0', NULL, '1', '223.181.43.192', '1778258895', '2026-05-08 11:18:15', '2026-05-08 11:18:15'),
(6, '3', 'Admin User Update', 1, 1, 4, 'superadmins', 2, '', '{\"id\":2,\"username\":\"AnjaliKumawat\",\"firstname\":\"Anjali\",\"lastname\":\"Kumawat\",\"mobile\":\"9024936553\",\"email\":\"kumawatkittu663@gmail.com\",\"image\":\"1778237264image.jpg\",\"password\":\"$2y$12$XN1jbvi8lnAUiok2gbquNeWYO0eBX2cjnXg\\/d.l6DeApSPweKXe2.\",\"token\":\"Qa089a6d8f6a2bd03a8529b4be51521f\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"2\",\"ip\":\"223.181.43.192\",\"verift_status\":\"1\",\"status\":\"1\",\"created_at\":\"2026-05-08T10:47:44.000000Z\",\"updated_at\":\"2026-05-08T11:18:19.000000Z\"}', '{\"id\":2,\"username\":\"AnjaliKumawat\",\"firstname\":\"Anjali\",\"lastname\":\"Kumawat\",\"mobile\":\"9024936553\",\"email\":\"kumawatkittu663@gmail.com\",\"image\":\"1778237264image.jpg\",\"password\":\"$2y$12$XN1jbvi8lnAUiok2gbquNeWYO0eBX2cjnXg\\/d.l6DeApSPweKXe2.\",\"token\":\"Qa089a6d8f6a2bd03a8529b4be51521f\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"2\",\"ip\":\"223.181.43.192\",\"verift_status\":\"1\",\"status\":\"1\",\"created_at\":\"2026-05-08T10:47:44.000000Z\",\"updated_at\":\"2026-05-08T11:18:19.000000Z\"}', 'https://indianpressnetwork.com/superadmin/adminuserupdate/eyJpdiI6Ing0RlhMc2VRNkN3T2VhVlE5NnZ3QVE9PSIsInZhbHVlIjoiaTYwQVBHbmlZOExJNndiWEtXYjZRUT09IiwibWFjIjoiOTU0MjY0NDA0MGE3MzMxNzcxNzkyNGFiZGM0NGY4N2MzZTBlYjEzMzY3Y2MyZjRlYzJiNzdjNTc2MTE4OTkxZSIsInRhZyI6IiJ9', '2026-05-08 16:48:54', '1', '0', '1', '0', '1', '1', '223.181.43.192', '1778258934', '2026-05-08 11:18:54', '2026-05-08 11:18:54'),
(7, '2', 'Role View', 2, 2, 3, 'roles', NULL, '', '', '', 'https://indianpressnetwork.com/superadmin/role', '2026-05-08 16:49:21', '1', '0', '0', '0', '2', '1', '223.181.43.192', '1778258961', '2026-05-08 11:19:21', '2026-05-08 11:19:21'),
(8, '2', 'Permission Denied', 2, 2, NULL, NULL, NULL, '', '', '', 'https://indianpressnetwork.com/superadmin/permission_denied', '2026-05-08 16:51:30', '1', '0', '0', '0', '2', '1', '223.181.43.192', '1778259090', '2026-05-08 11:21:30', '2026-05-08 11:21:30'),
(9, '3', 'Admin User Update', 1, 1, 4, 'superadmins', 2, '', '{\"id\":2,\"username\":\"AnjaliKumawat\",\"firstname\":\"Anjali\",\"lastname\":\"Kumawat\",\"mobile\":\"9024936553\",\"email\":\"kumawatkittu663@gmail.com\",\"image\":\"1778237264image.jpg\",\"password\":\"$2y$12$XN1jbvi8lnAUiok2gbquNeWYO0eBX2cjnXg\\/d.l6DeApSPweKXe2.\",\"token\":\"Qa089a6d8f6a2bd03a8529b4be51521f\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"2\",\"ip\":\"223.181.43.192\",\"verift_status\":\"1\",\"status\":\"1\",\"created_at\":\"2026-05-08T10:47:44.000000Z\",\"updated_at\":\"2026-05-08T11:18:19.000000Z\"}', '{\"id\":2,\"username\":\"AnjaliKumawat\",\"firstname\":\"Anjali\",\"lastname\":\"Kumawat\",\"mobile\":\"9024936553\",\"email\":\"kumawatkittu663@gmail.com\",\"image\":\"1778237264image.jpg\",\"password\":\"$2y$12$XN1jbvi8lnAUiok2gbquNeWYO0eBX2cjnXg\\/d.l6DeApSPweKXe2.\",\"token\":\"Qa089a6d8f6a2bd03a8529b4be51521f\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"2\",\"ip\":\"223.181.43.192\",\"verift_status\":\"1\",\"status\":\"1\",\"created_at\":\"2026-05-08T10:47:44.000000Z\",\"updated_at\":\"2026-05-08T11:18:19.000000Z\"}', 'https://indianpressnetwork.com/superadmin/adminuserupdate/eyJpdiI6Ii9zRTdVMko5NnZ1MjV1L0ZMbXlFVmc9PSIsInZhbHVlIjoiNGMvbzhKTHcvb1c4djdmUkRGUVVkZz09IiwibWFjIjoiZDBmYmI1YTE1YWVlY2U3MGM0ZWUzYmYzZWEwZmIwZjRmYjBkMmEzNjdmNDk0NGNmNTJmNjEwYmUxOGQyYTMzNSIsInRhZyI6IiJ9', '2026-05-08 16:52:31', '1', '0', '1', '0', '1', '1', '223.181.43.192', '1778259151', '2026-05-08 11:22:31', '2026-05-08 11:22:31'),
(10, '5', 'Superadmin Login', 1, 1, 0, NULL, NULL, '', NULL, '{\"id\":1,\"username\":\"Hyper\",\"firstname\":\"Mahesh\",\"lastname\":\"Kumawat\",\"mobile\":\"9079282750\",\"email\":\"admin@gmail.com\",\"image\":null,\"password\":\"$2y$12$VjYD\\/G9vXIoGJWjhMAQAJOIBt0WvmnzsVgSJOiEQK45kl.is5vsVu\",\"token\":\"Ga4e57eb0c684c38c0e7858170312872\",\"otp\":\"123456\",\"exptime\":null,\"role\":\"1\",\"ip\":null,\"verift_status\":\"0\",\"status\":\"1\",\"created_at\":null,\"updated_at\":null}', 'https://indianpressnetwork.com/superadmin/login_process', '2026-05-08 16:58:57', '1', '0', '0', '0', NULL, '1', '223.181.43.192', '1778259537', '2026-05-08 11:28:57', '2026-05-08 11:28:57');

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

--
-- Table structure for table `tbl_permissions`
--

CREATE TABLE `tbl_permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feature_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_add` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_edit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_view` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_globle_view` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_delete` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `strtotime` 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;

--
-- Dumping data for table `tbl_permissions`
--

INSERT INTO `tbl_permissions` (`id`, `user_id`, `feature_id`, `action_add`, `action_edit`, `action_view`, `action_globle_view`, `action_delete`, `status`, `ip`, `strtotime`, `created_at`, `updated_at`) VALUES
(1, '2', '1', '0', '0', '0', '0', '0', '1', '223.181.43.192', '1778198400', '2026-05-08 05:17:44', '2026-05-08 05:17:44'),
(2, '2', '2', '0', '0', '0', '0', '0', '1', '223.181.43.192', '1778198400', '2026-05-08 05:17:44', '2026-05-08 05:17:44'),
(3, '2', '3', '0', '0', '0', '0', '0', '1', '223.181.43.192', '1778198400', '2026-05-08 05:17:44', '2026-05-08 05:17:44'),
(4, '2', '4', '0', '0', '1', '1', '0', '1', '223.181.43.192', '1778198400', '2026-05-08 05:17:44', '2026-05-08 05:52:31');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `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,
  `remember_token` varchar(100) 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 `websitesettings`
--

CREATE TABLE `websitesettings` (
  `id` bigint UNSIGNED NOT NULL,
  `site_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fevicon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `header_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_otp_default_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_otp_default_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otp_defalut_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otp_defalutemail_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_with_opt_apply` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `web_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `facebook` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `copyright` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_keyword` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `video_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `map_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `adminloginattempt_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_otp_attempt_count` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `multipal_attempt_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `user_multipal_attempt_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `user_login_with_opt_apply` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_login_ip_attempt_count` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `allotted_countries` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otp_send_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1->Number,2->Email',
  `services` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home_services` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_services` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `captchasitekey` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `captchasecretkey` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `panel_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_popap_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_invoice_due_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `strtotime` varchar(255) CHARACTER SET utf8mb4 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;

--
-- Dumping data for table `websitesettings`
--

INSERT INTO `websitesettings` (`id`, `site_title`, `fevicon`, `header_logo`, `footer_logo`, `file_size`, `whatsapp`, `mobile_number`, `login_otp_default_number`, `login_otp_default_email`, `otp_defalut_status`, `otp_defalutemail_status`, `login_with_opt_apply`, `email`, `address`, `web_url`, `facebook`, `linkedin`, `instagram`, `twitter`, `youtube`, `footer_content`, `copyright`, `meta_title`, `meta_keyword`, `meta_description`, `video_link`, `map_link`, `adminloginattempt_time`, `admin_otp_attempt_count`, `multipal_attempt_status`, `user_multipal_attempt_status`, `user_login_with_opt_apply`, `admin_login_ip_attempt_count`, `allotted_countries`, `state`, `otp_send_type`, `services`, `home_services`, `sub_services`, `captchasitekey`, `captchasecretkey`, `status`, `panel_id`, `created_by`, `order_popap_status`, `order_invoice_due_date`, `title`, `ip`, `strtotime`, `created_at`, `updated_at`) VALUES
(1, 'local pintu', '1755063197fevicon.png', '1755074546header_logo.png', '1755074546footer_logo.png', '2', '70233 20977', '7023320977', '9079282750', 'maheshkumawat8275@gmail.com', '1', '1', '0', 'maheshkumawat8275@gmail.com', '1st Floor 11-12, Coral Tower, Narendra Nagar, Sodala, Jaipur, Rajasthan, 302019', 'https://localpintu.hyperofficial.in/', 'https://www.facebook.com/pintuattends', 'https://in.linkedin.com/', 'https://www.instagram.com/pintuattends/', 'https://x.com/pintuattends', 'https://www.youtube.com/@pintuattends', 'Welcome to the world of Local Pintu Repair Services. We know it\'s hard to call the best and most reliable technicians to fix your appliances when you have a problem, but with Local Pintu, you can get the largest repair service in Jaipur for 24/7 repair services.', 'Copyright © 2026 Your Company. All rights reserved.', 'Appliance repair Service - Local Pintu', 'Appliance repair service, Home Appliance repair Service in Jaipur, Best home appliance repair service, Home appliance repair service near me, All appliance repair service , kitchen appliance repair service,  Washing machine repair service, Air conditioning, kitchen chimney Service, Refrigerator repair services,  Microwave repair services, Electrical services, Home Cleaning Services, Painter Servicei in jaipur', 'Local Pintu is the fastest growing services provider company. we help appliance, home repairs, cleaning services. we provide three-month free service warranty.', 'https://uat.localpintu.com/backend/websitesetting', 'https://localpintu.hyperofficial.in/backend/settings/websitesetting', '50', '100', '1', '1', '1', '2', '101', '33', '2', '[\"4\",\"3\",\"2\",\"3\"]', '{\"3\":null,\"4\":\"13\"}', NULL, NULL, NULL, '1', '1', '1', '1', '4', 'local Pintu', '223.181.43.192', '1778138229', NULL, '2026-05-07 07:17:09');

--
-- 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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`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`);

--
-- Indexes for table `superadmins`
--
ALTER TABLE `superadmins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `superadmins_mobile_unique` (`mobile`),
  ADD UNIQUE KEY `superadmins_email_unique` (`email`);

--
-- Indexes for table `tbl_activities`
--
ALTER TABLE `tbl_activities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_crud_features`
--
ALTER TABLE `tbl_crud_features`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_logs`
--
ALTER TABLE `tbl_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_permissions`
--
ALTER TABLE `tbl_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `websitesettings`
--
ALTER TABLE `websitesettings`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `superadmins`
--
ALTER TABLE `superadmins`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_activities`
--
ALTER TABLE `tbl_activities`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_crud_features`
--
ALTER TABLE `tbl_crud_features`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_logs`
--
ALTER TABLE `tbl_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tbl_permissions`
--
ALTER TABLE `tbl_permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `websitesettings`
--
ALTER TABLE `websitesettings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

