-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: elevate_db
-- ------------------------------------------------------
-- 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 */;

--
-- Current Database: `elevate_db`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `elevate_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;

USE `elevate_db`;

--
-- Table structure for table `activation_codes`
--

DROP TABLE IF EXISTS `activation_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activation_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL,
  `pin` varchar(16) NOT NULL,
  `package_id` bigint(20) unsigned NOT NULL,
  `owner_id` bigint(20) unsigned DEFAULT NULL,
  `used_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT 0,
  `used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `activation_codes_code_unique` (`code`),
  KEY `activation_codes_package_id_foreign` (`package_id`),
  KEY `activation_codes_owner_id_index` (`owner_id`),
  KEY `activation_codes_used_by_user_id_index` (`used_by_user_id`),
  CONSTRAINT `activation_codes_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activation_codes`
--

LOCK TABLES `activation_codes` WRITE;
/*!40000 ALTER TABLE `activation_codes` DISABLE KEYS */;
INSERT INTO `activation_codes` VALUES (1,'ELV-0UQX-NBCJ-GACP','741857',1,1,2,1,'2026-09-20 01:17:38','2026-09-20 01:17:38','2026-09-20 01:17:38'),(2,'ELV-HSCB-4QRX-YNWR','655855',1,1,95,1,'2026-09-20 02:00:28','2026-09-20 01:17:38','2026-09-20 02:00:28'),(3,'ELV-XQCC-LGDG-T8KA','381865',1,1,94,1,'2026-09-20 01:58:13','2026-09-20 01:17:38','2026-09-20 01:58:13'),(4,'ELV-KCJC-OBKL-VQGI','781850',1,1,93,1,'2026-09-20 01:53:32','2026-09-20 01:17:38','2026-09-20 01:53:32'),(5,'ELV-TPXF-TUPZ-ASJ0','124659',1,1,53,1,'2026-09-20 01:26:13','2026-09-20 01:17:38','2026-09-20 01:26:13'),(16,'ELV-SHHP-D0JZ-VDIZ','347134',1,1,NULL,0,NULL,'2026-09-20 02:02:54','2026-09-20 02:02:54'),(17,'ELV-CAQH-2SXF-AWDH','844170',1,1,NULL,0,NULL,'2026-09-20 02:02:54','2026-09-20 02:02:54'),(18,'ELV-PPB6-3VMB-E1FS','502879',1,1,NULL,0,NULL,'2026-09-20 02:02:54','2026-09-20 02:02:54'),(19,'ELV-BIJ7-F3NN-OJX7','616672',1,1,97,1,'2026-09-20 02:04:56','2026-09-20 02:02:54','2026-09-20 02:04:56'),(20,'ELV-69SA-S0RM-3DWL','743743',1,1,96,1,'2026-09-20 02:03:37','2026-09-20 02:02:54','2026-09-20 02:03:37');
/*!40000 ALTER TABLE `activation_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `advisories`
--

DROP TABLE IF EXISTS `advisories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `advisories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `series_number` varchar(255) DEFAULT NULL,
  `category` varchar(50) NOT NULL DEFAULT 'MEMORANDUM',
  `content` text NOT NULL,
  `icon_color` varchar(30) NOT NULL DEFAULT 'blue',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `advisories`
--

LOCK TABLES `advisories` WRITE;
/*!40000 ALTER TABLE `advisories` DISABLE KEYS */;
INSERT INTO `advisories` VALUES (1,'MLM Account Renaming Guidelines','Series 2026 No. 13','MEMORANDUM','Please be advised regarding account verification and updating of primary distributor profiles to ensure smooth payout transactions.','blue',1,'2026-08-16 01:17:38','2026-09-20 01:17:38'),(2,'SYSTEM SECURITY ADVISORY','Series 2026 No. 11','MEMORANDUM','Always protect your login password and never share your withdrawal OTP with anyone. ElevateWell staff will never ask for your private passwords.','blue',1,'2026-08-09 01:17:38','2026-09-20 01:17:38');
/*!40000 ALTER TABLE `advisories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `binary_nodes`
--

DROP TABLE IF EXISTS `binary_nodes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `binary_nodes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `upline_id` bigint(20) unsigned DEFAULT NULL,
  `position` varchar(10) DEFAULT NULL,
  `left_points` int(11) NOT NULL DEFAULT 0,
  `right_points` int(11) NOT NULL DEFAULT 0,
  `total_pairs` int(11) NOT NULL DEFAULT 0,
  `daily_pairs_today` int(11) NOT NULL DEFAULT 0,
  `last_pair_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `binary_nodes_user_id_foreign` (`user_id`),
  KEY `binary_nodes_upline_id_index` (`upline_id`),
  CONSTRAINT `binary_nodes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `binary_nodes`
--

LOCK TABLES `binary_nodes` WRITE;
/*!40000 ALTER TABLE `binary_nodes` DISABLE KEYS */;
INSERT INTO `binary_nodes` VALUES (1,1,NULL,NULL,700,0,0,0,NULL,'2026-09-20 01:17:38','2026-09-20 02:05:42'),(2,2,1,'left',0,0,3,3,'2026-09-20','2026-09-20 01:17:38','2026-09-20 02:05:42'),(51,53,2,'left',100,100,0,0,'2026-09-20','2026-09-20 01:29:30','2026-09-20 02:00:54'),(88,93,2,'right',100,100,0,0,'2026-09-20','2026-09-20 01:55:10','2026-09-20 02:05:42'),(89,94,53,'left',0,0,0,0,'2026-09-20','2026-09-20 01:58:36','2026-09-20 01:58:36'),(90,95,53,'right',0,0,0,0,'2026-09-20','2026-09-20 02:00:54','2026-09-20 02:00:54'),(91,96,93,'right',0,0,0,0,'2026-09-20','2026-09-20 02:04:05','2026-09-20 02:04:05'),(92,97,93,'left',0,0,0,0,'2026-09-20','2026-09-20 02:05:42','2026-09-20 02:05:42');
/*!40000 ALTER TABLE `binary_nodes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

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

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

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

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` varchar(255) NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

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

--
-- Table structure for table `hubs`
--

DROP TABLE IF EXISTS `hubs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hubs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'CITY HUB',
  `contact_person` varchar(255) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `address` text NOT NULL,
  `city` varchar(100) NOT NULL,
  `province` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hubs`
--

LOCK TABLES `hubs` WRITE;
/*!40000 ALTER TABLE `hubs` DISABLE KEYS */;
INSERT INTO `hubs` VALUES (1,'Elevatewell Head Office','OFFICE HUB','Head Office Support','09999464275','3G1-A The Garden By Pacific GCBD, SBFZ','Olongapo City','Zambales',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(2,'DANIEL CANCIO HUB','CITY HUB','Daniel Cancio','+971503695678','UNIT 4 BLK 3 LOT 9 AVENIDA RIZAL ST PHASE 2, BAHAYANG PAG ASA, BRGY MOLINO 5','Bacoor City','Cavite',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(3,'MICHAEL CHIU HUB','CITY HUB','Michael Chiu','09562967077','AJA BOODLE BY THE BAY SOUTHBAY BRGY SOUTH P. Acharon Blvd.','General Santos City','South Cotabato',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(4,'JACQUELINE DECENA HUB','CITY HUB','Jacqueline Decena','09268366296','144 K 6th Corner Anonas St. East Kamias','Quezon City','Metro Manila',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(5,'JIM MORALES HUB','CITY HUB','Jim Morales','09065671028','CRUISERS CRIB AUTO CARE CENTER - 124 Fabian St New Niog Village','Bacoor City','Cavite',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(6,'ALBIN RESPUSTO HUB','CITY HUB','Albin Respuesto','09989911965','Purok 4, U.P road tugbok dist. Mintal','Davao City','Davao del Sur',1,'2026-09-20 01:17:38','2026-09-20 01:17:38');
/*!40000 ALTER TABLE `hubs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `incomes`
--

DROP TABLE IF EXISTS `incomes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `incomes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `source_user_id` bigint(20) unsigned DEFAULT NULL,
  `type` varchar(40) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `tax_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `net_amount` decimal(10,2) NOT NULL,
  `pv_points` int(11) NOT NULL DEFAULT 0,
  `package_name` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `incomes_user_id_foreign` (`user_id`),
  KEY `incomes_source_user_id_index` (`source_user_id`),
  CONSTRAINT `incomes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `incomes`
--

LOCK TABLES `incomes` WRITE;
/*!40000 ALTER TABLE `incomes` DISABLE KEYS */;
INSERT INTO `incomes` VALUES (1,1,2,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Juan Dela Cruz (Starter Package)','2026-09-20 01:17:38','2026-09-20 01:17:38'),(20,2,53,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 1 (Starter Package)','2026-09-20 01:26:13','2026-09-20 01:26:13'),(36,2,93,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 2 (Starter Package)','2026-09-20 01:53:32','2026-09-20 01:53:32'),(37,2,93,'unilevel',10.00,0.00,10.00,0,'Starter','Unilevel Leveling Bonus (Level 1) - Complete Line (2 Members)','2026-09-20 01:55:10','2026-09-20 01:55:10'),(38,53,94,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 3 (Starter Package)','2026-09-20 01:58:13','2026-09-20 01:58:13'),(39,53,95,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 4 (Starter Package)','2026-09-20 02:00:28','2026-09-20 02:00:28'),(40,53,95,'unilevel',10.00,0.00,10.00,0,'Starter','Unilevel Leveling Bonus (Level 1) - Complete Line (2 Members)','2026-09-20 02:00:54','2026-09-20 02:00:54'),(41,93,96,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 5 (Starter Package)','2026-09-20 02:03:37','2026-09-20 02:03:37'),(42,93,97,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 6 (Starter Package)','2026-09-20 02:04:56','2026-09-20 02:04:56'),(43,2,NULL,'binary',500.00,0.00,500.00,100,NULL,'Binary Pairing Bonus (Pair #1)','2026-09-20 02:05:42','2026-09-20 02:05:42'),(44,2,NULL,'binary',500.00,0.00,500.00,100,NULL,'Binary Pairing Bonus (Pair #2)','2026-09-20 02:05:42','2026-09-20 02:05:42'),(45,2,NULL,'binary',500.00,0.00,500.00,100,NULL,'Binary Pairing Bonus (Pair #3)','2026-09-20 02:05:42','2026-09-20 02:05:42'),(46,93,97,'unilevel',10.00,0.00,10.00,0,'Starter','Unilevel Leveling Bonus (Level 1) - Complete Line (2 Members)','2026-09-20 02:05:42','2026-09-20 02:05:42'),(47,2,97,'unilevel',10.00,0.00,10.00,0,'Starter','Unilevel Leveling Bonus (Level 2) - Complete Line (4 Members)','2026-09-20 02:05:42','2026-09-20 02:05:42');
/*!40000 ALTER TABLE `incomes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

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

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` smallint(5) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

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

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_09_19_104627_create_elevate_tables',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `order_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(20) NOT NULL DEFAULT 'product',
  `item_id` bigint(20) unsigned NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `pv_points` int(11) NOT NULL DEFAULT 0,
  `subtotal` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_items`
--

LOCK TABLES `order_items` WRITE;
/*!40000 ALTER TABLE `order_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_items` 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(50) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `shipping_fee` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total_amount` decimal(10,2) NOT NULL,
  `total_pv` int(11) NOT NULL DEFAULT 0,
  `payment_method` varchar(30) NOT NULL DEFAULT 'wallet',
  `payment_status` varchar(30) NOT NULL DEFAULT 'paid',
  `order_status` varchar(30) NOT NULL DEFAULT 'processing',
  `recipient_name` varchar(255) NOT NULL,
  `recipient_phone` varchar(255) NOT NULL,
  `shipping_address` text NOT NULL,
  `city` varchar(100) DEFAULT NULL,
  `province` varchar(100) DEFAULT NULL,
  `tracking_number` varchar(100) DEFAULT NULL,
  `is_affiliate_order` tinyint(1) NOT NULL DEFAULT 0,
  `affiliate_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_order_number_unique` (`order_number`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_affiliate_user_id_index` (`affiliate_user_id`),
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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 `packages`
--

DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `pv_points` int(11) NOT NULL DEFAULT 0,
  `direct_referral_bonus` decimal(10,2) NOT NULL DEFAULT 0.00,
  `pairing_bonus` decimal(10,2) NOT NULL DEFAULT 0.00,
  `daily_pair_limit` int(11) NOT NULL DEFAULT 10,
  `badge_color` varchar(30) NOT NULL DEFAULT 'emerald',
  `image_url` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `packages`
--

LOCK TABLES `packages` WRITE;
/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
INSERT INTO `packages` VALUES (1,'Starter',1998.00,100,200.00,500.00,10,'emerald',NULL,'Silver Account Activation / Starter Package with wellness essentials.',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(2,'Bronze',5998.00,300,600.00,1000.00,15,'amber',NULL,'Bronze Account Activation. Unlock additional income streams & higher pairing limits.',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(3,'Silver',11998.00,600,1200.00,1500.00,20,'slate',NULL,'Silver Account Activation with bulk wellness inventory.',1,'2026-09-20 01:17:38','2026-09-20 02:09:22'),(4,'Gold',19998.00,1000,2000.00,2500.00,25,'yellow',NULL,'Gold Account Activation with executive benefits.',0,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(5,'Titanium',99998.00,5000,10000.00,12000.00,35,'teal',NULL,'Titanium Account Activation with maximum payouts.',0,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(6,'Platinum',199998.00,10000,20000.00,25000.00,50,'cyan',NULL,'Platinum Account Activation with ultimate VIP master distributor privileges.',0,'2026-09-20 01:17:38','2026-09-20 01:17:38');
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

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

--
-- Table structure for table `payout_options`
--

DROP TABLE IF EXISTS `payout_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payout_options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `method` varchar(30) NOT NULL,
  `account_name` varchar(255) NOT NULL,
  `account_number` varchar(255) NOT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payout_options_user_id_foreign` (`user_id`),
  CONSTRAINT `payout_options_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payout_options`
--

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

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

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category` varchar(50) NOT NULL DEFAULT 'Barley',
  `member_price` decimal(10,2) NOT NULL,
  `retail_price` decimal(10,2) NOT NULL,
  `discount_percent` int(11) NOT NULL DEFAULT 20,
  `pv_points` int(11) NOT NULL DEFAULT 0,
  `stock` int(11) NOT NULL DEFAULT 100,
  `spec_weight` varchar(50) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'100% Pure Organic Barley Grass - 45g','Barley',440.00,550.00,20,2,500,'3g x 15 sachet - 45 grams','/images/products/barley-45g.png','Boost immunity, cleanse body, and increase energy with 100% Pure Organic Barley Grass.',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(2,'100% Pure Organic Barley Grass - 100g','Barley',960.00,1200.00,20,5,300,'50 servings - 100 grams','/images/products/barley-100g.png','Premium 100-gram pure organic barley grass container for daily superfood nutrition.',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(3,'Powerwell Barley Gummies','Gummies',1278.40,1598.00,20,10,250,'60 Gummies','/images/products/barley-gummies.png','Delicious and convenient daily superfood barley gummies for the whole family.',1,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(4,'Powerwell Pure Strong Brew (with Ganoderma)','Coffee & Brew',1200.00,1500.00,20,10,200,'15 Sachets (60g)','/images/banners/powerwell-strongbrew-hero.png','Pure strong brew with Ganoderma extract. Zero calories, natural energy, and vitality.',1,'2026-09-20 01:17:38','2026-09-20 01:17:38');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('2sqhMbTPxWFmzmE7pqn7sZNm7tUQMyg2wYbBrK5h',94,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJ3bEVSWmdNNjBBTmlPYkdQQmRDSlNJREZsQzduSVlyQVZNZWpxNmswIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9kYXNoYm9hcmQiLCJyb3V0ZSI6ImRhc2hib2FyZCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjo5NH0=',1789898294),('5v0yEvGuWD4zd1nrPhnXhTMBi6LXFveHEcspUKZl',96,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiIxTkNlZWpIbnFGcFJQVG5FcG9oRGNyZVpyR0hRbTdoREJsMldPcTlFIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9kYXNoYm9hcmQiLCJyb3V0ZSI6ImRhc2hib2FyZCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjo5Nn0=',1789898618),('6oF5Ver0mgUMYSjvopoIMQpJGtLWyWeuxeTwLY88',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJZUkZYY2ZVYnBTUmQ1UERGYU9BZlFKNEZaY05taEZ0RExlUEw0dWtDIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9FbGV2YXRlXC9wdWJsaWNcL2FkbWluXC9kYXNoYm9hcmQifSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9hZG1pblwvZGFzaGJvYXJkIiwicm91dGUiOiJhZG1pbi5kYXNoYm9hcmQifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1789969123),('b1xfKJ6yGcCT7C75u1WgTIMPGAC1SFr2KqPrRf7f',93,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJSYnR4cWtlWGtmalJRcWNXc3FMWnRxdUlWN2l4ZVV6dUhpSkh2Zk9PIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9uZXR3b3JrXC9nZW5lYWxvZ3kiLCJyb3V0ZSI6Im5ldHdvcmsuZ2VuZWFsb2d5In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjkzfQ==',1789898746),('BcWJXgC4rTeInTOOMcVY9U6T21DVIhVYao1vUetT',1,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJNTlZKOE9mQmpLSXVOMTRvSUdPdVU2NnhZSFN1OEZVNndZc05jRjByIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9hZG1pblwvZGFzaGJvYXJkIiwicm91dGUiOiJhZG1pbi5kYXNoYm9hcmQifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MX0=',1789974551),('Ff2hvOkhlTrzMLAYasqcYPSKn5N7zMhw6ggBUpUM',95,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJ3RW9WaUJVZlptb25MeENldWUydzNiQWR2d0Q3VmwxTGNoV2NNS01hIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9kYXNoYm9hcmQiLCJyb3V0ZSI6ImRhc2hib2FyZCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjo5NX0=',1789898428),('I4Mf4ub7h7rAjxlieMuZoF3gxg8OwFqPt2IOv8kE',97,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiI3QWZkRGx1cUVYZzBQdk9PbVJ1STFZQVdCUDBJcWo4Qzc1aGJkSURrIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9kYXNoYm9hcmQiLCJyb3V0ZSI6ImRhc2hib2FyZCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjo5N30=',1789898696),('NEipHiuAI2edWgUDf3IbXeMKKEuWHrlZM4mlltI7',53,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJydEtyOTRYSG9NWWtKVFRocmZsVzNZTTI1cXd2UWY0NWc4TElRTEFjIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9uZXR3b3JrXC9nZW5lYWxvZ3kiLCJyb3V0ZSI6Im5ldHdvcmsuZ2VuZWFsb2d5In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjUzfQ==',1789898706),('ntFuSVsWaZ1TdX7mjdVMZUSKhltBworyulwFv3QP',1,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJUWml0UDBGdnB3WU03eENtQWplMnU4aFkzWVJjNDV6TkhxbGNmdFBYIiwiX2ZsYXNoIjp7Im5ldyI6W10sIm9sZCI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9FbGV2YXRlXC9wdWJsaWNcL2FkbWluXC9wcm9kdWN0cyIsInJvdXRlIjoiYWRtaW4ucHJvZHVjdHMifSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1789898962),('v8QUTELKx3cCHhNhNGDpC2HFQJOR46aQGJ1XWsiP',2,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJCd2FmWDJ4OFN4RlZmbndXVk9GU0c4MWJ3UUcwT1RJNnYya3g0bWIxIiwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjIsIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9zdG9yZVwvcHJvZHVjdHMiLCJyb3V0ZSI6InN0b3JlLnByb2R1Y3RzIn0sImNhcnQiOnsicGFja2FnZV8yIjp7ImlkIjoyLCJ0eXBlIjoicGFja2FnZSIsIm5hbWUiOiJCcm9uemUgUGFja2FnZSIsInByaWNlIjoiNTk5OC4wMCIsInF1YW50aXR5IjoxLCJwdl9wb2ludHMiOjMwMCwiaW1hZ2UiOm51bGx9fX0=',1789898891);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `system_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `system_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(64) NOT NULL,
  `value` text DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `system_settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `system_settings` WRITE;
/*!40000 ALTER TABLE `system_settings` DISABLE KEYS */;
INSERT INTO `system_settings` VALUES (1,'app_name','SuperMovies Unilevel',NULL,'2026-09-20 01:17:38','2026-09-20 02:07:39'),(2,'pairing_bonus','500',NULL,'2026-09-20 01:17:38','2026-09-20 02:07:39'),(3,'safety_net_daily_pairs','10',NULL,'2026-09-20 01:17:38','2026-09-20 02:07:39'),(4,'min_withdrawal','500',NULL,'2026-09-20 01:17:38','2026-09-20 02:07:39'),(5,'withdrawal_fee','50',NULL,'2026-09-20 01:17:38','2026-09-20 02:07:39'),(48,'matrix_legs','2',NULL,'2026-09-20 02:07:39','2026-09-20 02:07:39'),(49,'pairing_required_downlines','4',NULL,'2026-09-20 02:07:39','2026-09-20 02:07:39'),(50,'unilevel_levels','[{\"level\":1,\"amount\":10},{\"level\":2,\"amount\":10},{\"level\":3,\"amount\":10}]',NULL,'2026-09-20 02:07:39','2026-09-20 02:07:39');
/*!40000 ALTER TABLE `system_settings` 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(32) DEFAULT NULL,
  `username` varchar(64) DEFAULT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(20) NOT NULL DEFAULT 'member',
  `rank` varchar(30) NOT NULL DEFAULT 'Starter',
  `dealer_status` varchar(30) NOT NULL DEFAULT 'Dealer',
  `package_id` bigint(20) unsigned DEFAULT NULL,
  `sponsor_id` bigint(20) unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_maintained` tinyint(1) NOT NULL DEFAULT 0,
  `maintenance_expires_at` timestamp NULL DEFAULT NULL,
  `balance` decimal(14,2) NOT NULL DEFAULT 0.00,
  `savings_balance` decimal(14,2) NOT NULL DEFAULT 0.00,
  `total_earned` decimal(14,2) NOT NULL DEFAULT 0.00,
  `total_withdrawn` decimal(14,2) NOT NULL DEFAULT 0.00,
  `replicated_store_settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`replicated_store_settings`)),
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_account_id_unique` (`account_id`),
  UNIQUE KEY `users_username_unique` (`username`),
  KEY `users_sponsor_id_index` (`sponsor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'100000000001','admin','Elevate','Administrator','Elevate Administrator','admin@elevatewell.ph','09170000000',NULL,'$2y$12$WMk0AeR7M9QrdFwaonsGQuNDhXysOKmh/bI4TnKcKJhbQ1uHKtZEm','admin','Platinum','Distributor',NULL,NULL,1,1,'2026-10-20 01:17:38',200.00,0.00,200.00,0.00,NULL,NULL,'2026-09-20 01:17:38','2026-09-20 01:17:38'),(2,'100000000002','juandelacruz','Juan','Dela Cruz','Juan Dela Cruz','juan@elevatewell.ph','09181234567',NULL,'$2y$12$V6NrJ6pcLb9AQJa20pcOxuDPqYcchWtwcWJ1BuDW0mP3ZnhRnCH6u','member','Starter','Dealer',1,1,1,1,'2026-10-20 01:17:38',1920.00,0.00,1920.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"JUAN DELA CRUZ\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 01:17:38','2026-09-20 02:05:42'),(53,'801775187020','ronald1','Ronald','1','Ronald 1','ronatorrejos1@gmail.com',NULL,NULL,'$2y$12$iRyJIo6MSTGPtSQoXgsYkOGxxURS2hq1Iblb8Cu0wmd6nPRydIllS','member','Starter','Dealer',1,2,1,0,NULL,410.00,0.00,410.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD 1\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 01:26:13','2026-09-20 02:00:54'),(93,'695428267141','ronald2','Ronald','2','Ronald 2','ronatorrejos2@gmail.com',NULL,NULL,'$2y$12$otHuHcNwqBh7DjF3N.RkiuAeSTT5rRh6KyN8gytTs/dcQsfwC7yOK','member','Starter','Dealer',1,2,1,0,NULL,410.00,0.00,410.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD 2\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 01:53:32','2026-09-20 02:05:42'),(94,'921056200142','ronald3','Ronald','3','Ronald 3','ronatorrejos3@gmail.com',NULL,NULL,'$2y$12$dqizmMoaNWbHrR/s40PP5uJ3HgKlfuIDZIdl.kyHC92dIQSY9gCWq','member','Starter','Dealer',1,53,1,0,NULL,0.00,0.00,0.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD 3\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 01:58:13','2026-09-20 01:58:13'),(95,'387149655148','ronald4','Ronald','4','Ronald 4','ronatorrejos4@gmail.com',NULL,NULL,'$2y$12$edXisfq.UUTCfvMUn6.R7.UrRgz.KIcxE0oevBjRYdQckw0Q3k9xi','member','Starter','Dealer',1,53,1,0,NULL,0.00,0.00,0.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD 4\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 02:00:28','2026-09-20 02:00:28'),(96,'734296017518','ronald5','Ronald','5','Ronald 5','ronatorrejos5@gmail.com',NULL,NULL,'$2y$12$/uM1Bxv8c1gv7q.rXQpyFeZGN3loglRD9iaYy5jkmJPKN3rgurPmm','member','Starter','Dealer',1,93,1,0,NULL,0.00,0.00,0.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD 5\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 02:03:37','2026-09-20 02:03:37'),(97,'812957647772','ronald6','Ronald','6','Ronald 6','ronatorrejos6@gmail.com',NULL,NULL,'$2y$12$1Yr0K.xi1kGtOZZ.8WcY4edD6kSDVrwMstqdUiodU6uiLjvXZuI.y','member','Starter','Dealer',1,93,1,0,NULL,0.00,0.00,0.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD 6\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 02:04:56','2026-09-20 02:04:56');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `withdrawals`
--

DROP TABLE IF EXISTS `withdrawals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `withdrawals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `reference_number` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `fee` decimal(10,2) NOT NULL DEFAULT 50.00,
  `net_amount` decimal(10,2) NOT NULL,
  `payout_method` varchar(30) NOT NULL,
  `account_name` varchar(255) NOT NULL,
  `account_number` varchar(255) NOT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `withdrawals_reference_number_unique` (`reference_number`),
  KEY `withdrawals_user_id_foreign` (`user_id`),
  CONSTRAINT `withdrawals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `withdrawals`
--

LOCK TABLES `withdrawals` WRITE;
/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-09-21 15:14:54