-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 24, 2026 at 11:42 AM
-- Server version: 10.11.16-MariaDB
-- PHP Version: 8.4.18

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: `licenser_smm`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `two_fa_enabled` int(1) DEFAULT 0,
  `google_2fa_secret` varchar(255) DEFAULT NULL,
  `google_2fa_enabled` int(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `username`, `password`, `email`, `phone`, `two_fa_enabled`, `google_2fa_secret`, `google_2fa_enabled`) VALUES
(1, 'admin', '$2y$10$YaW2zgaQF3/l35tcIb8M2OJqqDtQg29Isi5Fok1N/7Sw4szRhLKs.', 'admin@gmail.com', '917584068467', 0, NULL, 0);

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

--
-- Table structure for table `api_providers`
--

CREATE TABLE `api_providers` (
  `id` int(11) NOT NULL,
  `api_name` varchar(255) NOT NULL,
  `api_url` varchar(255) NOT NULL,
  `api_key` text NOT NULL,
  `api_type` varchar(50) DEFAULT 'Standard',
  `api_limit` int(11) DEFAULT 0,
  `currency` varchar(10) DEFAULT 'USD',
  `api_alert` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `api_sync` int(11) DEFAULT 0,
  `api_login_credentials` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_name` text NOT NULL,
  `category_line` int(11) NOT NULL DEFAULT 0,
  `category_type` int(11) NOT NULL DEFAULT 2,
  `category_status` int(11) NOT NULL DEFAULT 1,
  `category_icon` text DEFAULT NULL,
  `is_refill` int(11) NOT NULL DEFAULT 1,
  `category_deleted` int(11) NOT NULL DEFAULT 0,
  `category_icon_animation` varchar(50) DEFAULT 'none'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `child_panels`
--

CREATE TABLE `child_panels` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `domain` varchar(255) NOT NULL,
  `currency` varchar(50) NOT NULL,
  `admin_username` varchar(100) NOT NULL,
  `admin_password` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `status` varchar(50) DEFAULT 'Pending',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `expiry_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int(11) NOT NULL,
  `code` varchar(10) NOT NULL,
  `symbol` varchar(10) NOT NULL,
  `exchange_rate` decimal(10,4) NOT NULL DEFAULT 1.0000 COMMENT 'Rate compared to Base Currency',
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `code`, `symbol`, `exchange_rate`, `status`, `created_at`) VALUES
(1, 'INR', '₹', 1.0000, 1, '2026-03-06 12:35:05'),
(2, 'USD', '$', 0.0107, 1, '2026-03-06 12:36:19');

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

--
-- Table structure for table `custom_pages`
--

