-- MySQL dump 10.13  Distrib 9.6.0, for macos26.2 (arm64)
--
-- Host: 127.0.0.1    Database: rocket_store
-- ------------------------------------------------------
-- Server version	9.6.0

/*!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 */;
/*!50503 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 `banners`
--

DROP TABLE IF EXISTS `banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `banners` (
  `id` int NOT NULL AUTO_INCREMENT,
  `image_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `sort_order` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banners`
--

LOCK TABLES `banners` WRITE;
/*!40000 ALTER TABLE `banners` DISABLE KEYS */;
INSERT INTO `banners` VALUES (1,'/uploads/1780686477967-367143965.jpeg','WhatsApp Image 2026-06-03 at 17.14.41 (1)',1,0,'2026-06-05 19:07:57');
/*!40000 ALTER TABLE `banners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `config` (
  `key_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`key_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES ('banner_subtitle','MUDAH • CEPAT • AMAN','2026-06-05 18:54:19'),('banner_title','BONGKAR DI ROCKET STORE','2026-06-05 18:54:19'),('bongkar_estimasi','1-5 Menit','2026-06-05 18:54:19'),('bongkar_min','1','2026-06-05 18:54:19'),('bongkar_rate','50000','2026-06-05 18:54:19'),('marquee_text','PROSES KILAT 1-3MENIT  •  MURAH, AMAN, DAN TERPERCAYA  •','2026-06-05 19:12:35'),('wa_admin','6281234567890','2026-06-05 18:54:19');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `games`
--

DROP TABLE IF EXISTS `games`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `games` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_url` text COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) DEFAULT '1',
  `sort_order` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `bongkar_rate` int DEFAULT '50000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `games`
--

LOCK TABLES `games` WRITE;
/*!40000 ALTER TABLE `games` DISABLE KEYS */;
INSERT INTO `games` VALUES (1,'Higgs Games Island','ZEUS - HU','/uploads/1780688222462-185979945.jpeg',1,NULL,'2026-06-05 18:54:19',5000),(2,'Royal Dream','CHIP EMAS VIP',NULL,1,NULL,'2026-06-05 18:54:19',10000);
/*!40000 ALTER TABLE `games` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_methods`
--

DROP TABLE IF EXISTS `payment_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_methods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  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 `payment_methods`
--

LOCK TABLES `payment_methods` WRITE;
/*!40000 ALTER TABLE `payment_methods` DISABLE KEYS */;
INSERT INTO `payment_methods` VALUES (1,'QRIS','qris',1),(2,'BCA','bank',1),(3,'Mandiri','bank',1),(4,'OVO','ewallet',1),(5,'GoPay','ewallet',1),(6,'Dana','ewallet',1);
/*!40000 ALTER TABLE `payment_methods` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `game_id` int DEFAULT NULL,
  `category` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int NOT NULL,
  `image_url` text COLLATE utf8mb4_unicode_ci,
  `stock` enum('READY','HABIS') COLLATE utf8mb4_unicode_ci DEFAULT 'READY',
  `sort_order` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `game_id` (`game_id`),
  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`game_id`) REFERENCES `games` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=26 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,1,'ZEUS','1B KARTU ZEUS',1000,'/uploads/1780688360556-634101651.jpeg','READY',NULL,'2026-06-05 18:54:19'),(2,1,'ZEUS','2B KARTU ZEUS',114000,NULL,'READY',2,'2026-06-05 18:54:19'),(3,1,'ZEUS','3B KARTU ZEUS',171000,NULL,'READY',3,'2026-06-05 18:54:19'),(4,1,'ZEUS','4B KARTU ZEUS',228000,NULL,'READY',4,'2026-06-05 18:54:19'),(5,2,NULL,'1B',20000,NULL,'READY',0,'2026-06-05 19:09:47'),(6,1,'HU','1B KARTU HU',55000,NULL,'READY',10,'2026-06-05 19:17:40'),(7,1,'HU','2B KARTU HU',110000,NULL,'READY',11,'2026-06-05 19:17:40'),(8,1,'HU','3B KARTU HU',165000,NULL,'READY',12,'2026-06-05 19:17:40'),(9,1,'HU','5B KARTU HU',275000,NULL,'READY',13,'2026-06-05 19:17:40'),(10,1,'HU','10B KARTU HU',550000,NULL,'READY',14,'2026-06-05 19:17:40'),(16,1,'ZEUS','5B KARTU ZEUS',570000,NULL,'READY',5,'2026-06-05 19:17:40'),(17,1,'ZEUS','10B KARTU ZEUS',1140000,NULL,'READY',6,'2026-06-05 19:17:40'),(18,2,NULL,'100M CHIP EMAS',8000,NULL,'READY',1,'2026-06-05 19:17:40'),(19,2,NULL,'200M CHIP EMAS',16000,NULL,'READY',2,'2026-06-05 19:17:40'),(20,2,NULL,'500M CHIP EMAS',38000,NULL,'READY',3,'2026-06-05 19:17:40'),(21,2,NULL,'1B CHIP EMAS',70000,NULL,'READY',4,'2026-06-05 19:17:40'),(22,2,NULL,'2B CHIP EMAS',135000,NULL,'READY',5,'2026-06-05 19:17:40'),(23,2,NULL,'5B CHIP EMAS',320000,NULL,'READY',6,'2026-06-05 19:17:40'),(24,2,NULL,'10B CHIP EMAS',600000,NULL,'READY',7,'2026-06-05 19:17:40'),(25,2,NULL,'20B CHIP EMAS',1150000,NULL,'READY',8,'2026-06-05 19:17:40');
/*!40000 ALTER TABLE `products` 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-06-10 20:55:18
