Da

✏️ Editing: chatwith_cwm.sql

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

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

USE `chatwith_cwm`;

--
-- Table structure for table `agent`
--

DROP TABLE IF EXISTS `agent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `nickname` varchar(20) NOT NULL,
  `detail` varchar(50) NOT NULL,
  `pic` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `staffid` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agent`
--

LOCK TABLES `agent` WRITE;
/*!40000 ALTER TABLE `agent` DISABLE KEYS */;
INSERT INTO `agent` VALUES (1,'101','lisa','สวยใส ไร้มลพิษ 55','a1.jpg','online','001'),(2,'102','june','คุยขำๆ อย่าอำเรานะ อิอิ','a2.jpg','online','002'),(3,'a201','sheap','สวยซื่อ ชื่อก็บอก..','a3.jpg','online','001'),(4,'f301','fox','ปรึกษาปัญหาหัวใจจ้า','a4.jpg','online','002'),(5,'C005','Wicky','Fun chat with me','a5.jpg','online','001'),(6,'B006','Lala','Find place to eat?','a6.jpg','online','001'),(7,'B007','May','Chat in my heart','a7.jpg','online','001'),(8,'A008','Pim','All about Love!','a8.jpg','online','001');
/*!40000 ALTER TABLE `agent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `member`
--

DROP TABLE IF EXISTS `member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `memberid` varchar(20) NOT NULL,
  `msisdn` int(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `chatwith` varchar(30) NOT NULL,
  `staffid` varchar(20) DEFAULT NULL,
  `credit` int(10) NOT NULL,
  `package` varchar(30) NOT NULL,
  `newmsg` varchar(10) NOT NULL,
  `logintime` varchar(30) DEFAULT NULL,
  `logouttime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `member`
--

LOCK TABLES `member` WRITE;
/*!40000 ALTER TABLE `member` DISABLE KEYS */;
INSERT INTO `member` VALUES (1,'2222222',56,'','','free','','',30,'basic','',NULL,NULL),(2,'2222222',2222222,'','','free','','',30,'basic','',NULL,NULL),(3,'42',2,'e','4','new','','',30,'basic','',NULL,NULL),(4,'42',1122,'bing','4','new','','',30,'basic','',NULL,NULL),(5,'42',60,'one','4','new','','',30,'basic','',NULL,NULL),(6,'42',32,'Tom','4','new','','',30,'basic','',NULL,NULL),(7,'42',43,'้ริว','4','new','','',30,'basic','',NULL,NULL),(8,'42',12,'เคน','4','new','','',30,'basic','',NULL,NULL),(9,'42',42,'win','4','online','fox','001',30,'basic','no',NULL,NULL),(10,'42',10,'jira','4','online','sheap','002',30,'basic','no',NULL,NULL),(11,'42',2,'we','4','online','lisa','001',30,'basic','yes',NULL,NULL),(12,'42',45,'เมย์','4','online','lisa','002',30,'basic','yes',NULL,NULL),(13,'42',692456120,'fav','4','online','fox','001',30,'basic','no',NULL,NULL),(14,'42',45,'favi','4','online','lisa','002',30,'basic','no',NULL,NULL),(15,'42',76,'pagop','4','online','มาใหม่','001',30,'basic','no',NULL,NULL),(16,'42',32,'fufu','4','online','มาใหม่','002',30,'basic','yes',NULL,NULL),(17,'42',56,'kapi','4','online','lisa','001',30,'basic','yes','31-08-2017 11:12:25','31-08-2017 11:22:25'),(18,'42',421,'jingjo','4','online','sheap','002',30,'basic','no',NULL,NULL),(19,'42',12,'foxi','4','online','lisa','001',30,'basic','yes','31-08-2017 03:14:07',NULL),(20,'42',52,'muk','4','online','sheap','002',30,'basic','no','31-08-2017 10:16:34',NULL),(21,'42',25,'fuda','4','offline','มาใหม่','001',30,'basic','no','31-08-2017 11:12:25','31-08-2017 11:19:01'),(22,'42',98,'valic','4','offline','june','002',30,'basic','yes','31-08-2017 11:19:47','31-08-2017 11:20:56'),(23,'42',89,'mj','4','offline','Pim','001',30,'pro','yes','31-08-2017 11:36:41','05-09-2017 13:46:00'),(24,'42',62,'Ethan','4','offline','lisa','001',30,'basic','no','05-09-2017 10:15:36','05-09-2017 11:35:42'),(25,'42',89,'mj','4','offline','Pim','001',30,'basic','yes','05-09-2017 11:35:53','05-09-2017 13:46:00'),(26,'42',89,'mj','4','offline','Pim','001',30,'pro','yes','05-09-2017 11:46:45','05-09-2017 13:46:00'),(27,'42',89,'mj','4','offline','Pim','001',30,'pro','yes','05-09-2017 11:47:11','05-09-2017 13:46:00'),(28,'42',89,'mj','4','offline','Pim','001',30,'basic','yes','05-09-2017 12:07:19','05-09-2017 13:46:00'),(29,'42',89,'mj','4','offline','Pim','001',30,'basic','yes','05-09-2017 12:37:13','05-09-2017 13:46:00'),(30,'42',89,'mj','4','offline','Pim','001',30,'basic','yes','05-09-2017 12:38:00','05-09-2017 13:46:00'),(31,'42',89,'mj','4','offline','Pim','001',30,'pro','yes','05-09-2017 13:23:37','05-09-2017 13:46:00'),(32,'42',89,'mj','4','offline','Pim','001',30,'pro','yes','05-09-2017 13:24:31','05-09-2017 13:46:00'),(33,'42',1,'Dundee','4','offline','fox','002',30,'','yes','05-09-2017 13:46:22',NULL),(34,'42',1,'a','4','offline','lisa','001',30,'','yes','20-09-2017 18:42:31',NULL),(35,'42',4,'a','4','offline','lisa','001',30,'','yes','25-09-2017 16:33:19','26-09-2017 17:24:35'),(36,'42',1,'เอ','4','offline','Lala','001',30,'','no','26-09-2017 17:24:52',NULL),(37,'42',1,'ฟ้า','4','offline','lisa','001',30,'','yes','27-09-2017 07:54:30',NULL),(38,'42',1,'g','4','offline','May','001',30,'','yes','28-09-2017 14:06:55',NULL),(46,'42',1,'t','4','online','มาใหม่',NULL,30,'','no','28-09-2017 18:44:07',NULL),(39,'42',1,'โอมา','4','offline','Lala','001',30,'','yes','28-09-2017 15:26:10',NULL),(40,'42',1,'y','4','offline','Pim','001',30,'','no','28-09-2017 15:26:54',NULL),(41,'42',1,'mj','4','offline','Pim','001',30,'','yes','28-09-2017 16:00:37',NULL),(42,'42',1,'ค','4','offline','Pim','001',30,'','yes','28-09-2017 16:18:55',NULL),(43,'42',1,'kong','4','offline','Pim','001',30,'','yes','28-09-2017 16:20:03',NULL),(44,'42',1,'พ','4','offline','Wicky','001',30,'','yes','28-09-2017 16:20:43',NULL),(45,'42',1,'g','4','offline','May','001',30,'','yes','28-09-2017 18:43:46',NULL),(47,'42',555,'Kanok','4','offline','lisa','001',30,'','yes','11-12-2018 09:57:28','11-12-2018 09:59:10'),(48,'42',4,'we','4','online','lisa','001',30,'','yes','11-12-2018 09:59:22',NULL);
/*!40000 ALTER TABLE `member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_Lala`
--

DROP TABLE IF EXISTS `room_Lala`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_Lala` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_Lala`
--

LOCK TABLES `room_Lala` WRITE;
/*!40000 ALTER TABLE `room_Lala` DISABLE KEYS */;
INSERT INTO `room_Lala` VALUES (1,'Lala','เอ','ดีลาลา','เอ','1_เอ','26-09-2017','17:26:53'),(2,'Lala','เอ','ดีเอ','Lala','1_เอ','26-09-2017','17:27:09'),(3,'Lala','โอมา','hi','โอมา','1_โอมา','28-09-2017','15:26:18');
/*!40000 ALTER TABLE `room_Lala` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_May`
--

DROP TABLE IF EXISTS `room_May`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_May` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_May`
--

LOCK TABLES `room_May` WRITE;
/*!40000 ALTER TABLE `room_May` DISABLE KEYS */;
INSERT INTO `room_May` VALUES (1,'May','g','fdb','g','1_g','28-09-2017','18:43:54');
/*!40000 ALTER TABLE `room_May` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_Pim`
--

DROP TABLE IF EXISTS `room_Pim`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_Pim` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_Pim`
--

LOCK TABLES `room_Pim` WRITE;
/*!40000 ALTER TABLE `room_Pim` DISABLE KEYS */;
INSERT INTO `room_Pim` VALUES (1,'Pim','a','hi','a','4_a','26-09-2017','17:23:30'),(2,'Pim','เอ','Pi','เอ','1_เอ','26-09-2017','17:25:25'),(3,'Pim','เอ','ดีพิม','Pim','1_เอ','26-09-2017','17:25:34'),(4,'Pim','y','ดร','y','1_y','28-09-2017','15:59:20'),(5,'Pim','y','ไง','y','1_y','28-09-2017','15:59:34'),(6,'Pim','y','มา','y','1_y','28-09-2017','15:59:39'),(7,'Pim','y','ไหน','y','1_y','28-09-2017','15:59:42'),(8,'Pim','y','อยู่นี่','Pim','1_y','28-09-2017','16:00:06'),(9,'Pim','mj','hoho','mj','1_mj','28-09-2017','16:01:17'),(10,'Pim','mj','นน','Pim','1_mj','28-09-2017','16:01:31'),(11,'Pim','mj','าน','mj','1_mj','28-09-2017','16:03:19'),(12,'Pim','ค','าส','ค','1_ค','28-09-2017','16:19:49'),(13,'Pim','kong','jikjghj','kong','1_kong','28-09-2017','16:20:36');
/*!40000 ALTER TABLE `room_Pim` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_Wicky`
--

DROP TABLE IF EXISTS `room_Wicky`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_Wicky` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_Wicky`
--

LOCK TABLES `room_Wicky` WRITE;
/*!40000 ALTER TABLE `room_Wicky` DISABLE KEYS */;
INSERT INTO `room_Wicky` VALUES (1,'Wicky','y','ดีจ้า','y','1_y','28-09-2017','15:27:13'),(2,'Wicky','y','hi','Wicky','1_y','28-09-2017','15:28:15'),(3,'Wicky','y','ทำไรอยู่','y','1_y','28-09-2017','15:28:31'),(4,'Wicky','y','คุยยากไหม','y','1_y','28-09-2017','15:32:05'),(5,'Wicky','y','ไม่นะ','y','1_y','28-09-2017','15:32:16'),(6,'Wicky','y','จิงดิ','Wicky','1_y','28-09-2017','15:33:39'),(7,'Wicky','พ','กเ','พ','1_พ','28-09-2017','16:20:58'),(8,'Wicky','Kanok','hi Wicky','Kanok','555_Kanok','11-12-2018','09:57:54');
/*!40000 ALTER TABLE `room_Wicky` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_fox`
--

DROP TABLE IF EXISTS `room_fox`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_fox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_fox`
--

LOCK TABLES `room_fox` WRITE;
/*!40000 ALTER TABLE `room_fox` DISABLE KEYS */;
INSERT INTO `room_fox` VALUES (1,'fox','jira','wc fox','jira','','',NULL),(2,'fox','jira','yeh i can c u','fox','','',NULL),(3,'fox','jira','may i change','jira','','',NULL),(4,'fox','jira','done','jira','','29-08-2017',NULL),(5,'fox','jira','op','jira','','30-08-2017',NULL),(6,'fox','เมย์','won','เมย์','45_เมย์','30-08-2017',NULL),(7,'fox','เมย์','fan','เมย์','45_เมย์','30-08-2017',NULL),(8,'fox','fav','im fav','fav','692456120_fav','30-08-2017',NULL),(9,'fox','fav','hi fox','fav','692456120_fav','30-08-2017',NULL),(10,'fox','favi','ke ke','favi','45_favi','30-08-2017',NULL),(11,'fox','favi','he is a book','favi','45_favi','30-08-2017',NULL),(12,'fox','badi','hi fox','badi','21_badi','30-08-2017',NULL),(13,'fox','badi','im badi','badi','21_badi','30-08-2017',NULL),(14,'fox','badi','h r u','badi','21_badi','30-08-2017',NULL),(15,'fox','kapi','1111','kapi','56_kapi','30-08-2017',NULL),(16,'fox','kapi','2222','fox','56_kapi','30-08-2017',NULL),(17,'fox','kapi','333','kapi','56_kapi','30-08-2017',NULL),(18,'fox','kapi','444','kapi','56_kapi','30-08-2017',NULL),(19,'fox','muk','time','muk','52_muk','31-08-2017',NULL),(20,'fox','muk','card','muk','52_muk','31-08-2017','10:19:49'),(21,'fox','valic','hi fox','valic','98_valic','31-08-2017','11:20:07'),(22,'fox','mj','nuni','mj','89_mj','31-08-2017','12:19:16'),(23,'fox','mj','kk','fox','89_mj','31-08-2017','12:19:23'),(24,'fox','Dundee','hi foxu','Dundee','1_Dundee','05-09-2017','18:34:04');
/*!40000 ALTER TABLE `room_fox` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_june`
--

DROP TABLE IF EXISTS `room_june`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_june` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_june`
--

LOCK TABLES `room_june` WRITE;
/*!40000 ALTER TABLE `room_june` DISABLE KEYS */;
INSERT INTO `room_june` VALUES (1,'june','valic','pen','valic','98_valic','31-08-2017','11:20:46'),(2,'june','mj','kouyt','mj','89_mj','31-08-2017','12:20:12'),(3,'june','undefined','hihi','june','undefined_undefined','31-08-2017','17:56:12');
/*!40000 ALTER TABLE `room_june` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_lisa`
--

DROP TABLE IF EXISTS `room_lisa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_lisa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_lisa`
--

LOCK TABLES `room_lisa` WRITE;
/*!40000 ALTER TABLE `room_lisa` DISABLE KEYS */;
INSERT INTO `room_lisa` VALUES (1,'lisa','jira','jira hi','jira','','',NULL),(2,'lisa','jira','jo','jira','','',NULL),(3,'lisa','jira','wating long?','jira','','',NULL),(4,'lisa','jira','cool','jira','','',NULL),(5,'lisa','favi','mai','favi','45_favi','30-08-2017',NULL),(6,'lisa','favi','kui','favi','45_favi','30-08-2017',NULL),(7,'lisa','favi','dai','favi','45_favi','30-08-2017',NULL),(8,'lisa','favi','how are you?','favi','45_favi','30-08-2017',NULL),(9,'lisa','fufu','hi lisa','fufu','32_fufu','30-08-2017',NULL),(10,'lisa','kapi','hi lisa','kapi','56_kapi','30-08-2017',NULL),(11,'lisa','kapi','dd','kapi','56_kapi','30-08-2017',NULL),(12,'lisa','Gae','yes sure','Gae','Gae_34','30-08-2017',NULL),(13,'lisa','kapi','haha','lisa','Gae_34','30-08-2017',NULL),(14,'lisa','kapi','4444','kapi','56_kapi','30-08-2017',NULL),(15,'lisa','kapi','5555','lisa','56_kapi','30-08-2017',NULL),(16,'lisa','kapi','6666','kapi','56_kapi','30-08-2017',NULL),(17,'lisa','kapi','test','kapi','56_kapi','30-08-2017',NULL),(18,'lisa','kapi','ok','lisa','_kapi','30-08-2017',NULL),(19,'lisa','kapi','again','lisa','56_kapi','30-08-2017',NULL),(20,'lisa','kapi','see','lisa','56_kapi','30-08-2017',NULL),(21,'lisa','kapi','ui','lisa','56_kapi','30-08-2017',NULL),(22,'lisa','kapi','i kwon','lisa','56_kapi','30-08-2017',NULL),(23,'lisa','kapi','know','kapi','56_kapi','30-08-2017',NULL),(24,'lisa','kapi','wow','kapi','56_kapi','31-08-2017',NULL),(25,'lisa','foxi','judo','foxi','12_foxi','31-08-2017',NULL),(26,'lisa','muk','check time','muk','52_muk','31-08-2017',NULL),(27,'lisa','muk','date','muk','52_muk','31-08-2017','10:23:19'),(28,'lisa','muk','and time','muk','52_muk','31-08-2017','10:23:21'),(29,'lisa','mj','hi liz','mj','89_mj','31-08-2017','11:37:07'),(30,'lisa','mj','cat','mj','89_mj','31-08-2017','12:16:32'),(31,'lisa','mj','ui','mj','89_mj','31-08-2017','12:18:18'),(32,'lisa','Ethan','hi liz','Ethan','62_Ethan','05-09-2017','10:16:56'),(33,'lisa','Ethan','hi Ethan','lisa','62_Ethan','05-09-2017','11:33:45'),(34,'lisa','mj','yo liza','mj','89_mj','05-09-2017','11:36:28'),(35,'lisa','mj','h r u?','mj','89_mj','05-09-2017','12:08:40'),(36,'lisa','mj','good','lisa','89_mj','05-09-2017','12:09:29'),(37,'lisa','mj','and u?','lisa','89_mj','05-09-2017','12:09:52'),(38,'lisa','mj','k','mj','89_mj','05-09-2017','12:10:57'),(39,'lisa','mj','and u see me?','lisa','89_mj','05-09-2017','12:11:20'),(40,'lisa','mj','sure','mj','89_mj','05-09-2017','12:11:30'),(41,'lisa','mj','can see','mj','89_mj','05-09-2017','12:12:45'),(42,'lisa','mj','check','mj','89_mj','05-09-2017','12:16:07'),(43,'lisa','mj','again','mj','89_mj','05-09-2017','12:21:01'),(44,'lisa','mj','can?','mj','89_mj','05-09-2017','12:21:05'),(45,'lisa','mj','can now','mj','89_mj','05-09-2017','12:51:13'),(46,'lisa','mj','','mj','89_mj','05-09-2017','12:51:59'),(47,'lisa','mj','','mj','89_mj','05-09-2017','12:52:23'),(48,'lisa','mj','','mj','89_mj','05-09-2017','12:52:38'),(49,'lisa','mj','','mj','89_mj','05-09-2017','13:01:55'),(50,'lisa','mj','mj','mj','89_mj','05-09-2017','13:10:27'),(51,'lisa','mj','hi oi','mj','89_mj','05-09-2017','13:25:31'),(52,'lisa','a','hi','a','4_a','25-09-2017','17:01:04'),(53,'lisa','a','ดีลิ','a','4_a','26-09-2017','16:16:41'),(54,'lisa','a','ดีเอ','lisa','4_a','26-09-2017','16:16:52'),(55,'lisa','a','hi','a','4_a','26-09-2017','17:24:09'),(56,'lisa','เอ','ji','เอ','1_เอ','26-09-2017','17:25:02'),(57,'lisa','เอ','ko','lisa','1_เอ','26-09-2017','17:25:11'),(58,'lisa','ฟ้า','ดีฟ้าเอง','ฟ้า','1_ฟ้า','27-09-2017','07:54:56'),(59,'lisa','Kanok','hi Lisa','Kanok','555_Kanok','11-12-2018','09:58:44'),(60,'lisa','we','u there?','we','4_we','11-12-2018','09:59:42');
/*!40000 ALTER TABLE `room_lisa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_sheap`
--

DROP TABLE IF EXISTS `room_sheap`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_sheap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `sign` varchar(100) NOT NULL,
  `chatdate` varchar(50) NOT NULL,
  `chattime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_sheap`
--

LOCK TABLES `room_sheap` WRITE;
/*!40000 ALTER TABLE `room_sheap` DISABLE KEYS */;
INSERT INTO `room_sheap` VALUES (1,'sheap','เมย์','hi s','เมย์','','30-08-2017',NULL),(2,'sheap','fav','hi sheap','fav','fav_692456120','30-08-2017',NULL),(3,'sheap','fav','u know me','fav','fav_692456120','30-08-2017',NULL),(4,'sheap','favi','jojo','favi','45_favi','30-08-2017',NULL),(5,'sheap','favi','tee nai','favi','45_favi','30-08-2017',NULL),(6,'sheap','oi','ni ni','oi','25_oi','30-08-2017',NULL),(7,'sheap','oi','io eng','oi','25_oi','30-08-2017',NULL),(8,'sheap','oi','na','oi','25_oi','30-08-2017',NULL),(9,'sheap','jingjo','talk to me','jingjo','421_jingjo','31-08-2017',NULL),(10,'sheap','jingjo','okok','sheap','421_jingjo','31-08-2017',NULL),(11,'sheap','muk','wa ngai s','muk','52_muk','31-08-2017','10:25:07'),(12,'sheap','muk','d mak','sheap','52_muk','31-08-2017','10:30:35'),(13,'sheap','muk','hi ma','sheap','52_muk','31-08-2017','10:58:18'),(14,'sheap','mj','hw','mj','89_mj','31-08-2017','11:36:50'),(15,'sheap','mj','hi shp','mj','89_mj','31-08-2017','11:45:22'),(16,'sheap','mj','see paper','mj','89_mj','31-08-2017','11:45:29'),(17,'sheap','mj','้ร','mj','89_mj','31-08-2017','15:00:27'),(18,'sheap','mj','hi','mj','89_mj','31-08-2017','15:00:30'),(19,'sheap','mj','sme ','sheap','89_mj','31-08-2017','15:00:42'),(20,'sheap','mj','me rai','sheap','89_mj','31-08-2017','15:03:37'),(21,'sheap','mj','ok','sheap','89_mj','31-08-2017','15:04:12'),(22,'sheap','mj','hoho','mj','89_mj','31-08-2017','17:56:45'),(23,'sheap','mj','lola','sheap','89_mj','31-08-2017','18:04:59'),(24,'sheap','mj','hi','sheap','89_mj','31-08-2017','18:36:53'),(25,'sheap','mj','me','sheap','89_mj','31-08-2017','18:39:03'),(26,'sheap','mj','ok','sheap','89_mj','31-08-2017','18:39:09'),(27,'sheap','mj','wera','mj','89_mj','31-08-2017','18:39:22'),(28,'sheap','mj','nai','sheap','89_mj','31-08-2017','18:39:28'),(29,'sheap','mj','arai','sheap','89_mj','31-08-2017','18:39:32'),(30,'sheap','mj','wa','sheap','89_mj','31-08-2017','18:41:34'),(31,'sheap','mj','1','sheap','89_mj','31-08-2017','18:41:38'),(32,'sheap','mj','2','sheap','89_mj','31-08-2017','18:41:39'),(33,'sheap','mj','3','sheap','89_mj','31-08-2017','18:41:40'),(34,'sheap','mj','4','sheap','89_mj','31-08-2017','18:41:40'),(35,'sheap','mj','5','sheap','89_mj','31-08-2017','18:41:41'),(36,'sheap','mj','6','sheap','89_mj','31-08-2017','18:42:57'),(37,'sheap','mj','now','sheap','89_mj','31-08-2017','18:49:52'),(38,'sheap','mj','jidi','sheap','89_mj','31-08-2017','21:33:10'),(39,'sheap','mj','na','sheap','89_mj','31-08-2017','21:33:14'),(40,'sheap','mj','hi','sheap','89_mj','03-09-2017','10:22:40'),(41,'sheap','mj','how r u','sheap','89_mj','03-09-2017','10:22:46'),(42,'sheap','mj','good','mj','89_mj','03-09-2017','10:25:30'),(43,'sheap','mj','I m thinking about to eat more than this','sheap','89_mj','03-09-2017','16:12:13'),(44,'sheap','mj','candy ka','sheap','89_mj','03-09-2017','17:02:33'),(45,'sheap','mj','I can see you or you can see me','mj','89_mj','03-09-2017','17:13:11'),(46,'sheap','mj','ok','sheap','89_mj','03-09-2017','17:26:06'),(47,'sheap','mj','hi sheap','mj','89_mj','04-09-2017','09:55:53'),(48,'sheap','mj','hi mj','sheap','89_mj','04-09-2017','09:58:40'),(49,'sheap','mj','man','mj','89_mj','05-09-2017','10:14:04'),(50,'sheap','mj','hi shp','mj','89_mj','05-09-2017','12:11:42'),(51,'sheap','a','yo','a','4_a','25-09-2017','17:02:11'),(52,'sheap','a','jo','a','4_a','26-09-2017','12:10:40');
/*!40000 ALTER TABLE `room_sheap` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staffid` varchar(20) NOT NULL,
  `staff_name` varchar(30) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(30) NOT NULL,
  `status` varchar(20) NOT NULL,
  `agent` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES (1,'001','Admin','a','1','Approved','fox,lisa'),(2,'002','Kai','test','test','Approved','june,sheap');
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff_log`
--

DROP TABLE IF EXISTS `staff_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staffid` varchar(20) NOT NULL,
  `staff_name` varchar(30) NOT NULL,
  `logintime` varchar(20) NOT NULL,
  `logouttime` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_log`
--

LOCK TABLES `staff_log` WRITE;
/*!40000 ALTER TABLE `staff_log` DISABLE KEYS */;
INSERT INTO `staff_log` VALUES (1,'001','Gae','31-08-2017 03:41:07',''),(2,'001','Gae','31-08-2017 10:49:42',''),(3,'001','Gae','31-08-2017 10:51:05',''),(4,'001','Gae','31-08-2017 10:52:26',''),(5,'001','Gae','','31-08-2017 10:52:28'),(6,'002','Kai','31-08-2017 10:57:43',''),(7,'002','Kai','','31-08-2017 10:58:30'),(8,'002','Kai','31-08-2017 11:02:54',''),(9,'002','Kai','','31-08-2017 11:03:19'),(10,'001','Gae','31-08-2017 11:05:08',''),(11,'001','Gae','','31-08-2017 11:05:18'),(12,'002','Kai','31-08-2017 11:24:59',''),(13,'002','Kai','','31-08-2017 11:25:11'),(14,'001','Gae','31-08-2017 11:28:27',''),(15,'001','Gae','','31-08-2017 11:48:59'),(16,'002','Kai','31-08-2017 11:49:09',''),(17,'002','Kai','','31-08-2017 11:49:18'),(18,'001','Gae','31-08-2017 11:52:38',''),(19,'001','Gae','','31-08-2017 12:16:48'),(20,'002','Kai','31-08-2017 12:17:00',''),(21,'002','Kai','','31-08-2017 12:41:58'),(22,'001','Gae','31-08-2017 12:42:10',''),(23,'002','Kai','31-08-2017 14:42:40',''),(24,'001','Gae','31-08-2017 14:46:12',''),(25,'001','Gae','31-08-2017 14:50:53',''),(26,'001','Gae','','31-08-2017 14:51:16'),(27,'002','Kai','31-08-2017 14:51:37',''),(28,'002','Kai','','31-08-2017 14:51:43'),(29,'001','Gae','31-08-2017 14:51:57',''),(30,'002','Kai','31-08-2017 17:55:38',''),(31,'002','Kai','','31-08-2017 17:56:56'),(32,'001','Gae','31-08-2017 17:57:10',''),(33,'001','Gae','03-09-2017 10:22:16',''),(34,'001','Gae','04-09-2017 09:58:23',''),(35,'001','Gae','05-09-2017 09:57:39',''),(36,'002','Kai','05-09-2017 18:07:49',''),(37,'002','Kai','','05-09-2017 19:12:37'),(38,'002','Kai','05-09-2017 19:14:52',''),(39,'002','Kai','','05-09-2017 19:23:48'),(40,'001','Gae','05-09-2017 19:23:55',''),(41,'001','Gae','','05-09-2017 19:29:03'),(42,'001','Gae','05-09-2017 19:29:08',''),(43,'001','Gae','','05-09-2017 19:30:33'),(44,'001','Gae','05-09-2017 19:30:39',''),(45,'001','Gae','06-09-2017 18:39:44',''),(46,'001','Gae','20-09-2017 18:43:57',''),(47,'001','Gae','25-09-2017 16:30:58',''),(48,'001','Gae','28-09-2017 15:27:55','');
/*!40000 ALTER TABLE `staff_log` 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-22 16:48:11

📁 Sid Gifari File Manager