CREATE TABLE `custom_pages` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext DEFAULT NULL,
  `show_in_menu` int(1) DEFAULT 1,
  `status` int(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text DEFAULT NULL,
  `target_audience` varchar(50) DEFAULT 'all',
  `expiry_date` datetime DEFAULT NULL,
  `status` int(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `api_provider_id` int(11) DEFAULT 0 COMMENT 'ID from api_providers table, 0 if manual',
  `api_order_id` varchar(255) DEFAULT NULL COMMENT 'Order ID returned by the API provider',
  `link` text NOT NULL,
  `quantity` int(11) NOT NULL,
  `charge` decimal(10,4) NOT NULL DEFAULT 0.0000,
  `start_count` int(11) DEFAULT 0,
  `remains` int(11) DEFAULT 0,
  `order_status` varchar(50) NOT NULL DEFAULT 'pending',
  `remark` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `method_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `utr` varchar(255) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'success',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `method_type` varchar(50) NOT NULL,
  `method_name` varchar(255) NOT NULL,
  `min_amount` decimal(10,2) NOT NULL DEFAULT 10.00,
  `max_amount` decimal(10,2) NOT NULL DEFAULT 10000.00,
  `icon` varchar(50) DEFAULT 'credit-card',
  `icon_animation` varchar(50) DEFAULT 'none',
  `instructions` text DEFAULT NULL,
  `settings` longtext DEFAULT NULL COMMENT 'JSON stored settings like tokens, upi ids',
  `status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `method_type`, `method_name`, `min_amount`, `max_amount`, `icon`, `icon_animation`, `instructions`, `settings`, `status`) VALUES
(1, 'bharatpe', 'BharatPe QR / UPI', 1.00, 10000.00, 'indian-rupee', 'animate-bounce', 'Please scan the QR code to pay.', '{\"upi_id\":\"\",\"merchant_id\":\"\",\"access_token\":\"\",\"currency\":\"INR\"}', 1),
(2, 'phonepe', 'PhonePe Business / QR', 1.00, 10000.00, 'upi', 'animate-pulse', 'Scan the QR code via PhonePe app to add funds.', '{\"upi_id\":\"\",\"gmail\":\"\",\"app_password\":\"\",\"currency\":\"INR\"}', 1),
(3, 'binance', 'Binance Pay (Auto)', 0.50, 10000.00, 'bitcoin', 'none', '💳 Binance id : xyz\r\n👉 Name : You Name\r\nPay on Uid\r\nAfter payment copy order id\r\nPaste order id & amount\r\nVerify ~ Done', '{\"binance_pay_key\":\"\",\"binance_pay_secret\":\"\",\"currency\":\"USD\"}', 1),
(4, 'manual', 'Manual Payment', 10.00, 10000.00, 'landmark', 'animate-glow', 'nothing', '{\"qr_image\":\"assets\\/images\\/qrcodes\\/qr_1774345672.jpg\",\"currency\":\"INR\"}', 1),
(5, 'paytm', 'Paytm Auto (QR)', 1.00, 10000.00, 'qr-code', 'animate-pulse', 'Scan the QR code using your UPI app. Please wait on this page after payment, it will be verified automatically.', '{\"upi_id\":\"\",\"merchant_id\":\"\",\"currency\":\"INR\"}', 1),
(6, 'upigateway', 'UPI Gateway (Auto)', 1.00, 10000.00, 'zap', 'animate-pulse', 'Click the button below to pay securely via UPI Gateway.', '{\"api_key\":\"\",\"currency\":\"INR\"}', 1),
(7, 'heleket', 'Heleket Gateway', 10.00, 10000.00, 'zap', 'animate-pulse', 'Click the button below to pay securely via Heleket.', '{\"merchant_uuid\":\"\",\"payment_api_key\":\"\",\"currency\":\"CRYPTO\"}', 1);

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

--
-- Table structure for table `popups`
--

CREATE TABLE `popups` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image_url` varchar(500) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `btn_text` varchar(100) DEFAULT NULL,
  `btn_link` varchar(500) DEFAULT NULL,
  `target_audience` varchar(50) DEFAULT 'all',
  `target_page` varchar(100) DEFAULT 'all',
  `expiry_date` datetime DEFAULT NULL,
  `status` int(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `position` varchar(50) DEFAULT 'center',
  `show_once` int(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `refills`
--

CREATE TABLE `refills` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `api_provider_id` int(11) NOT NULL DEFAULT 0,
  `api_refill_id` varchar(255) DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Pending',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `role` varchar(100) DEFAULT 'Customer',
  `text` text NOT NULL,
  `stars` int(1) NOT NULL DEFAULT 5,
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Hidden',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `service_id` int(11) NOT NULL,
  `service_api` int(11) NOT NULL DEFAULT 0,
  `api_service` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL,
  `service_type` enum('1','2') NOT NULL DEFAULT '2',
  `service_line` int(11) NOT NULL DEFAULT 0,
  `service_name` text NOT NULL,
  `service_description` longtext DEFAULT NULL,
  `service_price` decimal(10,4) NOT NULL DEFAULT 0.0000,
  `service_min` int(11) NOT NULL DEFAULT 0,
  `service_max` int(11) NOT NULL DEFAULT 0,
  `show_refill` varchar(10) DEFAULT 'false',
  `cancelbutton` int(11) DEFAULT 2,
  `price_profit` decimal(10,2) DEFAULT 0.00,
  `service_deleted` int(11) NOT NULL DEFAULT 0,
  `avg_time` varchar(255) DEFAULT NULL,
  `service_speed` varchar(255) DEFAULT NULL,
  `service_status` int(11) NOT NULL DEFAULT 1,
  `service_dripfeed` int(11) NOT NULL DEFAULT 2
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`) VALUES
(1, 'site_name', 'SMM PRO'),
(2, 'site_description', 'The best SMM Panel for digital growth.'),
(3, 'site_keywords', 'smm, panel, followers, likes, growth'),
(4, 'site_logo', 'assets/images/logo_1772789104.png'),
(5, 'site_favicon', 'assets/icons/favicon_1772789104.png'),
(6, 'google_login_enabled', '1'),
(7, 'google_client_id', '223480860501-ipmii58o4shnukkj89p5e7a7g9rjf72k.apps.googleusercontent.com'),
(8, 'google_client_secret', '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'),
(73, 'terms_content', '<h2>1. Acceptance of Terms</h2><p>By accessing and using this website, you accept and agree to be bound by the terms and provision of this agreement.</p><h2>2. Service Delivery</h2><p>We guarantee delivery of all services as described. If a service drops, we will refill it according to the specific service rules.</p>'),
(74, 'privacy_content', '<h2>1. Information Collection</h2><p>We collect information from you when you register on our site, place an order, or subscribe to our newsletter.</p><h2>2. Data Protection</h2><p>We implement a variety of security measures to maintain the safety of your personal information.</p>'),
(121, 'admin_path', 'admin'),
(662, 'site_base_currency', 'INR'),
(1104, 'whatsapp_number', ''),
(1130, 'mpwa_api_key', 'your key'),
(1193, 'smtp_events', '[\"welcome\",\"order_updates\",\"admin_alerts\",\"otp_tickets\"]'),
(1194, 'telegram_events', '[\"admin_alerts\",\"order_updates\"]'),
(1195, 'whatsapp_events', '[\"welcome\",\"order_updates\",\"admin_alerts\",\"otp_tickets\"]'),
(1306, 'smtp_status', '0'),
(1314, 'telegram_status', '0'),
(1318, 'whatsapp_status', '0'),
(1626, 'template_new_order', '✅ Order Successful!\r\nYour order has been placed successfully.\r\n📦 Order Details:\r\n• Order ID: {order_id}\r\n• Service ID: {service_id}\r\n• Service Name: {service_name}\r\n🚀 Your order is now being processed. You will receive updates once the service starts.\r\nSent Via {site_name}'),
(1627, 'template_order_complete', '🎉 Order Completed Successfully!\r\n\r\nGreat news! Your order has been completed successfully.\r\n\r\n📦 Order Details:\r\n• Order ID:{order_id}\r\n• Service ID:{service_id}\r\n• Service Name: {service_name}\r\n\r\n✅ The service has been fully delivered.\r\n\r\nThank you for choosing  {site_name}  ❤️'),
(1628, 'template_order_fail', '❌ Order Cancelled\r\n\r\nYour order has been cancelled.\r\n\r\n📦 Order Details:\r\n• Order ID:{order_id}\r\n• Service ID: {service_id}\r\n• Service Name:{service_name}\r\n\r\nIf the payment was already made, the amount will be refunded according to the panel policy.\r\n\r\nSent Via  {site_name}'),
(1629, 'template_new_ticket', 'Hello Admin, a new support ticket #{ticket_id} has been opened by {name}.'),
(1770, 'template_welcome', 'Hello {name}, welcome to {site_name}! We are glad to have you on board.'),
(1771, 'smtp_host', 'mail.securedcp.in'),
(1772, 'smtp_port', '465'),
(1773, 'smtp_user', 'info@yourdomain.com'),
(1774, 'smtp_pass', 'fi@h?$Gid&RsErS,'),
(1775, 'smtp_from_email', 'info@yourdomain.com'),
(1776, 'smtp_from_name', 'SMM PRO'),
(1777, 'telegram_bot_token', 'your token'),
(1778, 'telegram_chat_id', 'your id'),
(1779, 'mpwa_api_url', 'https://mpwa.com'),
(1780, 'mpwa_admin_number', '91000000000000'),
(1793, 'notification_enabled', '0'),
(1794, 'notification_text', 'Humare SMM Panel mein aapka swagat hai! Humari premium services ka anand lein.'),
(1795, 'whatsapp_support_enabled', '0'),
(1989, 'floating_support_config', '{\"enabled\":1,\"main_icon\":\"message-circle\",\"main_color\":\"bg-indigo-600\",\"shape\":\"rounded-full\",\"animation\":\"animate-bounce\",\"buttons\":[{\"name\":\"WhatsApp Support\",\"icon\":\"message-circle\",\"image_url\":\"\",\"link\":\"https:\\/\\/wa.me\\/917584068467\",\"color\":\"bg-emerald-500\"},{\"name\":\"Telegram Support\",\"icon\":\"phone\",\"image_url\":\"\",\"link\":\"https:\\/\\/t.me\\/Gian_Tech_Sanu\",\"color\":\"bg-cyan-500\"}]}'),
(2022, 'admin_ip_protection', '0'),
(2023, 'admin_allowed_ips', '103.188.163.1'),
(2024, 'blacklisted_ips', '[]'),
(2577, 'site_menus', '[{\"id\":\"menu_69b2665f2fd38\",\"title\":\"Join Whstapp\",\"url\":\"https:\\/\\/wa.me\\/917584068467\"}]'),
(2711, 'sidebar_menus', '[{\"id\":\"new-order\",\"url\":\"new-order.php\",\"label\":\"New Order\",\"icon\":\"shopping-cart\",\"type\":\"system\"},{\"id\":\"orders\",\"url\":\"orders.php\",\"label\":\"My Orders\",\"icon\":\"list\",\"type\":\"system\"},{\"id\":\"refills\",\"url\":\"refills.php\",\"label\":\"Refill History\",\"icon\":\"refresh-cw\",\"type\":\"system\"},{\"id\":\"add-funds\",\"url\":\"add-funds.php\",\"label\":\"Add Funds\",\"icon\":\"credit-card\",\"type\":\"system\"},{\"id\":\"transactions\",\"url\":\"transactions.php\",\"label\":\"Transactions\",\"icon\":\"history\",\"type\":\"system\"},{\"id\":\"tickets\",\"url\":\"tickets.php\",\"label\":\"Support Tickets\",\"icon\":\"life-buoy\",\"type\":\"system\"},{\"id\":\"child-panel\",\"url\":\"child-panel.php\",\"label\":\"Child Panels\",\"icon\":\"zap\",\"image_url\":\"\",\"type\":\"system\"},{\"id\":\"profile\",\"url\":\"profile.php\",\"label\":\"Profile\",\"icon\":\"user\",\"type\":\"system\"}]'),
(2743, 'social_links', '[{\"id\":\"soc_69b26be603caf\",\"url\":\"https:\\/\\/wa.me\\/917584068467\",\"icon\":\"message-circle\"}]'),
(3390, 'text_slider', '[{\"id\":\"slide_69b966c92f36a\",\"text\":\"hii good discount for all\",\"link\":\"https:\\/\\/wa.me\\/9175840684657\",\"icon\":\"sparkles\",\"bg_color\":\"bg-transparent\",\"text_color\":\"text-emerald-400\",\"text_size\":\"text-xs\",\"font_style\":\"font-bold\",\"glow\":1,\"status\":1}]'),
(3564, 'site_decoration', '{\"enabled\":1,\"type\":\"snowfall\",\"color_mode\":\"multi\",\"single_color\":\"#12f840\"}'),
(6058, 'cp_price', '100'),
(6059, 'cp_ns1', 'dns1.novacloudserver.com'),
(6060, 'cp_ns2', 'dns2.novacloudserver.com'),
(6061, 'cp_demo_url', 'https://demo.youdomain.com'),
(6256, 'script_version', '2.8'),
(6798, 'enable_service_sell', '1'),
(6799, 'enable_subscription_sell', '1'),
(7397, 'home_headline_1', 'Social Media Growth & Account'),
(7398, 'home_headline_2', 'Instant & Secure'),
(7399, 'home_description', 'Boost your followers, likes, and views, or buy premium accounts instantly. World\'s leading SMM panel with guaranteed delivery'),
(7459, 'site_themes', '[{\"id\":\"theme_violet_default\",\"name\":\"Violet Elegance\",\"primary_color\":\"#4f46e5\",\"secondary_color\":\"#8b5cf6\",\"bg_color\":\"#0a0b10\",\"card_color\":\"#12141c\",\"text_color\":\"#ffffff\",\"is_system\":1},{\"id\":\"theme_golden_default\",\"name\":\"Golden Luxury\",\"primary_color\":\"#eab308\",\"secondary_color\":\"#f59e0b\",\"bg_color\":\"#000000\",\"card_color\":\"#141415\",\"text_color\":\"#fefce8\",\"is_system\":1}]'),
(7460, 'active_theme_id', 'theme_golden_default');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `credentials` text DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `expiry_date` datetime DEFAULT NULL,
  `validity` varchar(100) DEFAULT 'Lifetime'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `subscription_categories`
