Da

✏️ Editing: demo4_kijweb.sql

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

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

--
-- Current Database: `demo4_kijweb`
--

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

USE `demo4_kijweb`;

--
-- Table structure for table `career`
--

DROP TABLE IF EXISTS `career`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `career` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job` varchar(255) NOT NULL,
  `job_th` varchar(255) NOT NULL,
  `detail` longtext NOT NULL,
  `detail_th` longtext NOT NULL,
  `location` varchar(255) NOT NULL,
  `office` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `img` varchar(255) NOT NULL,
  `create_date` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `visible` varchar(255) NOT NULL,
  `usability` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `career`
--

LOCK TABLES `career` WRITE;
/*!40000 ALTER TABLE `career` DISABLE KEYS */;
INSERT INTO `career` VALUES (4,'Customer Service Representetive','Customer Service Representetive','The position is responsible for handling the customer’s order, supporting the salesforces, dealing with the incoming calls/walk-in customers and coordinating with the relating divisions, such as Supply Chain, Manufacturing, Finance & Accounting, so that the whole processes from orders to delivery are effectively and orderly implemented resulting in the overall customer satisfaction. In addition, coordinate with salesforce to keep track with the customer payment performance.','The position is responsible for handling the customer’s order, supporting the salesforces, dealing with the incoming calls/walk-in customers and coordinating with the relating divisions, such as Supply Chain, Manufacturing, Finance & Accounting, so that the whole processes from orders to delivery are effectively and orderly implemented resulting in the overall customer satisfaction. In addition, coordinate with salesforce to keep track with the customer payment performance.','KIJ Marketing Co.,Ltd. - 801 Soi Lasalle 24, Bangna Tai, Bangna ,Bangkok 10260','0 2749 8967','06 1256 6523','Korawit@kij.co.th','20231008130842.jpg','2023-10-08 13:08:41','','show','active'),(5,'1','1','1','1','1','1','1','1','20231008132710.jpg','0000-00-00 00:00:00','','hidden','active'),(6,'3','3','3','3','3','3','3','3','','2023-10-08 13:56:45','','show','delete'),(7,'3','3','3','3','3','3','3','3','20231012122425.jpg','2023-10-08 13:58:10','','show','active'),(8,'4','4','4','4','4','4','4','4','','2023-10-12 13:19:58','admin','show','delete'),(9,'5','5','5','5','5','5','5','5','20231012133406.jpg','2023-10-12 13:34:06','admin','show','active'),(10,'666','6','6','6','66','6','6','6','20231014143418.jpg','2023-10-14 14:34:17','admin','show','delete');
/*!40000 ALTER TABLE `career` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kbrite`
--

DROP TABLE IF EXISTS `kbrite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kbrite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_th` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `content_th` longtext DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `visible` varchar(255) NOT NULL,
  `usability` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kbrite`
--

LOCK TABLES `kbrite` WRITE;
/*!40000 ALTER TABLE `kbrite` DISABLE KEYS */;
INSERT INTO `kbrite` VALUES (52,'1','1','1','1','20231012130900.jpg','2023-10-10 19:42:11','','show','delete'),(53,'2','2','2','2','20231012133210.jpg','2023-10-12 13:32:10','admin','show','active'),(54,'3','1','1','1','20231014135253.jpg','2023-10-14 13:52:52','admin','show','delete'),(55,'4','4','4','4','20231014135328.jpg','2023-10-14 13:53:27','admin','show','delete');
/*!40000 ALTER TABLE `kbrite` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kingkong`
--

