Da

✏️ Editing: wkgarmen_db_r.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: wkgarmen_db_r
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB-log

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

--
-- Current Database: `wkgarmen_db_r`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wkgarmen_db_r` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `wkgarmen_db_r`;

--
-- Table structure for table `admin_users`
--

DROP TABLE IF EXISTS `admin_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `role` enum('admin','manager','staff') DEFAULT 'admin',
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_users`
--

LOCK TABLES `admin_users` WRITE;
/*!40000 ALTER TABLE `admin_users` DISABLE KEYS */;
INSERT INTO `admin_users` VALUES (1,'admin','$2y$10$/VKAjgKcRvJqI5W/yaxbfOv02eXIrQpqU7MvQlAYM3xfjlJcclwFO','admin@wkgarmentfactory.com','Administrator','admin',1,'2025-09-23 09:13:45','2025-09-23 09:23:07'),(2,'manager','$2y$10$V4SIgLe9qrdN8wqwnKu6TuITOWoe6z76M7UczkaSEY9A2NO4ekeAq','manager@wkgarmentfactory.com','Manager','manager',1,'2025-09-23 09:13:45','2025-09-23 09:13:45'),(3,'staff','$2y$10$1.QGeFYyHpByBIFd2qlr6uQ.M9dsfuvW8YuT1P6xc9QP4WLLA2era','staff@wkgarmentfactory.com','Staff','staff',1,'2025-09-23 09:13:45','2025-09-23 09:13:45');
/*!40000 ALTER TABLE `admin_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_events`
--

DROP TABLE IF EXISTS `order_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL,
  `event_type` varchar(50) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_order_event_order` (`order_id`),
  CONSTRAINT `fk_events_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=293 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_events`
--

LOCK TABLES `order_events` WRITE;
/*!40000 ALTER TABLE `order_events` DISABLE KEYS */;
INSERT INTO `order_events` VALUES (200,304,'created','Order created successfully','2025-09-25 02:22:27'),(201,304,'updated','Order updated successfully','2025-09-25 02:22:29'),(202,304,'updated','Order updated successfully','2025-09-25 02:23:24'),(203,304,'updated','Order updated successfully','2025-09-25 02:23:24'),(204,304,'updated','Order updated successfully','2025-09-25 02:26:02'),(205,304,'updated','Order updated successfully','2025-09-25 02:31:59'),(206,304,'updated','Order updated successfully','2025-09-25 02:34:47'),(207,305,'created','Order created successfully','2025-09-25 04:36:24'),(208,305,'updated','Order updated successfully','2025-09-25 04:36:25'),(209,306,'created','Order created successfully','2025-09-25 04:51:56'),(210,306,'updated','Order updated successfully','2025-09-25 04:51:58'),(211,306,'updated','Order updated successfully','2025-09-25 04:52:49'),(212,306,'updated','Order updated successfully','2025-09-25 04:52:49'),(213,306,'updated','Order updated successfully','2025-09-25 04:52:49'),(214,306,'updated','Order updated successfully','2025-09-25 04:53:13'),(215,307,'created','Order created successfully','2025-09-25 05:01:40'),(216,307,'updated','Order updated successfully','2025-09-25 05:01:42'),(217,308,'created','Order created successfully','2025-09-25 05:11:34'),(218,308,'updated','Order updated successfully','2025-09-25 05:11:35'),(219,309,'created','Order created successfully','2025-09-25 05:18:27'),(220,309,'updated','Order updated successfully','2025-09-25 05:18:28'),(221,310,'created','Order created successfully','2025-09-25 05:30:00'),(222,310,'updated','Order updated successfully','2025-09-25 05:30:07'),(223,311,'created','Order created successfully','2025-09-25 05:46:23'),(224,311,'updated','Order updated successfully','2025-09-25 05:46:26'),(225,312,'created','Order created successfully','2025-09-25 05:48:11'),(226,312,'updated','Order updated successfully','2025-09-25 05:48:15'),(227,313,'created','Order created successfully','2025-09-25 06:33:27'),(228,313,'updated','Order updated successfully','2025-09-25 06:33:30'),(229,314,'created','Order created successfully','2025-09-25 11:45:32'),(230,314,'updated','Order updated successfully','2025-09-25 11:45:34'),(231,315,'created','Order created successfully','2025-09-25 11:55:22'),(232,315,'updated','Order updated successfully','2025-09-25 11:55:23'),(233,316,'created','Order created successfully','2025-09-25 12:01:07'),(234,316,'updated','Order updated successfully','2025-09-25 12:01:10'),(235,317,'created','Order created successfully','2025-09-25 12:08:15'),(236,317,'updated','Order updated successfully','2025-09-25 12:08:16'),(237,318,'created','Order created successfully','2025-09-25 12:10:23'),(238,318,'updated','Order updated successfully','2025-09-25 12:10:24'),(239,319,'created','Order created successfully','2025-09-25 12:12:44'),(240,319,'updated','Order updated successfully','2025-09-25 12:12:51'),(241,320,'created','Order created successfully','2025-09-25 12:16:31'),(242,320,'updated','Order updated successfully','2025-09-25 12:16:33'),(243,321,'created','Order created successfully','2025-09-25 12:17:47'),(244,321,'updated','Order updated successfully','2025-09-25 12:17:49'),(245,322,'created','Order created successfully','2025-09-25 12:18:31'),(246,322,'updated','Order updated successfully','2025-09-25 12:18:32'),(247,323,'created','Order created successfully','2025-09-25 12:22:17'),(248,323,'updated','Order updated successfully','2025-09-25 12:22:17'),(249,324,'created','Order created successfully','2025-09-25 12:25:12'),(250,324,'updated','Order updated successfully','2025-09-25 12:25:13'),(251,325,'created','Order created successfully','2025-09-25 12:27:49'),(252,325,'updated','Order updated successfully','2025-09-25 12:27:57'),(253,326,'created','Order created successfully','2025-09-25 12:28:23'),(254,326,'updated','Order updated successfully','2025-09-25 12:28:24'),(255,327,'created','Order created successfully','2025-09-25 12:29:10'),(256,327,'updated','Order updated successfully','2025-09-25 12:29:10'),(257,328,'created','Order created successfully','2025-09-25 12:30:36'),(258,328,'updated','Order updated successfully','2025-09-25 12:30:37'),(259,329,'created','Order created successfully','2025-09-25 12:32:05'),(260,329,'updated','Order updated successfully','2025-09-25 12:32:06'),(261,330,'created','Order created successfully','2025-09-25 12:33:00'),(262,330,'updated','Order updated successfully','2025-09-25 12:33:01'),(263,331,'created','Order created successfully','2025-09-25 12:33:30'),(264,331,'updated','Order updated successfully','2025-09-25 12:33:31'),(265,332,'created','Order created successfully','2025-09-25 12:34:24'),(266,332,'updated','Order updated successfully','2025-09-25 12:34:25'),(267,333,'created','Order created successfully','2025-09-25 12:38:50'),(268,333,'updated','Order updated successfully','2025-09-25 12:38:51'),(269,334,'created','Order created successfully','2025-09-25 12:48:05'),(270,334,'updated','Order updated successfully','2025-09-25 12:48:07'),(271,335,'created','Order created successfully','2025-09-25 12:52:57'),(272,335,'updated','Order updated successfully','2025-09-25 12:52:58'),(273,336,'created','Order created successfully','2025-09-25 13:02:42'),(274,336,'updated','Order updated successfully','2025-09-25 13:02:45'),(275,337,'created','Order created successfully','2025-09-25 13:03:48'),(276,337,'updated','Order updated successfully','2025-09-25 13:03:50'),(277,338,'created','Order created successfully','2025-09-29 13:43:01'),(278,338,'updated','Order updated successfully','2025-09-29 13:43:24'),(279,339,'created','Order created successfully','2025-10-10 01:25:51'),(280,339,'updated','Order updated successfully','2025-10-10 01:25:53'),(281,340,'created','Order created successfully','2025-10-11 06:02:31'),(282,340,'updated','Order updated successfully','2025-10-11 06:02:33'),(283,341,'created','Order created successfully','2025-10-12 20:50:59'),(284,341,'updated','Order updated successfully','2025-10-12 20:51:08'),(285,342,'created','Order created successfully','2025-10-14 06:23:10'),(286,342,'updated','Order updated successfully','2025-10-14 06:23:11'),(287,343,'created','Order created successfully','2025-10-14 09:07:07'),(288,343,'updated','Order updated successfully','2025-10-14 09:07:07'),(289,344,'created','Order created successfully','2025-10-18 07:32:36'),(290,344,'updated','Order updated successfully','2025-10-18 07:32:37'),(291,345,'created','Order created successfully','2025-10-18 13:15:20'),(292,345,'updated','Order updated successfully','2025-10-18 13:15:48');
/*!40000 ALTER TABLE `order_events` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `order_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL,
  `product_name` varchar(200) NOT NULL,
  `sku` varchar(100) DEFAULT NULL,
  `quantity` int(10) unsigned NOT NULL DEFAULT 1,
  `unit_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `line_total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `size` varchar(20) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `view_side` enum('front','back','left','right') DEFAULT 'front',
  `design_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`design_json`)),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_order_id` (`order_id`),
  CONSTRAINT `fk_items_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(32) NOT NULL,
  `status` enum('pending','paid','processing','shipped','completed','cancelled') NOT NULL DEFAULT 'pending',
  `customer_name` varchar(160) NOT NULL,
  `customer_email` varchar(160) DEFAULT NULL,
  `customer_phone` varchar(60) DEFAULT NULL,
  `shipping_address` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `export_path` varchar(500) DEFAULT NULL,
  `export_path_back` varchar(500) DEFAULT NULL,
  `upload_path` varchar(500) DEFAULT NULL,
  `upload_paths` text DEFAULT NULL,
  `total_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `currency` varchar(8) NOT NULL DEFAULT 'THB',
  `payment_status` enum('unpaid','paid','refunded','failed') NOT NULL DEFAULT 'unpaid',
  `payment_method` varchar(50) DEFAULT NULL,
  `payment_slip_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `active` enum('yes','no') DEFAULT 'yes',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_number` (`order_number`),
  KEY `idx_status_created` (`status`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (304,'WK20250925022227228','pending','ttt',NULL,'ttt','ttt','Line: ttt, Quantity: 33, Size: S','orders/WK20250925022227228/exports/upload_20250925022228_abbf7143.png','orders/WK20250925022227228/exports/upload_20250925022228_c1c7d929.png','orders/WK20250925022227228/uploads/upload_20250925022229_d2752d58.jpg','[\"orders\\/WK20250925022227228\\/uploads\\/upload_20250925022229_d2752d58.jpg\"]',100.00,'THB','paid',NULL,'orders/ORD-304/slips/slip_20250925022336_1b29cb24.jpg','2025-09-25 02:22:27','2025-09-25 02:34:47','yes'),(305,'WK20250925043624997','pending','13',NULL,'098-131-1311',NULL,'Line: 13, Quantity: 1, Size: S','orders/WK20250925043624997/exports/upload_20250925043624_48690160.png','orders/WK20250925043624997/exports/upload_20250925043625_3acc5368.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 04:36:24','2025-09-25 04:36:25','yes'),(306,'WK20250925045156335','processing','Test1',NULL,'091-134-1134','ttt','Line: Test1, Quantity: 3, Size: 3XL',NULL,NULL,NULL,NULL,100.00,'THB','paid',NULL,'orders/ORD-306/slips/slip_20250925045303_9d6fcdde.jpg','2025-09-25 04:51:56','2025-09-25 04:54:54','no'),(307,'WK20250925050140181','pending','SSS',NULL,'091-111-1111',NULL,'Line: SSS, Quantity: 3, Size: S','orders/WK20250925050140181/exports/upload_20250925050141_b79555c0.png','orders/WK20250925050140181/exports/upload_20250925050141_3e3026c7.png','orders/WK20250925050140181/uploads/upload_20250925050142_b5beacb6.JPG','[\"orders\\/WK20250925050140181\\/uploads\\/upload_20250925050142_b5beacb6.JPG\"]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 05:01:40','2025-09-25 05:01:42','yes'),(308,'WK20250925051134672','pending','FIT',NULL,'083-123-4567',NULL,'Line: fit123456, Quantity: 1, Size: 3XL','orders/WK20250925051134672/exports/upload_20250925051135_97c25143.png','orders/WK20250925051134672/exports/upload_20250925051135_10239258.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 05:11:34','2025-09-25 05:11:35','yes'),(309,'WK20250925051827866','pending','หำดหำด',NULL,'091111111',NULL,'Line: ำด, Quantity: 1, Size: M','orders/WK20250925051827866/exports/upload_20250925051828_0bbf1907.png','orders/WK20250925051827866/exports/upload_20250925051828_fbe83139.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 05:18:27','2025-09-25 05:18:28','yes'),(310,'WK20250925053000618','pending','Hhh',NULL,'093-663-3666',NULL,'Line: Hhh, Quantity: 1, Size: S','orders/WK20250925053000618/exports/upload_20250925053002_8a0a209f.png','orders/WK20250925053000618/exports/upload_20250925053004_a5fe931e.png','orders/WK20250925053000618/uploads/upload_20250925053007_8241a19a.jpeg','[\"orders\\/WK20250925053000618\\/uploads\\/upload_20250925053007_8241a19a.jpeg\"]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 05:30:00','2025-09-25 05:30:07','yes'),(311,'WK20250925054623577','pending','F',NULL,'088-229-6765',NULL,'Line: F, Quantity: 999, Size: Xxxxxl','orders/WK20250925054623577/exports/upload_20250925054624_efeb2325.png','orders/WK20250925054623577/exports/upload_20250925054625_d57582fa.png','orders/WK20250925054623577/uploads/upload_20250925054626_c66352f8.jpeg','[\"orders\\/WK20250925054623577\\/uploads\\/upload_20250925054626_c66352f8.jpeg\",\"orders\\/WK20250925054623577\\/uploads\\/upload_20250925054626_6e190ef6.jpeg\",\"orders\\/WK20250925054623577\\/uploads\\/upload_20250925054626_b3c6be02.jpeg\",\"orders\\/WK20250925054623577\\/uploads\\/upload_20250925054626_70a2b0b4.jpeg\"]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 05:46:23','2025-09-25 05:46:26','yes'),(312,'WK20250925054811926','pending','123',NULL,'091-111-1111',NULL,'Line: 123, Quantity: 1, Size: XS','orders/WK20250925054811926/exports/upload_20250925054813_3924b0a7.png','orders/WK20250925054811926/exports/upload_20250925054815_32e1658d.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 05:48:11','2025-09-25 05:48:15','yes'),(313,'WK20250925063327697','pending','ฟหก',NULL,'091-111-1111',NULL,'Line: ฟหก, Quantity: 1, Size: S','orders/WK20250925063327697/exports/upload_20250925063329_ce75b1a4.png','orders/WK20250925063327697/exports/upload_20250925063329_e17a3ae7.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 06:33:27','2025-09-25 06:33:30','yes'),(314,'WK20250925114532013','pending','ๅๅๅ',NULL,'091-1111111',NULL,'Line: ๅๅๅ, Quantity: 1, Size: S','orders/WK20250925114532013/exports/upload_20250925114533_f0d8c3ec.png','orders/WK20250925114532013/exports/upload_20250925114533_94fc2f99.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 11:45:32','2025-09-25 11:45:34','yes'),(315,'WK20250925115522325','pending','1341',NULL,'091-1111111',NULL,'Line: 14141, Quantity: 2, Size: XS','orders/WK20250925115522325/exports/upload_20250925115522_f456729d.png','orders/WK20250925115522325/exports/upload_20250925115523_28ff1ed3.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 11:55:22','2025-09-25 11:55:23','yes'),(316,'WK20250925120106809','pending','131313',NULL,'091-1111111',NULL,'Line: 131313, Quantity: 1, Size: XS','orders/WK20250925120106809/exports/upload_20250925120108_1bdd45dd.png','orders/WK20250925120106809/exports/upload_20250925120109_d7ff4e1a.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:01:07','2025-09-25 12:01:10','yes'),(317,'WK20250925120815030','pending','หฟกฟหก',NULL,'091-1111111',NULL,'Line: ฟหกฟหก, Quantity: 1, Size: XS','orders/WK20250925120815030/exports/upload_20250925120815_ff5c5638.png','orders/WK20250925120815030/exports/upload_20250925120816_76143490.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:08:15','2025-09-25 12:08:16','yes'),(318,'WK20250925121023300','pending','ๅ_ๅ_',NULL,'091-1111111',NULL,'Line: ๅ_ๅ_, Quantity: 1, Size: XS','orders/WK20250925121023300/exports/upload_20250925121023_d0245abd.png','orders/WK20250925121023300/exports/upload_20250925121024_396bf952.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:10:23','2025-09-25 12:10:24','yes'),(319,'WK20250925121244489','pending','TEST!!',NULL,'012-345-6789',NULL,'Line: TTEEST, Quantity: 99999, Size: XS','orders/WK20250925121244489/exports/upload_20250925121247_13f81f30.png','orders/WK20250925121244489/exports/upload_20250925121251_9f2e6339.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:12:44','2025-09-25 12:12:51','yes'),(320,'WK20250925121631221','pending','ฟหกฟ',NULL,'091-1111111',NULL,'Line: ฟหกฟหก, Quantity: 1, Size: XS','orders/WK20250925121631221/exports/upload_20250925121632_98ae2802.png','orders/WK20250925121631221/exports/upload_20250925121633_7cab1f8b.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:16:31','2025-09-25 12:16:33','yes'),(321,'WK20250925121747430','pending','1',NULL,'091-1111111',NULL,'Line: 1, Quantity: 1, Size: S','orders/WK20250925121747430/exports/upload_20250925121748_3e2906ea.png','orders/WK20250925121747430/exports/upload_20250925121748_97bd4578.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:17:47','2025-09-25 12:17:49','yes'),(322,'WK20250925121831389','pending','09111',NULL,'091-1111111',NULL,'Line: 111, Quantity: 1, Size: S','orders/WK20250925121831389/exports/upload_20250925121831_b8a9e0f4.png','orders/WK20250925121831389/exports/upload_20250925121832_31610bd0.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:18:31','2025-09-25 12:18:32','yes'),(323,'WK20250925122217719','pending','ฟหกห',NULL,'091-1111111',NULL,'Line: ฟหกฟหก, Quantity: 1, Size: M','orders/WK20250925122217719/exports/upload_20250925122217_88fc2874.png','orders/WK20250925122217719/exports/upload_20250925122217_ced3fa57.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:22:17','2025-09-25 12:22:17','yes'),(324,'WK20250925122512502','pending','11',NULL,'091-1111111',NULL,'Line: 11, Quantity: 1, Size: S','orders/WK20250925122512502/exports/upload_20250925122513_2ad97167.png','orders/WK20250925122512502/exports/upload_20250925122513_e5302e4d.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:25:12','2025-09-25 12:25:13','yes'),(325,'WK20250925122749970','pending','test',NULL,'012-345-6789',NULL,'Line: testline, Quantity: 99, Size: XS','orders/WK20250925122749970/exports/upload_20250925122754_514e823b.png','orders/WK20250925122749970/exports/upload_20250925122757_9bde2d69.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:27:49','2025-09-25 12:27:57','yes'),(326,'WK20250925122823527','pending','ฟหกฟหก',NULL,'091-1111111',NULL,'Line: ฟหกฟหก, Quantity: 1, Size: S','orders/WK20250925122823527/exports/upload_20250925122823_a2570e80.png','orders/WK20250925122823527/exports/upload_20250925122824_e41c1b24.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:28:23','2025-09-25 12:28:24','yes'),(327,'WK20250925122910347','pending','1111',NULL,'091-1111111',NULL,'Line: 1111, Quantity: 1, Size: XS','orders/WK20250925122910347/exports/upload_20250925122910_0c548d78.png','orders/WK20250925122910347/exports/upload_20250925122910_3592aba0.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:29:10','2025-09-25 12:29:10','yes'),(328,'WK20250925123036512','pending','asd',NULL,'091-1111111',NULL,'Line: asd, Quantity: 1, Size: S','orders/WK20250925123036512/exports/upload_20250925123036_c5e33d4c.png','orders/WK20250925123036512/exports/upload_20250925123037_84299de4.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:30:36','2025-09-25 12:30:37','yes'),(329,'WK20250925123205472','pending','asdsad',NULL,'091-1111111',NULL,'Line: asdas, Quantity: 1, Size: S','orders/WK20250925123205472/exports/upload_20250925123205_0f80ba81.png','orders/WK20250925123205472/exports/upload_20250925123206_d7257b7a.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:32:05','2025-09-25 12:32:06','yes'),(330,'WK20250925123300479','pending','11',NULL,'091-1111111',NULL,'Line: 111, Quantity: 1, Size: S','orders/WK20250925123300479/exports/upload_20250925123300_e82cd093.png','orders/WK20250925123300479/exports/upload_20250925123301_e8ebf740.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:33:00','2025-09-25 12:33:01','yes'),(331,'WK20250925123330467','pending','asddsa',NULL,'091-1111111',NULL,'Line: asdasd, Quantity: 1, Size: M','orders/WK20250925123330467/exports/upload_20250925123330_5e9dda87.png','orders/WK20250925123330467/exports/upload_20250925123331_cae94d0b.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:33:30','2025-09-25 12:33:31','yes'),(332,'WK20250925123424776','pending','asdas',NULL,'091-1111111',NULL,'Line: asdasdas, Quantity: 1, Size: M','orders/WK20250925123424776/exports/upload_20250925123424_bb444a23.png','orders/WK20250925123424776/exports/upload_20250925123425_e791ae9a.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:34:24','2025-09-25 12:34:25','yes'),(333,'WK20250925123850345','pending','asdasd',NULL,'091-1111111',NULL,'Line: asdasd, Quantity: 1, Size: S','orders/WK20250925123850345/exports/upload_20250925123850_a3b2c388.png','orders/WK20250925123850345/exports/upload_20250925123851_c88b9be9.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:38:50','2025-09-25 12:38:51','yes'),(334,'WK20250925124805382','pending','ฟหก',NULL,'091-1111111',NULL,'Line: ฟหก, Quantity: 1, Size: M','orders/WK20250925124805382/exports/upload_20250925124806_f789a9c6.png','orders/WK20250925124805382/exports/upload_20250925124806_73d8ada6.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:48:05','2025-09-25 12:48:07','yes'),(335,'WK20250925125257053','pending','asdasd',NULL,'091-1111111',NULL,'Line: asdasd, Quantity: 1, Size: M','orders/WK20250925125257053/exports/upload_20250925125257_4f9bf31e.png','orders/WK20250925125257053/exports/upload_20250925125258_d724c2e5.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 12:52:57','2025-09-25 12:52:58','yes'),(336,'WK20250925130242240','pending','ฟหกฟหก',NULL,'091-1111111',NULL,'Line: ฟหกฟหก, Quantity: 1, Size: XS','orders/WK20250925130242240/exports/upload_20250925130244_94ea3d46.png','orders/WK20250925130242240/exports/upload_20250925130244_8a017668.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 13:02:42','2025-09-25 13:02:45','yes'),(337,'WK20250925130348449','pending','asdasd',NULL,'091-1111111',NULL,'Line: 3333, Quantity: 1, Size: XS','orders/WK20250925130348449/exports/upload_20250925130349_47f0f1b6.png','orders/WK20250925130348449/exports/upload_20250925130350_76dfabf9.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-25 13:03:48','2025-09-25 13:03:50','yes'),(338,'WK20250929134301786','pending','พิชญานันท์',NULL,'061-476-2268',NULL,'Line: Pitchanan💫, Quantity: 1, Size: M','orders/WK20250929134301786/exports/upload_20250929134312_512862aa.png','orders/WK20250929134301786/exports/upload_20250929134324_55acc826.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-09-29 13:43:01','2025-09-29 13:43:24','yes'),(339,'WK20251010012551610','pending','Tossaporn',NULL,'081-234-5678',NULL,'Line: FTEST, Quantity: 1000, Size: XL','orders/WK20251010012551610/exports/upload_20251010012552_9295b685.png','orders/WK20251010012551610/exports/upload_20251010012553_dd744ba2.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-10-10 01:25:51','2025-10-10 01:25:53','yes'),(340,'WK20251011060231903','pending','สั่งพิเศษ',NULL,'081-234-5678',NULL,'Line: FTEST, Quantity: 3, Size: 3XL','orders/WK20251011060231903/exports/upload_20251011060232_de50066b.png','orders/WK20251011060231903/exports/upload_20251011060233_34547a27.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-10-11 06:02:31','2025-10-11 06:02:33','yes'),(341,'WK20251012205059997','pending','โต๊ด',NULL,'095-332-1505',NULL,'Line: ตายห่า, Quantity: 1, Size: S','orders/WK20251012205059997/exports/upload_20251012205103_61f4cbc7.png','orders/WK20251012205059997/exports/upload_20251012205105_b7709ba2.png','orders/WK20251012205059997/uploads/upload_20251012205108_a39bc703.jpg','[\"orders\\/WK20251012205059997\\/uploads\\/upload_20251012205108_a39bc703.jpg\",\"orders\\/WK20251012205059997\\/uploads\\/upload_20251012205106_06fb1fa3.png\",\"orders\\/WK20251012205059997\\/uploads\\/upload_20251012205108_acf59f32.jpg\",\"orders\\/WK20251012205059997\\/uploads\\/upload_20251012205106_500e15d3.jpg\",\"orders\\/WK20251012205059997\\/uploads\\/upload_20251012205106_f41e0fc5.jpg\",\"orders\\/WK20251012205059997\\/uploads\\/upload_20251012205106_ff1994ca.jpg\"]',0.00,'THB','unpaid',NULL,NULL,'2025-10-12 20:50:59','2025-10-12 20:51:08','yes'),(342,'WK20251014062310059','pending','ทดสอบ',NULL,'081-234-5678',NULL,'Line: FTEST, Quantity: 1, Size: 2XL','orders/WK20251014062310059/exports/upload_20251014062311_48f7cff6.png','orders/WK20251014062310059/exports/upload_20251014062311_68aba7f1.png','orders/WK20251014062310059/uploads/upload_20251014062311_160cac2e.png','[\"orders\\/WK20251014062310059\\/uploads\\/upload_20251014062311_160cac2e.png\",\"orders\\/WK20251014062310059\\/uploads\\/upload_20251014062311_f3fdf62a.png\"]',0.00,'THB','unpaid',NULL,NULL,'2025-10-14 06:23:10','2025-10-14 06:23:11','yes'),(343,'WK20251014090707682','pending','Test1',NULL,'091-1111111',NULL,'Line: Test1, Quantity: 1, Size: XS','orders/WK20251014090707682/exports/upload_20251014090707_43c3ec1b.png','orders/WK20251014090707682/exports/upload_20251014090707_19f0924e.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-10-14 09:07:07','2025-10-14 09:07:07','yes'),(344,'WK20251018073236676','pending','กัญญารัตน์',NULL,'095-1352410',NULL,'Line: Kanyarat, Quantity: 1, Size: M','orders/WK20251018073236676/exports/upload_20251018073236_0846c812.png','orders/WK20251018073236676/exports/upload_20251018073237_573a959a.png','orders/WK20251018073236676/uploads/upload_20251018073237_623c6b99.jfif','[\"orders\\/WK20251018073236676\\/uploads\\/upload_20251018073237_623c6b99.jfif\",\"orders\\/WK20251018073236676\\/uploads\\/upload_20251018073237_89974b6b.jfif\",\"orders\\/WK20251018073236676\\/uploads\\/upload_20251018073237_c52004fe.jfif\"]',0.00,'THB','unpaid',NULL,NULL,'2025-10-18 07:32:36','2025-10-18 07:32:37','yes'),(345,'WK20251018131520714','pending','เฉลิมชัย',NULL,'097-0466547',NULL,'Line: เฉลิมชัย คู่โนรัมย์, Quantity: 1, Size: M','orders/WK20251018131520714/exports/upload_20251018131545_75d162fa.png','orders/WK20251018131520714/exports/upload_20251018131548_1aee4a1f.png',NULL,'[]',0.00,'THB','unpaid',NULL,NULL,'2025-10-18 13:15:20','2025-10-18 13:15:48','yes');
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2025-10-31 13:30:25

📁 Sid Gifari File Manager