INSERT INTO `paymentmethods` (`methodId`, `methodName`, `methodLogo`, `methodVisibleName`, `methodCallback`, `methodMin`, `methodMax`, `methodFee`, `methodBonusPercentage`, `methodBonusStartAmount`, `methodCurrency`, `methodStatus`, `methodExtras`, `methodPosition`, `methodInstructions`) VALUES
(69, 'NagorikPay', 'https://nagorikpay.com/public/assets/img/logo.png', 'বিকাশ - নগদ - রকেট [ For Bangladeshi User ] Min 0.2$', 'nagorikpay', 1, 1000, 0, 0, 0, 'BDT', '0', '{\"api_key\":\"SgCLvAaj4W9SHGnTH0UBcjptC3NBVCuvuYPjDMrbACzeP1B5qM\",\"exchange_rate\":\"126\"}', 5, '&lt;h4 class=&quot;ql-align-center&quot;&gt;&lt;strong&gt;Bkash / Nagad / Rocket Dollar Add&lt;/strong&gt;&lt;/h4&gt;&lt;h4 class=&quot;ql-align-center&quot;&gt;&lt;strong&gt;Fully Automatic&amp;nbsp;&lt;/strong&gt;&lt;/h4&gt;&lt;p&gt;&lt;strong&gt;★ 1 ডলার = 126&amp;nbsp;টাকা।&amp;nbsp;&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;★ সর্বনিস্ন 0.2 ডলার = 25.2 টাকা যোগ করা যাবে।&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;♻️ আপনি চাইলে ১.২$ / ২.৮৫$ এভাবে খুচরা ডলার যোগ করতে পারবেন।&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;🔥 ডলার যোগ করার নিয়ম সম্পুর্ন অটোমেটিক। যদি কখনো ডলার যোগ করতে গিয়ে সমস্যায় পরেন তাহলে দ্রুততম &lt;/strong&gt;&lt;a href=&quot;https://wa.me/+8801777822864&quot; target=&quot;_blank&quot; style=&quot;color: rgb(0, 123, 255); background-color: transparent;&quot;&gt;&lt;strong&gt;Wh&lt;/strong&gt;&lt;/a&gt;&lt;strong style=&quot;color: rgb(0, 123, 255); background-color: transparent;&quot;&gt;atsapp&lt;/strong&gt;&lt;strong&gt;&amp;nbsp;যোগাযোগ করবেন,ধন্যবাদ।&amp;nbsp;&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Bonus:&amp;nbsp;$50 = 1% $100=2% , $300=3% , $500=4%, $1k=5%,&lt;/strong&gt;&lt;/p&gt;'),
(100, 'Manual One', 'https://i.ibb.co/sjHv219/image.png', '₿ 𝐁𝐢𝐧𝐚𝐧𝐜𝐞 𝐏𝐚𝐲 [ 𝗠𝗮𝗻𝘂𝗮𝗹 ] 𝐌𝐢𝐧 - 𝟏$ [ 3-5％ 𝐁𝐨𝐧𝐮𝐬 ]', NULL, 1, 1, 0, 0, 0, NULL, '1', NULL, 4, ''),
(101, 'Manual Two', 'https://i.ibb.co/sjHv219/image.png', 'Manual Two', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 18, NULL),
(102, 'Manual Three', 'https://i.ibb.co/sjHv219/image.png', 'Manual Three', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 22, ''),
(103, 'Manual Four', 'https://i.ibb.co/sjHv219/image.png', 'Testing', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 3, ''),
(104, 'Manual Five', 'https://i.ibb.co/sjHv219/image.png', 'Manual Five', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 18, NULL),
(105, 'Manual Six', 'https://i.ibb.co/sjHv219/image.png', 'Manual Six', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 19, NULL),
(106, 'Manual Seven', 'https://i.ibb.co/sjHv219/image.png', 'Manual Seven', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 20, NULL),
(107, 'Manual Eight', 'https://i.ibb.co/sjHv219/image.png', 'Manual Eight', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 21, NULL),
(108, 'Manual Nine', 'https://i.ibb.co/sjHv219/image.png', 'Manual Nine', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 5, NULL),
(109, 'Manual Ten', 'https://i.ibb.co/sjHv219/image.png', 'Manual Ten', NULL, 1, 1, 0, 0, 0, NULL, '0', NULL, 23, NULL);

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

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

