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

START TRANSACTION;



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

--
-- Table structure for table `bandwidths`
--

CREATE TABLE `bandwidths` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `server` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `mb` 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 `bandwidths`
--

INSERT INTO `bandwidths` (`id`, `name`, `email`, `server`, `duration`, `mb`, `created_at`, `updated_at`) VALUES
(1, 'demo', 'demo@gmail.com', 'openvpn', '2', '2000', '2025-04-29 05:45:06', '2025-04-29 05:45:06');

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

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `sender_type` enum('user','admin') NOT NULL,
  `admin_read_view` tinyint(1) NOT NULL DEFAULT 0,
  `user_read_view` tinyint(1) NOT NULL DEFAULT 0,
  `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 `chats`
--

INSERT INTO `chats` (`id`, `user_id`, `admin_id`, `message`, `sender_type`, `admin_read_view`, `user_read_view`, `created_at`, `updated_at`) VALUES
(49, 66, 1, 'Hello', 'user', 1, 1, '2025-12-25 04:20:05', '2025-12-25 04:20:32'),
(50, 66, 1, 'I need help in purchase', 'user', 0, 1, '2025-12-25 04:24:11', '2025-12-25 04:24:11'),
(51, 66, 1, 'how can we help you sir?', 'admin', 1, 0, '2025-12-25 04:24:26', '2025-12-25 04:24:26'),
(52, 66, 1, 'How to purchase?', 'user', 0, 1, '2025-12-25 04:25:33', '2025-12-25 04:25:33'),
(53, 66, 1, 'tell us your username please', 'admin', 1, 0, '2025-12-25 04:25:57', '2025-12-25 04:25:57');

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

--
-- Table structure for table `epays`
--

CREATE TABLE `epays` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_no` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending',
  `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 `epays`
--

INSERT INTO `epays` (`id`, `order_no`, `name`, `amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 'ORD_68c19fda782b8', 'Kayem', 10.00, 'pending', '2025-09-10 09:57:14', '2025-09-10 09:57:14'),
(2, 'ORD_68c1a024e2c81', 'Kayem', 10.00, 'pending', '2025-09-10 09:58:28', '2025-09-10 09:58:28'),
(3, 'ORD_68c1a0523a270', 'Kayem', 10.00, 'pending', '2025-09-10 09:59:14', '2025-09-10 09:59:14'),
(4, 'ORD_68c1a157b8951', 'Kayem', 10.00, 'pending', '2025-09-10 10:03:35', '2025-09-10 10:03:35'),
(5, 'ORD_68c2e0161fc22', 'Kayem', 1.00, 'pending', '2025-09-11 08:43:34', '2025-09-11 08:43:34'),
(6, 'ORD_68c2e062bdfc7', 'Kayem', 1.00, 'pending', '2025-09-11 08:44:50', '2025-09-11 08:44:50'),
(7, 'ORD_68c2e1d28213f', 'Kayem', 1.00, 'pending', '2025-09-11 08:50:58', '2025-09-11 08:50:58'),
(8, 'ORD_68c2e347313a3', 'Admin', 1.00, 'pending', '2025-09-11 08:57:11', '2025-09-11 08:57:11'),
(9, 'ORD_68c2e7d5f2ce4', 'Admin', 1.00, 'pending', '2025-09-11 09:16:38', '2025-09-11 09:16:38'),
(10, 'ORD_68c2e8c87d04b', 'Admin', 1.00, 'pending', '2025-09-11 09:20:40', '2025-09-11 09:20:40'),
(11, 'ORD_68c2e947a7b74', 'Admin', 1.00, 'pending', '2025-09-11 09:22:47', '2025-09-11 09:22:47'),
(12, 'ORD_68c2e9b5a2e99', 'Admin', 1.00, 'pending', '2025-09-11 09:24:37', '2025-09-11 09:24:37'),
(13, 'ORD_68c2e9c5be2bf', 'Admin', 1.00, 'pending', '2025-09-11 09:24:53', '2025-09-11 09:24:53'),
(14, 'ORD_68c2eaf734c3d', 'Admin', 1.00, 'pending', '2025-09-11 09:29:59', '2025-09-11 09:29:59'),
(15, 'ORD_68c2ec3f5eee1', 'Admin', 1.00, 'pending', '2025-09-11 09:35:27', '2025-09-11 09:35:27'),
(16, 'ORD_68c2ece2579d7', 'Kayem', 1.00, 'pending', '2025-09-11 09:38:10', '2025-09-11 09:38:10'),
(17, 'ORD_68c2ecf0d5485', 'Kayem', 1.00, 'pending', '2025-09-11 09:38:24', '2025-09-11 09:38:24'),
(18, 'ORD_68c2ed06234f0', 'Kayem', 1.00, 'pending', '2025-09-11 09:38:46', '2025-09-11 09:38:46'),
(19, '2025091123550786690', 'Test', 1.00, 'pending', '2025-09-11 09:55:06', '2025-09-11 09:55:06'),
(20, 'ORD_68c2f30065df8', 'Test', 1.00, 'pending', '2025-09-11 10:04:16', '2025-09-11 10:04:16'),
(21, 'ORD_68c2f3e90d345', 'New User', 1.00, 'pending', '2025-09-11 10:08:09', '2025-09-11 10:08:09'),
(22, 'ORD_68c2f45e5f4b8', 'New User', 1.00, 'pending', '2025-09-11 10:10:06', '2025-09-11 10:10:06'),
(23, 'ORD_68c2f89b54d27', 'Kayem', 1.00, 'pending', '2025-09-11 10:28:11', '2025-09-11 10:28:11'),
(24, 'ORD_68c7dcc8cf37a', 'test', 1.00, 'pending', '2025-09-15 07:30:48', '2025-09-15 07:30:48'),
(25, 'ORD_68c7de6fd3948', 'test', 1.00, 'pending', '2025-09-15 07:37:51', '2025-09-15 07:37:51'),
(26, 'ORD_68c7e5584464d', 'test', 1.00, 'pending', '2025-09-15 08:07:20', '2025-09-15 08:07:20'),
(27, 'ORD_68c7e6e20cc51', 'test', 1.00, 'pending', '2025-09-15 08:13:54', '2025-09-15 08:13:54'),
(28, 'ORD_68c7e6f4f090a', 'test', 1.00, 'pending', '2025-09-15 08:14:12', '2025-09-15 08:14:12'),
(29, 'ORD_68c7e72d8ee28', 'test', 1.00, 'pending', '2025-09-15 08:15:09', '2025-09-15 08:15:09'),
(30, 'ORD_68c7e97e38595', 'test', 1.00, 'pending', '2025-09-15 08:25:02', '2025-09-15 08:25:02'),
(31, 'ORD_68c7eb356b4e2', 'test', 1.00, 'pending', '2025-09-15 08:32:21', '2025-09-15 08:32:21'),
(32, 'ORD_68c7f021a4845', 'test', 1.00, 'pending', '2025-09-15 08:53:21', '2025-09-15 08:53:21'),
(33, 'ORD_68c7f07459f12', 'test', 1.00, 'pending', '2025-09-15 08:54:44', '2025-09-15 08:54:44'),
(34, 'ORD_68c7f0a78a7cc', 'test', 1.00, 'pending', '2025-09-15 08:55:35', '2025-09-15 08:55:35'),
(35, 'ORD_68c8277fbf109', 'test', 1.00, 'pending', '2025-09-15 12:49:35', '2025-09-15 12:49:35'),
(36, 'ORD_68c82a8b33d1d', 'test', 1.00, 'pending', '2025-09-15 13:02:35', '2025-09-15 13:02:35'),
(37, 'ORD_68c82dbcad3e2', 'test', 1.00, 'pending', '2025-09-15 13:16:12', '2025-09-15 13:16:12'),
(38, 'ORD_68c830ba4d0c5', 'test100@gmail.com', 1.00, 'pending', '2025-09-15 13:28:58', '2025-09-15 13:28:58'),
(39, 'ORD_68c830e9523d7', 'test100@gmail.com', 1.00, 'pending', '2025-09-15 13:29:45', '2025-09-15 13:29:45'),
(40, 'ORD_68c8beb817080', 'VPN Payment', 1.00, 'pending', '2025-09-15 23:34:48', '2025-09-15 23:34:48'),
(41, 'ORD_68c8bf1024aaf', 'VPN Payment', 1.00, 'pending', '2025-09-15 23:36:16', '2025-09-15 23:36:16'),
(42, 'ORD_68c8bf45dc5ca', 'VPN Payment', 1.00, 'pending', '2025-09-15 23:37:09', '2025-09-15 23:37:09'),
(43, 'ORD_68c8c03dc79d3', 'VPN Payment', 1.00, 'pending', '2025-09-15 23:41:17', '2025-09-15 23:41:17'),
(44, 'ORD_68c8c059d706d', 'VPN Payment', 1.00, 'pending', '2025-09-15 23:41:45', '2025-09-15 23:41:45'),
(45, 'ORD_68c8c29403c47', 'VPN Payment', 1.00, 'pending', '2025-09-15 23:51:16', '2025-09-15 23:51:16'),
(46, 'ORD_68c8c5b592bdd', 'VPN Payment', 1.00, 'pending', '2025-09-16 00:04:37', '2025-09-16 00:04:37'),
(47, 'ORD_68c8c6c31fd27', 'VPN Payment', 50.00, 'pending', '2025-09-16 00:09:07', '2025-09-16 00:09:07'),
(48, 'ORD_68cbc5024f6f5', 'VPN Payment', 1.00, 'pending', '2025-09-18 06:38:26', '2025-09-18 06:38:26'),
(49, 'ORD_68cbc526c5afa', 'VPN Payment', 1.00, 'pending', '2025-09-18 06:39:02', '2025-09-18 06:39:02'),
(50, 'ORD_68cbd4802f7ff', 'VPN Payment', 1.00, 'pending', '2025-09-18 07:44:32', '2025-09-18 07:44:32'),
(51, 'ORD_68cbd4df863d1', 'VPN Payment', 1.00, 'pending', '2025-09-18 07:46:07', '2025-09-18 07:46:07'),
(52, 'ORD_68cbd4e6b7510', 'VPN Payment', 1.00, 'pending', '2025-09-18 07:46:14', '2025-09-18 07:46:14'),
(53, 'ORD_68cbd567b7b80', 'VPN Payment', 1.00, 'pending', '2025-09-18 07:48:23', '2025-09-18 07:48:23'),
(54, 'ORD_68d21e93d46a7', 'test', 1.00, 'pending', '2025-09-23 02:14:11', '2025-09-23 02:14:11'),
(55, 'ORD_68d21efbcde28', 'test', 1.00, 'pending', '2025-09-23 02:15:55', '2025-09-23 02:15:55'),
(56, 'ORD_68d22047ec4e2', 'VPN Payment', 1.00, 'pending', '2025-09-23 02:21:27', '2025-09-23 02:21:27'),
(57, 'ORD_68d2209ed394c', 'VPN Payment', 1.00, 'pending', '2025-09-23 02:22:54', '2025-09-23 02:22:54');

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