--

CREATE TABLE `subscription_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `subscription_orders`
--

CREATE TABLE `subscription_orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `subscription_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `credentials` text NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `validity` varchar(100) DEFAULT 'Lifetime'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL COMMENT 'NULL agar guest user hai',
  `guest_name` varchar(100) DEFAULT NULL,
  `guest_email` varchar(100) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` (`id`, `user_id`, `guest_name`, `guest_email`, `subject`, `status`, `created_at`, `updated_at`) VALUES
(13, NULL, 'Dont Delete Me', 'dontdeleteme@gmail.com', 'Dont Delete ME', 'Answered', '2026-03-22 17:35:17', '2026-03-22 17:41:26');

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

--
-- Table structure for table `ticket_messages`
--

CREATE TABLE `ticket_messages` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `sender_id` int(11) DEFAULT NULL COMMENT 'User ID, NULL agar admin/guest hai',
  `message` text NOT NULL,
  `is_admin` int(1) NOT NULL DEFAULT 0 COMMENT '1 agar admin ne bheja hai',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `balance` decimal(10,2) DEFAULT 0.00,
  `tier` varchar(50) DEFAULT 'Standard',
  `api_key` varchar(64) NOT NULL,
  `auth_provider` varchar(20) DEFAULT 'local',
  `oauth_uid` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `discount` decimal(5,2) DEFAULT 0.00,
  `status` int(1) DEFAULT 1 COMMENT '1=Active, 0=Suspended',
  `reset_token` varchar(100) DEFAULT NULL,
  `two_fa_enabled` int(1) DEFAULT 0,
  `google_2fa_secret` varchar(255) DEFAULT NULL,
  `google_2fa_enabled` int(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`);

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`service_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1995;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9308;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
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 */;