DROP TABLE IF EXISTS `kingkong`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kingkong` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_th` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `content_th` longtext DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `visible` varchar(255) NOT NULL,
  `usability` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kingkong`
--

LOCK TABLES `kingkong` WRITE;
/*!40000 ALTER TABLE `kingkong` DISABLE KEYS */;
INSERT INTO `kingkong` VALUES (52,'1','1','1','1','20231012130912.jpg','2023-10-10 19:44:21','','show','delete'),(53,'2','2','2','2','20231012133222.jpg','2023-10-12 13:32:21','admin','show','delete'),(54,'4','3','3','3','20231014135837.jpg','2023-10-14 13:58:36','admin','show','delete'),(55,'Bathroom Scrubber (Rectangular)','Bathroom Scrubber (Rectangular)','','','20231027183858.png','2023-10-27 18:16:13','admin','show','active'),(56,'Toilet Scrubber','Toilet Scrubber','','','20231027183752.png','2023-10-27 18:30:42','admin','show','active'),(57,'General Purpose Scouring Pad','แผ่นใยขัดอเนกประสงค์','','','20231027192253.png','2023-10-27 19:18:34','admin','show','active'),(58,'General Purpose Scouring Pad With Sponge','แผ่นใยขัดอเนกประสงค์ พร้อมฟองน้ำ','','','20231027192308.png','2023-10-27 19:20:56','admin','show','active'),(59,'Sponge Net','ฟองน้ำหุ้มตาข่าย','','','20231027193019.png','2023-10-27 19:24:31','admin','show','active'),(60,'Stainless Ball','ฝอยสแตนเลส','','','20231027193006.png','2023-10-27 19:30:05','admin','show','active'),(61,'Scouring Pad With Sponge','แผ่นใยขัดพร้อมฟองน้ำ','','','20231027194505.png','2023-10-27 19:45:05','admin','show','active');
/*!40000 ALTER TABLE `kingkong` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mrsmart`
--

DROP TABLE IF EXISTS `mrsmart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mrsmart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_th` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `content_th` longtext DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `visible` varchar(255) NOT NULL,
  `usability` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mrsmart`
--

LOCK TABLES `mrsmart` WRITE;
/*!40000 ALTER TABLE `mrsmart` DISABLE KEYS */;
INSERT INTO `mrsmart` VALUES (52,'1','1','1','1','20231010194200.jpg','2023-10-10 19:41:50','','show','delete'),(53,'2','2','2','2',NULL,'2023-10-12 12:46:57','','show','delete'),(54,'3','3','3','3','20231012125631.jpg','2023-10-12 12:47:40','','show','delete'),(55,'4','4','4','4','20231012130227.jpg','2023-10-12 12:49:57','','show','delete'),(56,'6','5','5','5','20231012130802.jpg','2023-10-12 12:53:43','','show','delete'),(57,'7','7','7','7','20231012133157.jpg','2023-10-12 13:31:57','admin','show','delete'),(58,'2','2','2','2',NULL,'2023-10-14 13:50:29','admin','show','delete'),(59,'Hygiene plus Sponge Net','Hygiene plus Sponge Net','','','20231027091812.png','2023-10-27 08:58:05','admin','show','active'),(60,'Hygiene plus Cleaning Pad Light Duty','Hygiene plus Cleaning Pad Light Duty','','','20231027112136.png','2023-10-27 09:20:00','admin','show','active'),(61,'Hygiene plus Cleaning Pad Heavy Duty','Hygiene plus Cleaning Pad Heavy Duty','','','20231027111826.png','2023-10-27 09:24:06','admin','show','active'),(62,'Bathroom Floor Scrubber','Bathroom Floor Scrubber','','','20231027170549.png','2023-10-27 09:26:04','admin','show','active'),(63,'Toilet Bowl Scourer','Toilet Bowl Scourer','','','20231027093334.png','2023-10-27 09:33:33','admin','show','active'),(64,'Hygiene Plus Bamboo Cloth','Hygiene Plus Bamboo Cloth','','','20231027093803.png','2023-10-27 09:37:06','admin','show','active'),(65,'Premium Quality Sponge Cloth','Premium Quality Sponge Cloth','','','20231027113215.png','2023-10-27 09:42:59','admin','show','active'),(66,'Jumbo Genaral Pupose Scouring Pad','แผ่นใยขัดอเนกประสงค์ รุ่น จัมโบ้','','','20231027113905.png','2023-10-27 09:48:52','admin','show','active'),(67,'General Purpose Scouring Pad','แผ่นใยขัดอเนกประสงค์','','','20231027154715.png','2023-10-27 09:50:44','admin','show','active'),(68,'General Purpose Scouring Pad With Sponge','แผ่นใยขัดอเนกประสงค์พร้อมฟองน้ำ','','','20231027114441.png','2023-10-27 09:52:30','admin','show','active'),(69,'Stainless Steel Wool','ฝอยสแตนเลส','','','20231027155607.png','2023-10-27 09:57:41','admin','show','active'),(70,'Scouring Pad Ideal for Cleaning Glass','แผ่นใยขัดทำความสะอาดแก้ว','','','20231027155216.png','2023-10-27 10:12:26','admin','show','active'),(71,'Scouring Pad 2 In 1','แผ่นใยขัด 2 อิน 1','','','20231027160246.png','2023-10-27 10:17:05','admin','show','active'),(72,'Pan brush','แปรงใยขัดกระทะ','','','20231027102307.png','2023-10-27 10:23:07','admin','show','active'),(73,'No-Scratch Scouring Pad With Sponge','แผ่นใยขัดพร้องฟองน้ำ ชนิดไม่ทิ้งรอบขีดข่วน','','','20231027153021.png','2023-10-27 15:30:21','admin','show','active');
/*!40000 ALTER TABLE `mrsmart` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_th` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `content_th` longtext DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `visible` varchar(255) NOT NULL,
  `usability` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `news`
