Da

✏️ Editing: coatahol_site3.sql

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

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

USE `coatahol_site3`;

--
-- Table structure for table `tb_buy_info`
--

DROP TABLE IF EXISTS `tb_buy_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_buy_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rentid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `fullname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `address` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_date` date NOT NULL,
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `payment` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `discount` int(11) NOT NULL,
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `amount` int(11) NOT NULL,
  `user_create` int(11) NOT NULL,
  `send` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_buy_info`
--

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

--
-- Table structure for table `tb_buys`
--

DROP TABLE IF EXISTS `tb_buys`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_buys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `rent_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_date` date NOT NULL,
  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_buys`
--

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

--
-- Table structure for table `tb_cates`
--

DROP TABLE IF EXISTS `tb_cates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_cates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_cates`
--

LOCK TABLES `tb_cates` WRITE;
/*!40000 ALTER TABLE `tb_cates` DISABLE KEYS */;
INSERT INTO `tb_cates` VALUES (1,'DR - DRESS เดรส ','1','2019-05-31'),(2,'SH - SHIRT เสื้อ','1','2019-05-31'),(3,'SK - Skirt กระโปรง ','1','2019-05-31'),(5,'PA - PANT กางเกง','1','2019-05-31'),(6,'AC - Accessories หมวก แว่นตา กระเป๋า ที่คาดผม สร้อย ต่างหู ','1','2019-05-31'),(7,'SHO - Shoe รองเท้า','1','2019-06-04'),(8,'SW - SWIMWEAR ชุดว่ายน้ำ','1','2019-05-31'),(9,'JS - JUMPSUIT สั้น ยาว','1','2019-05-31'),(10,'CO - COAT เสื้อคลุมต่างๆ ','1','2019-05-31');
/*!40000 ALTER TABLE `tb_cates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_clean`
--

DROP TABLE IF EXISTS `tb_clean`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_clean` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `start` date NOT NULL,
  `end` date NOT NULL,
  `count_itme` int(11) NOT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2160 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_clean`
--

LOCK TABLES `tb_clean` WRITE;
/*!40000 ALTER TABLE `tb_clean` DISABLE KEYS */;
INSERT INTO `tb_clean` VALUES (2028,1229,'2019-06-09','2019-06-10',1,'w'),(2029,1209,'2019-06-25','2019-06-26',1,'w'),(2030,1252,'2019-06-17','2019-06-18',1,'w'),(2031,1251,'2019-06-17','2019-06-18',1,'w'),(2032,1245,'2019-07-24','2019-07-25',1,'w'),(2033,1284,'2019-07-22','2019-07-23',1,'w'),(2034,1232,'2019-06-18','2019-06-19',1,'w'),(2035,1274,'2019-07-10','2019-07-11',1,'w'),(2036,1206,'2019-07-10','2019-07-11',1,'w'),(2037,1245,'2019-07-10','2019-07-11',1,'w'),(2038,1249,'2019-07-10','2019-07-11',1,'w'),(2039,1179,'2019-07-10','2019-07-11',1,'w'),(2040,1205,'2019-07-24','2019-07-25',1,'w'),(2041,1192,'2019-07-24','2019-07-25',1,'w'),(2042,1218,'2019-07-24','2019-07-25',1,'w'),(2043,1254,'2019-06-25','2019-06-26',1,'w'),(2044,1250,'2019-06-27','2019-06-28',1,'w'),(2045,1176,'2019-06-27','2019-06-28',1,'w'),(2046,1245,'2019-08-02','2019-08-03',1,'w'),(2047,1204,'2019-08-02','2019-08-03',1,'w'),(2048,1238,'2019-08-02','2019-08-03',1,'w'),(2049,1245,'2019-07-05','2019-07-06',1,'w'),(2050,1204,'2019-07-05','2019-07-06',1,'w'),(2051,1238,'2019-07-05','2019-07-06',1,'w'),(2052,1219,'2019-07-19','2019-07-20',1,'w'),(2053,1294,'2019-07-19','2019-07-20',1,'w'),(2054,1293,'2019-07-19','2019-07-20',1,'w'),(2055,1188,'2019-07-16','2019-07-17',1,'w'),(2056,1295,'2019-07-16','2019-07-17',1,'w'),(2057,1202,'2019-06-27','2019-06-28',1,'w'),(2058,1309,'2019-06-27','2019-06-28',1,'w'),(2059,1222,'2019-06-28','2019-06-29',1,'w'),(2060,1258,'2019-06-28','2019-06-29',1,'w'),(2061,1314,'2019-07-02','2019-07-03',1,'w'),(2062,1179,'2019-07-02','2019-07-03',1,'w'),(2063,1251,'2019-07-09','2019-07-10',1,'w'),(2064,1295,'2019-07-09','2019-07-10',1,'w'),(2065,1209,'2019-07-09','2019-07-10',1,'w'),(2066,1295,'2019-07-09','2019-07-10',1,'w'),(2067,1315,'2019-07-08','2019-07-09',1,'w'),(2068,1202,'2019-07-08','2019-07-09',1,'w'),(2069,1316,'2019-07-09','2019-07-10',1,'w'),(2070,1193,'2019-07-09','2019-07-10',1,'w'),(2071,1257,'2019-07-09','2019-07-10',1,'w'),(2072,1186,'2019-07-09','2019-07-10',1,'w'),(2073,1212,'2019-07-09','2019-07-10',1,'w'),(2074,1312,'2019-07-09','2019-07-10',1,'w'),(2075,1201,'2019-07-09','2019-07-10',1,'w'),(2076,1204,'2019-07-18','2019-07-19',1,'w'),(2077,1295,'2019-07-18','2019-07-19',1,'w'),(2078,1270,'2019-07-24','2019-07-25',1,'w'),(2079,1228,'2019-07-18','2019-07-19',1,'w'),(2080,1317,'2019-08-06','2019-08-07',1,'w'),(2081,1310,'2019-07-23','2019-07-24',1,'w'),(2082,1185,'2019-07-30','2019-07-31',1,'w'),(2083,1318,'2019-07-30','2019-07-31',1,'w'),(2084,1314,'2019-07-31','2019-08-01',1,'w'),(2085,1295,'2019-07-31','2019-08-01',1,'w'),(2086,1184,'2019-07-29','2019-07-30',1,'w'),(2087,1197,'2019-07-31','2019-08-01',1,'w'),(2088,1318,'2019-07-31','2019-08-01',1,'w'),(2089,1257,'2019-08-16','2019-08-17',1,'w'),(2090,1318,'2019-08-16','2019-08-17',1,'w'),(2091,1319,'2019-08-12','2019-08-13',1,'w'),(2092,1317,'2019-09-21','2019-09-22',1,'w'),(2093,1318,'2019-09-21','2019-09-22',1,'w'),(2094,1320,'2019-08-16','2019-08-17',1,'w'),(2095,1184,'2019-08-11','2019-08-12',1,'w'),(2096,1199,'2019-08-15','2019-08-16',1,'w'),(2097,1299,'2019-08-15','2019-08-16',1,'w'),(2098,1252,'2019-08-12','2019-08-13',1,'w'),(2099,1208,'2019-08-12','2019-08-13',1,'w'),(2100,1318,'2019-08-12','2019-08-13',1,'w'),(2101,1179,'2019-09-11','2019-09-12',1,'w'),(2102,1251,'2019-08-24','2019-08-25',1,'w'),(2103,1295,'2019-08-24','2019-08-25',1,'w'),(2104,1284,'2019-08-28','2019-08-29',1,'w'),(2105,1179,'2019-08-31','2019-09-01',1,'w'),(2106,1295,'2019-08-31','2019-09-01',1,'w'),(2107,1310,'2019-09-17','2019-09-18',1,'w'),(2108,1278,'2019-09-17','2019-09-18',1,'w'),(2109,1209,'2019-09-03','2019-09-04',1,'w'),(2110,1295,'2019-09-03','2019-09-04',1,'w'),(2111,1179,'2019-09-26','2019-09-27',1,'w'),(2112,1206,'2019-09-26','2019-09-27',1,'w'),(2113,1245,'2019-09-21','2019-09-22',1,'w'),(2114,1295,'2019-09-21','2019-09-22',1,'w'),(2115,1320,'2019-10-08','2019-10-09',1,'w'),(2116,1212,'2019-10-18','2019-10-19',1,'w'),(2117,1317,'2019-10-18','2019-10-19',1,'w'),(2118,1250,'2019-10-24','2019-10-25',1,'w'),(2119,1229,'2019-10-22','2019-10-23',1,'w'),(2120,1242,'2019-10-22','2019-10-23',1,'w'),(2121,1324,'2019-10-25','2019-10-26',1,'w'),(2122,1296,'2019-10-25','2019-10-26',1,'w'),(2123,1316,'2019-10-22','2019-10-23',1,'w'),(2124,1295,'2019-10-22','2019-10-23',1,'w'),(2125,1309,'2019-10-22','2019-10-23',1,'w'),(2126,1254,'2019-10-22','2019-10-23',1,'w'),(2127,1203,'2019-11-12','2019-11-13',1,'w'),(2128,1188,'2019-11-11','2019-11-12',1,'w'),(2129,1310,'2019-11-12','2019-11-13',1,'w'),(2130,1274,'2019-11-20','2019-11-21',1,'w'),(2131,1287,'2019-11-19','2019-11-20',1,'w'),(2132,1322,'2019-11-12','2019-11-13',1,'w'),(2133,1245,'2019-11-19','2019-11-20',1,'w'),(2134,1183,'2019-11-24','2019-11-25',1,'w'),(2135,1310,'2019-12-05','2019-12-06',1,'w'),(2136,1180,'2019-12-12','2019-12-13',1,'w'),(2137,1242,'2020-01-24','2020-01-25',1,'w'),(2138,1217,'2019-12-24','2019-12-25',1,'w'),(2139,1198,'2019-12-30','2019-12-31',1,'w'),(2140,1317,'2019-12-30','2019-12-31',1,'w'),(2141,1318,'2019-12-30','2019-12-31',1,'w'),(2142,1364,'2020-02-05','2020-02-06',3,'w'),(2143,1206,'2020-02-05','2020-02-06',1,'w'),(2144,1371,'2020-01-14','2020-01-15',1,'w'),(2145,1249,'2020-02-04','2020-02-05',1,'w'),(2146,1198,'2020-02-25','2020-02-26',1,'w'),(2147,1295,'2020-02-25','2020-02-26',1,'w'),(2148,1242,'2020-02-23','2020-02-24',1,'w'),(2149,1206,'2020-03-14','2020-03-15',1,'w'),(2150,1377,'2020-03-14','2020-03-15',4,'w'),(2151,1364,'2020-03-14','2020-03-15',1,'w'),(2152,1280,'2020-03-03','2020-03-04',1,'w'),(2153,1186,'2020-03-03','2020-03-04',1,'w'),(2154,1230,'2020-03-03','2020-03-04',1,'w'),(2155,1310,'2020-02-24','2020-02-25',1,'w'),(2156,1356,'2020-03-24','2020-03-25',1,'w'),(2157,1295,'2020-03-24','2020-03-25',1,'w'),(2158,1203,'2020-03-18','2020-03-19',1,'w'),(2159,1209,'2020-11-25','2020-11-26',1,'w');
/*!40000 ALTER TABLE `tb_clean` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_collection`
--

DROP TABLE IF EXISTS `tb_collection`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemid` int(11) NOT NULL,
  `nameset` varchar(255) NOT NULL,
  `id_date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_collection`
--

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

--
-- Table structure for table `tb_edit_logstocksale`
--

DROP TABLE IF EXISTS `tb_edit_logstocksale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_edit_logstocksale` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `is_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_edit` int(11) NOT NULL,
  `des_edit` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_edit_logstocksale`
--

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

--
-- Table structure for table `tb_instock`
--

