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

START TRANSACTION;



--
-- Database: `ifixrom1_test`
--

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

--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'ID of the registered user',
  `type` enum('shipping','billing') NOT NULL COMMENT 'Type of address: shipping or billing',
  `address_line_1` varchar(255) NOT NULL,
  `address_line_2` varchar(255) DEFAULT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) DEFAULT NULL COMMENT 'State or Province (Optional)',
  `zip_code` varchar(20) NOT NULL,
  `country` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `admin_users`
--

CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin_users`
--

INSERT INTO `admin_users` (`id`, `username`, `password`, `role_id`, `created_at`) VALUES
(1, 'admin', '$2y$10$3k.td28opNI6yXOwQC8lZu87Tts8a/dsreZeI7q.2/zE/5Y176ULy', 1, '2025-12-14 16:45:01');

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

--
-- Table structure for table `api_keys`
--

CREATE TABLE `api_keys` (
  `id` int(11) NOT NULL,
  `key_name` varchar(100) NOT NULL COMMENT 'A friendly name for the key''s purpose',
  `api_key` varchar(255) NOT NULL,
  `status` enum('active','revoked') NOT NULL DEFAULT 'active',
  `last_used` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `api_keys`
--

INSERT INTO `api_keys` (`id`, `key_name`, `api_key`, `status`, `last_used`, `created_at`) VALUES
(1, 'test', '01812f5da92262a5370a9ba9ec9145603a0051f45a33ac7b3f07006f372c17ba', 'revoked', NULL, '2025-09-19 10:29:57'),
(2, '7477477765', 'd3e9dd4f5cafad4079c527d78864be9166dcf8fbf572fd9da2ca9bae9b10edc9', 'revoked', NULL, '2025-09-20 18:42:51'),
(3, 'Nnbnsdbbdbd', '13820128ef8fa4697957baf7807bbc8230028b7f60216c9ea36a662b8394d93d', 'revoked', NULL, '2025-09-23 18:44:15'),
(4, 'ifrix firmware', 'f4b38e0abb6390884aa659c32048c2ece2421a3533952432585624d9b70e31bd', 'revoked', NULL, '2025-09-28 21:12:12');

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

--
-- Table structure for table `asset_folders`
--

CREATE TABLE `asset_folders` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `thumbnail` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `asset_folders`
--

INSERT INTO `asset_folders` (`id`, `parent_id`, `name`, `description`, `created_at`, `is_active`, `thumbnail`) VALUES
(13, 12, 'J2', '', '2025-10-27 17:47:03', 1, ''),
(25, NULL, 'XIAOMI FIRMWARE', 'All Xiaomi firmware 100% tested and Secure ', '2025-12-07 16:37:22', 1, 'uploads/library/1765125658_Xiaomi-Logo.png'),
(26, NULL, 'VIVO FIRMWARE', 'All Vivo Firmware', '2025-12-07 16:42:36', 1, 'uploads/library/1765125756_vivo-logo.png'),
(27, NULL, 'TECNO FIRMWARE', 'Tecno All Firmware', '2025-12-07 16:44:06', 1, 'uploads/library/1765125846_channels4_profile.jpg'),
(28, NULL, 'INFINIX FIRMWARE', 'Infinix All Firmware', '2025-12-07 16:45:13', 1, 'uploads/library/1765125913_infinix-logo.png'),
(29, NULL, 'SAMSUNG FIRMWARE', 'Samsung All Firmware', '2025-12-07 16:46:50', 1, 'uploads/library/1765126010_images1.png'),
(30, NULL, 'REALME FIRMWARE', 'Realme All Firmware', '2025-12-07 16:47:45', 1, 'uploads/library/1765126065_realme_logo.png'),
(31, NULL, 'OPPO FIRMWARE', 'Oppo All Firmware Tested', '2025-12-07 16:55:00', 1, 'uploads/library/1765126500_images6.jpeg'),
(32, NULL, 'ONPLUS FIRMWARE', 'Onplus All Firmware ', '2025-12-07 16:56:11', 1, 'uploads/library/1765126571_images2.png'),
(33, NULL, 'MOTOROLA FIRMWARE', 'Motorola All Firmware ', '2025-12-07 16:58:22', 1, 'uploads/library/1765126702_images3.png'),
(34, NULL, 'GOOGLE PIXEL FIRMWARE', 'Pixel All Firmware ', '2025-12-07 17:00:45', 1, 'uploads/library/1765126845_images4.png'),
(35, NULL, 'ITEL FIRMWARE', 'Itel All Firmware ', '2025-12-07 17:01:48', 1, 'uploads/library/1765126908_images5.png'),
(36, NULL, 'HUAWEI & HONOR', 'FIRMWARE FILE & OTHER', '2025-12-07 17:03:22', 1, 'uploads/library/1765127002_images7.jpeg'),
(37, 36, 'BOARD FIRMWARE', 'Huawei honor board repair', '2025-12-07 17:05:16', 1, 'uploads/library/1765127116_1-1704561287.jpg'),
(38, 36, 'Chip Repair _ Activate your Device Fix & Auto Recovery Fix', 'ALL MODEL _ALL VERSION_SUPPORT', '2025-12-07 17:07:31', 1, 'uploads/library/1765127251_images8.jpeg'),
(39, 36, 'HUAWEI ID & DOWNGRADE FILE', 'Solution & File', '2025-12-07 17:09:50', 1, 'uploads/library/1765127390_1-17042923791.png'),
(40, 25, 'MI ACCOUNT REMOVE FILE', 'Mi account remove any file & solution ', '2025-12-07 17:13:35', 1, 'uploads/library/1765127615_x1080.jpeg'),
(41, 25, 'ENG ROM', 'Engineering rom for Xiaomi ', '2025-12-07 17:14:33', 1, 'uploads/library/1765127673_1-1704561287.jpg'),
(42, 41, 'vayu', '', '2025-12-07 17:22:50', 1, '');

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

--
-- Table structure for table `asset_package_links`
--

CREATE TABLE `asset_package_links` (
  `asset_id` int(11) NOT NULL,
  `asset_type` enum('file','folder') NOT NULL,
  `package_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `asset_package_links`
--

INSERT INTO `asset_package_links` (`asset_id`, `asset_type`, `package_id`) VALUES
(10, 'file', 1),
(10, 'file', 2),
(10, 'file', 3),
(10, 'file', 4),
(10, 'file', 15),
(10, 'file', 16),
(22, 'file', 1),
(22, 'file', 2),
(22, 'file', 3),
(22, 'file', 4),
(22, 'file', 15),
(22, 'file', 16),
(22, 'file', 35);

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `image_url` varchar(255) NOT NULL COMMENT 'ব্যানার ইমেজের URL বা পাথ',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'ব্যানারে ক্লিক করলে কোথায় যাবে',
  `title` varchar(100) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0 COMMENT 'ব্যানারের প্রদর্শনের ক্রম',
  `is_active` tinyint(1) 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 `banners`
--

INSERT INTO `banners` (`id`, `image_url`, `link_url`, `title`, `subtitle`, `sort_order`, `is_active`, `created_at`) VALUES
(1, 'https://filewale.com/_next/image?url=https%3A%2F%2Fapis.filewale.com%2Fstatic%2Fmedia%2Fbanners%2Fbanners-1762701427444.gif&w=1920&q=85', '#browse-categories', 'Premium Digital Assets', 'Get instant access to top-quality files now.', 10, 1, '2025-12-01 12:14:48');

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `broadcasts`
--

