/*M!999999\- enable the sandbox mode */ 

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

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
INSERT INTO `cache` VALUES ('kultura-cache-toko.settings','a:0:{}',2107581939);
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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 */;

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Kaos Lengan Pendek','kaos-lengan-pendek','Kaos cotton combed dengan sablon awet untuk dipakai setiap hari.',1,'2026-10-09 21:54:42','2026-10-09 21:54:42'),(2,'Long Sleeve','long-sleeve','Kaos lengan panjang yang tetap adem, cocok untuk gaya kasual maupun layering.',2,'2026-10-09 21:54:42','2026-10-09 21:54:42'),(3,'Kemeja','kemeja','Kemeja flanel, linen, dan denim untuk tampilan rapi tapi santai.',3,'2026-10-09 21:54:42','2026-10-09 21:54:42'),(4,'Hoodie & Crewneck','hoodie-crewneck','Fleece tebal dan lembut, hangat untuk cuaca dingin dan perjalanan malam.',4,'2026-10-09 21:54:42','2026-10-09 21:54:42'),(5,'Jaket','jaket','Jaket coach dan denim yang kuat, ringan, dan gampang dipadukan.',5,'2026-10-09 21:54:42','2026-10-09 21:54:42'),(6,'Aksesoris','aksesoris','Topi dan totebag pelengkap gaya harianmu.',6,'2026-10-09 21:54:42','2026-10-09 21:54:42'),(7,'Celana Denim','celana-denim','Pilihan celana modern untuk gaya harian.',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(8,'Celana','celana','Pilihan celana modern untuk gaya harian.',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(9,'Polo','polo','Pilihan produk untuk gaya harian.',7,'2026-10-17 14:25:39','2026-10-17 14:25:39');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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 */;

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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 */;

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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 */;

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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_01_01_000050_create_settings_table',1),(5,'2026_01_01_000100_create_categories_table',1),(6,'2026_01_01_000200_create_products_table',1),(7,'2026_01_01_000250_create_payment_channels_table',1),(8,'2026_01_01_000300_create_orders_table',1),(9,'2026_10_09_000100_upgrade_store_features',1),(10,'2026_10_09_000200_distance_delivery',1),(11,'2026_10_10_000300_catalog_profile_branding',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `order_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `actor_id` bigint(20) unsigned DEFAULT NULL,
  `from_status` varchar(20) DEFAULT NULL,
  `to_status` varchar(20) NOT NULL,
  `description` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_events_order_id_foreign` (`order_id`),
  KEY `order_events_actor_id_foreign` (`actor_id`),
  CONSTRAINT `order_events_actor_id_foreign` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_events_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 */;

LOCK TABLES `order_events` WRITE;
/*!40000 ALTER TABLE `order_events` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_events` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `order_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `product_variant_id` bigint(20) unsigned DEFAULT NULL,
  `product_name` varchar(150) NOT NULL,
  `size` varchar(20) NOT NULL,
  `price` int(10) unsigned NOT NULL,
  `qty` int(10) unsigned NOT NULL,
  `subtotal` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  KEY `order_items_product_id_foreign` (`product_id`),
  KEY `order_items_product_variant_id_foreign` (`product_variant_id`),
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_items_product_variant_id_foreign` FOREIGN KEY (`product_variant_id`) REFERENCES `product_variants` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `order_items` WRITE;
/*!40000 ALTER TABLE `order_items` DISABLE KEYS */;
INSERT INTO `order_items` VALUES (1,1,16,67,'Totebag Kanvas \"Monstera\"','All Size',75000,1,75000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Natural'),(2,1,4,18,'Kaos Ringer Retro','L',109000,1,109000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream / Maroon'),(3,2,1,1,'Kaos \"Kota Senja\"','S',129000,1,129000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(4,3,11,50,'Hoodie \"Misty\"','XL',289000,1,289000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Abu Misty'),(5,4,13,60,'Jaket Coach Windbreaker','XXL',299000,1,299000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(6,5,11,50,'Hoodie \"Misty\"','XL',289000,1,289000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Abu Misty'),(7,5,12,55,'Crewneck \"Forest Range\"','XL',249000,1,249000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hijau Hutan'),(8,6,2,9,'Kaos Basic Heavyweight','XL',99000,2,198000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Off White'),(9,7,14,63,'Jaket Denim Trucker','L',349000,1,349000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(10,8,6,28,'Long Sleeve Stripe Marine','L',149000,1,149000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy / Putih'),(11,8,3,13,'Kaos \"Ombak Selatan\"','L',125000,1,125000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy'),(12,8,8,38,'Kemeja Flanel Kotak \"Lumber\"','XXL',219000,1,219000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Merah / Hitam'),(13,9,9,40,'Kemeja Linen Resort','M',199000,1,199000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sage'),(14,10,13,60,'Jaket Coach Windbreaker','XXL',299000,2,598000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(15,11,12,55,'Crewneck \"Forest Range\"','XL',249000,1,249000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hijau Hutan'),(16,12,8,34,'Kemeja Flanel Kotak \"Lumber\"','S',219000,1,219000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Merah / Hitam'),(17,13,6,29,'Long Sleeve Stripe Marine','XL',149000,1,149000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy / Putih'),(18,14,6,26,'Long Sleeve Stripe Marine','S',149000,1,149000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy / Putih'),(19,15,15,66,'Topi 6 Panel \"Bintang\"','All Size',89000,1,89000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream'),(20,16,10,46,'Kemeja Denim Washed','XXL',239000,2,478000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(21,17,6,27,'Long Sleeve Stripe Marine','M',149000,1,149000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy / Putih'),(22,18,11,47,'Hoodie \"Misty\"','S',289000,1,289000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Abu Misty'),(23,18,2,9,'Kaos Basic Heavyweight','XL',99000,1,99000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Off White'),(24,19,5,25,'Long Sleeve \"Nusantara\"','XXL',165000,1,165000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(25,20,5,25,'Long Sleeve \"Nusantara\"','XXL',165000,1,165000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(26,21,14,61,'Jaket Denim Trucker','S',349000,1,349000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(27,21,12,54,'Crewneck \"Forest Range\"','L',249000,2,498000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hijau Hutan'),(28,22,3,13,'Kaos \"Ombak Selatan\"','L',125000,1,125000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy'),(29,23,13,60,'Jaket Coach Windbreaker','XXL',299000,1,299000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(30,24,11,51,'Hoodie \"Misty\"','XXL',289000,1,289000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Abu Misty'),(31,24,13,57,'Jaket Coach Windbreaker','M',299000,2,598000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(32,25,4,17,'Kaos Ringer Retro','M',109000,1,109000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream / Maroon'),(33,26,14,63,'Jaket Denim Trucker','L',349000,2,698000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(34,26,10,43,'Kemeja Denim Washed','M',239000,2,478000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(35,27,10,45,'Kemeja Denim Washed','XL',239000,1,239000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(36,27,15,66,'Topi 6 Panel \"Bintang\"','All Size',89000,2,178000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream'),(37,28,12,53,'Crewneck \"Forest Range\"','M',249000,1,249000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hijau Hutan'),(38,29,15,66,'Topi 6 Panel \"Bintang\"','All Size',89000,1,89000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream'),(39,29,16,67,'Totebag Kanvas \"Monstera\"','All Size',75000,1,75000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Natural'),(40,30,11,49,'Hoodie \"Misty\"','L',289000,1,289000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Abu Misty'),(41,30,6,26,'Long Sleeve Stripe Marine','S',149000,2,298000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy / Putih'),(42,31,6,26,'Long Sleeve Stripe Marine','S',149000,1,149000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy / Putih'),(43,32,13,59,'Jaket Coach Windbreaker','XL',299000,1,299000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(44,33,4,16,'Kaos Ringer Retro','S',109000,1,109000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream / Maroon'),(45,34,12,56,'Crewneck \"Forest Range\"','XXL',249000,1,249000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hijau Hutan'),(46,34,6,26,'Long Sleeve Stripe Marine','S',149000,2,298000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Navy / Putih'),(47,34,15,66,'Topi 6 Panel \"Bintang\"','All Size',89000,1,89000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream'),(48,35,4,18,'Kaos Ringer Retro','L',109000,1,109000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream / Maroon'),(49,36,14,62,'Jaket Denim Trucker','M',349000,1,349000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(50,37,14,61,'Jaket Denim Trucker','S',349000,1,349000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Biru Denim'),(51,37,4,16,'Kaos Ringer Retro','S',109000,2,218000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream / Maroon'),(52,38,1,5,'Kaos \"Kota Senja\"','XXL',129000,1,129000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hitam'),(53,39,4,17,'Kaos Ringer Retro','M',109000,1,109000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Cream / Maroon'),(54,39,12,54,'Crewneck \"Forest Range\"','L',249000,2,498000,'2026-10-09 21:54:44','2026-10-09 21:54:44','Hijau Hutan');
/*!40000 ALTER TABLE `order_items` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(30) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `recipient_name` varchar(100) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `payment_method` varchar(20) NOT NULL DEFAULT 'va',
  `payment_channel_id` bigint(20) unsigned DEFAULT NULL,
  `payment_channel` varchar(60) DEFAULT NULL,
  `payment_account` varchar(40) DEFAULT NULL,
  `payment_account_name` varchar(100) DEFAULT NULL,
  `subtotal` bigint(20) unsigned NOT NULL,
  `shipping_cost` int(10) unsigned NOT NULL DEFAULT 0,
  `total` bigint(20) unsigned NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'menunggu',
  `payment_proof` varchar(255) DEFAULT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `checkout_token` char(36) DEFAULT NULL,
  `province` varchar(2) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `district` varchar(100) DEFAULT NULL,
  `postal_code` varchar(5) DEFAULT NULL,
  `shipping_name` varchar(150) DEFAULT NULL,
  `shipping_estimate` varchar(40) DEFAULT NULL,
  `payment_qr` varchar(255) DEFAULT NULL,
  `payment_instructions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_instructions`)),
  `verified_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `stock_reserved` tinyint(1) NOT NULL DEFAULT 1,
  `delivery_lat` decimal(10,7) DEFAULT NULL,
  `delivery_lng` decimal(10,7) DEFAULT NULL,
  `origin_lat` decimal(10,7) DEFAULT NULL,
  `origin_lng` decimal(10,7) DEFAULT NULL,
  `distance_meters` int(10) unsigned DEFAULT NULL,
  `shipping_base_cost` int(10) unsigned DEFAULT NULL,
  `shipping_discount` int(10) unsigned NOT NULL DEFAULT 0,
  `distance_method` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_code_unique` (`code`),
  UNIQUE KEY `orders_checkout_token_unique` (`checkout_token`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_payment_channel_id_foreign` (`payment_channel_id`),
  KEY `orders_created_at_index` (`created_at`),
  KEY `orders_status_index` (`status`),
  KEY `orders_expires_at_index` (`expires_at`),
  CONSTRAINT `orders_payment_channel_id_foreign` FOREIGN KEY (`payment_channel_id`) REFERENCES `payment_channels` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (1,'KLT260513JVDS',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135',NULL,'va',1,'BCA','39358 0812 3456 7890','Kultura Supply',184000,15000,199000,'selesai','payment-proofs/KLT260513JVDS-demo.jpg','2026-05-13 12:02:25',NULL,'2026-05-13 10:15:25','2026-05-17 10:15:25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BCA, atau datangi ATM BCA.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-05-13 12:02:25',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(2,'KLT260509S22A',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',129000,15000,144000,'selesai','payment-proofs/KLT260509S22A-demo.jpg','2026-05-09 18:43:06',NULL,'2026-05-09 17:11:06','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260509S22A.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-05-09 18:43:06',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(3,'KLT26052382KC',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135',NULL,'va',4,'BRI','26215 0812 3456 7890','Kultura Supply',289000,15000,304000,'selesai','payment-proofs/KLT26052382KC-demo.jpg','2026-05-23 17:52:47',NULL,'2026-05-23 16:26:47','2026-05-27 16:26:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BRI, atau datangi ATM BRI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-05-23 17:52:47',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(4,'KLT26051562VR',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281',NULL,'va',4,'BRI','26215 0812 3456 7890','Kultura Supply',299000,15000,314000,'selesai','payment-proofs/KLT26051562VR-demo.jpg','2026-05-15 14:33:27',NULL,'2026-05-15 12:39:27','2026-05-19 12:39:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BRI, atau datangi ATM BRI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-05-15 14:33:27',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(5,'KLT260619KVGV',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135','Tolong packing rapi ya, untuk kado.','qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',538000,15000,553000,'batal',NULL,NULL,'2026-06-20 08:41:51','2026-06-19 08:41:51','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260619KVGV.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(6,'KLT260605MXBY',4,'Dimas Saputra','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',198000,15000,213000,'selesai','payment-proofs/KLT260605MXBY-demo.jpg','2026-06-05 11:09:17',NULL,'2026-06-05 10:31:17','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260605MXBY.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-06-05 11:09:17',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(7,'KLT260629E6XC',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281','Tolong packing rapi ya, untuk kado.','qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',349000,15000,364000,'selesai','payment-proofs/KLT260629E6XC-demo.jpg','2026-06-29 14:03:09',NULL,'2026-06-29 13:35:09','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260629E6XC.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-06-29 14:03:09',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(8,'KLT2606224NRT',6,'Fajar Nugroho','082155556666','Jl. Tebet Raya No. 9, Tebet\nJakarta Selatan 12820',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',493000,15000,508000,'selesai','payment-proofs/KLT2606224NRT-demo.jpg','2026-06-22 23:05:42',NULL,'2026-06-22 20:20:42','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT2606224NRT.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-06-22 23:05:42',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(9,'KLT260610YSW7',6,'Fajar Nugroho','082155556666','Jl. Tebet Raya No. 9, Tebet\nJakarta Selatan 12820',NULL,'va',3,'BNI','8808 0812 3456 7890','Kultura Supply',199000,15000,214000,'selesai','payment-proofs/KLT260610YSW7-demo.jpg','2026-06-10 14:26:12',NULL,'2026-06-10 11:34:12','2026-06-14 11:34:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BNI, atau datangi ATM BNI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-06-10 14:26:12',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(10,'KLT260715MJ99',7,'Nadia Putri','087866667777','Jl. Gatot Subroto No. 88, Denpasar Barat\nBali 80119','Tolong packing rapi ya, untuk kado.','qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',598000,15000,613000,'selesai','payment-proofs/KLT260715MJ99-demo.jpg','2026-07-15 12:05:22',NULL,'2026-07-15 09:58:22','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260715MJ99.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-07-15 12:05:22',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(11,'KLT260722QUNQ',4,'Dimas Saputra','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275','Tolong packing rapi ya, untuk kado.','qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',249000,15000,264000,'selesai','payment-proofs/KLT260722QUNQ-demo.jpg','2026-07-22 16:43:10',NULL,'2026-07-22 14:16:10','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260722QUNQ.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-07-22 16:43:10',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12,'KLT260716FH2W',7,'Nadia Putri','087866667777','Jl. Gatot Subroto No. 88, Denpasar Barat\nBali 80119',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',219000,15000,234000,'batal',NULL,NULL,'2026-07-17 10:54:57','2026-07-16 10:54:57','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260716FH2W.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(13,'KLT260726FXE5',7,'Nadia Putri','087866667777','Jl. Gatot Subroto No. 88, Denpasar Barat\nBali 80119',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',149000,15000,164000,'selesai','payment-proofs/KLT260726FXE5-demo.jpg','2026-07-26 09:58:27',NULL,'2026-07-26 09:23:27','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260726FXE5.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-07-26 09:58:27',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(14,'KLT260704AKZC',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',149000,15000,164000,'selesai','payment-proofs/KLT260704AKZC-demo.jpg','2026-07-04 19:39:53',NULL,'2026-07-04 18:09:53','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260704AKZC.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-07-04 19:39:53',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(15,'KLT2607133UUM',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135',NULL,'va',3,'BNI','8808 0812 3456 7890','Kultura Supply',89000,15000,104000,'batal',NULL,NULL,'2026-07-14 18:57:02','2026-07-13 18:57:02','2026-07-14 18:57:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BNI, atau datangi ATM BNI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(16,'KLT260829GS99',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135',NULL,'va',1,'BCA','39358 0812 3456 7890','Kultura Supply',478000,15000,493000,'selesai','payment-proofs/KLT260829GS99-demo.jpg','2026-08-29 18:09:26',NULL,'2026-08-29 15:49:26','2026-09-02 15:49:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BCA, atau datangi ATM BCA.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-08-29 18:09:26',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(17,'KLT2608229A4Q',5,'Ayu Lestari','085244445555','Jl. Raya Darmo No. 45, Wonokromo\nSurabaya, Jawa Timur 60241','Tolong packing rapi ya, untuk kado.','va',6,'CIMB Niaga','5919 0812 3456 7890','Kultura Supply',149000,15000,164000,'selesai','payment-proofs/KLT2608229A4Q-demo.jpg','2026-08-22 12:05:42',NULL,'2026-08-22 09:54:42','2026-08-26 09:54:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking CIMB Niaga, atau datangi ATM CIMB Niaga.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-08-22 12:05:42',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(18,'KLT260814Q9MM',5,'Ayu Lestari','085244445555','Jl. Raya Darmo No. 45, Wonokromo\nSurabaya, Jawa Timur 60241','Tolong packing rapi ya, untuk kado.','qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',388000,15000,403000,'selesai','payment-proofs/KLT260814Q9MM-demo.jpg','2026-08-14 22:01:13',NULL,'2026-08-14 20:02:13','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260814Q9MM.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-08-14 22:01:13',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(19,'KLT2608082XRF',6,'Fajar Nugroho','082155556666','Jl. Tebet Raya No. 9, Tebet\nJakarta Selatan 12820',NULL,'va',5,'Permata','8625 0812 3456 7890','Kultura Supply',165000,15000,180000,'selesai','payment-proofs/KLT2608082XRF-demo.jpg','2026-08-08 13:09:07',NULL,'2026-08-08 10:55:07','2026-08-12 10:55:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking Permata, atau datangi ATM Permata.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-08-08 13:09:07',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(20,'KLT260801PPRT',7,'Nadia Putri','087866667777','Jl. Gatot Subroto No. 88, Denpasar Barat\nBali 80119',NULL,'va',5,'Permata','8625 0812 3456 7890','Kultura Supply',165000,15000,180000,'selesai','payment-proofs/KLT260801PPRT-demo.jpg','2026-08-01 18:37:49',NULL,'2026-08-01 16:09:49','2026-08-05 16:09:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking Permata, atau datangi ATM Permata.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-08-01 18:37:49',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(21,'KLT260827YP2R',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281',NULL,'va',1,'BCA','39358 0812 3456 7890','Kultura Supply',847000,15000,862000,'selesai','payment-proofs/KLT260827YP2R-demo.jpg','2026-08-27 09:58:39',NULL,'2026-08-27 08:20:39','2026-08-31 08:20:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BCA, atau datangi ATM BCA.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-08-27 09:58:39',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(22,'KLT2609134HB5',5,'Ayu Lestari','085244445555','Jl. Raya Darmo No. 45, Wonokromo\nSurabaya, Jawa Timur 60241',NULL,'va',3,'BNI','8808 0812 3456 7890','Kultura Supply',125000,15000,140000,'batal',NULL,NULL,'2026-09-14 19:12:46','2026-09-13 19:12:46','2026-09-14 19:12:46',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BNI, atau datangi ATM BNI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(23,'KLT260919Y4AT',7,'Nadia Putri','087866667777','Jl. Gatot Subroto No. 88, Denpasar Barat\nBali 80119',NULL,'va',2,'Mandiri','89508 0812 3456 7890','Kultura Supply',299000,15000,314000,'selesai','payment-proofs/KLT260919Y4AT-demo.jpg','2026-09-19 13:57:15',NULL,'2026-09-19 11:03:15','2026-09-23 11:03:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking Mandiri, atau datangi ATM Mandiri.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-09-19 13:57:15',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(24,'KLT260913PGNM',4,'Dimas Saputra','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',887000,15000,902000,'selesai','payment-proofs/KLT260913PGNM-demo.jpg','2026-09-13 18:37:38',NULL,'2026-09-13 16:01:38','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260913PGNM.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-09-13 18:37:38',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(25,'KLT260926TWZ5',4,'Dimas Saputra','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275','Tolong packing rapi ya, untuk kado.','va',3,'BNI','8808 0812 3456 7890','Kultura Supply',109000,15000,124000,'selesai','payment-proofs/KLT260926TWZ5-demo.jpg','2026-09-26 10:35:57',NULL,'2026-09-26 09:44:57','2026-09-30 09:44:57',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BNI, atau datangi ATM BNI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-09-26 10:35:57',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(26,'KLT260926ZZ3V',5,'Ayu Lestari','085244445555','Jl. Raya Darmo No. 45, Wonokromo\nSurabaya, Jawa Timur 60241',NULL,'va',6,'CIMB Niaga','5919 0812 3456 7890','Kultura Supply',1176000,15000,1191000,'selesai','payment-proofs/KLT260926ZZ3V-demo.jpg','2026-09-26 12:25:35',NULL,'2026-09-26 10:50:35','2026-09-30 10:50:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking CIMB Niaga, atau datangi ATM CIMB Niaga.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-09-26 12:25:35',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(27,'KLT260912SFBU',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',417000,15000,432000,'selesai','payment-proofs/KLT260912SFBU-demo.jpg','2026-09-12 15:25:20',NULL,'2026-09-12 13:48:20','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT260912SFBU.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-09-12 15:25:20',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(28,'KLT260912644M',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135','Tolong packing rapi ya, untuk kado.','va',6,'CIMB Niaga','5919 0812 3456 7890','Kultura Supply',249000,15000,264000,'selesai','payment-proofs/KLT260912644M-demo.jpg','2026-09-12 10:34:44',NULL,'2026-09-12 08:45:44','2026-09-16 08:45:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking CIMB Niaga, atau datangi ATM CIMB Niaga.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-09-12 10:34:44',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(29,'KLT261001WJ5Y',7,'Nadia Putri','087866667777','Jl. Gatot Subroto No. 88, Denpasar Barat\nBali 80119','Tolong packing rapi ya, untuk kado.','qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',164000,15000,179000,'selesai','payment-proofs/KLT261001WJ5Y-demo.jpg','2026-10-01 14:57:42',NULL,'2026-10-01 12:41:42','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT261001WJ5Y.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-10-01 14:57:42',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(30,'KLT261004WUMW',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',587000,15000,602000,'dikirim','payment-proofs/KLT261004WUMW-demo.jpg','2026-10-04 21:07:27',NULL,'2026-10-04 20:39:27','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT261004WUMW.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-10-04 21:07:27',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(31,'KLT261003ZPUY',4,'Dimas Saputra','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275',NULL,'va',4,'BRI','26215 0812 3456 7890','Kultura Supply',149000,15000,164000,'dikirim','payment-proofs/KLT261003ZPUY-demo.jpg','2026-10-03 21:12:19',NULL,'2026-10-03 20:02:19','2026-10-04 20:02:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BRI, atau datangi ATM BRI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-10-03 21:12:19',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(32,'KLT261002NYVR',4,'Dimas Saputra','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275',NULL,'va',1,'BCA','39358 0812 3456 7890','Kultura Supply',299000,15000,314000,'dikirim','payment-proofs/KLT261002NYVR-demo.jpg','2026-10-02 10:22:26',NULL,'2026-10-02 09:58:26','2026-10-03 09:58:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BCA, atau datangi ATM BCA.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-10-02 10:22:26',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(33,'KLT261009QFDD',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281',NULL,'va',1,'BCA','39358 0812 3456 7890','Kultura Supply',109000,15000,124000,'menunggu',NULL,NULL,NULL,'2026-10-09 19:10:05','2026-10-09 19:10:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BCA, atau datangi ATM BCA.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(34,'KLT261006ELG2',5,'Ayu Lestari','085244445555','Jl. Raya Darmo No. 45, Wonokromo\nSurabaya, Jawa Timur 60241',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',636000,15000,651000,'dikirim','payment-proofs/KLT261006ELG2-demo.jpg','2026-10-06 15:31:03',NULL,'2026-10-06 13:20:03','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT261006ELG2.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-10-06 15:31:03',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(35,'KLT261009MXTP',6,'Fajar Nugroho','082155556666','Jl. Tebet Raya No. 9, Tebet\nJakarta Selatan 12820',NULL,'va',3,'BNI','8808 0812 3456 7890','Kultura Supply',109000,15000,124000,'menunggu',NULL,NULL,NULL,'2026-10-09 19:25:39','2026-10-09 19:25:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BNI, atau datangi ATM BNI.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(36,'KLT261009W53F',5,'Ayu Lestari','085244445555','Jl. Raya Darmo No. 45, Wonokromo\nSurabaya, Jawa Timur 60241',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',349000,15000,364000,'diproses','payment-proofs/KLT261009W53F-demo.jpg','2026-10-09 15:03:59',NULL,'2026-10-09 14:07:59','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT261009W53F.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]','2026-10-09 15:03:59',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(37,'KLT261009E7LC',2,'Rizky Pratama','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135',NULL,'va',1,'BCA','39358 0812 3456 7890','Kultura Supply',567000,15000,582000,'menunggu',NULL,NULL,NULL,'2026-10-09 19:54:44','2026-10-09 19:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking BCA, atau datangi ATM BCA.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(38,'KLT261009Y7AM',3,'Salsa Nabila','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281',NULL,'qris',8,'QRIS','ID1026123456789','KULTURA SUPPLY',129000,15000,144000,'dibayar','payment-proofs/KLT261009Y7AM-demo.jpg','2026-10-09 17:38:44',NULL,'2026-10-09 16:54:44','2026-10-09 21:54:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'payment-assets/KLT261009Y7AM.png','[\"Buka aplikasi e-wallet atau m-banking yang mendukung QRIS.\",\"Pilih menu Scan \\/ Bayar, lalu scan kode QR di atas.\",\"Pastikan nama merchant sesuai, lalu masukkan nominal sesuai total pesanan.\",\"Selesaikan pembayaran, lalu screenshot bukti bayarnya.\",\"Unggah bukti pembayaran di halaman ini.\"]',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(39,'KLT261008TF4W',4,'Dimas Saputra','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275','Tolong packing rapi ya, untuk kado.','va',2,'Mandiri','89508 0812 3456 7890','Kultura Supply',607000,15000,622000,'diproses','payment-proofs/KLT261008TF4W-demo.jpg','2026-10-09 00:48:44',NULL,'2026-10-08 21:54:44','2026-10-09 00:48:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Buka m-banking \\/ internet banking Mandiri, atau datangi ATM Mandiri.\",\"Pilih menu Transfer \\u203a Virtual Account (atau Bayar \\u203a Virtual Account).\",\"Masukkan nomor Virtual Account di atas.\",\"Pastikan nama penerima dan nominal sesuai total pesanan, lalu konfirmasi.\",\"Simpan bukti pembayaran, lalu unggah di halaman ini.\"]','2026-10-09 00:48:44',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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 */;

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `payment_channels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_channels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `code` varchar(30) DEFAULT NULL,
  `name` varchar(60) NOT NULL,
  `account_number` varchar(40) DEFAULT NULL,
  `account_name` varchar(100) DEFAULT NULL,
  `qr_image` varchar(255) DEFAULT NULL,
  `instructions` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `logo_image` varchar(255) DEFAULT NULL,
  `logo_background` varchar(7) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_channels_type_index` (`type`),
  KEY `payment_channels_is_active_index` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `payment_channels` WRITE;
/*!40000 ALTER TABLE `payment_channels` DISABLE KEYS */;
INSERT INTO `payment_channels` VALUES (1,'va','bca','BCA','39358 0812 3456 7890','Kultura Supply',NULL,NULL,1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL),(2,'va','mandiri','Mandiri','89508 0812 3456 7890','Kultura Supply',NULL,NULL,1,2,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL),(3,'va','bni','BNI','8808 0812 3456 7890','Kultura Supply',NULL,NULL,1,3,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL),(4,'va','bri','BRI','26215 0812 3456 7890','Kultura Supply',NULL,NULL,1,4,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL),(5,'va','permata','Permata','8625 0812 3456 7890','Kultura Supply',NULL,NULL,1,5,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL),(6,'va','cimb','CIMB Niaga','5919 0812 3456 7890','Kultura Supply',NULL,NULL,1,6,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL),(7,'va','bsi','BSI','9347 0812 3456 7890','Kultura Supply',NULL,NULL,0,7,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL),(8,'qris',NULL,'QRIS','ID1026123456789','KULTURA SUPPLY','assets/img/qris-demo.png',NULL,1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',NULL,NULL);
/*!40000 ALTER TABLE `payment_channels` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `product_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `path` varchar(255) NOT NULL,
  `caption` varchar(150) DEFAULT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_images_product_id_foreign` (`product_id`),
  CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `product_images` WRITE;
/*!40000 ALTER TABLE `product_images` DISABLE KEYS */;
INSERT INTO `product_images` VALUES (1,1,'assets/img/products/gallery/kaos-kota-senja-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(2,1,'assets/img/products/gallery/kaos-kota-senja-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(3,1,'assets/img/products/gallery/kaos-kota-senja-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(4,1,'assets/img/products/gallery/kaos-kota-senja-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(5,2,'assets/img/products/gallery/kaos-basic-heavyweight-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(6,2,'assets/img/products/gallery/kaos-basic-heavyweight-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(7,2,'assets/img/products/gallery/kaos-basic-heavyweight-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(8,2,'assets/img/products/gallery/kaos-basic-heavyweight-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(9,3,'assets/img/products/gallery/kaos-ombak-selatan-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(10,3,'assets/img/products/gallery/kaos-ombak-selatan-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(11,3,'assets/img/products/gallery/kaos-ombak-selatan-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(12,3,'assets/img/products/gallery/kaos-ombak-selatan-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(13,4,'assets/img/products/gallery/kaos-ringer-retro-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(14,4,'assets/img/products/gallery/kaos-ringer-retro-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(15,4,'assets/img/products/gallery/kaos-ringer-retro-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(16,4,'assets/img/products/gallery/kaos-ringer-retro-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(17,5,'assets/img/products/gallery/longsleeve-nusantara-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(18,5,'assets/img/products/gallery/longsleeve-nusantara-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(19,5,'assets/img/products/gallery/longsleeve-nusantara-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(20,5,'assets/img/products/gallery/longsleeve-nusantara-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(21,6,'assets/img/products/gallery/longsleeve-stripe-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(22,6,'assets/img/products/gallery/longsleeve-stripe-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(23,6,'assets/img/products/gallery/longsleeve-stripe-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(24,6,'assets/img/products/gallery/longsleeve-stripe-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(25,7,'assets/img/products/gallery/longsleeve-waffle-henley-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(26,7,'assets/img/products/gallery/longsleeve-waffle-henley-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(27,7,'assets/img/products/gallery/longsleeve-waffle-henley-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(28,7,'assets/img/products/gallery/longsleeve-waffle-henley-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(29,8,'assets/img/products/gallery/kemeja-flanel-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(30,8,'assets/img/products/gallery/kemeja-flanel-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(31,8,'assets/img/products/gallery/kemeja-flanel-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(32,8,'assets/img/products/gallery/kemeja-flanel-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(33,9,'assets/img/products/gallery/kemeja-linen-resort-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(34,9,'assets/img/products/gallery/kemeja-linen-resort-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(35,9,'assets/img/products/gallery/kemeja-linen-resort-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(36,9,'assets/img/products/gallery/kemeja-linen-resort-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(37,10,'assets/img/products/gallery/kemeja-denim-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(38,10,'assets/img/products/gallery/kemeja-denim-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(39,10,'assets/img/products/gallery/kemeja-denim-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(40,10,'assets/img/products/gallery/kemeja-denim-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(41,11,'assets/img/products/gallery/hoodie-misty-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(42,11,'assets/img/products/gallery/hoodie-misty-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(43,11,'assets/img/products/gallery/hoodie-misty-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(44,11,'assets/img/products/gallery/hoodie-misty-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(45,12,'assets/img/products/gallery/crewneck-forest-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(46,12,'assets/img/products/gallery/crewneck-forest-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(47,12,'assets/img/products/gallery/crewneck-forest-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(48,12,'assets/img/products/gallery/crewneck-forest-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(49,13,'assets/img/products/gallery/jaket-coach-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(50,13,'assets/img/products/gallery/jaket-coach-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(51,13,'assets/img/products/gallery/jaket-coach-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(52,13,'assets/img/products/gallery/jaket-coach-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(53,14,'assets/img/products/gallery/jaket-denim-trucker-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(54,14,'assets/img/products/gallery/jaket-denim-trucker-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(55,14,'assets/img/products/gallery/jaket-denim-trucker-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(56,14,'assets/img/products/gallery/jaket-denim-trucker-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(57,15,'assets/img/products/gallery/topi-bintang-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(58,15,'assets/img/products/gallery/topi-bintang-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(59,15,'assets/img/products/gallery/topi-bintang-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(60,15,'assets/img/products/gallery/topi-bintang-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(61,16,'assets/img/products/gallery/totebag-monstera-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(62,16,'assets/img/products/gallery/totebag-monstera-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(63,16,'assets/img/products/gallery/totebag-monstera-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(64,16,'assets/img/products/gallery/totebag-monstera-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(65,17,'assets/img/products/gallery/blok-m-boxy-espresso-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(66,17,'assets/img/products/gallery/blok-m-boxy-espresso-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(67,17,'assets/img/products/gallery/blok-m-boxy-espresso-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(68,17,'assets/img/products/gallery/blok-m-boxy-espresso-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(69,18,'assets/img/products/gallery/senopati-knit-polo-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(70,18,'assets/img/products/gallery/senopati-knit-polo-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(71,18,'assets/img/products/gallery/senopati-knit-polo-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(72,18,'assets/img/products/gallery/senopati-knit-polo-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(73,19,'assets/img/products/gallery/scbd-oxford-blue-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(74,19,'assets/img/products/gallery/scbd-oxford-blue-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(75,19,'assets/img/products/gallery/scbd-oxford-blue-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(76,19,'assets/img/products/gallery/scbd-oxford-blue-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(77,20,'assets/img/products/gallery/cipete-linen-overshirt-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(78,20,'assets/img/products/gallery/cipete-linen-overshirt-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(79,20,'assets/img/products/gallery/cipete-linen-overshirt-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(80,20,'assets/img/products/gallery/cipete-linen-overshirt-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(81,21,'assets/img/products/gallery/weekend-club-hoodie-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(82,21,'assets/img/products/gallery/weekend-club-hoodie-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(83,21,'assets/img/products/gallery/weekend-club-hoodie-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(84,21,'assets/img/products/gallery/weekend-club-hoodie-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(85,22,'assets/img/products/gallery/kemang-utility-coach-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(86,22,'assets/img/products/gallery/kemang-utility-coach-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(87,22,'assets/img/products/gallery/kemang-utility-coach-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(88,22,'assets/img/products/gallery/kemang-utility-coach-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(89,23,'assets/img/products/gallery/relaxed-straight-denim-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(90,23,'assets/img/products/gallery/relaxed-straight-denim-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(91,23,'assets/img/products/gallery/relaxed-straight-denim-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(92,23,'assets/img/products/gallery/relaxed-straight-denim-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(93,24,'assets/img/products/gallery/wide-leg-washed-denim-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(94,24,'assets/img/products/gallery/wide-leg-washed-denim-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(95,24,'assets/img/products/gallery/wide-leg-washed-denim-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(96,24,'assets/img/products/gallery/wide-leg-washed-denim-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(97,25,'assets/img/products/gallery/carpenter-denim-black-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(98,25,'assets/img/products/gallery/carpenter-denim-black-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(99,25,'assets/img/products/gallery/carpenter-denim-black-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(100,25,'assets/img/products/gallery/carpenter-denim-black-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(101,26,'assets/img/products/gallery/parachute-cargo-olive-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(102,26,'assets/img/products/gallery/parachute-cargo-olive-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(103,26,'assets/img/products/gallery/parachute-cargo-olive-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(104,26,'assets/img/products/gallery/parachute-cargo-olive-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(105,27,'assets/img/products/gallery/straight-chino-sand-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(106,27,'assets/img/products/gallery/straight-chino-sand-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(107,27,'assets/img/products/gallery/straight-chino-sand-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(108,27,'assets/img/products/gallery/straight-chino-sand-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(109,28,'assets/img/products/gallery/denim-bermuda-shorts-2.webp','Ilustrasi AI — foto 2',0,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(110,28,'assets/img/products/gallery/denim-bermuda-shorts-3.webp','Ilustrasi AI — foto 3',1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(111,28,'assets/img/products/gallery/denim-bermuda-shorts-4.webp','Ilustrasi AI — foto 4',2,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(112,28,'assets/img/products/gallery/denim-bermuda-shorts-5.webp','Ilustrasi AI — foto 5',3,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(113,29,'assets/img/catalog-tambahan/kemeja-oxford-sage-02-belakang.jpg','Kemeja Oxford Arunika — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(114,29,'assets/img/catalog-tambahan/kemeja-oxford-sage-03-detail-atas.jpg','Kemeja Oxford Arunika — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(115,29,'assets/img/catalog-tambahan/kemeja-oxford-sage-04-detail-bahan.jpg','Kemeja Oxford Arunika — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(116,29,'assets/img/catalog-tambahan/kemeja-oxford-sage-05-lipatan.jpg','Kemeja Oxford Arunika — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(117,30,'assets/img/catalog-tambahan/kemeja-camp-terracotta-02-belakang.jpg','Kemeja Camp Collar Senja — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(118,30,'assets/img/catalog-tambahan/kemeja-camp-terracotta-03-detail-atas.jpg','Kemeja Camp Collar Senja — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(119,30,'assets/img/catalog-tambahan/kemeja-camp-terracotta-04-detail-bahan.jpg','Kemeja Camp Collar Senja — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(120,30,'assets/img/catalog-tambahan/kemeja-camp-terracotta-05-lipatan.jpg','Kemeja Camp Collar Senja — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(121,31,'assets/img/catalog-tambahan/kaos-oversized-ivory-02-belakang.jpg','Kaos Oversized Awan — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(122,31,'assets/img/catalog-tambahan/kaos-oversized-ivory-03-detail-atas.jpg','Kaos Oversized Awan — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(123,31,'assets/img/catalog-tambahan/kaos-oversized-ivory-04-detail-bahan.jpg','Kaos Oversized Awan — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(124,31,'assets/img/catalog-tambahan/kaos-oversized-ivory-05-lipatan.jpg','Kaos Oversized Awan — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(125,32,'assets/img/catalog-tambahan/polo-knit-navy-02-belakang.jpg','Polo Knit Samudra — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(126,32,'assets/img/catalog-tambahan/polo-knit-navy-03-detail-atas.jpg','Polo Knit Samudra — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(127,32,'assets/img/catalog-tambahan/polo-knit-navy-04-detail-bahan.jpg','Polo Knit Samudra — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(128,32,'assets/img/catalog-tambahan/polo-knit-navy-05-lipatan.jpg','Polo Knit Samudra — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(129,33,'assets/img/catalog-tambahan/hoodie-ash-grey-02-belakang.jpg','Hoodie Pullover Kabut — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(130,33,'assets/img/catalog-tambahan/hoodie-ash-grey-03-detail-atas.jpg','Hoodie Pullover Kabut — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(131,33,'assets/img/catalog-tambahan/hoodie-ash-grey-04-detail-bahan.jpg','Hoodie Pullover Kabut — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(132,33,'assets/img/catalog-tambahan/hoodie-ash-grey-05-lipatan.jpg','Hoodie Pullover Kabut — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(133,34,'assets/img/catalog-tambahan/jaket-coach-olive-02-belakang.jpg','Jaket Coach Rimba — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(134,34,'assets/img/catalog-tambahan/jaket-coach-olive-03-detail-atas.jpg','Jaket Coach Rimba — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(135,34,'assets/img/catalog-tambahan/jaket-coach-olive-04-detail-bahan.jpg','Jaket Coach Rimba — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(136,34,'assets/img/catalog-tambahan/jaket-coach-olive-05-lipatan.jpg','Jaket Coach Rimba — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(137,35,'assets/img/catalog-tambahan/cargo-stone-taupe-02-belakang.jpg','Celana Cargo Jelajah — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(138,35,'assets/img/catalog-tambahan/cargo-stone-taupe-03-detail-atas.jpg','Celana Cargo Jelajah — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(139,35,'assets/img/catalog-tambahan/cargo-stone-taupe-04-detail-bahan.jpg','Celana Cargo Jelajah — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(140,35,'assets/img/catalog-tambahan/cargo-stone-taupe-05-lipatan.jpg','Celana Cargo Jelajah — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(141,36,'assets/img/catalog-tambahan/chino-black-02-belakang.jpg','Celana Chino Urban — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(142,36,'assets/img/catalog-tambahan/chino-black-03-detail-atas.jpg','Celana Chino Urban — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(143,36,'assets/img/catalog-tambahan/chino-black-04-detail-bahan.jpg','Celana Chino Urban — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(144,36,'assets/img/catalog-tambahan/chino-black-05-lipatan.jpg','Celana Chino Urban — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(145,37,'assets/img/catalog-tambahan/jeans-dark-indigo-02-belakang.jpg','Jeans Straight Langit Malam — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(146,37,'assets/img/catalog-tambahan/jeans-dark-indigo-03-detail-atas.jpg','Jeans Straight Langit Malam — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(147,37,'assets/img/catalog-tambahan/jeans-dark-indigo-04-detail-bahan.jpg','Jeans Straight Langit Malam — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(148,37,'assets/img/catalog-tambahan/jeans-dark-indigo-05-lipatan.jpg','Jeans Straight Langit Malam — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(149,38,'assets/img/catalog-tambahan/flanel-burgundy-02-belakang.jpg','Kemeja Flanel Bara — ilustrasi AI 2',0,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(150,38,'assets/img/catalog-tambahan/flanel-burgundy-03-detail-atas.jpg','Kemeja Flanel Bara — ilustrasi AI 3',1,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(151,38,'assets/img/catalog-tambahan/flanel-burgundy-04-detail-bahan.jpg','Kemeja Flanel Bara — ilustrasi AI 4',2,'2026-10-17 14:25:39','2026-10-17 14:25:39'),(152,38,'assets/img/catalog-tambahan/flanel-burgundy-05-lipatan.jpg','Kemeja Flanel Bara — ilustrasi AI 5',3,'2026-10-17 14:25:39','2026-10-17 14:25:39');
/*!40000 ALTER TABLE `product_images` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `product_variants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_variants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `size` varchar(20) NOT NULL,
  `stock` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` varchar(60) NOT NULL DEFAULT 'Standar',
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_variants_product_id_color_size_unique` (`product_id`,`color`,`size`),
  KEY `product_variants_product_id_support_index` (`product_id`),
  CONSTRAINT `product_variants_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `product_variants` WRITE;
/*!40000 ALTER TABLE `product_variants` DISABLE KEYS */;
INSERT INTO `product_variants` VALUES (1,1,'S',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(2,1,'M',15,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(3,1,'L',18,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(4,1,'XL',10,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(5,1,'XXL',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(6,2,'S',12,'2026-10-09 21:54:42','2026-10-09 21:54:42','Off White',1),(7,2,'M',20,'2026-10-09 21:54:42','2026-10-09 21:54:42','Off White',1),(8,2,'L',20,'2026-10-09 21:54:42','2026-10-09 21:54:42','Off White',1),(9,2,'XL',12,'2026-10-09 21:54:42','2026-10-09 21:54:42','Off White',1),(10,2,'XXL',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Off White',1),(11,3,'S',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy',1),(12,3,'M',12,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy',1),(13,3,'L',14,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy',1),(14,3,'XL',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy',1),(15,3,'XXL',0,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy',1),(16,4,'S',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Cream / Maroon',1),(17,4,'M',9,'2026-10-09 21:54:42','2026-10-09 21:54:42','Cream / Maroon',1),(18,4,'L',9,'2026-10-09 21:54:42','2026-10-09 21:54:42','Cream / Maroon',1),(19,4,'XL',4,'2026-10-09 21:54:42','2026-10-09 21:54:42','Cream / Maroon',1),(20,4,'XXL',2,'2026-10-09 21:54:42','2026-10-09 21:54:42','Cream / Maroon',1),(21,5,'S',4,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(22,5,'M',10,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(23,5,'L',12,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(24,5,'XL',7,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(25,5,'XXL',3,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(26,6,'S',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy / Putih',1),(27,6,'M',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy / Putih',1),(28,6,'L',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy / Putih',1),(29,6,'XL',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Navy / Putih',1),(30,7,'M',7,'2026-10-09 21:54:42','2026-10-09 21:54:42','Olive',1),(31,7,'L',9,'2026-10-09 21:54:42','2026-10-09 21:54:42','Olive',1),(32,7,'XL',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Olive',1),(33,7,'XXL',2,'2026-10-09 21:54:42','2026-10-09 21:54:42','Olive',1),(34,8,'S',4,'2026-10-09 21:54:42','2026-10-09 21:54:42','Merah / Hitam',1),(35,8,'M',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Merah / Hitam',1),(36,8,'L',10,'2026-10-09 21:54:42','2026-10-09 21:54:42','Merah / Hitam',1),(37,8,'XL',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Merah / Hitam',1),(38,8,'XXL',3,'2026-10-09 21:54:42','2026-10-09 21:54:42','Merah / Hitam',1),(39,9,'S',3,'2026-10-09 21:54:42','2026-10-09 21:54:42','Sage',1),(40,9,'M',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Sage',1),(41,9,'L',7,'2026-10-09 21:54:42','2026-10-09 21:54:42','Sage',1),(42,9,'XL',4,'2026-10-09 21:54:42','2026-10-09 21:54:42','Sage',1),(43,10,'M',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(44,10,'L',7,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(45,10,'XL',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(46,10,'XXL',2,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(47,11,'S',3,'2026-10-09 21:54:42','2026-10-09 21:54:42','Abu Misty',1),(48,11,'M',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Abu Misty',1),(49,11,'L',10,'2026-10-09 21:54:42','2026-10-09 21:54:42','Abu Misty',1),(50,11,'XL',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Abu Misty',1),(51,11,'XXL',3,'2026-10-09 21:54:42','2026-10-09 21:54:42','Abu Misty',1),(52,12,'S',2,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hijau Hutan',1),(53,12,'M',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hijau Hutan',1),(54,12,'L',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hijau Hutan',1),(55,12,'XL',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hijau Hutan',1),(56,12,'XXL',2,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hijau Hutan',1),(57,13,'M',6,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(58,13,'L',8,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(59,13,'XL',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(60,13,'XXL',3,'2026-10-09 21:54:42','2026-10-09 21:54:42','Hitam',1),(61,14,'S',0,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(62,14,'M',4,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(63,14,'L',5,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(64,14,'XL',3,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(65,14,'XXL',0,'2026-10-09 21:54:42','2026-10-09 21:54:42','Biru Denim',1),(66,15,'All Size',20,'2026-10-09 21:54:42','2026-10-09 21:54:42','Cream',1),(67,16,'All Size',0,'2026-10-09 21:54:42','2026-10-09 21:54:42','Natural',1),(68,17,'S',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Espresso',1),(69,17,'M',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Espresso',1),(70,17,'L',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Espresso',1),(71,17,'XL',10,'2026-10-09 21:54:44','2026-10-09 21:54:44','Espresso',1),(72,17,'XXL',5,'2026-10-09 21:54:44','2026-10-09 21:54:44','Espresso',1),(73,18,'S',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Oatmeal',1),(74,18,'M',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Oatmeal',1),(75,18,'L',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Oatmeal',1),(76,18,'XL',10,'2026-10-09 21:54:44','2026-10-09 21:54:44','Oatmeal',1),(77,18,'XXL',5,'2026-10-09 21:54:44','2026-10-09 21:54:44','Oatmeal',1),(78,19,'S',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Powder Blue',1),(79,19,'M',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Powder Blue',1),(80,19,'L',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Powder Blue',1),(81,19,'XL',10,'2026-10-09 21:54:44','2026-10-09 21:54:44','Powder Blue',1),(82,19,'XXL',5,'2026-10-09 21:54:44','2026-10-09 21:54:44','Powder Blue',1),(83,20,'S',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(84,20,'M',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(85,20,'L',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(86,20,'XL',10,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(87,20,'XXL',5,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(88,21,'S',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Stone',1),(89,21,'M',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Stone',1),(90,21,'L',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Stone',1),(91,21,'XL',10,'2026-10-09 21:54:44','2026-10-09 21:54:44','Stone',1),(92,21,'XXL',5,'2026-10-09 21:54:44','2026-10-09 21:54:44','Stone',1),(93,22,'S',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Muted Olive',1),(94,22,'M',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Muted Olive',1),(95,22,'L',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Muted Olive',1),(96,22,'XL',10,'2026-10-09 21:54:44','2026-10-09 21:54:44','Muted Olive',1),(97,22,'XXL',5,'2026-10-09 21:54:44','2026-10-09 21:54:44','Muted Olive',1),(98,23,'28',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Indigo',1),(99,23,'30',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Indigo',1),(100,23,'32',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Indigo',1),(101,23,'34',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Indigo',1),(102,23,'36',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Indigo',1),(103,24,'28',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Light Blue',1),(104,24,'30',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Light Blue',1),(105,24,'32',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Light Blue',1),(106,24,'34',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Light Blue',1),(107,24,'36',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Light Blue',1),(108,25,'28',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Washed Black',1),(109,25,'30',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Washed Black',1),(110,25,'32',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Washed Black',1),(111,25,'34',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Washed Black',1),(112,25,'36',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Washed Black',1),(113,26,'28',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Olive',1),(114,26,'30',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Olive',1),(115,26,'32',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Olive',1),(116,26,'34',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Olive',1),(117,26,'36',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Olive',1),(118,27,'28',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(119,27,'30',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(120,27,'32',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(121,27,'34',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(122,27,'36',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Sand',1),(123,28,'28',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Vintage Blue',1),(124,28,'30',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Vintage Blue',1),(125,28,'32',16,'2026-10-09 21:54:44','2026-10-09 21:54:44','Vintage Blue',1),(126,28,'34',12,'2026-10-09 21:54:44','2026-10-09 21:54:44','Vintage Blue',1),(127,28,'36',8,'2026-10-09 21:54:44','2026-10-09 21:54:44','Vintage Blue',1),(128,29,'S',6,'2026-10-17 14:25:39','2026-10-17 14:25:39','Sage Green',1),(129,29,'M',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Sage Green',1),(130,29,'L',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Sage Green',1),(131,29,'XL',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Sage Green',1),(132,29,'XXL',4,'2026-10-17 14:25:39','2026-10-17 14:25:39','Sage Green',1),(133,30,'S',5,'2026-10-17 14:25:39','2026-10-17 14:25:39','Terracotta',1),(134,30,'M',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Terracotta',1),(135,30,'L',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Terracotta',1),(136,30,'XL',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Terracotta',1),(137,30,'XXL',4,'2026-10-17 14:25:39','2026-10-17 14:25:39','Terracotta',1),(138,31,'S',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ivory',1),(139,31,'M',12,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ivory',1),(140,31,'L',14,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ivory',1),(141,31,'XL',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ivory',1),(142,31,'XXL',6,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ivory',1),(143,32,'S',5,'2026-10-17 14:25:39','2026-10-17 14:25:39','Navy',1),(144,32,'M',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Navy',1),(145,32,'L',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Navy',1),(146,32,'XL',7,'2026-10-17 14:25:39','2026-10-17 14:25:39','Navy',1),(147,32,'XXL',4,'2026-10-17 14:25:39','2026-10-17 14:25:39','Navy',1),(148,33,'S',4,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ash Grey',1),(149,33,'M',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ash Grey',1),(150,33,'L',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ash Grey',1),(151,33,'XL',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ash Grey',1),(152,33,'XXL',4,'2026-10-17 14:25:39','2026-10-17 14:25:39','Ash Grey',1),(153,34,'S',4,'2026-10-17 14:25:39','2026-10-17 14:25:39','Olive',1),(154,34,'M',7,'2026-10-17 14:25:39','2026-10-17 14:25:39','Olive',1),(155,34,'L',9,'2026-10-17 14:25:39','2026-10-17 14:25:39','Olive',1),(156,34,'XL',7,'2026-10-17 14:25:39','2026-10-17 14:25:39','Olive',1),(157,34,'XXL',3,'2026-10-17 14:25:39','2026-10-17 14:25:39','Olive',1),(158,35,'28',5,'2026-10-17 14:25:39','2026-10-17 14:25:39','Stone Taupe',1),(159,35,'30',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Stone Taupe',1),(160,35,'32',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Stone Taupe',1),(161,35,'34',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Stone Taupe',1),(162,35,'36',5,'2026-10-17 14:25:39','2026-10-17 14:25:39','Stone Taupe',1),(163,36,'28',6,'2026-10-17 14:25:39','2026-10-17 14:25:39','Black',1),(164,36,'30',9,'2026-10-17 14:25:39','2026-10-17 14:25:39','Black',1),(165,36,'32',12,'2026-10-17 14:25:39','2026-10-17 14:25:39','Black',1),(166,36,'34',9,'2026-10-17 14:25:39','2026-10-17 14:25:39','Black',1),(167,36,'36',6,'2026-10-17 14:25:39','2026-10-17 14:25:39','Black',1),(168,37,'28',5,'2026-10-17 14:25:39','2026-10-17 14:25:39','Dark Indigo',1),(169,37,'30',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Dark Indigo',1),(170,37,'32',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Dark Indigo',1),(171,37,'34',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Dark Indigo',1),(172,37,'36',5,'2026-10-17 14:25:39','2026-10-17 14:25:39','Dark Indigo',1),(173,38,'S',5,'2026-10-17 14:25:39','2026-10-17 14:25:39','Burgundy / Charcoal',1),(174,38,'M',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Burgundy / Charcoal',1),(175,38,'L',10,'2026-10-17 14:25:39','2026-10-17 14:25:39','Burgundy / Charcoal',1),(176,38,'XL',8,'2026-10-17 14:25:39','2026-10-17 14:25:39','Burgundy / Charcoal',1),(177,38,'XXL',4,'2026-10-17 14:25:39','2026-10-17 14:25:39','Burgundy / Charcoal',1);
/*!40000 ALTER TABLE `product_variants` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned NOT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(180) NOT NULL,
  `description` text DEFAULT NULL,
  `material` varchar(120) DEFAULT NULL,
  `color` varchar(60) DEFAULT NULL,
  `price` int(10) unsigned NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `inventory_version` bigint(20) unsigned NOT NULL DEFAULT 0,
  `ai_gallery` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_slug_unique` (`slug`),
  KEY `products_category_id_foreign` (`category_id`),
  KEY `products_is_active_index` (`is_active`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,1,'Kaos \"Kota Senja\"','kaos-kota-senja','Ilustrasi siluet kota saat matahari terbenam, disablon plastisol dengan gradasi oranye yang tajam dan tidak mudah pecah.\nPotongan regular fit, jahitan rantai di pundak, dan kerah rib yang tetap rapi walau sering dicuci.','Cotton Combed 24s','Hitam',129000,'assets/img/products/kaos-kota-senja.webp',1,1,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(2,1,'Kaos Basic Heavyweight','kaos-basic-heavyweight','Kaos polos tebal yang jatuh di badan dan tidak menerawang. Wajib punya untuk tampilan clean atau dipadukan dengan outer.\nBahan sudah melalui proses pre-shrunk sehingga ukurannya tidak menyusut setelah dicuci.','Cotton Combed 20s (220 gsm)','Off White',99000,'assets/img/products/kaos-basic-heavyweight.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(3,1,'Kaos \"Ombak Selatan\"','kaos-ombak-selatan','Terinspirasi ombak pantai selatan Jawa dengan gaya ukiyo-e. Sablon rubber dua warna yang lembut di kulit.\nCocok untuk liburan, nongkrong, atau sekadar santai di akhir pekan.','Cotton Combed 24s','Navy',125000,'assets/img/products/kaos-ombak-selatan.webp',1,1,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(4,1,'Kaos Ringer Retro','kaos-ringer-retro','Kaos ringer bergaya 70-an dengan aksen rib maroon di kerah dan ujung lengan, plus bordir logo kecil di dada.\nBahan 30s yang ringan dan adem untuk aktivitas seharian.','Cotton Combed 30s','Cream / Maroon',109000,'assets/img/products/kaos-ringer-retro.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(5,2,'Long Sleeve \"Nusantara\"','longsleeve-nusantara','Long sleeve dengan sablon motif batik kontemporer di dada dan artwork memanjang di kedua lengan.\nManset rib di ujung lengan menjaga bentuk tetap rapi saat lengan digulung.','Cotton Combed 24s','Hitam',165000,'assets/img/products/longsleeve-nusantara.webp',1,1,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(6,2,'Long Sleeve Stripe Marine','longsleeve-stripe','Garis horizontal klasik ala pelaut yang ditenun langsung (yarn-dyed), jadi warnanya tidak luntur.\nGampang dipadukan dengan celana chino, jeans, atau dijadikan dalaman kemeja.','Cotton Combed 30s Yarn-dyed','Navy / Putih',149000,'assets/img/products/longsleeve-stripe.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(7,2,'Long Sleeve Waffle Henley','longsleeve-waffle-henley','Tekstur waffle yang unik dengan kerah henley tiga kancing. Bahan bernapas sehingga nyaman dipakai di cuaca tropis.\nTampil santai tapi tetap terlihat niat.','Cotton Waffle Knit','Olive',159000,'assets/img/products/longsleeve-waffle-henley.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(8,3,'Kemeja Flanel Kotak \"Lumber\"','kemeja-flanel','Flanel motif kotak klasik dengan permukaan brushed yang lembut. Dua saku dada berkancing dan kancing tanduk imitasi.\nBisa dipakai dikancing rapi atau sebagai outer di atas kaos.','Flanel Katun Brushed','Merah / Hitam',219000,'assets/img/products/kemeja-flanel.webp',1,1,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(9,3,'Kemeja Linen Resort','kemeja-linen-resort','Kemeja kerah kuba (camp collar) lengan pendek berbahan linen yang ringan dan sejuk.\nPilihan tepat untuk acara santai, liburan, atau kondangan outdoor.','Linen Rayon','Sage',199000,'assets/img/products/kemeja-linen-resort.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(10,3,'Kemeja Denim Washed','kemeja-denim','Kemeja denim dengan efek stone wash yang natural, jahitan kontras, dan kancing snap logam.\nMakin sering dipakai, karakter denimnya makin keluar.','Denim 8 oz','Biru Denim',239000,'assets/img/products/kemeja-denim.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(11,4,'Hoodie \"Misty\"','hoodie-misty','Hoodie fleece tebal dengan bagian dalam yang lembut, tali hoodie flat, dan saku kanguru.\nBordir logo minimalis di dada. Hangat untuk naik motor malam atau kerja di ruangan ber-AC.','Cotton Fleece 280 gsm','Abu Misty',289000,'assets/img/products/hoodie-misty.webp',1,1,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(12,4,'Crewneck \"Forest Range\"','crewneck-forest','Sweater crewneck dengan sablon ilustrasi pegunungan berwarna krem. Rib tebal di leher, manset, dan pinggang.\nTeman setia untuk naik gunung, ngopi pagi, atau perjalanan jauh.','Cotton Fleece 260 gsm','Hijau Hutan',249000,'assets/img/products/crewneck-forest.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(13,5,'Jaket Coach Windbreaker','jaket-coach','Jaket coach ringan yang menahan angin dan gerimis. Kancing snap depan, tali serut di bagian bawah, dan furing mesh agar tidak gerah.\nBisa dilipat ringkas ke dalam tas.','Taslan Water Repellent + furing mesh','Hitam',299000,'assets/img/products/jaket-coach.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(14,5,'Jaket Denim Trucker','jaket-denim-trucker','Jaket trucker klasik dengan denim 12 oz yang kokoh, kancing logam, dan dua saku dada berpenutup.\nInvestasi lemari yang awet bertahun-tahun.','Denim 12 oz','Biru Denim',349000,'assets/img/products/jaket-denim-trucker.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(15,6,'Topi 6 Panel \"Bintang\"','topi-bintang','Topi baseball 6 panel dengan bordir bintang di depan dan strap besi yang bisa diatur.\nMuat untuk lingkar kepala 54–60 cm.','Cotton Twill','Cream',89000,'assets/img/products/topi-bintang.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(16,6,'Totebag Kanvas \"Monstera\"','totebag-monstera','Totebag kanvas tebal dengan sablon daun monstera. Muat laptop 14 inci, punya saku dalam, dan tali bahu yang kuat.\nUkuran 38 x 42 cm.','Kanvas 12 oz','Natural',75000,'assets/img/products/totebag-monstera.webp',1,0,'2026-10-09 21:54:42','2026-10-09 21:54:44',0,1),(17,1,'Boxy Tee Espresso','blok-m-boxy-espresso','Boxy cut, dropped shoulder, dan detail bordir K yang subtle. Coffee run saat santai, lanjut sunset walk—easy outfit, tetap niat.\nIlustrasi dan spesifikasi konsep katalog AI. Cocokkan bahan, ukuran, warna, dan stok dengan barang nyata sebelum digunakan untuk penjualan.','Cotton heavyweight (konsep demo)','Espresso',159000,'assets/img/products/blok-m-boxy-espresso.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(18,1,'Textured Knit Polo','senopati-knit-polo','Open collar dan tekstur knit yang clean. Dipadukan dengan pleated trousers untuk brunch atau dinner casual; less effort, good impression.\nIlustrasi dan spesifikasi konsep katalog AI. Cocokkan bahan, ukuran, warna, dan stok dengan barang nyata sebelum digunakan untuk penjualan.','Cotton knit (konsep demo)','Oatmeal',229000,'assets/img/products/senopati-knit-polo.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(19,3,'Oxford Shirt Powder Blue','scbd-oxford-blue','Kemeja Oxford biru muda dengan collar button-down dan relaxed fit. Office hours to after-hours, tinggal gulung lengan dan ganti sneakers.\nIlustrasi dan spesifikasi konsep katalog AI. Cocokkan bahan, ukuran, warna, dan stok dengan barang nyata sebelum digunakan untuk penjualan.','Cotton Oxford (konsep demo)','Powder Blue',249000,'assets/img/products/scbd-oxford-blue.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(20,3,'Linen Blend Overshirt','cipete-linen-overshirt','Overshirt warna sand dengan dua patch pocket. Layer di atas basic tee, cocok untuk ngopi di Cipete atau weekend getaway dengan palet earthy.\nIlustrasi dan spesifikasi konsep katalog AI. Cocokkan bahan, ukuran, warna, dan stok dengan barang nyata sebelum digunakan untuk penjualan.','Linen blend (konsep demo)','Sand',269000,'assets/img/products/cipete-linen-overshirt.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(21,4,'Weekend Club Hoodie','weekend-club-hoodie','Oversized hoodie tanpa drawstring, clean silhouette dengan tone stone yang gampang di-mix. Study session, cinema date, atau chill Sunday.\nIlustrasi dan spesifikasi konsep katalog AI. Cocokkan bahan, ukuran, warna, dan stok dengan barang nyata sebelum digunakan untuk penjualan.','Cotton fleece (konsep demo)','Stone',319000,'assets/img/products/weekend-club-hoodie.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(22,5,'Utility Coach Jacket','kemang-utility-coach','Utility coach warna muted olive dengan flap pocket dan snap closure. Low-key streetwear untuk jalan sore, art space, dan coffee hopping.\nIlustrasi dan spesifikasi konsep katalog AI. Cocokkan bahan, ukuran, warna, dan stok dengan barang nyata sebelum digunakan untuk penjualan.','Nylon matte (konsep demo)','Muted Olive',339000,'assets/img/products/kemang-utility-coach.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(23,7,'Relaxed Straight Denim','relaxed-straight-denim','Siluet modern dengan detail minimal untuk outfit harian yang santai dan rapi. Ilustrasi AI dan spesifikasi katalog demo; cocokkan bahan, ukuran serta stok dengan produk nyata sebelum penjualan.','Cotton denim (konsep demo)','Indigo',289000,'assets/img/products/relaxed-straight-denim.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(24,7,'Wide Leg Washed Denim','wide-leg-washed-denim','Siluet modern dengan detail minimal untuk outfit harian yang santai dan rapi. Ilustrasi AI dan spesifikasi katalog demo; cocokkan bahan, ukuran serta stok dengan produk nyata sebelum penjualan.','Cotton denim (konsep demo)','Light Blue',299000,'assets/img/products/wide-leg-washed-denim.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(25,7,'Carpenter Denim Black','carpenter-denim-black','Siluet modern dengan detail minimal untuk outfit harian yang santai dan rapi. Ilustrasi AI dan spesifikasi katalog demo; cocokkan bahan, ukuran serta stok dengan produk nyata sebelum penjualan.','Cotton denim (konsep demo)','Washed Black',309000,'assets/img/products/carpenter-denim-black.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(26,8,'Parachute Cargo Pants','parachute-cargo-olive','Siluet modern dengan detail minimal untuk outfit harian yang santai dan rapi. Ilustrasi AI dan spesifikasi katalog demo; cocokkan bahan, ukuran serta stok dengan produk nyata sebelum penjualan.','Cotton blend (konsep demo)','Olive',279000,'assets/img/products/parachute-cargo-olive.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(27,8,'Straight Chino Pants','straight-chino-sand','Siluet modern dengan detail minimal untuk outfit harian yang santai dan rapi. Ilustrasi AI dan spesifikasi katalog demo; cocokkan bahan, ukuran serta stok dengan produk nyata sebelum penjualan.','Cotton blend (konsep demo)','Sand',249000,'assets/img/products/straight-chino-sand.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(28,7,'Denim Bermuda Shorts','denim-bermuda-shorts','Siluet modern dengan detail minimal untuk outfit harian yang santai dan rapi. Ilustrasi AI dan spesifikasi katalog demo; cocokkan bahan, ukuran serta stok dengan produk nyata sebelum penjualan.','Cotton denim (konsep demo)','Vintage Blue',229000,'assets/img/products/denim-bermuda-shorts.webp',1,1,'2026-10-09 21:54:44','2026-10-09 21:54:44',0,1),(29,3,'Kemeja Oxford Arunika','kemeja-oxford-arunika','Kemeja lengan panjang berwarna sage dengan kerah button-down, kancing depan, dan satu saku dada. Desain polos untuk dipadukan dengan chino atau denim dalam gaya kasual rapi.\n\nPotongan: Regular fit.','Katun Oxford','Sage Green',189000,'assets/img/catalog-tambahan/kemeja-oxford-sage-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(30,3,'Kemeja Camp Collar Senja','kemeja-camp-collar-senja','Kemeja lengan pendek berwarna terracotta dengan kerah terbuka dan potongan santai. Tampilan minimal tanpa saku, cocok dipadukan dengan celana pendek maupun celana panjang.\n\nPotongan: Relaxed fit.','Campuran katun dan linen','Terracotta',179000,'assets/img/catalog-tambahan/kemeja-camp-terracotta-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(31,1,'Kaos Oversized Awan','kaos-oversized-awan','Kaos polos warna ivory dengan kerah bulat dan bahu turun. Siluet oversized menjadi pilihan dasar untuk gaya kasual, dipakai sendiri atau sebagai dalaman kemeja dan jaket.\n\nPotongan: Oversized fit.','Katun jersey','Ivory',129000,'assets/img/catalog-tambahan/kaos-oversized-ivory-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(32,9,'Polo Knit Samudra','polo-knit-samudra','Polo lengan pendek warna navy dengan tekstur rajut, kerah klasik, dan tiga kancing depan. Bagian ujung lengan serta bawah baju memakai detail rib untuk tampilan kasual rapi.\n\nPotongan: Regular fit.','Rajut katun','Navy',199000,'assets/img/catalog-tambahan/polo-knit-navy-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(33,4,'Hoodie Pullover Kabut','hoodie-pullover-kabut','Hoodie pullover abu-abu melange dengan tudung bertali dan saku kanguru. Desain polos dilengkapi rib pada manset serta bagian bawah, mudah dipadukan dengan jeans atau cargo.\n\nPotongan: Relaxed fit.','Cotton fleece','Ash Grey',259000,'assets/img/catalog-tambahan/hoodie-ash-grey-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(34,5,'Jaket Coach Rimba','jaket-coach-rimba','Jaket coach warna olive dengan kerah lipat, kancing tekan, dua saku depan, dan manset elastis. Siluet sederhana untuk melengkapi gaya berlapis bersama kaos polos dan denim.\n\nPotongan: Regular fit.','Nilon','Olive',289000,'assets/img/catalog-tambahan/jaket-coach-olive-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(35,8,'Celana Cargo Jelajah','celana-cargo-jelajah','Celana cargo panjang warna stone taupe dengan potongan lurus, saku samping bertutup, dan loop sabuk. Cocok dipadukan dengan kaos oversized, hoodie, atau jaket coach.\n\nPotongan: Straight fit.','Katun twill','Stone Taupe',269000,'assets/img/catalog-tambahan/cargo-stone-taupe-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(36,8,'Celana Chino Urban','celana-chino-urban','Celana chino hitam dengan potongan mengecil ke bawah, saku samping miring, serta saku belakang welt. Desain tanpa motif untuk dipadukan dengan kemeja, polo, atau kaos.\n\nPotongan: Tapered fit.','Katun twill','Black',239000,'assets/img/catalog-tambahan/chino-black-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(37,7,'Jeans Straight Langit Malam','jeans-straight-langit-malam','Jeans dark indigo berpotongan lurus dengan konstruksi lima saku dan jahitan kontras. Tampilan bersih tanpa sobekan, cocok menjadi pasangan kemeja flanel maupun kaos polos.\n\nPotongan: Straight fit.','Denim katun','Dark Indigo',299000,'assets/img/catalog-tambahan/jeans-dark-indigo-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1),(38,3,'Kemeja Flanel Bara','kemeja-flanel-bara','Kemeja flanel lengan panjang bermotif kotak burgundy dan charcoal, dengan dua saku dada bertutup. Bisa dipakai terkancing sebagai atasan atau terbuka sebagai luaran kaos polos.\n\nPotongan: Regular fit.','Flanel katun','Burgundy / Charcoal',219000,'assets/img/catalog-tambahan/flanel-burgundy-01-depan.jpg',1,0,'2026-10-17 14:25:39','2026-10-17 14:25:39',0,1);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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 */;

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `key` varchar(60) NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `shipping_rates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `shipping_rates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `carrier` varchar(60) NOT NULL,
  `province` varchar(2) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `cost` int(10) unsigned NOT NULL,
  `min_days` smallint(5) unsigned NOT NULL DEFAULT 2,
  `max_days` smallint(5) unsigned NOT NULL DEFAULT 5,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shipping_rates_province_index` (`province`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `shipping_rates` WRITE;
/*!40000 ALTER TABLE `shipping_rates` DISABLE KEYS */;
INSERT INTO `shipping_rates` VALUES (1,'Reguler','Pengiriman toko',NULL,NULL,25000,3,7,1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(2,'Reguler','Pengiriman toko','31',NULL,15000,2,5,1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(3,'Reguler','Pengiriman toko','32',NULL,15000,2,5,1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(4,'Reguler','Pengiriman toko','33',NULL,15000,2,5,1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(5,'Reguler','Pengiriman toko','34',NULL,15000,2,5,1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(6,'Reguler','Pengiriman toko','35',NULL,15000,2,5,1,'2026-10-09 21:54:44','2026-10-09 21:54:44'),(7,'Reguler','Pengiriman toko','36',NULL,15000,2,5,1,'2026-10-09 21:54:44','2026-10-09 21:54:44');
/*!40000 ALTER TABLE `shipping_rates` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `role` varchar(20) NOT NULL DEFAULT 'customer',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `session_version` int(10) unsigned NOT NULL DEFAULT 0,
  `avatar` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_role_index` (`role`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Admin Kultura','admin@kultura.id','2026-10-09 21:54:42','$2y$12$piN4UEKEVklRwq0E195udewFWO58PqzXnpN0q.rovAvvqA4oQE00y','081234567890','Jl. Cihampelas No. 88, Cipaganti, Bandung','admin',NULL,'2026-03-23 21:54:42','2026-10-09 21:54:42',0,NULL),(2,'Rizky Pratama','customer@kultura.id','2026-10-09 21:54:43','$2y$12$miLimm7bvi.Va0Y3KFsiMefTvKVmPLJ.H.HuXmJr4XiqmIrnZC/ju','081311112222','Jl. Dago No. 21, Coblong\nBandung, Jawa Barat 40135','customer',NULL,'2026-04-02 21:54:43','2026-10-09 21:54:43',0,NULL),(3,'Salsa Nabila','salsa@contoh.id','2026-10-09 21:54:43','$2y$12$CG2j6gW4biSzhUUdLeawWeZuZZREoIjcyTqMDEFTStEaL5k24v2Vq','081322223333','Jl. Kaliurang Km 5 No. 12, Sleman\nYogyakarta 55281','customer',NULL,'2026-04-14 21:54:43','2026-10-09 21:54:43',0,NULL),(4,'Dimas Saputra','dimas@contoh.id','2026-10-09 21:54:43','$2y$12$nh0MIHrSrkctxe/fmjgaAOUbevzmyE78/5spSxo9CnLE6IDIEFVa6','081733334444','Perum Griya Asri Blok C-7, Tembalang\nSemarang, Jawa Tengah 50275','customer',NULL,'2026-04-26 21:54:43','2026-10-09 21:54:43',0,NULL),(5,'Ayu Lestari','ayu@contoh.id','2026-10-09 21:54:43','$2y$12$ZlLfjidd6FkUF6uWAcEj4u7NpjOGJ/kF7.Vngq1ZF3HtoHIAJBxRe','085244445555','Jl. Raya Darmo No. 45, Wonokromo\nSurabaya, Jawa Timur 60241','customer',NULL,'2026-05-08 21:54:43','2026-10-09 21:54:43',0,NULL),(6,'Fajar Nugroho','fajar@contoh.id','2026-10-09 21:54:44','$2y$12$5ezZhum.QxpWhnHAEvyXQO4REPWKfNkT/nfOoHbytHMM6muwomSXK','082155556666','Jl. Tebet Raya No. 9, Tebet\nJakarta Selatan 12820','customer',NULL,'2026-05-20 21:54:44','2026-10-09 21:54:44',0,NULL),(7,'Nadia Putri','nadia@contoh.id','2026-10-09 21:54:44','$2y$12$z5kmEi2C0KFifQPKoAeRvOB2dqF7uzes646CtYDF8uQniKVyU9ZWS','087866667777','Jl. Gatot Subroto No. 88, Denpasar Barat\nBali 80119','customer',NULL,'2026-06-01 21:54:44','2026-10-09 21:54:44',0,NULL);
/*!40000 ALTER TABLE `users` 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 */;

