Da

✏️ Editing: jsilpcom_db.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: jsilpcom_db
-- ------------------------------------------------------
-- 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: `jsilpcom_db`
--

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

USE `jsilpcom_db`;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name_th` varchar(100) DEFAULT NULL,
  `name_en` varchar(100) DEFAULT NULL,
  `group` varchar(100) DEFAULT NULL,
  `qty` decimal(10,0) NOT NULL DEFAULT 1,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `create_at` datetime NOT NULL DEFAULT current_timestamp(),
  `is_status` int(1) NOT NULL DEFAULT 1,
  `is_type` int(1) NOT NULL DEFAULT 0 COMMENT '0 = Product, 1 = Service, 2 = All',
  `is_service` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name_th`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES (1,'IN MOULD LABEL (IML)','IN MOULD LABEL (IML)','IN MOULD LABEL (IML)',1,0.00,'ขนาด 2.7 ลิตร','file_20250824.68aafce5b29a84.18953704.png,file_20250824.68aafce5b30756.24838739.png,file_20250824.68aafce5b33567.85088199.png,file_20250824.68aafce5b367d3.05020091.png,file_20250824.68aafce5b392b1.93736571.png,file_20250824.68aafce5b3c344.76610565.png,file_20250824.68aafce5b3f736.70173883.png,file_20250824.68aafce5b42852.26344500.png,file_20250824.68aafce5b45d22.26896355.png,file_20250824.68aafce5b482f1.89050875.png,file_20250824.68aafce5b4aee0.31117319.png,file_20250824.68aafce5b4da59.68942503.png,file_20250824.68aafce5b4fd69.29348313.png,file_20250824.68aafce5b51b55.88557406.png,file_20250824.68aafce5b53c04.49921470.png,file_20250824.68aafce5b56435.73773583.png','2025-07-30 14:22:36',1,1,'การฉีดขึ้นรูปพลาสติก'),(30,'อะไหล่รถยนต์','Autoparts','AUTOPARTS',1,0.00,'SKU: -\r\nขนาด: -\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250823.68a9463b9f7469.87399209.png','2025-08-23 04:40:27',1,1,'การฉีดขึ้นรูปพลาสติก'),(31,'่เครื่องใช้ไฟฟ้า','Appliance Parts','APPLIANCE PARTS',1,0.00,'SKU: -\r\nขนาด: -\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250823.68a946f3c557d1.59461590.png,file_20250823.68a946f3c575a8.36260693.png,file_20250823.68a946f3c596b9.93783143.png,file_20250823.68a946f3c5af42.72524977.png,file_20250823.68a946f3c5c6d9.57603229.png,file_20250823.68a946f3c5dd52.19372464.png,file_20250823.68a946f3c5f4b8.88591063.png,file_20250823.68a946f3c606e9.97407343.png,file_20250823.68a946f3c61b95.43143066.png,file_20250823.68a946f3c63819.55280891.png,file_20250823.68a946f3c64d40.95658790.png,file_20250823.68a946f3c66560.00769313.png,file_20250823.68a946f3c67c23.84369896.png,file_20250823.68a946f3c69331.81516468.png,file_20250823.68a946f3c6a747.84960874.png','2025-08-23 04:43:31',1,1,'การฉีดขึ้นรูปพลาสติก'),(32,'ถังเซฟตี้ขนาด 2.7 ลิตร','Bucket Safety Seal 2.7 l.','SAFETY SEAL BUCKET',1,0.00,'SKU: -\r\nขนาด: - 2.7 ลิตร\r\nบรรจุ: - 50 pcs.\r\nอื่นๆ: -','file_20250823.68a947c7713e49.29013260.png,file_20250823.68a947c77157d4.89386180.png,file_20250823.68a947c7716bb8.88774361.png','2025-08-23 04:47:03',1,0,''),(33,'รับผลิตแท่งไฟคอนเสิร์ต ','Light Stick','LIGHT STICK',1,0.00,'SKU: -\r\nขนาด: -\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250823.68a948ba9b7887.10489680.png,file_20250823.68a948ba9b9343.79281781.png,file_20250823.68a948ba9ba6d2.91946157.png,file_20250823.68a948ba9bba21.34407178.png','2025-08-23 04:51:06',1,1,'การออกแบบและการผลิต'),(34,'ชุดดับเก็บเชื้อปรสิตในอุจจาระ','JK-Parasite Tarp','MEDICAL EQUIPMENT',1,0.00,'SKU: -\r\nขนาด: -\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250823.68a94bb52e74c1.65636444.png,file_20250823.68a94bb52ea509.26080696.png','2025-08-23 05:03:49',1,1,'การออกแบบและการผลิต'),(35,'อื่นๆ','Other','OTHER',1,0.00,'กลุ่มงานพลาสติกอื่น ๆ','file_20250823.68a94cc6e9f726.60604927.png,file_20250823.68a94cc6ea2655.86797887.png,file_20250823.68a94cc6ea4021.68876578.png,file_20250823.68a94cc6ea5c16.20357625.png,file_20250823.68a94cc6ea75e4.71079474.png,file_20250823.68a94cc6ea9b44.96640037.png,file_20250823.68a94cc6eab764.34108142.png,file_20250823.68a94cc6eadb47.58272108.png,file_20250823.68a94cc6eaff94.02319799.png,file_20250823.68a94cc6eb1b36.17320342.png,file_20250823.68a94cc6eb3208.94342130.png','2025-08-23 05:08:22',1,1,'การฉีดขึ้นรูปพลาสติก'),(36,'ถ้วยใส่ยา','Medicine Cup','PLASTIC CONTAINERS',1,0.00,'SKU: - ถ้วยใส่ยาเม็ด&ยาน้ำ\r\nขนาด: -\r\nบรรจุ: -100 pcs.\r\nอื่นๆ: -','file_20250823.68a94d8d1edfa8.51462510.png','2025-08-23 05:11:41',1,0,''),(37,'ถ้วยเก็บอุจจาระ 40 ml.','Stool Container 40 ml.','PLASTIC CONTAINERS',1,0.00,'SKU: -ถ้วยใส่อุจจาระ\r\nขนาด: -40 ml.\r\nบรรจุ: - 100 pcs.\r\nอื่นๆ: -','file_20250823.68a94e4a960853.84244653.png','2025-08-23 05:14:50',1,0,''),(38,'ภาชนะเก็บสิ่งส่งตรวจ','Sample Container','PLASTIC CONTAINERS',1,0.00,'SKU: -ภาชนะเก็บสิ่งส่งตรวจ (สีเหลือง+สีเหลือง)\r\nขนาด: - 60 ml.\r\nบรรจุ: - 100 pcs.\r\nอื่นๆ: -','file_20250823.68a94fa1058bb9.71098215.png','2025-08-23 05:20:33',1,0,''),(40,'ภาชนะเก็บสิ่งส่งตรวจ 2','Sample Container 2','PLASTIC CONTAINERS',1,0.00,'SKU: -ภาชนะเก็บสิ่งส่งตรวจ (ฝาส้ม)\r\nขนาด: - 60 ml.\r\nบรรจุ: - 100 pcs.\r\nอื่นๆ: -','file_20250823.68a95399ab3126.03592807.png','2025-08-23 05:37:29',1,0,''),(41,'ภาชนะเก็บสิ่งส่งตรวจ 3','Sample Container 3','PLASTIC CONTAINERS',1,0.00,'SKU: - ภาชนะเก็บสิ่งส่งตรวจ (ฝาเหลือง)\r\nขนาด: - 60 ml.\r\nบรรจุ: - 100 pcs.\r\nอื่นๆ: -','file_20250823.68a953e535dac3.62309911.png','2025-08-23 05:38:45',1,0,''),(42,'ถ้วยใส่ยา 60 ml.','Medicine Cup 60 ml.','PLASTIC CONTAINERS',1,0.00,'SKU: -ถ้วยใส่ยา 60 ml.\r\nขนาด: - 60 ml.\r\nบรรจุ: - 100 pcs.\r\nอื่นๆ: -','file_20250823.68a9545681bd82.03058280.png','2025-08-23 05:40:38',1,0,''),(44,'ฝาไอติม 4 oz. ','Ice Cream Lid 4 oz.','ICE CREAM PACKAGING',1,0.00,'SKU: - ฝาไอติม 4 oz.\r\nขนาด: -\r\nบรรจุ: - 100 pcs\r\nอื่นๆ: -','file_20250825.68ac3f19e84d71.99423082.png,file_20250825.68ac3f19e866f0.87038596.png,file_20250825.68ac3f19e87e98.00649542.png,file_20250825.68ac3f19e89537.40215200.png,file_20250825.68ac3f19e8a0b5.07915655.png,file_20250825.68ac3f19e8ab57.01428387.png','2025-08-23 05:48:43',1,0,''),(45,'ฝาไอติม 5 oz. ','Ice Cream Lid 5 oz.','ICE CREAM PACKAGING',1,0.00,'SKU: - ฝาไอติม 5 oz.\r\nขนาด: -\r\nบรรจุ: - 100 pcs.\r\nอื่นๆ: -','file_20250825.68ac3ed781efe8.57486464.png,file_20250825.68ac3ed7820b20.78853704.png,file_20250825.68ac3ed7822477.43388441.png,file_20250825.68ac3ed7825bf5.64047659.png,file_20250825.68ac3ed78267d6.94802886.png,file_20250825.68ac3ed78272c2.52828571.png','2025-08-23 05:49:49',1,0,''),(46,'ช้อนไอติม','Ice Cream Spoon','ICE CREAM PACKAGING',1,0.00,'SKU: -ช้อนไอติม\r\nขนาด: -\r\nบรรจุ: - 1000 pcs.\r\nอื่นๆ: -','file_20250908.68be5e170894b8.22061533.png,file_20250908.68be5e1711c4a4.46259524.png,file_20250908.68be5e1711d771.87573348.png','2025-08-23 05:51:48',1,0,''),(47,'รับผลิตชั้นวางสินค้า','Rack&Shelf','RACK&SHELF',1,0.00,'SKU: -\r\nขนาด: -\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250825.68ac1df4011274.91005936.png,file_20250825.68ac1df4013e94.43509412.png','2025-08-25 08:25:24',1,1,'การออกแบบและการผลิต'),(48,'รับผลิตดิสเพลย์โชว์สินค้า','Product Display','PRODUCT DISPLAY',1,0.00,'SKU: -\r\nขนาด: -\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250825.68ac1f647041d4.40144648.png,file_20250825.68ac1f64706d80.90314804.png,file_20250825.68ac1f64709095.54506671.png,file_20250825.68ac1f6470af65.59368842.png,file_20250825.68ac1f6470d499.21878033.png,file_20250825.68ac1f6470eb02.17493003.png,file_20250825.68ac1f64710059.66478467.png,file_20250825.68ac1f647115e2.67602367.png,file_20250825.68ac1f64712876.21581926.png,file_20250825.68ac1f64713926.52612705.png,file_20250825.68ac1f64715027.34109167.png','2025-08-25 08:31:32',1,1,'การออกแบบและการผลิต'),(51,'ดิสเพลย์สินค้า','Display','DISPLAY',1,0.00,'SKU: -\r\nขนาด: -\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250825.68ac24f54349e5.26327665.png,file_20250825.68ac24f54381b3.13325573.png,file_20250825.68ac24f543a761.32908126.png,file_20250825.68ac24f543c450.42700894.png,file_20250825.68ac24f543ea77.83226182.png,file_20250825.68ac24f5440007.41873258.png,file_20250825.68ac24f54416c0.14791945.png,file_20250825.68ac24f5442927.47453459.png,file_20250825.68ac24f5443ae9.29630352.png,file_20250825.68ac24f5444aa0.00747572.png,file_20250825.68ac24f54463f3.60223698.png,file_20250825.68ac24f5447bc8.81067025.png,file_20250825.68ac24f5449395.89207922.png','2025-08-25 08:55:17',1,1,'การฉีดขึ้นรูปพลาสติก'),(52,'ถังใส่คุกกี้','Cookie Bucket','SAFETY SEAL BUCKET',1,0.00,'SKU: -ถังใส่คุกกี้\r\nขนาด: -ขนาด 2.7 l\r\nบรรจุ: -\r\nอื่นๆ: -','file_20250925.68d4faab599d05.40072547.png,file_20250925.68d4faab623c61.47078141.png,file_20250925.68d4faab625746.53012974.png','2025-09-25 15:17:47',1,0,'');
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_group`
--

DROP TABLE IF EXISTS `product_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_group` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_th` varchar(50) DEFAULT NULL,
  `name_en` varchar(50) DEFAULT NULL,
  `create_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_group`
--

LOCK TABLES `product_group` WRITE;
/*!40000 ALTER TABLE `product_group` DISABLE KEYS */;
INSERT INTO `product_group` VALUES (2,'ถังเซฟตี้ซีล','SAFETY SEAL BUCKET','2025-08-15 09:51:12'),(3,'บรรจุภัณฑ์พลาสติก','PLASTIC CONTAINERS','2025-08-15 09:51:26'),(4,'ไอศกรีมแพ็ค','ICE CREAM PACKAGING','2025-08-15 09:51:36');
/*!40000 ALTER TABLE `product_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `services`
--

DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_th` varchar(50) DEFAULT NULL,
  `name_en` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `services`
--

LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
INSERT INTO `services` VALUES (1,'การฉีดขึ้นรูปพลาสติก','INJECTION PLASTIC'),(2,'การออกแบบและการผลิต','DESING & MANUFACTURING');
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(20) NOT NULL,
  `is_status` int(1) NOT NULL DEFAULT 1,
  `create_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','UGFuZzI0MDYyNA==',1,'2025-07-30 09:52:29');
/*!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 */;

-- Dump completed on 2025-10-31 13:21:02

📁 Sid Gifari File Manager