-- MySQL dump 10.13  Distrib 8.0.44, for Linux (x86_64)
--
-- Host: localhost    Database: catalogonline
-- ------------------------------------------------------
-- Server version	8.0.44-0ubuntu0.22.04.1

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

--
-- Table structure for table `log_activity`
--

DROP TABLE IF EXISTS `log_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_activity` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `USER_ID` int NOT NULL,
  `TYPE` varchar(100) NOT NULL,
  `KEY_ID` int NOT NULL,
  `MODULE` varchar(100) NOT NULL,
  `SOURCE` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_activity`
--

LOCK TABLES `log_activity` WRITE;
/*!40000 ALTER TABLE `log_activity` DISABLE KEYS */;
INSERT INTO `log_activity` VALUES (1,1,'INSERT',0,'User List','user_userid=>73///user_title=>///user_username=>Nongtest///user_fullname=>Nongtest Nongtest///user_firstname=>Nongtest///user_lastname=>Nongtest///user_position=>///user_email=>nalinee@siit.tu.ac.th///user_role=>///user_picture=>///','2025-06-12 11:04:27','2025-06-12 11:04:27'),(2,1,'INSERT',45,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>2///price=>359///product_id=>3///product_name=>Fan///quantity=>3///price=>500///','2025-07-02 16:28:12','2025-07-02 16:28:12'),(3,1,'INSERT',0,'User List','user_userid=>74///user_title=>///user_username=>Nongtest///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalinee.phumpra@gmail.com///user_phone=>0614989429///user_address=>Street///user_role=>///user_picture=>///','2025-07-07 10:43:50','2025-07-07 10:43:50'),(4,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_picture=>///','2025-07-08 15:12:47','2025-07-08 15:12:47'),(5,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_picture=>///','2025-07-18 16:09:32','2025-07-18 16:09:32'),(6,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:12:57','2025-07-18 16:12:57'),(7,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:13:16','2025-07-18 16:13:16'),(8,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:15:59','2025-07-18 16:15:59'),(9,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:17:24','2025-07-18 16:17:24'),(10,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:20:20','2025-07-18 16:20:20'),(11,1,'INSERT',0,'User List','user_userid=>75///user_title=>///user_username=>Nongtest///user_fullname=>นลินี พุ่มประจำ///user_firstname=>นลินี///user_lastname=>พุ่มประจำ///user_position=>///user_email=>nalinee@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:27:10','2025-07-18 16:27:10'),(12,1,'INSERT',0,'User List','user_userid=>76///user_title=>///user_username=>Requester///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalinee.phumpra@gmail.com///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:28:24','2025-07-18 16:28:24'),(13,1,'INSERT',0,'User List','user_userid=>77///user_title=>///user_username=>Supervisor///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalinee.phumprajam@gmail.com///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:29:57','2025-07-18 16:29:57'),(14,1,'INSERT',0,'User List','user_userid=>78///user_title=>///user_username=>Authorize///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>morefinn.nvm@gmail.com///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:30:55','2025-07-18 16:30:55'),(15,1,'INSERT',0,'User List','user_userid=>79///user_title=>///user_username=>Admin///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalineep@tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:32:41','2025-07-18 16:32:41'),(16,79,'UPDATE',79,'User List','user_title=>///user_username=>Admin///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalineep@tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>20///user_picture=>///','2025-07-18 16:34:40','2025-07-18 16:34:40'),(17,79,'UPDATE',79,'User List','user_title=>///user_username=>Admin///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalineep@tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:34:59','2025-07-18 16:34:59'),(18,76,'INSERT',46,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-07-23 11:11:26','2025-07-23 11:11:26'),(19,75,'APPROVE',46,'Order','order_code=>2025/0005///status=>pending///approved_by=>Nongtest///','2025-07-23 11:14:17','2025-07-23 11:14:17'),(20,76,'INSERT',47,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 11:41:42','2025-07-23 11:41:42'),(21,1,'REJECT',47,'Order','order_code=>2025/0006///status=>rejected///rejected_by=>admin///','2025-07-23 13:18:45','2025-07-23 13:18:45'),(22,76,'INSERT',48,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///','2025-07-23 13:19:45','2025-07-23 13:19:45'),(23,75,'REJECT',48,'Order','order_code=>2025/0007///status=>rejected///rejected_by=>Nongtest///','2025-07-23 13:20:21','2025-07-23 13:20:21'),(24,76,'INSERT',49,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 13:35:10','2025-07-23 13:35:10'),(25,1,'REJECT',49,'Order','order_code=>2025/0008///status=>rejected///rejected_by=>admin///','2025-07-23 13:49:53','2025-07-23 13:49:53'),(26,1,'INSERT',50,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 13:50:09','2025-07-23 13:50:09'),(27,1,'INSERT',51,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:06:06','2025-07-23 14:06:06'),(28,1,'INSERT',52,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:15:53','2025-07-23 14:15:53'),(29,1,'APPROVE_ITEM',82,'OrderItem','order_item_id=>82///approved_by=>admin///','2025-07-23 14:22:12','2025-07-23 14:22:12'),(30,1,'INSERT',53,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:26:55','2025-07-23 14:26:55'),(31,1,'APPROVE_ITEM',84,'OrderItem','order_item_id=>84///approved_by=>admin///','2025-07-23 14:27:05','2025-07-23 14:27:05'),(32,1,'INSERT',54,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:32:31','2025-07-23 14:32:31'),(33,1,'APPROVE_ITEM',86,'OrderItem','order_item_id=>86///approved_by=>admin///','2025-07-23 14:32:40','2025-07-23 14:32:40'),(34,76,'INSERT',55,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>3///product_name=>Fan///quantity=>1///price=>500///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///','2025-07-23 14:37:16','2025-07-23 14:37:16'),(35,75,'APPROVE_ITEM',88,'OrderItem','order_item_id=>88///approved_by=>Nongtest///','2025-07-23 15:06:15','2025-07-23 15:06:15'),(36,75,'REJECT_ITEM',90,'OrderItem','order_item_id=>90///rejected_by=>Nongtest///','2025-07-23 15:06:26','2025-07-23 15:06:26'),(37,1,'APPROVE_ITEM',88,'OrderItem','order_item_id=>88///approved_by=>admin///','2025-07-24 10:10:19','2025-07-24 10:10:19'),(38,1,'INSERT',56,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///','2025-07-24 13:09:55','2025-07-24 13:09:55'),(39,1,'INSERT',57,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 10:29:35','2025-07-30 10:29:35'),(40,76,'INSERT',58,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 10:34:49','2025-07-30 10:34:49'),(41,1,'APPROVE_ITEM',97,'OrderItem','order_item_id=>97///approved_by=>admin///','2025-07-30 10:41:34','2025-07-30 10:41:34'),(42,1,'APPROVE_ITEM',100,'OrderItem','order_item_id=>100///approved_by=>admin///','2025-07-30 10:41:41','2025-07-30 10:41:41'),(43,1,'APPROVE_ITEM',93,'OrderItem','order_item_id=>93///approved_by=>admin///','2025-07-30 10:42:15','2025-07-30 10:42:15'),(44,1,'APPROVE_ITEM',96,'OrderItem','order_item_id=>96///approved_by=>admin///','2025-07-30 10:42:18','2025-07-30 10:42:18'),(45,76,'INSERT',59,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 11:10:13','2025-07-30 11:10:13'),(46,76,'INSERT',60,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>3///product_name=>Fan///quantity=>1///price=>500///product_id=>4///product_name=>Post-It///quantity=>1///price=>39///product_id=>1///product_name=>ขวดน้ำ///quantity=>2///price=>359///','2025-07-30 11:11:13','2025-07-30 11:11:13'),(47,78,'INSERT',61,'Order','product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///product_id=>5///product_name=>Pluck///quantity=>1///price=>299///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///','2025-07-30 13:23:18','2025-07-30 13:23:18'),(48,75,'APPROVE_ITEM',111,'OrderItem','order_item_id=>111///approved_by=>Nongtest///','2025-07-30 13:25:28','2025-07-30 13:25:28'),(49,75,'APPROVE_ITEM',112,'OrderItem','order_item_id=>112///approved_by=>Nongtest///','2025-07-30 13:28:35','2025-07-30 13:28:35'),(50,1,'INSERT',62,'Order','product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-07-30 14:49:04','2025-07-30 14:49:04'),(51,1,'INSERT',63,'Order','product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///','2025-07-30 14:54:51','2025-07-30 14:54:51'),(52,1,'REJECT_ITEM',117,'OrderItem','order_item_id=>117///rejected_by=>admin///','2025-07-30 15:02:31','2025-07-30 15:02:31'),(53,1,'INSERT',64,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 15:45:49','2025-07-30 15:45:49'),(54,1,'INSERT',65,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 15:49:35','2025-07-30 15:49:35'),(55,76,'INSERT',66,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///','2025-07-30 15:59:54','2025-07-30 15:59:54'),(56,76,'INSERT',67,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>3///product_name=>Fan///quantity=>1///price=>500///','2025-07-30 16:03:15','2025-07-30 16:03:15'),(57,75,'APPROVE_ITEM',122,'OrderItem','order_item_id=>122///approved_by=>Nongtest///','2025-07-30 16:03:45','2025-07-30 16:03:45'),(58,1,'APPROVE_ITEM',119,'OrderItem','order_item_id=>119///approved_by=>admin///','2025-07-30 16:18:29','2025-07-30 16:18:29'),(59,1,'INSERT',68,'Order','product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-07-31 13:33:32','2025-07-31 13:33:32'),(60,76,'INSERT',69,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-08-04 10:59:16','2025-08-04 10:59:16'),(61,76,'INSERT',70,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///','2025-08-04 11:01:55','2025-08-04 11:01:55'),(62,76,'INSERT',71,'Order','product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>4///product_name=>Post-It///quantity=>1///price=>39///','2025-08-04 11:04:03','2025-08-04 11:04:03'),(63,76,'INSERT',72,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>5///product_name=>Pluck///quantity=>1///price=>299///','2025-08-04 11:05:21','2025-08-04 11:05:21'),(64,76,'INSERT',73,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///','2025-08-04 13:17:05','2025-08-04 13:17:05'),(65,75,'APPROVE_ITEM',140,'OrderItem','order_item_id=>140///approved_by=>Nongtest///','2025-08-04 13:18:33','2025-08-04 13:18:33'),(66,75,'APPROVE_ITEM',139,'OrderItem','order_item_id=>139///approved_by=>Nongtest///','2025-08-04 13:18:39','2025-08-04 13:18:39'),(67,77,'INSERT',74,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>5///product_name=>Pluck///quantity=>1///price=>299///product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///','2025-08-04 14:42:28','2025-08-04 14:42:28'),(68,75,'APPROVE_ITEM',142,'OrderItem','order_item_id=>142///approved_by=>Nongtest///','2025-08-04 14:43:17','2025-08-04 14:43:17'),(69,1,'INSERT',75,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-08-04 14:59:59','2025-08-04 14:59:59'),(70,1,'INSERT',76,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///','2025-08-13 10:52:21','2025-08-13 10:52:21'),(71,1,'INSERT',77,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///','2025-08-13 11:03:59','2025-08-13 11:03:59'),(72,1,'INSERT',78,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///','2025-08-13 11:07:20','2025-08-13 11:07:20'),(73,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 13:33:27','2025-08-13 13:33:27'),(74,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 13:34:34','2025-08-13 13:34:34'),(75,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 13:35:34','2025-08-13 13:35:34'),(76,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 13:40:30','2025-08-13 13:40:30'),(77,1,'APPROVE_ITEM',117,'OrderItem','order_item_id=>117///approved_by=>admin///','2025-08-13 13:41:18','2025-08-13 13:41:18'),(78,1,'APPROVE_ITEM',148,'OrderItem','order_item_id=>148///approved_by=>admin///','2025-08-13 13:49:06','2025-08-13 13:49:06'),(79,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 13:49:09','2025-08-13 13:49:09'),(80,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 13:52:57','2025-08-13 13:52:57'),(81,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 13:54:28','2025-08-13 13:54:28'),(82,1,'APPROVE_ITEM',146,'OrderItem','order_item_id=>146///approved_by=>admin///','2025-08-13 13:54:32','2025-08-13 13:54:32'),(83,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 14:07:22','2025-08-13 14:07:22'),(84,1,'REJECT_ITEM',150,'OrderItem','order_item_id=>150///rejected_by=>admin///','2025-08-13 14:07:46','2025-08-13 14:07:46'),(85,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 14:08:02','2025-08-13 14:08:02'),(86,1,'REJECT_ITEM',150,'OrderItem','order_item_id=>150///rejected_by=>admin///','2025-08-13 14:17:02','2025-08-13 14:17:02'),(87,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 14:17:23','2025-08-13 14:17:23'),(88,75,'INSERT',79,'Order','product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-08-13 14:35:47','2025-08-13 14:35:47'),(89,1,'REJECT_ITEM',150,'OrderItem','order_item_id=>150///rejected_by=>admin///','2025-08-13 14:37:58','2025-08-13 14:37:58'),(90,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 14:38:14','2025-08-13 14:38:14'),(91,75,'APPROVE_ITEM',153,'OrderItem','order_item_id=>153///approved_by=>Nongtest///','2025-08-13 14:42:10','2025-08-13 14:42:10'),(92,1,'REJECT_ITEM',150,'OrderItem','order_item_id=>150///rejected_by=>admin///','2025-08-13 14:58:43','2025-08-13 14:58:43'),(93,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 14:58:46','2025-08-13 14:58:46'),(94,1,'REJECT_ITEM',150,'OrderItem','order_item_id=>150///rejected_by=>admin///','2025-08-13 15:07:45','2025-08-13 15:07:45'),(95,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 15:07:49','2025-08-13 15:07:49'),(96,1,'REJECT_ITEM',150,'OrderItem','order_item_id=>150///rejected_by=>admin///','2025-08-13 15:13:21','2025-08-13 15:13:21'),(97,1,'APPROVE_ITEM',150,'OrderItem','order_item_id=>150///approved_by=>admin///','2025-08-13 15:13:24','2025-08-13 15:13:24'),(98,1,'APPROVE',78,'Order','order_code=>2025/0025///status=>approved///approved_by=>admin///','2025-08-13 15:28:00','2025-08-13 15:28:00'),(99,1,'APPROVE',78,'Order','order_code=>2025/0025///status=>approved///approved_by=>admin///','2025-08-14 10:23:07','2025-08-14 10:23:07'),(100,75,'INSERT',80,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///','2025-08-20 10:19:27','2025-08-20 10:19:27'),(101,75,'INSERT',81,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///','2025-08-20 14:07:19','2025-08-20 14:07:19'),(102,75,'INSERT',82,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///','2025-08-20 14:07:20','2025-08-20 14:07:20'),(103,75,'INSERT',83,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///','2025-08-20 14:07:21','2025-08-20 14:07:21'),(104,75,'INSERT',84,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///','2025-08-20 14:07:21','2025-08-20 14:07:21'),(105,75,'INSERT',85,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///','2025-08-20 14:07:22','2025-08-20 14:07:22'),(106,1,'INSERT',86,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-08-20 15:09:03','2025-08-20 15:09:03'),(107,75,'INSERT',87,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359.00///product_id=>5///product_name=>Pluck///quantity=>1///price=>299.00///product_id=>8///product_name=>Business card box///quantity=>1///price=>99.00///product_id=>11///product_name=>ทดสอบ///quantity=>2///price=>250.00///','2025-08-26 15:48:56','2025-08-26 15:48:56'),(108,75,'INSERT',88,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359.00///product_id=>5///product_name=>Pluck///quantity=>1///price=>299.00///product_id=>8///product_name=>Business card box///quantity=>1///price=>99.00///product_id=>11///product_name=>ทดสอบ///quantity=>2///price=>250.00///','2025-08-26 15:48:58','2025-08-26 15:48:58'),(109,76,'INSERT',89,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250.00///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269.00///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129.00///','2025-08-29 15:30:46','2025-08-29 15:30:46'),(110,76,'INSERT',90,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129.00///','2025-08-29 15:31:16','2025-08-29 15:31:16'),(111,76,'INSERT',91,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129.00///','2025-08-29 15:34:54','2025-08-29 15:34:54'),(112,76,'INSERT',92,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129.00///','2025-08-29 15:37:08','2025-08-29 15:37:08'),(113,1,'INSERT',93,'Order','product_id=>7///product_name=>Charging cable///quantity=>1///price=>149.00///','2025-09-01 10:34:08','2025-09-01 10:34:08'),(114,1,'INSERT',94,'Order','product_id=>15///product_name=>chicken///quantity=>1///price=>999.00///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149.00///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359.00///','2025-09-08 11:09:55','2025-09-08 11:09:55'),(115,1,'INSERT',95,'Order','product_id=>15///product_name=>chicken///quantity=>1///price=>999.00///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149.00///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359.00///','2025-09-08 11:12:53','2025-09-08 11:12:53'),(116,75,'INSERT',100,'Order','product_id=>16///product_name=>คลุกฝุ่น แมวฉ้มอ้วนขนาดใหญ่///quantity=>1///price=>5.00///product_id=>5///product_name=>Pluck///quantity=>1///price=>299.00///','2025-09-16 10:29:38','2025-09-16 10:29:38'),(117,76,'INSERT',101,'Order','product_id=>16///product_name=>คลุกฝุ่น แมวฉ้มอ้วนขนาดใหญ่///quantity=>1///price=>5.00///product_id=>20///product_name=>ชาเขียวแสนอร่อย///quantity=>1///price=>170.00///product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 10:17:13','2025-09-18 10:17:13'),(118,76,'INSERT',102,'Order','product_id=>20///product_name=>ชาเขียวแสนอร่อย///quantity=>1///price=>170.00///product_id=>22///product_name=>คลุกฝุ่นนอนยิ้ม///quantity=>1///price=>459.00///product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 10:19:49','2025-09-18 10:19:49'),(119,76,'INSERT',103,'Order','product_id=>16///product_name=>คลุกฝุ่น แมวฉ้มอ้วนขนาดใหญ่///quantity=>1///price=>5.00///product_id=>15///product_name=>chicken///quantity=>1///price=>999.00///','2025-09-18 10:27:00','2025-09-18 10:27:00'),(120,1,'INSERT',104,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///product_id=>22///product_name=>คลุกฝุ่นนอนยิ้ม///quantity=>1///price=>459.00///','2025-09-18 10:37:33','2025-09-18 10:37:33'),(121,1,'INSERT',105,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///product_id=>22///product_name=>คลุกฝุ่นนอนยิ้ม///quantity=>1///price=>459.00///','2025-09-18 10:39:37','2025-09-18 10:39:37'),(122,1,'INSERT',106,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///product_id=>22///product_name=>คลุกฝุ่นนอนยิ้ม///quantity=>1///price=>459.00///','2025-09-18 10:39:56','2025-09-18 10:39:56'),(123,1,'INSERT',107,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///product_id=>22///product_name=>คลุกฝุ่นนอนยิ้ม///quantity=>1///price=>459.00///product_id=>16///product_name=>คลุกฝุ่น แมวฉ้มอ้วนขนาดใหญ่///quantity=>1///price=>5.00///','2025-09-18 10:40:32','2025-09-18 10:40:32'),(124,1,'INSERT',108,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///product_id=>22///product_name=>คลุกฝุ่นนอนยิ้ม///quantity=>1///price=>459.00///','2025-09-18 10:44:58','2025-09-18 10:44:58'),(125,1,'INSERT',109,'Order','product_id=>15///product_name=>chicken///quantity=>1///price=>999.00///','2025-09-18 10:47:58','2025-09-18 10:47:58'),(126,1,'INSERT',110,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 10:50:11','2025-09-18 10:50:11'),(127,1,'INSERT',111,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 11:23:12','2025-09-18 11:23:12'),(128,1,'INSERT',112,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 14:01:34','2025-09-18 14:01:34'),(129,1,'INSERT',113,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 14:12:26','2025-09-18 14:12:26'),(130,1,'INSERT',114,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 14:13:40','2025-09-18 14:13:40'),(131,1,'INSERT',115,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250.00///','2025-09-18 14:13:46','2025-09-18 14:13:46'),(132,1,'INSERT',116,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 14:14:10','2025-09-18 14:14:10'),(133,1,'INSERT',117,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 14:15:48','2025-09-18 14:15:48'),(134,1,'INSERT',118,'Order','product_id=>21///product_name=>โมเดลแมวคลุกฝุ่นสุดน่ารัก///quantity=>1///price=>500.00///','2025-09-18 14:16:04','2025-09-18 14:16:04'),(135,1,'INSERT',119,'Order','product_id=>22///product_name=>คลุกฝุ่นนอนยิ้ม///quantity=>1///price=>459.00///','2025-09-18 14:17:24','2025-09-18 14:17:24'),(136,1,'APPROVE',141,'Order','order_code=>2025/0006///status=>pending///approved_by=>admin///','2025-10-21 10:32:16','2025-10-21 10:32:16'),(137,1,'APPROVE',146,'Order','order_code=>2025/0001///status=>pending///approved_by=>admin///','2025-10-21 11:21:48','2025-10-21 11:21:48'),(138,75,'APPROVE',147,'Order','order_code=>2025/0002///status=>pending///approved_by=>Nongtest///','2025-10-21 13:42:56','2025-10-21 13:42:56'),(139,75,'APPROVE',154,'Order','order_code=>2025/0009///status=>pending///approved_by=>Nongtest///','2025-11-27 14:11:16','2025-11-27 14:11:16'),(140,75,'APPROVE',155,'Order','order_code=>2025/0010///status=>pending///approved_by=>Nongtest///','2025-11-27 14:14:43','2025-11-27 14:14:43'),(141,75,'APPROVE',156,'Order','order_code=>2025/0011///status=>pending///approved_by=>Nongtest///','2025-11-27 15:18:27','2025-11-27 15:18:27'),(142,75,'APPROVE',157,'Order','order_code=>2025/0012///status=>pending///approved_by=>Nongtest///','2025-12-01 14:12:43','2025-12-01 14:12:43'),(143,1,'APPROVE',160,'Order','order_code=>2025/0001///status=>pending///approved_by=>admin///','2025-12-01 14:29:49','2025-12-01 14:29:49'),(144,1,'APPROVE',161,'Order','order_code=>2025/0001///status=>pending///approved_by=>admin///','2025-12-01 14:35:43','2025-12-01 14:35:43');
/*!40000 ALTER TABLE `log_activity` 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-12-03 10:00:05