--
-- 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 `help_centers`
--

CREATE TABLE `help_centers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) NOT NULL,
  `answer` text 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 `help_centers`
--

INSERT INTO `help_centers` (`id`, `question`, `answer`, `created_at`, `updated_at`) VALUES
(3, 'What is VPN?', 'A VPN, or virtual private network, creates a secure and encrypted connection over the internet to protect your data and hide your online activity', '2025-11-04 04:57:21', '2025-11-11 14:30:43');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_11_04_075241_create_help_centers_table', 2),
(5, '2025_11_04_124237_create_chats_table', 3);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `pakage_name` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `validity` varchar(255) DEFAULT NULL,
  `expired_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` 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 `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `name`, `email`, `pakage_name`, `price`, `validity`, `expired_date`, `status`, `created_at`, `updated_at`) VALUES
(75, 66, 'test', 'test@gmail.com', '30 days', '30', '30', '2026-01-23 08:18:46', 'success', '2025-12-24 01:58:49', '2025-12-24 08:18:46');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('WorvuR7DTCemfZIiYO9clPFC2nV3nro19zz950ix', NULL, '103.92.154.146', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiNHMxRXFKMGl5TE9VMHVYaG5aRHlBS3oySk05dVZaRVl4d3JPdjNYUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly92cG4uY2hhZG5pY2hvay5jb20vYWRtaW4vZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czoxMDoic2hvcnRfbG9nbyI7czoxNzoiMTc2Mjg3NDk4MzQ3MS5wbmciO3M6ODoiYXBwX2xvZ28iO3M6MTc6IjE3NjI4NzQ5ODM5MDQucG5nIjtzOjUzOiJsb2dpbl9hZG1pbnNfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1766658387),
('XjjJsgfj5dfxhMj8wVRSxwuiuDKin2nZx7WnXgDK', NULL, '149.57.180.132', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSVdhNFhuZ0UybVpFY1psZWF2dFpJRU92cU1jMjZPQ1Z6WkN2U0trSiI7czoxMDoic2hvcnRfbG9nbyI7czoxNzoiMTc2Mjg3NDk4MzQ3MS5wbmciO3M6ODoiYXBwX2xvZ28iO3M6MTc6IjE3NjI4NzQ5ODM5MDQucG5nIjtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNjoiaHR0cHM6Ly92cG4uY2hhZG5pY2hvay5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1766657772);

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

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pakage_name` varchar(255) NOT NULL,
  `validity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `expired_date` 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 `subscription_plans`
