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

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: smm
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `api_providers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_providers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `url` text DEFAULT NULL,
  `key` text DEFAULT NULL,
  `type` varchar(50) DEFAULT 'standard',
  `balance` decimal(15,4) DEFAULT 0.0000,
  `currency_code` varchar(10) DEFAULT 'USD',
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `api_providers`
--

LOCK TABLES `api_providers` WRITE;
/*!40000 ALTER TABLE `api_providers` DISABLE KEYS */;
/*!40000 ALTER TABLE `api_providers` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blacklist_email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blacklist_email` WRITE;
/*!40000 ALTER TABLE `blacklist_email` DISABLE KEYS */;
/*!40000 ALTER TABLE `blacklist_email` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blacklist_ip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blacklist_ip` WRITE;
/*!40000 ALTER TABLE `blacklist_ip` DISABLE KEYS */;
/*!40000 ALTER TABLE `blacklist_ip` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blacklist_link`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blacklist_link` WRITE;
/*!40000 ALTER TABLE `blacklist_link` DISABLE KEYS */;
/*!40000 ALTER TABLE `blacklist_link` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blog_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blog_categories` WRITE;
/*!40000 ALTER TABLE `blog_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blog_posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blog_posts` WRITE;
/*!40000 ALTER TABLE `blog_posts` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_posts` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blog_posts_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blog_posts_lang` WRITE;
/*!40000 ALTER TABLE `blog_posts_lang` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_posts_lang` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `categories_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `categories_lang` WRITE;
/*!40000 ALTER TABLE `categories_lang` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `categories_lang` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `coupons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `coupons` WRITE;
/*!40000 ALTER TABLE `coupons` DISABLE KEYS */;
/*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `faqs` WRITE;
/*!40000 ALTER TABLE `faqs` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `faqs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `file_manager`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `file_manager` WRITE;
/*!40000 ALTER TABLE `file_manager` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_manager` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `languages_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `languages_list` WRITE;
/*!40000 ALTER TABLE `languages_list` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `languages_list` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `menu` WRITE;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;
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 © 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','');
/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `pages_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `pages_lang` WRITE;
/*!40000 ALTER TABLE `pages_lang` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `pages_lang` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `payments_method`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `payments_method` WRITE;
/*!40000 ALTER TABLE `payments_method` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `payments_method` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `purchase`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `purchase` WRITE;
/*!40000 ALTER TABLE `purchase` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `purchase` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `social_network_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `social_network_categories` WRITE;
/*!40000 ALTER TABLE `social_network_categories` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `social_network_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staffs`
--

DROP TABLE IF EXISTS `staffs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staffs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) DEFAULT NULL,
  `role_id` int(11) DEFAULT 1,
  `admin` tinyint(1) DEFAULT 1,
  `login_type` varchar(50) DEFAULT 'staff',
  `first_name` varchar(255) DEFAULT 'Admin',
  `last_name` varchar(255) DEFAULT 'User',
  `email` varchar(255) NOT NULL,
  `password` text NOT NULL,
  `timezone` varchar(255) DEFAULT 'UTC',
  `settings` text DEFAULT NULL,
  `history_ip` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `changed` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staffs`
--

LOCK TABLES `staffs` WRITE;
/*!40000 ALTER TABLE `staffs` DISABLE KEYS */;
INSERT INTO `staffs` VALUES (1,'adm01',1,1,'staff','Admin','User','admin@admin.com','$2a$08$LI3nYKoXwpJc1nmdiYvEDebG/wQutbsA5SpbnanCMjJFXeE82VHKS','UTC',NULL,NULL,1,'2026-08-29 23:15:55','2026-08-29 23:15:55');
/*!40000 ALTER TABLE `staffs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `subscribers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `subscribers` WRITE;
/*!40000 ALTER TABLE `subscribers` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscribers` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `ticket_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `ticket_messages` WRITE;
/*!40000 ALTER TABLE `ticket_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `ticket_messages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `tickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `tickets` WRITE;
/*!40000 ALTER TABLE `tickets` DISABLE KEYS */;
/*!40000 ALTER TABLE `tickets` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'smm'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-30  6:46:39