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

START TRANSACTION;



--
-- Database: `promoxhu_bot`
--

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

--
-- 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `talhatechnology_admins`
--

INSERT INTO `talhatechnology_admins` (`id`, `username`, `password`, `created_at`) VALUES
(1, 'admin', '$2a$12$mAkKLL.Y90P4tjS/TrD01u//M3rj6feslTLccOCe/ZQzSWUx6Ng3C', '2026-06-28 18:37:13');

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

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

CREATE TABLE `talhatechnology_broadcasts` (
  `id` int(11) NOT NULL,
  `message` longtext DEFAULT NULL,
  `message_color` varchar(30) DEFAULT '#111827',
  `photo` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_url` varchar(600) DEFAULT NULL,
  `button_color` varchar(30) DEFAULT '#22c55e',
  `button_style` varchar(20) DEFAULT 'success',
  `total_sent` int(11) NOT NULL DEFAULT 0,
  `total_failed` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `talhatechnology_broadcasts` (`id`, `message`, `message_color`, `photo`, `button_text`, `button_url`, `button_color`, `button_style`, `total_sent`, `total_failed`, `created_at`) VALUES
(1, 'hu', '#111827', '', '', '', '#22c55e', 'success', 2, 0, '2026-06-28 18:42:54'),
(2, 'hi', '#111827', '', '', '', '#22c55e', 'success', 1, 1, '2026-06-28 18:52:53'),
(3, 'hiiiiiiiiiiiiiiiiiiiiiiiiiiiii', '#111827', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTDMlBcjx3moVAuocN5qJSVT-bK5Y92tOtb-T41NNH0MfLPxePW5eeX4tQSEdzDlZGq1Y5tuBnVCGSEvi_RU4fy771K7w9s9k8Mm-A1IxD0&s=10', 'join', 'www.talha.com', '#22c55e', 'success', 1, 1, '2026-06-28 18:53:58'),
(4, 'hi kemon aso', '#111827', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTDMlBcjx3moVAuocN5qJSVT-bK5Y92tOtb-T41NNH0MfLPxePW5eeX4tQSEdzDlZGq1Y5tuBnVCGSEvi_RU4fy771K7w9s9k8Mm-A1IxD0&s=10', 'join', 'https://www.talha.com', '#22c55e', 'success', 1, 1, '2026-06-28 19:08:06'),
(5, '🎉 শুধুমাত্র আপনার জন্য 11,000 BDT পর্যন্ত এবং 100% বোনাস!\r\n\r\n⚡ এখনই BetOnGame-এ আপনার জন্য একটি বোনাস অপেক্ষা করছে, যা আপনাকে শুরু করতে সাহায্য করবে!\r\n\r\nনিচের বাটনে ক্লিক করে, রেজিস্ট্রেশন করুন, বোনাস নিন, প্রিয় গেমগুলো খেলুন এবং জিতুন!\r\n\r\n🎁 আপনার বোনাস এখনই\r\n👇 ক্লিক করুন!', '#111827', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTDMlBcjx3moVAuocN5qJSVT-bK5Y92tOtb-T41NNH0MfLPxePW5eeX4tQSEdzDlZGq1Y5tuBnVCGSEvi_RU4fy771K7w9s9k8Mm-A1IxD0&s=10', '🎁 বোনাস নিয়ে নাও', 'https://www.talha.com', '#22c55e', 'success', 1, 1, '2026-06-28 19:10:00'),
(6, '🎉 শুধুমাত্র আপনার জন্য 11,000 BDT পর্যন্ত এবং 100% বোনাস!\r\n\r\n⚡ এখনই BetOnGame-এ আপনার জন্য একটি বোনাস অপেক্ষা করছে, যা আপনাকে শুরু করতে সাহায্য করবে!\r\n\r\nনিচের বাটনে ক্লিক করে, রেজিস্ট্রেশন করুন, বোনাস নিন, প্রিয় গেমগুলো খেলুন এবং জিতুন!\r\n\r\n🎁 আপনার বোনাস এখনই\r\n👇 ক্লিক করুন!', '#111827', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTDMlBcjx3moVAuocN5qJSVT-bK5Y92tOtb-T41NNH0MfLPxePW5eeX4tQSEdzDlZGq1Y5tuBnVCGSEvi_RU4fy771K7w9s9k8Mm-A1IxD0&s=10', '🎁 বোনাস নিয়ে নাও', 'https://www.talha.com', '#22c55e', 'success', 1, 1, '2026-06-28 19:20:35');

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

--
-- 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,
  `start_photo` text DEFAULT NULL,
  `start_text` longtext DEFAULT NULL,
  `start_message_color` varchar(30) DEFAULT '#111827',
  `start_button_text` varchar(255) DEFAULT '? Bonus Niye Nao',
  `start_button_url` varchar(600) DEFAULT NULL,
  `start_button_color` varchar(30) DEFAULT '#22c55e',
  `start_button_style` varchar(20) DEFAULT 'success',
  `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_settings`
--

INSERT INTO `talhatechnology_settings` (`id`, `bot_token`, `bot_username`, `admin_chat_id`, `start_photo`, `start_text`, `start_message_color`, `start_button_text`, `start_button_url`, `start_button_color`, `start_button_style`, `updated_at`) VALUES
(1, '8940444046:AAE3TsbkF4zf5_B916njpYP8kqYy3U2tTSQ', 'promoxhubbot', 5817676442, 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTDMlBcjx3moVAuocN5qJSVT-bK5Y92tOtb-T41NNH0MfLPxePW5eeX4tQSEdzDlZGq1Y5tuBnVCGSEvi_RU4fy771K7w9s9k8Mm-A1IxD0&s=10', '🎁 সকলের জন্য নতুন অ্যাকাউন্টে 100% Welcome Bonus !\r\n\r\n💰 ২১০০০০ পর্যন্ত বোনাস + ১৫০ স্পিন\r\n• ক্যাসিনো বোনাস \r\n🏆 স্পোর্টস বোনাস ১৪০০০ পর্যন্ত \r\n\r\n🎟 Promo Code: BD45\r\n\r\n💳 bKash • Nagad • Rocket সাপোর্টেড \r\n👇নিচে ক্লিক করে এখনই রেজিস্ট্রেশন করুন এবং‌ বোনাস নিন\r\nplayzonebd.site', '#111827', '🎁 বোনাস সংগ্রহ করুন', 'https://refpa94452.com/L?tag=d_4190892m_94912c_&site=4190892&ad=94912&r=registration', '#22c55e', 'success', '2026-06-29 00:13:03');

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

--
-- 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,
  `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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `talhatechnology_users` (`id`, `chat_id`, `username`, `first_name`, `is_banned`, `created_at`, `updated_at`) VALUES
(1, -1001726581064, 'GroupAnonymousBot', 'Group', 0, '2026-06-28 18:42:35', '2026-06-28 18:43:24'),
(2, 5518928976, 'Mindgamertalha', 'Abu Talha', 0, '2026-06-28 18:42:36', '2026-06-29 02:12:31'),
(3, 7211285498, 'RifatAdminSupport', '𝑹𝒊𝒇𝒂𝒕', 0, '2026-06-28 19:49:50', '2026-06-28 23:53:39'),
(4, 6340271786, 'Expert_Betting_Analyst', 'Expert Betting', 0, '2026-06-29 00:13:42', '2026-06-29 00:13:42'),
(5, 5817676442, 'Rafi_VAI_Admin', 'RAFI', 0, '2026-06-29 06:51:50', '2026-06-29 06:53:34');

--
-- 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_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`);

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

--
-- 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=6;
COMMIT;

