Da

✏️ Editing: thaiddcc_hwincheck.sql

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

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

USE `thaiddcc_hwincheck`;

--
-- Table structure for table `invoice_buy`
--

DROP TABLE IF EXISTS `invoice_buy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_buy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(255) NOT NULL,
  `purchase_channel` varchar(255) DEFAULT NULL,
  `vat_status` varchar(3) NOT NULL,
  `customer_id` varchar(255) DEFAULT NULL,
  `seller_name` varchar(255) DEFAULT NULL,
  `seller_address` varchar(255) DEFAULT NULL,
  `product_name1` varchar(255) DEFAULT NULL,
  `serial_number1` varchar(255) DEFAULT NULL,
  `product_category1` varchar(255) DEFAULT NULL,
  `product_amount1` int(11) DEFAULT NULL,
  `product_price_before_vat1` decimal(10,2) DEFAULT NULL,
  `product_price_after_vat1` decimal(10,2) DEFAULT NULL,
  `product_name2` varchar(255) DEFAULT NULL,
  `serial_number2` varchar(255) DEFAULT NULL,
  `product_category2` varchar(255) DEFAULT NULL,
  `product_amount2` int(11) DEFAULT NULL,
  `product_price_before_vat2` decimal(10,2) DEFAULT NULL,
  `product_price_after_vat2` decimal(10,2) DEFAULT NULL,
  `product_name3` varchar(255) DEFAULT NULL,
  `serial_number3` varchar(255) DEFAULT NULL,
  `product_category3` varchar(255) DEFAULT NULL,
  `product_amount3` int(11) DEFAULT NULL,
  `product_price_before_vat3` decimal(10,2) DEFAULT NULL,
  `product_price_after_vat3` decimal(10,2) DEFAULT NULL,
  `product_name4` varchar(255) DEFAULT NULL,
  `serial_number4` varchar(255) DEFAULT NULL,
  `product_category4` varchar(255) DEFAULT NULL,
  `product_amount4` int(11) DEFAULT NULL,
  `product_price_before_vat4` decimal(10,2) DEFAULT NULL,
  `product_price_after_vat4` decimal(10,2) DEFAULT NULL,
  `product_name5` varchar(255) DEFAULT NULL,
  `serial_number5` varchar(255) DEFAULT NULL,
  `product_category5` varchar(255) DEFAULT NULL,
  `product_amount5` int(11) DEFAULT NULL,
  `product_price_before_vat5` decimal(10,2) DEFAULT NULL,
  `product_price_after_vat5` decimal(10,2) DEFAULT NULL,
  `other_expenses` varchar(255) DEFAULT NULL,
  `other_expenses_category` varchar(255) DEFAULT NULL,
  `product_amount6` int(11) DEFAULT NULL,
  `product_price_before_vat6` decimal(10,2) DEFAULT NULL,
  `product_price_after_vat6` decimal(10,2) DEFAULT NULL,
  `payment_gateway` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `product_count_all` int(11) DEFAULT NULL,
  `product_price_total` decimal(10,2) DEFAULT NULL,
  `file1` varchar(255) DEFAULT NULL,
  `file2` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_buy`
--

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

