-- SmartStore SMM Database Dump
-- Import this into your cPanel MySQL database via phpMyAdmin
-- 1) Create empty database in cPanel
-- 2) Select that database in phpMyAdmin
-- 3) Import this file

--
-- Host: localhost    Database: smm
-- ------------------------------------------------------


--
-- Table structure for table `blacklist_email`
--

CREATE TABLE `blacklist_email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blacklist_email`
--


--
-- Table structure for table `blacklist_ip`
--

CREATE TABLE `blacklist_ip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `ip` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blacklist_ip`
--


--
-- Table structure for table `blacklist_link`
--

CREATE TABLE `blacklist_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `link` text NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blacklist_link`
--


--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `url_slug` varchar(255) DEFAULT NULL,
  `lang_name` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `sort` int(11) DEFAULT 0,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_categories`
--


--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `cate_id` int(11) DEFAULT 0,
  `name` varchar(255) NOT NULL,
  `image` text DEFAULT NULL,
  `url_slug` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `released` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_posts`
--


--
-- Table structure for table `blog_posts_lang`
--

CREATE TABLE `blog_posts_lang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `post_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `url_slug` varchar(255) DEFAULT NULL,
  `lang_code` varchar(10) DEFAULT 'en',
  `page_seo` text DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_posts_lang`
--


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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `sncate_id` int(11) DEFAULT 0,
  `name` varchar(255) NOT NULL,
  `url_slug` varchar(255) DEFAULT NULL,
  `manage_sections` text DEFAULT NULL,
  `icon_class` varchar(100) DEFAULT 'bi bi-person-plus',
  `sort` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  `options` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'cat_ig_fol',1,'Instagram Followers','instagram-followers',NULL,'bi bi-person-plus',1,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(2,'cat_ig_likes',1,'Instagram Likes','instagram-likes',NULL,'bi bi-heart',2,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(3,'cat_tt_fol',4,'TikTok Followers','tiktok-followers',NULL,'bi bi-person-plus',3,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL);

--
-- Table structure for table `categories_lang`
--

CREATE TABLE `categories_lang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `cate_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `unit_name` varchar(255) DEFAULT NULL,
  `url_slug` varchar(255) DEFAULT NULL,
  `lang_code` varchar(10) DEFAULT 'en',
  `required_field` text DEFAULT NULL,
  `page_seo` text DEFAULT NULL,
  `sections_layout` longtext DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  `options` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories_lang`
--