--

INSERT INTO `subscription_plans` (`id`, `pakage_name`, `validity`, `price`, `start_date`, `expired_date`, `created_at`, `updated_at`) VALUES
(5, '365 Days Plan', 365, 50.00, '2025-09-16 00:01:29', '2026-09-16 00:01:29', '2025-09-08 22:08:05', '2025-09-16 00:01:29'),
(6, '180 Days Plan', 180, 2.00, '2025-09-15 07:34:40', '2026-03-14 08:34:40', '2025-09-09 09:55:25', '2025-09-15 07:34:40'),
(7, '30 Days Plan', 30, 1.00, '2025-09-19 23:10:15', '2025-10-19 23:10:15', '2025-09-09 09:56:09', '2025-09-19 23:10:15');

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

--
-- Table structure for table `v2rays`
--

CREATE TABLE `v2rays` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL,
  `active_count` int(11) DEFAULT 0,
  `link` longtext NOT NULL,
  `type` tinyint(1) NOT NULL,
  `status` tinyint(4) 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 `v2rays`
--

INSERT INTO `v2rays` (`id`, `name`, `country_code`, `city_name`, `active_count`, `link`, `type`, `status`, `created_at`, `updated_at`) VALUES
(5, 'Singapore Pro V2ray', 'sg', 'Jurong Town', 0, 'vless://6e3efb6e-4522-4d85-b358-fffd526c8268@46.250.226.102:59076?type=tcp&encryption=none&security=none#Singapore-iffwpwe1', 1, 1, '2025-06-02 16:46:33', '2025-12-24 08:18:10'),
(23, 'Singapore', 'sg', 'sg', 0, 'vless://6e3efb6e-4522-4d85-b358-fffd526c8268@46.250.226.102:59076?type=tcp&encryption=none&security=none#Singapore-iffwpwe1', 0, 1, '2025-12-24 07:12:03', '2025-12-25 02:00:57');

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

--
-- Indexes for table `chats`
--
ALTER TABLE `chats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chats_user_id_foreign` (`user_id`),
  ADD KEY `chats_admin_id_foreign` (`admin_id`);

--
-- Indexes for table `epays`
--
ALTER TABLE `epays`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `epays_order_no_unique` (`order_no`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `v2rays`
--
ALTER TABLE `v2rays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `active_count` (`active_count`);

--
-- AUTO_INCREMENT for table `bandwidths`
--
ALTER TABLE `bandwidths`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `chats`
--
ALTER TABLE `chats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `epays`
--
ALTER TABLE `epays`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

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

--
-- AUTO_INCREMENT for table `help_centers`
--
ALTER TABLE `help_centers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `subscription_plans`
--
ALTER TABLE `subscription_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `v2rays`
--
ALTER TABLE `v2rays`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `chats`
--
ALTER TABLE `chats`
  ADD CONSTRAINT `chats_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chats_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

