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

START TRANSACTION;



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

--
-- Table structure for table `talhatechnology_broadcasts`
--

CREATE TABLE `talhatechnology_broadcasts` (
  `id` int(11) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `talhatechnology_broadcasts`
--

INSERT INTO `talhatechnology_broadcasts` (`id`, `message`, `created_at`) VALUES
(1, 'hi', '2026-04-14 13:28:30'),
(2, 'hi', '2026-04-14 13:28:39'),
(3, 'hi', '2026-04-14 13:33:11'),
(4, 'hi', '2026-04-14 13:41:44'),
(5, 'gfythfhytg', '2026-04-15 12:49:50'),
(6, 'hi', '2026-04-15 18:14:00'),
(7, 'hi\r\n000', '2026-04-15 18:15:10'),
(8, 'hiiiiiii', '2026-04-15 18:18:23'),
(9, 'hiii', '2026-04-15 18:19:30'),
(10, 'hi', '2026-04-15 18:23:10'),
(11, 'kkkk', '2026-04-15 18:26:02'),
(12, 'hi', '2026-04-15 18:30:06'),
(13, '????? ?????? ?????? ????? ???? \r\n?? ????? ????? ??? ??? ??? ?????? ???? ? https://t.me/bd_trading_group', '2026-04-15 18:48:13'),
(14, 'hi', '2026-04-15 18:51:40'),
(15, 'Hlw?', '2026-04-15 18:51:49'),
(16, 'Hi Botla', '2026-04-16 09:42:55'),
(17, 'Hi everyone kaj koro sovai', '2026-04-16 14:35:14'),
(18, 'hi', '2026-04-16 20:05:59');

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

--
-- Table structure for table `talhatechnology_users`
--

CREATE TABLE `talhatechnology_users` (
  `id` int(11) NOT NULL,
  `chat_id` bigint(20) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `balance` decimal(10,2) DEFAULT 0.00,
  `joined_channel` tinyint(1) DEFAULT 0,
  `referer_chat_id` bigint(20) DEFAULT NULL,
  `started_task_id` int(11) DEFAULT NULL,
  `withdraw_method` varchar(100) DEFAULT NULL,
  `withdraw_number` varchar(255) DEFAULT NULL,
  `language` varchar(10) DEFAULT NULL,
  `bot_step` varchar(100) DEFAULT NULL,
  `selected_category_id` int(11) DEFAULT NULL,
  `selected_product_id` int(11) DEFAULT NULL,
  `temp_amount` decimal(10,2) DEFAULT NULL,
  `is_banned` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `talhatechnology_users`
--

INSERT INTO `talhatechnology_users` (`id`, `chat_id`, `username`, `first_name`, `balance`, `joined_channel`, `referer_chat_id`, `started_task_id`, `withdraw_method`, `withdraw_number`, `language`, `bot_step`, `selected_category_id`, `selected_product_id`, `temp_amount`, `is_banned`, `created_at`, `updated_at`) VALUES
(1, 5518928976, 'Mindgamertalha', 'Abu Talha', 0.00, 1, NULL, NULL, NULL, NULL, 'en', NULL, NULL, NULL, 100.00, 0, '2026-05-22 22:23:17', '2026-05-22 22:33:05');

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

--
-- Table structure for table `talhatechnology_vpn_categories`
--

CREATE TABLE `talhatechnology_vpn_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(120) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `talhatechnology_vpn_categories`
--

INSERT INTO `talhatechnology_vpn_categories` (`id`, `name`, `status`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, '3 Days VPN', 'Active', 10, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(2, '7 Days VPN', 'Active', 20, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(3, '14 Days VPN', 'Active', 30, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(4, '1 Month VPN', 'Active', 40, '2026-05-22 19:03:53', '2026-05-22 19:03:53');

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

--
-- Table structure for table `talhatechnology_vpn_orders`
--

CREATE TABLE `talhatechnology_vpn_orders` (
  `id` int(11) NOT NULL,
  `order_code` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `chat_id` bigint(20) NOT NULL,
  `product_id` int(11) NOT NULL,
  `vpn_name` varchar(160) NOT NULL,
  `category_name` varchar(120) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `vpn_details_id` int(11) DEFAULT NULL,
  `delivery_details` longtext DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Pending',
  `completed_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `talhatechnology_vpn_products`
--

CREATE TABLE `talhatechnology_vpn_products` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(160) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `status` varchar(50) NOT NULL DEFAULT 'Active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `talhatechnology_vpn_products`
--

INSERT INTO `talhatechnology_vpn_products` (`id`, `category_id`, `name`, `price`, `status`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 2, 'Pia 7D', 50.00, 'Active', 90, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(2, 2, 'Bitdefender 7D', 50.00, 'Active', 80, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(3, 2, 'Turbo 7D', 50.00, 'Active', 70, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(4, 2, 'IP Vanish 7D', 50.00, 'Active', 60, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(5, 2, 'Hotspot Shield 7D', 50.00, 'Active', 50, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(6, 2, 'HMA 7D', 50.00, 'Active', 40, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(7, 2, 'Surfshark 7D', 50.00, 'Active', 30, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(8, 2, 'Express 7D', 50.00, 'Active', 20, '2026-05-22 19:03:53', '2026-05-22 19:03:53'),
(9, 2, 'Nord 7D', 50.00, 'Active', 10, '2026-05-22 19:03:53', '2026-05-22 19:03:53');

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

--
-- Table structure for table `talhatechnology_vpn_product_details`
--

CREATE TABLE `talhatechnology_vpn_product_details` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `details_json` longtext NOT NULL,
  `quantity_total` int(11) NOT NULL DEFAULT 1,
  `quantity_sold` int(11) NOT NULL DEFAULT 0,
  `status` varchar(50) NOT NULL DEFAULT 'Available',
  `order_id` int(11) DEFAULT NULL,
  `sold_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `talhatechnology_vpn_product_fields`
--

CREATE TABLE `talhatechnology_vpn_product_fields` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `field_name` varchar(120) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Indexes for table `talhatechnology_users`
--
ALTER TABLE `talhatechnology_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `chat_id` (`chat_id`);

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

--
-- Indexes for table `talhatechnology_vpn_orders`
--
ALTER TABLE `talhatechnology_vpn_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_code` (`order_code`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `talhatechnology_vpn_products`
--
ALTER TABLE `talhatechnology_vpn_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `talhatechnology_vpn_product_details`
--
ALTER TABLE `talhatechnology_vpn_product_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `talhatechnology_vpn_product_fields`
--
ALTER TABLE `talhatechnology_vpn_product_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- AUTO_INCREMENT for table `talhatechnology_broadcasts`
--
ALTER TABLE `talhatechnology_broadcasts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `talhatechnology_users`
--
ALTER TABLE `talhatechnology_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `talhatechnology_vpn_categories`
--
ALTER TABLE `talhatechnology_vpn_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `talhatechnology_vpn_orders`
--
ALTER TABLE `talhatechnology_vpn_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `talhatechnology_vpn_products`
--
ALTER TABLE `talhatechnology_vpn_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `talhatechnology_vpn_product_details`
--
ALTER TABLE `talhatechnology_vpn_product_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `talhatechnology_vpn_product_fields`
--
ALTER TABLE `talhatechnology_vpn_product_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