INSERT INTO `categories_lang` VALUES (1,'clang_ig_fol',1,'Instagram Followers','Followers','instagram-followers','en','link','{\"title\":\"Buy Instagram Followers\",\"keywords\":\"instagram, followers\",\"description\":\"Buy high quality Instagram followers\"}','{\"header_section\":{\"status\":1,\"section_type\":\"header_section\"},\"packages_section\":{\"status\":1,\"section_type\":\"packages_section\"},\"why_choose_us_section\":{\"status\":1,\"section_type\":\"why_choose_us_section\"},\"what_we_offer_section\":{\"status\":1,\"section_type\":\"what_we_offer_section\"},\"how_it_work_section\":{\"status\":1,\"section_type\":\"how_it_work_section\"},\"counters_section\":{\"status\":1,\"section_type\":\"counters_section\"},\"growing_brands_section\":{\"status\":1,\"section_type\":\"growing_brands_section\"},\"reviews_section\":{\"status\":1,\"section_type\":\"reviews_section\"},\"faqs_section\":{\"status\":1,\"section_type\":\"faqs_section\"},\"contact_us_section\":{\"status\":1,\"section_type\":\"contact_us_section\"}}',1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(2,'clang_ig_likes',2,'Instagram Likes','Likes','instagram-likes','en','link','{\"title\":\"Buy Instagram Likes\",\"keywords\":\"instagram, likes\",\"description\":\"Buy high quality Instagram likes\"}','{\"header_section\":{\"status\":1,\"section_type\":\"header_section\"},\"packages_section\":{\"status\":1,\"section_type\":\"packages_section\"},\"why_choose_us_section\":{\"status\":1,\"section_type\":\"why_choose_us_section\"},\"what_we_offer_section\":{\"status\":1,\"section_type\":\"what_we_offer_section\"},\"how_it_work_section\":{\"status\":1,\"section_type\":\"how_it_work_section\"},\"counters_section\":{\"status\":1,\"section_type\":\"counters_section\"},\"growing_brands_section\":{\"status\":1,\"section_type\":\"growing_brands_section\"},\"reviews_section\":{\"status\":1,\"section_type\":\"reviews_section\"},\"faqs_section\":{\"status\":1,\"section_type\":\"faqs_section\"},\"contact_us_section\":{\"status\":1,\"section_type\":\"contact_us_section\"}}',1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(3,'clang_tt_fol',3,'TikTok Followers','Followers','tiktok-followers','en','link','{\"title\":\"Buy TikTok Followers\",\"keywords\":\"tiktok, followers\",\"description\":\"Buy high quality TikTok followers\"}','{\"header_section\":{\"status\":1,\"section_type\":\"header_section\"},\"packages_section\":{\"status\":1,\"section_type\":\"packages_section\"},\"why_choose_us_section\":{\"status\":1,\"section_type\":\"why_choose_us_section\"},\"what_we_offer_section\":{\"status\":1,\"section_type\":\"what_we_offer_section\"},\"how_it_work_section\":{\"status\":1,\"section_type\":\"how_it_work_section\"},\"counters_section\":{\"status\":1,\"section_type\":\"counters_section\"},\"growing_brands_section\":{\"status\":1,\"section_type\":\"growing_brands_section\"},\"reviews_section\":{\"status\":1,\"section_type\":\"reviews_section\"},\"faqs_section\":{\"status\":1,\"section_type\":\"faqs_section\"},\"contact_us_section\":{\"status\":1,\"section_type\":\"contact_us_section\"}}',1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL);

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `code` varchar(100) NOT NULL,
  `discount_value` int(11) DEFAULT 0,
  `discount_type` varchar(50) DEFAULT 'percentage',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `changed` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupons`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `question` text DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `sort` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'faq_01','How does the delivery work?','Once you make a payment and submit your link/username, our automated systems begin processing your order within minutes.',1,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(2,'faq_02','Do I need to share my password?','No, we never ask for your account password. We only require the public profile link or username.',2,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(3,'faq_03','Can I get a refund if something goes wrong?','Yes, we offer refunds or refills if orders are not delivered properly according to our terms of service.',3,1,'2026-08-29 23:15:55','2026-08-29 23:15:55');

--
-- Table structure for table `file_manager`
--

CREATE TABLE `file_manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `file_path` text DEFAULT NULL,
  `file_type` varchar(50) DEFAULT NULL,
  `file_size` int(11) DEFAULT 0,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `file_manager`
--


--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(10) NOT NULL,
  `country_code` varchar(10) NOT NULL,
  `is_default` tinyint(1) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `languages`
--


--
-- Table structure for table `languages_list`
--

CREATE TABLE `languages_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(10) NOT NULL,
  `country_code` varchar(10) NOT NULL,
  `is_default` tinyint(1) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `languages_list`
--

INSERT INTO `languages_list` VALUES (1,'lang_en','English','en','us',1,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(2,'lang_vi','Vietnamese','vi','vn',0,1,'2026-08-29 23:15:55','2026-08-29 23:15:55');

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `options` text DEFAULT NULL,
  `name_lang` text DEFAULT NULL,
  `type` varchar(50) DEFAULT 'link',
  `target` varchar(50) DEFAULT 'self',
  `status` tinyint(1) DEFAULT 1,
  `sort` int(11) DEFAULT 0,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` VALUES (1,'menu_home','Home','{\"url_slug\":\"home\"}','{\"en\":\"Home\"}','link','self',1,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(2,'menu_services','Services','{\"url_slug\":\"services\"}','{\"en\":\"Services\"}','link','self',1,2,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(3,'menu_blog','Blog','{\"url_slug\":\"blog\"}','{\"en\":\"Blog\"}','blog','self',1,3,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(4,'menu_track','Track Order','{\"url_slug\":\"track-order\"}','{\"en\":\"Track Order\"}','track_order','self',1,4,'2026-08-29 23:15:55','2026-08-29 23:15:55');

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

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `news`
--


--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `options`
--

INSERT INTO `options` VALUES (1,'website_name','SmartStore SMM'),(2,'website_logo','assets/images/logo.png'),(3,'website_logo_white','assets/images/logo-white.png'),(4,'website_logo_mark','assets/images/logo-mark.png'),(5,'website_favicon','assets/images/favicon.png'),(6,'currency_code','USD'),(7,'currency_symbol','$'),(8,'currency_decimal','2'),(9,'currency_decimal_separator','.'),(10,'currency_thousand_separator',','),(11,'currency_position','left'),(12,'admin_max_items_per_page','25'),(13,'blog_limit_posts_per_page','9'),(14,'reviews_limit_per_page','10'),(15,'blog_author_name','Admin'),(16,'site_copy_right_content','Copyright &copy; 2026. All Rights Reserved.'),(17,'site_maintenance_mode','0'),(18,'app_token_data','{\"time\":\"2030-01-01 00:00:00\",\"token\":\"valid\"}'),(19,'google_recaptcha','{\"status\":0,\"site_key\":\"\",\"secret_key\":\"\"}'),(20,'website_seo','{\"title\":\"SmartStore - Best SMM Store\",\"keywords\":\"smm, panel, social media\",\"description\":\"Best SMM Store\",\"image_url\":\"\",\"index\":\"index\"}'),(40,'embed_js_code_header',''),(41,'coupon_header',''),(42,'cookie_popup','{\"status\":1,\"title\":\"Cookie Policy\",\"content\":\"We use cookies to ensure you get the best experience on our website.\",\"button_text\":\"Got it!\"}'),(43,'social_links',''),(44,'footer_links',''),(45,'embed_js_code_footer',''),(46,'contact_informations','');

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `uid` int(11) DEFAULT 0,
  `client_order_id` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT 'direct',
  `cate_id` int(11) DEFAULT 0,
  `service_id` int(11) DEFAULT 0,
  `service_type` varchar(50) DEFAULT 'default',
  `api_provider_id` int(11) DEFAULT 0,
  `api_service_id` varchar(255) DEFAULT NULL,
  `api_order_id` varchar(255) DEFAULT '0',
  `status` varchar(50) DEFAULT 'pending',
  `charge` decimal(15,4) DEFAULT 0.0000,
  `formal_charge` decimal(15,4) DEFAULT 0.0000,
  `profit` decimal(15,4) DEFAULT 0.0000,
  `link` text DEFAULT NULL,
  `quantity` int(11) DEFAULT 0,
  `start_counter` varchar(100) DEFAULT NULL,
  `remains` varchar(100) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `ip_address` varchar(100) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` text DEFAULT NULL,
  `sort` int(11) DEFAULT 0,
  `url_slug` varchar(255) DEFAULT NULL,
  `lang_name` text DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orders`
--


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

CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `url_slug` varchar(255) DEFAULT NULL,
  `manage_sections` text DEFAULT NULL,
  `page_type` varchar(50) DEFAULT 'default',
  `is_core_page` tinyint(1) DEFAULT 0,
  `sort` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  `options` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'page_home','Home','home',NULL,'home_page',1,1,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(2,'page_terms','Terms of Service','terms',NULL,'terms',1,2,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(3,'page_privacy','Privacy Policy','privacy',NULL,'privacy',1,3,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(4,'page_faq','FAQ','faq',NULL,'faq',1,4,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL),(5,'page_contact','Contact Us','contact',NULL,'contact',1,5,1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL);

--
-- Table structure for table `pages_lang`
--

CREATE TABLE `pages_lang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `page_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `url_slug` varchar(255) DEFAULT NULL,
  `lang_code` varchar(10) DEFAULT 'en',
  `page_seo` text DEFAULT NULL,
  `sections_layout` longtext DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  `options` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pages_lang`
--

INSERT INTO `pages_lang` VALUES (1,'plang_home',1,'Home','home','en','{\"title\":\"SmartStore - Best SMM Store\",\"keywords\":\"smm, panel, social media\",\"description\":\"Best SMM Store\"}','{\"header_section\":{\"status\":1,\"section_type\":\"header_section\"},\"packages_section\":{\"status\":1,\"section_type\":\"packages_section\"},\"why_choose_us_section\":{\"status\":1,\"section_type\":\"why_choose_us_section\"},\"what_we_offer_section\":{\"status\":1,\"section_type\":\"what_we_offer_section\"},\"how_it_work_section\":{\"status\":1,\"section_type\":\"how_it_work_section\"},\"counters_section\":{\"status\":1,\"section_type\":\"counters_section\"},\"growing_brands_section\":{\"status\":1,\"section_type\":\"growing_brands_section\"},\"reviews_section\":{\"status\":1,\"section_type\":\"reviews_section\"},\"faqs_section\":{\"status\":1,\"section_type\":\"faqs_section\"},\"contact_us_section\":{\"status\":1,\"section_type\":\"contact_us_section\"}}',1,'2026-08-29 23:15:55','2026-08-29 23:15:55',NULL);

--
-- Table structure for table `payments_method`
--

CREATE TABLE `payments_method` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `params` longtext DEFAULT NULL,
  `sort` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payments_method`
--

INSERT INTO `payments_method` VALUES (1,'pm_free','Free Trial','free','{\"type\":\"free\"}',1,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(2,'pm_paypal','PayPal','paypal','{\"type\":\"paypal\",\"environment\":\"sandbox\",\"client_id\":\"\",\"client_secret\":\"\"}',2,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(3,'pm_stripe','Stripe','stripe3ds','{\"type\":\"stripe3ds\",\"environment\":\"sandbox\",\"publishable_key\":\"\",\"secret_key\":\"\"}',3,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(4,'pm_payeer','Payeer','payeer','{\"type\":\"payeer\",\"merchant_id\":\"\",\"secret_key\":\"\"}',4,1,'2026-08-29 23:15:55','2026-08-29 23:15:55');

--
-- Table structure for table `purchase`
--

CREATE TABLE `purchase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `pid` varchar(255) DEFAULT '24815787',
  `purchase_code` varchar(255) DEFAULT '11111111-2222-3333-4444-555555555555',
  `version` varchar(50) DEFAULT '2.0',
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase`
--

INSERT INTO `purchase` VALUES (1,'pur01','24815787','11111111-2222-3333-4444-555555555555','2.0','2026-08-29 23:15:55','2026-08-29 23:15:55');

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

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `rating` int(11) DEFAULT 5,
  `comment` text DEFAULT NULL,
  `customer_id` int(11) DEFAULT 0,
  `cate_id` int(11) DEFAULT 0,
  `client_order_id` varchar(100) DEFAULT NULL,
  `options` text DEFAULT NULL,
  `ip_address` varchar(100) DEFAULT NULL,
  `last_submission_time` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `changed` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (1,'rev_01','Sarah Jenkins','sarah@example.com',5,'Super fast delivery and great support! My followers increased right away.',0,0,NULL,NULL,NULL,NULL,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(2,'rev_02','Michael Wong','michael@example.com',5,'Best SMM store I have used. Clean interface and instant results.',0,0,NULL,NULL,NULL,NULL,1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(3,'rev_03','Elena Gomez','elena@example.com',5,'Highly recommend for anyone wanting to grow their social presence fast!',0,0,NULL,NULL,NULL,NULL,1,'2026-08-29 23:15:55','2026-08-29 23:15:55');

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

CREATE TABLE `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `cate_id` int(11) DEFAULT 0,
  `name` varchar(255) NOT NULL,
  `price` decimal(15,4) DEFAULT 0.0000,
  `original_price` decimal(15,4) DEFAULT 0.0000,
  `quantity` int(11) DEFAULT 1,
  `discount_value` int(11) DEFAULT 0,
  `sort` int(11) DEFAULT 0,
  `desc` text DEFAULT NULL,
  `min` int(11) DEFAULT 1,
  `max` int(11) DEFAULT 10000,
  `add_type` varchar(50) DEFAULT 'manual',
  `is_free` tinyint(1) DEFAULT 0,
  `type` varchar(50) DEFAULT 'default',
  `api_provider_id` int(11) DEFAULT 0,
  `api_service_id` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `tab_name` varchar(255) DEFAULT NULL,
  `is_tab_name` tinyint(1) DEFAULT 0,
  `tab_name_background` varchar(50) DEFAULT 'primary',
  `url_slug` varchar(255) DEFAULT NULL,
  `lang_name` text DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `services` VALUES (1,'srv_ig_100',1,'100 Instagram Followers',1.9900,2.9900,100,33,1,'High Quality Instagram Followers, Instant start',100,100,'manual',0,'default',0,NULL,1,'STARTER',1,'primary',NULL,NULL,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(2,'srv_ig_500',1,'500 Instagram Followers',4.9900,7.9900,500,37,2,'High Quality Instagram Followers, Fast Delivery',500,500,'manual',0,'default',0,NULL,1,'POPULAR',1,'danger',NULL,NULL,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(3,'srv_ig_1000',1,'1000 Instagram Followers',8.9900,14.9900,1000,40,3,'Premium Instagram Followers, 24/7 Support',1000,1000,'manual',0,'default',0,NULL,1,'BEST VALUE',1,'success',NULL,NULL,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(4,'srv_ig_like_100',2,'100 Instagram Likes',0.9900,1.4900,100,33,1,'Fast Instagram Likes',100,100,'manual',0,'default',0,NULL,1,'',0,'primary',NULL,NULL,'2026-08-29 23:15:55','2026-08-29 23:15:55');

--
-- Table structure for table `social_network_categories`
--

CREATE TABLE `social_network_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) DEFAULT 1,
  `desc` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `sort` int(11) DEFAULT 0,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `social_network_categories`
--

INSERT INTO `social_network_categories` VALUES (1,'sn_ig','Instagram',1,'Instagram Services','assets/images/instagram.png',1,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(2,'sn_fb','Facebook',1,'Facebook Services','assets/images/facebook.png',2,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(3,'sn_yt','YouTube',1,'YouTube Services','assets/images/youtube.png',3,'2026-08-29 23:15:55','2026-08-29 23:15:55'),(4,'sn_tt','TikTok',1,'TikTok Services','assets/images/tiktok.png',4,'2026-08-29 23:15:55','2026-08-29 23:15:55');

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `history_ip` text DEFAULT NULL,
  `options` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `changed` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscribers`
--


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

CREATE TABLE `ticket_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `ticket_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT 0,
  `message` text DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ticket_messages`
--


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

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `from` varchar(50) DEFAULT 'client',
  `name` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `reply_message` text DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'new',
  `read` tinyint(1) DEFAULT 0,
  `changed` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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


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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `amount` decimal(15,4) DEFAULT 0.0000,
  `order_id` int(11) DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `desc` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `sort` int(11) DEFAULT 0,
  `created` datetime DEFAULT NULL,
  `changed` datetime DEFAULT NULL,
  `uid` int(11) DEFAULT 0,
  `transaction_fee` decimal(15,4) DEFAULT 0.0000,
  `data` longtext DEFAULT NULL,
  `discount_value` decimal(15,4) DEFAULT 0.0000,
  `original_amount` decimal(15,4) DEFAULT 0.0000,
  `coupon_code` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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


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

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `total_orders` int(11) DEFAULT 0,
  `total_spent` decimal(15,4) DEFAULT 0.0000,
  `timezone` varchar(255) DEFAULT 'UTC',
  `history_ip` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `changed` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `last_order` datetime DEFAULT NULL,
  `options` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--


--
-- Dumping routines for database 'smm'
--