DROP TABLE IF EXISTS `tb_instock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_instock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `item_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `count` int(11) NOT NULL,
  `in_stock` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  `insurance` int(11) NOT NULL,
  `is_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `rent_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `stat` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1378 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_instock`
--

LOCK TABLES `tb_instock` WRITE;
/*!40000 ALTER TABLE `tb_instock` DISABLE KEYS */;
INSERT INTO `tb_instock` VALUES (1175,'20190603152401','CORE001-ขนนก 40-F-F-16-20-13','เสื้อคลุมขนนกแดง',1,1,700,1300,'2019-06-03','N','1','10','แดง',0),(1176,'20190603152741','DRRE001-36-28-38-14-33-15Flat2112','เดรสแดง flat2112 ',1,1,450,900,'2019-06-03','N','1','1','แดง',1),(1177,'20190603153626','DRRE002-32-28-34-17-40 เดรสแดงแขนกุด','เดรสสีแดงแขนกุด คอมีระบาย',1,1,450,900,'2019-06-03','N','1','1','แดง',0),(1178,'20190603154054','DRRE003-36-26-36-F-50-F','เดรสแดงสายเดี่ยว ปักฉลุ ',1,1,450,900,'2019-06-19','N','1','10','แดง',0),(1179,'20190603154328','DRRE004-38-28-F-17-45-23 เดรสแดงอาหรับ','เดรสแดงอาหรับ',1,1,450,900,'2019-06-12','N','1','1','แดง',5),(1180,'20190603154746','SHRE001-36-30-F-14-21-21 แขนขน','เสื้อแดงแขนขนนกกระจอกเทศ',1,1,250,500,'2019-06-03','N','1','2','แดง',1),(1181,'20190603155059','RRSKREBENZ001-28-34-20 กระโปรงพู่','กระโปรงพู่แดง',1,1,350,500,'2019-06-03','N','1','3','แดง',0),(1182,'20190603155856','RRDRWHBENZ001-33-26-32-12-50-F ราตรีปักเลื่อมขาว','ราตรีปักเลื่อมสีขาว',1,1,1000,1200,'2019-06-03','N','1','1','ขาว',0),(1183,'20190603160328','SKWH001-27-38-33','กระโปรงขาวลายตัวหนังสือ',1,1,350,700,'2019-06-03','N','1','3','ขาว',1),(1184,'20190603160721','COWH001-60-F-F-F-53-Fอองฟองขาว','เสื้อคลุมอองฟองขาว',1,1,450,900,'2019-06-03','N','1','10','ขาว',2),(1185,'20190603161421','JSWH001-34-26-36-15-60-27','JUMPSUIT สีขาว มีกระโปรงคลุม',0,1,350,600,'2019-06-10','N','1','9','ขาว',1),(1186,'20190603161813','SHWH001-อก32-36 ยาว16 บราดอกไม้','บราขาวดอกไม้',1,1,300,500,'2019-06-03','N','1','2','ขาว',2),(1187,'20190603162537','SKGR001เอว24-26สะโพก34-36ยาว15กปขนนก','กระโปรงสั้นเขียว ขนนกกระจอกเทศ',1,1,300,500,'2019-06-03','N','1','3','เขียว',0),(1188,'20190603163213','DRGR001-34-28-F-15-53-29','เดรสสีเขียวชมพูสะท้อนแสง',1,1,400,700,'2019-06-03','N','1','1','เขียวชมพูสะท้อนแสง',2),(1189,'20190603163458','COGR001-60-F-F-F-53-F','เสื้อคลุมอองฟองเขียว',1,1,450,900,'2019-06-03','N','1','10','เขียว',0),(1190,'20190603163758','SKGR002-24-26-สะโพกF-35','กระโปรงเขียวสะท้อนแสง',1,1,350,700,'2019-06-03','N','1','3','เขียวสะท้อนแสง',0),(1191,'20190603164500','SHGY001-36-30-F-14-21-21','เสื้อเทาแขนขนนกกระจอกเทศ',1,1,250,500,'2019-06-03','N','1','2','เทา',0),(1192,'20190603165257','SHGY002-34-F-F-16-11-19','เสื้อกลิสเตอร์+เสื้อคลุม',1,1,300,500,'2019-06-04','N','1','2','เทา',1),(1193,'20190603165605','DRGY001-36-30-42-F-54-F','เดรสเทาลายตรง+ลายขวาง',1,1,500,900,'2019-06-03','N','1','1','เทา',1),(1194,'20190603170329','DRGY002M-35-29-37-F-40-F','เดรสเทาตกแต่งลูกไม้ขาว Size M',1,1,400,800,'2019-06-03','N','1','1','เทา',0),(1195,'20190603170535','DRGY002L-37-31-39-F-41-F','เดรสเทาตกแต่งลูกไม้ Size L',1,1,400,800,'2019-06-03','N','1','1','เทา',0),(1196,'20190603170804','JSGY001-34-28-38-14.5-28-14','JUMPSUIT กางเกงขาสั้นผ้ามันเทา',1,1,700,1400,'2019-06-03','N','1','9','เทา',0),(1197,'20190603171543','SHPI001-34-30-F-F-28-F-อกเสื้อคลุม47','เสื้อสายเดี่ยวชมพู+ผ้ามุ้งคลุม',1,1,250,300,'2019-06-03','N','1','2','ชมพู',1),(1198,'20190603171800','DRPI001-38-35-48-F-53-F','เดรสเกาะอกชมพูลายดอกไม้',1,1,500,1000,'2019-06-03','N','1','1','ชมพู',2),(1199,'20190603172320','SKPI001-เอว24-26สะโพก34-36ยาว15','กระโปรงสั้นขนนกชมพู',1,1,300,500,'2019-06-03','N','1','3','ชมพู',1),(1200,'20190603172451','SHPI002-36-30-F-14-21-21','เสื้อชมพูแขนขนนกกระจอกเทศ',1,1,250,500,'2019-06-03','N','1','2','ชมพู',0),(1201,'20190603172636','DRPI002-34-F-F-F-55-F','เดรสชมพูสายเดี่ยว ผ้าพิมพ์ลาย',1,1,450,600,'2019-06-03','N','1','1','ชมพู',1),(1202,'20190603173332','COPI001-60-F-F-F-19-20','เสื้อคลุมอองฟองสั้นชมพู',1,1,400,700,'2019-06-03','N','1','10','ชมพู',2),(1203,'20190603173647','DRPI003-34-26-40-F-55-F','เดรสสายเดี่ยวยาวชมพูตกแต่งขน',1,1,500,700,'2019-06-03','N','1','1','ชมพู',2),(1204,'20190603173908','SHPI003-36-34-F-F-20-F','เสื้อชมพูแขนกระดิ่ง',0,1,400,800,'2019-06-03','N','1','2','ชมพู',3),(1205,'20190603174244','DRBR001-34-26-34-F-24-11','เดรสน้ำตาลสั้น zimmerman',1,1,750,1400,'2019-06-03','N','1','1','น้ำตาล',1),(1206,'20190603174448','DRBR002-34-28-F-16-52-23','เดรสน้ำตาลลายดอกชมพู zimmerman',2,1,700,1400,'2019-06-03','N','1','1','น้ำตาล ดอกชมพู',4),(1207,'20190603174701','DRBR003-35-29-40-15.5-35-22','เดรสน้ำตาลจับจีบย่นด้านหน้า',1,1,500,1000,'2019-06-03','N','1','1','น้ำตาล',0),(1208,'20190603175153','DRBK001-33-26-F-15-53-27','เดรสดำผ้าลูกไม้ตกแต่งขนชมพูที่คอ',1,1,600,1000,'2019-06-03','N','1','1','ดำ',1),(1209,'20190603175417','SHBK001-36-30-F-F-14-14','เสื้อสายเดี่ยวดำ แขนกระดิ่ง',0,1,350,350,'2019-06-03','N','1','2','ดำ',4),(1210,'20190603175527','PABK001-30-37-40','กางเกงสีดำขากระบอกใหญ่ คู่เสื้อสายเดี่ยวดำ',1,1,350,350,'2019-06-03','N','1','5','ดำ',0),(1211,'20190603175929','RRSHBKBENZ001-38-F-F-15-23-20','เสื้อเกาะไหล่ลายดำขาว',1,1,350,350,'2019-06-03','N','1','2','ดำลายขาว',0),(1212,'20190603180124','DRBK002-40-F-F-F-48-F','เดรสคล้องคอดำลายม้าลาย',1,1,450,1000,'2019-06-03','N','1','1','ดำ',2),(1213,'20190603180410','DRBK003-33-26-33-F-36-F','เดรสดำสายเดี่ยวปักเลื่อม',1,1,600,1000,'2019-06-03','N','1','1','ดำ',0),(1214,'20190603180607','SKBK001-28-36-40','กระโปรงมุ้งดำ ตกแต่งลูกไม้ขาว',1,1,350,350,'2019-06-04','N','1','3','ดำ',0),(1215,'20190603180735','DRBK004-33-30-36-15-33-23','เดรสดำปักเลื่อม ไหล่ตกแต่งขนนก',1,1,600,1000,'2019-06-03','N','1','1','ดำ',0),(1216,'20190603180930','SHBK002-36-34-F-F-20-F','เสื้อสีดำแขนกระดิ่ง',1,1,400,800,'2019-06-03','N','1','2','ดำ',0),(1218,'20190603181533','DRBK006-36-29-38-14-33-25','เดรสสั้นดำระบายชั้น',1,1,600,1000,'2019-06-03','N','1','1','ดำ',1),(1219,'20190603181659','DRBK007-34-28-36-14-52-23','เดรสยาวดำระบายชั้น',1,1,700,1200,'2019-06-03','N','1','1','ดำ',1),(1220,'20190603181921','SKBK002-เอว24-26สะโพก34-36ยาว15','กระโปรงสั้นดำขนนกกระจอกเทศ',1,1,300,500,'2019-06-03','N','1','3','ดำ',0),(1221,'20190603182132','DRBK007-34-26-F-14-30-9','DRESS ดำกระโปรงบัลเล่ต์ลายจุด',1,1,400,500,'2019-06-03','N','1','1','ดำ',0),(1222,'20190603182515','SKBK003-26-36-14-39','กระโปรงดำผ่าหน้า',1,1,400,1000,'2019-06-03','N','1','3','ดำ',1),(1223,'20190603182713','SKBL001เอว24-26สะโพก34-36ยาว15','กระโปรงน้ำเงินสั้น ขนนกกระจอกเทศ',1,1,300,500,'2019-06-03','N','1','3','น้ำเงิน',0),(1224,'20190603183054','DRBL001-38-35-48-F-53-F','เดรสเกาะอกสีฟ้าผ้าลายดอกไม้',1,1,500,1000,'2019-06-03','N','1','1','น้ำเงิน',0),(1225,'20190603183458','DRBL002-40-32-42-15-55-35','DRESS น้ำเงินแขนยาว ตกแต่งเปลือกหอย',1,1,500,1000,'2019-06-03','N','1','1','น้ำเงิน',0),(1226,'20190603183707','SHBL001-32F-F-F-16-24','เสื้อฟ้าลายจุด',1,1,350,700,'2019-06-03','N','1','2','น้ำเงิน',0),(1227,'20190603183956','SHBL002-36-30-F-14-21-21','เสื้อน้ำเงินแขนตกแต่งขนนกกระจอกเทศ',1,1,250,500,'2019-06-03','N','1','2','น้ำเงิน',0),(1228,'20190603184515','SKBL002-26-F-35','กระโปรง Dior น้ำเงิน',0,1,350,500,'2019-06-03','N','1','3','น้ำเงิน',1),(1229,'20190603184749','JSBL001-36-28-38-F-56-F','JUMPSUIT กางเกงขายาวน้ำเงินลายขวาง',2,1,450,700,'2019-06-03','N','1','9','น้ำเงิน',2),(1230,'20190603184935','DRBL003-F-F-F-F-50-F','DRESS ยาวสีฟ้าไล่สี',1,1,450,700,'2019-06-03','N','1','1','น้ำเงิน',1),(1231,'20190603193451','RRJSBRCHERRY001-34-28-36-F-44-F','JUMPSUIT กางเกงขายาวสีน้ำตาล เกาะอกลูกไม้ขาว',1,1,300,300,'2019-06-03','N','1','9','น้ำตาล',0),(1232,'20190603193618','RRDRPIBENZ001-34-F-F-F-45-F','เดรสสายเดี่ยวชมพูพลีท',1,1,450,600,'2019-06-03','N','1','1','ชมพู',1),(1233,'20190603194554','RRDRWHBENZ002-36-28-36-F-40-F','DRESS สีขาวแขนกุด',1,1,300,300,'2019-06-03','N','1','1','ขาว',0),(1234,'20190604130112','JSWH002-36-26-36-14-30-13กลิสเตอร์','JUMPSUIT ขาสั้นกลิสเตอร์สีเงิน',1,1,400,800,'2019-06-04','N','1','9','ขาว (เงิน',0),(1235,'20190604130425','SHPU001-34-30-F-F-28-Fอกเสื้อคลุม47','เสื้อคลุมสีม่วงพร้อมเสื้อซับสายเดี่ยว',1,1,250,300,'2019-06-04','N','1','2','ม่วง',0),(1236,'20190604130743','SHPU002-34-28-F-F-16-F','เสื้อสีม่วงคอกว้างผ้ามุ้ง',1,1,250,400,'2019-06-04','N','1','2','ม่วง',0),(1237,'20190604131057','DRWH001-34-28-36-14.5-37-22.5กลิสเตอร์สีเงิน','เดรสกลิสเตอร์สีเงิน',1,1,500,1000,'2019-06-04','N','1','1','ขาว กลิสเตอร์เงิน',0),(1238,'20190604131334','DRBR004-34-28-36-14.5-37-22.5กลิสเตอร์สีทอง','เดรสกลิสเตอร์สีทอง',0,1,500,1000,'2019-06-04','N','1','1','น้ำตาล กลิสเตอร์ทอง',2),(1239,'20190604131611','DRBR005-34-F-F-F-26-Fดิวทอง','เดรสดิวสีทอง',1,1,500,1000,'2019-06-04','N','1','1','น้ำตาล ทอง',0),(1240,'20190604131851','SKCR001-28-36-40','กระโปรงสีครีม ตกแต่งลูกไม้หน้าสีขาว',1,1,350,350,'2019-06-04','N','1','3','ครีม',0),(1241,'20190604132055','SHCR001-60-60-F-F-35-F','เสื้อคลุมผ้ามุ้งบางครีม กลิสเตอร์ดาวสีทอง',1,1,300,600,'2019-06-04','N','1','2','ครีม',0),(1242,'20190604132247','COBR001-34-28-F-15-43-22','เสื้อโค้ทลายเสือ',1,1,700,1000,'2019-06-04','N','1','10','น้ำตาล ลายเสือ',3),(1243,'20190604160923','SHBR001-34-F-F-16-11-19','เสื้อกลิสเตอร์สี pinkgold พร้อมเสื้อคลุม',1,1,300,500,'2019-06-04','N','1','2','น้ำตาล กลิสเตอร์pinkgold',0),(1244,'20190604161137','RRDRBRBENZ001-38-29-36-F-36-5','เดรสแขนล้ำสีทองมีพู่ระบายรอบตัว',1,1,400,600,'2019-06-04','N','1','1','น้ำตาล',0),(1245,'20190604161524','DRBR006-38-F-F-F-33-F','เดรสสายเดี่ยวน้ำตาล flat 2112',-1,1,450,900,'2019-06-04','N','1','1','น้ำตาล',6),(1246,'20190604161741','DRYE001-36-28-F-F-33-F','DRESS แขนกุดสีเหลืองชมพู คอตกแต่งลูกไม้ขาว',1,1,400,700,'2019-06-04','N','1','1','เหลืองชมพู',0),(1247,'20190604162019','SHYE001-34-28-F-15-27-20','เสื้อเชิ้ตบางสีเหลืองพร้อมกับเสื้อซับในสายเดี่ยวสีเหลือ',1,1,250,500,'2019-06-04','N','1','2','เหลือง',0),(1248,'20190604162304','SKBR001-26-F-35','กระโปรง DIOR ลายสีน้ำตาลแดง',1,1,350,500,'2019-06-04','N','1','3','น้ำตาลแดง',0),(1249,'20190604162510','DRYE002-42-F-F-17-47-23','เดรสสีเหลืองอินเดีย',1,1,350,500,'2019-06-04','N','1','1','เหลือง',2),(1250,'20190604162648','DRYE003-35-26-42-F-45-F','เดรสสายเดี่ยวสีเหลืองคอวีมีเชือกผูก',1,1,350,600,'2019-06-04','N','1','1','เหลือง',2),(1251,'20190604162850','SHYE002-36-30-F-14-12-F','เสื้อครอปแขนเดียวลายสีเหลือง',1,1,350,700,'2019-06-11','N','1','10','เหลือง',3),(1252,'20190604163152','SKBL003-26-34-30 มุ้งขาว','กระโปรงยีนส์ ซับในมุ้งสีขาว',1,1,350,700,'2019-06-04','N','1','3','น้ำเงิน',2),(1253,'20190604163347','SHOR001-38-F-F-F-หน้า18.5 หลัง48.5-F','เสื้อหน้าสั้น หลังยาวสีส้ม',1,1,300,600,'2019-06-04','N','1','2','ส้ม',0),(1254,'20190604163507','SHYE003-38-F-F-F-ยาวหน้า18.5 หลัง48.5-F','เสื้อหน้าสั้น หลังยาวสีเหลือง',1,1,300,600,'2019-06-04','N','1','2','เหลือง',2),(1255,'20190604163714','SKBL004-28-38-กปยีนส์ยาว14 มุ้งยาว36 (มุ้งเขียว','กระโปรงยีนส์สั้น ตกแต่งมุ้งเขียว',1,1,350,700,'2019-06-04','N','1','3','น้ำเงิน',0),(1256,'20190604163828','SKBL005-28-38-กปยีนส์ยาว14 มุ้งยาว36 (มุ้งชมพู)','กระโปรงยีนส์สั้นตกแต่งมุ้งชมพู',1,1,350,700,'2019-06-04','N','1','3','น้ำเงิน',0),(1257,'20190604163922','SKBL006-28-38-กปยีนส์ยาว14 มุ้งยาว36 (มุ้งสีรุ้ง)','กระโปรงยีนส์สั้น ตกแต่งมุ้งสีรุ้ง',0,1,350,700,'2019-06-04','N','1','3','',2),(1258,'20190604192301','JSBK001-34-F-F-F-F-F(S)','JUMPSUIT สีดำ ไหล่เฉียงระบาย Size S',1,1,400,800,'2019-06-04','N','1','9','ดำ',1),(1259,'20190604192442','JSBK001-36-F-F-F-F-F(M)','JUMPSUIT สีดำ ไหล่เฉียงระบาย Size M',1,1,400,800,'2019-07-08','N','1','9','ดำ',0),(1260,'20190605193633','RRDRRECHERRY001-36-28-38-F-36-F','DRESS ลูกไม้สีแดง size L',1,1,300,300,'2019-06-05','N','1','1','แดง',0),(1261,'20190605193825','RRDRBLCHERRY001-34-28-38-F-27-F','เดรสสีน้ำเงินคล้องคอ จับจีบหน้า',1,1,300,300,'2019-06-05','N','1','1','น้ำเงิน',0),(1262,'20190605193944','RRDRBLCHERRY002-36-28-F--F28-F','เดรสเกาะอกสีน้ำเงิน แต่งคลิบสีทอง',1,1,400,400,'2019-06-05','N','1','1','น้ำเงิน',0),(1263,'20190605194112','RRDRWHBENZ003-34-26-F-F-32-F','เดรสพองสีขาว ZARA',1,1,450,800,'2019-06-05','N','1','1','ขาว',0),(1264,'20190605194528','RRDRRECHERRY002-38-30-40-F-50-F','เดรสเกาะอกแดง ผ้ามุ้งยาว',1,1,300,300,'2019-06-05','N','1','1','แดง',0),(1265,'20190605194759','DRRE005-32-26-33-F-32-F','เดรสไหล่เฉียงแขนยาว ลายจุดแดง',1,1,500,900,'2019-06-09','N','1','1','แดงจุด',0),(1266,'20190605195006','RRDRWHBENZ004-33-26-F-F-35-F','เดรสขาวคอวี Jaspal',1,1,400,600,'2019-06-05','N','1','1','ขาว',0),(1267,'20190608183805','RRSKPIBENZ001-25-36-18(POEM SIZE36)','กระโปรงสั้นชั้นสีชมพูไล่ดำ POEM ',1,1,2300,6000,'2019-06-08','N','1','3','ชมพูไล่โทนดำ',0),(1268,'20190608184224','RRJSBKBENZ001-34-26-F-F-F-18 (POEMSIZE36)','เสื้อกำมะหยี่ดำแขนยาว POEM SIZE36',1,1,1500,3500,'2019-06-08','N','1','9','ดำ',0),(1269,'20190608184453','RRSHPIBENZ001-34-26-F-F-14-F (POEMSIZE36)','สายเดี่ยวคลอเซ็ทสีชมพู POEM SIZE36',1,1,1700,5000,'2019-06-08','N','1','2','ชมพู',0),(1270,'20190608184756','RRDRGYBENZ001-34-32-36-F-48-F(VARINTHORN)','เดรสฟรุ้งฟริ้งสีเทาวิรินทร ',1,1,2300,5000,'2019-06-08','N','1','1','เทา',1),(1271,'20190608185654','RRDRCRBENZ001-34-26-35-14-38-24 (LABOUTIQUE)','DRESS มุ้งพร้อมซับใน  Laboutique',1,1,1300,2500,'2019-06-08','N','1','1','ครีม',0),(1272,'20190608190656','RRJSBKBENZ002-34-27-38-F-33-F (LABOUTIQUE)','JUMPSUIT ขาสั้นสีดำ ',1,1,1200,2000,'2019-06-08','N','1','9','ดำ',0),(1273,'20190608190850','RRDRYEBENZ001-34-26-35-F-26-18 (LABOUTIQUE)','เดรสสีเหลือง',1,1,900,1000,'2019-06-08','N','1','1','เหลือง',0),(1274,'20190608191317','RRDRWHBENZ005-32-25-34-F-58-F (VARINTHORN)','DRESS สีขาว กระโปรงชั้น Varinthorn',1,1,1500,2500,'2019-06-08','N','1','1','ขาว',2),(1275,'20190608193013','ACGY001-คลัชขนสีเทา 7X4 inch','กระเป๋าคลัชขนนกกระจอกเทศสีเทา ขนาด 7\"X4\"',1,1,250,500,'2019-06-10','N','1','6','เทา',0),(1276,'20190608193227','ACCR001-กระเป๋าขนสีครีม 7X4 inch','กระเป่าคลัชขนนกกระจอกเทศสีครีม ขนาด 7\"X4\"',1,1,250,500,'2019-06-10','N','1','6','ครีม',0),(1277,'20190608193710','RRDRREBENZ003-36-28.5-39-F-25-F (VATANIKA UK12)','เดรสเกาะอกสีแดง vatanika size Uk12',1,1,1850,4000,'2019-06-08','N','1','1','แดง',0),(1278,'20190608193954','RRDRBKBENZ001-34-27-37.5-F-25-F (VATANIKA UK10)','เดรสเกาะอกลายดอก vatanika size uk10',1,1,1950,4000,'2019-06-08','N','1','1','ดำ',1),(1279,'20190608195037','RRSKBKBENZ001-เอว26-34 สะโพกฟรี ยาวชุด19.5 inch(L)','Tutu ดำสั้น size L',1,1,300,300,'2019-06-10','N','1','3','ดำ',0),(1280,'20190608195201','RRSKPUBENZ-เอว24-34 สะโพกฟรี ยาวชุด19 (M)','TUTU สั้น สีม่วง Size M',1,1,300,300,'2019-06-10','N','1','3','ม่วง',1),(1281,'20190608195315','RRSKCRBENZ001-เอว24-34 สะโพกฟรี ยาวชุด19(M)','tutu สั้นครีม',1,1,300,300,'2019-06-10','N','1','3','ครีม',0),(1282,'20190608195834','RRSKBLBENZ001-เอว25-33สะโพกฟรี ยาว32.5','tutu ชั้นยาว น้ำเงิน',1,1,400,400,'2019-06-10','N','1','3','น้ำเงิน',0),(1283,'20190609165430','RRACCRBENZ001-หมวกปีกกว้าง','หมวกปีกกว้าง',1,1,300,600,'2019-06-09','N','1','6','ครีม',0),(1284,'20190609170232','RRDRREBENZ004-อก32-40 เอว24-40 สะโพก F-17-40-20','เดรสสีแดง ถ่วงหลัง',1,1,400,400,'2019-06-09','N','1','1','แดง',2),(1285,'20190609170701','RRDRREBENZ005-34-28-F-13-47.5-20','DRESS แดงมีฮู้ด ',1,1,400,400,'2019-06-09','N','1','1','แดง',0),(1286,'20190609170946','RRDRWHBENZ006-34-26-F-14-49.5-15','เดรสยาวสีขาว',1,1,400,400,'2019-06-09','N','1','1','ขาว',0),(1287,'20190609172040','DRPI004-32-26-34-F-32-14','เดรสชมพูผ้ามัน มีแขน 1 ข้าง อีกข้างเป็นสายเดี่ยว',1,1,800,1500,'2019-06-09','N','1','1','ชมพู',1),(1288,'20190611183641','RRDRWHCHERRY007-36-28-F-F-49-F','DRESS สีขาว ',1,1,300,300,'2019-06-11','N','1','1','ขาว',0),(1289,'20190611183811','RRDRBKCHERRY002-34-28-F-F-35-17','เดรสสีดำ กระโปรงลาย',1,1,300,300,'2019-06-11','N','1','1','ดำ',0),(1290,'20190611184007','RRACWHBENZ-กระเป๋ากลมขาวลายดอกไม้','กระเป๋ากลมขาวลายดอกไม้',1,1,200,300,'2019-06-11','N','1','6','ขาว',0),(1291,'20190611184206','RRACBRBENZ-กระเป๋าถือเพชรสีทอง','กระเป๋าสีทองทรงตระกร้าประดับเพชร',1,1,300,500,'2019-06-11','N','1','6','ทอง',0),(1292,'20190611184414','RRACBKBENZ-กระเป๋าคลัชสีดำประดับเพชร','กระเป๋าคลัชสีดำประดับเพชร',1,1,300,300,'2019-06-11','N','1','6','ดำ',0),(1293,'20190619200805','DRPI005 ชมพูขนนก','เดรสชมพูสั้นขนนก',1,1,800,800,'2019-06-19','N','1','1','ชมพู',1),(1294,'20190619201006','DRBK008 เดรสสุ่มผีเสื้อ32-26-F-F-26.5-F','เดรสสุ่มผีเสื้อ',1,1,800,800,'2019-06-23','N','1','1','ดำ',1),(1295,'20190621112344','ค่าส่ง70','',999,1000,70,0,'2019-08-23','N','1','10','',12),(1296,'20190622145321','JSPI001-ALICEMCCALL','JUMPSUIT กางเกง สีชมพู Brand alice mccall',1,1,1200,1200,'2019-06-22','N','1','9','ชมพู',1),(1297,'20190622145704','DRBL004-32-26-F-F-42.5-F','DRESS ลูกไม้ไล่สี สไตล์ selfportrait',1,1,500,500,'2019-06-23','N','1','1','น้ำเงิน ฟ้า',0),(1298,'20190622145939','DRYE004','เดรสยาวสีเหลืองอ่อน ลายดอกไม้',1,1,400,400,'2019-06-22','N','1','1','เหลืองอ่อน',0),(1299,'20190622150223','DRPI006 ','เดรสสีชมพูลายดอกไม้สีแดง เว้าหลัง',1,1,400,400,'2019-06-22','N','1','1','ชมพู',1),(1300,'20190622150606','RRDRWHBENZ007-HERLAFEMME37-30-36-F-28.5-F','เดรสสั้นสีเงิน สายเดี่ยว  BRAND HERLAFEMME',1,1,350,350,'2019-06-23','N','1','1','เงิน',0),(1301,'20190622151132','DRWH002-FIFTH GARDEN 34-28-37-F-33-F','DRESS เกาะอกลูกไม้สีขาว BRAND FIFTH GARDEN',1,1,500,500,'2019-06-23','N','1','1','ขาว',0),(1302,'20190622151402','DRBL005-SRETSIS 34-27-40-14-31-21.5','DRESS SRETSIS สีฟ้า ดำ',1,1,600,600,'2019-06-23','N','1','1','ฟ้า ดำ',0),(1303,'20190622151858','DRWH003-VICKTEERUT','DRESS สั้นสีเงิน BRAND VICKTEERUT',1,1,600,600,'2019-06-22','N','1','1','เงิน',0),(1304,'20190622152223','DRPU001-SELFPORTRAIT34-26-F-F-43.5-F','DRESS สีม่วงอ่อน BRAND SELFPORTRAIT',1,1,1500,1500,'2019-06-23','N','1','1','ม่วงอ่อน',0),(1305,'20190622152531','DRPI007-MILIN 32-27-36-F-25-F','เดรสสั้นสายเดี่ยว สีชมพู BRAND MILIN',1,1,500,500,'2019-06-23','N','1','1','ชมพู',0),(1306,'20190622153206','SKPI002-POEM 26-F-26.5','กระโปรง POEM สีชมพูลายสีเงิน',1,1,2000,2000,'2019-06-23','N','1','3','ชมพู',0),(1307,'20190622153856','JSBK002-VATANIKA34-26-35-F-59-F','Jumpsuit กางเกงขายาวสีดำ แขนกุด BRAND VATANIKA',1,1,1200,1200,'2019-06-23','N','1','9','ดำ',0),(1308,'20190622154149','JSGY002','JUMPSUIT กางเกงขายาวสีเทา มีตกแต่งผ้าด้านหลัง',1,1,500,500,'2019-06-22','N','1','9','เทา',0),(1309,'20190622154415','DRWH004 34-26-F-F-44-F','เดรสสายเดี่ยวสีขาว ลายดอกไม้',1,1,400,400,'2019-06-23','N','1','1','ขาว',2),(1310,'20190622154749','DRPI008-HAATIYA 32-33,26-27,35-36 SIZE S','เดรสสีชมพู เกาะอก แขนพอง BRAND HAATIYA',2,1,1000,2000,'2019-06-22','N','1','1','ชมพูนู้ด',5),(1311,'20190622154949','DRGY003-HAATIYA 34-35,28-29,37-38 SIZE M','เดรสเกาะอก แขนพอง BRAND HAATIYA สีเทา',1,1,1000,2000,'2019-06-22','N','1','1','เทา',0),(1312,'20190623185637','RRDRREBENZ006-MISISY 38-30-38-F-49-F','DRESS แขนกุดแดง BRAND MISISY',1,1,350,350,'2019-06-23','N','1','1','แดง',1),(1313,'20190623190437','RRJSBKBENZ003-M2SPOP-38-30-36-F-22.5-14','JUMPSUIT ขาสั้นสีดำ BRAND M2SPOP',1,1,300,300,'2019-06-23','N','1','9','ดำ',0),(1314,'20190627144820','RRCOPIBENZ001','เสื้อคลุมชมพูยาว',1,1,450,450,'2019-06-27','N','1','10','ชมพู',2),(1315,'20190703190436','RRACGRBENZ001-กระเป๋าขนนกกระจอกเทศเขียว','กระเป๋าขนนกกระจอกเทศสีเขียว',1,1,450,450,'2019-08-01','N','1','6','เขียว',1),(1316,'20190704213026','RRDRPIBENZ002','ชุดเสื้อ + กระโปรง สีชมพู ลายจุด',1,1,450,450,'2019-07-04','N','1','1','ชมพูลายจุด',2),(1317,'20190714163704','DRBL006-FLAT2112','เดรสยาวสีฟ้าขาว Flat 2112',2,1,350,500,'2019-07-14','N','1','1','ฟ้า',4),(1318,'20190721185408','ค่าส่ง80','',999,1000,80,0,'2019-08-23','N','1','10','',6),(1319,'20190801121644','RRACPIBENZ001-กระเป๋าขนนกกระจอกเทศสีชมพู','กระเป๋าขนนกกระจอกเทศสีชมพู',1,1,450,450,'2019-08-01','N','1','6','ชมพู',1),(1320,'20190801130437','RRSKBLBENZ002-กระโปรงยีนส์มุ้งขาว L เอว30 สะโพก 39','กระโปรงยีนส์สั้นตกแต่งมุ้งขาว',1,1,350,350,'2019-08-01','N','1','3','น้ำเงิน มุ้งขาว',2),(1321,'20190810191201','RRACGRBENZ001-กระเป๋าขนนกกระจอกเทศแดง','',1,1,450,450,'2019-08-10','N','1','6','แดง',0),(1322,'20190810191402','RRDROR001พี่เบซ์','เดรสสายรุ้งพี่เบนซ์',1,1,350,350,'2019-08-10','N','1','1','ส้ม',1),(1323,'20190818121910','DROR002-34-26-F-F-F','DROR002-34-26-F-F-F เดรสส้ม',1,1,450,450,'2019-08-18','N','1','1','ส้ม',0),(1324,'20190819162540','RYSKPI001-30-F-34','RYSKPI001-30-F-34',0,1,250,250,'2019-08-19','N','1','3','ชมพู',1),(1325,'20190819162727','RYSKPI002-30-F-34','RYSKPI002-30-F-34',1,1,250,250,'2019-08-19','N','1','3','ชมพู',0),(1326,'20190819163039','RRDRWHCHERRY008-42-40-42-38-34.5-24','RRDRWHCHERRY008-42-40-42-38-34.5-24',1,1,300,300,'2019-08-19','N','1','10','ขาว',0),(1327,'20190819163550','RRDRRECHERRY003-42-40-40-42-37.5-13','RRDRRECHERRY003-42-40-40-42-37.5-13',1,1,300,300,'2020-01-08','N','1','1','ดำ',0),(1328,'20190823141753','DRGY004 2XL-48-40-50','DRGY004-48-40-50อกไม่เกิน48 เอวไม่เกิน40สะโพกไม่เกิน50',1,1,500,500,'2019-08-23','N','1','1','เทา',0),(1329,'20190823141928','DRBR007 2XL-48-40-50','DRBR004-48-40-50อกไม่เกิน48 เอวไม่เกิน40สะโพกไม่เกิน50',1,1,500,500,'2019-08-23','N','1','1','น้ำตาล',0),(1330,'20190823143444','DRBL007L-36/40-30/32-36/40','DRBL007L-36/40-30/32-36/40 \r\nL อก36-30-40 อก36ยืดได้ถึง40 เอวยืดถึง32 สะโพกยืดถึง40',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1331,'20190823144301','DRRE006L-36/40-30/32-36/40','DRRE006L-36/40-30/32-36/40',1,1,500,500,'2019-08-23','N','1','1','แดง',0),(1332,'20190823145312','DRBR008 2XL-42-34-44','DRBR008 2XL-42-34-44',1,1,500,500,'2019-08-23','N','1','1','น้ำตาล',0),(1333,'20190823145438','DRPI009 2XL-42-34-44','DRPI009 2XL-42-34-44',1,1,500,500,'2019-08-23','N','1','1','ชมพู',0),(1334,'20190823145542','DRGY005 2XL-42-34-44','DRPI005 2XL-42-34-44',1,1,500,500,'2019-08-23','N','1','1','เทา',0),(1335,'20190823150122','DRPI010 2XL-40-34-44',' 2XL-40-34-44',1,1,500,500,'2019-08-23','N','1','1','ชมพู',0),(1336,'20190823150259','DRRE007 2XL-40-34-44','DRPI010 2XL-40-34-44',1,1,500,500,'2019-08-23','N','1','1','แดง',0),(1337,'20190823150408','DRBL008 2XL-40-34-44','DRBL008 2XL-40-34-44',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1338,'20190823151005','DRPI011 4XL-44-38-46','DRPI011 4XL-44-38-46',1,1,500,500,'2019-08-23','N','1','1','ชมพู',0),(1339,'20190823151130','DRBL009 4XL-44-38-46','DRBL009 4XL-44-38-46',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1340,'20190823151254','DRRE008 4XL-44-38-46','DRRE008 4XL-44-38-46',1,1,500,500,'2019-08-23','N','1','1','แดง',0),(1341,'20190823151743','DRBR009 4XL-44-38-46','DRBR009 4XL-44-38-46',1,1,500,500,'2019-08-23','N','1','1','น้ำตาล',0),(1342,'20190823152921','DRPI012 2XL-42-34-44','DRPI012 2XL-42-34-44',1,1,500,500,'2019-08-23','N','1','1','ชมพู',0),(1343,'20190823153155','DRGY006 2XL-42-34-44','DRGY006 2XL-42-34-44',1,1,500,500,'2019-08-23','N','1','1','เทา',0),(1344,'20190823153335','DRBL010 2XL-42-34-44','DRBL006 2XL-42-34-44',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1345,'20190823153803','DRBL011 4XL-44-38-46','DRBL011 4XL-44-38-46',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1346,'20190823154307','JSBK003-33-26-33','JSBK003-33-26-33 ชุดดำมีสายคล้องดอก ลายจุด',1,1,350,350,'2019-08-23','N','1','9','ดำ',0),(1347,'20190823190148','DRBR010-34/36-28-36','DRBR010-34/36-28-36 เดรสเกาะอก ขนนกน้ำตาล',1,1,500,500,'2019-08-23','N','1','1','น้ำตาล',0),(1348,'20190823190408','DRBL012-34/36-28-36','DRBL012-34/36-28-36 เดรสเกาะอกขนนก',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1349,'20190823190713','DRBL013-36/38-28/30-36/38','DRBL013-36/38-28/30-36/38 เดรสน้ำเงินกำมะหยี่สั้น',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1350,'20190823191148','DRBL014-36/40-3/32-40','DRBL014-36/40-3/32-40 เดรสแขนเดี่ยวมุก',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1351,'20190823191304','DRPI012-36/40-30/32-40','DRPI012-36/40-30/32-40 เดรสแขนเดี่ยวมุก ชมพูกรีบบัว',1,1,500,500,'2019-08-23','N','1','1','ชมพู',0),(1352,'20190823191429','DRRE009-36/40-30/32-40','DRRE009-36/40-30/32-40เดรสแดงแขนเดี่ยวมุก',1,1,500,500,'2019-08-23','N','1','10','แดง',0),(1353,'20190823191751','DRRE010-34-26/28-34/36','DRRE010-34-26/28-34/36',1,1,500,500,'2019-08-23','N','1','1','แดง',0),(1354,'20190823192023','DRPI013-34-26/28-34/36','DRPI013-34-26/28-34/36',1,1,500,500,'2019-08-23','N','1','1','ชมพู',0),(1355,'20190823192441','DRRE011-36/40-30/32-40','DRRE011-36/40-30/32-40 เดรสโซ่ซ้าย ไหล่เดี่ยว',1,1,500,500,'2019-08-23','N','1','1','แดง',0),(1356,'20190823192538','DROR003-36/40-30/32-40 ','DROR003-36/40-30/32-40 เดรสโซ่ซ้าย ไหล่เดี่ยว',0,1,500,500,'2019-08-23','N','1','1','ส้ม',1),(1357,'20190823192640','DRBL015-36/40-30/32-40 ','DRBL015-36/40-30/32-40 เดรสโซ่ซ้าย ไหล่เดี่ยว',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1358,'20190823192827','DRPI014-36/40-30/32-40 เดรสโซ่ซ้าย ไหล่เดี่ยว','DRPI014-36/40-30/32-40 เดรสโซ่ซ้าย ไหล่เดี่ยว',1,1,500,500,'2019-08-23','N','1','1','ชมพู',0),(1359,'20190823193512','DRRE012-34/38-26/28-34/38','DRRE012-34/38-26/28-34/38',1,1,500,500,'2019-08-23','N','1','1','แดง',0),(1360,'20190823193648','DRBL016-34/38-26/28-34/38','DRBL016-34/38-26/28-34/38',1,1,500,500,'2019-08-23','N','1','1','น้ำเงิน',0),(1361,'20190825183510','DROR004-36-29-F','DROR004-36-29-F',1,1,500,500,'2019-08-25','N','1','1','ส้ม',0),(1362,'20190825183659','DRRE013-36-29-F','DRRE013-36-29-F',1,1,500,500,'2019-08-25','N','1','1','แดง',0),(1363,'20190825183824','DRBL017-36-29-F','DRBL017-36-29-F',1,1,500,500,'2019-08-25','N','1','1','น้ำเงิน',0),(1364,'20200105111036','ค่าส่ง','',101,1000,100,0,'2020-01-05','N','1','10','',2),(1365,'20200108143107','RRSKWH001','RRSKWH001',1,1,350,350,'2020-01-08','N','1','3','ขาว',0),(1366,'20200108143226','RRLPWH001','RRLPWH001',1,1,350,350,'2020-01-08','N','1','5','ขาว',0),(1367,'20200108143312','RRDRGY002','RRDRGY002',1,1,350,350,'2020-01-08','N','1','1','1',0),(1368,'20200108143405','RRDRBL003','RRDRBL003',1,1,350,350,'2020-01-08','N','1','1','น้ำเงิน',0),(1369,'20200108143512','RRDRCR002','RRDRCR002',1,1,350,350,'2020-01-08','N','1','1','ครีม',0),(1370,'20200108143658','RRDRCR003','RRDRCR003',1,1,350,350,'2020-01-08','N','1','1','ครีม',0),(1371,'20200108143739','RRDRCR004','RRDRCR004',1,1,350,350,'2020-01-08','N','1','1','ครีม',1),(1372,'20200108143837','RRDRGY003','RRDRGY003',1,1,350,350,'2020-01-08','N','1','1','เทา',0),(1373,'20200108144050','RRDRWH009-เกาะอก','RRDRWH009',1,1,350,350,'2020-01-08','N','1','1','ขาว',0),(1374,'20200108144152','RRDRRE008','RRDRRE008',1,1,350,350,'2020-01-08','N','1','1','แดง',0),(1375,'20200108144229','RRDRPI003','RRDRPI003',1,1,350,350,'2020-01-08','N','1','1','ชมพู',0),(1376,'20200108144328','RRDRGY004','RRDRGY004',1,1,350,350,'2020-01-08','N','1','1','เทา',0),(1377,'20200207161930','EXTRA-ส่วนเกิน4 วัน 50/วัน','EXTRA-ส่วนเกิน4 วัน 50/วัน',1004,1000,50,0,'2020-02-07','N','1','10','ดำ',1);
/*!40000 ALTER TABLE `tb_instock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_order_update`
--

DROP TABLE IF EXISTS `tb_order_update`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_order_update` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `descript` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `date_update` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `orderid` int(11) NOT NULL,
  `is_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_order_update`