--
-- 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` (
  `name` varchar(255) NOT NULL,
  `serial_number` varchar(255) NOT NULL,
  `purchase_channel` varchar(255) DEFAULT NULL,
  `buyer_name` varchar(255) DEFAULT NULL,
  `purchase_date` datetime DEFAULT NULL,
  `warranty_expiration_date` datetime DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_price` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `serial_number` (`serial_number`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COLLATE=utf8_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 ('i9 13900K','88888888','Shopee','Potter','2024-01-11 17:10:22','2024-01-18 17:10:22',1,'5000','-'),('Nas ZyXEL NSA325 มือสอง','S190Y09043156','Shopee','tanhanij','2024-01-24 03:51:34','2024-07-24 03:51:34',58,'2000','240122JG4JXKJW'),('CPU [LGA1700] i9 13900 24CORE 32THREAD (ES Version)','FLHT8X8GF9','Shopee','a_light_shining','2024-01-27 13:13:19','2025-01-27 13:13:19',59,'11545','-'),('SSD 120GB มือสอง คละยี่ห้อ','4316030014117','Shopee','supest','2024-01-29 15:03:09','2024-04-29 15:03:09',60,'330','24012716SN6QS2'),('SSD 120GB มือสอง คละยี่ห้อ','E300LE3DC0010','Shopee','supest','2024-01-29 15:07:07','2024-04-29 15:07:07',61,'330','24012716SN6QS2'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','U8ZGJNBJLS','Shopee','bon_ptw','2024-02-04 13:00:17','2025-02-04 13:00:17',62,'11823','240202ERTC4JRS'),('SSD SATA 120GB','733842991610','Shopee','bigmthailand41','2024-02-08 12:05:07','2024-05-08 12:05:07',63,'350','240206RQD7V656'),('CPU [LGA1200] i9 11900T (ES Version)','2AW2WA7JDG','Shopee','sathit1210','2024-02-10 11:49:06','2024-08-10 11:49:06',64,'4000','240130754K6A96'),('Mini PC HP Elitedesk i5 8500T RAM16GB SSD240GB','B6D0BFGEAF','Shopee','biwpotter','2024-02-14 12:09:40','2024-08-14 12:09:40',65,'5300','240211AH9XQ63N'),('Mini PC HP Elitedesk i5 8500T RAM16GB SSD240GB','W7FEAKTD87','Shopee','biwpotter','2024-02-14 12:10:19','2024-08-14 12:10:19',66,'5300','240211AH9XQ63N'),('Mini PC HP Elitedesk i5 8500T RAM16GB SSD240GB','TPAHZI8JHG','Shopee','biwpotter','2024-02-14 12:11:31','2024-08-14 12:11:31',67,'5300','240211AH9XQ63N'),('_6byihywe3','IXDCBTIZAL','Shopee','_6byihywe3','2024-02-21 12:13:54','2025-02-21 12:13:54',68,'900','2402190BWF76P3'),('แรมโน๊ตบุ๊ค KILLSRE DDR4 16GB 3200','8ADCBUGQUB','Shopee',' _6byihywe3','2024-02-21 12:15:11','2025-02-21 12:15:11',69,'900','2402190BWF76P3'),('MiniPC Intel N100 RAM8GB SSD512GB','JUODK9BG8T','Shopee','nitesbootkhot','2024-02-23 12:59:50','2024-08-23 12:59:50',70,'4800','24022030PVE81V'),('MiniPC Intel N100 RAM8GB SSD512GB','B5LJSI9ACB','Shopee','nitesbootkhot','2024-02-23 13:00:36','2024-08-23 13:00:36',71,'4800','24022030PVE81V'),('MiniPC Intel N100 RAM8GB SSD256GB','IYASXEHG6Z','Shopee','nitesbootkhot','2024-02-23 13:02:16','2024-08-23 13:02:16',72,'4800','24022030PVE81V'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','ANHZFZBBAI','Shopee','jiarxwxx','2024-02-28 23:58:13','2024-08-28 23:58:13',73,'11300','240225EBSXE212'),('SSD 120GB มือสอง คละยี่ห้อ','2037X01IW051800','Shopee','bangdeechonsiri','2024-03-03 13:13:40','2025-03-03 13:13:40',74,'360','240229STF5VWQ7'),('CPU i9 11900T ES QV1L','H3HFTE69HM','Shopee','mrnape','2024-03-05 13:01:46','2025-03-05 13:01:46',75,'4400','240215MKNRJV0Y'),('SSD 120GB มือสอง','HY12080808E02287','Shopee',' warayuttuvasan','2024-03-09 12:13:34','2024-06-09 12:13:34',76,'330','240306BCA5DGEA'),('SSD 120GB มือสอง','S20120181835','Shopee',' warayuttuvasan','2024-03-09 12:14:30','2024-06-09 12:14:30',77,'330','240306BCA5DGEA'),('SSD 120GB มือสอง','SPS27H704822','Shopee',' kurixu','2024-03-13 12:29:57','2025-03-13 12:29:57',78,'360','240309KYKNK62B'),('DDR4 16GB KILLSRE 3200','240312TQX52S6S','Shopee','noppadonkankate','2024-03-15 13:03:48','2025-03-15 13:03:48',79,'900','240312TQX52S6S'),('SSD120GB +Windows 10','240312UNT7WVGS','Shopee','pjj007','2024-03-15 13:16:24','2024-06-15 13:16:24',80,'330','240312UNT7WVGS'),('SSD 120GB','Q600201709013200','Shopee','phr011','2024-03-16 11:40:27','2024-06-16 11:40:27',81,'330','24031422944N1P'),(' kamphol_mak','BAD4MI7JLF','Shopee',' kamphol_mak','2024-03-17 11:49:26','2024-09-17 11:49:26',82,'4300','2403034BURXFX5'),('CPU [LGA1700] i9 13900T (ES VERSION)','BLGAOMKIPC','Shopee','rushsykes','2024-03-17 11:50:59','2025-03-17 11:50:59',83,'12000','2403046UNHA7DA'),('I9 10900 (ES Version)','ETADCJEJGE','Shopee','new.sam','2024-03-17 11:52:27','2025-03-17 11:52:27',84,'5000','240308HG5BF4RF'),('DDR4 SODIMM 16GB KILLSRE 3200','THGSNLCBDY','Shopee','krakenz777','2024-03-17 11:53:55','2025-03-17 11:53:55',85,'900','2403153UPGWYN5'),('Mini PC HP i7 10700T RAM16GB SSD240GB','PDFJZCAO96','Shopee',' tor_ano','2024-03-17 11:55:19','2024-09-17 11:55:19',86,'8500','2403153WNTHCX4'),('SSD 120GB USED','XSDB1812103307','Shopee',' kiadtisak123','2024-03-17 11:59:59','2024-06-17 11:59:59',87,'330','2403154PY3MXBY'),('i9 13900  (ES Version Q0L4 )','3AJCIEJQAI','Shopee','mikky69','2024-03-17 12:01:30','2024-09-17 12:01:30',88,'11300','2403154UN5CK02'),('Mini PC HP i7 10700T RAM16GB SSD240GB','8CC2213GP6','Shopee',' tor_ano','2024-03-17 12:59:31','2024-09-17 12:59:31',89,'8500','2403153WNTHCX4'),('SSD 120GB มือสอง','P5YF06548T','Shopee',' milk268268','2024-03-19 13:18:41','2024-06-19 13:18:41',90,'330','2403167JK7SEM6'),('SSD 120GB มือสอง','HS500120021709500169','Shopee','ธนกร วรรณา','2024-03-19 13:27:14','2025-03-19 13:27:14',91,'360','836308588244002'),('CPU [LGA1700] i9 13900 24CORE 32THREAD (ES Q0L4)','G90BJWIMXU','Shopee','nyxcz','2024-03-23 12:03:45','2024-09-23 12:03:45',92,'11300','2403154YG1BMNV'),('SSD 120GB มือสอง คละยี่ห้อ','ANUY172813342','Shopee','pipopbank','2024-03-23 12:06:36','2024-06-23 12:06:36',93,'330','240320HJSQBRTE'),('MiniPC Intel N100 RAM16GB SSD512GB','240321MBP3VMCB','Shopee','roflolmao','2024-03-23 13:03:45','2025-03-23 13:03:45',94,'6400','240321MBP3VMCB'),('SSD 120GB มือสอง','A1928A0003766','Shopee',' thanapol2519','2024-03-25 21:51:09','2024-06-25 21:51:09',95,'330','240323T4BUMDH4'),('SSD 120GB มือสอง','1803060600292','Shopee',' taohoodnshop','2024-03-25 21:54:33','2024-06-25 21:54:33',96,'330','240322Q7WDBPTX'),('SSD 120GB มือสอง','3K4K7ZFOZW','Shopee',' krithada2005','2024-03-27 12:13:17','2024-06-27 12:13:17',97,'330','240324VCC9J3PY'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4]','A3DNWBXA2J','Shopee','minestoreth','2024-03-27 12:15:41','2024-09-27 12:15:41',98,'11300','240325W2VE4SPW'),('SSD 120GB มือสอง คละยี่ห้อ','20050601S120404','Shopee','kaiploy188','2024-03-29 11:41:52','2024-06-29 11:41:52',99,'330','24032526PK5DFY'),('MiniPC Intel N100 RAM8GB SSD256GB','X5PQGCNGLD','Shopee',' patatapong','2024-03-29 11:43:49','2024-09-29 11:43:49',100,'4800','240325221A8595'),(' MiniPC Intel N100 RAM16GB SSD512GB','K0Z8GHZLXB','Shopee',' jeep081056','2024-03-29 11:44:46','2024-09-29 11:44:46',101,'5900','2403264MJYVVWC'),('CPU [LGA1200] i9 11900 (ES Version)','AGCBLW2EAC','Shopee','ldfldfjk_boy2','2024-03-30 09:15:47','2024-09-30 09:15:47',102,'4300','2403154UU33MQY'),('CPU [LGA1200] i9 11900 (ES Version)','DBJIQ9NKKJ','Shopee',' birdtd7','2024-03-30 09:17:26','2024-09-30 09:17:26',103,'4300','240318CFATETPU'),('CPU [LGA1200] i9 11900 (ES Version)','71EU2TAYSU','Shopee',' theiceman80','2024-03-30 09:18:22','2024-09-30 09:18:22',104,'4300','2403276PH5RK1Y'),('MiniPC Intel N100 RAM16GB SSD512GB','VHJMHP7D7C','Shopee','pottermobile','2024-04-07 11:21:50','2025-04-07 11:21:50',105,'6400','240404TRR3PUAH'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','PGFKDDQJD3','Shopee',' spamboy','2024-04-08 10:54:49','2024-10-08 10:54:49',106,'11300','2403264582Y7TW'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','XNYL9HTCDV','Shopee','napat.tham','2024-04-09 10:55:58','2025-04-09 10:55:58',107,'12000','2403264MDJA43T'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','BR6JBQ0TGA','Shopee',' hopboyz','2024-04-08 10:57:23','2024-10-08 10:57:23',108,'11300','240405UHNQWFUD'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','7CYPBLE1B1','Shopee','g_xurzk9rp','2024-04-08 11:48:47','2024-10-08 11:48:47',109,'11300','240405UMEHTCG0'),('Mini PC Ryzen 7 7735HS DDR5 32GB SSD512GB','PB5NJZ7S6H','Shopee','ohm04','2024-04-12 12:11:34','2025-04-12 12:11:34',110,'16000','240410BWYT6E4S'),('MiniPC Intel N100 RAM16GB SSD512GB (S1)','FDDCGA0DGK','Shopee','tanutfasiriporn','2024-04-27 07:59:34','2025-04-27 07:59:34',111,'6900','240425KVX3MH5C'),('Mini PC Ryzen 7 7735HS DDR5 16GB SSD512GB','BGYJE1QMEJ','Shopee','yesmanza','2024-05-02 00:45:27','2024-11-02 00:45:27',112,'14000','240428VD75R789'),('MiniPC Intel N100 RAM16GB SSD512GB (S1)','2GXAUQ2CEC','Shopee',' kolid2012','2024-05-01 10:25:42','2024-11-03 10:25:42',113,'6500','240425MYHPYBUN'),('MiniPC Intel N100 RAM16GB SSD512GB (S1)','NFGBW7DMFF','Shopee','ohm_45','2024-05-08 00:48:18','2025-05-08 00:48:18',114,'7100','240506J8HSC31H'),('CPU [LGA1200] i9 11900 (ES Version)','G8YDIDK1EF','Shopee','winey.the.cat','2024-05-08 00:51:39','2024-11-08 00:51:39',115,'4300','240506J83FJM5D'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','GRZ1F8K2HR','Shopee','nuningza','2024-05-20 20:24:28','2024-11-20 20:24:28',116,'11300','240506KH3AF7QN'),('CPU [LGA1200] i9 11900 (ES Version)','EVQ5WCHKLE','Shopee','athip8055','2024-05-20 20:27:00','2024-11-20 20:27:00',117,'4300','240517K2SXC5FN'),('CPU [LGA1200] i9 11900 (ES Version)','GDBWDLB82C','Shopee','tum.01','2024-05-27 10:44:13','2024-11-27 10:44:13',118,'4300','2405247E1HAS3D'),('CPU [LGA1200] i9 11900 (ES Version)','GBID7GL1LJ','Shopee','ieddie','2024-05-27 10:52:21','2025-05-27 10:52:21',119,'5000','24052582QP0309'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','DWE518P898','Shopee','karnetkmitnb','2024-06-08 01:18:14','2024-12-08 01:18:14',120,'6700','24060690GHURYA'),('Mini PC HP EliteDesk i7 8700T RAM16GB SSD256GB','9O4LG4NNGA','Shopee','jelefunny','2024-06-08 21:11:22','2024-12-08 21:11:22',121,'6700','240606AXNCBR92'),('CPU [LGA1200] i9 11900 (ES Version)','EA0P3MMCV6','Shopee','ukkarapong','2024-06-08 21:12:28','2024-12-08 21:12:28',122,'4300','240606AXF6YU8D'),('Mini PC HP EliteDesk i7 8700T RAM16GB SSD256GB','FSGDHBMSEC','Shopee','stns111','2024-06-12 01:01:56','2024-12-12 01:01:56',123,'6700','240610JW86Q0UK'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','FQX78HB4KJ','Shopee','x65fzld6ne','2024-06-12 07:54:12','2025-06-12 07:54:12',124,'7100','240610KRSRAFWB'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','NQCE7CBHYB','Shopee',' j.supawit.m','2024-06-12 10:09:45','2024-12-12 10:09:45',125,'6700','240610KKXJJKHY'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','M92GGTOB7S','Shopee','hewkawjung','2024-06-23 00:22:50','2024-12-23 00:22:50',126,'11300','240606A0NDHR0N'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','FG86FBEJQE','Shopee','beerpannoy','2024-06-23 00:23:46','2024-12-23 00:23:46',127,'11300','240607BDH9K9EV'),('แรมโน๊ตบุ๊ค DDR4 KILLSRE 3200','EDU5I3TVUB','Shopee','khunkheiw.shop','2024-06-27 22:20:24','2025-06-27 22:20:24',128,'950','240625024JN349'),('MiniPC Intel N100 RAM16GB SSD512GB (S1)','C0RK39J6DT','Shopee','komsan023','2024-06-28 23:52:12','2024-12-28 23:52:12',129,'6700','2406262HH1M7MR'),('CPU [LGA1200] i9 11900 (ES Version)','3FIWCQ9EHF','Shopee','yutthana.bua19','2024-07-06 08:04:27','2025-01-06 08:04:27',130,'4300','240704NPBU18WW'),('CPU [LGA1700] i9 13900T 24CORE 32THREAD (Q0PV)','ULDE7ECMFH','Shopee','pimpila99','2024-07-08 11:01:23','2025-07-08 11:01:23',131,'12000','2406154S6EQC8A'),('Mainbord [AM5] Jjinyue B650i Night Devil','VGNMBM4GF2','Shopee',' sod016296272','2024-07-18 08:51:53','2025-07-18 08:51:53',132,'5000','240716P44KV0RG'),('Mainbord [AM5] Jjinyue B650i Night Devil','SNI65024C151504','Shopee','sod016296272','2024-07-18 09:05:42','2025-07-18 09:05:42',133,'5000','240716P44KV0RG'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','QEGSHYX2JC','Shopee',' tanathorn_m','2024-07-18 23:45:14','2025-01-18 23:45:14',134,'6700','240716QN5XDX3J'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','KGC23WKOXB','Shopee','dudeedekdeez','2024-07-20 00:22:46','2025-01-20 00:22:46',135,'6900','240717T65G1WBH'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','UM5H5BLDFF','Shopee','pj_toysshop','2024-07-20 00:27:29','2025-01-20 00:27:29',136,'6900','240717TCDPTQQX'),('CPU [LGA1700] i9 13900 24CORE 32THREAD [Q0L4] (ES Version)','J0N7QZGJHD','Shopee','theteza01','2024-07-23 00:09:00','2025-07-23 00:09:00',137,'12000','240702HD5YQYS2'),('CPU [LGA1200] i9 11900 (ES Version)','QKJDJEP6C4','Shopee',' bookbig_utto','2024-07-23 00:10:07','2025-01-23 00:10:07',138,'4300','240713G3SGG784'),('MiniPC Intel N100 RAM16GB SSD512GB','6D4WZIKZJS','Shopee','sompongkia','2024-08-16 15:31:51','2025-02-16 15:31:51',139,'6400','2408136M4SGQ1A'),('CPU [LGA1200] i9 11900T (ES Version)','BEJAJF5KHQ','Shopee','mmoany1410','2024-08-19 14:42:53','2025-02-19 14:42:53',140,'4000','240808Q2312XPG'),('CPU [LGA1200] i9 11900 (ES Version)','7YVZBFB5YD','Shopee',' jarkkirt12','2024-08-30 23:48:40','2025-03-02 23:48:40',141,'4300','240828G3JN51VJ'),('MiniPC Ryzen 7 8845HS DDR5 32GB SSD M.2 NVME 1TB','6JXBKGDNWE','Shopee','kukong.mn','2024-09-12 13:00:45','2025-03-12 13:00:45',142,'22000','24082588XF2CWR'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','RSGD1Z9NRR','Shopee','maioakin','2024-09-23 20:42:41','2024-03-23 20:42:41',143,'7100','240921GMEVD3PW'),('MiniPC Ryzen 7 8845HS DDR5 32GB SSD M.2 NVME 1TB','YZA88A2405S0458EU','Shopee','wattkun','2024-10-14 14:41:45','2025-10-14 14:41:45',144,'23000','241004N14F27VQ'),('MiniPC Intel N100 RAM16GB SSD512GB','02F7J1DEET','Shopee','psnstudio','2024-10-14 15:27:09','2025-04-14 15:27:09',145,'7100','241004KHVQVWC8'),('CPU [LGA1200] i9 11900T (ES Version)','LQFBJXPIFT','Shopee','suppachok459','2024-11-10 08:55:04','2025-05-10 08:55:04',146,'4000','241108MBKF2S22'),('CPU [LGA1200] i9 11900 (ES Version)','3HCAVFGAL0','Shopee',' tiantianrally','2024-11-13 08:40:54','2025-05-13 08:40:54',147,'4400','241111V6FB8NDE'),('Mini PC Ryzen 7 7735HS DDR5 16GB SSD512GB','5HNA3GA6JF','Shopee','anontaiy','2024-11-21 15:48:42','2025-05-21 15:48:42',148,'14500','2411110BVGSCJM'),('CPU [LGA1200] i9 11900T (ES Version)','Z1TBHMCENO','Shopee','natapong231029','2024-11-28 11:49:28','2025-11-28 11:49:28',149,'4500','2411122BMYX4WK'),('CPU [LGA1200] i9 11900 (ES Version)','OXUDH9EAN8','Shopee',' arreenajaa','2024-11-28 11:50:24','2025-05-28 11:50:24',150,'4400','2411254WVP5AG5'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','NCXIU0GROH','Shopee','ysp.o','2024-12-03 10:17:14','2025-12-03 10:17:14',151,'7800','2411123GRJX5Q3'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','G898HQGBJM','Shopee','moto.master.hub','2024-12-04 09:09:37','2025-12-04 09:09:37',152,'7800','241201N5VYWVG7'),('CPU [LGA1200] i9 11900 (ES Version)','VN67CCGQV2','Shopee','soi_tiger','2024-12-26 21:44:15','2025-06-26 21:44:15',153,'4400','241224N5ECKQUY'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','OZN1323515163','Shopee','janzent99','2025-01-10 16:55:17','2026-01-10 16:55:17',154,'7800','2412318M2EPAGD'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','MJXRCKEKMB','Shopee','wye3lsskd3','2025-01-10 23:52:47','2025-07-10 23:52:47',155,'7450','250103HSHW8JMR'),('MiniPC S1 Intel N100 RAM16GB SSD512GB','D6XF2XFNEQ','Shopee','chanat1175','2025-01-13 01:05:34','2025-07-13 01:05:34',156,'7450','250105NWN86JTN'),(' เมนบอร์ด [AM5] Jjinyue B650i Night Devil','SNI65024K150349','Shopee','nesjumbo','2025-01-13 16:14:07','2025-07-13 16:14:07',157,'4700','250111845HRHAD'),('MiniPC Ryzen 7 8845HS DDR5 32GB SSD M.2 NVME 1TB','YZA88A2405S0534EU','Shopee','whosomeone','2025-01-27 15:41:49','2025-07-27 15:41:49',158,'22200','250125D2A1J4V3'),('MiniPC Intel N100 RAM16GB SSD256GB ','JGDMYAV94J','Shopee','wissnu_wattana','2025-01-28 15:44:41','2025-07-28 15:44:41',159,'6750','250125E5UM7P6T'),('MiniPC Intel N100 RAM16GB SSD512GB','0DDMLMK8FA','Shopee','nuntapongtonmai','2025-03-05 09:35:18','2025-09-05 09:35:18',160,'6750','250303JQ9RPH1P'),('CPU [LGA1200] i9 11900 (ES Version)','UYBMBJGLDE','Shopee','thanaphatt','2025-03-07 10:49:55','2025-09-07 10:49:55',161,'4300','250304N318H7M5'),('CPU [LGA1200] i9 11900 (ES Version)','BFGBQBE00D','Shopee','sansernchansangsri','2025-03-13 23:44:11','2025-09-13 23:44:11',162,'4,300','250310971PRUCP'),('CPU [LGA1200] i9 11900 (ES Version)','Z9OA004VHZ','Shopee','rachanonkhakhanmalee','2025-03-14 09:31:43','2025-09-14 09:31:43',163,'4300','250311B4SJDE9U');
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_stock`
--

DROP TABLE IF EXISTS `product_stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `SerialNumber` varchar(255) NOT NULL,
  `ProductName` varchar(255) NOT NULL,
  `PurchaseChannel` varchar(255) DEFAULT NULL,
  `PurchaseDate` datetime DEFAULT NULL,
  `ProductPrice` varchar(255) DEFAULT NULL,
  `ProductAmount` varchar(255) DEFAULT NULL,
  `ProductCategory` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_stock`
--

LOCK TABLES `product_stock` WRITE;
/*!40000 ALTER TABLE `product_stock` DISABLE KEYS */;
INSERT INTO `product_stock` VALUES (1,'WLA3LR1G5E','DDR4 8GB 1600','Facebook','2024-01-23 09:36:11','500','2','RAM','ไม่มี'),(2,'KXC7FJ4AI5','ทดสอบสินค้า','Shopee','2024-01-23 16:40:16','600','2','CPU Cooler','8'),(3,'HH8ITPKBH0','ทดสอบ3','Shopee','2024-01-23 16:49:19','100','2','RAM','ฟไก'),(4,'BIKNC92UCT','ทดสอบ4','Lazada','2024-01-23 20:52:16','700','5','Graphic Card','ทดสอบหมายเหตุ');
/*!40000 ALTER TABLE `product_stock` 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:27:26

📁 Sid Gifari File Manager