-- 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 */;

--
-- 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=17 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-BMIQ-XMZZ-GDOF','162123',1,1,103,1,'2026-09-20 23:35:46','2026-09-20 23:18:18','2026-09-20 23:35:46'),(2,'ELV-NVTK-SBBE-AQQI','395526',1,1,102,1,'2026-09-20 23:33:27','2026-09-20 23:18:18','2026-09-20 23:33:27'),(3,'ELV-3NDK-AHQN-GHBD','502418',1,1,101,1,'2026-09-20 23:31:29','2026-09-20 23:18:18','2026-09-20 23:31:29'),(4,'ELV-IHIG-3HEB-N1GY','872053',1,1,100,1,'2026-09-20 23:25:03','2026-09-20 23:18:18','2026-09-20 23:25:03'),(5,'ELV-2RZN-9GNW-41V7','501268',1,1,99,1,'2026-09-20 23:22:13','2026-09-20 23:18:18','2026-09-20 23:22:13'),(6,'ELV-4R6P-XS85-J1YF','191245',6,1,104,1,'2026-09-20 23:37:29','2026-09-20 23:36:50','2026-09-20 23:37:29'),(7,'ELV-4EB3-CAFD-3IFC','964295',6,1,NULL,0,NULL,'2026-09-20 23:36:50','2026-09-20 23:36:50'),(8,'ELV-PABF-9COJ-KYWJ','150661',6,1,NULL,0,NULL,'2026-09-20 23:36:50','2026-09-20 23:36:50'),(9,'ELV-8VGD-YGIH-GG3M','416950',6,1,NULL,0,NULL,'2026-09-20 23:36:50','2026-09-20 23:36:50'),(10,'ELV-NNYV-E791-IN2T','693461',6,1,NULL,0,NULL,'2026-09-20 23:36:50','2026-09-20 23:36:50');
/*!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=14 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=139 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,10600,0,0,0,NULL,'2026-09-20 01:17:38','2026-09-20 23:38:15'),(93,98,1,'left',0,9900,3,3,'2026-09-21','2026-09-20 23:19:06','2026-09-20 23:38:15'),(94,99,98,'left',100,100,0,0,'2026-09-21','2026-09-20 23:22:59','2026-09-20 23:33:46'),(95,100,98,'right',10000,100,0,0,'2026-09-21','2026-09-20 23:25:36','2026-09-20 23:38:15'),(96,101,99,'left',0,0,0,0,'2026-09-21','2026-09-20 23:31:53','2026-09-20 23:31:53'),(97,102,99,'right',0,0,0,0,'2026-09-21','2026-09-20 23:33:46','2026-09-20 23:33:46'),(98,103,100,'right',0,0,0,0,'2026-09-21','2026-09-20 23:36:08','2026-09-20 23:36:08'),(99,104,100,'left',0,0,0,0,'2026-09-21','2026-09-20 23:38:15','2026-09-20 23:38:15');
/*!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=18 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=33 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,98,99,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald2 Torrejos (Starter Package)','2026-09-20 23:22:13','2026-09-20 23:22:13'),(2,98,100,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Dala-dalay Buslo (Starter Package)','2026-09-20 23:25:03','2026-09-20 23:25:03'),(3,98,100,'unilevel',10.00,0.00,10.00,0,'Starter','Unilevel Leveling Bonus (Level 1) - Complete Line (2 Members)','2026-09-20 23:25:36','2026-09-20 23:25:36'),(4,99,101,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 4 (Starter Package)','2026-09-20 23:31:29','2026-09-20 23:31:29'),(5,99,102,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 5 (Starter Package)','2026-09-20 23:33:27','2026-09-20 23:33:27'),(6,99,102,'unilevel',10.00,0.00,10.00,0,'Starter','Unilevel Leveling Bonus (Level 1) - Complete Line (2 Members)','2026-09-20 23:33:46','2026-09-20 23:33:46'),(7,100,103,'direct',200.00,0.00,200.00,100,'Starter','Direct Referral Bonus from Ronald 6 (Starter Package)','2026-09-20 23:35:46','2026-09-20 23:35:46'),(8,100,104,'direct',20000.00,0.00,20000.00,10000,'Platinum','Direct Referral Bonus from Ronald 67 (Platinum Package)','2026-09-20 23:37:29','2026-09-20 23:37:29'),(9,98,NULL,'binary',500.00,0.00,500.00,100,NULL,'Binary Pairing Bonus (Pair #1)','2026-09-20 23:38:15','2026-09-20 23:38:15'),(10,98,NULL,'binary',500.00,0.00,500.00,100,NULL,'Binary Pairing Bonus (Pair #2)','2026-09-20 23:38:15','2026-09-20 23:38:15'),(11,98,NULL,'binary',500.00,0.00,500.00,100,NULL,'Binary Pairing Bonus (Pair #3)','2026-09-20 23:38:15','2026-09-20 23:38:15'),(12,100,104,'unilevel',10.00,0.00,10.00,0,'Platinum','Unilevel Leveling Bonus (Level 1) - Complete Line (2 Members)','2026-09-20 23:38:15','2026-09-20 23:38:15'),(13,98,104,'unilevel',10.00,0.00,10.00,0,'Platinum','Unilevel Leveling Bonus (Level 2) - Complete Line (4 Members)','2026-09-20 23:38:15','2026-09-20 23:38:15');
/*!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=16 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 ('f5XOP8u2JXvp0WJL4qOQS4D84RdQEAUYkOI1jDIt',NULL,'::1','curl/8.13.0','eyJfdG9rZW4iOiJraVp4TzhsNnFyVVAwMWdqdEVVRzVkbmxHNFp0MDIwMUk0SmF5V0E0IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9hZG1pblwvbG9naW4iLCJyb3V0ZSI6ImFkbWluLmxvZ2luIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1792995412),('GyG9rWDayvltSlE2IG6mpbjTq8ZsfS6GwPTHbUC5',NULL,'::1','curl/8.13.0','eyJfdG9rZW4iOiJEWXF3WmExRjBrN0NYUWNsZk4yU2Jua1FjUDU0M0M3V2IwVzRtSTQ3IiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1792994102),('ihJdr8boWYr67g3i4hHD95rTsuW6wl3uHmOPuxiz',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/156.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJ6ekdOeDVsc0NDOG5WZWN3NGJPdlRqdENpUTZSMTRWeDZIbHd1WnpEIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9FbGV2YXRlXC9wdWJsaWNcL25ldHdvcmtcL2dlbmVhbG9neSJ9LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9FbGV2YXRlXC9wdWJsaWNcL25ldHdvcmtcL2dlbmVhbG9neSIsInJvdXRlIjoibmV0d29yay5nZW5lYWxvZ3kifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1792993793),('JanMm60TiJw1VCylRhNMUyl6WcUTAMYynDdCNGLt',NULL,'::1','curl/8.13.0','eyJfdG9rZW4iOiJLVHpWbmVYcTA5RTNXMFp3WmhkNmJuSVBsVFA2ZElnVE1HU05WeXNtIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvRWxldmF0ZVwvcHVibGljXC9sb2dpbiIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1792995426),('qnZfzCpswPBu8U22tQP6kTYLrwS5PB1Y7li4i6rz',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/156.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJ6RTlUdjNNczMwcnNBWW56YTNBa1h6Q2lOQjdtTjVCRzNOQVNUb2hDIiwiX2ZsYXNoIjp7Im5ldyI6W10sIm9sZCI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9FbGV2YXRlXC9wdWJsaWNcL2xvZ2luIiwicm91dGUiOiJsb2dpbiJ9fQ==',1793000399),('r3Hw5qo2E72sxaTuPdv5lAL91vWCwFRyETt38U5l',1,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/156.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJRbG1EeUJwTm9udzBzSzEybEREa0pYSk8wN2FiOG9MM3pQckl2UXFoIiwiX2ZsYXNoIjp7Im5ldyI6W10sIm9sZCI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9FbGV2YXRlXC9wdWJsaWNcL2FkbWluXC9tZW1iZXJzIiwicm91dGUiOiJhZG1pbi5tZW1iZXJzIn0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjoxfQ==',1793000057);
/*!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=147 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',0.00,0.00,0.00,0.00,NULL,'FPYFm0wn7RGtUzsxEj9bKNnm3tqRoq6x1pHByrTHcI6wweGAAvR8ymyRrGcS','2026-09-20 01:17:38','2026-09-20 01:17:38'),(98,'594795897699','ronald1','Ronald','Torrejos','Ronald Torrejos','ronatorrejos1@gmail.com',NULL,NULL,'$2y$12$5km7AWYv9cEZqNbGAIeXu.GqNSPieXWy/zKg19RalH35JUdWfwzXS','member','Member','active',1,1,1,0,NULL,1920.00,0.00,1920.00,0.00,NULL,NULL,'2026-09-20 23:19:06','2026-09-20 23:38:15'),(99,'929518202612','ronald2torrejos','Ronald2','Torrejos','Ronald2 Torrejos','ronatorrejos2@gmail.com',NULL,NULL,'$2y$12$sKaQo6Og23j56qtnumwa2.ud0EsB6CnSRuqAZOyAST6X8H44j5aOK','member','Starter','Dealer',1,98,1,0,NULL,410.00,0.00,410.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD2 TORREJOS\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 23:22:13','2026-09-20 23:33:46'),(100,'987121141516','dala-dalaybuslo','Dala-dalay','Buslo','Dala-dalay Buslo','ronatorrejos3@gmail.com',NULL,NULL,'$2y$12$CsJRyPBm9s7sAuM0t3vQw.XlrEQiUhtVsu0QMkYqgsdXWnaGu19WC','member','Starter','Dealer',1,98,1,0,NULL,20210.00,0.00,20210.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"DALA-DALAY BUSLO\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 23:25:03','2026-09-20 23:38:15'),(101,'235353695312','ronald4','Ronald','4','Ronald 4','ronatorrejos4@gmail.com',NULL,NULL,'$2y$12$bNfUqbW.Ya/MhNpgrdiW7u4XMITCwyFBTz/R6B59B3U7Oro1awCOK','member','Starter','Dealer',1,99,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 23:31:28','2026-09-20 23:31:28'),(102,'418332794690','ronald5','Ronald','5','Ronald 5','ronatorrejos5@gmail.com',NULL,NULL,'$2y$12$epVQEtr7s8XDCyZ6LlbsXuoa1KoPBQalINwcRlkpoJUX0/MmyGipm','member','Starter','Dealer',1,99,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 23:33:27','2026-09-20 23:33:27'),(103,'700508760496','ronald6','Ronald','6','Ronald 6','ronatorrejos6@gmail.com',NULL,NULL,'$2y$12$wF9AuZW9rORbN4/wpvNwGeYhSS7RmDkYdhCvKnqdQsFMgCAr.zrcG','member','Starter','Dealer',1,100,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 23:35:46','2026-09-20 23:35:46'),(104,'396042428503','ronald67','Ronald','67','Ronald 67','ronatorrejos7@gmail.com',NULL,NULL,'$2y$12$Dn7AdYD/Do25zD/cbGxITOjATyUXnz7q4jdwhK2kGtbPD1aiEGjbi','member','Platinum','Dealer',6,100,1,0,NULL,0.00,0.00,0.00,0.00,'{\"visible\":true,\"show_badge\":true,\"show_account_id\":true,\"full_name\":\"RONALD 67\",\"welcome\":\"Welcome to my official Elevatewell site! Elevate your wellness with pure organic barley.\",\"tagline\":\"Your Business. Your Wellness.\"}',NULL,'2026-09-20 23:37:29','2026-09-20 23:37:29');
/*!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=5 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-10-26 15:42:23