--
-- Host: localhost    Database: catalogonline
-- ------------------------------------------------------


--
-- Table structure for table `access_log`
--

CREATE TABLE `access_log` (
  `access_log_id` int NOT NULL AUTO_INCREMENT,
  `access_log_pk` int NOT NULL,
  `access_log_ip` varchar(255) NOT NULL,
  `access_log_activity` varchar(255) NOT NULL,
  `access_log_loginas` varchar(255) DEFAULT NULL,
  `access_log_time` datetime NOT NULL,
  PRIMARY KEY (`access_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=378 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `access_log`
--

INSERT INTO `access_log` VALUES (1,1,'49.229.126.185','Login','','2025-06-11 15:43:30'),(2,1,'49.229.126.185','Login','','2025-06-11 15:50:31'),(3,1,'49.229.126.185','Login','','2025-06-11 17:12:37'),(4,1,'49.229.127.211','Login','','2025-06-12 09:59:54'),(5,1,'49.229.127.211','Login','','2025-06-12 10:24:21'),(6,1,'49.229.127.211','Login','','2025-06-12 10:26:49'),(7,1,'49.229.127.211','Login','','2025-06-12 10:26:55'),(8,1,'49.229.127.211','LoginAsGo','73','2025-06-12 11:04:48'),(9,1,'49.229.127.211','Login','','2025-06-12 13:24:36'),(10,1,'49.229.127.211','Login','','2025-06-12 13:36:17'),(11,1,'49.229.126.5','Login','','2025-06-13 09:59:11'),(12,1,'49.229.126.0','Login','','2025-06-13 17:00:34'),(13,1,'49.229.127.235','Login','','2025-06-16 10:09:40'),(14,1,'49.229.127.235','Login','','2025-06-16 14:07:31'),(15,1,'49.229.126.57','Login','','2025-06-17 10:11:29'),(16,1,'49.229.126.57','Login','','2025-06-17 14:32:52'),(17,1,'49.229.125.12','Login','','2025-06-23 10:05:34'),(18,1,'49.229.124.182','Login','','2025-06-24 09:54:25'),(19,1,'49.229.124.182','Login','','2025-06-24 13:04:07'),(20,1,'49.229.125.234','Login','','2025-06-26 10:02:03'),(21,1,'49.229.125.234','Login','','2025-06-26 10:30:56'),(22,1,'49.229.125.122','Login','','2025-06-26 13:54:58'),(23,1,'192.168.42.124','Login','','2025-06-26 16:09:18'),(24,1,'49.229.124.139','Login','','2025-06-27 10:05:59'),(25,1,'192.168.42.27','Login','','2025-06-27 13:02:58'),(26,1,'49.229.127.193','Login','','2025-06-27 13:19:45'),(27,1,'49.229.125.231','Login','','2025-06-30 09:56:25'),(28,1,'49.229.125.239','Login','','2025-07-01 14:03:32'),(29,1,'49.229.126.88','Login','','2025-07-02 10:19:11'),(30,1,'49.229.126.88','Login','','2025-07-02 15:44:16'),(31,1,'49.229.127.20','Login','','2025-07-07 10:01:40'),(32,1,'192.168.42.226','Login','','2025-07-07 10:32:50'),(33,72,'192.168.42.226','Login','','2025-07-07 10:44:21'),(34,1,'192.168.42.226','Login','','2025-07-07 10:45:53'),(35,72,'192.168.42.226','Login','','2025-07-07 10:48:41'),(36,72,'192.168.42.226','Login','','2025-07-07 11:06:56'),(37,1,'203.131.209.86','Login','','2025-07-08 14:22:57'),(38,72,'203.131.209.86','Login','','2025-07-08 14:40:56'),(39,1,'203.131.209.86','Login','','2025-07-08 14:46:53'),(40,1,'192.168.3.131','Login','','2025-07-14 16:00:23'),(41,1,'49.229.126.37','Login','','2025-07-14 16:02:46'),(42,1,'192.168.3.57','Login','','2025-07-15 15:51:59'),(43,72,'192.168.3.57','Login','','2025-07-15 15:54:43'),(44,72,'203.131.209.86','Login','','2025-07-15 16:01:04'),(45,72,'192.168.3.57','Login','','2025-07-15 16:02:21'),(46,72,'203.131.209.86','Login','','2025-07-15 16:04:10'),(47,1,'203.131.209.86','Login','','2025-07-15 16:05:48'),(48,1,'203.131.209.86','Login','','2025-07-15 16:06:38'),(49,1,'49.229.124.184','Login','','2025-07-16 10:28:48'),(50,1,'49.229.124.184','Login','','2025-07-16 10:28:55'),(51,1,'49.229.124.184','Login','','2025-07-16 10:29:13'),(52,1,'49.229.126.40','Login','','2025-07-17 10:13:46'),(53,1,'192.168.41.45','Login','','2025-07-18 13:53:04'),(54,1,'49.229.126.102','Login','','2025-07-18 15:39:58'),(55,1,'49.229.126.102','Login','','2025-07-18 15:44:38'),(56,1,'49.229.126.102','Login','','2025-07-18 15:50:18'),(57,1,'192.168.41.45','Login','','2025-07-18 16:25:17'),(58,1,'192.168.41.45','LoginAsGo','79','2025-07-18 16:32:54'),(59,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:34:10'),(60,1,'49.229.126.102','Login','','2025-07-18 16:34:31'),(61,79,'192.168.41.45','LoginAsGo','78','2025-07-18 16:38:07'),(62,76,'192.168.41.45','Login','','2025-07-18 16:38:57'),(63,75,'192.168.41.45','Login','','2025-07-18 16:39:20'),(64,77,'192.168.41.45','Login','','2025-07-18 16:39:43'),(65,78,'192.168.41.45','Login','','2025-07-18 16:40:16'),(66,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:43:17'),(67,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:46:13'),(68,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:49:26'),(69,75,'192.168.41.45','Login','','2025-07-18 16:50:28'),(70,75,'192.168.41.45','Login','','2025-07-18 16:50:43'),(71,75,'49.229.126.102','Login','','2025-07-18 16:51:32'),(72,75,'192.168.2.246','Login','','2025-07-23 10:39:05'),(73,76,'192.168.2.246','Login','','2025-07-23 10:50:09'),(74,76,'192.168.2.246','Login','','2025-07-23 10:51:25'),(75,1,'49.229.124.62','Login','','2025-07-23 11:04:46'),(76,76,'49.229.124.62','Login','','2025-07-23 11:07:04'),(77,75,'192.168.2.246','Login','','2025-07-23 11:12:50'),(78,76,'192.168.2.246','Login','','2025-07-23 11:37:09'),(79,1,'49.229.124.62','Login','','2025-07-23 11:39:02'),(80,76,'192.168.2.246','Login','','2025-07-23 11:40:58'),(81,76,'192.168.2.246','Login','','2025-07-23 11:41:15'),(82,1,'192.168.2.246','Login','','2025-07-23 11:41:58'),(83,76,'192.168.2.246','Login','','2025-07-23 13:19:09'),(84,75,'192.168.2.246','Login','','2025-07-23 13:20:02'),(85,76,'192.168.2.246','Login','','2025-07-23 13:20:37'),(86,76,'49.229.124.62','Login','','2025-07-23 13:33:42'),(87,1,'49.229.124.62','Login','','2025-07-23 13:35:29'),(88,76,'192.168.2.246','Login','','2025-07-23 14:20:33'),(89,75,'192.168.2.246','Login','','2025-07-23 14:38:02'),(90,76,'192.168.2.246','Login','','2025-07-23 15:07:12'),(91,75,'192.168.2.246','Login','','2025-07-23 15:09:09'),(92,76,'192.168.2.246','Login','','2025-07-23 15:51:24'),(93,75,'192.168.2.246','Login','','2025-07-23 15:54:57'),(94,76,'192.168.2.246','Login','','2025-07-23 16:17:18'),(95,76,'192.168.2.174','Login','','2025-07-24 09:40:10'),(96,75,'192.168.2.174','Login','','2025-07-24 09:48:53'),(97,77,'192.168.2.174','Login','','2025-07-24 09:56:19'),(98,76,'192.168.2.174','Login','','2025-07-24 09:56:44'),(99,1,'49.229.125.252','Login','','2025-07-24 10:03:13'),(100,75,'192.168.2.174','Login','','2025-07-24 10:10:32'),(101,77,'192.168.2.174','Login','','2025-07-24 11:08:12'),(102,78,'192.168.2.174','Login','','2025-07-24 11:09:53'),(103,77,'49.229.125.252','Login','','2025-07-24 11:21:32'),(104,78,'49.229.125.252','Login','','2025-07-24 11:22:00'),(105,1,'49.229.125.252','Login','','2025-07-24 13:09:39'),(106,77,'192.168.2.174','Login','','2025-07-24 13:18:07'),(107,75,'192.168.2.174','Login','','2025-07-24 14:31:31'),(108,75,'192.168.2.174','Login','','2025-07-24 16:38:48'),(109,75,'192.168.3.111','Login','','2025-07-30 10:17:10'),(110,1,'192.168.3.111','Login','','2025-07-30 10:28:17'),(111,1,'203.131.209.86','Login','','2025-07-30 10:32:24'),(112,76,'192.168.3.111','Login','','2025-07-30 10:34:19'),(113,76,'192.168.3.111','Login','','2025-07-30 11:10:39'),(114,1,'192.168.3.111','Login','','2025-07-30 11:12:19'),(115,76,'192.168.3.111','Login','','2025-07-30 11:12:50'),(116,1,'192.168.3.111','Login','','2025-07-30 11:23:09'),(117,75,'192.168.3.111','Login','','2025-07-30 11:23:21'),(118,76,'192.168.3.111','Login','','2025-07-30 11:25:08'),(119,78,'192.168.3.111','Login','','2025-07-30 11:27:01'),(120,76,'192.168.3.111','Login','','2025-07-30 13:24:16'),(121,75,'192.168.3.111','Login','','2025-07-30 13:24:47'),(122,76,'192.168.3.111','Login','','2025-07-30 13:25:39'),(123,75,'192.168.3.111','Login','','2025-07-30 13:27:08'),(124,76,'192.168.3.111','Login','','2025-07-30 13:27:54'),(125,75,'192.168.3.111','Login','','2025-07-30 13:28:25'),(126,76,'192.168.3.111','Login','','2025-07-30 13:28:48'),(127,1,'203.131.209.86','Login','','2025-07-30 13:32:38'),(128,75,'192.168.3.111','Login','','2025-07-30 14:41:27'),(129,76,'192.168.3.111','Login','','2025-07-30 15:03:15'),(130,76,'192.168.3.111','Login','','2025-07-30 15:03:56'),(131,76,'192.168.3.111','Login','','2025-07-30 15:53:17'),(132,75,'192.168.3.111','Login','','2025-07-30 16:03:31'),(133,76,'192.168.3.111','Login','','2025-07-30 16:03:58'),(134,77,'192.168.3.111','Login','','2025-07-30 16:05:28'),(135,78,'192.168.3.111','Login','','2025-07-30 16:10:04'),(136,76,'192.168.3.111','Login','','2025-07-30 16:11:04'),(137,75,'192.168.3.111','Login','','2025-07-30 16:11:34'),(138,76,'192.168.3.111','Login','','2025-07-30 16:27:07'),(139,1,'203.131.209.86','Login','','2025-07-30 16:53:11'),(140,76,'192.168.3.111','Login','','2025-07-31 09:59:45'),(141,1,'49.229.124.147','Login','','2025-07-31 13:05:21'),(142,76,'192.168.3.111','Login','','2025-07-31 13:47:51'),(143,75,'192.168.3.111','Login','','2025-07-31 13:48:29'),(144,76,'192.168.3.111','Login','','2025-07-31 14:06:51'),(145,75,'192.168.3.111','Login','','2025-07-31 14:08:43'),(146,1,'49.229.124.231','Login','','2025-08-01 11:06:50'),(147,75,'49.229.125.14','Login','','2025-08-04 10:11:36'),(148,75,'49.229.125.14','Login','','2025-08-04 10:13:23'),(149,76,'49.229.125.14','Login','','2025-08-04 10:14:13'),(150,76,'49.229.125.14','Login','','2025-08-04 10:40:06'),(151,1,'172.16.1.238','Login','','2025-08-04 10:49:33'),(152,75,'49.229.125.14','Login','','2025-08-04 10:57:41'),(153,76,'49.229.125.14','Login','','2025-08-04 10:58:36'),(154,78,'49.229.125.14','Login','','2025-08-04 11:02:23'),(155,77,'49.229.125.14','Login','','2025-08-04 11:02:42'),(156,76,'49.229.125.14','Login','','2025-08-04 11:03:02'),(157,78,'49.229.125.14','Login','','2025-08-04 11:04:21'),(158,76,'49.229.125.14','Login','','2025-08-04 11:05:01'),(159,76,'49.229.125.14','Login','','2025-08-04 11:06:35'),(160,77,'49.229.125.14','Login','','2025-08-04 11:27:20'),(161,75,'49.229.125.14','Login','','2025-08-04 11:27:37'),(162,76,'49.229.125.14','Login','','2025-08-04 11:33:15'),(163,75,'49.229.125.14','Login','','2025-08-04 13:18:23'),(164,76,'49.229.125.14','Login','','2025-08-04 13:21:14'),(165,77,'49.229.125.14','Login','','2025-08-04 14:41:55'),(166,77,'49.229.125.14','Login','','2025-08-04 14:42:42'),(167,75,'49.229.125.14','Login','','2025-08-04 14:42:53'),(168,77,'49.229.125.14','Login','','2025-08-04 14:43:33'),(169,76,'49.229.125.14','Login','','2025-08-04 14:45:11'),(170,77,'49.229.125.14','Login','','2025-08-04 14:47:18'),(171,77,'49.229.125.14','Login','','2025-08-04 14:51:37'),(172,1,'172.16.1.238','Login','','2025-08-04 14:51:57'),(173,76,'49.229.125.14','Login','','2025-08-04 14:52:03'),(174,75,'49.229.125.14','Login','','2025-08-04 14:53:50'),(175,1,'49.229.125.40','Login','','2025-08-04 17:07:53'),(176,1,'49.229.125.95','Login','','2025-08-05 10:05:09'),(177,75,'49.229.125.99','Login','','2025-08-05 13:40:14'),(178,1,'203.131.209.86','Login','','2025-08-05 15:17:17'),(179,1,'203.131.209.86','Login','','2025-08-05 15:57:51'),(180,75,'172.16.2.137','Login','','2025-08-07 13:37:36'),(181,1,'203.131.209.86','Login','','2025-08-07 13:44:14'),(182,75,'172.16.2.137','Login','','2025-08-13 09:54:57'),(183,1,'49.229.124.115','Login','','2025-08-13 10:03:57'),(184,1,'49.229.124.115','Login','','2025-08-13 13:32:49'),(185,75,'172.16.2.137','Login','','2025-08-13 13:54:09'),(186,75,'172.16.2.137','Login','','2025-08-13 14:41:43'),(187,1,'49.229.124.146','Login','','2025-08-14 09:56:32'),(188,1,'203.131.209.86','LoginAsGo','77','2025-08-14 11:02:14'),(189,1,'203.131.209.86','LoginAsGo','78','2025-08-14 11:02:47'),(190,75,'172.16.2.137','Login','','2025-08-14 13:08:40'),(191,1,'203.131.209.86','Login','','2025-08-14 13:34:30'),(192,1,'49.228.100.39','Login','','2025-08-14 20:44:18'),(193,75,'172.16.2.137','Login','','2025-08-15 09:32:57'),(194,75,'172.16.2.137','Login','','2025-08-15 15:58:56'),(195,1,'49.229.127.189','Login','','2025-08-18 10:22:57'),(196,75,'172.16.2.137','Login','','2025-08-20 09:52:55'),(197,1,'49.229.127.223','Login','','2025-08-20 09:58:16'),(198,1,'49.229.127.223','LoginAsGo','76','2025-08-20 11:26:40'),(199,1,'49.229.127.223','LoginAsGo','77','2025-08-20 11:28:32'),(200,1,'49.230.44.217','Login','','2025-08-20 11:42:06'),(201,78,'172.16.2.137','Login','','2025-08-20 13:17:01'),(202,77,'172.16.2.137','Login','','2025-08-20 13:17:22'),(203,76,'172.16.2.137','Login','','2025-08-20 13:17:36'),(204,78,'172.16.2.137','Login','','2025-08-20 13:17:45'),(205,1,'49.229.127.223','LoginAsGo','77','2025-08-20 13:21:37'),(206,1,'49.229.127.223','LoginAsGo','77','2025-08-20 13:24:16'),(207,75,'172.16.2.137','Login','','2025-08-20 13:25:40'),(208,75,'172.16.2.137','Login','','2025-08-20 13:38:01'),(209,1,'49.229.127.223','Login','','2025-08-20 13:41:45'),(210,1,'49.229.127.223','Login','','2025-08-20 13:42:13'),(211,76,'172.16.2.137','Login','','2025-08-20 13:52:24'),(212,75,'172.16.2.137','Login','','2025-08-20 13:54:33'),(213,1,'49.230.44.37','Login','','2025-08-20 14:26:51'),(214,75,'172.16.2.137','Login','','2025-08-21 09:49:28'),(215,1,'49.229.125.128','Login','','2025-08-21 10:20:22'),(216,75,'172.16.2.137','Login','','2025-08-21 10:34:21'),(217,75,'172.16.2.137','Login','','2025-08-21 10:34:44'),(218,75,'172.16.2.137','Login','','2025-08-21 10:36:24'),(219,76,'172.16.2.137','Login','','2025-08-21 10:41:25'),(220,78,'172.16.2.137','Login','','2025-08-21 10:42:20'),(221,78,'172.16.2.137','Login','','2025-08-21 10:59:51'),(222,77,'172.16.2.137','Login','','2025-08-21 11:04:32'),(223,1,'49.229.125.128','LoginAsGo','78','2025-08-21 11:05:44'),(224,1,'49.229.125.128','LoginAsGo','78','2025-08-21 11:07:19'),(225,76,'172.16.2.137','Login','','2025-08-21 16:52:06'),(226,1,'49.229.125.128','Login','','2025-08-21 16:53:30'),(227,1,'49.229.125.128','LoginAsGo','76','2025-08-21 16:53:38'),(228,75,'172.16.2.137','Login','','2025-08-25 10:01:12'),(229,1,'49.229.127.26','Login','','2025-08-25 10:26:29'),(230,75,'172.16.2.137','Login','','2025-08-25 10:41:35'),(231,78,'172.16.2.137','Login','','2025-08-25 14:09:30'),(232,77,'172.16.2.137','Login','','2025-08-25 14:09:54'),(233,75,'172.16.2.137','Login','','2025-08-25 14:10:14'),(234,76,'172.16.2.137','Login','','2025-08-25 14:10:36'),(235,78,'172.16.2.137','Login','','2025-08-25 14:10:53'),(236,76,'172.16.2.137','Login','','2025-08-25 14:12:31'),(237,75,'172.16.2.137','Login','','2025-08-25 14:51:53'),(238,75,'172.16.2.137','Login','','2025-08-26 09:14:38'),(239,1,'49.229.125.52','Login','','2025-08-26 10:05:34'),(240,1,'172.16.2.77','Login','','2025-08-26 14:53:08'),(241,75,'172.16.2.137','Login','','2025-08-26 14:55:56'),(242,75,'49.229.126.65','Login','','2025-08-26 15:49:29'),(243,76,'49.229.126.65','Login','','2025-08-26 15:49:37'),(244,1,'203.131.209.86','Login','','2025-08-27 10:10:23'),(245,76,'172.16.1.244','Login','','2025-08-29 10:38:06'),(246,76,'172.16.1.244','Login','','2025-08-29 13:22:38'),(247,1,'203.131.209.86','Login','','2025-08-29 15:05:22'),(248,1,'203.131.209.86','Login','','2025-08-29 15:30:12'),(249,1,'203.131.209.86','LoginAsGo','76','2025-08-29 15:30:21'),(250,76,'172.16.1.244','Login','','2025-08-29 15:46:11'),(251,75,'172.16.1.244','Login','','2025-08-29 15:46:35'),(252,1,'203.131.209.86','LoginAsGo','76','2025-08-29 15:47:45'),(253,1,'203.131.209.86','Login','','2025-09-01 10:15:42'),(254,75,'49.229.168.94','Login','','2025-09-06 13:47:09'),(255,1,'49.229.126.19','Login','','2025-09-08 10:12:54'),(256,75,'172.16.2.120','Login','','2025-09-08 10:37:38'),(257,75,'172.16.2.120','Login','','2025-09-09 15:46:47'),(258,76,'172.16.2.120','Login','','2025-09-09 15:53:07'),(259,76,'172.16.2.120','Login','','2025-09-09 16:19:28'),(260,75,'172.16.2.120','Login','','2025-09-09 16:19:37'),(261,75,'172.16.2.120','Login','','2025-09-09 16:55:15'),(262,1,'49.229.127.194','Login','','2025-09-10 10:17:25'),(263,75,'172.16.2.120','Login','','2025-09-10 13:52:29'),(264,1,'49.229.127.194','Login','','2025-09-10 15:26:50'),(265,75,'172.16.2.120','Login','','2025-09-11 09:58:09'),(266,76,'172.16.2.120','Login','','2025-09-11 13:58:55'),(267,1,'49.229.124.187','Login','','2025-09-11 14:01:17'),(268,76,'172.16.2.120','Login','','2025-09-11 14:02:10'),(269,1,'49.229.124.187','LoginAsGo','76','2025-09-11 14:02:58'),(270,76,'172.16.2.120','Login','','2025-09-11 14:05:33'),(271,75,'172.16.2.120','Login','','2025-09-11 14:05:48'),(272,76,'172.16.2.120','Login','','2025-09-11 14:07:55'),(273,75,'172.16.2.120','Login','','2025-09-11 14:08:44'),(274,78,'172.16.2.120','Login','','2025-09-11 14:09:35'),(275,1,'49.229.124.187','LoginAsGo','76','2025-09-11 14:10:00'),(276,75,'192.168.2.221','Login','','2025-09-11 14:14:01'),(277,75,'192.168.2.221','Login','','2025-09-11 14:14:51'),(278,76,'172.16.2.120','Login','','2025-09-11 14:16:48'),(279,1,'49.229.124.187','Login','','2025-09-11 15:35:26'),(280,1,'49.229.124.187','Login','','2025-09-11 15:35:44'),(281,1,'49.229.124.187','Login','','2025-09-11 15:45:57'),(282,76,'172.16.2.120','Login','','2025-09-11 16:16:19'),(283,1,'49.229.126.116','Login','','2025-09-12 10:11:30'),(284,1,'49.229.126.116','Login','','2025-09-12 15:07:00'),(285,1,'49.229.124.142','Login','','2025-09-15 10:06:17'),(286,76,'172.16.2.120','Login','','2025-09-15 10:18:41'),(287,75,'172.16.2.120','Login','','2025-09-15 10:46:58'),(288,75,'192.168.222.157','Login','','2025-09-16 10:19:04'),(289,75,'192.168.222.157','Login','','2025-09-16 13:24:39'),(290,1,'192.168.3.180','Login','','2025-09-18 10:07:59'),(291,75,'192.168.220.109','Login','','2025-09-18 10:08:54'),(292,75,'192.168.220.109','Login','','2025-09-18 10:09:05'),(293,76,'192.168.220.109','Login','','2025-09-18 10:16:45'),(294,75,'192.168.220.109','Login','','2025-09-18 10:17:32'),(295,1,'192.168.3.180','LoginAsGo','76','2025-09-18 10:19:26'),(296,75,'192.168.3.180','Login','','2025-09-18 10:30:41'),(297,75,'192.168.3.180','Login','','2025-09-18 10:30:59'),(298,75,'192.168.3.180','Login','','2025-09-18 10:31:20'),(299,1,'192.168.3.180','Login','','2025-09-18 10:31:35'),(300,1,'192.168.3.180','LoginAsGo','76','2025-09-18 10:31:49'),(301,1,'192.168.3.180','LoginAsGo','77','2025-09-18 10:35:19'),(302,75,'192.168.3.180','Login','','2025-09-18 10:36:41'),(303,75,'192.168.3.180','Login','','2025-09-18 10:36:55'),(304,1,'192.168.3.180','Login','','2025-09-18 10:37:15'),(305,77,'192.168.3.180','Login','','2025-09-18 10:41:53'),(306,1,'192.168.3.180','Login','','2025-09-18 10:43:04'),(307,1,'192.168.3.180','LoginAsGo','77','2025-09-18 10:54:04'),(308,1,'192.168.3.180','LoginAsGo','76','2025-09-18 10:55:30'),(309,1,'192.168.3.180','LoginAsGo','76','2025-09-18 10:57:36'),(310,75,'192.168.220.109','Login','','2025-09-18 12:58:05'),(311,76,'192.168.220.109','Login','','2025-09-18 13:54:54'),(312,76,'192.168.220.109','Login','','2025-09-18 13:55:53'),(313,75,'192.168.3.180','Login','','2025-09-18 13:57:18'),(314,75,'192.168.3.180','LoginAsGo','76','2025-09-18 13:57:24'),(315,75,'192.168.3.180','Login','','2025-09-18 13:58:11'),(316,75,'192.168.3.180','LoginAsGo','76','2025-09-18 13:58:21'),(317,75,'192.168.3.180','LoginAsGo','78','2025-09-18 13:59:07'),(318,75,'192.168.3.180','LoginAsGo','79','2025-09-18 13:59:14'),(319,75,'192.168.220.109','Login','','2025-09-18 14:00:01'),(320,75,'192.168.220.109','LoginAsGo','76','2025-09-18 14:00:11'),(321,1,'192.168.3.180','Login','','2025-09-18 14:01:27'),(322,1,'192.168.3.180','LoginAsGo','76','2025-09-18 14:16:55'),(323,76,'192.168.220.109','Login','','2025-09-18 15:34:41'),(324,1,'192.168.3.180','LoginAsGo','79','2025-09-18 15:36:28'),(325,75,'192.168.220.109','Login','','2025-09-18 15:43:56'),(326,76,'192.168.220.109','Login','','2025-09-18 15:44:34'),(327,75,'192.168.220.109','Login','','2025-09-18 15:45:38'),(328,75,'172.16.1.210','Login','','2025-09-19 10:14:48'),(329,77,'172.16.1.210','Login','','2025-09-19 10:43:07'),(330,78,'172.16.1.210','Login','','2025-09-19 10:43:35'),(331,1,'192.168.3.180','Login','','2025-09-22 09:58:17'),(332,1,'192.168.3.180','Login','','2025-09-23 10:00:13'),(333,1,'192.168.3.180','Login','','2025-09-23 15:14:37'),(334,78,'192.168.220.109','Login','','2025-09-26 09:44:14'),(335,75,'192.168.220.109','Login','','2025-09-26 09:44:25'),(336,1,'192.168.3.180','Login','','2025-09-29 13:22:50'),(337,75,'172.16.3.41','Login','','2025-10-06 08:58:06'),(338,76,'172.16.3.41','Login','','2025-10-06 09:06:06'),(339,75,'172.16.3.41','Login','','2025-10-06 09:07:47'),(340,1,'192.168.3.180','Login','','2025-10-06 09:56:15'),(341,78,'172.16.3.41','Login','','2025-10-06 10:03:28'),(342,75,'172.16.3.41','Login','','2025-10-06 10:03:59'),(343,75,'172.16.1.49','Login','','2025-10-06 14:22:43'),(344,75,'172.16.1.49','Login','','2025-10-07 10:17:54'),(345,75,'172.16.1.49','Login','','2025-10-07 16:41:45'),(346,1,'192.168.2.49','Login','','2025-10-08 14:30:46'),(347,1,'192.168.2.49','Login','','2025-10-09 16:16:50'),(348,75,'172.16.2.35','Login','','2025-10-09 16:35:45'),(349,1,'192.168.2.49','Login','','2025-10-10 10:25:57'),(350,75,'192.168.215.81','Login','','2025-10-20 10:36:05'),(351,1,'192.168.2.141','Login','','2025-10-20 11:09:58'),(352,78,'192.168.215.81','Login','','2025-10-20 11:22:19'),(353,77,'192.168.215.81','Login','','2025-10-20 11:23:40'),(354,1,'192.168.215.81','Login','','2025-10-20 11:24:04'),(355,75,'192.168.215.81','Login','','2025-10-20 11:24:40'),(356,76,'192.168.215.81','Login','','2025-10-20 14:29:51'),(357,75,'192.168.215.81','Login','','2025-10-20 14:34:19'),(358,76,'192.168.215.81','Login','','2025-10-20 14:44:07'),(359,75,'192.168.215.81','Login','','2025-10-20 15:30:16'),(360,76,'192.168.215.81','Login','','2025-10-20 15:53:56'),(361,76,'192.168.215.81','Login','','2025-10-20 16:03:47'),(362,75,'192.168.215.81','Login','','2025-10-20 16:20:20'),(363,76,'192.168.215.81','Login','','2025-10-20 16:21:47'),(364,75,'192.168.215.81','Login','','2025-10-20 16:24:17'),(365,75,'192.168.2.141','Login','','2025-10-20 16:24:24'),(366,1,'192.168.2.141','Login','','2025-10-20 16:26:19'),(367,1,'192.168.2.141','Login','','2025-10-21 09:58:30'),(368,75,'192.168.215.81','Login','','2025-10-21 13:20:58'),(369,76,'192.168.215.81','Login','','2025-10-21 13:24:20'),(370,76,'192.168.215.81','Login','','2025-10-21 13:37:38'),(371,75,'192.168.215.81','Login','','2025-10-21 13:42:38'),(372,76,'192.168.215.81','Login','','2025-10-21 13:50:20'),(373,1,'192.168.2.141','Login','','2025-10-21 16:45:23'),(374,75,'192.168.215.81','Login','','2025-10-22 10:07:38'),(375,76,'192.168.215.81','Login','','2025-10-22 11:18:08'),(376,75,'192.168.215.81','Login','','2025-10-22 11:29:56'),(377,1,'49.229.124.223','Login','','2025-10-24 10:55:32');

--
-- Table structure for table `backup_log`
--

CREATE TABLE `backup_log` (
  `backup_log_id` int NOT NULL AUTO_INCREMENT,
  `backup_log_date_active` varchar(255) NOT NULL,
  `backup_log_date_inactive` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `backup_log_type` varchar(50) NOT NULL,
  `backup_log_folder` varchar(50) NOT NULL,
  `backup_log_status` varchar(50) NOT NULL,
  PRIMARY KEY (`backup_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `backup_log`
--

INSERT INTO `backup_log` VALUES (10,'2025-07-18 14:17:05','2025-07-24 17:00:07','database','1','Inactive'),(11,'2025-07-18 17:00:05','2025-07-25 17:00:08','database','2','Inactive'),(12,'2025-07-19 17:00:06','2025-07-26 17:00:10','database','3','Inactive'),(13,'2025-07-20 17:00:09','2025-07-27 17:00:09','database','4','Inactive'),(14,'2025-07-21 17:00:06','2025-07-28 17:00:11','database','5','Inactive'),(15,'2025-07-22 17:00:07','2025-07-29 17:00:10','database','6','Inactive'),(16,'2025-07-23 17:00:06','2025-07-30 17:00:09','database','7','Inactive'),(17,'2025-07-24 17:00:07','2025-07-31 17:00:12','database','1','Inactive'),(18,'2025-07-25 17:00:08','2025-08-01 17:00:11','database','2','Inactive'),(19,'2025-07-26 17:00:10','2025-08-02 17:00:11','database','3','Inactive'),(20,'2025-07-27 17:00:09','2025-08-03 17:00:10','database','4','Inactive'),(21,'2025-07-28 17:00:11','2025-08-04 17:00:08','database','5','Inactive'),(22,'2025-07-29 17:00:10','2025-08-05 17:00:12','database','6','Inactive'),(23,'2025-07-30 17:00:09','2025-08-06 17:00:12','database','7','Inactive'),(24,'2025-07-31 17:00:12','2025-08-07 17:00:08','database','1','Inactive'),(25,'2025-08-01 17:00:11','2025-08-08 17:00:10','database','2','Inactive'),(26,'2025-08-02 17:00:11','2025-08-09 17:00:11','database','3','Inactive'),(27,'2025-08-03 17:00:10','2025-08-10 17:00:11','database','4','Inactive'),(28,'2025-08-04 17:00:08','2025-08-11 17:00:11','database','5','Inactive'),(29,'2025-08-05 17:00:12','2025-08-12 17:00:31','database','6','Inactive'),(30,'2025-08-06 17:00:12','2025-08-13 17:00:11','database','7','Inactive'),(31,'2025-08-07 17:00:08','2025-08-14 17:00:07','database','1','Inactive'),(32,'2025-08-08 17:00:10','2025-08-15 17:00:09','database','2','Inactive'),(33,'2025-08-09 17:00:11','2025-08-16 17:00:09','database','3','Inactive'),(34,'2025-08-10 17:00:11','2025-08-17 17:00:09','database','4','Inactive'),(35,'2025-08-11 17:00:11','2025-08-18 17:00:09','database','5','Inactive'),(36,'2025-08-12 17:00:31','2025-08-19 17:00:10','database','6','Inactive'),(37,'2025-08-13 17:00:11','2025-08-20 17:00:08','database','7','Inactive'),(38,'2025-08-14 17:00:07','2025-08-21 17:00:09','database','1','Inactive'),(39,'2025-08-15 17:00:09','2025-08-22 17:00:09','database','2','Inactive'),(40,'2025-08-16 17:00:09','2025-08-23 17:00:08','database','3','Inactive'),(41,'2025-08-17 17:00:10','2025-08-24 17:00:10','database','4','Inactive'),(42,'2025-08-18 17:00:09','2025-08-25 17:00:09','database','5','Inactive'),(43,'2025-08-19 17:00:10','2025-08-26 17:00:08','database','6','Inactive'),(44,'2025-08-20 17:00:08','2025-08-27 17:00:08','database','7','Inactive'),(45,'2025-08-21 17:00:09','2025-08-28 17:00:09','database','1','Inactive'),(46,'2025-08-22 17:00:09','2025-08-29 17:00:07','database','2','Inactive'),(47,'2025-08-23 17:00:08','2025-08-30 17:00:10','database','3','Inactive'),(48,'2025-08-24 17:00:10','2025-08-31 17:00:09','database','4','Inactive'),(49,'2025-08-25 17:00:09','2025-09-01 17:00:08','database','5','Inactive'),(50,'2025-08-26 17:00:08','2025-09-02 17:00:07','database','6','Inactive'),(51,'2025-08-27 17:00:08','2025-09-03 17:00:09','database','7','Inactive'),(52,'2025-08-28 17:00:09','2025-09-04 17:00:11','database','1','Inactive'),(53,'2025-08-29 17:00:07','2025-09-05 17:00:09','database','2','Inactive'),(54,'2025-08-30 17:00:10','2025-09-06 17:00:07','database','3','Inactive'),(55,'2025-08-31 17:00:09','2025-09-07 17:00:08','database','4','Inactive'),(56,'2025-09-01 17:00:08','2025-09-08 17:00:07','database','5','Inactive'),(57,'2025-09-02 17:00:07','2025-09-09 17:00:08','database','6','Inactive'),(58,'2025-09-03 17:00:09','2025-09-10 17:00:08','database','7','Inactive'),(59,'2025-09-04 17:00:11','2025-09-11 17:00:09','database','1','Inactive'),(60,'2025-09-05 17:00:09','2025-09-12 17:00:08','database','2','Inactive'),(61,'2025-09-06 17:00:07','2025-09-13 17:00:08','database','3','Inactive'),(62,'2025-09-07 17:00:08','2025-09-14 17:00:07','database','4','Inactive'),(63,'2025-09-08 17:00:07','2025-09-15 17:00:07','database','5','Inactive'),(64,'2025-09-09 17:00:08','2025-09-16 17:00:09','database','6','Inactive'),(65,'2025-09-10 17:00:08','2025-09-17 17:00:09','database','7','Inactive'),(66,'2025-09-11 17:00:09','2025-09-18 17:00:08','database','1','Inactive'),(67,'2025-09-12 17:00:08','2025-09-19 17:00:10','database','2','Inactive'),(68,'2025-09-13 17:00:08','2025-09-20 17:00:09','database','3','Inactive'),(69,'2025-09-14 17:00:07','2025-09-21 17:00:10','database','4','Inactive'),(70,'2025-09-15 17:00:07','2025-09-22 17:00:10','database','5','Inactive'),(71,'2025-09-16 17:00:09','2025-09-23 17:00:09','database','6','Inactive'),(72,'2025-09-17 17:00:09','2025-09-24 17:00:09','database','7','Inactive'),(73,'2025-09-18 17:00:08','2025-09-25 17:00:09','database','1','Inactive'),(74,'2025-09-19 17:00:10','2025-09-26 17:00:10','database','2','Inactive'),(75,'2025-09-20 17:00:10','2025-09-27 17:00:09','database','3','Inactive'),(76,'2025-09-21 17:00:10','2025-09-28 17:00:11','database','4','Inactive'),(77,'2025-09-22 17:00:10','2025-09-29 17:00:07','database','5','Inactive'),(78,'2025-09-23 17:00:10','2025-09-30 17:00:09','database','6','Inactive'),(79,'2025-09-24 17:00:09','2025-10-01 17:00:08','database','7','Inactive'),(80,'2025-09-25 17:00:09','2025-10-02 17:00:09','database','1','Inactive'),(81,'2025-09-26 17:00:10','2025-10-03 17:00:10','database','2','Inactive'),(82,'2025-09-27 17:00:09','2025-10-04 17:00:08','database','3','Inactive'),(83,'2025-09-28 17:00:11','2025-10-05 17:00:09','database','4','Inactive'),(84,'2025-09-29 17:00:07','2025-10-06 17:00:11','database','5','Inactive'),(85,'2025-09-30 17:00:09','2025-10-07 17:00:09','database','6','Inactive'),(86,'2025-10-01 17:00:08','2025-10-08 17:00:08','database','7','Inactive'),(87,'2025-10-02 17:00:09','2025-10-09 17:00:07','database','1','Inactive'),(88,'2025-10-03 17:00:10','2025-10-10 17:00:11','database','2','Inactive'),(89,'2025-10-04 17:00:08','2025-10-11 17:00:10','database','3','Inactive'),(90,'2025-10-05 17:00:09','2025-10-12 17:00:10','database','4','Inactive'),(91,'2025-10-06 17:00:11','2025-10-13 17:00:11','database','5','Inactive'),(92,'2025-10-07 17:00:09','2025-10-14 17:00:10','database','6','Inactive'),(93,'2025-10-08 17:00:08','2025-10-15 17:00:07','database','7','Inactive'),(94,'2025-10-09 17:00:07','2025-10-16 17:00:10','database','1','Inactive'),(95,'2025-10-10 17:00:11','2025-10-17 17:00:09','database','2','Inactive'),(96,'2025-10-11 17:00:10','2025-10-18 17:00:08','database','3','Inactive'),(97,'2025-10-12 17:00:10','2025-10-19 17:00:09','database','4','Inactive'),(98,'2025-10-13 17:00:11','2025-10-20 17:00:06','database','5','Inactive'),(99,'2025-10-14 17:00:10','2025-10-21 17:00:07','database','6','Inactive'),(100,'2025-10-15 17:00:07','2025-10-22 17:00:09','database','7','Inactive'),(101,'2025-10-16 17:00:10','2025-10-23 17:00:08','database','1','Inactive'),(102,'2025-10-17 17:00:09','2025-10-24 17:00:07','database','2','Inactive'),(103,'2025-10-18 17:00:08','2025-10-25 17:00:08','database','3','Inactive'),(104,'2025-10-19 17:00:09','2025-10-26 17:00:09','database','4','Inactive'),(105,'2025-10-20 17:00:06','2025-10-27 17:00:09','database','5','Inactive'),(106,'2025-10-21 17:00:07','2025-10-28 17:00:08','database','6','Inactive'),(107,'2025-10-22 17:00:09','2025-10-29 17:00:09','database','7','Inactive'),(108,'2025-10-23 17:00:08','','database','1','Active'),(109,'2025-10-24 17:00:07','','database','2','Active'),(110,'2025-10-25 17:00:08','','database','3','Active'),(111,'2025-10-26 17:00:09','','database','4','Active'),(112,'2025-10-27 17:00:09','','database','5','Active'),(113,'2025-10-28 17:00:08','','database','6','Active'),(114,'2025-10-29 17:00:09','','database','7','Active');

--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `qty` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cart_items`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `categories_id` int NOT NULL AUTO_INCREMENT,
  `categories_name` varchar(255) DEFAULT NULL,
  `categories_description` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `categories`
--


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

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=139 DEFAULT CHARSET=utf8mb3;

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

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');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--


--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` VALUES (7,'App\\User',1),(7,'App\\User',2);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\User',1),(21,'App\\User',1),(1,'App\\User',73),(2,'App\\User',74),(21,'App\\User',75),(2,'App\\User',76),(3,'App\\User',77),(20,'App\\User',78),(1,'App\\User',79);

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

CREATE TABLE `order_items` (
  `order_item_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_price` varchar(255) DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `item_status` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`order_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=323 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `order_items` VALUES (313,146,24,'เป็ด','12.00',1,NULL,'confirmed','2025-10-21 11:39:14','2025-10-21 11:39:14'),(314,146,25,'หมอนปลอบใจแฟนหงส์  YNWA = You’ll Never Win Again\"','102.00',1,NULL,'confirmed','2025-10-21 11:39:14','2025-10-21 11:39:14'),(320,147,9,'Craftsman key chain','129.00',1,NULL,'confirmed','2025-10-21 13:50:32','2025-10-21 13:50:32'),(321,147,10,'Passport Case','269.00',1,NULL,'confirmed','2025-10-21 13:50:32','2025-10-21 13:50:32'),(322,147,23,'ลูกบอล','250.00',1,NULL,'confirmed','2025-10-21 13:50:32','2025-10-21 13:50:32');

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

CREATE TABLE `orders` (
  `order_id` int NOT NULL AUTO_INCREMENT,
  `order_user_id` int DEFAULT NULL,
  `order_code` varchar(20) DEFAULT NULL,
  `order_customer_name` varchar(255) DEFAULT NULL,
  `order_division` varchar(255) DEFAULT NULL,
  `order_email` varchar(255) DEFAULT NULL,
  `order_purpose` text,
  `order_request_date` datetime DEFAULT NULL,
  `order_use_date` datetime DEFAULT NULL,
  `order_receive_date` datetime DEFAULT NULL,
  `order_approved_date` datetime DEFAULT NULL,
  `order_address` text,
  `order_total_price` varchar(255) DEFAULT NULL,
  `order_status_for_admin` varchar(255) DEFAULT NULL,
  `order_status_for_supervisor` varchar(255) DEFAULT NULL,
  `order_status_for_authorize` varchar(255) DEFAULT NULL,
  `order_status` varchar(255) DEFAULT NULL,
  `order_delivered_date` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `orders` VALUES (146,1,'2025/0001','admin','1','consulting@siit.tu.ac.th','แพ้ผี','2025-10-21 00:00:00','2025-10-25 00:00:00','2025-10-23 00:00:00',NULL,'Anfield','114','approved','pending','pending','submitted',NULL,'2025-10-21 11:21:34','2025-10-21 11:44:37'),(147,76,'2025/0002','Requester',NULL,'nalinee.phumpra@gmail.com',NULL,'2025-10-21 13:24:41',NULL,NULL,'2025-10-21 13:42:56',NULL,'648','confirmed','pending','pending','confirmed',NULL,'2025-10-21 13:24:41','2025-10-21 13:50:32');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (7,'Nullper','web','2024-11-06 16:00:30','2024-11-06 16:00:30');

--
-- Table structure for table `product_type`
--

CREATE TABLE `product_type` (
  `product_type_id` int NOT NULL AUTO_INCREMENT,
  `product_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`product_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `product_type`
--

INSERT INTO `product_type` VALUES (1,'Accessories','2025-06-13 10:45:44','2025-06-13 10:45:44'),(2,'Books & Stationery','2025-06-13 10:51:15','2025-06-13 10:51:15'),(3,'Collectibles','2025-06-13 10:52:50','2025-06-13 10:52:50'),(4,'Electronics','2025-06-13 10:53:09','2025-06-13 10:53:09'),(5,'Gift Sets','2025-06-13 10:53:19','2025-06-13 10:53:19'),(6,'Limited Edition Items','2025-06-13 10:53:44','2025-06-13 10:53:44'),(7,'Premium Souvenirs','2025-06-17 11:02:33','2025-06-17 11:02:33'),(8,'Office Supplies','2025-07-07 10:02:34','2025-07-07 10:02:34'),(9,'Portable Accessories','2025-07-07 10:03:01','2025-07-07 10:03:01'),(10,'Travel Accessories','2025-07-07 10:13:29','2025-07-07 10:13:29'),(11,'Electronics Accessories','2025-07-07 10:14:15','2025-07-07 10:14:15');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int NOT NULL AUTO_INCREMENT,
  `product_code` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `product_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `product_price` decimal(10,2) DEFAULT NULL,
  `product_weight` decimal(8,2) DEFAULT NULL,
  `product_quantity` int DEFAULT NULL,
  `product_type` varchar(255) DEFAULT NULL,
  `product_stock` int DEFAULT NULL,
  `product_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `product_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'0001','ขวดน้ำ','ขวดน้ำ 3 สี',359.00,1.30,77,'7',NULL,'1','1749723562_ขวดน้ำ.jpg','2025-06-12 15:57:47','2025-10-20 11:24:02'),(3,'2','Fan',NULL,500.00,2.00,80,'4',NULL,'1','1749723657_พัดลม.jpg','2025-06-12 16:48:45','2025-10-20 13:36:09'),(4,'3','Post-It',NULL,39.00,150.00,20,'2',NULL,'1','1752483885_โพสอิท.jpg','2025-07-14 16:04:45','2025-10-20 14:39:56'),(5,'4','Pluck',NULL,299.00,300.00,9,'11',NULL,'1','1752483937_ไอปลั๊ก.jpg','2025-07-14 16:05:37','2025-10-20 14:40:20'),(6,'6','Fabric bag',NULL,199.00,70.00,60,'10',NULL,'1','1752483993_กระเป๋าผ้า.jpg','2025-07-14 16:06:33','2025-10-20 14:40:31'),(7,'7','Charging cable',NULL,149.00,195.00,25,'11',NULL,'1','1752484041_กล่องเคเบิ้ล.jpg','2025-07-14 16:07:21','2025-10-20 14:40:49'),(8,'8','Business card box',NULL,99.00,220.00,16,'8',NULL,'1','1752484092_กล่องใส่นามบัตร.jpg','2025-07-14 16:08:12','2025-10-20 14:41:46'),(9,'9','Craftsman key chain',NULL,129.00,215.00,17,'8',NULL,'1','1752484324_พวงกุญแจช่าง.jpg','2025-07-14 16:12:04','2025-10-20 14:42:00'),(10,'10','Passport Case',NULL,269.00,85.00,20,'7',NULL,'1','1752484357_พาส2.jpg','2025-07-14 16:12:37','2025-10-20 14:42:09'),(11,'0002','ทดสอบ','สีดำ ไม่ใช่ สีแดง',250.00,177.00,73,'7',NULL,'1','1753951247_user-icon-person-icon-client-symbol-login-head-sign-icon-design-vector-Photoroom (1).png','2025-07-31 15:40:47','2025-10-20 14:42:22'),(15,'8999','chicken',NULL,999.00,1020.00,23,'5',NULL,'1','1757303643_ไก่-Leghorn.jpg','2025-09-08 10:52:47','2025-10-20 14:42:46'),(16,'0003','คลุกฝุ่น แมวฉ้มอ้วนขนาดใหญ่','ดื้อ ซน ขี้อ้อน ติดคน ชอบวิ่งตัดหน้า',5.00,3500.00,19,'7',NULL,'1','1757409671_S__28450821.jpg','2025-09-09 16:21:11','2025-10-20 14:42:58'),(20,'0001','ชาเขียวแสนอร่อย','ชาเขียวสตาร์บัค หวานปกติ เพิ่มวิปครีม',170.00,440.00,29,'10',NULL,'1','1758007591_S__28737545_0.jpg','2025-09-16 14:26:31','2025-10-20 14:43:18'),(21,'0002','โมเดลแมวคลุกฝุ่นสุดน่ารัก','โมเดลขนาดเท่าแมวจริง น่ารักจริงๆ',500.00,2100.00,22,'1',NULL,'1','1758007675_S__28737547_0.jpg','2025-09-16 14:27:55','2025-10-20 14:43:31'),(22,'0001','คลุกฝุ่นนอนยิ้ม','นอนยิ้มอ้วน',459.00,3500.00,30,'5',NULL,'1','1758007725_S__28737548_0.jpg','2025-09-16 14:28:45','2025-10-20 14:43:40'),(23,'033','ลูกบอล','อุปกรณ์กีฬา',250.00,312.00,3,'10',NULL,'1','1760933193_Screenshot 2025-10-20 110542.png','2025-10-20 11:06:33','2025-10-20 14:43:52'),(24,'12','เป็ด','หวานๆ',12.00,12.00,119,'5',NULL,'1','1760948466_เป็ด.jpg','2025-10-20 15:21:06','2025-10-20 15:21:06'),(25,'1111222','หมอนปลอบใจแฟนหงส์  YNWA = You’ll Never Win Again\"','หมอนที่กักโปอยากมีไว้ซับน้ำตาหลังได้ ถ้วยเสาทองคำ',102.00,1.20,10,'7',NULL,'1','1760949466_ChatGPT Image 20 ต.ค. 2568 15_26_56.png','2025-10-20 15:37:33','2025-10-20 15:37:46');

--
-- Table structure for table `return_orders`
--

CREATE TABLE `return_orders` (
  `return_orders_id` int NOT NULL AUTO_INCREMENT,
  `return_orders_item_id` int DEFAULT NULL,
  `return_orders_quantity` int DEFAULT NULL,
  `return_orders_reason` text,
  `return_orders_completed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`return_orders_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `return_orders`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` int unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (7,1),(7,2),(7,3),(7,20),(7,21);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','web','2019-11-27 03:25:57','2019-11-27 03:25:57'),(2,'Requester','web','2023-06-08 00:00:00','2023-06-08 00:00:00'),(3,'Supervisor','web','2025-02-27 15:26:10','2025-02-27 15:26:10'),(20,'Authorize','web','2025-06-11 16:43:51','2025-06-11 16:43:51'),(21,'AdminConsult','web','2025-07-08 14:47:12','2025-07-08 14:47:12');

--
-- Table structure for table `school_division`
--

CREATE TABLE `school_division` (
  `school_division_id` int NOT NULL AUTO_INCREMENT,
  `school_division_name_en` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `school_division_name_th` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `school_division_shortname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `school_division_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`school_division_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `school_division`
--

INSERT INTO `school_division` VALUES (1,'SIIT Consulting Center','ศูนย์ให้คำปรึกษา','Consulting','Center','2022-05-10 11:07:55','2022-05-24 11:27:32'),(2,'Accounting Division','ฝ่ายบัญชี','ACC','Division','2022-05-10 11:20:20','2022-05-24 11:38:03'),(3,'Admission and Public Relations Division','ฝ่ายรับเข้าศึกษาและประชาสัมพันธ์','AD&PR','Division','2022-05-10 11:20:28','2024-08-29 11:34:37'),(4,'Academic Services and Registration Division','ฝ่ายบริการวิชาการและทะเบียน','AS&R','Division','2022-05-10 11:20:38','2022-06-07 10:54:46'),(5,'School of Bio-Chemical Engineering and Technology','ภาควิชาวิศวกรรมและเทคโนโลยีเคมีชีวภาพ','BCET','School','2022-05-10 11:20:52','2022-05-24 11:15:30'),(6,'Building and Ground Division','ฝ่ายอาคารและสถานที่','BG','Division','2022-05-10 11:21:01','2022-05-24 11:31:41'),(7,'Central Coordinating Division','ฝ่ายประสานงานกลาง','CCO','Division','2022-05-10 11:21:10','2022-05-24 11:37:26'),(8,'School of Civil Engineering and Technology','ภาควิชาวิศวกรรมและเทคโนโลยีโยธา','CET','School','2022-05-10 11:21:17','2022-05-24 11:13:01'),(9,'School of Integrated Science and Innovation','ภาควิชาวิทยาศาสตร์บูรณาการและนวัตกรรม','ISI','School','2022-05-10 11:24:28','2023-02-15 09:11:25'),(10,'Computer and Audiovisual Center','ศูนย์คอมพิวเตอร์และโสตทัศนศึกษา','COM&AV','Division','2022-05-10 11:24:36','2022-05-24 11:30:52'),(11,'Construction and Maintenance Technology Research Center','ศูนย์วิจัยเทคโนโลยีการก่อสร้างและบำรุงรักษา','CONTEC','Center','2022-05-10 11:24:45','2022-05-24 11:28:33'),(12,'Functional Advanced Materials Engineering','ศูนย์วิจัยวิศวกรรมวัสดุสมบัติพิเศษขั้นสูง','FAME','School','2022-05-10 11:24:56','2022-05-24 11:39:51'),(13,'Finance and Budget Division','ฝ่ายการเงินและงบประมาณ','FIN','Division','2022-05-10 11:25:02','2022-05-24 11:38:56'),(14,'International Affairs and Corporate Relations Division','ฝ่ายวิเทศและองค์กรสัมพันธ์','IA&CR','Division','2022-05-10 11:25:10','2022-05-24 11:32:38'),(15,'School of Information, Computer, and Communication Technology','ภาควิชาเทคโนโลยีสารสนเทศ คอมพิวเตอร์ และการสื่อสาร','ICT','School','2022-05-10 11:25:17','2022-05-24 11:18:39'),(16,'Library and Information Services Center','ห้องสมุดและศูนย์บริการข้อมูล','LIB&ISC','Division','2022-05-10 11:25:23','2022-05-24 11:29:46'),(17,'School of Manufacturing Systems and Mechanical Engineering','ภาควิชาวิศวกรรมเครื่องกลและระบบการผลิต','MSME','School','2022-05-10 11:25:32','2022-05-24 11:17:11'),(18,'School of Management Technology','ภาควิชาเทคโนโลยีการจัดการ','MT','School','2022-05-10 11:25:45','2022-05-24 11:26:41'),(19,'Office of the Director','สำนักผู้อำนวยการ','OD','Division','2022-05-10 11:25:53','2022-05-24 11:30:08'),(20,'Property Management Division','ฝ่ายจัดการทรัพย์สิน','PM','Division','2022-05-10 11:26:00','2022-05-24 11:31:19'),(21,'Research and Academic Quality Assurance Division','ฝ่ายวิจัยและประกันคุณภาพการศึกษา','R&QA','Division','2022-05-10 11:26:10','2022-05-24 11:29:29'),(22,'Student Affairs and Alumni Relations Division','ฝ่ายกิจการนักศึกษาและศิษย์เก่าสัมพันธ์','SA&AR','Division','2022-05-10 11:26:54','2022-05-24 11:38:39'),(23,'SIIT Academy','SIIT Academy','SIIT Academy','Center','2022-05-10 11:27:04','2022-05-24 11:28:07'),(24,'Supplies and Procurement Division','ฝ่ายพัสดุและจัดซื้อ','SP','Division','2022-05-10 11:27:15','2022-05-24 11:36:57'),(25,'Ground and Properties (Rangsit)','-','G&P-RS','Division','2024-08-29 00:00:00','2024-08-29 00:00:00'),(26,'Ground and Properties (Bangkadi)','-','G&P-BKD','Division','2024-08-29 00:00:00','2024-08-29 00:00:00'),(27,'Department of Common and Graduate Studies','-','CGS','School','2024-08-29 00:00:00','2024-08-29 00:00:00'),(28,'Academic Services Division (Bangkadi)','-','AS-BKD','Division','2024-08-29 00:00:00','2024-08-29 00:00:00'),(29,'Academic Services Division (Rangsit)','-','AS-RS','Division','2024-08-29 00:00:00','2024-08-29 00:00:00');

--
-- Table structure for table `sendemail`
--

CREATE TABLE `sendemail` (
  `sendemail_id` int NOT NULL AUTO_INCREMENT,
  `sendemail_userid` int NOT NULL,
  `sendemail_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `sendemail_type` varchar(255) NOT NULL,
  `sendemail_key` varchar(255) NOT NULL,
  `sendemail_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sendemail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sendemail`
--

INSERT INTO `sendemail` VALUES (32,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-09 16:33:59','2025-10-09 16:33:59'),(33,76,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 14:52:16','2025-10-20 14:52:16'),(34,75,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 15:48:18','2025-10-20 15:48:18'),(35,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 15:51:28','2025-10-20 15:51:28'),(36,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:06:53','2025-10-20 16:06:53'),(37,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:19:23','2025-10-20 16:19:23'),(38,76,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:22:08','2025-10-20 16:22:08'),(39,76,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:23:45','2025-10-20 16:23:45'),(40,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:27:44','2025-10-20 16:27:44'),(41,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:37:22','2025-10-20 16:37:22'),(42,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:39:32','2025-10-20 16:39:32'),(43,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:44:23','2025-10-20 16:44:23'),(44,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:44:46','2025-10-20 16:44:46'),(45,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-20 16:47:26','2025-10-20 16:47:26'),(46,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-21 10:20:47','2025-10-21 10:20:47'),(47,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-21 10:32:33','2025-10-21 10:32:33'),(48,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-21 10:32:39','2025-10-21 10:32:39'),(49,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-21 10:44:53','2025-10-21 10:44:53'),(50,1,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-21 11:21:37','2025-10-21 11:21:37'),(51,76,'[\"nalinee@siit.tu.ac.th\",\"kriettipoom@siit.tu.ac.th\"]','admin_premium_request','[75,79]','sent','2025-10-21 13:24:44','2025-10-21 13:24:44');

--
-- Table structure for table `souvenir_logs`
--

CREATE TABLE `souvenir_logs` (
  `souvenir_log_id` int NOT NULL AUTO_INCREMENT,
  `souvenir_id` int DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `action_type` varchar(255) DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `note` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`souvenir_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `souvenir_logs`
--

INSERT INTO `souvenir_logs` VALUES (18,23,'ลูกบอล','add',5,75,'Auto log from product edit','2025-10-20 11:06:33','2025-10-20 11:06:33'),(19,24,'เป็ด','add',121,1,'Auto log from product edit','2025-10-20 15:21:06','2025-10-20 15:21:06'),(20,25,'หมอนปลอบใจแฟนหงส์  YNWA = You’ll Never Win Again\"','add',12,75,'Auto log from product edit','2025-10-20 15:37:33','2025-10-20 15:37:33');

--
-- Table structure for table `souvenir_request_items`
--

CREATE TABLE `souvenir_request_items` (
  `souvenir_request_items_id` int NOT NULL AUTO_INCREMENT,
  `request_id` int DEFAULT NULL,
  `souvenir_id` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`souvenir_request_items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `souvenir_request_items`
--


--
-- Table structure for table `souvenir_requests`
--

CREATE TABLE `souvenir_requests` (
  `request_id` int NOT NULL AUTO_INCREMENT,
  `request_code` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `request_date` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `note` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `souvenir_requests`
--