--

LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (1,'หัวเรื่อง','','เรื่องราว','','20231006161946.jpg','2023-10-05 18:00:00','admin','show','delete'),(48,'2','2','2','2','20231006154118.jpg','2023-10-06 15:41:17','','show','delete'),(49,'5','5','5','5','20231006161721.jpg','2023-10-06 15:43:33','','hidden','delete'),(50,'1','1','1','1','20231010174949.jpg','2023-10-07 12:30:19','','hidden','delete'),(51,'444','','','','20231012130952.jpg','2023-10-11 17:04:37','','show','delete'),(52,'6','6','6','6','20231012133353.jpg','2023-10-12 13:33:52','admin','show','delete');
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `promotion`
--

DROP TABLE IF EXISTS `promotion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `promotion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_th` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `content_th` longtext DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `visible` varchar(255) NOT NULL,
  `usability` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `promotion`
--

LOCK TABLES `promotion` WRITE;
/*!40000 ALTER TABLE `promotion` DISABLE KEYS */;
INSERT INTO `promotion` VALUES (51,'5','2','3','4','20231012130928.jpg','2023-10-10 18:39:41','','show','delete'),(52,'2','2','2','2','20231012133244.jpg','2023-10-12 13:32:44','admin','show','delete'),(53,'3','3','3','3','20231012133258.jpg','2023-10-12 13:32:57','admin','show','delete'),(54,'4','4','4','4','20231012133313.jpg','2023-10-12 13:33:13','admin','show','delete'),(55,'5','5','5','5','20231018185823.jpg','2023-10-18 18:58:23','admin','show','delete'),(56,'6','6','6','6','20231018185835.jpg','2023-10-18 18:58:35','admin','show','delete'),(57,'ขัดสะอาดไว','ขัดสะอาดไว','','','20231107115904.jpg','2023-11-07 11:59:03','admin','show','active'),(58,'ปาร์ตี้หนักก็ไม่หวั่น','ปาร์ตี้หนักก็ไม่หวั่น','','','20231107120014.jpg','2023-11-07 12:00:14','admin','show','active'),(59,'ครัวสะอาด ทำอาหารก็ Happy','ครัวสะอาด ทำอาหารก็ Happy','','','20231107120120.jpg','2023-11-07 12:01:19','admin','show','active'),(60,'สะอาด มั่นใจ ไม่เปลืองแรงขัด','สะอาด มั่นใจ ไม่เปลืองแรงขัด','','','20231107120156.jpg','2023-11-07 12:01:56','admin','show','active'),(61,'ลดสุดคุ้ม','ลดสุดคุ้ม','','','20231107120221.jpg','2023-11-07 12:02:20','admin','show','active'),(62,'โปรโมชั่นพิเศษ','โปรโมชั่นพิเศษ','','','20231107120249.jpg','2023-11-07 12:02:49','admin','show','active'),(63,'โถสุขภัณฑ์สะอาดสร้างได้ง่ายๆ','โถสุขภัณฑ์สะอาดสร้างได้ง่ายๆ','','','20231107120331.jpg','2023-11-07 12:03:31','admin','show','active');
/*!40000 ALTER TABLE `promotion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tricks`
--

DROP TABLE IF EXISTS `tricks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tricks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_th` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `content_th` longtext DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `user` varchar(255) NOT NULL,
  `visible` varchar(255) NOT NULL,
  `usability` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tricks`