--

LOCK TABLES `tb_order_update` WRITE;
/*!40000 ALTER TABLE `tb_order_update` DISABLE KEYS */;
INSERT INTO `tb_order_update` VALUES (23,'note','test by p.benz','2019-07-13 11:48:29',1303,'2019-07-13 11:48:29'),(24,'cancel','covid - 19  ยกเลิกแล้ว 2 รอบ','2020-03-11 19:38:32',1350,'2020-03-11 19:38:32');
/*!40000 ALTER TABLE `tb_order_update` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_payment`
--

DROP TABLE IF EXISTS `tb_payment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rent_id` int(11) NOT NULL,
  `type_pay` varchar(255) NOT NULL,
  `in_pay` int(11) NOT NULL,
  `is_date` varchar(255) NOT NULL,
  `name_in` int(11) NOT NULL,
  `payment` varchar(1) NOT NULL,
  `date_pay` date NOT NULL,
  `payment_des` text NOT NULL,
  `blank` varchar(1) NOT NULL,
  `blank_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2535 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_payment`
--

LOCK TABLES `tb_payment` WRITE;
/*!40000 ALTER TABLE `tb_payment` DISABLE KEYS */;
INSERT INTO `tb_payment` VALUES (2325,1283,'1',350,'2019-06-10 18:01:39',15,'2','2019-06-10','','3',''),(2326,1284,'1',2100,'2019-06-11 11:22:53',9,'2','2019-06-10','','3',''),(2327,1284,'2',0,'2019-06-12 11:10:01',9,'1','2019-06-12','','1',''),(2328,1285,'1',450,'2019-06-13 21:32:26',9,'2','2019-06-13','','3',''),(2329,1286,'1',400,'2019-07-01 11:51:00',9,'2','2019-06-13','','1',''),(2330,1283,'2',350,'2019-06-14 11:23:35',9,'2','2019-06-14','','3',''),(2331,1287,'1',350,'2019-06-14 13:20:54',9,'1','2019-06-14','','1',''),(2332,1288,'1',0,'2019-06-21 12:15:23',9,'1','2019-06-14','','1',''),(2333,1289,'1',0,'2019-07-09 11:55:50',9,'1','2019-06-14','','1',''),(2334,1287,'2',0,'2019-06-14 15:15:21',9,'1','2019-06-14','','1',''),(2335,1290,'1',900,'2019-06-14 16:43:57',9,'2','2019-06-14','','3',''),(2336,1290,'2',0,'2019-06-17 11:45:15',9,'1','2019-06-17','','1',''),(2337,1291,'1',700,'2019-06-19 11:33:48',9,'2','2019-06-19','','3',''),(2338,1291,'2',0,'2019-06-19 17:53:30',9,'1','2019-06-19','','1',''),(2339,1292,'1',1080,'2019-06-19 19:56:20',9,'2','2019-06-19','','3',''),(2340,1293,'1',1840,'2019-06-19 20:14:57',9,'2','2019-06-19','','3',''),(2341,1294,'1',340,'2019-06-21 11:29:07',9,'2','2019-06-21','','3',''),(2342,1295,'1',0,'2019-06-24 17:26:04',9,'1','2019-06-24','','1',''),(2343,1296,'1',450,'2019-06-24 17:32:50',9,'1','2019-06-24','','1',''),(2344,1296,'2',0,'2019-06-25 13:30:46',9,'1','2019-06-25','','1',''),(2345,1295,'2',0,'2019-06-25 13:30:55',9,'1','2019-06-25','','1',''),(2346,1297,'1',1800,'2019-06-27 16:12:35',7,'2','2019-06-27','','3',''),(2347,1292,'2',0,'2019-06-28 11:14:14',9,'1','2019-06-28','','1',''),(2348,1296,'3',0,'2019-06-30 19:01:58',9,'1','2019-06-30','','1',''),(2349,1295,'3',0,'2019-06-30 19:02:09',9,'1','2019-06-30','','1',''),(2350,1291,'3',0,'2019-06-30 19:02:28',9,'1','2019-06-30','','1',''),(2351,1290,'3',600,'2019-06-30 19:02:33',9,'1','2019-06-30','','1',''),(2352,1287,'3',0,'2019-06-30 19:02:47',9,'1','2019-06-30','','1',''),(2353,1284,'3',1400,'2019-06-30 19:02:51',9,'1','2019-06-30','','1',''),(2354,1283,'3',350,'2019-06-30 19:02:56',9,'1','2019-06-30','','1',''),(2355,1298,'1',718,'2019-07-01 12:48:29',9,'2','2019-07-01','','3',''),(2356,1297,'2',0,'2019-07-01 12:54:15',9,'1','2019-07-01','','1',''),(2357,1299,'1',750,'2019-07-03 12:57:59',9,'2','2019-07-03','','3',''),(2358,1298,'2',0,'2019-07-03 16:41:07',9,'1','2019-07-03','','1',''),(2359,1300,'1',800,'2019-07-03 19:07:02',9,'1','2019-07-03','','1',''),(2360,1301,'1',5700,'2019-07-04 22:10:28',15,'2','2019-07-04','','3',''),(2361,1301,'2',0,'2019-07-04 22:50:17',15,'1','2019-07-04','','1',''),(2362,1302,'1',650,'2019-07-05 11:39:20',9,'2','2019-07-05','','3',''),(2363,1299,'2',0,'2019-07-05 11:44:53',9,'1','2019-07-05','','1',''),(2364,1294,'2',470,'2019-07-05 14:21:35',9,'2','2019-07-05','','3',''),(2365,1293,'2',0,'2019-07-05 16:48:55',9,'1','2019-07-05','','1',''),(2366,1300,'2',800,'2019-07-05 17:40:11',9,'2','2019-07-05','','3',''),(2367,1292,'3',0,'2019-07-06 18:47:51',11,'1','2019-07-06','','1',''),(2368,1297,'3',900,'2019-07-06 18:48:38',11,'1','2019-07-06','','1',''),(2369,1300,'3',800,'2019-07-08 16:40:05',11,'1','2019-07-08','','1',''),(2370,1302,'2',0,'2019-07-09 11:54:24',11,'1','2019-07-09','','1',''),(2371,1289,'2',0,'2019-07-09 11:56:05',11,'1','2019-07-09','','1',''),(2372,1303,'1',650,'2019-07-13 11:47:33',11,'2','2019-07-13','','3',''),(2373,1304,'1',350,'2019-07-14 16:50:22',11,'2','2019-07-13','','3',''),(2374,1301,'3',2850,'2019-07-15 14:35:35',7,'1','2019-07-15','','1',''),(2375,1299,'3',350,'2019-07-15 14:37:03',7,'1','2019-07-15','','1',''),(2376,1298,'3',350,'2019-07-15 14:37:13',7,'1','2019-07-15','','1',''),(2377,1305,'1',2500,'2019-07-16 18:21:51',11,'2','2019-07-16','','3',''),(2378,1306,'1',780,'2019-07-21 18:57:08',11,'2','2019-07-21','','3',''),(2379,1285,'2',900,'2019-07-21 19:00:32',11,'1','2019-07-21','','1',''),(2380,1305,'2',0,'2019-07-21 19:00:53',11,'1','2019-07-21','','1',''),(2381,1288,'2',0,'2019-07-21 19:01:08',11,'1','2019-07-21','','1',''),(2382,1294,'3',400,'2019-07-21 23:24:40',7,'1','2019-07-21','','1',''),(2383,1306,'2',0,'2019-07-22 17:30:02',11,'1','2019-07-22','','1',''),(2384,1302,'3',300,'2019-07-23 10:06:06',15,'1','2019-07-23','','1',''),(2385,1307,'1',830,'2019-07-23 11:29:23',9,'2','2019-07-23','','3',''),(2386,1305,'3',1500,'2019-07-23 17:51:32',15,'1','2019-07-23','','1',''),(2387,1305,'3',1500,'2019-07-23 17:51:38',15,'1','2019-07-23','','1',''),(2388,1308,'1',400,'2019-07-25 17:55:15',15,'2','2019-07-24','','3',''),(2389,1309,'1',570,'2019-07-25 18:01:44',15,'2','2019-07-25','','3',''),(2390,1304,'2',500,'2019-07-26 11:17:40',9,'2','2019-07-26','','3',''),(2391,1309,'2',0,'2019-07-26 11:17:55',9,'1','2019-07-26','','1',''),(2392,1307,'2',0,'2019-07-26 11:18:16',9,'1','2019-07-26','','1',''),(2393,1308,'2',400,'2019-07-26 17:30:18',9,'1','2019-07-26','','1',''),(2394,1285,'3',900,'2019-07-28 15:40:53',9,'1','2019-07-28','','1',''),(2395,1289,'3',0,'2019-07-28 15:41:20',9,'1','2019-07-28','','1',''),(2396,1310,'1',750,'2019-08-01 13:06:27',15,'2','2019-07-31','','3',''),(2397,1311,'1',900,'2019-08-01 12:19:06',15,'2','2019-07-31','','3',''),(2398,1312,'1',350,'2019-09-07 18:47:52',15,'2','2019-08-01','','3',''),(2399,1304,'3',500,'2019-08-04 14:09:59',11,'1','2019-08-04','','1',''),(2400,1304,'3',500,'2019-08-04 14:10:49',11,'1','2019-08-04','','1',''),(2401,1293,'3',0,'2019-08-04 19:22:58',11,'1','2019-08-04','','1',''),(2402,1308,'3',400,'2019-08-04 19:23:44',11,'1','2019-08-04','','1',''),(2403,1307,'3',400,'2019-08-04 19:24:38',11,'1','2019-08-04','','1',''),(2404,1309,'3',250,'2019-08-04 19:24:48',11,'1','2019-08-04','','1',''),(2405,1313,'1',900,'2019-08-05 11:55:17',9,'2','2019-08-04','','3',''),(2406,1303,'2',-350,'2019-08-05 14:54:25',9,'1','2019-08-05','','1',''),(2407,1313,'2',0,'2019-08-05 14:54:50',9,'1','2019-08-05','','1',''),(2408,1314,'1',1400,'2019-08-06 20:56:03',7,'2','2019-08-06','','3',''),(2409,1311,'2',0,'2019-08-07 11:18:48',9,'1','2019-08-07','','1',''),(2410,1310,'2',0,'2019-08-07 11:19:08',9,'1','2019-08-07','','1',''),(2411,1315,'1',700,'2019-08-07 13:15:41',9,'2','2019-08-07','','1',''),(2412,1316,'1',970,'2019-08-09 11:22:13',9,'2','2019-08-09','','3',''),(2413,1314,'2',0,'2019-08-09 11:24:57',9,'1','2019-08-09','','1',''),(2414,1316,'2',0,'2019-08-09 11:25:02',9,'1','2019-08-09','','1',''),(2415,1303,'3',-150,'2019-08-09 19:18:10',9,'1','2019-08-09','','1',''),(2416,1288,'3',0,'2019-08-09 19:18:21',9,'1','2019-08-09','','1',''),(2417,1317,'1',900,'2019-08-12 14:38:00',7,'2','2019-08-12','','3',''),(2418,1315,'2',0,'2019-08-13 11:41:08',9,'1','2019-08-13','','1',''),(2419,1316,'3',450,'2019-08-13 19:07:16',9,'1','2019-08-13','','1',''),(2420,1315,'3',350,'2019-08-13 19:07:21',9,'1','2019-08-13','','1',''),(2421,1314,'3',700,'2019-08-13 19:07:27',9,'1','2019-08-13','','1',''),(2422,1311,'3',450,'2019-08-13 19:07:34',9,'1','2019-08-13','','1',''),(2423,1318,'1',820,'2019-08-14 15:10:20',9,'2','2019-08-14','','3',''),(2424,1319,'1',800,'2019-08-19 14:21:01',11,'2','2019-08-19','','3',''),(2425,1318,'2',0,'2019-08-19 14:24:33',11,'1','2019-08-19','','1',''),(2426,1310,'3',350,'2019-08-19 17:50:17',7,'1','2019-08-19','','1',''),(2427,1319,'2',0,'2019-08-19 18:40:32',7,'1','2019-08-19','','1',''),(2428,1320,'1',970,'2019-08-21 11:18:33',9,'2','2019-08-21','','3',''),(2429,1321,'1',1400,'2019-08-27 11:53:50',11,'2','2019-08-26','','1',''),(2430,1322,'1',760,'2019-08-30 13:57:15',11,'2','2019-08-30','','3',''),(2431,1319,'3',400,'2019-08-30 19:36:47',11,'1','2019-08-30','','1',''),(2432,1322,'2',0,'2019-09-09 18:01:53',11,'1','2019-09-09','','1',''),(2433,1321,'2',0,'2019-09-09 18:02:01',11,'1','2019-09-09','','1',''),(2434,1317,'2',0,'2019-09-09 18:02:06',11,'1','2019-09-09','','1',''),(2435,1286,'2',400,'2019-09-09 18:02:49',11,'2','2019-09-09','','3',''),(2436,1320,'2',0,'2019-09-09 18:03:07',11,'1','2019-09-09','','1',''),(2437,1312,'2',410,'2019-09-09 18:03:13',11,'1','2019-09-09','','1',''),(2438,1323,'1',1150,'2019-09-11 15:51:51',11,'1','2019-09-11','','3',''),(2439,1324,'1',860,'2019-09-13 11:57:57',11,'2','2019-09-13','','3',''),(2440,1324,'2',0,'2019-09-14 14:19:19',11,'1','2019-09-14','','1',''),(2441,1322,'3',350,'2019-09-15 19:05:35',11,'1','2019-09-15','','1',''),(2442,1313,'3',450,'2019-09-15 19:05:46',11,'1','2019-09-15','','1',''),(2443,1317,'3',450,'2019-09-15 19:06:02',11,'1','2019-09-15','','1',''),(2444,1323,'2',1150,'2019-09-18 15:28:31',11,'1','2019-09-18','','1',''),(2445,1324,'3',350,'2019-09-25 19:31:26',11,'1','2019-09-25','','1',''),(2446,1323,'3',1150,'2019-09-27 19:04:29',11,'1','2019-09-27','','1',''),(2447,1321,'3',0,'2019-09-27 19:04:48',11,'1','2019-09-27','','1',''),(2448,1318,'3',400,'2019-09-27 19:04:56',11,'1','2019-09-27','','1',''),(2449,1312,'3',350,'2019-09-27 19:05:06',11,'1','2019-09-27','','1',''),(2450,1286,'3',400,'2019-09-27 19:05:14',11,'1','2019-09-27','','1',''),(2451,1320,'3',450,'2019-09-27 19:05:28',11,'1','2019-09-27','','1',''),(2452,1325,'1',700,'2019-09-29 16:17:13',7,'1','2019-09-29','','1',''),(2453,1326,'1',0,'2019-10-05 19:42:27',11,'1','2019-10-05','','1',''),(2454,1327,'1',0,'2019-10-13 12:16:44',11,'1','2019-10-06','','1',''),(2455,1325,'3',350,'2019-10-07 18:45:45',11,'1','2019-10-07','','1',''),(2456,1328,'1',900,'2019-10-09 18:31:15',11,'2','2019-10-09','','3',''),(2457,1329,'1',0,'2019-10-09 18:41:28',11,'1','2019-10-09','','1',''),(2458,1330,'1',560,'2019-10-13 14:56:31',9,'2','2019-10-13','','3',''),(2459,1331,'1',1260,'2019-10-14 18:26:05',7,'2','2019-10-14','','3',''),(2460,1328,'3',450,'2019-10-20 16:16:53',7,'1','2019-10-20','','1',''),(2461,1328,'3',450,'2019-10-20 16:19:45',7,'1','2019-10-20','','1',''),(2462,1331,'3',630,'2019-10-21 17:20:22',7,'1','2019-10-21','','1',''),(2463,1327,'3',0,'2019-10-24 17:26:03',7,'1','2019-10-24','','1',''),(2464,1332,'1',1000,'2019-11-04 11:11:57',11,'2','2019-11-04','','3',''),(2465,1333,'1',700,'2019-11-04 19:47:49',15,'1','2019-11-04','','1',''),(2466,1334,'1',800,'2019-11-06 15:28:04',7,'2','2019-11-06','','1',''),(2467,1329,'2',0,'2019-11-08 11:16:48',9,'1','2019-11-08','','1',''),(2468,1330,'2',0,'2019-11-08 11:17:00',9,'1','2019-11-08','','1',''),(2469,1326,'2',0,'2019-11-08 11:17:09',9,'1','2019-11-08','','1',''),(2470,1333,'2',0,'2019-11-08 11:17:14',9,'1','2019-11-08','','1',''),(2471,1332,'2',0,'2019-11-08 11:17:29',9,'1','2019-11-08','','1',''),(2472,1335,'1',2400,'2019-11-08 11:24:41',9,'2','2019-11-07','','3',''),(2473,1336,'1',1000,'2019-11-08 18:33:18',7,'2','2019-11-08','','1',''),(2474,1337,'1',300,'2019-11-08 18:55:28',7,'1','2019-11-08','','1',''),(2475,1333,'3',350,'2019-11-11 19:37:54',7,'1','2019-11-11','','1',''),(2476,1326,'3',0,'2019-11-11 19:38:01',7,'1','2019-11-11','','1',''),(2477,1329,'3',0,'2019-11-11 19:38:15',7,'1','2019-11-11','','1',''),(2478,1332,'3',500,'2019-11-11 19:38:27',7,'1','2019-11-11','','1',''),(2479,1338,'1',900,'2019-11-13 15:37:13',11,'2','2019-11-13','','3',''),(2480,1337,'2',0,'2019-11-13 15:37:32',11,'1','2019-11-13','','1',''),(2481,1338,'2',0,'2019-11-13 15:37:39',11,'1','2019-11-13','','1',''),(2482,1335,'2',0,'2019-11-13 15:38:11',11,'1','2019-11-13','','1',''),(2483,1334,'2',0,'2019-11-13 15:38:17',11,'1','2019-11-13','','1',''),(2484,1339,'1',700,'2019-11-13 17:47:43',11,'1','2019-11-13','','1',''),(2485,1335,'3',1200,'2019-11-20 18:33:27',7,'1','2019-11-20','','1',''),(2486,1334,'3',0,'2019-11-20 18:33:37',7,'1','2019-11-20','','1',''),(2487,1330,'3',250,'2019-11-20 18:33:44',7,'1','2019-11-20','','1',''),(2488,1337,'3',0,'2019-11-20 18:33:52',7,'1','2019-11-20','','1',''),(2489,1338,'3',450,'2019-11-20 18:33:58',7,'1','2019-11-20','','1',''),(2490,1340,'1',2000,'2019-11-26 11:06:13',9,'1','2019-11-25','','1',''),(2491,1339,'2',0,'2019-11-26 11:10:02',9,'1','2019-11-26','','1',''),(2492,1336,'2',0,'2019-11-26 11:10:10',9,'1','2019-11-26','','1',''),(2493,1339,'3',350,'2019-12-02 22:14:19',9,'1','2019-12-02','','1',''),(2494,1340,'2',0,'2019-12-02 22:14:38',9,'1','2019-12-02','','1',''),(2495,1336,'3',500,'2019-12-02 22:14:47',9,'1','2019-12-02','','1',''),(2496,1341,'1',200,'2019-12-11 17:18:06',11,'2','2019-12-11','','3',''),(2497,1341,'2',0,'2019-12-11 17:19:58',11,'1','2019-12-11','','1',''),(2498,1341,'3',0,'2019-12-16 09:45:17',7,'1','2019-12-16','','1',''),(2499,1340,'3',1000,'2019-12-16 09:45:22',7,'1','2019-12-16','','1',''),(2500,1342,'1',0,'2020-01-08 14:44:05',7,'1','2019-12-20','','1',''),(2501,1343,'1',700,'2019-12-21 19:22:01',7,'1','2019-12-21','','1',''),(2502,1344,'1',1780,'2019-12-25 18:21:19',11,'2','2019-12-24','','3',''),(2503,1343,'2',0,'2019-12-25 18:30:39',11,'1','2019-12-25','','1',''),(2504,1344,'2',0,'2019-12-25 18:30:45',11,'1','2019-12-25','','1',''),(2505,1344,'3',850,'2020-01-02 19:14:39',7,'1','2020-01-02','','1',''),(2506,1345,'1',1000,'2020-01-06 14:00:30',7,'2','2020-01-04','','1',''),(2507,1342,'2',0,'2020-01-08 14:44:11',9,'1','2020-01-08','','1',''),(2508,1346,'1',700,'2020-01-10 11:31:48',9,'2','2020-01-10','','3',''),(2509,1345,'2',0,'2020-01-10 11:47:13',9,'1','2020-01-10','','1',''),(2510,1345,'3',1000,'2020-01-10 11:47:18',9,'1','2020-01-10','','1',''),(2511,1347,'1',350,'2020-01-13 13:42:00',7,'2','2020-01-13','','1',''),(2512,1348,'1',0,'2020-02-23 17:14:23',11,'2','2020-01-25','','1',''),(2513,1346,'2',0,'2020-01-29 15:34:56',11,'1','2020-01-29','','1',''),(2514,1347,'2',350,'2020-01-29 15:35:03',11,'1','2020-01-29','','1',''),(2515,1349,'1',0,'2020-01-29 15:36:06',11,'1','2020-01-29','','1',''),(2516,1350,'1',0,'2020-02-07 16:22:13',11,'1','2020-02-07','','1',''),(2517,1351,'1',840,'2020-02-21 17:09:10',11,'2','2020-02-18','','1',''),(2518,1352,'1',1200,'2020-02-21 17:08:20',11,'1','2020-02-21','','1',''),(2519,1352,'2',0,'2020-02-21 17:09:23',11,'1','2020-02-21','','1',''),(2520,1349,'2',0,'2020-02-21 17:09:32',11,'1','2020-02-21','','1',''),(2521,1352,'3',600,'2020-02-23 17:07:59',11,'1','2020-02-23','','1',''),(2522,1349,'3',0,'2020-03-11 19:30:50',11,'1','2020-03-11','','1',''),(2523,1347,'3',350,'2020-03-11 19:31:06',11,'1','2020-03-11','','1',''),(2524,1346,'3',350,'2020-03-11 19:31:37',11,'1','2020-03-11','','1',''),(2525,1351,'2',0,'2020-03-11 19:36:20',7,'1','2020-03-11','','1',''),(2526,1342,'3',0,'2020-03-11 19:36:29',7,'1','2020-03-11','','1',''),(2527,1351,'3',0,'2020-03-11 19:36:35',7,'1','2020-03-11','','1',''),(2528,1350,'3',1000,'2020-03-11 19:38:50',7,'1','2020-03-11','','1',''),(2529,1348,'2',0,'2020-03-11 19:39:13',7,'1','2020-03-11','','1',''),(2530,1348,'3',0,'2020-03-11 19:39:25',7,'1','2020-03-11','','1',''),(2531,1353,'1',1070,'2020-03-13 11:07:37',7,'2','2020-03-13','','2',''),(2532,1354,'1',1000,'2020-03-13 13:28:10',7,'2','2020-03-13','','2',''),(2533,1354,'3',500,'2020-03-16 19:15:30',7,'1','2020-03-16','','1',''),(2534,1355,'1',700,'2020-11-21 12:05:55',9,'2','2020-11-21','','3','');
/*!40000 ALTER TABLE `tb_payment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_payment_buy`
--

DROP TABLE IF EXISTS `tb_payment_buy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_payment_buy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rent_id` int(11) NOT NULL,
  `type_pay` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `in_pay` int(11) NOT NULL,
  `is_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name_in` int(11) NOT NULL,
  `payment` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `date_pay` date NOT NULL,
  `payment_des` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `blank` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `blank_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_payment_buy`
--

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

--
-- Table structure for table `tb_picture`
--

DROP TABLE IF EXISTS `tb_picture`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_picture` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `is_date` varchar(255) NOT NULL,
  `status` varchar(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1410 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_picture`
--

LOCK TABLES `tb_picture` WRITE;
/*!40000 ALTER TABLE `tb_picture` DISABLE KEYS */;
INSERT INTO `tb_picture` VALUES (1194,1175,'2019-06-031524010.jpg','2019-06-03','1'),(1195,1176,'2019-06-031527410.jpg','2019-06-03','1'),(1196,1177,'2019-06-031536260.jpg','2019-06-03','1'),(1197,1178,'2019-06-031540540.jpg','2019-06-03','1'),(1198,1179,'2019-06-031543280.jpg','2019-06-03','1'),(1199,1180,'2019-06-031547460.jpg','2019-06-03','1'),(1200,1181,'2019-06-031550590.jpg','2019-06-03','1'),(1201,1182,'2019-06-031558560.jpg','2019-06-03','1'),(1202,1183,'2019-06-031603280.jpg','2019-06-03','1'),(1203,1184,'2019-06-031607210.jpg','2019-06-03','1'),(1204,1185,'2019-06-031614210.jpg','2019-06-03','1'),(1205,1186,'2019-06-031618130.jpg','2019-06-03','1'),(1206,1187,'2019-06-031625370.jpg','2019-06-03','1'),(1207,1188,'2019-06-031632130.jpg','2019-06-03','1'),(1208,1189,'2019-06-031634580.jpg','2019-06-03','1'),(1209,1190,'2019-06-031637580.jpg','2019-06-03','1'),(1210,1191,'2019-06-031645000.jpg','2019-06-03','1'),(1211,1192,'2019-06-031652570.jpg','2019-06-03','1'),(1212,1193,'2019-06-031656050.jpg','2019-06-03','1'),(1213,1194,'2019-06-031703290.jpg','2019-06-03','1'),(1214,1195,'2019-06-031705350.jpg','2019-06-03','1'),(1215,1196,'2019-06-031708040.jpg','2019-06-03','1'),(1216,1197,'2019-06-031715430.jpg','2019-06-03','1'),(1217,1198,'2019-06-031718000.jpg','2019-06-03','1'),(1218,1199,'2019-06-031723200.jpg','2019-06-03','1'),(1219,1200,'2019-06-031724510.jpg','2019-06-03','1'),(1220,1201,'2019-06-031726360.jpg','2019-06-03','1'),(1221,1202,'2019-06-031733320.jpg','2019-06-03','1'),(1222,1203,'2019-06-031736470.jpg','2019-06-03','1'),(1223,1204,'2019-06-031739080.jpg','2019-06-03','1'),(1224,1205,'2019-06-031742440.jpg','2019-06-03','1'),(1225,1206,'2019-06-031744480.jpg','2019-06-03','1'),(1226,1207,'2019-06-031747020.jpg','2019-06-03','1'),(1227,1208,'2019-06-031751530.jpg','2019-06-03','1'),(1228,1209,'2019-06-031754170.jpg','2019-06-03','1'),(1229,1210,'2019-06-031755270.jpg','2019-06-03','1'),(1230,1211,'2019-06-031759290.jpg','2019-06-03','1'),(1231,1212,'2019-06-031801240.jpg','2019-06-03','1'),(1232,1213,'2019-06-031804100.jpg','2019-06-03','1'),(1233,1214,'2019-06-031806070.jpg','2019-06-03','1'),(1234,1215,'2019-06-031807350.jpg','2019-06-03','1'),(1235,1216,'2019-06-031809300.jpg','2019-06-03','1'),(1237,1218,'2019-06-031815330.jpg','2019-06-03','1'),(1238,1219,'2019-06-031816590.jpg','2019-06-03','1'),(1239,1220,'2019-06-031819210.jpg','2019-06-03','1'),(1240,1221,'2019-06-031821320.jpg','2019-06-03','1'),(1241,1222,'2019-06-031825150.jpg','2019-06-03','1'),(1242,1223,'2019-06-031827130.jpg','2019-06-03','1'),(1243,1224,'2019-06-031830540.jpg','2019-06-03','1'),(1244,1225,'2019-06-031834580.jpg','2019-06-03','1'),(1245,1226,'2019-06-031837070.jpg','2019-06-03','1'),(1246,1227,'2019-06-031839560.jpg','2019-06-03','1'),(1247,1228,'2019-06-031845150.jpg','2019-06-03','1'),(1248,1229,'2019-06-031847490.jpg','2019-06-03','1'),(1249,1230,'2019-06-031849350.jpg','2019-06-03','1'),(1250,1231,'2019-06-031934510.jpg','2019-06-03','1'),(1251,1232,'2019-06-031936190.jpg','2019-06-03','1'),(1252,1233,'2019-06-031945540.jpg','2019-06-03','1'),(1253,1234,'2019-06-041301120.jpg','2019-06-04','1'),(1254,1235,'2019-06-041304250.jpg','2019-06-04','1'),(1255,1236,'2019-06-041307430.jpg','2019-06-04','1'),(1256,1237,'2019-06-041310570.jpg','2019-06-04','1'),(1257,1238,'2019-06-041313340.jpg','2019-06-04','1'),(1258,1239,'2019-06-041316110.jpg','2019-06-04','1'),(1259,1240,'2019-06-041318510.jpg','2019-06-04','1'),(1260,1241,'2019-06-041320550.jpg','2019-06-04','1'),(1261,1242,'2019-06-041322470.jpg','2019-06-04','1'),(1262,1243,'2019-06-041609230.jpg','2019-06-04','1'),(1263,1244,'2019-06-041611370.jpg','2019-06-04','1'),(1264,1245,'2019-06-041615240.jpg','2019-06-04','1'),(1265,1246,'2019-06-041617410.jpg','2019-06-04','1'),(1266,1247,'2019-06-041620190.jpg','2019-06-04','1'),(1267,1248,'2019-06-041623040.jpg','2019-06-04','1'),(1268,1249,'2019-06-041625100.jpg','2019-06-04','1'),(1269,1250,'2019-06-041626480.jpg','2019-06-04','1'),(1270,1251,'2019-06-041628500.jpg','2019-06-04','1'),(1271,1252,'2019-06-041631520.jpg','2019-06-04','1'),(1272,1253,'2019-06-041633470.jpg','2019-06-04','1'),(1273,1254,'2019-06-041635070.jpg','2019-06-04','1'),(1274,1255,'2019-06-041637140.jpg','2019-06-04','1'),(1275,1256,'2019-06-041638280.jpg','2019-06-04','1'),(1276,1257,'2019-06-041639220.jpg','2019-06-04','1'),(1277,1258,'2019-06-041923010.jpg','2019-06-04','1'),(1278,1259,'2019-06-041924420.jpg','2019-06-04','1'),(1279,1260,'2019-06-051936330.jpg','2019-06-05','1'),(1280,1261,'2019-06-051938250.jpg','2019-06-05','1'),(1281,1262,'2019-06-051939440.jpg','2019-06-05','1'),(1282,1263,'2019-06-051941120.jpg','2019-06-05','1'),(1283,1264,'2019-06-051945280.jpg','2019-06-05','1'),(1284,1265,'2019-06-051947590.jpg','2019-06-05','1'),(1285,1266,'2019-06-051950060.jpg','2019-06-05','1'),(1286,1267,'2019-06-081838050.jpg','2019-06-08','1'),(1287,1268,'2019-06-081842240.jpg','2019-06-08','1'),(1288,1269,'2019-06-081844530.jpg','2019-06-08','1'),(1289,1270,'2019-06-081847560.jpg','2019-06-08','1'),(1290,1271,'2019-06-081856540.jpg','2019-06-08','1'),(1291,1272,'2019-06-081906560.jpg','2019-06-08','1'),(1292,1273,'2019-06-081908500.jpg','2019-06-08','1'),(1293,1274,'2019-06-081913170.jpg','2019-06-08','1'),(1294,1275,'2019-06-081930130.jpg','2019-06-08','1'),(1295,1276,'2019-06-081932270.jpg','2019-06-08','1'),(1296,1277,'2019-06-081937100.jpg','2019-06-08','1'),(1297,1278,'2019-06-081940180.jpg','2019-06-08','1'),(1298,1279,'2019-06-081950370.jpg','2019-06-08','1'),(1299,1280,'2019-06-081952010.jpg','2019-06-08','1'),(1300,1281,'2019-06-081953150.jpg','2019-06-08','1'),(1301,1282,'2019-06-081958340.jpg','2019-06-08','1'),(1302,1283,'2019-06-091654300.jpg','2019-06-09','1'),(1303,1284,'2019-06-091702320.jpg','2019-06-09','1'),(1304,1285,'2019-06-091707010.jpg','2019-06-09','1'),(1305,1286,'2019-06-091709460.jpg','2019-06-09','1'),(1306,1287,'2019-06-091720400.jpg','2019-06-09','1'),(1307,1288,'2019-06-111836410.jpg','2019-06-11','1'),(1308,1289,'2019-06-111838110.jpg','2019-06-11','1'),(1309,1290,'2019-06-111840070.jpg','2019-06-11','1'),(1310,1291,'2019-06-111842060.jpg','2019-06-11','1'),(1311,1292,'2019-06-111844140.jpg','2019-06-11','1'),(1312,1293,'2019-06-192008050.jpg','2019-06-19','1'),(1313,1294,'2019-06-192010060.jpg','2019-06-19','1'),(1314,1296,'2019-06-221453210.jpg','2019-06-22','1'),(1315,1297,'2019-06-221457040.jpg','2019-06-22','1'),(1316,1298,'2019-06-221459390.jpg','2019-06-22','1'),(1317,1299,'2019-06-221502230.jpg','2019-06-22','1'),(1318,1300,'2019-06-221506060.jpg','2019-06-22','1'),(1319,1301,'2019-06-221511320.jpg','2019-06-22','1'),(1320,1302,'2019-06-221514020.jpg','2019-06-22','1'),(1321,1303,'2019-06-221518580.jpg','2019-06-22','1'),(1322,1304,'2019-06-221522230.jpg','2019-06-22','1'),(1323,1305,'2019-06-221525310.jpg','2019-06-22','1'),(1324,1306,'2019-06-221532060.jpg','2019-06-22','1'),(1325,1307,'2019-06-221538560.jpg','2019-06-22','1'),(1326,1308,'2019-06-221541490.jpg','2019-06-22','1'),(1327,1309,'2019-06-221544150.jpg','2019-06-22','1'),(1328,1310,'2019-06-221547490.jpg','2019-06-22','1'),(1329,1311,'2019-06-221549490.jpg','2019-06-22','1'),(1330,1312,'2019-06-231856370.jpg','2019-06-23','1'),(1331,1313,'2019-06-231904370.jpg','2019-06-23','1'),(1332,1314,'2019-06-271448200.jpg','2019-06-27','1'),(1333,1316,'2019-07-042130260.jpg','2019-07-04','1'),(1334,1315,'2019-07-051134220.jpg','2019-07-05','1'),(1335,1317,'2019-07-141637040.jpg','2019-07-14','1'),(1336,1319,'2019-08-011216440.jpg','2019-08-01','1'),(1337,1320,'2019-08-011304370.jpg','2019-08-01','1'),(1338,1321,'2019-08-101912010.jpg','2019-08-10','1'),(1339,1322,'2019-08-101914020.jpg','2019-08-10','1'),(1340,1323,'2019-08-181219100.jpg','2019-08-18','1'),(1341,1324,'2019-08-191625400.jpg','2019-08-19','1'),(1342,1325,'2019-08-191627270.jpg','2019-08-19','1'),(1343,1326,'2019-08-191631330.jpg','2019-08-19','1'),(1344,1327,'2019-08-191635500.jpg','2019-08-19','1'),(1345,1328,'2019-08-231417530.jpg','2019-08-23','1'),(1346,1328,'2019-08-231417531.jpg','2019-08-23','1'),(1347,1329,'2019-08-231419280.jpg','2019-08-23','1'),(1348,1330,'2019-08-231434440.jpg','2019-08-23','1'),(1349,1330,'2019-08-231434441.jpg','2019-08-23','1'),(1350,1331,'2019-08-231443010.jpg','2019-08-23','1'),(1365,1332,'2019-08-231515300.jpg','2019-08-23','1'),(1352,1332,'2019-08-231453121.jpg','2019-08-23','1'),(1353,1333,'2019-08-231454380.jpg','2019-08-23','1'),(1354,1334,'2019-08-231455420.jpg','2019-08-23','1'),(1355,1335,'2019-08-231501220.jpg','2019-08-23','1'),(1356,1335,'2019-08-231501221.jpg','2019-08-23','1'),(1357,1336,'2019-08-231502590.jpg','2019-08-23','1'),(1358,1337,'2019-08-231504080.jpg','2019-08-23','1'),(1359,1338,'2019-08-231510060.jpg','2019-08-23','1'),(1360,1338,'2019-08-231510061.jpg','2019-08-23','1'),(1361,1339,'2019-08-231511300.jpg','2019-08-23','1'),(1362,1339,'2019-08-231511301.jpg','2019-08-23','1'),(1363,1340,'2019-08-231512540.jpg','2019-08-23','1'),(1364,1340,'2019-08-231512541.jpg','2019-08-23','1'),(1366,1341,'2019-08-231517430.jpg','2019-08-23','1'),(1367,1342,'2019-08-231529210.jpg','2019-08-23','1'),(1368,1342,'2019-08-231529211.jpg','2019-08-23','1'),(1369,1343,'2019-08-231531550.jpg','2019-08-23','1'),(1370,1343,'2019-08-231531561.jpg','2019-08-23','1'),(1371,1344,'2019-08-231533350.jpg','2019-08-23','1'),(1372,1344,'2019-08-231533351.jpg','2019-08-23','1'),(1373,1345,'2019-08-231538031.jpg','2019-08-23','1'),(1374,1346,'2019-08-231543070.jpg','2019-08-23','1'),(1375,1295,'2019-08-231556490.png','2019-08-23','1'),(1376,1318,'2019-08-231556590.png','2019-08-23','1'),(1377,1347,'2019-08-231901480.jpg','2019-08-23','1'),(1378,1348,'2019-08-231904080.jpg','2019-08-23','1'),(1379,1349,'2019-08-231910130.jpg','2019-08-23','1'),(1380,1350,'2019-08-231911480.jpg','2019-08-23','1'),(1381,1351,'2019-08-231913040.jpg','2019-08-23','1'),(1382,1352,'2019-08-231914290.jpg','2019-08-23','1'),(1383,1353,'2019-08-231917510.jpg','2019-08-23','1'),(1384,1354,'2019-08-231920230.jpg','2019-08-23','1'),(1390,1355,'2019-08-231931090.jpg','2019-08-23','1'),(1386,1356,'2019-08-231925380.jpg','2019-08-23','1'),(1389,1357,'2019-08-231930210.jpg','2019-08-23','1'),(1388,1358,'2019-08-231928270.jpg','2019-08-23','1'),(1391,1359,'2019-08-231935120.jpg','2019-08-23','1'),(1392,1359,'2019-08-231935121.jpg','2019-08-23','1'),(1393,1360,'2019-08-231936480.jpg','2019-08-23','1'),(1394,1360,'2019-08-231936481.jpg','2019-08-23','1'),(1395,1361,'2019-08-251835100.jpg','2019-08-25','1'),(1396,1362,'2019-08-251837000.jpg','2019-08-25','1'),(1397,1363,'2019-08-251838240.jpg','2019-08-25','1'),(1398,1365,'2020-01-081431140.jpg','2020-01-08','1'),(1399,1366,'2020-01-081432260.jpg','2020-01-08','1'),(1400,1368,'2020-01-081434050.jpg','2020-01-08','1'),(1401,1367,'2020-01-081435340.jpg','2020-01-08','1'),(1402,1369,'2020-01-081435520.jpg','2020-01-08','1'),(1403,1370,'2020-01-081436580.jpg','2020-01-08','1'),(1404,1371,'2020-01-081437390.jpg','2020-01-08','1'),(1405,1372,'2020-01-081438370.jpg','2020-01-08','1'),(1406,1373,'2020-01-081440500.jpg','2020-01-08','1'),(1407,1374,'2020-01-081441520.jpg','2020-01-08','1'),(1408,1375,'2020-01-081442290.jpg','2020-01-08','1'),(1409,1376,'2020-01-081443280.jpg','2020-01-08','1');
/*!40000 ALTER TABLE `tb_picture` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_picturesale`
--

DROP TABLE IF EXISTS `tb_picturesale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_picturesale` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_picturesale`
--

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

--
-- Table structure for table `tb_rent_info`
--

DROP TABLE IF EXISTS `tb_rent_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_rent_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rentid` varchar(255) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `phone` varchar(255) NOT NULL,
  `insurance` varchar(255) NOT NULL,
  `return_insurance` int(11) NOT NULL,
  `insurance_des` text NOT NULL,
  `book_rate` int(11) NOT NULL,
  `receive_date` date NOT NULL,
  `remand_date` date NOT NULL,
  `event_date` date NOT NULL,
  `method` text NOT NULL,
  `is_date` datetime NOT NULL,
  `status` varchar(1) NOT NULL,
  `pay_status` varchar(1) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `payment` varchar(1) NOT NULL,
  `discount_insurance` int(11) NOT NULL,
  `discount_rent` int(11) NOT NULL,
  `cancel_des` text NOT NULL,
  `date_update` varchar(255) NOT NULL,
  `date_updateinfo` varchar(255) NOT NULL,
  `note` text NOT NULL,
  `returnbook` int(11) NOT NULL,
  `returnbook_des` text NOT NULL,
  `send` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1356 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_rent_info`
--

LOCK TABLES `tb_rent_info` WRITE;
/*!40000 ALTER TABLE `tb_rent_info` DISABLE KEYS */;
INSERT INTO `tb_rent_info` VALUES (1283,'OR190600001','คุณธราธิป จงสมจิตต์','28/2191 เดอะโพลิแทน รีฟ ชั้น52 ซ.นนทบุรี15 ถ.สนามบินน้ำ ต.บางกระสอ อ.เมือง จ.นนทบุรี 11000','081-803-4546','350',0,'',350,'2019-06-14','2019-06-24','2019-06-10','ปณ.','2019-06-30 19:02:56','A','1','','2',0,0,'','','','',1,'',0),(1284,'OR190600002','ปณ.มัทรี สีสวย ','Prostreet Motors 96/10-11 ม.14 ถ.นครเขื่อนขันธ์ ต.บางพึ่ง อ.พระประแดง สมุทรปราการ 10130 \r\nTel.087 705 7557','087 705 7557','1400',0,'',2100,'2019-06-13','2019-06-16','2019-06-11','ส่งปณ ฟรีค่าส่ง','2019-06-30 19:02:51','A','2','','2',0,0,'','','','',1,'',0),(1285,'OR190600003','ปณ.จัณณ์พัชชาญ์ ใช้จริง19-22','269/182 หมู่บ้านเดอะนิช ซ.พระยาสุเรนทร์30 แขวง บางชัน เขต คลองสามวา กทม10510','061-261-5646','900',0,'',450,'2019-07-13','2019-07-23','2019-06-13','ส่งเคอรี่','2019-07-28 15:40:53','A','1','','2',0,0,'','','','',1,'',0),(1286,'OR190600004','จันจิรา  จุลสวัสดิ์ ','16/1 ม.5 ต.หนองโน จ.สระบุรี','0815559887','400',0,'',400,'2019-09-10','2019-09-15','2019-07-01','รับเอง','2019-09-27 19:05:14','A','1','','2',0,0,'','','','',1,'',0),(1287,'OR190600005','พี่เปิ้ล ศุลาภัย','-','-','600',0,'',350,'2019-06-14','2019-06-17','2019-06-14','มารับเอง','2019-06-30 19:02:47','A','2','','1',600,100,'','','','',1,'',0),(1288,'OR190600006','นางแบบรีวิว/ ตุรกี','-','0838238228','5300',0,'',0,'2019-07-20','2019-08-01','2019-06-21','ยังไม่แน่ใจ','2019-08-09 19:18:21','A','1','','1',5300,3000,'','','','',1,'',0),(1292,'OR190600010','พี่บูม','-','-','2700',0,'',1080,'2019-06-26','2019-07-04','2019-06-19','รับเอง','2019-07-06 18:47:51','A','1','','2',2700,270,'','','','',1,'',0),(1289,'OR190600007','ปณ.นางแบบรีวิว ชลบุรี','-','0838238228','7900',0,'',0,'2019-07-09','2019-07-23','2019-07-09','รับเอง','2019-07-28 15:41:20','A','1','','1',7900,3950,'','','','',1,'',0),(1290,'OR190600008','สู้ศึก อนุคระหานนท์','-','0970545647','600',0,'',900,'2019-06-14','2019-06-24','2019-06-14','รับเอง','2019-06-30 19:02:33','A','2','','2',0,0,'','','','',1,'',0),(1291,'OR190600009','คุณโบว์ MC','-','0863680820','1500',0,'',700,'2019-06-19','2019-06-26','2019-06-19','รับเอง','2019-06-30 19:02:28','A','2','','2',1500,100,'','','','',1,'',0),(1293,'OR190600011','พี่บูม','-','-','2800',0,'',1840,'2019-07-06','2019-07-18','2019-06-19','รับเอง','2019-08-04 19:22:58','A','1','','2',2800,460,'','','','',1,'',0),(1294,'OR190600012','ปณ.อพัชชา สีงาม','47 ม.2 ต.ลาดสาลร ลพบุรี',' 0854224798','700',0,'',340,'2019-07-06','2019-07-15','2019-06-21','ส่งเคอรี่','2019-07-21 23:24:40','A','1','','2',300,60,'','','','',1,'',0),(1295,'OR190600013','MC.พี่หน่อย','-','-','1100',0,'',0,'2019-06-24','2019-06-26','2019-06-24','รับเอง','2019-06-30 19:02:09','A','1','','1',1100,800,'','','','',1,'',0),(1296,'OR190600014','พี่เปิ้ล ศุลาลัย','-','-','1800',0,'',450,'2019-06-24','2019-06-27','2019-06-24','รับเอง','2019-06-30 19:01:58','A','2','','1',1800,350,'','','','',1,'',0),(1297,'OR190600015','นลินี รุ่งโรจน์ (พลอย)','-','0984742792','1350',0,'',1800,'2019-06-27','2019-07-01','2019-06-27','รับเอง','2019-07-06 18:48:38','A','2','','2',450,0,'','','','',1,'',0),(1298,'OR190700016','ปณ.ปอย ','ชัยนาท','0819331624','700',0,'',718,'2019-07-01','2019-07-08','2019-07-01','ส่งปณ.','2019-07-15 14:37:13','A','2','','2',350,52,'','','','',1,'',0),(1299,'OR190700017','ปณ.ดวงดารา อรปัญญา','111/183 ,.5ถ.แจ้งวัฒนะ นนทบุรี','0925057716','350',0,'',750,'2019-07-03','2019-07-08','2019-07-03','ส่งปณ','2019-07-15 14:37:03','A','2','','2',0,20,'','','','',1,'',0),(1300,'OR190700018','วรรณิดา  ฟุ้งมาก','38/2 ม.3 ระยอง','0871388042','1100',0,'',800,'2019-07-05','2019-07-07','2019-07-03','รับเอง','2019-07-08 16:40:05','A','1','','1',300,0,'','','','',1,'',0),(1301,'OR190700019','คุณม่านฟ้า แก้วละมุล','671 ม.1 ต.ละหาร อ.ปลวกแดง จ.ระยอง','061-551-5982','4500',0,'',5700,'2019-07-04','2019-07-08','2019-07-04','รับเอง','2019-07-15 14:35:35','A','2','','2',1650,0,'','','','',1,'',0),(1302,'OR190700020','ปณ.ปภัสณัฏฐ์  พินิจวงศ์วิทยา','บ. ซีอารฺซี ไทวัสดุ สมุทรปราการ','0894564929','800',0,'',650,'2019-07-09','2019-07-17','2019-07-05','ส่งปณ.','2019-07-23 10:06:06','A','2','','2',500,120,'','','','',1,'',0),(1303,'OR190700021','สิริยา  มีสบาย test by p.benz','18/6 ม.4 ต.เนินพระ อ.เมือง จ.ระยอง','0647868436','500',0,'',650,'2019-07-14','2019-07-17','2019-07-13','รับเอง','2019-08-09 19:18:10','A','2','','2',150,50,'','','2019-07-13 11:48:29','test by p.benz',1,'',0),(1304,'OR190700022','คุณจารุวรรณ น้ำใส ปณ','36 ม.1 ต.สร้างนางขาว อ.โพนพิสัย จ.หนองคาย','-','500',0,'',350,'2019-07-26','2019-08-05','2019-07-14','ส่ง ปณ.','2019-08-04 14:10:49','A','1','','2',0,0,'','','','',1,'',0),(1305,'OR190700023','คุณสุจิตรา วงษ์วิวงษ์ (ปณ)','50/26 แขวงสี่พระยา บางรัก กรุงเทพฯ','0655939939','2000',0,'',2500,'2019-07-17','2019-07-22','2019-07-16','ส่ง ปณ','2019-07-23 17:51:38','A','2','','2',500,0,'','','','',1,'',0),(1306,'OR190700024','ปณ.อ๊อด ลูกค้าตปท.ไม่มีไลน์ IG sugarr_girls','-ส่งให้เพื่อนรับให้ที่พังงา','0816775871','600',100,'',780,'2019-07-22','2019-07-29','2019-07-21','ส่ง','2019-08-04 19:23:31','A','2','','2',250,0,'','','','',1,'',0),(1307,'OR190700025','ปณ.ปภัสณัฏฐ์ พินิจวงศ์วิทยา','-','0894564929','450',0,'',830,'2019-07-23','2019-07-30','2019-07-23','ส่ง','2019-08-04 19:24:38','A','2','','2',50,90,'','','','',1,'',0),(1308,'OR190700026','คุณนลินี รุ่งโรจน์','233 ม.4 ต.พนานิคม อ.นิคมพัฒนา จ.ระยอง','098-474-2792','900',0,'',400,'2019-07-26','2019-07-28','2019-07-25','รับเอง','2019-08-04 19:23:44','A','1','','2',500,50,'','','','',1,'',0),(1309,'OR190700027','คุณสิริวิมล ทองแม้น','74/44 ม. ต.ปราสาท อ.บ้านกรวด จ.บุรีรัมย์','065-483-2705','300',0,'',570,'2019-07-25','2019-07-30','2019-07-25','ส่ง ปณ','2019-08-04 19:24:48','A','2','','2',50,10,'','','','',1,'',0),(1310,'OR190800028','คุณนุชจรินทร์ นิยม (ปณ.ศุภกิจ)','1 ซ.ริมคลองหัวหมากแยก5 แขวงหัวหมาก เขตบางกะปิ กทม.','092-013-7044','350',0,'',750,'2019-08-06','2019-08-15','2019-08-01','ปณ','2019-08-19 17:50:17','A','2','','2',0,30,'','','','',1,'',0),(1311,'OR190800029','คุณวรรณฤดี จิตรา ปณ','72 ต.เขากอบ อ.ห้วยยอก จ.ตรัง','094-898-2287','450',0,'',900,'2019-08-06','2019-08-11','2019-08-01','ปณ','2019-08-13 19:07:34','A','2','','2',0,0,'','','','',1,'',0),(1312,'OR190800030','คุณธัญชนก โฮ่สกุล ปณ.','เดอะคริสตัว คอนโด 168/30 ม. ต.ทุ่งสุขลา อ.ศรีราชา จ.ชลบุรี','063-168-6599','500',0,'',350,'2019-09-11','2019-09-20','2019-09-07','ปณ','2019-09-27 19:05:06','A','1','','2',150,20,'','','','',1,'',0),(1313,'OR190800031','ณัฎฐนิช ศรีคำชุม','-','0828992342','900',0,'',900,'2019-08-05','2019-08-10','2019-08-05','รับเอง','2019-09-15 19:05:46','A','2','','2',450,0,'','','','',1,'',0),(1314,'OR190800032','รุจิรา ยั่งยืน','-','-','900',0,'',1400,'2019-08-06','2019-08-14','2019-08-06','รับเอง','2019-08-13 19:07:27','A','2','','2',200,0,'','','','',1,'',0),(1315,'OR190800033','ภคมน  ศรีมะโน','37/23 ต.ปากน้ำ อ.เมือง จ.ระยอง','0908891824','700',0,'',700,'2019-08-09','2019-08-12','2019-08-07','รับเอง','2019-08-13 19:07:21','A','2','','2',350,0,'','','','',1,'',0),(1316,'OR190800034','ปณ.สิริวิมล  ทองแม้น 0654832705','-','0654832705','1000',0,'',970,'2019-08-09','2019-08-11','2019-08-09','ส่งเคอรี่','2019-08-13 19:07:16','A','2','','2',550,160,'','','','',1,'',0),(1317,'OR190800035','ปณ.ปุณรภา บุญเรือง','เดอะไฮริเวอร์พาร์ค 177/4 ซอยคอนโดศรีเมือง 1 ถนน อดุลย์ประภาส ตำบลเชิงเนิน อำเภอเมือง จังหวัดระยอง 21000','082-9428242','900',0,'',900,'2019-09-03','2019-09-10','2019-08-12','ส่ง ปณ.','2019-09-15 19:06:02','A','2','','2',450,0,'','','','',1,'',0),(1318,'OR190800036','ปณ. ชลิตา ฉิมบุญอยู่','444/5 ธนพลอพาร์ทเมนต์ ถ.พหลโยธิน 35 แยก 15 ซ.7 แขวงลาดยาว เขตจตุจักร กรุงเทพมหานคร 10900','085-1700322','700',0,'',820,'2019-08-14','2019-08-23','2019-08-14','ส่ง ปณ.','2019-09-27 19:04:56','A','2','','2',300,0,'','','','',1,'',0),(1319,'OR190800037','ปณ.ธนิษฐา  เอลเบร์ท','-','0955365144','400',0,'',800,'2019-08-19','2019-08-27','2019-08-19','ส่งปณ.','2019-08-30 19:36:47','A','2','','2',0,0,'','','','',1,'',0),(1320,'OR190800038','ปณ.ชลลดา','-','-','900',0,'',970,'2019-08-22','2019-08-30','2019-08-21','ส่ง','2019-09-27 19:05:28','A','2','','2',450,0,'','','','',1,'',0),(1321,'OR190800039','ปณ.กวินท์ภัทร์ บุญล้อมทรัพย์','ส่งที่ กวินท์ภัทร์ บุญล้อมทรัพย์ (ของกึ๋ย) 195/77 ม.ปรีชาราม1 ถ.ราษฏร์พัฒนา แขวง/เขตสะพานสูง กทม10240 ','0899680315','6000',0,'',1400,'2019-09-11','2019-09-16','2019-08-27','ส่งเคอรี่','2019-09-27 19:04:48','A','2','','2',6000,1550,'','','','',1,'',0),(1322,'OR190800040','ปณ.สิริวิมล  ทองแม้น','195/3 ม.6 ต.นาเกลือ ขลบุรี','0654832705','350',0,'',760,'2019-08-30','2019-09-02','2019-08-30','ส่งเคอรี่','2019-09-15 19:05:35','A','2','','2',0,10,'','','','',1,'',0),(1323,'OR190900041','ช่อแก้ว','103/5 ถ.สมุทรคงคา ระยอง','0855551927','2300',0,'',1150,'2019-09-18','2019-09-25','2019-09-11','รับเอง','2019-09-27 19:04:29','A','1','','1',1150,0,'','','','',1,'',0),(1324,'OR190900042','ปณ.สวรินทร์ บุญชอบ','ห้องB310 เซ็นทรับอพาร์ทเม้นท์153/10 ม.1 กทม','090-97198480','900',0,'',860,'2019-09-13','2019-09-20','2019-09-13','ส่ง','2019-09-25 19:31:26','A','2','','2',550,110,'','','','',1,'',0),(1325,'OR190900043','อนัญญา จันทร์บุษราคัม','55/40 ถ.จันอุดม ต.เชิงเนิน ระยอง','0819831307','350',0,'',700,'2019-09-29','2019-10-07','2019-09-29','รับเอง','2019-10-07 18:45:45','A','2','','1',0,0,'','','','',1,'',0),(1326,'OR191000044','พี่เชอรี่ยืม','-','-','1500',0,'',0,'2019-10-13','2019-10-18','2019-10-05','-','2019-11-11 19:38:01','A','1','','1',1500,800,'','','','',1,'',0),(1327,'OR191000045','ป้อมแป้มยืม','-','-','1800',0,'',0,'2019-10-18','2019-10-24','2019-10-13','-','2019-10-24 17:26:03','A','1','','1',1800,1550,'','','','',1,'',0),(1328,'OR191000046','ศุภิสรา รัตนรักษ์ ','-','-','700',0,'',900,'2019-10-09','2019-10-21','2019-10-09','รับเอง','2019-10-20 16:19:45','A','2','','2',250,0,'','','','',1,'',0),(1329,'OR191000047','ศุภิสรา รัตนรักษ์ /ยืมไปปล่อยเช่าCO','-',' 088-2109879','1000',0,'',0,'2019-10-09','2019-10-21','2019-10-09','รับเอง','2019-11-11 19:38:15','A','2','','1',1000,700,'','','','',1,'',0),(1330,'OR191000048','ปณ.ณัฐพร ปานเอี่ยม','-','082-769288','450',0,'',560,'2019-10-13','2019-10-21','2019-10-13','รับเอง','2019-11-20 18:33:44','A','2','','2',200,210,'','','','',1,'',0),(1331,'OR191000049','ภคมน  ศรีมะโน','37/33 ต.ปากน้ำ ระยอง ','090-889-1824','1000',0,'',1260,'2019-10-14','2019-10-21','2019-10-14','รับเอง','2019-10-21 17:20:22','A','2','','2',370,70,'','','','',1,'',0),(1332,'OR191100050','นุชนาภา  บุตรรอด','214/4 บ้านฉาง ระยอง','061-4698289','700',0,'',1000,'2019-11-08','2019-11-11','2019-11-04','รับเอง','2019-11-11 19:38:27','A','2','','2',200,0,'','','','',1,'',0),(1333,'OR191100051','คุณอลินนันท์ อรุณสวัสดิ์','99/57 ม.3 ต.เนินพระ อ.เมือง จ.ระยอง','081-246-5159+','700',0,'',700,'2019-11-04','2019-11-10','2019-11-04','รับเอง','2019-11-11 19:37:54','A','2','','1',350,50,'','','','',1,'',0),(1334,'OR191100052','ปณ.ศวัสพร  คูณชัยพานิชย์ ณ นคร','-','081-62665626','2000',0,'',800,'2019-11-07','2019-11-11','2019-11-06','ส่ง','2019-11-20 18:33:37','A','2','','2',2000,200,'','','','',1,'',0),(1335,'OR191100053','ปณ.อริสา  มาใจ','1ม.2 ต.สำราญราษฎร์ อ.ดอยสะเก็ด เชียงใหม่','065-4949262','2500',0,'',2400,'2019-11-14','2019-11-19','2019-11-08','ส่งเคอรี่','2019-11-20 18:33:27','A','2','','2',1300,300,'','','','',1,'',0),(1336,'OR191100054','อนุลักษณ์ ภู่ถนนนอก ','49/13 ม 3 ทับมา ระยอง\r\n\r\n',' 086 3424829','1500',0,'',1000,'2019-11-13','2019-11-18','2019-11-08','รับเอง','2019-12-02 22:14:47','A','2','','2',1000,300,'','','','',1,'',0),(1337,'OR191100055','พี่บูม','-','-','350',0,'',300,'2019-11-08','2019-11-11','2019-11-08','รับเอง','2019-11-20 18:33:52','A','2','','1',350,50,'','','','',1,'',0),(1338,'OR191100056','นุชนาภา บุตรรอด','14/4 บ้านฉาง ระยอง\r\n','061-4698289','900',0,'',900,'2019-11-13','2019-11-18','2019-11-13','รับเอง','2019-11-20 18:33:58','A','1','','2',450,0,'','','','',1,'',0),(1339,'OR191100057','อัญชิสา จาตุรันต์เรืองศรี ','1 ตากสิน ระยอง','094-8487969','700',0,'',700,'2019-11-13','2019-11-23','2019-11-13','รับเอง','2019-12-02 22:14:19','A','2','','1',350,0,'','','','',1,'',0),(1340,'OR191100058','ปณ.ธนัชชา  คุณาดิเรกวง','195 สุขุมวิท กทม ','088-4211080','2000',0,'',2000,'2019-11-29','2019-12-04','2019-11-26','ส่งเคอรี่','2019-12-16 09:45:22','A','2','','1',1000,0,'','','','',1,'',0),(1341,'OR191200059','พี่บูม','-','-','500',0,'',200,'2019-12-11','2019-12-11','2019-12-11','รับเอง','2019-12-16 09:45:17','A','2','','2',500,50,'','','','',1,'',0),(1342,'OR191200060','ยืมไปปล่อยของco','-','-','1000',0,'',0,'2020-01-12','2020-01-23','2020-01-08','รับเอง','2020-03-11 19:36:29','A','1','','1',1000,700,'','','','',1,'',0),(1343,'OR191200061','พชร สกุลกลั่น','-','0800560206','1000',350,'',700,'2019-12-21','2019-12-23','2019-12-21','รับเอง','2020-03-11 19:31:59','A','2','','1',650,150,'','','','',1,'',0),(1344,'OR191200062','ปณ.พิชญ์กัญญา  พรมแตง','1/29 ต.ในเมือง อ.เมือง จ.พิจิตร','092-2604404','1500',0,'',1780,'2019-12-25','2019-12-29','2019-12-25','ส่ง','2020-01-02 19:14:39','A','2','','2',650,0,'','','','',1,'',0),(1345,'OR200100063','ปณ.เรืองฟ้า เดชพรม','169/155 มบ.เศรษสิริ จรัญ ปิ่นเกล้า ถ.เลียบทางรถไฟตลิ่งชัน','088-2529719','1400',0,'',1000,'2020-01-27','2020-02-07','2020-01-06','ส่งเอกชน','2020-01-10 11:47:18','A','1','','2',400,0,'','','','',1,'',0),(1346,'OR200100064','ปราณี  ลูกสอาด','232/121 ม.7 ต.ตะพง เมือง ระยอง','088-4836544','350',0,'',700,'2020-01-10','2020-01-13','2020-01-10','รับเอง','2020-03-11 19:31:37','A','2','','2',0,0,'','','','',1,'',0),(1347,'OR200100065','ดวงฤดี จังตระกูล ที่อยู่','2195 ม.1 ต.สัตหีบ อ.สัตหีบ ชลบุรี\r\n','089-8319524','500',0,'',350,'2020-01-26','2020-02-03','2020-01-13','รับเอง','2020-03-11 19:31:06','A','1','','2',150,0,'','','','',1,'',0),(1348,'OR200100066','ปณ.พรพิมล ไวจันทา*ส่งชุดผิด','พิษณุโลก','094-8924363','1000',0,'',0,'2020-02-23','2020-02-23','2020-02-23','ส่งเคอรี่','2020-03-11 19:39:25','A','1','','2',1000,570,'','','','',1,'',0),(1349,'OR200100067','ยืมปล่อยใน CO','-','-','1000',0,'',0,'2020-02-10','2020-02-22','2020-01-29','-','2020-03-11 19:30:50','A','1','','1',1000,700,'','','','',1,'',0),(1350,'OR200200068','ปณ.เรืองฟ้า ยอดเดิม1000','-','088-2529719','1400',0,'',0,'2020-03-01','2020-03-13','2020-02-07','ส่งปณ *ไม่มียอดเนื่องจ้าเก็บเครดิตไว้1000 ','2020-03-11 19:38:50','A','1','','1',400,1000,'covid - 19  ยกเลิกแล้ว 2 รอบ','2020-03-11 19:38:32','','',1,'',0),(1351,'OR200200069','ภูชยา เหมหงษ์','39/259 หมู่ 4 ต.ทับมา อ.เมืองระยอง จ.ระยอง','0814937165','1500',0,'',840,'2020-02-25','2020-03-02','2020-02-21','รับเอง','2020-03-11 19:36:35','A','1','','2',1500,210,'','','','',1,'',0),(1352,'OR200200070','อาภัสรา เพ็งวัน','-','0809711223','2000',0,'',1200,'2020-02-21','2020-02-23','2020-02-21','รับเอง','2020-02-23 17:07:59','A','1','','1',1400,400,'','','','',1,'',0),(1353,'OR200300071','ปณ วรณัน วิจิตรพัชราภรณ์','1188 ม.2 ต.ท่ามะเขือ อ.คลองขลุง จ.กำแพงเพชร 62120','0926945625','500',0,'',1070,'2020-03-13','2020-03-23','2020-03-13','ปณ','2020-03-13 11:05:07','B','2','','2',0,0,'','','','',0,'',0),(1354,'OR200300072','ภคมน ศรีมะโน','37/23 ถ.อดุลย์ธรรมประภาส ต.ปากน้ำ อ.เมืองระยอง จ.ระยอง','0908891824','500',0,'',1000,'2020-03-13','2020-03-17','2020-03-13','รับเอง','2020-03-16 19:15:30','A','2','','2',200,0,'','','','',1,'',0),(1355,'OR201100073','พัชรา  หล้าเนตร','59/49 ม.3 อ.เมืองสุพรรณบุรี จ.สุพรรณบุรี','096-6580419','350',0,'',700,'2020-11-21','2020-11-24','2020-11-21','รับเอง','2020-11-21 12:05:55','B','2','','2',0,0,'','','','',0,'',0);
/*!40000 ALTER TABLE `tb_rent_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_rents`
--

DROP TABLE IF EXISTS `tb_rents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_rents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `rent_id` int(11) NOT NULL,
  `count` varchar(255) NOT NULL,
  `rate` varchar(255) NOT NULL,
  `status` varchar(1) NOT NULL,
  `is_date` varchar(255) NOT NULL,
  `remark` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3236 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_rents`
--

LOCK TABLES `tb_rents` WRITE;
/*!40000 ALTER TABLE `tb_rents` DISABLE KEYS */;
INSERT INTO `tb_rents` VALUES (3105,1209,1283,'1','350','A','2019-06-10 18:01:39',''),(3106,1252,1284,'1','350','A','2019-06-11 11:22:53',''),(3107,1251,1284,'1','350','A','2019-06-11 11:22:53',''),(3108,1245,1285,'1','450','A','2019-06-13 21:32:26',''),(3109,1284,1286,'1','400','A','2019-06-13 21:41:05',''),(3110,1232,1287,'1','450','A','2019-06-14 13:20:54',''),(3111,1274,1288,'1','1500','A','2019-06-14 14:26:50',''),(3112,1206,1288,'1','700','A','2019-06-14 14:26:50',''),(3125,1245,1292,'1','450','A','2019-06-19 19:54:50',''),(3114,1249,1288,'1','350','A','2019-06-14 14:26:50',''),(3115,1179,1288,'1','450','A','2019-06-14 14:26:50',''),(3116,1205,1289,'1','750','A','2019-06-14 14:30:25',''),(3117,1192,1289,'1','300','A','2019-06-14 14:30:25',''),(3118,1218,1289,'1','600','A','2019-06-14 14:30:25',''),(3119,1254,1290,'1','300','A','2019-06-14 16:43:57',''),(3120,1250,1291,'1','350','A','2019-06-19 11:33:48',''),(3121,1176,1291,'1','450','A','2019-06-19 11:33:48',''),(3127,1238,1292,'1','500','A','2019-06-19 19:54:50',''),(3126,1204,1292,'1','400','A','2019-06-19 19:54:50',''),(3128,1219,1293,'1','700','A','2019-06-19 20:14:57',''),(3129,1294,1293,'1','800','A','2019-06-19 20:14:57',''),(3130,1293,1293,'1','800','A','2019-06-19 20:14:57',''),(3131,1188,1294,'1','400','A','2019-06-21 11:29:07',''),(3132,1295,1294,'1','70','A','2019-06-21 11:29:07',''),(3133,1202,1295,'1','400','A','2019-06-24 17:26:04',''),(3134,1309,1295,'1','400','A','2019-06-24 17:26:04',''),(3135,1222,1296,'1','400','A','2019-06-24 17:32:50',''),(3136,1258,1296,'1','400','A','2019-06-24 17:32:50',''),(3137,1314,1297,'1','450','A','2019-06-27 16:12:35',''),(3138,1179,1297,'1','450','A','2019-06-27 16:12:35',''),(3139,1251,1298,'1','350','A','2019-07-01 12:47:18',''),(3140,1295,1298,'1','70','A','2019-07-01 12:48:29',''),(3141,1209,1299,'1','350','A','2019-07-03 12:57:59',''),(3142,1295,1299,'1','70','A','2019-07-03 12:57:59',''),(3143,1315,1300,'1','400','A','2019-07-03 19:07:02',''),(3144,1202,1300,'1','400','A','2019-07-03 19:07:02',''),(3145,1316,1301,'1','450','A','2019-07-04 22:10:28',''),(3146,1193,1301,'1','500','A','2019-07-04 22:10:28',''),(3147,1257,1301,'1','350','A','2019-07-04 22:10:28',''),(3148,1186,1301,'1','300','A','2019-07-04 22:10:28',''),(3149,1212,1301,'1','450','A','2019-07-04 22:10:28',''),(3150,1312,1301,'1','350','A','2019-07-04 22:10:28',''),(3151,1201,1301,'1','450','A','2019-07-04 22:10:28',''),(3152,1204,1302,'1','400','A','2019-07-05 11:39:20',''),(3153,1295,1302,'1','70','A','2019-07-05 11:39:20',''),(3154,1270,1289,'1','2300','A','2019-07-09 11:55:50',''),(3156,1317,1304,'1','350','A','2019-07-14 16:41:54',''),(3157,1310,1305,'1','1000','A','2019-07-16 18:21:51',''),(3158,1185,1306,'1','350','B','2019-07-21 18:57:08',''),(3159,1318,1306,'1','80','B','2019-07-21 18:57:08',''),(3160,1314,1307,'1','450','A','2019-07-23 11:29:23',''),(3161,1295,1307,'1','70','A','2019-07-23 11:29:23',''),(3162,1184,1308,'1','450','A','2019-07-25 17:55:15',''),(3163,1197,1309,'1','250','A','2019-07-25 18:01:44',''),(3164,1318,1309,'1','80','A','2019-07-25 18:01:44',''),(3170,1320,1310,'1','350','A','2019-08-01 13:06:27',''),(3166,1318,1310,'1','80','A','2019-08-01 12:07:38',''),(3167,1319,1311,'1','450','A','2019-08-01 12:19:06',''),(3168,1317,1312,'1','350','A','2019-08-01 12:24:26',''),(3169,1318,1312,'1','80','A','2019-08-01 12:24:26',''),(3171,1184,1313,'1','450','A','2019-08-04 20:22:34',''),(3172,1199,1314,'1','300','A','2019-08-06 20:56:03',''),(3173,1299,1314,'1','400','A','2019-08-06 20:56:03',''),(3174,1252,1315,'1','350','A','2019-08-07 13:09:48',''),(3175,1208,1316,'1','600','A','2019-08-09 11:22:13',''),(3176,1318,1316,'1','80','A','2019-08-09 11:22:13',''),(3177,1179,1317,'1','450','A','2019-08-12 14:38:00',''),(3178,1251,1318,'1','350','A','2019-08-14 15:10:20',''),(3179,1295,1318,'1','70','A','2019-08-14 15:10:20',''),(3180,1284,1319,'1','400','A','2019-08-19 14:21:01',''),(3181,1179,1320,'1','450','A','2019-08-21 11:18:33',''),(3182,1295,1320,'1','70','A','2019-08-21 11:18:33',''),(3183,1310,1321,'1','1000','A','2019-08-26 16:21:45',''),(3184,1278,1321,'1','1950','A','2019-08-26 16:21:45',''),(3185,1209,1322,'1','350','A','2019-08-30 13:57:15',''),(3186,1295,1322,'1','70','A','2019-08-30 13:57:15',''),(3187,1179,1323,'1','450','A','2019-09-11 15:51:51',''),(3188,1206,1323,'1','700','A','2019-09-11 15:51:51',''),(3189,1245,1324,'1','450','A','2019-09-13 11:55:36',''),(3190,1295,1324,'1','70','A','2019-09-13 11:55:36',''),(3191,1320,1325,'1','350','A','2019-09-29 16:17:13',''),(3192,1212,1326,'1','450','A','2019-10-05 19:41:37',''),(3193,1317,1326,'1','350','A','2019-10-05 19:41:37',''),(3194,1250,1327,'1','350','A','2019-10-06 13:07:19',''),(3195,1229,1328,'1','450','A','2019-10-09 18:31:15',''),(3196,1242,1329,'1','700','A','2019-10-09 18:39:01',''),(3198,1296,1327,'1','1200','A','2019-10-13 12:16:44',''),(3199,1316,1330,'1','450','A','2019-10-13 14:56:31',''),(3200,1295,1330,'1','70','A','2019-10-13 14:56:31',''),(3201,1309,1331,'1','400','A','2019-10-14 18:26:05',''),(3202,1254,1331,'1','300','A','2019-10-14 18:26:05',''),(3203,1203,1332,'1','500','A','2019-11-04 11:11:57',''),(3204,1188,1333,'1','400','A','2019-11-04 19:47:49',''),(3205,1310,1334,'1','1000','A','2019-11-06 15:28:04',''),(3206,1274,1335,'1','1500','A','2019-11-08 11:24:41',''),(3207,1287,1336,'1','800','A','2019-11-08 18:31:23',''),(3208,1322,1337,'1','350','A','2019-11-08 18:55:28',''),(3209,1245,1338,'1','450','A','2019-11-13 14:32:39',''),(3210,1183,1339,'1','350','A','2019-11-13 17:47:43',''),(3211,1310,1340,'1','1000','A','2019-11-26 11:06:13',''),(3212,1180,1341,'1','250','A','2019-12-11 17:18:06',''),(3213,1242,1342,'1','700','A','2019-12-20 13:19:54',''),(3214,1217,1343,'1','500','B','2019-12-21 19:22:01',''),(3215,1198,1344,'1','500','A','2019-12-25 18:21:19',''),(3216,1317,1344,'1','350','A','2019-12-25 18:21:19',''),(3217,1318,1344,'1','80','A','2019-12-25 18:21:19',''),(3218,1364,1345,'3','100','A','2020-01-05 12:19:47',''),(3219,1206,1345,'1','700','A','2020-01-05 12:19:47',''),(3220,1371,1346,'1','350','A','2020-01-10 11:31:48',''),(3221,1249,1347,'1','350','A','2020-01-13 13:42:00',''),(3222,1198,1348,'1','500','A','2020-01-25 12:08:40',''),(3223,1295,1348,'1','70','A','2020-01-25 12:08:40',''),(3224,1242,1349,'1','700','A','2020-01-29 15:36:06',''),(3225,1206,1350,'1','700','A','2020-02-07 16:22:13',''),(3226,1377,1350,'4','50','A','2020-02-07 16:22:13',''),(3227,1364,1350,'1','100','A','2020-02-07 16:22:13',''),(3228,1280,1351,'1','300','A','2020-02-18 19:11:28',''),(3229,1186,1351,'1','300','A','2020-02-18 19:11:28',''),(3230,1230,1351,'1','450','A','2020-02-18 19:11:28',''),(3231,1310,1352,'1','1000','A','2020-02-21 17:04:39',''),(3232,1356,1353,'1','500','B','2020-03-13 11:05:07',''),(3233,1295,1353,'1','70','B','2020-03-13 11:05:07',''),(3234,1203,1354,'1','500','A','2020-03-13 13:28:10',''),(3235,1209,1355,'1','350','B','2020-11-21 12:05:55','');
/*!40000 ALTER TABLE `tb_rents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_setup`
--

DROP TABLE IF EXISTS `tb_setup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_setup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nameshop` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `lineid` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_setup`
--

LOCK TABLES `tb_setup` WRITE;
/*!40000 ALTER TABLE `tb_setup` DISABLE KEYS */;
INSERT INTO `tb_setup` VALUES (2,'ร้านชอบเช่า','โครงการ กุญชร์สิริ 8/8 ม.1 ถนนราชชุมพล ','ต.เนินพระ อ.เมือง จ.ระยอง 21000','โทร. เบนซ์ 098-193-9426, เชอรี่ 085-320-0320','@chobchao');
/*!40000 ALTER TABLE `tb_setup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_stockslae`
--

DROP TABLE IF EXISTS `tb_stockslae`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_stockslae` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `item_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `count` int(11) NOT NULL,
  `in_stock` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  `is_date` date NOT NULL,
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `stat` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_stockslae`
--

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

--
-- Table structure for table `tb_users`
--

DROP TABLE IF EXISTS `tb_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `is_date` date NOT NULL,
  `status` varchar(1) NOT NULL,
  `user` varchar(11) NOT NULL,
  `stock_buy` int(11) NOT NULL,
  `stock_rent` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_users`
--

LOCK TABLES `tb_users` WRITE;
/*!40000 ALTER TABLE `tb_users` DISABLE KEYS */;
INSERT INTO `tb_users` VALUES (16,'jarunya ','noi','1234','2019-06-05','1','A',1,1),(7,'Widsana T.','Cherry','1234','2019-06-05','1','A',1,1),(8,'Rutchanee K.','Benz','1234','2019-06-05','1','A',1,1),(9,'pompam','pompam','pp00','2019-06-05','1','A',1,1),(15,'For Programmer','admin','1234','2018-11-26','1','A',1,1);
/*!40000 ALTER TABLE `tb_users` 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:38

📁 Sid Gifari File Manager