CREATE TABLE `broadcasts` (
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `activated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `currencies` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(10) NOT NULL,
  `symbol` varchar(10) NOT NULL,
  `exchange_rate` decimal(13,5) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `currencies` (`id`, `name`, `code`, `symbol`, `exchange_rate`, `is_default`) VALUES
(1, 'US Dollar', 'USD', '$', 1.00000, 1),
(2, 'Bangladeshi Taka', 'BDT', '৳', 121.36000, 0),
(3, 'Indian Rupee', 'INR', '₹', 87.64200, 0);

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

--
-- Table structure for table `customer_feedback`
--

CREATE TABLE `customer_feedback` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) DEFAULT NULL COMMENT 'Optional: link feedback to a specific package',
  `rating` tinyint(1) NOT NULL COMMENT 'Rating from 1 to 5',
  `comment` text DEFAULT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_feedback`
--

INSERT INTO `customer_feedback` (`id`, `user_id`, `package_id`, `rating`, `comment`, `status`, `submitted_at`) VALUES
(2, 2, 4, 3, 'The free package is good, but has some limitations as expected. Good for a start.', 'approved', '2025-09-19 06:02:07');

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

--
-- Table structure for table `discount_codes`
--

CREATE TABLE `discount_codes` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `type` enum('fixed','percentage') NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `max_uses` int(11) NOT NULL DEFAULT 1,
  `uses` int(11) NOT NULL DEFAULT 0,
  `expires_at` datetime DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `discount_codes`
--

INSERT INTO `discount_codes` (`id`, `code`, `type`, `value`, `max_uses`, `uses`, `expires_at`, `status`, `created_at`) VALUES
(1, 'SAVE10', 'fixed', 10.00, 100, 0, '2025-12-31 23:59:59', 'active', '2025-09-19 09:27:57'),
(2, 'SUMMER20', 'percentage', 20.00, 500, 0, '2026-08-31 23:59:59', 'active', '2025-09-19 09:27:57');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL COMMENT 'Friendly name for the template',
  `slug` varchar(100) NOT NULL COMMENT 'Unique identifier for use in code',
  `subject` varchar(255) NOT NULL COMMENT 'Email subject line',
  `body` text NOT NULL COMMENT 'HTML content of the email',
  `variables` text DEFAULT NULL COMMENT 'JSON array of available variables like {{username}}',
  `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 `email_templates`
--

INSERT INTO `email_templates` (`id`, `name`, `slug`, `subject`, `body`, `variables`, `updated_at`) VALUES
(1, 'New User Welcome', 'new-user-welcome', 'Welcome to {{site_name}}!', '<p>Hi {{username}},</p><p>Thank you for registering at {{site_name}}. We are excited to have you with us!</p><p>Regards,<br>The {{site_name}} Team</p>', '[\"{{username}}\", \"{{site_name}}\"]', '2025-09-19 09:40:20'),
(2, 'Order Confirmation', 'order-confirmation', 'Your Order #{{order_id}} has been confirmed!', '<p>Hello {{customer_name}},</p><p>Thank you for your purchase. Your order with ID #{{order_id}} has been successfully placed.</p><p>Total Amount: ${{order_total}}</p><p>We will notify you again once your items have been delivered.</p><p>Thanks,<br>{{site_name}}</p>', '[\"{{customer_name}}\", \"{{order_id}}\", \"{{order_total}}\", \"{{site_name}}\"]', '2025-09-19 09:40:20'),
(3, 'Password Reset Request', 'password-reset', 'Password Reset Request for {{site_name}}', '<p>Hello {{username}},</p><p>We received a request to reset your password. Please click the link below to set a new password:</p><p><a href=\"{{reset_link}}\">Reset Password</a></p><p>If you did not request this, please ignore this email.</p><p>Regards,<br>The {{site_name}} Team</p>', '[\"{{username}}\", \"{{reset_link}}\", \"{{site_name}}\"]', '2025-09-19 09:40:20'),
(4, 'Subscription Verification Code', 'subscription-verify-code', 'Your Verification Code for Subscription Purchase at {{site_name}}', '<p>Dear {{username}},</p>\r\n<p>To finalize your subscription purchase, please use the verification code below:</p>\r\n<div style=\"text-align: center; margin: 25px 0;\">\r\n    <span style=\"display: inline-block; background: #F0F9FF; color: #4F46E5; padding: 15px 30px; border-radius: 8px; font-size: 24px; font-weight: 700; border: 1px solid #3B82F6;\">\r\n        {{verification_code}}\r\n    </span>\r\n</div>\r\n<p>This code is valid for 10 minutes. If you did not initiate this purchase, please ignore this email.</p>', '[\"{{username}}\", \"{{site_name}}\", \"{{verification_code}}\"]', '2025-12-10 18:15:40'),
(5, 'Subscription Purchase Success', 'subscription-success', '🎉 Subscription Confirmed: {{package_name}} Activated!', '<p>Congratulations, {{username}}!</p>\r\n<p>Your purchase of the <strong>{{package_name}}</strong> subscription has been successfully processed and is now active on your account.</p>\r\n<p style=\"margin-top: 20px; font-size: 16px; color: #10B981; font-weight: 600;\">\r\n    Package Price: {{package_price}}\r\n</p>\r\n<p>You can now enjoy instant access to all the features and files included in your new subscription.</p>\r\n<p>Thank you for choosing {{site_name}}.</p>\r\n<p>Transaction ID: {{transaction_id}}</p>', '[\"{{username}}\", \"{{site_name}}\", \"{{package_name}}\", \"{{package_price}}\", \"{{transaction_id}}\"]', '2025-12-10 18:01:52'),
(7, 'Two-Factor Verification Code', '2fa-code', 'Your Security Verification Code for {{site_name}}', '<p>Hello {{username}},</p>\r\n<p>You recently attempted to log in to your account. For added security, please use the 6-digit verification code below:</p>\r\n<div style=\"text-align: center; margin: 25px 0;\">\r\n    <span style=\"display: inline-block; background: #F0F9FF; color: #4F46E5; padding: 15px 30px; border-radius: 8px; font-size: 24px; font-weight: 700; border: 1px solid #3B82F6;\">\r\n        {{verification_code}}\r\n    </span>\r\n</div>\r\n<p>This code is valid for 5 minutes. Do not share this code with anyone. If you did not initiate this login attempt, please ignore this email.</p>\r\n<p>Regards,<br>The {{site_name}} Security Team</p>', '[\"{{username}}\", \"{{verification_code}}\", \"{{site_name}}\"]', '2025-12-10 20:08:26');

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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` int(11) NOT NULL,
  `folder_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `link_type` enum('upload','direct','indirect') NOT NULL DEFAULT 'upload',
  `is_paid` tinyint(1) NOT NULL DEFAULT 0,
  `price` decimal(10,2) DEFAULT 0.00,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `filename` varchar(255) NOT NULL,
  `filepath` varchar(255) NOT NULL,
  `filesize` bigint(20) NOT NULL DEFAULT 0 COMMENT 'Size in bytes',
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `thumbnail` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `gallery` text DEFAULT NULL,
  `license_code` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`id`, `folder_id`, `title`, `description`, `link_type`, `is_paid`, `price`, `is_featured`, `is_active`, `filename`, `filepath`, `filesize`, `upload_date`, `thumbnail`, `image`, `body`, `tags`, `gallery`, `license_code`) VALUES
(22, 42, 'Poco X3 Pro (vayu) eng firmware 100% tested by ifixrom.com', NULL, 'indirect', 0, 0.00, 1, 1, '', 'https://drive.google.com/file/d/18blXAvcGQk2YebfD4c4ovTM2SkgDS-_C/view?usp=drivesdk', 1288490188, '2025-12-07 17:27:28', NULL, NULL, '', '', '[]', 'Hello dndbbdbdbdb');

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

--
-- Table structure for table `file_downloads`
--

CREATE TABLE `file_downloads` (
  `id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `download_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `ip_address` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `file_downloads`
--

INSERT INTO `file_downloads` (`id`, `file_id`, `user_id`, `download_date`, `ip_address`) VALUES
(18, 10, NULL, '2025-10-29 06:44:19', '118.179.33.166'),
(19, 10, NULL, '2025-10-29 06:44:48', '118.179.33.166'),
(20, 10, 8, '2025-10-29 06:45:38', '118.179.33.166'),
(21, 10, 8, '2025-10-29 06:55:21', '118.179.33.166'),
(22, 10, 8, '2025-10-29 06:55:49', '118.179.33.166'),
(30, 10, 8, '2025-12-01 08:24:41', '118.179.33.166'),
(31, 10, 8, '2025-12-01 08:25:02', '118.179.33.166'),
(32, 10, 7, '2025-12-01 13:23:00', '37.111.243.251'),
(42, 10, 2, '2025-12-03 13:22:37', '118.179.33.169'),
(45, 17, 1, '2025-12-05 06:27:56', '37.111.243.102'),
(46, 17, 1, '2025-12-05 06:28:44', '37.111.243.102'),
(47, 17, 3, '2025-12-07 07:30:17', '118.179.33.169'),
(48, 17, 3, '2025-12-07 07:34:47', '118.179.33.169'),
(49, 17, 4, '2025-12-07 08:34:35', '118.179.33.169'),
(50, 20, 1, '2025-12-07 10:38:51', '37.111.243.41'),
(51, 20, 1, '2025-12-07 10:40:53', '37.111.243.41'),
(52, 20, 1, '2025-12-07 10:43:02', '37.111.243.41'),
(53, 20, 1, '2025-12-07 10:43:07', '37.111.243.41'),
(54, 20, 1, '2025-12-07 10:43:35', '37.111.243.41'),
(55, 20, 4, '2025-12-07 15:47:57', '118.179.33.169'),
(56, 20, 4, '2025-12-07 16:20:15', '118.179.33.169'),
(57, 20, 1, '2025-12-07 16:20:47', '37.111.243.86'),
(58, 20, 1, '2025-12-07 16:20:59', '37.111.243.86'),
(59, 21, 4, '2025-12-07 16:30:41', '118.179.33.169'),
(60, 21, 4, '2025-12-07 16:41:36', '118.179.33.169'),
(61, 21, 4, '2025-12-07 17:03:52', '118.179.33.169'),
(62, 21, 4, '2025-12-07 17:15:48', '118.179.33.169'),
(63, 22, 1, '2025-12-07 17:28:01', '37.111.243.86'),
(64, 22, 1, '2025-12-07 17:28:06', '37.111.243.86'),
(65, 22, 1, '2025-12-07 17:28:09', '37.111.243.86'),
(66, 22, 1, '2025-12-07 17:28:41', '37.111.243.86'),
(67, 22, 1, '2025-12-07 17:29:36', '37.111.243.86'),
(68, 22, 1, '2025-12-07 17:29:43', '37.111.243.86'),
(69, 21, 4, '2025-12-07 17:35:46', '118.179.33.169'),
(70, 21, 4, '2025-12-07 17:35:51', '118.179.33.169'),
(71, 22, 4, '2025-12-07 17:41:17', '118.179.33.169'),
(72, 22, 1, '2025-12-08 11:43:37', '37.111.243.73'),
(73, 22, 1, '2025-12-08 11:44:02', '37.111.243.73'),
(74, 22, 1, '2025-12-08 11:44:10', '37.111.243.73'),
(75, 22, 1, '2025-12-08 11:44:17', '37.111.243.73'),
(76, 22, 1, '2025-12-08 11:48:27', '37.111.243.73'),
(77, 22, 1, '2025-12-08 11:50:19', '37.111.243.73'),
(78, 22, 1, '2025-12-08 11:50:47', '37.111.243.73'),
(79, 22, 1, '2025-12-08 11:52:45', '37.111.243.73'),
(80, 22, 1, '2025-12-08 11:53:16', '37.111.243.73'),
(81, 22, 1, '2025-12-08 11:57:38', '37.111.243.73'),
(82, 22, 1, '2025-12-08 11:57:43', '37.111.243.73'),
(83, 22, 1, '2025-12-08 11:57:46', '37.111.243.73'),
(84, 22, 1, '2025-12-08 12:17:14', '37.111.243.73'),
(85, 22, 6, '2025-12-11 11:05:57', '118.179.33.169'),
(86, 22, 10, '2025-12-12 16:54:50', '37.111.243.12'),
(87, 22, 10, '2025-12-12 16:55:40', '37.111.243.12'),
(88, 22, 10, '2025-12-12 16:55:48', '37.111.243.12');

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

--
-- Table structure for table `file_reviews`
--

CREATE TABLE `file_reviews` (
  `id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rating` tinyint(1) NOT NULL COMMENT 'Rating from 1 to 5',
  `review_text` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_approved` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = Approved, 0 = Pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `file_reviews`
--

INSERT INTO `file_reviews` (`id`, `file_id`, `user_id`, `rating`, `review_text`, `created_at`, `is_approved`) VALUES
(2, 17, 1, 5, 'Top file', '2025-12-05 11:22:39', 1),
(3, 22, 1, 5, 'Good', '2025-12-07 17:30:16', 1);

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

--
-- Table structure for table `file_views`
--

CREATE TABLE `file_views` (
  `id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `view_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `file_views`
--

INSERT INTO `file_views` (`id`, `file_id`, `user_id`, `ip_address`, `view_date`) VALUES
(1, 9, NULL, '118.179.33.166', '2025-11-02 01:58:18'),
(2, 10, NULL, '118.179.33.166', '2025-11-02 01:12:10'),
(3, 10, NULL, '118.179.33.166', '2025-11-02 01:15:22'),
(4, 5, NULL, '118.179.33.166', '2025-11-02 01:47:50'),
(5, 10, NULL, '118.179.33.166', '2025-11-02 12:43:11'),
(6, 10, NULL, '69.171.234.16', '2025-11-02 21:55:10'),
(7, 10, NULL, '173.252.107.37', '2025-11-18 23:02:15'),
(8, 8, 7, '37.111.243.42', '2025-11-19 13:33:34'),
(9, 8, NULL, '37.111.243.42', '2025-11-19 13:34:17'),
(10, 5, NULL, '37.111.243.42', '2025-11-19 13:34:43'),
(11, 5, NULL, '118.179.33.166', '2025-11-24 05:25:15'),
(12, 8, NULL, '37.111.243.154', '2025-11-24 07:07:27'),
(13, 8, NULL, '118.179.33.166', '2025-11-24 07:08:30'),
(14, 5, 7, '37.111.243.154', '2025-11-24 07:19:03'),
(15, 10, NULL, '27.147.191.120', '2025-11-24 10:11:37'),
(16, 11, 7, '27.147.191.120', '2025-11-24 10:48:29'),
(17, 8, NULL, '37.111.243.154', '2025-11-24 11:53:26'),
(18, 11, NULL, '37.111.243.187', '2025-11-24 12:09:25'),
(19, 5, NULL, '37.111.243.187', '2025-11-24 12:09:38'),
(20, 10, 7, '37.111.243.187', '2025-11-24 12:10:42'),
(21, 10, NULL, '118.179.33.166', '2025-11-24 13:02:35'),
(22, 5, NULL, '118.179.33.166', '2025-11-24 13:03:27'),
(23, 11, NULL, '37.111.243.187', '2025-11-24 13:55:15'),
(24, 11, NULL, '37.111.243.218', '2025-11-24 16:02:06'),
(25, 11, NULL, '74.7.242.53', '2025-11-24 22:23:32'),
(26, 11, NULL, '74.7.241.51', '2025-11-24 22:46:27'),
(27, 11, NULL, '27.147.191.120', '2025-11-26 00:34:58'),
(28, 12, NULL, '74.7.242.53', '2025-11-27 06:30:40'),
(29, 4, 7, '27.147.191.120', '2025-11-28 07:35:15'),
(30, 5, 7, '27.147.191.120', '2025-11-28 07:35:22'),
(31, 6, 7, '27.147.191.120', '2025-11-28 07:35:35'),
(32, 7, 7, '27.147.191.120', '2025-11-28 07:35:38'),
(33, 12, NULL, '37.111.243.164', '2025-11-28 12:00:42'),
(34, 11, NULL, '37.111.243.164', '2025-11-28 12:01:07'),
(35, 7, NULL, '37.111.243.164', '2025-11-28 13:35:45'),
(36, 19, NULL, '37.111.243.164', '2025-11-28 13:35:50'),
(37, 4, NULL, '37.111.243.164', '2025-11-28 13:35:53'),
(38, 12, NULL, '74.7.241.51', '2025-11-29 00:49:52'),
(39, 25, NULL, '118.179.33.166', '2025-11-29 09:37:03'),
(40, 12, 8, '118.179.33.166', '2025-11-29 12:46:03'),
(41, 5, 8, '118.179.33.166', '2025-11-29 12:46:06'),
(42, 9, 8, '118.179.33.166', '2025-11-29 13:12:40'),
(43, 11, 8, '118.179.33.166', '2025-11-29 14:12:56'),
(44, 5, NULL, '118.179.33.166', '2025-11-30 00:54:48'),
(45, 9, NULL, '118.179.33.166', '2025-11-30 00:59:05'),
(46, 5, 8, '118.179.33.166', '2025-11-30 05:33:06'),
(47, 10, 8, '118.179.33.166', '2025-11-30 05:33:26'),
(48, 8, 8, '118.179.33.166', '2025-11-30 05:33:38'),
(49, 9, 8, '118.179.33.166', '2025-11-30 05:34:19'),
(50, 11, NULL, '118.179.33.166', '2025-11-30 11:50:37'),
(51, 9, 8, '118.179.33.166', '2025-11-30 12:17:16'),
(52, 5, 8, '118.179.33.166', '2025-11-30 12:17:27'),
(53, 10, 8, '118.179.33.166', '2025-11-30 12:17:54'),
(54, 10, NULL, '118.179.33.166', '2025-11-30 12:19:34'),
(55, 11, NULL, '37.111.243.164', '2025-11-30 14:52:09'),
(56, 5, 7, '37.111.243.164', '2025-11-30 14:53:19'),
(57, 10, 7, '37.111.243.164', '2025-11-30 14:53:43'),
(58, 13, 7, '37.111.243.164', '2025-11-30 14:55:46'),
(59, 15, 7, '37.111.243.164', '2025-11-30 15:00:10'),
(60, 10, NULL, '118.179.33.166', '2025-12-01 02:23:02'),
(61, 10, NULL, '118.179.33.166', '2025-12-01 03:47:54'),
(62, 15, NULL, '118.179.33.166', '2025-12-01 03:50:33'),
(63, 14, NULL, '118.179.33.166', '2025-12-01 03:52:07'),
(64, 9, NULL, '118.179.33.166', '2025-12-01 05:03:29'),
(65, 14, NULL, '118.179.33.166', '2025-12-01 05:04:26'),
(66, 15, NULL, '118.179.33.166', '2025-12-01 05:05:31'),
(67, 8, NULL, '118.179.33.166', '2025-12-01 06:41:26'),
(68, 10, NULL, '37.111.243.251', '2025-12-01 08:22:39'),
(69, 5, NULL, '118.179.33.166', '2025-12-01 08:58:18'),
(70, 11, NULL, '118.179.33.166', '2025-12-01 09:45:50'),
(71, 10, 5, '118.179.33.166', '2025-12-01 09:57:01'),
(72, 11, NULL, '118.179.33.166', '2025-12-01 11:34:40'),
(73, 13, NULL, '37.111.243.134', '2025-12-01 11:54:19'),
(74, 16, 7, '37.111.243.134', '2025-12-01 11:58:09'),
(75, 11, 9, '37.111.243.134', '2025-12-01 12:24:24'),
(76, 16, 9, '37.111.243.134', '2025-12-01 12:24:40'),
(77, 11, 9, '37.111.243.134', '2025-12-01 12:26:08'),
(78, 14, 9, '37.111.243.134', '2025-12-01 12:26:27'),
(79, 16, 9, '37.111.243.134', '2025-12-01 12:26:53'),
(80, 5, 8, '118.179.33.166', '2025-12-01 13:01:18'),
(81, 9, 8, '118.179.33.166', '2025-12-01 13:05:26'),
(82, 13, NULL, '74.7.241.51', '2025-12-01 18:02:43'),
(83, 14, NULL, '74.7.241.51', '2025-12-01 18:03:06'),
(84, 16, NULL, '74.7.241.51', '2025-12-01 18:04:21'),
(85, 15, NULL, '74.7.241.51', '2025-12-01 18:04:35'),
(86, 10, NULL, '118.179.33.169', '2025-12-03 14:30:47'),
(87, 15, NULL, '37.111.243.105', '2025-12-03 15:49:56'),
(88, 10, NULL, '37.111.247.94', '2025-12-03 16:02:18'),
(89, 11, NULL, '118.179.33.169', '2025-12-03 17:54:07'),
(90, 11, NULL, '118.179.33.169', '2025-12-03 17:54:46'),
(91, 10, NULL, '118.179.33.169', '2025-12-03 18:09:45'),
(92, 10, NULL, '37.111.243.105', '2025-12-03 18:48:56'),
(93, 15, 1, '37.111.243.105', '2025-12-03 18:51:18'),
(94, 16, NULL, '37.111.253.129', '2025-12-03 19:11:27'),
(95, 15, 1, '37.111.253.129', '2025-12-03 19:12:43'),
(96, 11, NULL, '118.179.33.169', '2025-12-03 19:33:56'),
(97, 10, 2, '118.179.33.169', '2025-12-03 21:04:15'),
(98, 11, 2, '118.179.33.169', '2025-12-03 21:18:58'),
(99, 10, 2, '118.179.33.169', '2025-12-03 21:21:59'),
(100, 9, NULL, '15.235.96.175', '2025-12-03 21:52:59'),
(101, 8, NULL, '54.39.210.43', '2025-12-03 22:05:07'),
(102, 5, NULL, '54.39.203.13', '2025-12-03 22:16:45'),
(103, 16, NULL, '51.222.95.169', '2025-12-03 22:28:04'),
(104, 15, NULL, '15.235.27.38', '2025-12-03 22:39:30'),
(105, 14, NULL, '142.44.220.141', '2025-12-03 22:53:38'),
(106, 13, NULL, '51.161.37.87', '2025-12-03 23:07:01'),
(107, 12, NULL, '15.235.98.119', '2025-12-03 23:19:48'),
(108, 11, NULL, '15.235.27.43', '2025-12-03 23:31:24'),
(109, 10, NULL, '15.235.98.26', '2025-12-03 23:43:28'),
(110, 11, NULL, '118.179.33.169', '2025-12-04 00:55:20'),
(111, 10, NULL, '118.179.33.169', '2025-12-04 00:55:24'),
(112, 16, 1, '37.111.239.86', '2025-12-05 01:50:28'),
(113, 10, NULL, '37.111.243.102', '2025-12-05 13:34:54'),
(114, 17, 1, '37.111.243.102', '2025-12-05 14:26:40'),
(115, 17, NULL, '37.111.243.82', '2025-12-05 17:40:20'),
(116, 17, NULL, '66.249.79.205', '2025-12-05 18:34:15'),
(117, 17, 1, '37.111.243.82', '2025-12-05 19:21:13'),
(118, 17, NULL, '37.111.243.228', '2025-12-06 15:55:49'),
(119, 17, NULL, '198.244.226.163', '2025-12-07 12:32:47'),
(120, 17, NULL, '118.179.33.169', '2025-12-07 15:01:52'),
(121, 17, NULL, '118.179.33.169', '2025-12-07 16:14:21'),
(122, 17, NULL, '118.179.33.169', '2025-12-07 16:25:32'),
(123, 17, 1, '37.111.243.186', '2025-12-07 18:10:42'),
(124, 19, NULL, '37.111.243.186', '2025-12-07 18:26:34'),
(125, 19, 4, '118.179.33.169', '2025-12-07 18:32:08'),
(126, 20, 1, '37.111.243.41', '2025-12-07 18:34:57'),
(127, 20, 1, '37.111.243.41', '2025-12-07 18:43:57'),
(128, 20, NULL, '37.111.243.179', '2025-12-07 18:58:13'),
(129, 20, 1, '118.179.33.169', '2025-12-07 19:43:53'),
(130, 20, NULL, '37.111.243.179', '2025-12-07 19:55:28'),
(131, 20, NULL, '37.111.243.179', '2025-12-07 21:24:55'),
(132, 20, NULL, '37.111.243.179', '2025-12-07 22:53:23'),
(133, 20, NULL, '118.179.33.169', '2025-12-07 23:15:10'),
(134, 20, NULL, '118.179.33.169', '2025-12-07 23:44:36'),
(135, 20, NULL, '37.111.243.86', '2025-12-08 00:18:50'),
(136, 20, NULL, '118.179.33.169', '2025-12-08 00:19:45'),
(137, 21, 4, '118.179.33.169', '2025-12-08 00:30:27'),
(138, 21, NULL, '118.179.33.169', '2025-12-08 00:41:11'),
(139, 21, 1, '37.111.243.86', '2025-12-08 00:48:01'),
(140, 21, NULL, '37.111.243.86', '2025-12-08 00:55:19'),
(141, 21, NULL, '118.179.33.169', '2025-12-08 01:15:34'),
(142, 22, NULL, '37.111.243.86', '2025-12-08 01:27:39'),
(143, 22, NULL, '118.179.33.169', '2025-12-08 01:41:03'),
(144, 20, NULL, '37.111.243.86', '2025-12-08 01:45:55'),
(145, 22, NULL, '37.111.243.73', '2025-12-08 03:34:48'),
(146, 22, NULL, '37.111.243.73', '2025-12-08 18:16:37'),
(147, 21, NULL, '37.111.243.73', '2025-12-08 18:16:47'),
(148, 22, NULL, '37.111.243.73', '2025-12-08 19:25:21'),
(149, 22, NULL, '37.111.243.73', '2025-12-08 19:31:26'),
(150, 22, NULL, '37.111.243.73', '2025-12-08 19:42:18'),
(151, 22, NULL, '37.111.243.73', '2025-12-08 20:16:36'),
(152, 17, NULL, '47.79.194.224', '2025-12-08 22:52:09'),
(153, 22, 4, '118.179.33.169', '2025-12-10 04:13:49'),
(154, 17, NULL, '66.249.79.205', '2025-12-10 07:46:35'),
(155, 10, NULL, '66.249.79.206', '2025-12-10 09:03:50'),
(156, 22, NULL, '47.79.218.225', '2025-12-10 13:02:33'),
(157, 21, NULL, '47.79.213.59', '2025-12-10 13:28:50'),
(158, 22, 4, '118.179.33.169', '2025-12-10 15:47:02'),
(159, 22, NULL, '37.111.243.101', '2025-12-10 23:46:11'),
(160, 22, NULL, '66.249.79.205', '2025-12-11 00:22:49'),
(161, 22, NULL, '66.249.79.206', '2025-12-11 06:01:09'),
(162, 22, NULL, '66.249.79.206', '2025-12-11 06:03:31'),
(163, 22, NULL, '43.166.136.202', '2025-12-11 13:45:18'),
(164, 22, 6, '118.179.33.169', '2025-12-11 19:05:54'),
(165, 22, NULL, '92.222.104.198', '2025-12-12 07:15:52'),
(166, 9, NULL, '92.222.108.97', '2025-12-12 07:27:44'),
(167, 5, NULL, '92.222.104.194', '2025-12-12 07:39:04'),
(168, 16, NULL, '92.222.108.113', '2025-12-12 07:50:30'),
(169, 15, NULL, '54.37.118.73', '2025-12-12 08:02:08'),
(170, 14, NULL, '92.222.104.218', '2025-12-12 08:13:35'),
(171, 13, NULL, '37.59.204.141', '2025-12-12 08:24:25'),
(172, 12, NULL, '54.37.118.64', '2025-12-12 08:35:50'),
(173, 11, NULL, '92.222.104.223', '2025-12-12 08:48:51'),
(174, 10, NULL, '37.59.204.137', '2025-12-12 09:03:47'),
(175, 22, NULL, '37.111.243.155', '2025-12-12 09:56:25'),
(176, 22, 9, '37.111.243.155', '2025-12-12 10:12:24'),
(177, 22, NULL, '37.111.243.42', '2025-12-12 14:34:04'),
(178, 22, NULL, '37.111.243.42', '2025-12-12 14:34:42'),
(179, 22, NULL, '37.111.243.42', '2025-12-12 16:08:38'),
(180, 22, NULL, '37.111.243.42', '2025-12-12 16:33:07'),
(181, 22, NULL, '37.111.243.42', '2025-12-12 16:33:08'),
(182, 22, NULL, '37.111.243.42', '2025-12-12 16:43:29'),
(183, 22, NULL, '37.111.243.12', '2025-12-13 00:34:08'),
(184, 22, 10, '37.111.243.12', '2025-12-13 00:53:40'),
(185, 22, NULL, '162.120.184.226', '2025-12-13 01:54:52'),
(186, 22, NULL, '192.178.8.73', '2025-12-13 01:54:54'),
(187, 22, NULL, '192.178.8.64', '2025-12-13 01:54:54'),
(188, 22, NULL, '37.111.243.77', '2025-12-13 22:36:28'),
(189, 22, 10, '27.147.191.120', '2025-12-13 23:35:46');

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

--
-- Table structure for table `guest_billing_addresses`
--

CREATE TABLE `guest_billing_addresses` (
  `id` int(11) NOT NULL,
  `address_line1` varchar(255) NOT NULL,
  `address_line2` varchar(255) DEFAULT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) DEFAULT NULL COMMENT 'State/Province, or Bangladesh district',
  `zip_code` varchar(20) NOT NULL,
  `country` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `guest_billing_addresses`
--

INSERT INTO `guest_billing_addresses` (`id`, `address_line1`, `address_line2`, `city`, `state`, `zip_code`, `country`) VALUES
(1, 'test', '', 'rajshahi', 'rajshahi', '6310', 'BD'),
(2, 'dfg', 'sde', 'Rajshshi', 'wer', '3453', 'BD'),
(3, 'werty', 'ert', 'Rajshshi', 'wer', '3453', 'BD'),
(4, 'zsdx', 'sde', 'Rajshshi', 'wer', '3453', 'BD');

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

--
-- Table structure for table `guest_shipping_addresses`
--

CREATE TABLE `guest_shipping_addresses` (
  `id` int(11) NOT NULL,
  `address_line1` varchar(255) NOT NULL,
  `address_line2` varchar(255) DEFAULT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) DEFAULT NULL COMMENT 'State/Province, or Bangladesh district',
  `zip_code` varchar(20) NOT NULL,
  `country` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `guest_shipping_addresses`
--

INSERT INTO `guest_shipping_addresses` (`id`, `address_line1`, `address_line2`, `city`, `state`, `zip_code`, `country`) VALUES
(2, 'test', '', 'rajshahi', 'rajshahi', '6310', 'BD');

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

--
-- Table structure for table `ip_blocklist`
--

CREATE TABLE `ip_blocklist` (
  `id` int(11) NOT NULL,
  `ip` varbinary(16) NOT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `added_by` int(11) DEFAULT 0,
  `added_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ip_blocklist`
--

INSERT INTO `ip_blocklist` (`id`, `ip`, `reason`, `added_by`, `added_at`) VALUES
(2, 0x256ff352, '', 1, '2025-12-05 08:30:46');

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

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `attempt_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `login_attempts`
--

INSERT INTO `login_attempts` (`id`, `ip_address`, `attempt_time`) VALUES
(2, '103.87.251.255', '2025-09-02 14:48:47'),
(3, '103.87.251.255', '2025-09-02 14:49:08'),
(6, '37.111.243.227', '2025-09-04 14:46:36');

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

--
-- Table structure for table `login_logs`
--

CREATE TABLE `login_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `user_agent` text NOT NULL COMMENT 'Browser and OS information of the user',
  `login_time` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `login_logs`
--

INSERT INTO `login_logs` (`id`, `user_id`, `ip_address`, `user_agent`, `login_time`) VALUES
(1, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-02 13:40:38'),
(2, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-02 13:55:02'),
(3, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-02 15:03:55'),
(4, 1, '37.111.243.167', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/140.0.7339.101 Mobile/15E148 Safari/604.1', '2025-09-06 17:37:39'),
(5, 1, '59.153.18.189', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/140.0.7339.101 Mobile/15E148 Safari/604.1', '2025-09-07 04:47:01'),
(6, 1, '36.255.82.132', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/140.0.7339.101 Mobile/15E148 Safari/604.1', '2025-09-07 13:09:51'),
(7, 1, '36.255.82.132', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/140.0.7339.101 Mobile/15E148 Safari/604.1', '2025-09-07 16:30:21'),
(8, 1, '59.153.18.190', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/140.0.7339.101 Mobile/15E148 Safari/604.1', '2025-09-08 05:52:10'),
(9, 1, '36.255.81.167', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/140.0.7339.101 Mobile/15E148 Safari/604.1', '2025-09-08 14:38:42'),
(10, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-08 23:30:13'),
(11, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 00:05:34'),
(12, 1, '118.179.33.166', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-09 00:33:20'),
(13, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 00:34:06'),
(14, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 01:59:11'),
(15, 1, '118.179.33.166', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-09 02:02:56'),
(16, 1, '118.179.33.166', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-09 02:30:38'),
(17, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 02:34:02'),
(18, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 02:37:57'),
(19, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 02:39:55'),
(20, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 02:40:05'),
(21, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 02:40:15'),
(22, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '2025-09-09 03:19:39'),
(23, 1, '36.255.80.170', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Mobile/15E148 Safari/604.1', '2025-09-09 03:24:00'),
(24, 1, '118.179.33.166', 'Mozilla/5.0 (Linux; Android 13; RMX3710 Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/139.0.7258.158 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/523.0.0.53.109;]', '2025-09-09 03:24:05'),
(25, 1, '36.255.80.170', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Mobile/15E148 Safari/604.1', '2025-09-09 03:28:12'),
(26, 1, '36.255.81.141', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Mobile/15E148 Safari/604.1', '2025-09-10 02:29:56'),
(27, 1, '36.255.80.130', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 [FBAN/FBIOS;FBAV/523.0.0.32.108;FBBV/786592955;FBDV/iPhone14,5;FBMD/iPhone;FBSN/iOS;FBSV/18.6.2;FBSS/3;FBCR/;FBID/phone;FBLC/en_GB;FBOP/80]', '2025-09-10 14:35:43'),
(28, 1, '36.255.80.164', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 [FBAN/FBIOS;FBAV/523.0.0.32.108;FBBV/786592955;FBDV/iPhone14,5;FBMD/iPhone;FBSN/iOS;FBSV/18.6.2;FBSS/3;FBCR/;FBID/phone;FBLC/en_GB;FBOP/80]', '2025-09-11 06:48:34'),
(29, 1, '36.255.80.164', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Mobile/15E148 Safari/604.1', '2025-09-11 15:25:13'),
(30, 1, '59.153.18.190', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Mobile/15E148 Safari/604.1', '2025-09-13 02:46:43'),
(31, 1, '36.255.81.227', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Mobile/15E148 Safari/604.1', '2025-09-13 15:25:38'),
(32, 1, '103.137.161.26', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-14 11:41:18'),
(33, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-15 00:07:53'),
(34, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-15 00:38:10'),
(35, 1, '36.255.82.246', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Mobile/15E148 Safari/604.1', '2025-09-15 00:56:07'),
(36, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-15 01:08:50'),
(37, 1, '103.137.161.26', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-15 03:22:43'),
(38, 1, '36.255.83.236', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-16 12:30:23'),
(39, 1, '103.137.161.26', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-16 12:33:07'),
(40, 1, '36.255.83.236', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-16 15:43:51'),
(41, 1, '36.255.83.236', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 [FBAN/FBIOS;FBAV/524.0.0.38.107;FBBV/789599495;FBDV/iPhone14,5;FBMD/iPhone;FBSN/iOS;FBSV/26.0;FBSS/3;FBCR/;FBID/phone;FBLC/en_GB;FBOP/80]', '2025-09-17 05:34:11'),
(42, 1, '36.255.81.164', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-17 12:45:24'),
(43, 1, '103.25.251.214', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-17 14:08:57'),
(44, 1, '36.255.81.164', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-18 00:22:48'),
(45, 1, '36.255.81.205', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-18 15:13:01'),
(46, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-19 04:34:55'),
(47, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-19 05:08:25'),
(48, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-19 05:39:15'),
(49, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-19 06:15:43'),
(50, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-19 06:48:04'),
(51, 1, '36.255.80.198', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-19 15:39:06'),
(52, 1, '36.255.80.195', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-20 04:33:27'),
(53, 1, '59.153.16.225', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-20 12:06:11'),
(54, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-20 13:18:54'),
(55, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-20 13:52:20'),
(56, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-20 14:24:29'),
(57, 1, '36.255.81.205', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-20 14:42:09'),
(58, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-20 14:54:42'),
(59, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-20 15:37:25'),
(60, 1, '36.255.81.221', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-20 16:15:00'),
(61, 1, '36.255.81.241', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-21 14:49:00'),
(62, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 00:33:58'),
(63, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 01:06:25'),
(64, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 01:39:48'),
(65, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 04:44:41'),
(66, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 05:26:58'),
(67, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 06:01:17'),
(68, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 06:39:54'),
(69, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 07:12:49'),
(70, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 07:44:43'),
(71, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-23 08:39:55'),
(72, 1, '36.255.82.136', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-23 14:41:07'),
(73, 1, '118.179.33.166', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-24 04:28:26'),
(74, 1, '36.255.82.136', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-24 04:28:35'),
(75, 1, '59.153.16.227', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-24 11:54:05'),
(76, 1, '36.255.81.190', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-25 15:16:12'),
(77, 1, '36.255.80.244', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-26 12:41:14'),
(78, 1, '36.255.82.168', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-26 14:24:37'),
(79, 1, '36.255.82.136', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-27 11:38:11'),
(80, 1, '36.255.82.136', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-27 11:38:22'),
(81, 1, '36.255.83.206', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-09-27 15:07:34'),
(82, 1, '36.255.81.232', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-27 19:04:54'),
(83, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 00:17:31'),
(84, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 00:48:16'),
(85, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 01:22:01'),
(86, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 01:58:56'),
(87, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 02:37:12'),
(88, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 03:08:47'),
(89, 1, '36.255.81.232', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-28 04:17:13'),
(90, 1, '36.255.81.232', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-28 04:17:26'),
(91, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 05:07:54'),
(92, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 05:40:21'),
(93, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 06:11:05'),
(94, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 07:01:13'),
(95, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 13:05:23'),
(96, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 13:38:36'),
(97, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 14:10:44'),
(98, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 14:41:59'),
(99, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 15:12:14'),
(100, 1, '36.255.81.232', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-28 15:52:01'),
(101, 1, '36.255.81.232', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 16:53:16'),
(102, 1, '36.255.81.232', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 16:56:29'),
(103, 1, '36.255.81.232', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-28 17:27:24'),
(104, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 06:07:51'),
(105, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 06:37:54'),
(106, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 07:14:43'),
(107, 1, '59.153.16.226', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 10:20:17'),
(108, 1, '59.153.16.226', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 12:01:15'),
(109, 1, '36.255.81.201', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 15:26:04'),
(110, 1, '36.255.81.247', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-29 15:27:25'),
(111, 1, '59.153.16.226', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-30 03:31:55'),
(112, 1, '59.153.16.227', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Mobile/15E148 Safari/604.1', '2025-09-30 14:15:55'),
(113, 1, '36.255.81.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-30 15:10:03'),
(114, 1, '36.255.81.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-30 15:42:22'),
(115, 1, '36.255.83.201', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-10-01 11:00:44'),
(116, 1, '36.255.81.159', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Mobile/15E148 Safari/604.1', '2025-10-01 16:06:29'),
(117, 1, '36.255.81.159', 'Mozilla/5.0 (iPhone; CPU iPhone OS 26_0_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/141.0.7390.26 Mobile/15E148 Safari/604.1', '2025-10-01 16:07:42'),
(118, 1, '36.255.81.193', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-10-02 01:09:55'),
(119, 1, '36.255.81.165', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Mobile/15E148 Safari/604.1', '2025-10-02 11:42:34'),
(120, 1, '103.136.159.221', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Mobile/15E148 Safari/604.1', '2025-10-03 03:51:12'),
(121, 1, '103.136.159.221', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Mobile/15E148 Safari/604.1', '2025-10-03 03:51:20'),
(122, 1, '202.134.11.230', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Mobile/15E148 Safari/604.1', '2025-10-03 14:39:05'),
(123, 1, '202.134.10.130', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Mobile/15E148 Safari/604.1', '2025-10-04 02:35:40'),
(124, 1, '202.134.10.130', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Mobile/15E148 Safari/604.1', '2025-10-04 12:11:51'),
(125, 1, '202.134.8.194', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', '2025-10-04 12:13:01'),
(126, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-10-05 01:02:38'),
(127, 2, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-10-05 01:08:27'),
(128, 1, '118.179.33.166', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-10-05 01:30:47');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `location` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `location`) VALUES
(1, 'Main Header Menu', 'header'),
(2, 'Footer Quick Links', 'footer'),
(3, 'Support', 'footer1'),
(4, 'category', 'footer2'),
(5, 'Reseller ', 'ifixrom.com');

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

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `url` varchar(2083) NOT NULL,
  `target` varchar(20) NOT NULL DEFAULT '_self',
  `parent_id` int(11) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `type` varchar(20) NOT NULL DEFAULT 'custom',
  `page_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `folder_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `parent_id`, `sort_order`, `type`, `page_id`, `category_id`, `folder_id`) VALUES
(10, 2, 'Contact Us', 'page.php?slug=contact-us', '_self', NULL, 0, 'page', 2, NULL, NULL),
(25, 1, 'Home', 'https://ifixrom.com', '_self', NULL, 0, 'custom', NULL, NULL, NULL),
(26, 1, 'Request Files', 'https://ifixrom.com/request-custom-files.php', '_self', NULL, 2, 'custom', NULL, NULL, NULL),
(27, 1, 'Packages & Pricing', 'https://ifixrom.com/downloads-package.php', '_self', NULL, 1, 'custom', NULL, NULL, NULL),
(28, 1, 'Shopping Us', 'https://ifixrom.com/shop.php', '_self', NULL, 4, 'custom', NULL, NULL, NULL),
(30, 1, 'Password Finder', 'https://ifixrom.com/password_finder.php', '_self', NULL, 3, 'custom', NULL, NULL, NULL),
(31, 1, 'Recent File', 'https://ifixrom.com/recent_uploads.php', '_self', NULL, 5, 'custom', NULL, NULL, NULL),
(32, 2, 'About Us', 'page.php?slug=about-us', '_self', NULL, 999, 'page', 1, NULL, NULL),
(33, 2, 'Contact Us', 'page.php?slug=contact-us', '_self', NULL, 999, 'page', 2, NULL, NULL),
(34, 2, 'Terms of Service', 'page.php?slug=terms-of-service', '_self', NULL, 999, 'page', 3, NULL, NULL),
(35, 1, 'Verified Resellers', 'https://ifixrom.com/our_reseller.php', '_self', NULL, 6, 'custom', NULL, NULL, NULL);

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `invoice_number` varchar(50) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `status` enum('pending','processing','completed','cancelled','refunded') NOT NULL DEFAULT 'pending',
  `payment_status` enum('pending','paid','failed','refunded') NOT NULL DEFAULT 'pending',
  `order_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `notes` text DEFAULT NULL,
  `billing_name` varchar(255) DEFAULT NULL,
  `billing_address` text DEFAULT NULL,
  `billing_city` varchar(100) DEFAULT NULL,
  `billing_country` varchar(100) DEFAULT NULL,
  `billing_phone` varchar(50) DEFAULT NULL,
  `shipping_notes` text DEFAULT NULL,
  `discount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL COMMENT 'ID of the product (from packages or files table)',
  `item_type` enum('package','file','custom') NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `package_sales`
--

CREATE TABLE `package_sales` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `purchase_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('pending','completed','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `package_sales`
--

INSERT INTO `package_sales` (`id`, `user_id`, `package_id`, `transaction_id`, `amount`, `purchase_date`, `status`, `created_at`) VALUES
(1, 1, 2, 'txn_1ABC123XYZ', 35.00, '2025-09-23 09:14:27', 'completed', '2025-09-21 05:47:09'),
(2, 2, 3, 'txn_2DEF456ABC', 90.00, '2025-09-23 09:14:27', 'completed', '2025-09-18 05:47:09'),
(4, 1, 4, 'txn_4JKL012GHI', 0.00, '2025-09-23 09:14:27', 'completed', '2025-09-08 05:47:09'),
(5, 2, 1, 'txn_5MNO345JKL', 0.00, '2025-09-23 09:14:27', 'completed', '2025-09-03 05:47:09'),
(7, 5, 4, 'BAL-68F5D7E660F4B', 0.00, '2025-10-20 06:34:14', 'completed', '2025-10-20 06:34:14'),
(8, 5, 1, 'BAL-68F5D88925391', 50.00, '2025-10-20 06:36:57', 'completed', '2025-10-20 06:36:57'),
(9, 5, 2, 'BAL-68F5D8C5E121D', 35.00, '2025-10-20 06:37:57', 'completed', '2025-10-20 06:37:57'),
(10, 5, 1, 'BAL-68F5DA1ED1635', 50.00, '2025-10-20 06:43:42', 'completed', '2025-10-20 06:43:42'),
(11, 7, 1, 'BAL-68F5DA77379DE', 50.00, '2025-10-20 06:45:11', 'completed', '2025-10-20 06:45:11'),
(12, 7, 2, 'BAL-68F5DB538A089', 35.00, '2025-10-20 06:48:51', 'completed', '2025-10-20 06:48:51'),
(13, 7, 1, 'BAL-68F5ED152627E', 50.00, '2025-10-20 08:04:37', 'completed', '2025-10-20 08:04:37'),
(14, 7, 3, 'BAL-68F6268649C83', 90.00, '2025-10-20 12:09:42', 'completed', '2025-10-20 12:09:42'),
(15, 7, 1, 'BAL-68F653920F1D5', 50.00, '2025-10-20 15:21:54', 'completed', '2025-10-20 15:21:54'),
(16, 7, 2, 'BAL-68F6539969DA2', 35.00, '2025-10-20 15:22:01', 'completed', '2025-10-20 15:22:01'),
(17, 8, 2, 'ORD-19-1764496702', 35.00, '2025-11-30 09:58:22', '', '2025-11-30 09:58:22'),
(18, 8, 2, 'ORD-20-1764499005', 35.00, '2025-11-30 10:36:45', '', '2025-11-30 10:36:45'),
(19, 8, 2, 'ORD-22-1764500197', 35.00, '2025-11-30 10:56:37', 'completed', '2025-11-30 10:56:37'),
(20, 7, 2, 'ORD-23-1764515922', 35.00, '2025-11-30 15:18:42', 'completed', '2025-11-30 15:18:42'),
(21, 1, 1, '0', 50.00, '2025-12-07 10:35:45', 'completed', '2025-12-07 10:35:45'),
(22, 1, 16, '0', 50.00, '2025-12-07 10:42:38', 'completed', '2025-12-07 10:42:38'),
(23, 4, 4, '0', 0.00, '2025-12-07 11:03:24', 'completed', '2025-12-07 11:03:24'),
(24, 1, 17, '0', 50.00, '2025-12-08 11:35:23', 'completed', '2025-12-08 11:35:23'),
(25, 1, 1, '0', 50.00, '2025-12-08 11:43:31', 'completed', '2025-12-08 11:43:31'),
(26, 4, 4, '0', 0.00, '2025-12-10 07:45:45', 'completed', '2025-12-10 07:45:45'),
(27, 4, 2, '0', 35.00, '2025-12-10 10:15:49', 'completed', '2025-12-10 10:15:49'),
(28, 4, 1, '0', 50.00, '2025-12-10 10:21:35', 'completed', '2025-12-10 10:21:35'),
(29, 4, 4, '0', 0.00, '2025-12-10 10:23:48', 'completed', '2025-12-10 10:23:48'),
(30, 6, 2, '0', 35.00, '2025-12-10 15:58:16', 'completed', '2025-12-10 15:58:16'),
(31, 6, 1, '0', 50.00, '2025-12-10 18:30:33', 'completed', '2025-12-10 18:30:33'),
(32, 6, 2, '0', 35.00, '2025-12-10 19:21:30', 'completed', '2025-12-10 19:21:30'),
(33, 6, 1, '0', 50.00, '2025-12-11 09:08:49', 'completed', '2025-12-11 09:08:49'),
(34, 4, 17, '0', 50.00, '2025-12-11 09:15:39', 'completed', '2025-12-11 09:15:39'),
(35, 4, 1, 'SWITCH-693A9ED74A793', 0.00, '2025-12-11 10:37:11', 'completed', '2025-12-11 10:37:11'),
(36, 4, 17, 'SWP-693AA19B25287', 0.00, '2025-12-11 10:48:59', 'completed', '2025-12-11 10:48:59'),
(37, 9, 34, '0', 10.00, '2025-12-12 02:08:37', 'completed', '2025-12-12 02:08:37'),
(38, 1, 16, 'SWP-693C45BD4E37C', 0.00, '2025-12-12 16:41:33', 'completed', '2025-12-12 16:41:33'),
(39, 1, 4, 'SWP-693C46053401A', 0.00, '2025-12-12 16:42:45', 'completed', '2025-12-12 16:42:45'),
(40, 1, 1, 'SWP-693C460B7B71E', 0.00, '2025-12-12 16:42:51', 'completed', '2025-12-12 16:42:51'),
(41, 10, 35, '0', 15.00, '2025-12-12 16:51:44', 'completed', '2025-12-12 16:51:44');

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

--
-- Table structure for table `package_subscriptions`
--

CREATE TABLE `package_subscriptions` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `monthly_bandwidth_gb` int(11) NOT NULL DEFAULT 0 COMMENT 'Monthly bandwidth limit in GB. 0 for unlimited.',
  `extra_bw_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is extra bandwidth enabled?',
  `extra_bw_quota_value` int(11) NOT NULL DEFAULT 0 COMMENT 'Quota value for extra bandwidth',
  `extra_bw_quota_unit` varchar(10) NOT NULL DEFAULT 'GB' COMMENT 'Quota unit for extra bandwidth',
  `extra_bw_limit_files` int(11) NOT NULL DEFAULT 0 COMMENT 'File limit for extra bandwidth',
  `extra_bw_file_types` varchar(100) NOT NULL DEFAULT 'all' COMMENT 'Allowed file types for extra bandwidth',
  `fair_usage_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is fair usage policy enabled?',
  `fair_usage_quota_value` int(11) NOT NULL DEFAULT 0 COMMENT 'Quota value for fair usage',
  `fair_usage_quota_unit` varchar(10) NOT NULL DEFAULT 'GB' COMMENT 'Quota unit for fair usage',
  `fair_usage_limit_files` int(11) NOT NULL DEFAULT 0 COMMENT 'File limit for fair usage',
  `validity_days` int(11) NOT NULL DEFAULT 0 COMMENT '0 for unlimited/non-expiring',
  `device_limit` int(11) NOT NULL DEFAULT 0 COMMENT '0 for unlimited',
  `limit_files` int(11) NOT NULL DEFAULT 0 COMMENT '0 for unlimited',
  `limit_file_types` varchar(100) NOT NULL DEFAULT 'all' COMMENT 'e.g., all, video, audio, image',
  `quota_value` int(11) NOT NULL DEFAULT 0 COMMENT 'Bandwidth Quota value. Unit is in quota_unit. 0 for unlimited.',
  `quota_unit` varchar(10) NOT NULL DEFAULT 'GB',
  `is_public` tinyint(1) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 for Inactive, 1 for Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `daily_limit_files` int(11) NOT NULL DEFAULT 0 COMMENT 'Daily file download limit. 0 for unlimited.',
  `daily_quota_value` int(11) NOT NULL DEFAULT 0 COMMENT 'Daily bandwidth quota value (in GB). 0 for unlimited.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `package_subscriptions`
--

INSERT INTO `package_subscriptions` (`id`, `title`, `description`, `price`, `monthly_bandwidth_gb`, `extra_bw_enabled`, `extra_bw_quota_value`, `extra_bw_quota_unit`, `extra_bw_limit_files`, `extra_bw_file_types`, `fair_usage_enabled`, `fair_usage_quota_value`, `fair_usage_quota_unit`, `fair_usage_limit_files`, `validity_days`, `device_limit`, `limit_files`, `limit_file_types`, `quota_value`, `quota_unit`, `is_public`, `status`, `created_at`, `daily_limit_files`, `daily_quota_value`) VALUES
(1, 'Unlimited', 'Unlimited Downloads', 50.00, 0, 0, 0, 'GB', 0, 'all', 0, 0, 'GB', 0, 0, 0, 0, 'all', 0, 'GB', 1, 1, '2025-09-19 10:35:36', 0, 0),
(2, 'Premium', 'Public - Premium Package fits all businesses', 35.00, 100, 0, 0, 'GB', 0, 'all', 0, 0, 'GB', 0, 30, 5, 0, 'all', 110, 'GB', 1, 1, '2025-09-19 10:35:36', 0, 0),
(3, 'Gold', 'Public - Golden Package', 90.00, 500, 0, 0, 'GB', 0, 'all', 0, 0, 'GB', 0, 90, 10, 0, 'all', 0, 'GB', 1, 1, '2025-09-19 10:35:36', 0, 0),
(4, 'Free', 'Public - Free Package', 0.00, 5, 0, 0, 'GB', 0, 'all', 0, 0, 'GB', 0, 365, 1, 10, 'all', 50, 'GB', 1, 1, '2025-09-19 10:35:36', 0, 0),
(15, 'VIP 1', 'HELLO', 600.00, 500, 1, 22, 'GB', 0, 'all', 1, 0, 'GB', 0, 30, 15, 0, 'all', 22, 'GB', 1, 1, '2025-10-20 08:11:48', 0, 0),
(16, 'IFIX STUDENT PACKAGE', 'HELLO TOP PACKAGE', 50.00, 0, 0, 0, 'GB', 0, 'all', 0, 0, 'GB', 0, 165, 10, 34, 'all', 210, 'GB', 1, 1, '2025-11-30 18:10:05', 5, 10),
(17, 'Ifixrom', '', 50.00, 0, 0, 0, '0', 0, '0', 0, 0, 'GB', 0, 0, 0, 60, 'all', 660, 'GB', 1, 1, '2025-12-08 11:34:19', 10, 30),
(35, '1 days package', 'low', 15.00, 0, 0, 0, 'GB', 0, 'all', 0, 0, '0', 0, 2, 2, 17, 'all', 0, 'GB', 1, 1, '2025-12-12 16:40:41', 3, 0);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `author_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `status` enum('published','draft') NOT NULL DEFAULT 'draft',
  `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 `pages`
--

INSERT INTO `pages` (`id`, `author_id`, `title`, `slug`, `content`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'About Us', 'about-us', '<h2>Our Mission</h2><p>Welcome to our website! We are dedicated to providing the best services and products to our customers. Our team is passionate about technology and innovation, and we strive to create solutions that make a difference.</p><h2>Our Team</h2><p>We have a diverse team of experts with a wide range of skills and experience. We believe in collaboration and continuous learning to stay ahead in this fast-paced industry.</p>', 'published', '2025-09-28 05:04:48', '2025-09-28 05:04:48'),
(2, 1, 'Contact Us', 'contact-us', '<h2>Get in Touch</h2><p>We would love to hear from you! Whether you have a question about our products, services, or anything else, our team is ready to answer all your questions.</p><p><strong>Email:</strong> support@example.com<br><strong>Phone:</strong> +1 (123) 456-7890<br><strong>Address:</strong> 123 Innovation Drive, Tech City</p>', 'published', '2025-09-28 05:04:48', '2025-09-28 05:04:48'),
(3, 1, 'Terms of Service', 'terms-of-service', '<h2>1. Introduction</h2><p>Welcome to our website. By accessing and using this website, you agree to comply with and be bound by the following terms and conditions of use, which together with our privacy policy govern our relationship with you in relation to this website.</p><h2>2. Use of the Website</h2><p>The content of the pages of this website is for your general information and use only. It is subject to change without notice. Unauthorized use of this website may give rise to a claim for damages and/or be a criminal offense.</p>', 'published', '2025-09-28 05:04:48', '2025-09-28 05:04:48'),
(4, 2, 'test', 'test', '', 'published', '2025-10-05 05:16:00', '2025-10-05 05:16:00');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `user_id` int(11) NOT NULL COMMENT 'ID of the user requesting the reset',
  `token` varchar(64) NOT NULL COMMENT 'Unique, random token sent via email',
  `expires_at` int(11) NOT NULL COMMENT 'Timestamp when the token expires (e.g., 1 hour from creation)',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` (`user_id`, `token`, `expires_at`, `created_at`) VALUES
(10, 'dc362c29bad5f1c84d34f99363740e7474b277a9ae36df41fa4755331c19995f', 1765565732, '2025-12-12 17:55:32');

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

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `is_installed` tinyint(1) NOT NULL DEFAULT 0,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `name`, `slug`, `description`, `is_installed`, `is_enabled`, `settings`) VALUES
(1, '2Checkout', '2checkout', '2Checkout description.', 0, 0, '{\"account_number\":\"\",\"secret_word\":\"\"}'),
(2, 'Balance', 'balance', 'Use user account balance.', 1, 1, '[]'),
(3, 'Bank Deposit', 'bank_deposit', 'Offline bank deposit.', 0, 0, '{\"bank_details\":\"\"}'),
(4, 'Cash Payment', 'cash_payment', 'Offline cash payment.', 0, 0, '{\"instructions\":\"\"}'),
(5, 'FirstData Payeezy', 'firstdata_payeezy', 'FirstData Payeezy description.', 0, 0, '[]'),
(6, 'Free Checkout', 'free_checkout', 'For orders with a zero total.', 0, 0, '[]'),
(7, 'MasterCard MIGS', 'mastercard_migs', 'MasterCard MIGS description.', 0, 0, '[]'),
(8, 'MasterCard MPGS Redirect', 'mastercard_mpgs', 'MasterCard MPGS Redirect description.', 0, 0, '[]'),
(9, 'PayPal Express Checkout', 'paypal_express', 'PayPal Express Checkout description.', 0, 0, '{\"api_username\":\"\",\"api_password\":\"\",\"api_signature\":\"\"}'),
(10, 'Skrill Quick Checkout', 'skrill', 'Skrill Quick Checkout description.', 0, 0, '[]'),
(11, 'Stripe', 'stripe', 'Stripe description.', 0, 0, '{\"publishable_key\":\"\",\"secret_key\":\"\"}'),
(12, 'Western Union', 'western_union', 'Western Union description.', 0, 0, '[]'),
(13, 'ZarinPal', 'zarinpal', 'ZarinPal description.', 0, 0, '[]'),
(14, 'PayU Money', 'payu_money', 'PayU Money description.', 0, 0, '[]'),
(15, 'Fast-Pay.cash', 'fast_pay', 'Fast-Pay.cash description.', 0, 0, '[]'),
(16, 'PayPal Standard', 'paypal_standard', 'PayPal Standard description.', 0, 0, '{\"paypal_email\":\"\"}'),
(17, 'Payssion', 'payssion', 'Payssion description.', 0, 0, '[]');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL,
  `permission_key` varchar(100) NOT NULL COMMENT 'e.g., manage_users',
  `description` varchar(255) NOT NULL COMMENT 'e.g., Can add, edit, and delete users',
  `category` varchar(50) NOT NULL DEFAULT 'General'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `permission_key`, `description`, `category`) VALUES
(1, 'view_dashboard', 'Can view the main admin dashboard', 'General'),
(2, 'manage_users', 'Can create, edit, and delete users', 'Users'),
(3, 'manage_content', 'Can create, edit, and delete site content', 'Content'),
(4, 'manage_products', 'Can add, edit, and delete products', 'Store'),
(5, 'view_financials', 'Can view orders, invoices, and payment logs', 'Financials'),
(6, 'manage_settings', 'Can edit core site settings', 'Settings'),
(7, 'manage_roles', 'Can edit roles and their permissions', 'Settings'),
(8, 'generate_reports', 'Can generate and view data reports', 'Reports'),
(9, 'manage_discounts', 'Can create and manage discount codes', 'Store'),
(10, 'manage_email_templates', 'Can edit email templates', 'Settings');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(11) NOT NULL,
  `author_id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `status` enum('published','draft') NOT NULL DEFAULT 'draft',
  `published_at` timestamp NULL DEFAULT NULL,
  `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 `posts`
--

INSERT INTO `posts` (`id`, `author_id`, `category_id`, `title`, `slug`, `content`, `featured_image`, `status`, `published_at`, `created_at`, `updated_at`) VALUES
(5, 1, 0, 'Hello', 'hello', '', '', 'published', '2025-12-08 06:12:29', '2025-12-08 14:12:29', '2025-12-08 14:12:29');

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

--
-- Table structure for table `post_categories`
--

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

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

--
-- Table structure for table `post_views`
--

CREATE TABLE `post_views` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL COMMENT 'NULL for guest views',
  `ip_address` varchar(45) NOT NULL,
  `view_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `post_views`
--

INSERT INTO `post_views` (`id`, `post_id`, `user_id`, `ip_address`, `view_date`) VALUES
(1, 1, 1, '203.0.113.10', '2025-09-09 05:58:41'),
(2, 1, 2, '198.51.100.22', '2025-09-09 05:58:41'),
(3, 2, 1, '203.0.113.10', '2025-09-14 05:58:41'),
(4, 1, NULL, '192.0.2.5', '2025-09-15 05:58:41'),
(5, 2, 2, '198.51.100.22', '2025-09-15 05:58:41'),
(6, 3, 1, '203.0.113.10', '2025-09-21 05:58:41'),
(7, 3, NULL, '192.168.1.1', '2025-09-22 05:58:41'),
(8, 2, NULL, '192.0.2.44', '2025-09-22 05:58:41'),
(9, 3, 2, '198.51.100.22', '2025-09-23 05:58:41');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `short_description` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL COMMENT 'Primary Category ID',
  `brand_id` int(11) DEFAULT NULL,
  `product_type` enum('simple','variable') NOT NULL DEFAULT 'simple',
  `custom_badge_text` varchar(50) DEFAULT NULL,
  `show_free_delivery_badge` tinyint(1) NOT NULL DEFAULT 0,
  `is_virtual` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `base_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `sku` varchar(50) DEFAULT NULL,
  `stock_quantity` int(11) NOT NULL DEFAULT 0,
  `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 `products`
--

INSERT INTO `products` (`id`, `title`, `slug`, `short_description`, `description`, `category_id`, `brand_id`, `product_type`, `custom_badge_text`, `show_free_delivery_badge`, `is_virtual`, `is_active`, `base_price`, `sale_price`, `sku`, `stock_quantity`, `created_at`, `updated_at`) VALUES
(4, 'test prodcut test1', 'test-prodcut-test1', '', '', 1, NULL, 'variable', '', 0, 0, 1, 0.00, NULL, NULL, 0, '2025-11-28 10:41:58', '2025-11-28 11:24:56'),
(5, 'test2', 'test2', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, 'qwer', 1, '2025-11-28 11:34:05', '2025-11-28 11:35:03'),
(6, 'testdfdb', 'testdfdb', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, 'qwert', 1, '2025-11-28 12:26:11', '2025-11-28 12:26:11'),
(7, 'twws', 'twws', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, '', 1, '2025-11-28 12:26:33', '2025-11-28 12:26:33'),
(8, 'test test333', 'test-test333', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, '34566', 1, '2025-11-28 16:24:03', '2025-11-28 16:24:03'),
(9, 'test223', 'test223', '', '', NULL, NULL, 'variable', '', 0, 0, 1, 10.00, NULL, NULL, 20, '2025-11-28 16:24:57', '2025-11-30 08:01:11'),
(10, 'sdfghj', 'sdfghj', '', '', NULL, NULL, 'variable', '', 0, 0, 1, 0.10, NULL, NULL, 10, '2025-11-28 16:25:53', '2025-11-30 07:57:18'),
(11, '3456789', '3456789', '', '', NULL, NULL, 'variable', '', 0, 0, 1, 0.00, NULL, NULL, 0, '2025-11-28 16:26:57', '2025-11-28 16:26:57'),
(12, '2345678', '2345678', '', '', NULL, NULL, 'variable', '', 0, 0, 1, 0.00, NULL, NULL, 0, '2025-11-28 16:27:59', '2025-11-28 16:27:59'),
(13, 'test 222', 'test-222', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, '1234567', 1, '2025-11-28 16:40:52', '2025-11-28 16:40:52'),
(14, 'reewewtw', 'reewewtw', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, '2333344', 1, '2025-11-28 16:53:25', '2025-11-28 16:55:37'),
(15, 'werty', 'werty', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, 'wedrtfgy', 1, '2025-11-28 16:59:52', '2025-11-28 17:00:31'),
(17, 'Hello firmware', 'hi', 'Top product', '', 1, NULL, 'simple', '', 0, 1, 0, 0.00, NULL, '', 1, '2025-11-28 17:03:09', '2025-11-28 17:04:50'),
(18, 'wertyu', 'wertyu', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 4.00, NULL, 'wsedrtfy', 1, '2025-11-28 17:34:11', '2025-11-28 18:29:15'),
(19, 'test tesfxdff', 'test-tesfxdff', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 500.00, NULL, 'xdfcgvhj', 1, '2025-11-28 18:25:29', '2025-11-28 18:25:29'),
(20, 'ftgyhj', 'ftgyhj', '', '', NULL, NULL, 'variable', '', 0, 0, 1, 0.10, NULL, NULL, 10, '2025-11-28 18:26:52', '2025-11-30 08:02:02'),
(21, 'sderty', 'sderty', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 0.00, NULL, '', 1, '2025-11-28 18:37:22', '2025-11-28 18:41:30'),
(22, 'w4e5r6t7yui', 'w4e5r6t7yui', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 51.00, NULL, '', 1, '2025-11-28 19:20:49', '2025-11-29 05:54:46'),
(23, 'trewert', 'trewert', '', '<p>zxdcfgv</p>', NULL, NULL, 'simple', '', 0, 0, 1, 50.00, NULL, 'sdfg', 1, '2025-11-29 06:07:53', '2025-11-29 06:07:53'),
(24, 'asdfg', 'asdfg', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 10.00, NULL, '', 0, '2025-11-29 06:10:15', '2025-11-30 09:58:22'),
(25, 'aszdxcfgvbh', 'aszdxcfgvbh', '', '', NULL, NULL, 'simple', '', 0, 0, 1, 2.00, NULL, '', 8, '2025-11-29 06:22:30', '2025-11-30 10:38:24');

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

--
-- Table structure for table `product_attributes`
--

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

--
-- Dumping data for table `product_attributes`
--

INSERT INTO `product_attributes` (`id`, `name`, `created_at`) VALUES
(1, 'size', '2025-11-27 17:53:54'),
(2, 'color', '2025-11-27 18:30:34');

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

--
-- Table structure for table `product_attribute_values`
--

CREATE TABLE `product_attribute_values` (
  `id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  `value` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_attribute_values`
--

INSERT INTO `product_attribute_values` (`id`, `attribute_id`, `value`, `created_at`) VALUES
(1, 1, 'red, green, black', '2025-11-27 17:54:32'),
(3, 2, 'XXL', '2025-11-27 18:57:15'),
(4, 2, 'M', '2025-11-27 18:57:32');

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

--
-- Table structure for table `product_attr_links`
--

CREATE TABLE `product_attr_links` (
  `product_id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_attr_links`
--

INSERT INTO `product_attr_links` (`product_id`, `attribute_id`) VALUES
(4, 2),
(9, 2),
(10, 2),
(11, 2),
(12, 2),
(20, 2);

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) 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 `product_categories`
--

INSERT INTO `product_categories` (`id`, `parent_id`, `name`, `slug`, `description`, `is_active`, `created_at`) VALUES
(1, NULL, 'Iphone', '', '', 1, '2025-11-27 17:57:26');

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

--
-- Table structure for table `product_category_links`
--

CREATE TABLE `product_category_links` (
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_category_links`
--

INSERT INTO `product_category_links` (`product_id`, `category_id`) VALUES
(4, 1),
(17, 1);

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `is_thumbnail` tinyint(1) NOT NULL DEFAULT 0,
  `sort_order` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image_path`, `is_thumbnail`, `sort_order`) VALUES
(7, 9, 'uploads/product_images/1764489043_692bf75376d35.jpg', 1, 0),
(8, 20, 'uploads/product_images/1764488719_692bf60f12f28.png', 1, 0),
(9, 25, 'uploads/product_images/1764488572_692bf57c7efd4.png', 1, 0);

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL COMMENT 'Links to the products table',
  `user_id` int(11) NOT NULL COMMENT 'ID of the user who submitted the review',
  `rating` tinyint(1) NOT NULL COMMENT 'Rating from 1 to 5',
  `comment` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_approved` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = Approved, 0 = Pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_variations`
--

CREATE TABLE `product_variations` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `sku` varchar(50) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `stock_quantity` int(11) NOT NULL DEFAULT 0,
  `image_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_variations`
--

INSERT INTO `product_variations` (`id`, `product_id`, `sku`, `price`, `sale_price`, `stock_quantity`, `image_url`) VALUES
(8, 4, '345r', 1.24, NULL, 10, NULL),
(9, 4, 'wq3er', 1.24, NULL, 10, NULL),
(13, 11, '345678', 0.00, NULL, 10, NULL),
(14, 12, '1234567', 0.03, NULL, 10, NULL),
(20, 10, '34567', 0.10, NULL, 10, NULL),
(21, 9, 'wer567', 10.00, NULL, 10, NULL),
(22, 9, 'ertyu', 10.00, NULL, 10, NULL),
(23, 20, 'wertyu', 0.10, NULL, 10, NULL);

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

--
-- Table structure for table `product_variation_attributes`
--

CREATE TABLE `product_variation_attributes` (
  `variation_id` int(11) NOT NULL,
  `attribute_value_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_variation_attributes`
--

INSERT INTO `product_variation_attributes` (`variation_id`, `attribute_value_id`) VALUES
(8, 4),
(9, 3),
(13, 4),
(14, 4),
(20, 4),
(21, 4),
(22, 3),
(23, 4);

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

--
-- Table structure for table `request_files`
--

CREATE TABLE `request_files` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'ID of the user submitting the request',
  `file_title` varchar(255) NOT NULL COMMENT 'Title or Name of the requested file (e.g., iPhone 13 Pro Max Schematic)',
  `file_type` varchar(50) DEFAULT NULL COMMENT 'Type of file (e.g., Firmware, Tool, Schema)',
  `device_model` varchar(100) DEFAULT NULL COMMENT 'Specific device model (e.g., Samsung J200F)',
  `details` text NOT NULL COMMENT 'Detailed description of the requirement/issue',
  `budget_usd` decimal(10,2) DEFAULT NULL COMMENT 'User''s proposed budget (optional, in USD)',
  `contact_email` varchar(100) NOT NULL,
  `contact_phone` varchar(50) DEFAULT NULL,
  `priority` enum('low','medium','high') NOT NULL DEFAULT 'medium',
  `status` enum('pending','in_progress','completed','rejected') NOT NULL DEFAULT 'pending',
  `requested_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `reseller_settings`
--

CREATE TABLE `reseller_settings` (
  `setting_key` varchar(100) NOT NULL,
  `setting_value` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Value used for percentage or amount, or 1/0 for boolean',
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reseller_settings`
--

INSERT INTO `reseller_settings` (`setting_key`, `setting_value`, `description`) VALUES
('balance_transfer_commission_percent', 1.00, 'Commission percentage Reseller receives when transferring balance to another user.'),
('deposit_commission_percent', 5.00, 'Commission percentage Reseller receives on their own deposits.'),
('enable_deposit_commission', 1.00, '1 to enable deposit commission for resellers.'),
('enable_package_commission', 1.00, '1 to enable package purchase commission for resellers.'),
('enable_transfer_commission', 1.00, '1 to enable balance transfer commission for resellers.'),
('package_purchase_commission_percent', 2.50, 'Commission percentage Reseller receives when buying a package.');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `role_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `role_name`) VALUES
(2, 'Editor'),
(1, 'Super Admin'),
(3, 'Support Staff');

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

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` (`role_id`, `permission_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(2, 1);

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

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

CREATE TABLE `settings` (
  `setting_key` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `settings` (`setting_key`, `setting_value`) VALUES
('automation_abandoned_cart_delay_hours', '24'),
('automation_abandoned_cart_enabled', '1'),
('automation_low_stock_enabled', '1'),
('automation_low_stock_threshold', '5'),
('automation_review_request_delay_days', '7'),
('automation_review_request_enabled', '0'),
('currency_position', 'before'),
('download_link_expiry_hours', '48'),
('download_max_attempts', '5'),
('favicon_url', 'assets/images/favicon_url_1761298541_IMG-20250517-WA0000-e1747653546892-removebg-preview.png'),
('file_delivery_method', 'secure_link'),
('footer_layout', 'detailed'),
('footer_logo_url', 'assets/images/footer_logo_url_1764859608_IMG_3840.png'),
('force_download', '1'),
('header_layout', 'standard'),
('header_logo_url', 'assets/images/header_logo_url_1764858693_IMG_3840.png'),
('layout_style', 'full-width'),
('mailer_method', 'smtp'),
('mail_from_address', 'info@ifixrom.com'),
('mail_from_name', 'IFIX ROM'),
('maintenance_message', '🚧 iFixRom is Under Maintenance 🚧\\\\r\\\\nWe’re currently performing scheduled maintenance to make your experience even better.\\\\r\\\\nDon’t worry — your favorite tested firmware, stock ROMs, and flash tools will be back online very soon!\\\\r\\\\n\\\\r\\\\n⏳ Expected Back Online: [Insert Time/Date]\\\\r\\\\nThank you for your patience and support.\\\\r\\\\n\\\\r\\\\n\\\\r\\\\n---\\\\r\\\\n\\\\r\\\\n🔹 Alternative Stylish Version\\\\r\\\\n\\\\r\\\\n🔧 iFixRom is Getting a Tune-Up! 🔧\\\\r\\\\nWe’re improving our website to serve you faster and safer.\\\\r\\\\nAll your trusted mobile firmware downloads will be available shortly.\\\\r\\\\n\\\\r\\\\nStay tuned & check back soon?'),
('maintenance_mode', 'enabled'),
('products_per_row_desktop', '4'),
('products_per_row_mobile', '2'),
('products_per_row_tablet', '3'),
('seo_meta_description', 'iFixRom provides 100% tested and verified firmware for all mobile brands. Download official stock ROMs, flash files, tools, and drivers safely with fast and secure links. Your trusted source for mobile firmware'),
('seo_meta_keywords', 'ifixrom, mobile firmware, tested firmware, official stock rom, flash file download, android flash file, mobile software, mobile repair files, all brand firmware, mtp firmware, mtk scatter file, qualcomm firmware, qcn file download, samsung flash file, samsung stock rom, xiaomi firmware, miui rom, redmi flash file, oppo flash file, realme stock rom, vivo firmware, infinix firmware, tecno flash file, oneplus stock rom, nokia firmware, huawei flash file, lenovo firmware, lg stock rom, motorola firmware, google pixel firmware, android usb drivers, flash tool download, sp flash tool, odin tool, msm download tool, qpst tool, fastboot rom, unbrick firmware, dead boot repair, imei repair file, firmware update, android stock rom download, secure download link, tested rom download'),
('seo_meta_title', 'iFixRom – Tested Firmware for All Mobile Brands'),
('shop_sidebar_position', 'left'),
('smtp_enabled', '1'),
('smtp_encryption', 'ssl'),
('smtp_host', 'mail.ifixrom.com'),
('smtp_password', '8#{Ao)jn0-9Y'),
('smtp_port', '465'),
('smtp_username', 'info@ifixrom.com'),
('social_facebook', 'https://facebook.com/yourpage'),
('social_instagram', 'https://instagram.com/yourprofile'),
('social_telegram', 'https://t.me/digitalstoreofficial'),
('social_twitter', 'https://twitter.com/yourhandle'),
('store_address_1', '123 ABC Road'),
('store_address_2', 'Apt 4B'),
('store_city', 'Dhaka'),
('store_country', 'Bangladesh'),
('store_currency', 'USD'),
('store_email', 'ifixrom@support.com'),
('store_name', 'iFiX-ROM'),
('store_phone', '+8801782219267'),
('store_state', 'Dhaka'),
('store_zip', '1212'),
('theme_bg_color', '#ffffff'),
('theme_body_font', 'Roboto'),
('theme_heading_font', 'Inter'),
('theme_primary_color', '#60789f'),
('theme_secondary_color', '#831100'),
('theme_text_color', '#ff6a00'),
('timezone', 'Asia/Dhaka');

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

--
-- Table structure for table `shipping_rates`
--

CREATE TABLE `shipping_rates` (
  `id` int(11) NOT NULL,
  `zone_name` varchar(100) NOT NULL COMMENT 'যেমন: ঢাকার মধ্যে, ঢাকার বাইরে',
  `charge` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'ডলার/বেস কারেন্সিতে শিপিং চার্জ',
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `shipping_rates`
--

INSERT INTO `shipping_rates` (`id`, `zone_name`, `charge`, `is_active`) VALUES
(1, 'ঢাকার মধ্যে', 2.00, 1),
(2, 'ঢাকার বাইরে', 4.00, 1);

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

--
-- Table structure for table `simple_products`
--

CREATE TABLE `simple_products` (
  `product_id` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `stock_quantity` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `system_settings`
--

INSERT INTO `system_settings` (`setting_key`, `setting_value`) VALUES
('license_key', 'f16a4fcac24cb1b780ed7b54c9770f70'),
('license_status', 'inactive'),
('module_announcements_status', 'inactive'),
('module_blog_status', 'inactive'),
('module_downloads_status', 'inactive'),
('module_shop_status', 'inactive');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `from_user_id` int(11) DEFAULT NULL,
  `to_user_id` int(11) NOT NULL COMMENT 'যে ব্যবহারকারী টাকা পেয়েছেন তার আইডি',
  `amount` decimal(10,2) NOT NULL COMMENT 'স্থানান্তরিত অর্থের পরিমাণ',
  `notes` text DEFAULT NULL COMMENT 'লেনদেন সম্পর্কে অতিরিক্ত নোট',
  `transaction_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `from_user_id`, `to_user_id`, `amount`, `notes`, `transaction_date`) VALUES
(1, NULL, 1, 100.00, '[Admin Deposit] ', '2025-09-19 05:16:43'),
(2, 2, 1, 5.00, '[Admin Transfer] ', '2025-10-19 06:27:02'),
(3, 2, 1, 4.12, '[Admin Transfer] ', '2025-10-19 06:28:11'),
(4, 2, 1, 0.82, '[Admin Transfer] ', '2025-10-19 06:29:37'),
(5, 2, 1, 0.41, '[Admin Transfer] ', '2025-10-19 06:30:52'),
(6, 2, 1, 7.47, '[Admin Transfer] ', '2025-10-19 06:32:20'),
(7, 2, 1, 10.00, '[Admin Transfer] ', '2025-10-19 23:11:53'),
(8, 2, 1, 3.00, '[Admin Transfer] ', '2025-10-19 23:14:03'),
(9, 6, 5, 10.00, '[Admin Transfer] ', '2025-10-20 05:10:39'),
(10, 6, 5, 10.00, 'Transfer to test1. ', '2025-10-20 05:12:06'),
(11, 6, 5, 10.00, 'Balance transfer from test2', '2025-10-20 05:21:09'),
(12, 7, 6, 50.00, 'rasel', '2025-10-20 07:35:13'),
(13, 7, 6, 100.00, 'rasel', '2025-10-20 07:35:37'),
(14, NULL, 2, 4.12, '[Admin Deposit] ', '2025-11-28 13:50:39'),
(15, NULL, 2, 0.04, '[Admin Deposit] ', '2025-11-28 13:52:01'),
(16, 1, 999, 50.00, 'Package Purchase: Unlimited', '2025-12-07 18:35:45'),
(17, 1, 999, 50.00, 'Package Purchase: IFIX STUDENT PACKAGE', '2025-12-07 18:42:38'),
(18, 1, 999, 50.00, 'Package Purchase: Ifixrom', '2025-12-08 19:35:23'),
(19, 1, 999, 50.00, 'Package Purchase: Unlimited', '2025-12-08 19:43:31'),
(20, 6, 999, 35.00, 'Package Payment: Premium (Purchased for User ID: 4)', '2025-12-10 18:15:49'),
(21, 999, 6, 0.88, 'Reseller Package Commission (2.5%): Premium', '2025-12-10 18:15:49'),
(22, 6, 999, 50.00, 'Package Payment: Unlimited (Purchased for User ID: 4)', '2025-12-10 18:21:35'),
(23, 999, 6, 1.25, 'Reseller Package Commission (2.5%): Unlimited', '2025-12-10 18:21:35'),
(24, 6, 999, 35.00, 'Package Payment: Premium', '2025-12-10 23:58:16'),
(25, 999, 6, 0.88, 'Reseller Package Commission (2.5%): Premium', '2025-12-10 23:58:16'),
(26, 6, 999, 50.00, 'Package Payment: Unlimited', '2025-12-11 02:30:33'),
(27, 999, 6, 1.25, 'Reseller Package Commission (2.5%): Unlimited', '2025-12-11 02:30:33'),
(28, 6, 999, 35.00, 'Package Payment: Premium', '2025-12-11 03:21:30'),
(29, 999, 6, 0.88, 'Reseller Package Commission (2.5%): Premium', '2025-12-11 03:21:30'),
(30, 6, 999, 50.00, 'Package Payment: Unlimited', '2025-12-11 17:08:49'),
(31, 999, 6, 1.25, 'Reseller Package Commission (2.5%): Unlimited', '2025-12-11 17:08:49'),
(32, 6, 999, 50.00, 'Package Payment: Ifixrom (Purchased for User: test22)', '2025-12-11 17:15:39'),
(33, 999, 6, 1.25, 'Reseller Package Commission (2.5%): Ifixrom', '2025-12-11 17:15:39'),
(34, 4, 999, 0.00, 'Switch Package: Ifixrom (Sale ID: 36)', '2025-12-11 18:48:59'),
(35, 6, 4, 10.00, 'Balance transfer to test22', '2025-12-11 19:03:01'),
(36, 999, 6, 0.10, 'Reseller Transfer Bonus (1%): Transfer to test22', '2025-12-11 19:03:01'),
(37, 9, 999, 10.00, 'Package Payment: 1 Days Package', '2025-12-12 10:08:37'),
(38, 1, 999, 0.00, 'Switch Package: IFIX STUDENT PACKAGE (Sale ID: 38)', '2025-12-13 00:41:33'),
(39, 1, 999, 0.00, 'Switch Package: Free (Sale ID: 39)', '2025-12-13 00:42:45'),
(40, 1, 999, 0.00, 'Switch Package: Unlimited (Sale ID: 40)', '2025-12-13 00:42:51'),
(41, 10, 999, 15.00, 'Package Payment: 1 days package', '2025-12-13 00:51:44');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `phone_country_code` varchar(10) DEFAULT NULL,
  `phone_number` varchar(50) DEFAULT NULL,
  `address_line_1` varchar(255) DEFAULT NULL,
  `address_line_2` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `password` varchar(255) NOT NULL COMMENT 'সর্বদা হ্যাশ করা পাসওয়ার্ড সংরক্ষণ করুন',
  `user_type` enum('user','reseller') NOT NULL DEFAULT 'user',
  `balance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'ব্যবহারকারীর অ্যাকাউন্টের ব্যালেন্স',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `user_2fa`
--

CREATE TABLE `user_2fa` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `provider` enum('email','google') NOT NULL,
  `secret` varchar(255) DEFAULT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `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 `user_2fa`
--

INSERT INTO `user_2fa` (`id`, `user_id`, `provider`, `secret`, `is_enabled`, `created_at`, `updated_at`) VALUES
(1, 5, 'email', NULL, 0, '2025-10-20 06:14:33', '2025-10-20 06:14:41'),
(3, 7, 'email', NULL, 0, '2025-10-20 06:15:10', '2025-10-20 12:12:36'),
(4, 5, 'google', NULL, 0, '2025-10-20 06:15:17', '2025-12-01 17:45:00'),
(6, 7, 'google', 'POGSPTK2FI24IF6V', 1, '2025-10-20 06:24:37', '2025-12-10 19:41:24'),
(12, 4, 'google', 'PBQIXHSKMMFVKP6G', 1, '2025-12-10 19:43:23', '2025-12-10 19:57:12'),
(13, 4, 'email', NULL, 1, '2025-12-10 19:53:16', '2025-12-10 19:56:28'),
(17, 10, 'email', NULL, 0, '2025-12-12 16:48:35', '2025-12-12 17:58:09');

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

--
-- Table structure for table `visitor_logs`
--

CREATE TABLE `visitor_logs` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `user_agent` text DEFAULT NULL,
  `page_url` varchar(2083) NOT NULL,
  `referrer_domain` varchar(255) DEFAULT NULL,
  `visit_time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `visitor_logs`
--

INSERT INTO `visitor_logs` (`id`, `ip_address`, `user_agent`, `page_url`, `referrer_domain`, `visit_time`) VALUES
(1, '203.0.113.10', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) ...', '/index.php', 'google.com', '2025-09-23 14:00:00'),
(2, '198.51.100.25', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) ...', '/products.php?id=12', 'facebook.com', '2025-09-23 14:05:00'),
(3, '203.0.113.10', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) ...', '/about.php', 'google.com', '2025-09-23 14:02:00'),
(4, '192.0.2.44', 'Mozilla/5.0 (Linux; Android 13; SM-A536B) ...', '/index.php', NULL, '2025-09-23 15:20:00'),
(5, '198.51.100.25', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) ...', '/index.php', 'facebook.com', '2025-09-23 15:25:00');

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

--
-- Table structure for table `wishlist`
--

CREATE TABLE `wishlist` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'ID of the user who owns this wishlist item',
  `product_id` int(11) NOT NULL COMMENT 'ID of the product added to the wishlist',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wishlist`
--

INSERT INTO `wishlist` (`id`, `user_id`, `product_id`, `created_at`) VALUES
(1, 8, 10, '2025-11-29 16:24:37'),
(2, 7, 12, '2025-11-30 18:14:08');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `asset_folders`
--
ALTER TABLE `asset_folders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parent_id` (`parent_id`);

--
-- Indexes for table `asset_package_links`
--
ALTER TABLE `asset_package_links`
  ADD PRIMARY KEY (`asset_id`,`asset_type`,`package_id`);

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sort_order` (`sort_order`);

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

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

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

--
-- Indexes for table `customer_feedback`
--
ALTER TABLE `customer_feedback`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `package_id` (`package_id`);

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

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

--
-- Indexes for table `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_files_folder_base` (`folder_id`);

--
-- Indexes for table `file_downloads`
--
ALTER TABLE `file_downloads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `file_reviews`
--
ALTER TABLE `file_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `file_views`
--
ALTER TABLE `file_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id_index` (`file_id`),
  ADD KEY `user_id_index` (`user_id`);

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

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

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

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

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

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

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_id` (`menu_id`),
  ADD KEY `parent_id` (`parent_id`);

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

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`);

--
-- Indexes for table `package_sales`
--
ALTER TABLE `package_sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `package_id` (`package_id`);

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`token`),
  ADD KEY `user_id` (`user_id`);

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

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

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

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

--
-- Indexes for table `post_views`
--
ALTER TABLE `post_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `user_id` (`user_id`);

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

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

--
-- Indexes for table `product_attribute_values`
--
ALTER TABLE `product_attribute_values`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `attr_val_unique` (`attribute_id`,`value`);

--
-- Indexes for table `product_attr_links`
--
ALTER TABLE `product_attr_links`
  ADD PRIMARY KEY (`product_id`,`attribute_id`),
  ADD KEY `attribute_id` (`attribute_id`);

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

--
-- Indexes for table `product_category_links`
--
ALTER TABLE `product_category_links`
  ADD PRIMARY KEY (`product_id`,`category_id`),
  ADD KEY `category_id` (`category_id`);

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

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

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

--
-- Indexes for table `product_variation_attributes`
--
ALTER TABLE `product_variation_attributes`
  ADD PRIMARY KEY (`variation_id`,`attribute_value_id`),
  ADD KEY `attribute_value_id` (`attribute_value_id`);

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

--
-- Indexes for table `reseller_settings`
--
ALTER TABLE `reseller_settings`
  ADD PRIMARY KEY (`setting_key`);

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

--
-- Indexes for table `role_permissions`
--
ALTER TABLE `role_permissions`
  ADD PRIMARY KEY (`role_id`,`permission_id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `permission_id` (`permission_id`);

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

--
-- Indexes for table `shipping_rates`
--
ALTER TABLE `shipping_rates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `zone_name_unique` (`zone_name`);

--
-- Indexes for table `simple_products`
--
ALTER TABLE `simple_products`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `system_settings`
--
ALTER TABLE `system_settings`
  ADD PRIMARY KEY (`setting_key`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `from_user_id` (`from_user_id`),
  ADD KEY `to_user_id` (`to_user_id`);

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

--
-- Indexes for table `user_2fa`
--
ALTER TABLE `user_2fa`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_provider_unique` (`user_id`,`provider`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `visitor_logs`
--
ALTER TABLE `visitor_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visit_time` (`visit_time`),
  ADD KEY `ip_address` (`ip_address`);

--
-- Indexes for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_product_unique` (`user_id`,`product_id`),
  ADD KEY `product_id` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `addresses`
--
ALTER TABLE `addresses`
  ADD CONSTRAINT `fk_addresses_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_feedback`
--
ALTER TABLE `customer_feedback`
  ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `package_subscriptions` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `fk_files_folder_1` FOREIGN KEY (`folder_id`) REFERENCES `asset_folders` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_files_folder_base` FOREIGN KEY (`folder_id`) REFERENCES `asset_folders` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD CONSTRAINT `fk_resets_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