--

LOCK TABLES `tricks` WRITE;
/*!40000 ALTER TABLE `tricks` DISABLE KEYS */;
INSERT INTO `tricks` VALUES (51,'1','2','3','4','20231012130939.jpg','2023-10-10 18:55:42','','show','delete'),(52,'2','1','1','1','20231012133334.jpg','2023-10-12 13:33:34','admin','show','delete'),(53,'4444','3','3','3','20231014141322.jpg','2023-10-14 14:13:21','admin','show','delete'),(54,'ทำงานที่บ้าน เผาพลาญกี่แคล','ทำงานที่บ้าน เผาพลาญกี่แคล','','','20231107120449.jpg','2023-11-07 12:04:48','admin','show','active'),(55,'3 วิธีล้างคราบน้ำมันบนภาชนะ','3 วิธีล้างคราบน้ำมันบนภาชนะ','','','20231107120518.jpg','2023-11-07 12:05:18','admin','show','active'),(56,'รู้หรือไม่ โคมไฟก็มีคราบไขมัน','รู้หรือไม่ โคมไฟก็มีคราบไขมัน','','','20231107120549.jpg','2023-11-07 12:05:48','admin','show','active'),(57,'กำจัดขนสัตว์เลี้ยง ที่ติดบนโซฟา','กำจัดขนสัตว์เลี้ยง ที่ติดบนโซฟา','','','20231107120850.jpg','2023-11-07 12:08:50','admin','show','active'),(58,'เคล็ดลับของการใช้น้ำร้อนล้างจาน','เคล็ดลับของการใช้น้ำร้อนล้างจาน','','','20231107121008.jpg','2023-11-07 12:10:08','admin','show','active'),(59,'การเลือกใช้ถังขยะ','การเลือกใช้ถังขยะ','','','20231107121217.jpg','2023-11-07 12:12:17','admin','show','active'),(60,'อ่างล้างจานมีกลิ่นเหม็น','อ่างล้างจานมีกลิ่นเหม็น','','','20231107121243.jpg','2023-11-07 12:12:43','admin','show','active');
/*!40000 ALTER TABLE `tricks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `user` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `privilage` varchar(255) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'admin','iskijmar@kij.co.th','admin','$2y$10$EN7kkmVybFSgdsGGgzlLbO5DcSsWmU.EBvisO3WSFXYjueF.RC2IO','admin','2023-10-04 13:56:00','2023-10-16 15:08:16','active'),(2,'2','3','1','$2y$10$IJywtRNGRt1Tm8AoM.w5R.iuCYHjRG1bAPFHBi0dfA0XNNdr//1dS','admin','2023-10-05 03:59:37',NULL,'active'),(3,'name','email','user','$2y$10$8nzHNS8.qzw3gwHtPGUeXOj2eU0Fb5BRULMMnyh39DCsRZKFpPZUC','admin','2023-10-05 04:04:24',NULL,'active'),(31,'Naronglit Permpoon','iskijmar@kij.co.th','2','$2y$10$y9tAtpq8ODNGxtsp5Lcx9uzWNGVDpb60GHKOv3z8cI3l.tR826Xae','admin','2023-10-08 14:08:55','2023-10-16 15:41:33','active');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_reset`
--

DROP TABLE IF EXISTS `user_reset`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_reset` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_refer` int(11) NOT NULL,
  `user` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `ticket` varchar(255) NOT NULL,
  `create_date` datetime NOT NULL,
  `status` varchar(255) NOT NULL,
  `reset_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_reset`
--

LOCK TABLES `user_reset` WRITE;
/*!40000 ALTER TABLE `user_reset` DISABLE KEYS */;
INSERT INTO `user_reset` VALUES (1,31,'','0','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),(2,31,'2','iskijmar@kij.co.th','652caf8f3e870','2023-10-16 10:35:43','confirmed','2023-10-16 12:25:25'),(3,31,'2','iskijmar@kij.co.th','652cca01c8ccd','2023-10-16 12:28:33','confirmed','0000-00-00 00:00:00'),(4,31,'2','iskijmar@kij.co.th','652cca7d14ae3','2023-10-16 12:30:37','confirmed','0000-00-00 00:00:00'),(5,31,'2','iskijmar@kij.co.th','652ccafd33687','2023-10-16 12:32:45','confirmed','2023-10-16 12:33:11'),(6,31,'2','iskijmar@kij.co.th','652ccb9170b15','2023-10-16 12:35:13','confirmed','2023-10-16 12:36:02'),(7,3,'user','email','652cd154e1bd9','2023-10-16 12:59:48','waiting',NULL),(8,31,'2','iskijmar@kij.co.th','652cd23cd2298','2023-10-16 13:03:40','waiting',NULL),(9,3,'user','email','652cd24473f2c','2023-10-16 13:03:48','waiting',NULL),(10,31,'2','iskijmar@kij.co.th','652cd292d1c8c','2023-10-16 13:05:06','confirmed','2023-10-16 13:06:04'),(11,3,'user','email','652cd29d08e18','2023-10-16 13:05:17','waiting',NULL),(12,2,'1','3','652cd2a52282f','2023-10-16 13:05:25','waiting',NULL),(13,31,'2','iskijmar@kij.co.th','652cd51b004bd','2023-10-16 13:15:55','confirmed','2023-10-16 13:18:37'),(14,3,'user','email','652cd53ae8629','2023-10-16 13:16:26','You must provide at least one recipient email address.',NULL),(15,3,'user','email','652cd593a915d','2023-10-16 13:17:55','Fail : You must provide at least one recipient email address.',NULL),(16,31,'2','iskijmar@kij.co.th','652cd6f7b18a7','2023-10-16 13:23:51','confirmed','2023-10-16 13:24:58'),(17,1,'admin','iskijmar@kij.co.th','652cef4d984d4','2023-10-16 15:07:41','confirmed','2023-10-16 15:08:16'),(18,31,'2','iskijmar@kij.co.th','652cf23057ba3','2023-10-16 15:20:00','confirmed','2023-10-16 15:26:07'),(19,31,'2','iskijmar@kij.co.th','652cf5675511a','2023-10-16 15:33:43','confirmed','2023-10-16 15:34:24'),(20,31,'2','iskijmar@kij.co.th','652cf6afed594','2023-10-16 15:39:11','waiting',NULL),(21,31,'2','iskijmar@kij.co.th','652cf6e57f808','2023-10-16 15:40:05','waiting',NULL),(22,31,'2','iskijmar@kij.co.th','652cf71051cf4','2023-10-16 15:40:48','confirmed','2023-10-16 15:41:33'),(23,31,'2','iskijmar@kij.co.th','652d25fa43612','2023-10-16 19:00:58','waiting',NULL),(24,3,'user','email','652d267ab8077','2023-10-16 19:03:06','Fail : You must provide at least one recipient email address.',NULL),(25,31,'2','iskijmar@kij.co.th','652d2689dc672','2023-10-16 19:03:21','waiting',NULL);
/*!40000 ALTER TABLE `user_reset` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2025-10-26 21:34:57

📁 Sid Gifari File Manager