CREATE TABLE `payments` (
  `payment_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `client_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `payment_amount` decimal(15,4) NOT NULL,
  `payment_privatecode` double DEFAULT NULL,
  `payment_method` int(11) NOT NULL,
  `payment_status` enum('1','2','3') NOT NULL DEFAULT '1',
  `payment_delivery` enum('1','2') NOT NULL DEFAULT '1',
  `payment_note` varchar(255) NOT NULL DEFAULT 'No',
  `payment_mode` enum('Manual','Automatic') NOT NULL DEFAULT 'Automatic',
  `payment_create_date` datetime NOT NULL,
  `payment_update_date` datetime NOT NULL,
  `payment_ip` varchar(225) NOT NULL,
  `payment_extra` text NOT NULL,
  `payment_bank` int(11) NOT NULL,
  `t_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`payment_id`, `client_id`, `client_balance`, `payment_amount`, `payment_privatecode`, `payment_method`, `payment_status`, `payment_delivery`, `payment_note`, `payment_mode`, `payment_create_date`, `payment_update_date`, `payment_ip`, `payment_extra`, `payment_bank`, `t_id`) VALUES
(1, 1, 0.00, 2.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-17 18:31:06', '0000-00-00 00:00:00', '103.147.162.143', 'c1ebf5237089e59c0c5ed71fa41a181c', 0, NULL),
(2, 1, 0.00, 5.0000, NULL, 1, '3', '2', 'No', 'Manual', '2025-01-18 09:13:55', '0000-00-00 00:00:00', '103.147.162.143', '', 0, NULL),
(3, 1, 0.00, 1.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-18 21:37:31', '0000-00-00 00:00:00', '103.147.162.143', 'e892c5a3d1ae11208fb7f933779a2942', 0, NULL),
(4, 1, 0.00, 1.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-19 09:00:41', '0000-00-00 00:00:00', '103.147.162.143', '7527af39b3e7fbda343b093d22d05080', 0, NULL),
(5, 1, 0.00, 1.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-19 09:02:28', '0000-00-00 00:00:00', '103.147.162.143', '7ba68a2c249956a991af3b0b2a95345b', 0, NULL),
(6, 1, 0.00, 1.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-19 09:50:25', '0000-00-00 00:00:00', '103.147.162.143', 'ec8e5bf16b404f07b96bff3bfab33a1e', 0, NULL),
(7, 1, 4.98, 1.0000, NULL, 69, '3', '2', 'No', 'Automatic', '2025-01-19 09:52:23', '0000-00-00 00:00:00', '103.147.162.143', '3929614c9fb3e63e3844597f3e5f879a', 0, NULL),
(8, 1, 0.00, 1.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-19 09:59:19', '0000-00-00 00:00:00', '103.147.162.143', 'fb94cd7097c8280f6072ba386be63f3a', 0, NULL),
(9, 9, 0.00, 1.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-19 13:33:31', '0000-00-00 00:00:00', '202.134.10.130', 'c3db71ca1959e70e345ee9797eaf6c29', 0, NULL),
(10, 7, 0.00, 0.1200, NULL, 69, '3', '2', 'No', 'Manual', '2025-01-19 16:03:02', '0000-00-00 00:00:00', '103.147.162.143', '', 0, NULL),
(11, 1, 0.00, 2.1000, NULL, 3, '1', '1', 'No', 'Automatic', '2025-01-19 22:29:10', '0000-00-00 00:00:00', '103.147.162.143', 'fd73bae660daec2eb6a37f18eb625a9b', 0, NULL),
(12, 1, 0.00, 1.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-01-20 12:45:58', '0000-00-00 00:00:00', '103.147.162.143', 'e15a9d92cd4ff861dc1abfc892e6b21f', 0, NULL),
(13, 30, 0.00, 1.5700, NULL, 69, '3', '2', 'No', 'Automatic', '2025-01-21 23:51:20', '0000-00-00 00:00:00', '103.231.160.120', 'cbb02bb154fa73097803644a39f68e9c', 0, NULL),
(14, 30, 1.57, 0.0100, NULL, 69, '3', '2', 'No', 'Manual', '2025-01-22 00:15:15', '0000-00-00 00:00:00', '103.147.162.143', '', 0, NULL),
(15, 41, 0.00, 50.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-02-04 14:41:21', '0000-00-00 00:00:00', '39.63.32.92', '778e64e2b86c8fe8fc37eea115ad1aeb', 0, NULL),
(16, 41, 0.00, 50.0000, NULL, 69, '1', '1', 'No', 'Automatic', '2025-02-04 14:41:54', '0000-00-00 00:00:00', '39.63.32.92', '98b769d5303b9ef8e0ae67aa4981142d', 0, NULL),
(17, 43, 0.00, 0.0179, NULL, 9, '3', '2', 'No', 'Automatic', '2025-02-22 00:04:24', '0000-00-00 00:00:00', '203.215.167.45', '075667936807', 0, NULL),
(18, 42, 0.00, 0.1794, NULL, 9, '3', '2', 'No', 'Automatic', '2025-02-22 13:06:32', '0000-00-00 00:00:00', '152.56.69.73', '075663949392', 0, NULL);

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

--
-- Table structure for table `referral`
--

CREATE TABLE `referral` (
  `referral_id` int(11) NOT NULL,
  `referral_client_id` int(11) NOT NULL,
  `referral_clicks` double NOT NULL DEFAULT 0,
  `referral_sign_up` double NOT NULL DEFAULT 0,
  `referral_totalFunds_byReffered` double NOT NULL DEFAULT 0,
  `referral_earned_commision` double DEFAULT 0,
  `referral_requested_commision` varchar(225) DEFAULT '0',
  `referral_total_commision` double DEFAULT 0,
  `referral_status` enum('1','2') NOT NULL DEFAULT '1',
  `referral_code` text NOT NULL,
  `referral_rejected_commision` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `referral`
--

INSERT INTO `referral` (`referral_id`, `referral_client_id`, `referral_clicks`, `referral_sign_up`, `referral_totalFunds_byReffered`, `referral_earned_commision`, `referral_requested_commision`, `referral_total_commision`, `referral_status`, `referral_code`, `referral_rejected_commision`) VALUES
(1, 3, 0, 0, 0, 0, '0', 0, '1', '36a1af', 0),
(2, 5, 0, 0, 0, 0, '0', 0, '1', '08af67', 0),
(3, 6, 0, 0, 0, 0, '0', 0, '1', '7834be', 0),
(4, 7, 0, 0, 0, 0, '0', 0, '1', 'dc4d35', 0),
(5, 8, 0, 0, 0, 0, '0', 0, '1', '543833', 0),
(6, 9, 0, 0, 0, 0, '0', 0, '1', '4a220c', 0),
(7, 10, 0, 0, 0, 0, '0', 0, '1', '464355', 0),
(8, 12, 0, 0, 0, 0, '0', 0, '1', '396ae6', 0),
(9, 21, 0, 0, 0, 0, '0', 0, '1', '07e0dd', 0),
(10, 23, 0, 0, 0, 0, '0', 0, '1', '5b709d', 0),
(11, 25, 0, 0, 0, 0, '0', 0, '1', '796511', 0),
(12, 26, 0, 0, 0, 0, '0', 0, '1', 'c691c8', 0),
(13, 29, 0, 0, 0, 0, '0', 0, '1', '919ae9', 0),
(14, 30, 0, 0, 0, 0, '0', 0, '1', 'e165e7', 0),
(15, 32, 0, 0, 0, 0, '0', 0, '1', '7dfd91', 0),
(16, 35, 0, 0, 0, 0, '0', 0, '1', '923bdc', 0),
(17, 36, 0, 0, 0, 0, '0', 0, '1', '9ad650', 0),
(18, 37, 0, 0, 0, 0, '0', 0, '1', 'a4a2e7', 0),
(19, 38, 0, 0, 0, 0, '0', 0, '1', 'e300ac', 0),
(20, 39, 0, 0, 0, 0, '0', 0, '1', '0598a6', 0),
(21, 40, 0, 0, 0, 0, '0', 0, '1', 'fa3d83', 0),
(22, 41, 0, 0, 0, 0, '0', 0, '1', '41656d', 0),
(23, 42, 0, 0, 0, 0, '0', 0, '1', 'f6ce3e', 0),
(24, 43, 0, 0, 0, 0, '0', 0, '1', 'e9ffc4', 0),
(25, 44, 0, 0, 0, 0, '0', 0, '1', '2c9c7d', 0),
(26, 45, 0, 0, 0, 0, '0', 0, '1', 'e4de27', 0);

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

--
-- Table structure for table `referral_payouts`
--

CREATE TABLE `referral_payouts` (
  `r_p_id` int(11) NOT NULL,
  `r_p_code` text NOT NULL,
  `r_p_status` enum('1','2','3','4','0') NOT NULL DEFAULT '0',
  `r_p_amount_requested` double NOT NULL,
  `r_p_requested_at` datetime NOT NULL,
  `r_p_updated_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `refill_status`
--

CREATE TABLE `refill_status` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `refill_apiid` int(11) DEFAULT NULL,
  `order_url` text NOT NULL,
  `creation_date` datetime DEFAULT NULL,
  `ending_date` date DEFAULT NULL,
  `service_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `refill_status` varchar(255) DEFAULT 'Pending',
  `order_apiid` int(11) DEFAULT 0,
  `refill_response` text DEFAULT NULL,
  `refill_where` enum('site','api') DEFAULT 'site'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `serviceapi_alert`
--

CREATE TABLE `serviceapi_alert` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `serviceapi_alert` text NOT NULL,
  `servicealert_extra` text NOT NULL,
  `servicealert_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

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

CREATE TABLE `services` (
  `service_id` int(11) NOT NULL,
  `service_api` int(11) NOT NULL DEFAULT 0,
  `api_service` int(11) NOT NULL DEFAULT 0,
  `api_servicetype` enum('1','2') NOT NULL DEFAULT '2',
  `api_detail` text NOT NULL,
  `category_id` int(11) NOT NULL,
  `service_line` double NOT NULL,
  `service_type` enum('1','2') NOT NULL DEFAULT '2',
  `service_package` enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17') NOT NULL,
  `service_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `service_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `service_price` varchar(225) NOT NULL,
  `service_min` double NOT NULL,
  `service_max` double NOT NULL,
  `service_dripfeed` enum('1','2') NOT NULL DEFAULT '1',
  `service_autotime` double NOT NULL DEFAULT 0,
  `service_autopost` double NOT NULL DEFAULT 0,
  `service_speed` enum('1','2','3','4') NOT NULL,
  `want_username` enum('1','2') NOT NULL DEFAULT '1',
  `service_secret` enum('1','2') NOT NULL DEFAULT '2',
  `price_type` enum('normal','percent','amount') NOT NULL DEFAULT 'normal',
  `price_cal` text DEFAULT NULL,
  `instagram_second` enum('1','2') NOT NULL DEFAULT '2',
  `start_count` enum('none','instagram_follower','instagram_photo','') NOT NULL,
  `instagram_private` enum('1','2') NOT NULL,
  `name_lang` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `description_lang` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `time_lang` varchar(225) NOT NULL DEFAULT 'New Service',
  `time` varchar(225) NOT NULL DEFAULT 'New Service',
  `cancelbutton` enum('1','2') NOT NULL DEFAULT '2' COMMENT '1 -> ON, 2 -> OFF',
  `show_refill` enum('true','false') NOT NULL DEFAULT 'false',
  `service_profit` varchar(225) NOT NULL,
  `refill_days` varchar(225) NOT NULL DEFAULT '30',
  `refill_hours` varchar(225) NOT NULL DEFAULT '24',
  `avg_days` int(11) NOT NULL,
  `avg_hours` int(11) NOT NULL,
  `avg_minutes` int(11) NOT NULL,
  `avg_many` int(11) NOT NULL,
  `price_profit` int(11) NOT NULL,
  `service_overflow` int(11) NOT NULL DEFAULT 0,
  `service_sync` enum('0','1') NOT NULL DEFAULT '1',
  `service_deleted` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`service_id`, `service_api`, `api_service`, `api_servicetype`, `api_detail`, `category_id`, `service_line`, `service_type`, `service_package`, `service_name`, `service_description`, `service_price`, `service_min`, `service_max`, `service_dripfeed`, `service_autotime`, `service_autopost`, `service_speed`, `want_username`, `service_secret`, `price_type`, `price_cal`, `instagram_second`, `start_count`, `instagram_private`, `name_lang`, `description_lang`, `time_lang`, `time`, `cancelbutton`, `show_refill`, `service_profit`, `refill_days`, `refill_hours`, `avg_days`, `avg_hours`, `avg_minutes`, `avg_many`, `price_profit`, `service_overflow`, `service_sync`, `service_deleted`) VALUES
(485, 8, 6397, '2', '{\"min\":\"100\",\"max\":\"2147483647\",\"rate\":\"0.0011\",\"currency\":\"USD\"}', 65, 18, '2', '1', 'TikTok Video Views [ Max Unlimited ] | Instant Start | Day 10M [ Cheap ]', '', '0.00143', 100, 2147483647, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"TikTok Video Views [ Max Unlimited ] | Instant Start | Day 10M [ Cheap ]\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'false', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(484, 8, 3084, '2', '{\"min\":\"10\",\"max\":\"200000\",\"rate\":\"0.055\",\"currency\":\"USD\"}', 66, 17, '2', '1', 'TikTok Likes [ Max 200K ] | LQ Profiles | Cancel Enable | 30 Days ♻️ | Day 20K', '', '0.0715', 10, 200000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"TikTok Likes [ Max 200K ] | LQ Profiles | Cancel Enable | 30 Days \\u267b\\ufe0f | Day 20K\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(482, 8, 1480, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.69\",\"currency\":\"USD\"}', 67, 15, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | Lifetime ♻️ | Day 100K 🚀', '', '0.897', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | Lifetime \\u267b\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(483, 8, 3893, '2', '{\"min\":\"10\",\"max\":\"200000\",\"rate\":\"0.051\",\"currency\":\"USD\"}', 66, 16, '2', '1', 'TikTok Likes [ Max 200K ] | LQ Profiles | Cancel Enable | No Refill ⚠️ | Day 20K', '', '0.0663', 10, 200000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"TikTok Likes [ Max 200K ] | LQ Profiles | Cancel Enable | No Refill \\u26a0\\ufe0f | Day 20K\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'false', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(481, 8, 1420, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.66\",\"currency\":\"USD\"}', 67, 14, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 365 Days ♻️ | Day 100K 🚀', '', '0.858', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 365 Days \\u267b\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(473, 8, 6292, '2', '{\"min\":\"10\",\"max\":\"500000\",\"rate\":\"0.80\",\"currency\":\"USD\"}', 77, 6, '2', '1', 'Facebook Page Followers [ Max 500K ] | Low Drop | NR ⚠️ | Day 30K', '', '1.04', 10, 500000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Facebook Page Followers [ Max 500K ] | Low Drop | NR \\u26a0\\ufe0f | Day 30K\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'false', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(474, 8, 6400, '2', '{\"min\":\"100\",\"max\":\"20000\",\"rate\":\"1.0165\",\"currency\":\"USD\"}', 77, 7, '2', '1', 'Facebook Page Followers [ Max 20K ] | HQ Profiles | Non Drop | 30 Days ♻️ | Instant Start | Day 20K', '', '1.32145', 100, 20000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Facebook Page Followers [ Max 20K ] | HQ Profiles | Non Drop | 30 Days \\u267b\\ufe0f | Instant Start | Day 20K\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(475, 8, 1478, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.565\",\"currency\":\"USD\"}', 67, 8, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | No Refill ⚠️ | Day 100K 🚀', '', '0.7345', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | No Refill \\u26a0\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'false', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(476, 8, 465, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.575\",\"currency\":\"USD\"}', 67, 9, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 7 Days ♻️ | Day 100K 🚀', '', '0.7475', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 7 Days \\u267b\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(477, 8, 324, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.585\",\"currency\":\"USD\"}', 67, 10, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 15 Days ♻️ | Day 100K 🚀', '', '0.7605', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 15 Days \\u267b\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(478, 8, 840, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.60\",\"currency\":\"USD\"}', 67, 11, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 30 Days ♻️ | Day 100K 🚀', '', '0.78', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 30 Days \\u267b\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(479, 8, 1083, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.62\",\"currency\":\"USD\"}', 67, 12, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 60 Days ♻️ | Day 100K 🚀', '', '0.806', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 60 Days \\u267b\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(480, 8, 4438, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.64\",\"currency\":\"USD\"}', 67, 13, '2', '1', 'Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 90 Days ♻️ | Day 100K 🚀', '', '0.832', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Tiktok Followers [ Max 1M ] | HQ Profiles | Cancel Enable | 90 Days \\u267b\\ufe0f | Day 100K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(469, 8, 6399, '2', '{\"min\":\"100\",\"max\":\"300000\",\"rate\":\"0.551\",\"currency\":\"USD\"}', 77, 2, '2', '1', 'Facebook Page Followers [ Max 300K ] | Non Drop | No Refill ⚠️ | Instant Start | Day 50K 🚀', '', '0.7163', 100, 300000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Facebook Page Followers [ Max 300K ] | Non Drop | No Refill \\u26a0\\ufe0f | Instant Start | Day 50K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'false', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(470, 8, 5336, '2', '{\"min\":\"100\",\"max\":\"400000\",\"rate\":\"0.6175\",\"currency\":\"USD\"}', 77, 3, '2', '1', 'Facebook Page Followers [ Max 400K ] | Low Drop | NR ⚠️ | Day 20K', '', '0.80275', 100, 400000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Facebook Page Followers [ Max 400K ] | Low Drop | NR \\u26a0\\ufe0f | Day 20K\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'false', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(471, 8, 5337, '2', '{\"min\":\"100\",\"max\":\"500000\",\"rate\":\"0.6365\",\"currency\":\"USD\"}', 77, 4, '2', '1', 'Facebook Page Followers [ Max 500K ] | Non Drop | 30 Days ♻️ | Day 40K', '', '0.82745', 100, 500000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Facebook Page Followers [ Max 500K ] | Non Drop | 30 Days \\u267b\\ufe0f | Day 40K\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(472, 8, 5338, '2', '{\"min\":\"100\",\"max\":\"1000000\",\"rate\":\"0.7505\",\"currency\":\"USD\"}', 77, 5, '2', '1', 'Facebook Page Followers [ Max 1M ] | Non Drop | 60 Days ♻️ | Day 60K', '', '0.97565', 100, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Facebook Page Followers [ Max 1M ] | Non Drop | 60 Days \\u267b\\ufe0f | Day 60K\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'true', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0'),
(468, 8, 6401, '2', '{\"min\":\"10\",\"max\":\"1000000\",\"rate\":\"0.50\",\"currency\":\"USD\"}', 77, 1, '2', '1', 'Facebook Page Followers [ Max 1M ] | Non Drop | No Refill ⚠️ | Instant Start | Day 50K 🚀', '', '0.65', 10, 1000000, '1', 0, 0, '1', '1', '2', 'normal', NULL, '2', 'none', '1', '{\"en\":\"Facebook Page Followers [ Max 1M ] | Non Drop | No Refill \\u26a0\\ufe0f | Instant Start | Day 50K \\ud83d\\ude80\"}', '{\"en\":\"\"}', 'New Service', 'New Service', '2', 'false', '', '30', '24', 0, 0, 0, 0, 30, 0, '1', '0');

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

--
-- Table structure for table `service_api`
--

CREATE TABLE `service_api` (
  `id` int(11) NOT NULL,
  `api_name` varchar(225) NOT NULL,
  `provider_name` varchar(255) NOT NULL,
  `api_url` text NOT NULL,
  `api_key` varchar(225) NOT NULL,
  `api_type` int(11) NOT NULL,
  `api_limit` double NOT NULL DEFAULT 0,
  `currency` varchar(200) DEFAULT NULL,
  `api_alert` enum('1','2') NOT NULL DEFAULT '2' COMMENT '2 -> Gönder, 1 -> Gönderildi',
  `status` enum('1','2') NOT NULL DEFAULT '2',
  `api_sync` enum('0','1') NOT NULL DEFAULT '1',
  `api_login_credentials` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `service_api`
--

INSERT INTO `service_api` (`id`, `api_name`, `provider_name`, `api_url`, `api_key`, `api_type`, `api_limit`, `currency`, `api_alert`, `status`, `api_sync`, `api_login_credentials`) VALUES
(1, 'smmarcade.com', 'jcjhux', 'https://smmarcade.com/api/v2', '3478e78948x94898089889', 1, 10, NULL, '1', '2', '1', '{\"username\":\"\",\"password\":null}');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `site_seo` text NOT NULL,
  `site_title` text DEFAULT NULL,
  `site_description` text DEFAULT NULL,
  `google_verification` varchar(255) DEFAULT NULL,
  `meta_logo` varchar(255) DEFAULT NULL,
  `site_keywords` text DEFAULT NULL,
  `site_logo` text DEFAULT NULL,
  `site_name` text DEFAULT NULL,
  `site_currency` varchar(2555) NOT NULL DEFAULT 'try',
  `site_base_currency` varchar(20) DEFAULT NULL,
  `site_currency_converter` tinyint(1) NOT NULL DEFAULT 0,
  `site_update_rates_automatically` int(11) NOT NULL DEFAULT 0,
  `last_updated_currency_rates` datetime DEFAULT NULL,
  `favicon` text DEFAULT NULL,
  `site_language` varchar(225) NOT NULL DEFAULT 'tr',
  `site_theme` text NOT NULL,
  `site_theme_alt` text DEFAULT NULL,
  `recaptcha` enum('1','2') NOT NULL DEFAULT '1',
  `recaptcha_key` text DEFAULT NULL,
  `recaptcha_secret` text DEFAULT NULL,
  `custom_header` text DEFAULT NULL,
  `custom_footer` text DEFAULT NULL,
  `ticket_system` enum('1','2') NOT NULL DEFAULT '2',
  `register_page` enum('1','2') NOT NULL DEFAULT '2',
  `service_speed` enum('1','2') NOT NULL,
  `service_list` enum('1','2') NOT NULL,
  `dolar_charge` double NOT NULL,
  `euro_charge` double NOT NULL,
  `smtp_user` text NOT NULL,
  `smtp_pass` text NOT NULL,
  `smtp_server` text NOT NULL,
  `smtp_port` varchar(225) NOT NULL,
  `smtp_protocol` enum('0','ssl','tls') NOT NULL,
  `alert_type` enum('1','2','3') NOT NULL,
  `alert_apimail` enum('1','2') NOT NULL,
  `alert_newmanuelservice` enum('1','2') NOT NULL,
  `alert_newticket` enum('1','2') NOT NULL,
  `alert_apibalance` enum('1','2') NOT NULL,
  `alert_serviceapialert` enum('1','2') NOT NULL,
  `sms_provider` varchar(225) NOT NULL,
  `sms_title` varchar(225) NOT NULL,
  `sms_user` varchar(225) NOT NULL,
  `sms_pass` varchar(225) NOT NULL,
  `sms_validate` enum('0','1') NOT NULL DEFAULT '0' COMMENT '1 -> OK, 0 -> NO',
  `admin_mail` varchar(225) NOT NULL,
  `admin_telephone` varchar(225) NOT NULL,
  `resetpass_page` enum('1','2') NOT NULL,
  `resetpass_sms` enum('1','2') NOT NULL,
  `resetpass_email` enum('1','2') NOT NULL,
  `site_maintenance` enum('1','2') NOT NULL DEFAULT '2',
  `servis_siralama` varchar(255) NOT NULL,
  `bronz_statu` int(11) NOT NULL,
  `silver_statu` int(11) NOT NULL,
  `gold_statu` int(11) NOT NULL,
  `bayi_statu` int(11) NOT NULL,
  `child_panel_nameservers` varchar(255) NOT NULL DEFAULT '{"ns1":"ns1.vipfastpanel.com","ns2":"ns2.vipfastpanel.com"}',
  `childpanel_price` double DEFAULT NULL,
  `snow_effect` enum('1','2') NOT NULL DEFAULT '2',
  `snow_colour` text NOT NULL,
  `promotion` enum('1','2') DEFAULT '2',
  `referral_commision` double NOT NULL,
  `referral_payout` double NOT NULL,
  `referral_status` enum('1','2') NOT NULL DEFAULT '1',
  `childpanel_selling` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 -> OFF , 2 -> ON',
  `tickets_per_user` double NOT NULL DEFAULT 5,
  `name_fileds` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 -> ON, 2 -> NO',
  `skype_feilds` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1 -> ON, 2 -> NO',
  `otp_login` enum('1','2','0') NOT NULL DEFAULT '0',
  `auto_deactivate_payment` enum('1','2') NOT NULL DEFAULT '1',
  `service_avg_time` enum('1','0') NOT NULL DEFAULT '0',
  `alert_orderfail` enum('1','2') NOT NULL DEFAULT '2',
  `alert_welcomemail` enum('1','2') NOT NULL DEFAULT '2',
  `freebalance` enum('1','2') NOT NULL DEFAULT '1',
  `freeamount` double DEFAULT 0,
  `alert_newmessage` enum('1','2') NOT NULL DEFAULT '1',
  `email_confirmation` enum('1','2') NOT NULL DEFAULT '2',
  `resend_max` int(11) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT '1',
  `fundstransfer_fees` varchar(10) NOT NULL,
  `permissions` text DEFAULT NULL,
  `fake_order_service_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `fake_order_min` int(11) DEFAULT NULL,
  `fake_order_max` int(11) DEFAULT NULL,
  `panel_orders` int(11) DEFAULT NULL,
  `panel_orders_pattern` varchar(255) NOT NULL DEFAULT '{"panel_orders_prefix":"","panel_orders_suffix":""}',
  `downloaded_category_icons` tinyint(1) NOT NULL DEFAULT 0,
  `summary_card_background_color` varchar(100) DEFAULT 'theme_colour',
  `google_login` varchar(100) NOT NULL DEFAULT '{"purchased":"1","status":"1"}',
  `services_average_time` tinyint(1) NOT NULL DEFAULT 1,
  `alert_adminlogin` int(11) DEFAULT 1,
  `google_client_id` varchar(255) DEFAULT NULL,
  `google_client_secret` varchar(255) DEFAULT NULL,
  `whatsapp_field` varchar(255) DEFAULT NULL,
  `telegram_field` varchar(255) DEFAULT NULL,
  `website_field` varchar(255) DEFAULT NULL,
  `neworder_display` tinyint(1) DEFAULT 1,
  `sort_by` tinyint(1) DEFAULT 1,
  `timezone` varchar(100) NOT NULL DEFAULT 'UTC',
  `two_factor_auth` tinyint(1) DEFAULT 0,
  `search_enabled` tinyint(1) DEFAULT 0,
  `ticket_replytime` int(11) DEFAULT 180,
  `ticket_form` tinyint(1) DEFAULT 1,
  `ticket_imgupload` tinyint(1) DEFAULT 1,
  `ticket_res` tinyint(1) DEFAULT 1,
  `ticket_autoclose` tinyint(1) DEFAULT 2,
  `ticket_autoclose_time` int(11) DEFAULT NULL,
  `alert_newpayment` int(11) NOT NULL DEFAULT 2,
  `whatsappbutton` tinyint(1) DEFAULT 0,
  `whatsappnumber` varchar(20) DEFAULT NULL,
  `whatsappcolour` varchar(50) DEFAULT NULL,
  `whatsappposition` enum('left','right') DEFAULT 'left',
  `telegrambutton` tinyint(1) DEFAULT 0,
  `telegramusername` varchar(50) DEFAULT NULL,
  `telegramposition` enum('left','right') DEFAULT 'left',
  `theme_bg_img` varchar(255) DEFAULT NULL,
  `alert_newpay` tinyint(1) DEFAULT 1,
  `skype_area` tinyint(1) DEFAULT 0,
  `terms_checkbox` tinyint(1) DEFAULT 0,
  `otp` tinyint(1) DEFAULT 1,
  `neworder_terms` tinyint(1) DEFAULT 1,
  `auto_refill` tinyint(1) DEFAULT 1,
  `ser_sync` tinyint(1) DEFAULT 1,
  `site_timezone` varchar(50) DEFAULT 'UTC'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `settings` (`id`, `site_seo`, `site_title`, `site_description`, `google_verification`, `meta_logo`, `site_keywords`, `site_logo`, `site_name`, `site_currency`, `site_base_currency`, `site_currency_converter`, `site_update_rates_automatically`, `last_updated_currency_rates`, `favicon`, `site_language`, `site_theme`, `site_theme_alt`, `recaptcha`, `recaptcha_key`, `recaptcha_secret`, `custom_header`, `custom_footer`, `ticket_system`, `register_page`, `service_speed`, `service_list`, `dolar_charge`, `euro_charge`, `smtp_user`, `smtp_pass`, `smtp_server`, `smtp_port`, `smtp_protocol`, `alert_type`, `alert_apimail`, `alert_newmanuelservice`, `alert_newticket`, `alert_apibalance`, `alert_serviceapialert`, `sms_provider`, `sms_title`, `sms_user`, `sms_pass`, `sms_validate`, `admin_mail`, `admin_telephone`, `resetpass_page`, `resetpass_sms`, `resetpass_email`, `site_maintenance`, `servis_siralama`, `bronz_statu`, `silver_statu`, `gold_statu`, `bayi_statu`, `child_panel_nameservers`, `childpanel_price`, `snow_effect`, `snow_colour`, `promotion`, `referral_commision`, `referral_payout`, `referral_status`, `childpanel_selling`, `tickets_per_user`, `name_fileds`, `skype_feilds`, `otp_login`, `auto_deactivate_payment`, `service_avg_time`, `alert_orderfail`, `alert_welcomemail`, `freebalance`, `freeamount`, `alert_newmessage`, `email_confirmation`, `resend_max`, `status`, `fundstransfer_fees`, `permissions`, `fake_order_service_enabled`, `fake_order_min`, `fake_order_max`, `panel_orders`, `panel_orders_pattern`, `downloaded_category_icons`, `summary_card_background_color`, `google_login`, `services_average_time`, `alert_adminlogin`, `google_client_id`, `google_client_secret`, `whatsapp_field`, `telegram_field`, `website_field`, `neworder_display`, `sort_by`, `timezone`, `two_factor_auth`, `search_enabled`, `ticket_replytime`, `ticket_form`, `ticket_imgupload`, `ticket_res`, `ticket_autoclose`, `ticket_autoclose_time`, `alert_newpayment`, `whatsappbutton`, `whatsappnumber`, `whatsappcolour`, `whatsappposition`, `telegrambutton`, `telegramusername`, `telegramposition`, `theme_bg_img`, `alert_newpay`, `skype_area`, `terms_checkbox`, `otp`, `neworder_terms`, `auto_refill`, `ser_sync`, `site_timezone`) VALUES
(1, 'The Market Leader We have everything you need to run successful smm panels.', NULL, 'Boost your social media presence with mt smm, the top-rated Pakistan SMM panel offering reliable and affordable services for Instagram, Facebook, Twitter, and more', '', NULL, NULL, '', 'smm', '$', 'USD', 1, 1, '2025-01-28 13:47:01', '', 'en', 'smmgen', 'pink', '1', '', '', '', '', '1', '2', '1', '2', 0, 0, '	', 'Lgb(]4V1gwv%', '', '465', 'ssl', '2', '2', '2', '2', '2', '2', 'bizimsms', '', '', '', '1', '', '', '2', '1', '2', '2', 'asc', 0, 0, 0, 0, '{\"ns1\":\"\",\"ns2\":\"\"}', 0, '2', '', NULL, 0, 0, '1', '1', 2, '2', '2', '0', '1', '1', '2', '2', '1', 0, '2', '2', 0, '0', '', '{\n  \"admin_access\": {\n    \"admin_access\": {\n      \"name\": \"Admin Access\",\n      \"value\": \"admin_access\"\n    },\n    \"users\": {\n      \"name\": \"Users\",\n      \"value\": \"users\"\n    },\n    \"services\": {\n      \"name\": \"Services\",\n      \"value\": \"services\"\n    },\n    \"update-prices\": {\n      \"name\": \"Update Prices\",\n      \"value\": \"update-prices\"\n    },\n    \"bulk\": {\n      \"name\": \"Bulk Services Editor\",\n      \"value\": \"bulk\"\n    },\n    \"bulkc\": {\n      \"name\": \"Bulk Category Editor\",\n      \"value\": \"bulkc\"\n    },\n    \"synced-logs\": {\n      \"name\": \"Seller Sync Logs\",\n      \"value\": \"synced-logs\"\n    },\n    \"orders\": {\n      \"name\": \"Orders\",\n      \"value\": \"orders\"\n    },\n    \"subscriptions\": {\n      \"name\": \"Subscriptions\",\n      \"value\": \"subscriptions\"\n    },\n    \"dripfeed\": {\n      \"name\": \"Dripfeed\",\n      \"value\": \"dripfeed\"\n    },\n    \"tasks\": {\n      \"name\": \"Order Refill and Cancel Tasks\",\n      \"value\": \"tasks\"\n    },\n    \"payments\": {\n      \"name\": \"Payments\",\n      \"value\": \"payments\"\n    },\n    \"tickets\": {\n      \"name\": \"Tickets\",\n      \"value\": \"tickets\"\n    },\n    \"guard_logs\": {\n      \"name\": \"Guard Logs\",\n      \"value\": \"guard_logs\"\n    },\n    \"provider_logs\": {\n      \"name\": \"Provider Logs\",\n      \"value\": \"provider_logs\"\n    }\n  },\n  \"additionals\": {\n    \"additionals\": {\n      \"name\": \"Additionals\",\n      \"value\": \"additionals\"\n    },\n    \"referral\": {\n      \"name\": \"Affiliates\",\n      \"value\": \"referral\"\n    },\n    \"broadcast\": {\n      \"name\": \"Broadcasts\",\n      \"value\": \"broadcast\"\n    },\n    \"logs\": {\n      \"name\": \"Panel Logs\",\n      \"value\": \"logs\"\n    },\n    \"reports\": {\n      \"name\": \"Reports\",\n      \"value\": \"reports\"\n    },\n    \"videop\": {\n      \"name\": \"Promotion\",\n      \"value\": \"videop\"\n    },\n    \"coupon\": {\n      \"name\": \"Coupons\",\n      \"value\": \"coupon\"\n    },\n    \"child-panels\": {\n      \"name\": \"Child Panels\",\n      \"value\": \"child-panels\"\n    },\n    \"updates\": {\n      \"name\": \"Updates\",\n      \"value\": \"updates\"\n    }\n  },\n  \"appearance\": {\n    \"appearance\": {\n      \"name\": \"Appearance\",\n      \"value\": \"appearance\"\n    },\n    \"themes\": {\n      \"name\": \"Themes\",\n      \"value\": \"themes\"\n    },\n    \"new_year\": {\n      \"name\": \"New Year\",\n      \"value\": \"new_year\"\n    },\n    \"pages\": {\n      \"name\": \"Pages\",\n      \"value\": \"pages\"\n    },\n    \"news\": {\n      \"name\": \"Announcements\",\n      \"value\": \"news\"\n    },\n    \"meta\": {\n      \"name\": \"Meta (SEO) Settings\",\n      \"value\": \"meta\"\n    },\n    \"blog\": {\n      \"name\": \"Blogs\",\n      \"value\": \"blog\"\n    },\n    \"menu\": {\n      \"name\": \"Menu\",\n      \"value\": \"menu\"\n    },\n    \"inte\": {\n      \"name\": \"Integrations\",\n      \"value\": \"inte\"\n    },\n    \"language\": {\n      \"name\": \"Languages\",\n      \"value\": \"language\"\n    },\n    \"whatsapp-telegram\": {\n      \"name\": \"WhatsApp & Telegram\",\n      \"value\": \"whatsapp-telegram\"\n    },\n    \"files\": {\n      \"name\": \"Uploaded Images\",\n      \"value\": \"files\"\n    }\n  },\n  \"settings\": {\n    \"settings\": {\n      \"name\": \"Settings\",\n      \"value\": \"settings\"\n    },\n    \"general_settings\": {\n      \"name\": \"General Settings\",\n      \"value\": \"general_settings\"\n    },\n    \"providers\": {\n      \"name\": \"Sellers\",\n      \"value\": \"providers\"\n    },\n    \"payments_settings\": {\n      \"name\": \"Payment Methods\",\n      \"value\": \"payments_settings\"\n    },\n    \"bank_accounts\": {\n      \"name\": \"Bank Accounts\",\n      \"value\": \"bank_accounts\"\n    },\n    \"modules\": {\n      \"name\": \"Modules\",\n      \"value\": \"modules\"\n    },\n    \"subject\": {\n      \"name\": \"Support Settings\",\n      \"value\": \"subject\"\n    },\n    \"payments_bonus\": {\n      \"name\": \"Payment Bonuses\",\n      \"value\": \"payments_bonus\"\n    },\n    \"currency-manager\": {\n      \"name\": \"Site Currency Manager\",\n      \"value\": \"currency-manager\"\n    },\n    \"alert_settings\": {\n      \"name\": \"Notification Settings\",\n      \"value\": \"alert_settings\"\n    },\n    \"site_count\": {\n      \"name\": \"Fake Orders\",\n      \"value\": \"site_count\"\n    },\n    \"manager\": {\n      \"name\": \"Manager\",\n      \"value\": \"manager\"\n    },\n    \"signform\": {\n      \"name\": \"Signform Settings\",\n      \"value\": \"signform\"\n    },\n    \"ticket\": {\n      \"name\": \"Ticket Settings\",\n      \"value\": \"ticket\"\n    },\n    \"feedback\": {\n      \"name\": \"Feedback Settings\",\n      \"value\": \"feedback\"\n    }\n  }\n}', 0, 1, 5, 9, '{\"panel_orders_prefix\":\"\",\"panel_orders_suffix\":\"\"}', 1, 'fixed_colour', '{\"status\":\"0\"}', 1, 2, '350600123084-0iblr034jmrnmr1ji73js0jtm0e0gbhe.apps.googleusercontent.com', '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', '2', '2', '2', 2, 2, '-54000', 0, 1, 10, 1, 1, 2, 2, 1, 2, 0, '', 'Are you available to chat?', 'right', 0, '', 'left', NULL, NULL, 1, 2, NULL, 1, 2, 1, '-28800');

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

--
-- Table structure for table `sync_logs`
--

CREATE TABLE `sync_logs` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `action` varchar(225) NOT NULL,
  `date` datetime NOT NULL,
  `description` varchar(225) NOT NULL,
  `api_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `sync_logs`
--

INSERT INTO `sync_logs` (`id`, `service_id`, `action`, `date`, `description`, `api_id`) VALUES
(1, 5, 'Price Decreased', '2025-01-17 18:21:26', 'Service rate changed from <b>$ 2.91</b> to <b>$ 2.87</b>', 1),
(2, 1, 'Minimum Quantity Increased', '2025-01-17 21:28:30', 'Service minimum quantity increased from <b>10</b> to <b>50</b>', 1),
(3, 1, 'Maximum Quantity Increased', '2025-01-17 21:28:30', 'Service maximum quantity increased from <b>500000</b> to <b>1000000</b>', 1),
(4, 1, 'Minimum Quantity Decreased', '2025-01-17 21:29:29', 'Service minimum quantity decreased from <b>50</b> to <b>10</b>', 1),
(5, 1, 'Maximum Quantity Decreased', '2025-01-17 21:29:29', 'Service maximum quantity decreased from <b>1000000</b> to <b>500000</b>', 1),
(6, 7, 'Price Increased', '2025-01-17 22:23:27', 'Service rate changed from <b>$ 0.0011</b> to <b>$ 0.0112</b>', 1),
(7, 7, 'Price Decreased', '2025-01-17 23:55:36', 'Service rate changed from <b>$ 0.0112</b> to <b>$ 0.0009</b>', 1),
(8, 22, 'Minimum Quantity Increased', '2025-01-18 06:17:13', 'Service minimum quantity increased from <b>10</b> to <b>20</b>', 1),
(9, 22, 'Maximum Quantity Decreased', '2025-01-18 06:17:13', 'Service maximum quantity decreased from <b>500000</b> to <b>20000</b>', 1),
(10, 22, 'Minimum Quantity Decreased', '2025-01-18 06:18:25', 'Service minimum quantity decreased from <b>20</b> to <b>10</b>', 1),
(11, 22, 'Maximum Quantity Increased', '2025-01-18 06:18:25', 'Service maximum quantity increased from <b>20000</b> to <b>5000000</b>', 1),
(12, 12, 'Price Decreased', '2025-01-18 11:11:31', 'Service rate changed from <b>$ 0.0092</b> to <b>$ 0.0086</b>', 1),
(13, 56, 'Price Decreased', '2025-01-18 17:22:23', 'Service rate changed from <b>$ 1.55</b> to <b>$ 1.48</b>', 1),
(14, 1, 'Maximum Quantity Decreased', '2025-01-18 19:14:32', 'Service maximum quantity decreased from <b>500000</b> to <b>100000</b>', 1),
(15, 18, 'Price Decreased', '2025-01-18 21:47:09', 'Service rate changed from <b>$ 1.64</b> to <b>$ 1.63</b>', 1),
(16, 1, 'Maximum Quantity Increased', '2025-01-18 22:27:27', 'Service maximum quantity increased from <b>100000</b> to <b>1000000</b>', 1),
(17, 174, 'Price Increased', '2025-01-19 17:03:36', 'Service rate changed from <b>$ 0.675</b> to <b>$ 1.13</b>', 3),
(18, 13, 'Price Increased', '2025-01-19 17:04:14', 'Service rate changed from <b>$ 0.672</b> to <b>$ 1.12</b>', 1),
(19, 65, 'Price Decreased', '2025-01-19 17:45:18', 'Service rate changed from <b>$ 0.0258</b> to <b>$ 0.0148</b>', 1),
(20, 65, 'Maximum Quantity Decreased', '2025-01-19 17:45:18', 'Service maximum quantity decreased from <b>1000000000</b> to <b>100000000</b>', 1),
(21, 181, 'Price Decreased', '2025-01-19 19:05:33', 'Service rate changed from <b>$ 1.78</b> to <b>$ 1.42</b>', 3),
(22, 181, 'Maximum Quantity Increased', '2025-01-19 19:05:33', 'Service maximum quantity increased from <b>100000</b> to <b>1000000</b>', 3),
(23, 277, 'Price Decreased', '2025-01-21 13:17:30', 'Service rate changed from <b>$ 0.085</b> to <b>$ 0.0636</b>', 1),
(24, 277, 'Maximum Quantity Decreased', '2025-01-21 13:17:30', 'Service maximum quantity decreased from <b>500000</b> to <b>100000</b>', 1);

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `task_id` int(11) NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `task_api` int(11) DEFAULT NULL,
  `task_type` varchar(225) DEFAULT NULL,
  `task_status` varchar(225) DEFAULT 'pending',
  `task_response` text DEFAULT NULL,
  `task_created_at` datetime DEFAULT NULL,
  `task_updated_at` datetime DEFAULT NULL,
  `task_by` text DEFAULT NULL,
  `check_refill_status` int(11) DEFAULT NULL,
  `refill_orderid` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(11) NOT NULL,
  `theme_name` text NOT NULL,
  `theme_dirname` text NOT NULL,
  `theme_extras` text NOT NULL,
  `last_modified` datetime NOT NULL,
  `colour` enum('1','2') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `theme_name`, `theme_dirname`, `theme_extras`, `last_modified`, `colour`) VALUES
(1, 'SIMPLIFY', 'Simplify', '', '2024-12-28 09:32:04', '2'),
(3, 'ETERNITY', 'Eternity', '', '2024-11-26 11:19:23', '2'),
(6, 'SMMXZ', 'smmxz', '', '2024-12-29 01:14:16', '1'),
(7, 'SMMSUN', 'smmsun', '', '2024-12-29 01:14:53', '1'),
(8, 'SMMCUTE', 'smmcute', '', '2024-12-29 01:15:33', '1'),
(9, 'SMMFACE', 'smmface', '', '2024-12-29 01:16:08', '1'),
(10, 'SMMWORLD', 'smmworld', '', '2024-12-29 01:16:36', '1'),
(30, 'SMM X FOLLOWS', 'dce0902e', '', '2024-12-30 10:27:10', '1'),
(12, 'TECH-SMM', 'techsmm', '', '2025-01-17 07:53:57', '1'),
(13, 'SMMSUN-V2', 'smmsun-v2', '', '2024-12-27 03:09:55', '1'),
(14, 'RENTAL-V2.0', 'rental-v2', '', '2024-12-29 10:21:43', '2'),
(15, 'GROWFOLLOW', 'growfollows', '', '2024-12-29 11:22:34', '2'),
(16, 'SMMGEN V2.0', 'smmgen', '', '2024-12-28 07:34:04', '2'),
(17, 'RENTAL V3', 'dilsmm', '', '2025-01-01 07:25:37', '2'),
(31, 'New Theme -837CCCD8', '837cccd8', '', '2025-01-17 13:58:54', '1'),
(32, 'New Theme -14A9921F', '14a9921f', '', '2025-01-21 07:45:40', '1'),
(33, 'New Theme -2E6EC0A3', '2e6ec0a3', '', '2025-01-18 13:48:39', '1'),
(34, 'New Theme -A2ECD90B', 'a2ecd90b', '', '2025-01-24 17:39:01', '1');

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

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

CREATE TABLE `tickets` (
  `ticket_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `subject` varchar(225) NOT NULL,
  `time` datetime NOT NULL,
  `lastupdate_time` datetime NOT NULL,
  `client_new` enum('1','2') NOT NULL DEFAULT '2',
  `status` enum('pending','answered','closed') NOT NULL DEFAULT 'pending',
  `support_new` enum('1','2') NOT NULL DEFAULT '1',
  `canmessage` enum('1','2') NOT NULL DEFAULT '2',
  `image_url` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `tickets` (`ticket_id`, `client_id`, `subject`, `time`, `lastupdate_time`, `client_new`, `status`, `support_new`, `canmessage`, `image_url`) VALUES
(1, 1, 'Order', '2025-01-17 20:32:52', '2025-01-17 20:32:52', '1', 'closed', '1', '1', NULL);

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

--
-- Table structure for table `ticket_reply`
--

CREATE TABLE `ticket_reply` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `time` datetime NOT NULL,
  `support` enum('1','2') NOT NULL DEFAULT '1',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `readed` enum('1','2') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ticket_reply`
--

INSERT INTO `ticket_reply` (`id`, `ticket_id`, `client_id`, `time`, `support`, `message`, `image_path`, `readed`) VALUES
(1, 1, 0, '2025-01-17 20:32:52', '1', 'test', NULL, '1');

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

--
-- Table structure for table `ticket_subjects`
--

CREATE TABLE `ticket_subjects` (
  `subject_id` int(11) NOT NULL,
  `subject` varchar(225) NOT NULL,
  `content` text DEFAULT NULL,
  `auto_reply` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `ticket_subjects`
--

INSERT INTO `ticket_subjects` (`subject_id`, `subject`, `content`, `auto_reply`) VALUES
(1, 'Order', '', '0'),
(2, 'Payment', '', '0'),
(4, 'Complaint & Suggestion', '', '0'),
(6, 'Others', 'You will be answered within minutes', '1');

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

--
-- Table structure for table `units_per_page`
--

CREATE TABLE `units_per_page` (
  `id` int(11) NOT NULL,
  `unit` int(11) NOT NULL,
  `page` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `units_per_page`
--

INSERT INTO `units_per_page` (`id`, `unit`, `page`) VALUES
(1, 1000, 'clients'),
(2, 100, 'orders'),
(3, 100, 'payments'),
(4, 100, 'refill'),
(5, 100, 'bulk'),
(6, 100, 'services');

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

--
-- Table structure for table `updates`
--

CREATE TABLE `updates` (
  `u_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `action` varchar(225) NOT NULL,
  `date` datetime NOT NULL,
  `description` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'Not enough data'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `updates`
--

INSERT INTO `updates` (`u_id`, `service_id`, `action`, `date`, `description`) VALUES
(1, 5, 'Price Decreased', '2025-01-17 18:21:26', 'Service rate changed from <b>$ 2.91</b> to <b>$ 2.87</b>'),
(2, 1, 'Minimum Quantity Increased', '2025-01-17 21:28:30', 'Service minimum quantity increased from <b>10</b> to <b>50</b>'),
(3, 1, 'Maximum Quantity Increased', '2025-01-17 21:28:30', 'Service maximum quantity increased from <b>500000</b> to <b>1000000</b>'),
(4, 1, 'Minimum Quantity Decreased', '2025-01-17 21:29:29', 'Service minimum quantity decreased from <b>50</b> to <b>10</b>'),
(5, 1, 'Maximum Quantity Decreased', '2025-01-17 21:29:29', 'Service maximum quantity decreased from <b>1000000</b> to <b>500000</b>'),
(6, 7, 'Price Increased', '2025-01-17 22:23:27', 'Service rate changed from <b>$ 0.0011</b> to <b>$ 0.0112</b>'),
(7, 7, 'Price Decreased', '2025-01-17 23:55:36', 'Service rate changed from <b>$ 0.0112</b> to <b>$ 0.0009</b>'),
(8, 22, 'Minimum Quantity Increased', '2025-01-18 06:17:13', 'Service minimum quantity increased from <b>10</b> to <b>20</b>'),
(9, 22, 'Maximum Quantity Decreased', '2025-01-18 06:17:13', 'Service maximum quantity decreased from <b>500000</b> to <b>20000</b>'),
(10, 22, 'Minimum Quantity Decreased', '2025-01-18 06:18:25', 'Service minimum quantity decreased from <b>20</b> to <b>10</b>'),
(11, 22, 'Maximum Quantity Increased', '2025-01-18 06:18:25', 'Service maximum quantity increased from <b>20000</b> to <b>5000000</b>'),
(12, 12, 'Price Decreased', '2025-01-18 11:11:31', 'Service rate changed from <b>$ 0.0092</b> to <b>$ 0.0086</b>'),
(13, 56, 'Price Decreased', '2025-01-18 17:22:23', 'Service rate changed from <b>$ 1.55</b> to <b>$ 1.48</b>'),
(14, 1, 'Maximum Quantity Decreased', '2025-01-18 19:14:32', 'Service maximum quantity decreased from <b>500000</b> to <b>100000</b>'),
(15, 18, 'Price Decreased', '2025-01-18 21:47:09', 'Service rate changed from <b>$ 1.64</b> to <b>$ 1.63</b>'),
(16, 1, 'Maximum Quantity Increased', '2025-01-18 22:27:27', 'Service maximum quantity increased from <b>100000</b> to <b>1000000</b>'),
(17, 174, 'Price Increased', '2025-01-19 17:03:36', 'Service rate changed from <b>$ 0.675</b> to <b>$ 1.13</b>'),
(18, 13, 'Price Increased', '2025-01-19 17:04:14', 'Service rate changed from <b>$ 0.672</b> to <b>$ 1.12</b>'),
(19, 65, 'Price Decreased', '2025-01-19 17:45:18', 'Service rate changed from <b>$ 0.0258</b> to <b>$ 0.0148</b>'),
(20, 65, 'Maximum Quantity Decreased', '2025-01-19 17:45:18', 'Service maximum quantity decreased from <b>1000000000</b> to <b>100000000</b>'),
(21, 181, 'Price Decreased', '2025-01-19 19:05:33', 'Service rate changed from <b>$ 1.78</b> to <b>$ 1.42</b>'),
(22, 181, 'Maximum Quantity Increased', '2025-01-19 19:05:33', 'Service maximum quantity increased from <b>100000</b> to <b>1000000</b>'),
(23, 213, 'Activated', '2025-01-19 21:48:01', 'Refill Button has been activated'),
(24, 277, 'Price Decreased', '2025-01-21 13:17:30', 'Service rate changed from <b>$ 0.085</b> to <b>$ 0.0636</b>'),
(25, 277, 'Maximum Quantity Decreased', '2025-01-21 13:17:30', 'Service maximum quantity decreased from <b>500000</b> to <b>100000</b>'),
(26, 381, 'Refill Deactivated', '2025-01-21 22:31:55', 'Refill Button has been Deativated'),
(27, 381, 'Cancel Deactivated', '2025-01-21 22:31:55', 'Cancel Button has been Deativated'),
(28, 381, 'SERVICE PRICE UPDATED', '2025-01-21 22:31:55', 'Service rate changed from <b></b> to <b>0.50'),
(29, 381, 'Service Minimum Quantity Changed', '2025-01-21 22:31:55', 'Service minimum quantity changed from <b></b> to <b> 1'),
(30, 381, 'Service Maximum Quantity Changed', '2025-01-21 22:31:55', 'Service Maximum quantity changed from<b></b> to <b> 100000'),
(31, 381, 'Refill Deactivated', '2025-01-21 22:35:17', 'Refill Button has been Deativated'),
(32, 381, 'Cancel Deactivated', '2025-01-21 22:35:17', 'Cancel Button has been Deativated'),
(33, 381, 'SERVICE PRICE UPDATED', '2025-01-21 22:35:17', 'Service rate changed from <b></b> to <b>0.50'),
(34, 381, 'Service Minimum Quantity Changed', '2025-01-21 22:35:17', 'Service minimum quantity changed from <b></b> to <b> 1'),
(35, 381, 'Service Maximum Quantity Changed', '2025-01-21 22:35:17', 'Service Maximum quantity changed from<b></b> to <b> 100000'),
(36, 381, 'Refill Deactivated', '2025-01-21 22:36:19', 'Refill Button has been Deativated'),
(37, 381, 'Cancel Deactivated', '2025-01-21 22:36:19', 'Cancel Button has been Deativated'),
(38, 381, 'SERVICE PRICE UPDATED', '2025-01-21 22:36:19', 'Service rate changed from <b></b> to <b>0.50'),
(39, 381, 'Service Minimum Quantity Changed', '2025-01-21 22:36:19', 'Service minimum quantity changed from <b></b> to <b> 1'),
(40, 381, 'Service Maximum Quantity Changed', '2025-01-21 22:36:19', 'Service Maximum quantity changed from<b></b> to <b> 100000'),
(41, 382, 'Activated', '2025-01-22 01:27:23', 'Refill Button has been activated'),
(42, 383, 'Activated', '2025-01-22 01:27:23', 'Refill Button has been activated'),
(43, 384, 'Activated', '2025-01-22 01:27:23', 'Refill Button has been activated'),
(44, 385, 'Activated', '2025-01-22 01:27:23', 'Refill Button has been activated'),
(45, 400, 'Activated', '2025-01-22 13:25:41', 'Refill Button has been activated'),
(46, 400, 'Activated', '2025-01-22 13:25:48', 'Cancel Button has been activated');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `article`
--
ALTER TABLE `article`
  ADD PRIMARY KEY (`id`),
  ADD KEY `title` (`title`);

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

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

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

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

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`client_id`);

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

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

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

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

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

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

--
-- Indexes for table `earn`
--
ALTER TABLE `earn`
  ADD PRIMARY KEY (`earn_id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`);

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

--
-- Indexes for table `panel_info`
--
ALTER TABLE `panel_info`
  ADD PRIMARY KEY (`panel_id`);

--
-- Indexes for table `paymentmethods`
--
ALTER TABLE `paymentmethods`
  ADD PRIMARY KEY (`methodId`),
  ADD KEY `methodId` (`methodId`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `referral`
--
ALTER TABLE `referral`
  ADD PRIMARY KEY (`referral_id`);

--
-- Indexes for table `referral_payouts`
--
ALTER TABLE `referral_payouts`
  ADD PRIMARY KEY (`r_p_id`);

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

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

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

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

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

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`task_id`);

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

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

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

--
-- Indexes for table `ticket_subjects`
--
ALTER TABLE `ticket_subjects`
  ADD PRIMARY KEY (`subject_id`);

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

--
-- Indexes for table `updates`
--
ALTER TABLE `updates`
  ADD PRIMARY KEY (`u_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `client_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `earn`
--
ALTER TABLE `earn`
  MODIFY `earn_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `paymentmethods`
--
ALTER TABLE `paymentmethods`
  MODIFY `methodId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

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

--
-- AUTO_INCREMENT for table `referral`
--
ALTER TABLE `referral`
  MODIFY `referral_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `referral_payouts`
--
ALTER TABLE `referral_payouts`
  MODIFY `r_p_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `ticket_subjects`
--
ALTER TABLE `ticket_subjects`
  MODIFY `subject_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `updates`
--
ALTER TABLE `updates`
  MODIFY `u_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
COMMIT;

