-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 23, 2026 at 11:58 PM -- Server version: 11.4.9-MariaDB -- PHP Version: 8.4.20 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `premiums_Premiumshop` -- -- -------------------------------------------------------- -- -- Table structure for table `talhatechnology_admins` -- CREATE TABLE `talhatechnology_admins` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `talhatechnology_admins` -- INSERT INTO `talhatechnology_admins` (`id`, `username`, `password`, `created_at`) VALUES (1, 'talha', '$2a$12$WZhSH2NWPJpat3iiNUQNTOM7dkZi0kFgLF/xyaTwC6H7ettz8GlxK', '2026-04-14 13:06:20'); -- -------------------------------------------------------- -- -- 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_deposits` -- CREATE TABLE `talhatechnology_deposits` ( `id` int(11) NOT NULL, `deposit_code` varchar(100) NOT NULL, `user_id` int(11) NOT NULL, `chat_id` bigint(20) NOT NULL, `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `method` varchar(100) NOT NULL DEFAULT 'Auto Pay', `transaction_id` varchar(160) DEFAULT NULL, `status` varchar(50) NOT NULL DEFAULT 'Pending', `created_at` datetime NOT NULL, `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `secure_token` varchar(128) DEFAULT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `talhatechnology_deposits` -- INSERT INTO `talhatechnology_deposits` (`id`, `deposit_code`, `user_id`, `chat_id`, `amount`, `method`, `transaction_id`, `status`, `created_at`, `updated_at`, `secure_token`, `expires_at`) VALUES (1, 'DEP6A10D998D7E35', 1, 5518928976, 100.00, 'Uronto Pay', NULL, 'Pending', '2026-05-23 04:32:56', '2026-05-22 22:32:56', '7db52c93638d34156f7707d4be9957f16f48d31ca2770c55e2e61aa324465ec0', '2026-05-23 05:32:56'); -- -------------------------------------------------------- -- -- Table structure for table `talhatechnology_settings` -- CREATE TABLE `talhatechnology_settings` ( `id` int(11) NOT NULL, `bot_token` varchar(255) DEFAULT NULL, `bot_username` varchar(255) DEFAULT NULL, `admin_chat_id` bigint(20) DEFAULT NULL, `currency` varchar(50) DEFAULT 'BM', `refer_bonus` decimal(10,2) DEFAULT 10.00, `minimum_withdraw` decimal(10,2) DEFAULT 100.00, `support_username` varchar(100) DEFAULT 'crazydeveloperbdc', `support_link` varchar(255) DEFAULT NULL, `payment_link` varchar(255) DEFAULT NULL, `minimum_deposit` decimal(10,2) DEFAULT 20.00, `uronto_pay_brand_key` text DEFAULT NULL, `uronto_pay_create_url` varchar(255) DEFAULT 'https://pay.urontopay.com/api/payment/create', `deposit_mode` varchar(20) DEFAULT 'auto', `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_settings` -- INSERT INTO `talhatechnology_settings` (`id`, `bot_token`, `bot_username`, `admin_chat_id`, `currency`, `refer_bonus`, `minimum_withdraw`, `support_username`, `support_link`, `payment_link`, `minimum_deposit`, `uronto_pay_brand_key`, `uronto_pay_create_url`, `deposit_mode`, `updated_at`) VALUES (1, '8837516399:AAEyoi-vdbPMXAqwH6MCRPnja_E2tHPW2Nk', '@PremiumShopbd_bot', 8948055907, 'BDT', 0.00, 100.00, 'Premiumvpnshopsupport', '', NULL, 20.00, '8QFIJJNzDGGw1qmhdCJcK5xcvuh8PwRXviUfDlLatVhgkjXlZv', '', 'auto', '2026-05-23 17:43:57'); -- -------------------------------------------------------- -- -- 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'), (2, 8948055907, 'Premiumvpnshopsupport', 'Premium vpn bot', 0.00, 1, NULL, NULL, NULL, NULL, 'bn', NULL, NULL, NULL, NULL, 0, '2026-05-23 17:44:15', '2026-05-23 17:47:38'); -- -------------------------------------------------------- -- -- 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', 1, '2026-05-22 19:03:53', '2026-05-23 17:47:00'), (2, '7 Days VPN', 'Active', 2, '2026-05-22 19:03:53', '2026-05-23 17:47:07'), (3, '14 Days VPN', 'Active', 3, '2026-05-22 19:03:53', '2026-05-23 17:47:32'), (4, '1 Month VPN', 'Active', 4, '2026-05-22 19:03:53', '2026-05-23 17:47:20'), (6, '2 month', 'Active', 5, '2026-05-23 17:46:26', '2026-05-23 17:46:26'); -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- 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 dumped tables -- -- -- Indexes for table `talhatechnology_admins` -- ALTER TABLE `talhatechnology_admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`); -- -- Indexes for table `talhatechnology_broadcasts` -- ALTER TABLE `talhatechnology_broadcasts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `talhatechnology_deposits` -- ALTER TABLE `talhatechnology_deposits` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `deposit_code` (`deposit_code`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `talhatechnology_settings` -- ALTER TABLE `talhatechnology_settings` 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 dumped tables -- -- -- AUTO_INCREMENT for table `talhatechnology_admins` -- ALTER TABLE `talhatechnology_admins` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- 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_deposits` -- ALTER TABLE `talhatechnology_deposits` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `talhatechnology_settings` -- ALTER TABLE `talhatechnology_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `talhatechnology_users` -- ALTER TABLE `talhatechnology_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `talhatechnology_vpn_categories` -- ALTER TABLE `talhatechnology_vpn_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;