BfwxQXph

1-- MySQL dump 10.13  Distrib 5.6.22, for osx10.8 (x86_64)
2--
3-- Host: 127.0.0.1    Database: hacktech-modelsystem-web
4-- ------------------------------------------------------
5-- Server version	5.6.24
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `ABOUT`
20--
21
22DROP TABLE IF EXISTS `ABOUT`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `ABOUT` (
26  `ID` int(11) NOT NULL AUTO_INCREMENT,
27  `DETAIL_1` longtext CHARACTER SET utf8,
28  `DETAIL_2` longtext CHARACTER SET utf8,
29  `IMG_1` longtext CHARACTER SET utf8,
30  `IMG_2` longtext CHARACTER SET utf8,
31  `CREATED_AT` timestamp NULL DEFAULT NULL,
32  `UPDATED_AT` timestamp NULL DEFAULT NULL,
33  PRIMARY KEY (`ID`)
34) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `ABOUT`
39--
40
41LOCK TABLES `ABOUT` WRITE;
42/*!40000 ALTER TABLE `ABOUT` DISABLE KEYS */;
43INSERT INTO `ABOUT` VALUES (7,'rfzdQn_h8UA',NULL,NULL,NULL,'2016-07-01 13:26:46','2016-07-01 13:26:46'),(8,'Step1 你下單','結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單結帳下單',NULL,NULL,'2016-07-01 13:26:46','2016-07-01 13:26:46'),(9,'Step2 我配送','馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送馬上配送',NULL,NULL,'2016-07-01 13:26:46','2016-07-01 13:26:46'),(10,'Step3 你烹煮','馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃馬上就能吃',NULL,NULL,'2016-07-01 13:26:46','2016-07-01 13:26:46');
44/*!40000 ALTER TABLE `ABOUT` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `ADMIN`
49--
50
51DROP TABLE IF EXISTS `ADMIN`;
52/*!40101 SET @saved_cs_client     = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `ADMIN` (
55  `ID` int(11) NOT NULL AUTO_INCREMENT,
56  `ACCOUNT` varchar(45) COLLATE utf8_latvian_ci NOT NULL,
57  `PASSWORD` varchar(120) CHARACTER SET utf8 NOT NULL,
58  `EMAIL` varchar(45) COLLATE utf8_latvian_ci NOT NULL,
59  `remember_token` longtext CHARACTER SET utf8,
60  `CREATED_AT` timestamp NULL DEFAULT NULL,
61  `UPDATED_AT` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
62  `PERMISSION` varchar(45) COLLATE utf8_latvian_ci NOT NULL,
63  `STATUS` varchar(45) CHARACTER SET utf8 NOT NULL,
64  PRIMARY KEY (`ID`)
65) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `ADMIN`
70--
71
72LOCK TABLES `ADMIN` WRITE;
73/*!40000 ALTER TABLE `ADMIN` DISABLE KEYS */;
74INSERT INTO `ADMIN` VALUES (38,'eee','$2y$10$e4xMGXteIwyHc34b9OtV7uOa5phJWAtdRJM05uzmRC7PTwPVQntO.','aa0930101298@gmail.com','SwNOppOmhnBtbC5C88iC1MAilJs6YHvz5jHXWVUCj9eYDSPWxJUIYbqgYkKm','2016-01-28 23:48:18','2016-12-11 10:40:32','boss','open'),(47,'test','$2y$10$YDfZWwBn7duJhqiDqi2mw.yVPHYXrN9odDwLeNN6FIi.y6FiIcmcq','gn02158263@gmail.com',NULL,'2016-07-12 09:23:13','2016-10-12 03:12:14','boss','delete');
75/*!40000 ALTER TABLE `ADMIN` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `BRANCH`
80--
81
82DROP TABLE IF EXISTS `BRANCH`;
83/*!40101 SET @saved_cs_client     = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `BRANCH` (
86  `ID` int(11) NOT NULL AUTO_INCREMENT,
87  `NAME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
88  `CITY` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
89  `ADDRESS` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
90  `IMG_URL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
91  `PHONE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
92  `FAX` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
93  `MOMENT` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
94  `SORT` int(11) DEFAULT NULL,
95  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
96  `CREATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
97  `UPDATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
98  PRIMARY KEY (`ID`)
99) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
100/*!40101 SET character_set_client = @saved_cs_client */;
101
102--
103-- Dumping data for table `BRANCH`
104--
105
106LOCK TABLES `BRANCH` WRITE;
107/*!40000 ALTER TABLE `BRANCH` DISABLE KEYS */;
108INSERT INTO `BRANCH` VALUES (3,'台南總經銷','台南市','<p>19501 Biscayne Blvd<br>Aventura, FL 33180<br>305-792-0355</p><br>','/img/frontend/da0108/store01.jpg','06 - 247 - 4907','06 - 247 - 4907','<p>Mon-Sat 10am-9:30pm<br>Sun 12pm-8pm</p>',1,'open','2016-04-05 10:55:35','2016-06-20 12:45:12'),(4,'台北試賣店','台北市','<p>19501 Biscayne Blvd<br>Aventura, FL 33180<br>305-792-0355</p><br>','/img/frontend/da0108/store02.jpg','06 - 247 - 4907','06 - 247 - 4907','<p>Mon-Sat 10am-9:30pm<br>Sun 12pm-8pm</p>',2,'open','2016-09-30 19:03:07','2016-09-30 19:09:09');
109/*!40000 ALTER TABLE `BRANCH` ENABLE KEYS */;
110UNLOCK TABLES;
111
112--
113-- Table structure for table `BUGREPORT`
114--
115
116DROP TABLE IF EXISTS `BUGREPORT`;
117/*!40101 SET @saved_cs_client     = @@character_set_client */;
118/*!40101 SET character_set_client = utf8 */;
119CREATE TABLE `BUGREPORT` (
120  `ID` int(11) NOT NULL,
121  `PAGE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
122  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
123  `IMG` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
124  `DETAIL` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
125  `CREATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
126  PRIMARY KEY (`ID`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `BUGREPORT`
132--
133
134LOCK TABLES `BUGREPORT` WRITE;
135/*!40000 ALTER TABLE `BUGREPORT` DISABLE KEYS */;
136/*!40000 ALTER TABLE `BUGREPORT` ENABLE KEYS */;
137UNLOCK TABLES;
138
139--
140-- Table structure for table `BUSINESS_SERVICES`
141--
142
143DROP TABLE IF EXISTS `BUSINESS_SERVICES`;
144/*!40101 SET @saved_cs_client     = @@character_set_client */;
145/*!40101 SET character_set_client = utf8 */;
146CREATE TABLE `BUSINESS_SERVICES` (
147  `ID` int(11) NOT NULL AUTO_INCREMENT,
148  `TITLE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
149  `TEXT_DETAIL` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
150  `DETAIL` text COLLATE utf8_unicode_ci,
151  `URL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
152  `IMG_URL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
153  `ICON` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
154  `SORT` int(11) DEFAULT NULL,
155  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
156  `CREATED_AT` timestamp NULL DEFAULT NULL,
157  `UPDATED_AT` timestamp NULL DEFAULT NULL,
158  PRIMARY KEY (`ID`)
159) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
160/*!40101 SET character_set_client = @saved_cs_client */;
161
162--
163-- Dumping data for table `BUSINESS_SERVICES`
164--
165
166LOCK TABLES `BUSINESS_SERVICES` WRITE;
167/*!40000 ALTER TABLE `BUSINESS_SERVICES` DISABLE KEYS */;
168/*!40000 ALTER TABLE `BUSINESS_SERVICES` ENABLE KEYS */;
169UNLOCK TABLES;
170
171--
172-- Table structure for table `CONTACT_BACKUP`
173--
174
175DROP TABLE IF EXISTS `CONTACT_BACKUP`;
176/*!40101 SET @saved_cs_client     = @@character_set_client */;
177/*!40101 SET character_set_client = utf8 */;
178CREATE TABLE `CONTACT_BACKUP` (
179  `ID` int(11) NOT NULL AUTO_INCREMENT,
180  `NAME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
181  `EMAIL` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
182  `PHONE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
183  `SUBJECT` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
184  `DETAIL` text COLLATE utf8_unicode_ci,
185  `STATUS` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
186  `CREATED_AT` timestamp NULL DEFAULT NULL,
187  `UPDATED_AT` timestamp NULL DEFAULT NULL,
188  PRIMARY KEY (`ID`)
189) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
190/*!40101 SET character_set_client = @saved_cs_client */;
191
192--
193-- Dumping data for table `CONTACT_BACKUP`
194--
195
196LOCK TABLES `CONTACT_BACKUP` WRITE;
197/*!40000 ALTER TABLE `CONTACT_BACKUP` DISABLE KEYS */;
198INSERT INTO `CONTACT_BACKUP` VALUES (1,'','','','','','open','2016-10-12 00:19:56','2016-10-12 00:19:56'),(2,'','','','','','open','2016-10-12 00:21:07','2016-10-12 00:21:07'),(3,'','gn02158263@gmail.com','12346789','test','','open','2016-10-12 00:23:13','2016-10-12 00:23:13'),(4,'','gn02158263@gmail.com','12346789','123','','open','2016-10-12 00:30:18','2016-10-12 00:30:18'),(5,'','test@gmail.com','12346789','test','','open','2016-10-12 00:31:00','2016-10-12 00:31:00'),(6,'test','test@gmail.com','12346789','test','test','open','2016-10-12 00:32:05','2016-10-12 00:32:05'),(7,'ted','gn02158263@gmail.com','952736897','test','321','open','2016-10-12 00:32:19','2016-10-12 00:32:19'),(8,'ted','gn02158263@gmail.com','952736897','test','321','open','2016-10-12 00:34:42','2016-10-12 00:34:42');
199/*!40000 ALTER TABLE `CONTACT_BACKUP` ENABLE KEYS */;
200UNLOCK TABLES;
201
202--
203-- Table structure for table `IMG`
204--
205
206DROP TABLE IF EXISTS `IMG`;
207/*!40101 SET @saved_cs_client     = @@character_set_client */;
208/*!40101 SET character_set_client = utf8 */;
209CREATE TABLE `IMG` (
210  `ID` int(11) NOT NULL AUTO_INCREMENT,
211  `URL` text COLLATE utf8_unicode_ci NOT NULL,
212  `SORT` int(11) NOT NULL,
213  `STATUS` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
214  `CREATED_AT` timestamp NULL DEFAULT NULL,
215  `UPDATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
216  PRIMARY KEY (`ID`)
217) ENGINE=InnoDB AUTO_INCREMENT=299 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
218/*!40101 SET character_set_client = @saved_cs_client */;
219
220--
221-- Dumping data for table `IMG`
222--
223
224LOCK TABLES `IMG` WRITE;
225/*!40000 ALTER TABLE `IMG` DISABLE KEYS */;
226INSERT INTO `IMG` VALUES (1,'http://a1.bbkz.net/forum/attachment.php?attachmentid=115473&thumb=1&d=1246614832',1,'open','2016-02-18 00:58:28','2016-02-19 09:27:50'),(2,'http://static.ettoday.net/images/1102/d1102812.jpg',1,'open','2016-02-02 09:47:38','2016-02-18 08:27:36'),(10,'http://localhost:8000/img/1457334276-logo.png',3,'open','2016-03-06 23:04:36','2016-03-07 07:04:47'),(11,'http://localhost:8000/img/1457334457-1456969123-螢幕快照 2016-02-23 下午312321.png',4,'delete','2016-03-06 23:07:37','2016-03-07 07:07:38'),(12,'http://localhost:8000/img/1457334465-1456969123-螢幕快照 2016-02-23 下午312321.png',4,'delete','2016-03-06 23:07:46','2016-03-07 07:07:50'),(13,'http://localhost:8000/img/1457334476-1456969123-螢幕快照 2016-02-23 下午312321.png',4,'delete','2016-03-06 23:07:57','2016-03-07 07:08:29'),(14,'http://localhost:8000/img/1457334514-logo.png',4,'close','2016-03-06 23:08:34','2016-03-07 07:08:34'),(15,'http://localhost:8000/img/1457334766-logo.png',2,'close','2016-03-06 23:12:46','2016-03-07 07:12:46'),(16,'http://localhost:8000/img/1457334827-logo.png',2,'close','2016-03-06 23:13:47','2016-03-07 07:13:47'),(17,'http://localhost:8000/img/1457334882-logo.png',3,'close','2016-03-06 23:14:42','2016-03-07 07:14:42'),(18,'http://localhost:8000/img/1457335090-logo.png',2,'open','2016-03-06 23:18:10','2016-03-07 07:18:14'),(19,'http://localhost:8000/img/1457342050-1456969123-螢幕快照 2016-02-23 下午312321.png',33,'delete','2016-03-07 01:14:10','2016-03-07 09:14:19'),(20,'http://localhost:8000/img/1457342068-1456969123-螢幕快照 2016-02-23 下午312321.png',33,'open','2016-03-07 01:14:29','2016-03-07 09:15:08'),(21,'http://localhost:8000/img/1457413239-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'open','2016-03-07 21:00:40','2016-03-08 05:00:45'),(22,'http://localhost:8000/img/1457414840-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-03-07 21:27:21','2016-03-08 05:27:21'),(23,'http://localhost:8000/img/1457414857-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-03-07 21:27:38','2016-03-08 05:27:38'),(24,'http://localhost:8000/img/1457414899-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-03-07 21:28:19','2016-03-08 05:28:19'),(25,'http://localhost:8000/img/1457415169-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-03-07 21:32:50','2016-03-08 05:32:50'),(26,'http://localhost:8000/img/1457415223-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'open','2016-03-07 21:33:43','2016-03-08 05:33:57'),(27,'http://localhost:8000/img/1457417969-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-03-07 22:19:30','2016-03-08 06:19:30'),(28,'http://localhost:8000/img/1457418072-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-03-07 22:21:12','2016-03-08 06:21:14'),(29,'http://localhost:8000/img/1457418120-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-03-07 22:22:01','2016-04-01 17:52:47'),(30,'http://localhost:8000/img/1457418229-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-03-07 22:23:50','2016-03-08 06:23:50'),(31,'http://localhost:8000/img/1457418241-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-03-07 22:24:02','2016-03-08 06:24:02'),(32,'http://localhost:8000/img/1457418267-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-03-07 22:24:28','2016-03-08 06:25:22'),(33,'http://localhost:8000/img/1457418278-1456969123-螢幕快照 2016-02-23 下午312321.png',34,'delete','2016-03-07 22:24:39','2016-03-08 06:25:07'),(34,'http://localhost:8000/img/1458278991-S__4349957.jpg',3,'close','2016-03-18 05:29:51','2016-03-18 13:29:51'),(35,'http://localhost:8000/img/1458279009-S__4349957.jpg',3,'close','2016-03-18 05:30:09','2016-03-18 13:30:09'),(36,'http://localhost:8000/img/1458279236-S__4349957.jpg',3,'close','2016-03-18 05:33:56','2016-03-18 13:33:56'),(37,'http://localhost:8000/img/1458279288-S__4349957.jpg',3,'close','2016-03-18 05:34:48','2016-03-18 13:34:48'),(38,'http://localhost:8000/img/1458279329-S__4349957.jpg',3,'open','2016-03-18 05:35:30','2016-03-18 13:35:39'),(39,'http://localhost:8000/img/1458721759-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'open','2016-03-23 08:29:20','2016-03-23 16:29:24'),(41,'http://localhost:8000/img/1458793942-S__4349957.jpg',1,'close','2016-03-24 04:32:22','2016-03-24 12:32:22'),(42,'http://localhost:8000/img/1458793959-S__4349957.jpg',1,'close','2016-03-24 04:32:39','2016-03-24 12:32:39'),(43,'http://localhost:8000/img/1458795399-logo.png',1,'close','2016-03-24 04:56:39','2016-03-24 12:56:39'),(51,'http://localhost:8000/img/1458797688-logo.png',1,'close','2016-03-24 05:34:48','2016-03-24 13:34:48'),(71,'http://localhost:8000/img/1458800719-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-03-24 06:25:20','2016-03-24 14:25:20'),(72,'http://localhost:8000/img/1458800819-S__4349957.jpg',1,'close','2016-03-24 06:26:59','2016-03-24 14:26:59'),(73,'http://localhost:8000/img/1458800861-store_setting.jpg',1,'close','2016-03-24 06:27:41','2016-03-24 14:27:41'),(74,'http://localhost:8000/img/1458800910-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-03-24 06:28:31','2016-03-24 14:28:34'),(75,'http://localhost:8000/img/1458800940-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-03-24 06:29:00','2016-03-24 14:29:00'),(76,'http://localhost:8000/img/1458800969-logo.png',1,'close','2016-03-24 06:29:30','2016-03-24 14:29:30'),(77,'http://localhost:8000/img/1458801347-S__4349957.jpg',1,'close','2016-03-24 06:35:47','2016-03-24 14:35:47'),(78,'http://localhost:8000/img/1458801366-S__4349957.jpg',1,'close','2016-03-24 06:36:06','2016-03-24 14:36:06'),(79,'http://localhost:8000/img/1458801410-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-03-24 06:36:50','2016-03-24 14:36:50'),(80,'http://localhost:8000/img/1458801423-S__4349957.jpg',1,'close','2016-03-24 06:37:03','2016-03-24 14:37:03'),(81,'http://localhost:8000/img/1458801457-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-03-24 06:37:38','2016-03-24 14:37:38'),(82,'http://localhost:8000/img/1458801560-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-03-24 06:39:21','2016-03-24 14:39:21'),(83,'http://localhost:8000/img/1458801600-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-03-24 06:40:01','2016-03-24 14:40:01'),(84,'http://localhost:8000/img/1458801650-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-03-24 06:40:51','2016-03-24 14:40:51'),(85,'http://localhost:8000/img/1458801747-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-03-24 06:42:28','2016-03-24 14:42:28'),(86,'http://localhost:8000/img/1458801774-logo.png',1,'open','2016-03-24 06:42:54','2016-03-24 14:42:54'),(87,'http://localhost:8000/img/1458801813-taiwan_flag_clip_art_14572.jpg',1,'open','2016-03-24 06:43:33','2016-03-24 14:43:33'),(88,'http://localhost:8000/img/1459503120-1456969123-螢幕快照 2016-02-23 下午312321.png',2,'delete','2016-04-01 09:32:01','2016-04-01 17:52:36'),(89,'http://localhost:8000/img/1459504390-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'open','2016-04-01 09:53:11','2016-04-01 17:53:13'),(90,'http://localhost:8000/img/1459676883-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-04-03 01:48:03','2016-04-03 09:49:01'),(91,'http://localhost:8000/img/1459676964-1456969123-螢幕快照 2016-02-23 下午312321.png',222,'delete','2016-04-03 01:49:25','2016-04-03 09:49:36'),(92,'http://localhost:8000/img/1459677068-10270742_1162419533769156_3783256124732369050_n.jpg',23,'delete','2016-04-03 01:51:08','2016-04-03 09:51:09'),(93,'http://localhost:8000/img/1459677162-1456969123-螢幕快照 2016-02-23 下午312321.png',33332,'delete','2016-04-03 01:52:42','2016-04-03 09:52:43'),(94,'http://localhost:8000/img/1459677208-10270742_1162419533769156_3783256124732369050_n.jpg',66,'delete','2016-04-03 01:53:28','2016-04-03 09:53:29'),(95,'http://localhost:8000/img/1459677253-10270742_1162419533769156_3783256124732369050_n.jpg',0,'close','2016-04-03 01:54:13','2016-04-03 09:54:13'),(96,'http://localhost:8000/img/1459677262-10270742_1162419533769156_3783256124732369050_n.jpg',332,'close','2016-04-03 01:54:22','2016-04-03 09:54:22'),(97,'http://localhost:8000/img/1459677274-10270742_1162419533769156_3783256124732369050_n.jpg',2321,'close','2016-04-03 01:54:34','2016-04-03 09:54:34'),(98,'http://localhost:8000/img/1459677281-10270742_1162419533769156_3783256124732369050_n.jpg',2321,'close','2016-04-03 01:54:41','2016-04-03 09:54:41'),(99,'http://localhost:8000/img/1459677332-1456969123-螢幕快照 2016-02-23 下午312321.png',33,'delete','2016-04-03 01:55:32','2016-04-03 09:55:34'),(100,'http://localhost:8000/img/1459677495-10270742_1162419533769156_3783256124732369050_n.jpg',132,'delete','2016-04-03 01:58:15','2016-04-03 09:58:17'),(101,'http://localhost:8000/img/1459683825-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-04-03 03:43:45','2016-04-03 11:43:45'),(102,'http://localhost:8000/img/1459921070-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-04-06 05:37:51','2016-04-06 13:37:52'),(103,'http://localhost:8000/img/1460110899-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-04-08 10:21:40','2016-04-23 13:38:29'),(104,'http://localhost:8000/img/1460809691-10270742_1162419533769156_3783256124732369050_n.jpg',3,'delete','2016-04-16 12:28:11','2016-04-16 20:28:13'),(105,'http://localhost:8000/img/1461326647-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:04:08','2016-04-22 20:04:08'),(106,'http://localhost:8000/img/1461326808-10270742_1162419533769156_3783256124732369050_n.jpg',1,'close','2016-04-22 12:06:48','2016-04-22 20:06:48'),(107,'http://localhost:8000/img/1461326846-10270742_1162419533769156_3783256124732369050_n.jpg',1,'close','2016-04-22 12:07:26','2016-04-22 20:07:26'),(108,'http://localhost:8000/img/1461326862-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:07:43','2016-04-22 20:07:43'),(109,'http://localhost:8000/img/1461326908-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:08:28','2016-04-22 20:08:28'),(110,'http://localhost:8000/img/1461327543-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:19:03','2016-04-22 20:19:03'),(111,'http://localhost:8000/img/1461327615-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:20:15','2016-04-22 20:20:15'),(112,'http://localhost:8000/img/1461327705-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:21:45','2016-04-22 20:21:45'),(113,'http://localhost:8000/img/1461327818-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:23:39','2016-04-22 20:23:39'),(114,'http://localhost:8000/img/1461328088-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-04-22 12:28:08','2016-04-23 14:18:43'),(115,'http://localhost:8000/img/1461328668-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:37:49','2016-04-22 20:37:49'),(116,'http://localhost:8000/img/1461328687-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-04-22 12:38:08','2016-04-22 20:38:08'),(117,'http://localhost:8000/img/1461328712-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-04-22 12:38:33','2016-04-22 20:38:33'),(118,'http://localhost:8000/img/1461328742-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-04-22 12:39:02','2016-04-22 20:39:02'),(119,'http://localhost:8000/img/1461328769-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-04-22 12:39:29','2016-04-23 14:16:35'),(120,'http://localhost:8000/img/1461389614-10270742_1162419533769156_3783256124732369050_n.jpg',3,'delete','2016-04-23 05:33:34','2016-04-23 13:34:13'),(121,'http://localhost:8000/img/1461389843-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'close','2016-04-23 05:37:24','2016-04-23 13:37:24'),(122,'http://localhost:8000/img/1461392481-10270742_1162419533769156_3783256124732369050_n.jpg',1,'delete','2016-04-23 06:21:21','2016-04-23 14:21:54'),(123,'http://localhost:8000/img/1461392551-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-04-23 06:22:31','2016-04-23 14:22:32'),(124,'http://localhost:8000/img/1461392744-S__4349957.jpg',1,'open','2016-04-23 06:25:44','2016-04-23 14:25:44'),(125,'http://localhost:8000/img/1461392751-taiwan_flag_clip_art_14572.jpg',1,'delete','2016-04-23 06:25:51','2016-06-01 13:11:30'),(126,'http://localhost:8000/img/1461392761-螢幕快照 2016-03-15 14.27.11.png',1,'delete','2016-04-23 06:26:01','2016-04-23 14:58:16'),(127,'http://localhost:8000/img/1461392780-螢幕快照 2016-03-04 13.41.15.png',1,'delete','2016-04-23 06:26:20','2016-06-01 13:10:34'),(128,'http://localhost:8000/img/1461394747-logo.png',1,'delete','2016-04-23 06:59:07','2016-06-01 13:07:55'),(129,'http://localhost:8000/img/1461401883-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-04-23 08:58:04','2016-04-23 16:58:36'),(130,'http://localhost:8000/img/1461401921-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-04-23 08:58:41','2016-04-23 17:06:15'),(131,'http://localhost:8000/img/1461402404-10270742_1162419533769156_3783256124732369050_n.jpg',1,'delete','2016-04-23 09:06:44','2016-04-23 17:06:47'),(132,'http://localhost:8000/img/1461402609-10270742_1162419533769156_3783256124732369050_n.jpg',1,'delete','2016-04-23 09:10:10','2016-04-23 17:12:34'),(133,'http://localhost:8000/img/1461402766-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-04-23 09:12:47','2016-04-23 17:12:57'),(134,'http://localhost:8000/img/1461578889-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-04-25 10:08:10','2016-04-25 18:08:24'),(135,'http://localhost:8000/img/1461664051-10270742_1162419533769156_3783256124732369050_n.jpg',4,'delete','2016-04-26 09:47:31','2016-04-26 17:48:26'),(136,'http://localhost:8000/img/1461664124-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'open','2016-04-26 09:48:45','2016-04-26 17:48:47'),(137,'http://localhost:8000/img/1462875014-005.png',3,'close','2016-05-10 10:10:14','2016-05-10 18:10:14'),(138,'http://localhost:8000/img/1462875045-005.png',3,'delete','2016-05-10 10:10:45','2016-05-10 18:11:20'),(139,'http://localhost:8000/img/1462875053-004.png',3,'close','2016-05-10 10:10:53','2016-05-10 18:10:53'),(140,'http://localhost:8000/img/1462875074-012.png',3,'delete','2016-05-10 10:11:14','2016-05-10 18:11:21'),(141,'http://localhost:8000/img/1462875115-005.png',3,'delete','2016-05-10 10:11:55','2016-05-10 18:12:24'),(142,'http://localhost:8000/img/1462875120-005.png',2,'open','2016-05-10 10:12:00','2016-05-10 18:13:51'),(143,'http://localhost:8000/img/1462875124-005.png',3,'delete','2016-05-10 10:12:04','2016-05-10 18:12:24'),(144,'http://localhost:8000/img/1462875130-009.png',3,'open','2016-05-10 10:12:10','2016-05-10 18:13:51'),(145,'http://localhost:8000/img/1462877288-005.png',5,'close','2016-05-10 10:48:08','2016-05-10 18:48:08'),(146,'http://localhost:8000/img/1462877292-004.png',5,'delete','2016-05-10 10:48:12','2016-05-10 18:48:20'),(147,'http://localhost:8000/img/1462877295-003.png',5,'delete','2016-05-10 10:48:15','2016-05-10 18:48:19'),(148,'http://localhost:8000/img/1462877316-005.png',5,'delete','2016-05-10 10:48:36','2016-05-10 18:48:54'),(149,'http://localhost:8000/img/1462877324-005.png',5,'close','2016-05-10 10:48:45','2016-05-10 18:48:45'),(150,'http://localhost:8000/img/1462877328-002.png',5,'delete','2016-05-10 10:48:48','2016-05-10 18:48:55'),(151,'http://localhost:8000/img/1462877332-010.png',5,'close','2016-05-10 10:48:52','2016-05-10 18:48:52'),(152,'http://localhost:8000/img/1462877842-003.png',3,'delete','2016-05-10 10:57:22','2016-05-10 18:57:24'),(153,'http://localhost:8000/img/1462877853-007.png',3,'delete','2016-05-10 10:57:33','2016-05-10 18:57:59'),(154,'http://localhost:8000/img/1462877856-009.png',3,'close','2016-05-10 10:57:36','2016-05-10 18:57:36'),(155,'http://localhost:8000/img/1462877867-012.png',3,'delete','2016-05-10 10:57:47','2016-05-10 18:58:00'),(156,'http://localhost:8000/img/1462877877-004.png',3,'close','2016-05-10 10:57:57','2016-05-10 18:57:57'),(157,'http://localhost:8000/img/1462950094-003.png',4,'open','2016-05-11 07:01:34','2016-05-11 15:01:52'),(158,'http://localhost:8000/img/1462950099-009.png',2,'delete','2016-05-11 07:01:39','2016-05-11 15:02:44'),(159,'http://localhost:8000/img/1462950103-004.png',1,'open','2016-05-11 07:01:44','2016-05-11 15:01:52'),(160,'http://localhost:8000/img/1462950109-004.png',1,'open','2016-05-11 07:01:49','2016-05-11 15:01:52'),(161,'http://localhost:8000/img/1462950284-004.png',3,'delete','2016-05-11 07:04:44','2016-05-11 15:05:00'),(162,'http://localhost:8000/img/1462950286-002.png',3,'delete','2016-05-11 07:04:47','2016-05-11 15:05:15'),(163,'http://localhost:8000/img/1462950343-006.png',3,'delete','2016-05-11 07:05:44','2016-05-11 15:06:03'),(164,'http://localhost:8000/img/1462950351-005.png',3,'delete','2016-05-11 07:05:51','2016-05-26 21:47:30'),(165,'http://localhost:8000/img/1462950392-007.png',3,'delete','2016-05-11 07:06:32','2016-05-11 15:06:58'),(166,'http://localhost:8000/img/1462950400-003.png',3,'delete','2016-05-11 07:06:40','2016-05-11 15:07:08'),(167,'http://localhost:8000/img/1462951658-007.png',3,'delete','2016-05-11 07:27:38','2016-05-11 15:27:40'),(168,'http://localhost:8000/img/1462952266-012.png',3,'delete','2016-05-11 07:37:46','2016-05-11 15:37:48'),(169,'http://localhost:8000/img/1462955056-006.png',3,'delete','2016-05-11 08:24:16','2016-06-22 16:08:06'),(170,'http://localhost:8000/img/1462955065-012.png',4,'open','2016-05-11 08:24:26','2016-05-11 16:25:51'),(171,'http://localhost:8000/img/1462955096-004.png',1,'open','2016-05-11 08:24:56','2016-05-11 16:25:51'),(172,'http://localhost:8000/img/1462955108-002.png',2,'open','2016-05-11 08:25:08','2016-05-11 16:25:51'),(173,'http://localhost:8000/img/1462955149-002.png',5,'open','2016-05-11 08:25:50','2016-05-11 16:25:51'),(174,'http://localhost:8000/img/1463730801-1457418229-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'delete','2016-05-20 07:53:22','2016-05-20 16:32:53'),(175,'http://localhost:8000/img/1463733187-1457418241-1456969123-螢幕快照 2016-02-23 下午312321.png',3,'open','2016-05-20 08:33:07','2016-05-20 16:33:09'),(176,'http://localhost:8000/img/1464332294-curator.JPG',3,'delete','2016-05-27 06:58:14','2016-05-27 14:58:17'),(177,'http://localhost:8000/img/1464338261-IMG_3659.JPG',2,'open','2016-05-27 08:37:42','2016-05-27 16:37:43'),(178,'http://localhost:8000/img/1464759174-10270742_1162419533769156_3783256124732369050_n.jpg',1,'delete','2016-06-01 05:32:55','2016-06-01 14:07:50'),(179,'http://localhost:8000/img/1464759185-10270742_1162419533769156_3783256124732369050_n.jpg',1,'delete','2016-06-01 05:33:05','2016-06-01 13:54:46'),(180,'http://localhost:8000/img/1464760491-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-06-01 05:54:52','2016-06-01 14:08:26'),(181,'http://localhost:8000/img/1464760918-index_slider.jpg',1,'open','2016-06-01 06:01:58','2016-06-01 14:01:58'),(182,'http://localhost:8000/img/1464760922-index_slider2.jpg',1,'delete','2016-06-01 06:02:02','2016-06-01 14:35:31'),(183,'http://localhost:8000/img/1464761166-IMG_3646.JPG',1,'open','2016-06-01 06:06:06','2016-06-01 14:06:06'),(184,'http://localhost:8000/img/1464761182-curator.jpg',1,'open','2016-06-01 06:06:23','2016-06-01 14:06:23'),(185,'http://localhost:8000/img/1464761302-012.png',1,'open','2016-06-01 06:08:23','2016-06-01 14:08:23'),(186,'http://localhost:8000/img/1464761316-010.png',1,'delete','2016-06-01 06:08:36','2016-06-01 14:09:04'),(187,'http://localhost:8000/img/1464763089-004.png',1,'open','2016-06-01 06:38:09','2016-06-01 14:38:09'),(188,'http://localhost:8000/img/1464763154-009.png',1,'delete','2016-06-01 06:39:14','2016-06-01 14:48:22'),(189,'http://localhost:8000/img/1464763709-007.png',1,'open','2016-06-01 06:48:29','2016-06-01 14:48:29'),(190,'http://localhost:8000/img/1464763757-006.png',1,'open','2016-06-01 06:49:17','2016-06-01 14:49:17'),(191,'http://localhost:8000/img/1464763774-005.png',1,'open','2016-06-01 06:49:34','2016-06-01 14:49:34'),(192,'http://localhost:8000/img/1464763822-010.png',1,'open','2016-06-01 06:50:22','2016-06-01 14:50:22'),(193,'http://localhost:8000/img/1464763831-010.png',1,'open','2016-06-01 06:50:32','2016-06-01 14:50:32'),(194,'http://localhost:8000/img/1464763849-005.png',1,'open','2016-06-01 06:50:49','2016-06-01 14:50:49'),(195,'http://localhost:8000/img/1464763875-009.png',1,'open','2016-06-01 06:51:15','2016-06-01 14:51:15'),(196,'http://localhost:8000/img/1464763891-009.png',1,'open','2016-06-01 06:51:31','2016-06-01 14:51:31'),(197,'http://localhost:8000/img/1464763972-013.png',1,'delete','2016-06-01 06:52:52','2016-06-01 15:13:37'),(198,'http://localhost:8000/img/1464764182-005.png',1,'open','2016-06-01 06:56:22','2016-06-01 14:56:22'),(199,'http://localhost:8000/img/1464863905-1457415223-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-06-02 10:38:25','2016-06-02 18:38:26'),(200,'http://localhost:8000/img/1464863968-1458116447-kuma.jpg',1,'open','2016-06-02 10:39:28','2016-06-02 18:39:28'),(201,'http://localhost:8000/img/1464863976-1457417969-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-06-02 10:39:36','2016-06-02 18:39:36'),(202,'http://localhost:8000/img/1464864576-1457417969-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-06-02 10:49:37','2016-06-02 18:49:37'),(203,'http://localhost:8000/img/1464864584-1457418229-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-06-02 10:49:44','2016-06-02 18:49:44'),(204,'http://localhost:8000/img/1464864614-1464763831-010.png',1,'close','2016-06-02 10:50:14','2016-06-02 18:50:14'),(205,'http://localhost:8000/img/1464864626-1458801747-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'close','2016-06-02 10:50:27','2016-06-02 18:50:27'),(206,'http://localhost:8000/img/1464864688-1457418241-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'open','2016-06-02 10:51:29','2016-06-02 18:51:29'),(207,'http://localhost:8000/img/1464864735-1458116571-badCat.jpg',1,'open','2016-06-02 10:52:15','2016-06-02 18:52:15'),(208,'http://localhost:8000/img/1464864750-1458116447-kuma.jpg',1,'delete','2016-06-02 10:52:30','2016-06-21 11:38:43'),(209,'http://localhost:8000/img/1464864759-1458116447-kuma.jpg',1,'delete','2016-06-02 10:52:40','2016-06-24 15:21:35'),(210,'http://localhost:8000/img/1464864774-1458801347-S__4349957.jpg',1,'open','2016-06-02 10:52:54','2016-06-02 18:52:54'),(211,'http://localhost:8000/img/1464864814-1458116571-badCat.jpg',1,'open','2016-06-02 10:53:34','2016-06-02 18:53:34'),(212,'http://localhost:8000/img/1465363170-BG.png',1,'open','2016-06-08 05:19:30','2016-06-08 13:19:30'),(213,'http://localhost:8000/img/1465363629-10270742_1162419533769156_3783256124732369050_n.jpg',1,'open','2016-06-08 05:27:09','2016-06-08 13:27:09'),(214,'http://localhost:8000/img/1465363749-10270742_1162419533769156_3783256124732369050_n.jpg',1,'open','2016-06-08 05:29:09','2016-06-08 13:29:09'),(215,'http://localhost:8000/img/1465363756-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-06-08 05:29:17','2016-06-08 13:41:30'),(216,'http://localhost:8000/img/1465363809-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-06-08 05:30:09','2016-06-08 13:33:07'),(217,'http://localhost:8000/img/1465363994-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-06-08 05:33:15','2016-06-08 13:45:26'),(218,'http://localhost:8000/img/1465364062-1456969123-螢幕快照 2016-02-23 下午312321.png',1,'delete','2016-06-08 05:34:23','2016-06-08 13:45:29'),(219,'http://localhost:8000/img/1465364090-313330.jpg',1,'delete','2016-06-08 05:34:50','2016-06-08 13:34:53'),(220,'http://localhost:8000/img/1465364592-1456969123- 2016-02-23 下午312321.png',1,'delete','2016-06-08 05:43:12','2016-06-08 13:45:23'),(221,'http://localhost:8000/img/1465364734-1456969123.png',1,'open','2016-06-08 05:45:35','2016-06-08 13:45:35'),(222,'http://localhost:8000/img/1465895198-1456969123.png',1,'open','2016-06-14 09:06:38','2016-06-14 17:06:38'),(223,'http://localhost:8000/img/1465895622-10270742_1162419533769156_3783256124732369050_n.jpg',1,'delete','2016-06-14 09:13:42','2016-06-14 17:15:07'),(224,'http://localhost:8000/img/1465895715-10270742_1162419533769156_3783256124732369050_n.jpg',1,'open','2016-06-14 09:15:15','2016-06-14 17:15:15'),(225,'http://localhost:8000/img/1466065251-1456969123.png',3,'delete','2016-06-16 08:20:51','2016-06-16 16:20:53'),(226,'http://localhost:8000/img/1466400284-content_29e5fa4a-cb35-4044-a3c7-ea8876ab63ae.jpg',1,'close','2016-06-20 05:24:44','2016-06-20 13:24:44'),(227,'http://localhost:8000/img/1466480329-007.png',1,'delete','2016-06-21 03:38:49','2016-06-21 11:38:52'),(228,'http://localhost:8000/img/1466481532-007.png',4,'delete','2016-06-21 03:58:52','2016-06-21 11:58:54'),(229,'http://localhost:8000/img/1466481698-009.png',1,'open','2016-06-21 04:01:38','2016-06-21 12:01:38'),(230,'http://localhost:8000/img/1466481740-007.png',1,'open','2016-06-21 04:02:20','2016-06-21 12:02:20'),(231,'http://localhost:8000/img/1466580802-1456969123.png',2,'close','2016-06-22 07:33:22','2016-06-22 15:33:22'),(232,'http://localhost:8000/img/1466581013-1456969123.png',1,'close','2016-06-22 07:36:53','2016-06-22 15:36:53'),(233,'http://localhost:8000/img/1466581038-10270742_1162419533769156_3783256124732369050_n.jpg',1,'open','2016-06-22 07:37:18','2016-06-22 15:37:35'),(234,'http://localhost:8000/img/1466581177-1456969123.png',1,'delete','2016-06-22 07:39:37','2016-06-22 16:06:27'),(235,'http://localhost:8000/img/1466761145-螢幕快照 2016-06-21 12.29.41.png',3,'delete','2016-06-24 09:39:06','2016-06-24 17:39:08'),(236,'http://localhost:8000/img/1466761199-curator.jpg',3,'delete','2016-06-24 09:40:00','2016-06-24 17:40:02'),(237,'http://localhost:8000/img/1466761404-005.png',3,'delete','2016-06-24 09:43:24','2016-06-24 17:43:26'),(238,'http://localhost:8000/img/1466761428-curator.jpg',3,'delete','2016-06-24 09:43:48','2016-06-24 17:43:50'),(239,'http://localhost:8000/img/1466773461-007.png',3,'open','2016-06-24 13:04:21','2016-06-24 21:04:23'),(240,'http://localhost:8000/img/1467189841-009.png',3,'close','2016-06-29 08:44:01','2016-06-29 16:44:01'),(241,'http://localhost:8000/img/1467373034-13340255_990686894380714_3461832968264704477_o.jpg',2,'open','2016-07-01 11:37:14','2016-07-01 19:37:20'),(242,'http://localhost:8000/img/1467446003-13340255_990686894380714_3461832968264704477_o.jpg',1,'open','2016-07-02 07:53:23','2016-07-02 15:53:23'),(243,'http://localhost:8000/img/1467534712-螢幕快照 2016-07-03 16.31.01.png',2,'open','2016-07-03 08:31:52','2016-07-03 16:32:03'),(244,'http://localhost:8000/img/1467535769-activated carbon(3).jpg',2,'close','2016-07-03 08:49:29','2016-07-03 16:49:29'),(245,'http://localhost:8000/img/1467535776-activated carbon(3).jpg',1,'close','2016-07-03 08:49:36','2016-07-03 16:49:36'),(246,'http://localhost:8000/img/1467535784-activated carbon(3).jpg',1,'close','2016-07-03 08:49:44','2016-07-03 16:49:44'),(247,'http://localhost:8000/img/1467535825-activated carbon(3).jpg',2,'close','2016-07-03 08:50:25','2016-07-03 16:50:25'),(248,'http://localhost:8000/img/1467545020-img1.jpg',2,'close','2016-07-03 11:23:40','2016-07-03 19:23:40'),(249,'http://localhost:8000/img/1467649262-1456969123.png',1,'open','2016-07-04 16:21:03','2016-07-05 00:21:03'),(250,'http://localhost:8000/img/1467708783-1456969123.png',1,'open','2016-07-05 08:53:03','2016-07-05 16:53:04'),(251,'http://localhost:8000/img/1469398594-logo_cube.png',1,'open','2016-07-24 22:16:34','2016-07-25 06:16:36'),(252,'http://localhost:8000/img/home/banner-slider/slider-bg.jpg',1,'open','2016-07-25 03:35:51','2016-07-25 11:35:52'),(253,'http://localhost:8000/img/home/banner-slider/slider-bg.jp',1,'open','2016-07-25 03:36:26','2016-07-25 11:36:26'),(254,'http://localhost:8000/img/1469541615-kuma.jpg',1,'open','2016-07-26 14:00:15','2016-07-26 22:00:15'),(255,'http://localhost:8000/img/1469541660-kuma.jpg',1,'open','2016-07-26 14:01:00','2016-07-26 22:01:00'),(256,'http://localhost:8000/img/1469541932-kuma.jpg',1,'open','2016-07-26 14:05:32','2016-07-26 22:05:32'),(257,'http://localhost:8000/img/1469542071-kuma.jpg',1,'open','2016-07-26 14:07:51','2016-07-26 22:07:51'),(258,'http://localhost:8000/img/1469542104-kuma.jpg',1,'open','2016-07-26 14:08:24','2016-07-26 22:08:24'),(259,'http://localhost:8000/img/1469542145-kuma.jpg',1,'open','2016-07-26 14:09:05','2016-07-26 22:09:05'),(260,'http://localhost:8000/img/1469542178-VersionDesignLogo_small.png',1,'open','2016-07-26 14:09:38','2016-07-26 22:09:39'),(261,'http://localhost:8000/img/1469542269-kuma.jpg',1,'open','2016-07-26 14:11:09','2016-07-26 22:11:09'),(262,'http://localhost:8000/img/1469542294-VersionDesignLogo_small.png',1,'open','2016-07-26 14:11:34','2016-07-26 22:11:34'),(263,'http://localhost:8000/img/1469542398-VersionDesignLogo_small.png',1,'open','2016-07-26 14:13:18','2016-07-26 22:13:18'),(264,'http://localhost:8000/img/1469542616-VersionDesignLogo_small.png',1,'open','2016-07-26 14:16:56','2016-07-26 22:16:56'),(265,'http://localhost:8000/img/1469781363-kuma.jpg',1,'open','2016-07-29 08:36:03','2016-07-29 16:36:05'),(266,'http://localhost:8000/img/1471387370-VersionDesignLogo.png',1,'open','2016-08-16 22:42:50','2016-08-17 06:42:50'),(267,'http://localhost:8000/img/1471390574-kuma.jpg',2,'open','2016-08-16 23:36:14','2016-08-17 07:36:16'),(268,'http://localhost:8000/img/1472629172-p1.jpg',1,'delete','2016-08-31 07:39:32','2016-08-31 15:40:35'),(269,'http://localhost:8000/img/1472629233-S__14958637.jpg',1,'delete','2016-08-31 07:40:33','2017-02-22 15:31:53'),(270,'http://localhost:8000/img/1472629310-p3.jpg',1,'open','2016-08-31 07:41:50','2016-08-31 15:41:52'),(271,'http://localhost:8000/img/1472629325-p1.jpg',1,'open','2016-08-31 07:42:05','2016-08-31 15:42:06'),(272,'http://localhost:8000/img/1472629339-p2.jpg',1,'open','2016-08-31 07:42:19','2016-08-31 15:42:21'),(273,'http://localhost:8000/img/1472629356-S__14958639.jpg',1,'open','2016-08-31 07:42:36','2016-08-31 15:42:38'),(274,'http://localhost:8000/img/1472629373-S__14958638.jpg',1,'open','2016-08-31 07:42:53','2016-08-31 15:42:55'),(275,'http://localhost:8000/img/1474943904-1474873326-首頁照.jpg',1,'open','2016-09-27 02:38:24','2016-09-27 10:38:24'),(276,'http://localhost:8000/img/1474965044-p3.jpg',1,'delete','2016-09-27 08:30:44','2016-09-27 16:31:13'),(277,'http://localhost:8000/img/1475016652-kuma.jpg',1,'open','2016-09-27 22:50:52','2016-09-28 06:50:54'),(278,'http://localhost:8000/img/1477658910-14550982_1238635936188295_1015699844_o.jpg',1,'delete','2016-10-28 12:48:31','2016-10-28 20:49:40'),(279,'http://localhost:8000/img/1477659073-14522180_1238766559508566_688553111_o.jpg',1,'delete','2016-10-28 12:51:13','2016-10-28 20:52:13'),(280,'http://localhost:8000/img/1477668983-badCat.jpg',1,'delete','2016-10-28 15:36:23','2016-10-28 23:36:38'),(281,'http://localhost:8000/img/1478098686-1475637321-開幕永山納豆banner.jpg',1,'delete','2016-11-02 14:58:06','2016-11-02 23:28:49'),(282,'http://localhost:8000/img/1478100557-1475637321-開幕永山納豆banner.jpg',1,'delete','2016-11-02 15:29:17','2016-11-02 23:30:17'),(283,'http://localhost:8000/img/1478100653-1475637321-開幕永山納豆banner.jpg',1,'open','2016-11-02 15:30:53','2016-11-02 23:30:53'),(284,'http://localhost:8000/img/1479102221-螢幕快照 2016-10-30 下午11.28.15.png',1,'close','2016-11-14 05:43:41','2016-11-14 13:43:41'),(285,'http://localhost:8000/img/1487320038-黑蒜頭slider.jpg',1,'delete','2017-02-17 08:27:18','2017-02-17 20:26:51'),(286,'http://localhost:8000/img/1487320049-kuma.jpg',3,'delete','2017-02-17 08:27:29','2017-02-18 00:57:02'),(287,'http://localhost:8000/img/1487320114-badCat.jpg',5,'delete','2017-02-17 08:28:34','2017-02-17 16:28:52'),(288,'http://localhost:8000/img/1487334426-p2.jpg',2,'delete','2017-02-17 12:27:06','2017-02-17 20:34:52'),(289,'http://localhost:8000/img/1487349856-p1.jpg',5,'close','2017-02-17 16:44:16','2017-02-18 00:44:16'),(290,'http://localhost:8000/img/1487350038-p3.jpg',5,'open','2017-02-17 16:47:18','2017-02-18 00:47:21'),(291,'http://localhost:8000/img/1487350667-kuma.jpg',1,'open','2017-02-17 16:57:47','2017-02-18 00:57:56'),(292,'http://localhost:8000/img/1487399646-1487385278-2瓶組主圖.jpg',1,'open','2017-02-18 06:34:07','2017-02-18 14:34:15'),(293,'http://localhost:8000/img/1487399977-1487385278-2瓶組主圖.jpg',1,'open','2017-02-18 06:39:37','2017-02-18 14:39:39'),(294,'http://localhost:8000/img/1487400071-1487385278-2瓶組主圖.jpg',2,'open','2017-02-18 06:41:11','2017-02-18 14:41:24'),(295,'http://localhost:8000/img/1487557927-2瓶組主圖.jpg',1,'open','2017-02-20 02:32:07','2017-02-20 10:32:11'),(296,'http://localhost:8000/img/1487748709-2瓶組主圖.jpg',2,'open','2017-02-22 07:31:49','2017-02-22 19:58:47'),(297,'http://localhost:8000/img/1487748722-螢幕快照 2017-02-22 上午1.53.52.png',1,'delete','2017-02-22 07:32:02','2017-02-22 15:33:39'),(298,'http://localhost:8000/img/1487748833-野口甲殼素_01.jpg',3,'open','2017-02-22 07:33:53','2017-02-22 19:58:47');
227/*!40000 ALTER TABLE `IMG` ENABLE KEYS */;
228UNLOCK TABLES;
229
230--
231-- Table structure for table `JOB`
232--
233
234DROP TABLE IF EXISTS `JOB`;
235/*!40101 SET @saved_cs_client     = @@character_set_client */;
236/*!40101 SET character_set_client = utf8 */;
237CREATE TABLE `JOB` (
238  `ID` int(11) NOT NULL AUTO_INCREMENT,
239  `BRANCH_ID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
240  `JOB_TITLE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '職稱',
241  `QTY` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '需求人數',
242  `MOMENT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '上班時段',
243  `TYPE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '工作性質',
244  `RESPONSIBILITY` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '管理責任',
245  `BUSINESS_TRIP` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '出差外派',
246  `VACATION_POLICY` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '休假制度',
247  `SALARY_RANGE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '薪資範圍',
248  `EXPERIENCE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '工作經驗',
249  `CAN_WORK_DATE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '可上班日',
250  `DETAIL` text COLLATE utf8_unicode_ci COMMENT '工作內容',
251  `WELFARE_POLICY` text COLLATE utf8_unicode_ci COMMENT '福利制度',
252  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
253  `CREATED_AT` timestamp NULL DEFAULT NULL,
254  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
255  PRIMARY KEY (`ID`)
256) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
257/*!40101 SET character_set_client = @saved_cs_client */;
258
259--
260-- Dumping data for table `JOB`
261--
262
263LOCK TABLES `JOB` WRITE;
264/*!40000 ALTER TABLE `JOB` DISABLE KEYS */;
265INSERT INTO `JOB` VALUES (1,'3','資訊助理','1','日班/晚班，需輪班','全職','不需負擔管理責任','無需出差外派','依公司規定',NULL,NULL,'一週內','1.負責介紹及銷售門市商品<br>\n	                                        2.提供顧客接待與需求服務<br>\n	                                        3.負責商品進貨入庫、銷售管理及庫存管理<br>\n	                                        4.負責商品包裝、陳列及促銷品換檔工作<br>\n	                                        5.維持店櫃週遭整潔','勞保、健保、加班費、勞退提撥金<br>\n	                                        獎金類 /<br>\n	                                        全勤獎金、年節獎金、年終獎金、三節獎金<br>\n	                                        補助類 / <br>\n	                                        員工結婚補助、生育補助、員工退休規劃（包括退休金及退休後之福利等）、員工及眷屬喪葬補助<br>\n	                                        其    他 / <br>\n	                                        員工在職教育訓練、良好升遷制度','open',NULL,'2016-10-02 13:47:48'),(2,'4','門市人員','1','日班/晚班，需輪班','全職','不需負擔管理責任','無需出差外派','依公司規定',NULL,NULL,'一週內','1.負責介紹及銷售門市商品<br>\n	                                        2.提供顧客接待與需求服務<br>\n	                                        3.負責商品進貨入庫、銷售管理及庫存管理<br>\n	                                        4.負責商品包裝、陳列及促銷品換檔工作<br>\n	                                        5.維持店櫃週遭整潔','勞保、健保、加班費、勞退提撥金<br>\n	                                        獎金類 /<br>\n	                                        全勤獎金、年節獎金、年終獎金、三節獎金<br>\n	                                        補助類 / <br>\n	                                        員工結婚補助、生育補助、員工退休規劃（包括退休金及退休後之福利等）、員工及眷屬喪葬補助<br>\n	                                        其    他 / <br>\n	                                        員工在職教育訓練、良好升遷制度','delete','2016-10-03 13:50:13','2016-10-12 03:14:39');
266/*!40000 ALTER TABLE `JOB` ENABLE KEYS */;
267UNLOCK TABLES;
268
269--
270-- Table structure for table `JOB_SEEKER`
271--
272
273DROP TABLE IF EXISTS `JOB_SEEKER`;
274/*!40101 SET @saved_cs_client     = @@character_set_client */;
275/*!40101 SET character_set_client = utf8 */;
276CREATE TABLE `JOB_SEEKER` (
277  `ID` int(11) NOT NULL AUTO_INCREMENT,
278  `JOB_ID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
279  `NAME` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
280  `PHONE` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
281  `EMAIL` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
282  `TIMECHECK` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
283  `BIRTHDAY` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
284  `EXPERIENCE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
285  `URL` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
286  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
287  `CREATED_AT` timestamp NULL DEFAULT NULL,
288  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
289  PRIMARY KEY (`ID`)
290) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
291/*!40101 SET character_set_client = @saved_cs_client */;
292
293--
294-- Dumping data for table `JOB_SEEKER`
295--
296
297LOCK TABLES `JOB_SEEKER` WRITE;
298/*!40000 ALTER TABLE `JOB_SEEKER` DISABLE KEYS */;
299INSERT INTO `JOB_SEEKER` VALUES (1,'1','test','12345678','test@gmail.com','allday',NULL,NULL,NULL,'open','2016-10-11 23:46:42','2016-10-12 04:03:53');
300/*!40000 ALTER TABLE `JOB_SEEKER` ENABLE KEYS */;
301UNLOCK TABLES;
302
303--
304-- Table structure for table `MEMBER`
305--
306
307DROP TABLE IF EXISTS `MEMBER`;
308/*!40101 SET @saved_cs_client     = @@character_set_client */;
309/*!40101 SET character_set_client = utf8 */;
310CREATE TABLE `MEMBER` (
311  `ID` int(11) NOT NULL AUTO_INCREMENT,
312  `IMG_ID` longtext CHARACTER SET latin1,
313  `ACCOUNT` varchar(45) CHARACTER SET utf8 NOT NULL,
314  `PASSWORD` longtext CHARACTER SET latin1 NOT NULL,
315  `SEX` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
316  `USERNAME` varchar(45) CHARACTER SET utf8 NOT NULL,
317  `BIRTHDAY` varchar(45) CHARACTER SET utf8 NOT NULL,
318  `MOBILEPHONE` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
319  `EMAIL` varchar(100) CHARACTER SET latin1 NOT NULL,
320  `COUNTRY` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
321  `CITY` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
322  `ZONE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
323  `ZIP` int(11) DEFAULT NULL,
324  `ADDRESS` varchar(90) CHARACTER SET utf8 DEFAULT NULL,
325  `VILLAGE` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '村里\n',
326  `ROAD` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '路街',
327  `NEIGHBOR` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT 'é„°',
328  `SECTION` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '段',
329  `LANE` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT 'å··',
330  `ALLEY` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '弄\n',
331  `NUMBER` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '號',
332  `FLOOR` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '樓\n',
333  `ACCESSTOKEN` longtext CHARACTER SET latin1 NOT NULL,
334  `STATUS` varchar(45) CHARACTER SET latin1 NOT NULL,
335  `CREATED_AT` timestamp NULL DEFAULT NULL,
336  `UPDATED_AT` timestamp NULL DEFAULT NULL,
337  PRIMARY KEY (`ID`)
338) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
339/*!40101 SET character_set_client = @saved_cs_client */;
340
341--
342-- Dumping data for table `MEMBER`
343--
344
345LOCK TABLES `MEMBER` WRITE;
346/*!40000 ALTER TABLE `MEMBER` DISABLE KEYS */;
347INSERT INTO `MEMBER` VALUES (1,'[]','test','12345','female','test','2016-07-13','952736897','test@gmail.com','台灣','名間鄉','中山區',551,'中正村董門巷87之5號','','',NULL,NULL,NULL,NULL,NULL,NULL,'','open','2016-07-13 11:27:33','2016-11-04 08:16:14'),(2,'[]','NULL','123123','female','hacktechtw','2016-11-04','952736897','gn02158263@gmail.com','台灣','名間鄉','NULL',551,'中正村董門巷87之5號','','',NULL,NULL,NULL,NULL,NULL,NULL,'','open','2016-11-03 17:21:40','2016-11-03 17:26:09'),(3,'[]','NULL','123123','female','TEST','2016-11-04','0952736897','abc@gmail.com','美國','名間鄉','',551,'中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','open','2016-11-04 08:12:58','2016-11-04 08:12:58'),(4,'[]','NULL','123123','female','hacktech','2016-11-04','0952736897','test123@gmail.com','日本','名間鄉','',551,'中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','open','2016-11-04 09:53:43','2016-11-04 09:57:35'),(5,'[]','123@gmail.com','123123','female','123','-2177481600','9527368970','gn02158263@gmail.com','1','2',NULL,3,'5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','open','2017-01-25 21:04:13','2017-03-14 03:53:42'),(6,'[]','NULL','12345','female','hacktechtw','2017-01-02','0952736897','test3@gmail.com','TA','32',NULL,555,'dddddd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','open','2017-03-14 04:48:50','2017-03-14 04:48:50');
348/*!40000 ALTER TABLE `MEMBER` ENABLE KEYS */;
349UNLOCK TABLES;
350
351--
352-- Table structure for table `NEWS`
353--
354
355DROP TABLE IF EXISTS `NEWS`;
356/*!40101 SET @saved_cs_client     = @@character_set_client */;
357/*!40101 SET character_set_client = utf8 */;
358CREATE TABLE `NEWS` (
359  `ID` int(11) NOT NULL AUTO_INCREMENT,
360  `TYPE_ID` varchar(45) CHARACTER SET utf8 NOT NULL,
361  `SUBJECT` varchar(45) COLLATE utf8_latvian_ci NOT NULL COMMENT '標題名稱\n只存繁體中文 提供後台快速搜尋',
362  `CONTENT` text CHARACTER SET utf8 NOT NULL,
363  `IMG_ID` text CHARACTER SET utf8,
364  `SORT` varchar(45) COLLATE utf8_latvian_ci NOT NULL,
365  `CREATED_AT` timestamp NULL DEFAULT NULL,
366  `UPDATED_AT` timestamp NULL DEFAULT NULL,
367  `STATUS` varchar(45) CHARACTER SET utf8 NOT NULL,
368  PRIMARY KEY (`ID`)
369) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
370/*!40101 SET character_set_client = @saved_cs_client */;
371
372--
373-- Dumping data for table `NEWS`
374--
375
376LOCK TABLES `NEWS` WRITE;
377/*!40000 ALTER TABLE `NEWS` DISABLE KEYS */;
378INSERT INTO `NEWS` VALUES (1,'1','保羅開幕3','\n                                              \n                                              <span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測試</span><span style=\"line-height: 18.5714px;\">測ㄅ</span><br>\n                                            \n                                            ','[251]','2','2016-07-01 11:37:20','2016-07-24 22:16:36','open');
379/*!40000 ALTER TABLE `NEWS` ENABLE KEYS */;
380UNLOCK TABLES;
381
382--
383-- Table structure for table `NEWS_INFO`
384--
385
386DROP TABLE IF EXISTS `NEWS_INFO`;
387/*!40101 SET @saved_cs_client     = @@character_set_client */;
388/*!40101 SET character_set_client = utf8 */;
389CREATE TABLE `NEWS_INFO` (
390  `ID` int(11) NOT NULL AUTO_INCREMENT,
391  `NID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
392  `LANGUAGE` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
393  `SUBJECT` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
394  `CONTENT` text COLLATE utf8_unicode_ci NOT NULL,
395  `CREATED_AT` timestamp NULL DEFAULT NULL,
396  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
397  PRIMARY KEY (`ID`)
398) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
399/*!40101 SET character_set_client = @saved_cs_client */;
400
401--
402-- Dumping data for table `NEWS_INFO`
403--
404
405LOCK TABLES `NEWS_INFO` WRITE;
406/*!40000 ALTER TABLE `NEWS_INFO` DISABLE KEYS */;
407/*!40000 ALTER TABLE `NEWS_INFO` ENABLE KEYS */;
408UNLOCK TABLES;
409
410--
411-- Table structure for table `NEWS_TYPE`
412--
413
414DROP TABLE IF EXISTS `NEWS_TYPE`;
415/*!40101 SET @saved_cs_client     = @@character_set_client */;
416/*!40101 SET character_set_client = utf8 */;
417CREATE TABLE `NEWS_TYPE` (
418  `ID` int(11) NOT NULL AUTO_INCREMENT,
419  `NAME` varchar(45) COLLATE utf8_latvian_ci NOT NULL COMMENT '名稱\n只存繁體中文 提供後台快速搜尋',
420  `SORT` varchar(45) COLLATE utf8_latvian_ci NOT NULL,
421  `STATUS` varchar(45) CHARACTER SET utf8 NOT NULL,
422  `CREATED_AT` timestamp NULL DEFAULT NULL,
423  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
424  PRIMARY KEY (`ID`)
425) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
426/*!40101 SET character_set_client = @saved_cs_client */;
427
428--
429-- Dumping data for table `NEWS_TYPE`
430--
431
432LOCK TABLES `NEWS_TYPE` WRITE;
433/*!40000 ALTER TABLE `NEWS_TYPE` DISABLE KEYS */;
434INSERT INTO `NEWS_TYPE` VALUES (1,'haha','','','2016-07-01 11:36:29','2016-12-01 01:15:56');
435/*!40000 ALTER TABLE `NEWS_TYPE` ENABLE KEYS */;
436UNLOCK TABLES;
437
438--
439-- Table structure for table `NEWS_TYPE_INFO`
440--
441
442DROP TABLE IF EXISTS `NEWS_TYPE_INFO`;
443/*!40101 SET @saved_cs_client     = @@character_set_client */;
444/*!40101 SET character_set_client = utf8 */;
445CREATE TABLE `NEWS_TYPE_INFO` (
446  `ID` int(11) NOT NULL AUTO_INCREMENT,
447  `NTYPE_ID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
448  `LANGUAGE` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
449  `NAME` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
450  `CREATED_AT` timestamp NULL DEFAULT NULL,
451  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
452  PRIMARY KEY (`ID`)
453) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
454/*!40101 SET character_set_client = @saved_cs_client */;
455
456--
457-- Dumping data for table `NEWS_TYPE_INFO`
458--
459
460LOCK TABLES `NEWS_TYPE_INFO` WRITE;
461/*!40000 ALTER TABLE `NEWS_TYPE_INFO` DISABLE KEYS */;
462/*!40000 ALTER TABLE `NEWS_TYPE_INFO` ENABLE KEYS */;
463UNLOCK TABLES;
464
465--
466-- Table structure for table `ORDER`
467--
468
469DROP TABLE IF EXISTS `ORDER`;
470/*!40101 SET @saved_cs_client     = @@character_set_client */;
471/*!40101 SET character_set_client = utf8 */;
472CREATE TABLE `ORDER` (
473  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水號',
474  `MID` int(11) DEFAULT NULL,
475  `PRODUCT_LIST` text COLLATE utf8_latvian_ci COMMENT '購物清單',
476  `STATUS` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '狀態',
477  `SHIPPING_NUMBER` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '送貨編號',
478  `SHIPPING_WAY` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '送貨方式',
479  `SHIPPING_COST` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '運費',
480  `SHIPPING_DATE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '送貨日期',
481  `PAYMENT_TYPE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '付款狀態',
482  `PAYMENT_NAME` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '付款人姓名',
483  `PAYMENT_PHONE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '付款人電話',
484  `PAYMENT_EMAIL` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '付款人電子郵件',
485  `PAYMENT_ADDRESS_COUNTRY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
486  `PAYMENT_ADDRESS_CITY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
487  `PAYMENT_ADDRESS_ZONE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
488  `PAYMENT_ADDRESS_ZIP` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
489  `PAYMENT_ADDRESS` text COLLATE utf8_latvian_ci,
490  `PAYMENT_ADDRESS_VILLAGE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '村里',
491  `PAYMENT_ADDRESS_ROAD` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '路街',
492  `PAYMENT_ADDRESS_NEIGHBOR` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT 'é„°',
493  `PAYMENT_ADDRESS_SECTION` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '段',
494  `PAYMENT_ADDRESS_ALLEY` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '弄',
495  `PAYMENT_ADDRESS_LANE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT 'å··',
496  `PAYMENT_ADDRESS_NUMBER` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '號',
497  `PAYMENT_ADDRESS_FLOOR` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '樓',
498  `CONSIGNEE_NAME` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '連絡人姓名',
499  `CONSIGNEE_PHONE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '連絡人電話',
500  `CONSIGNEE_EMAIL` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '連絡人電子郵件',
501  `CONSIGNEE_ADDRESS_COUNTRY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
502  `CONSIGNEE_ADDRESS_CITY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
503  `CONSIGNEE_ADDRESS_ZONE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
504  `CONSIGNEE_ADDRESS_ZIP` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
505  `CONSIGNEE_ADDRESS` text COLLATE utf8_latvian_ci,
506  `CONSIGNEE_ADDRESS_VILLAGE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '村里',
507  `CONSIGNEE_ADDRESS_ROAD` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '路街',
508  `CONSIGNEE_ADDRESS_NEIGHBOR` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT 'é„°',
509  `CONSIGNEE_ADDRESS_SECTION` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '段',
510  `CONSIGNEE_ADDRESS_LANE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT 'å··',
511  `CONSIGNEE_ADDRESS_ALLEY` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '弄',
512  `CONSIGNEE_ADDRESS_NUMBER` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '號',
513  `CONSIGNEE_ADDRESS_FLOOR` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '樓',
514  `TAX_ID` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '統一編號\n',
515  `COMPANY_NAME` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
516  `COMPANY_ADDRESS` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
517  `COMPANY_ZIP` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
518  `INVOICE_TYPE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '發票類型',
519  `INVOICE_NUMBER` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '發票號碼',
520  `TAX` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '稅額',
521  `NOTE` mediumtext CHARACTER SET utf8 COMMENT '備註',
522  `DISCOUNT` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '優惠卷代碼',
523  `TOTAL_PRICE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '總額價格',
524  `CREATED_AT` timestamp NULL DEFAULT NULL,
525  `UPDATED_AT` timestamp NULL DEFAULT NULL,
526  `DISCOUNT_TOTAL` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT '優惠金額',
527  `SHIPPING_DATE_LIST` mediumtext COLLATE utf8_latvian_ci COMMENT '收件日期',
528  `PAYMENT_TRADE_NO` varchar(250) COLLATE utf8_latvian_ci DEFAULT NULL,
529  `PAYMENT_ORDER_NO` varchar(250) COLLATE utf8_latvian_ci DEFAULT NULL,
530  PRIMARY KEY (`ID`)
531) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
532/*!40101 SET character_set_client = @saved_cs_client */;
533
534--
535-- Dumping data for table `ORDER`
536--
537
538LOCK TABLES `ORDER` WRITE;
539/*!40000 ALTER TABLE `ORDER` DISABLE KEYS */;
540INSERT INTO `ORDER` VALUES (1,1,'[{\"ID\":7,\"TYPE\":\"夏季蔬果\",\"QTY\":\"1\",\"PRICE\":5233,\"SUB_TOTAL\":5233,\"PROMOTIONS_ID\":0},{\"ID\":12,\"TYPE\":\"番茄\",\"QTY\":2,\"PRICE\":120,\"SUB_TOTAL\":240,\"PROMOTIONS_ID\":0},{\"ID\":10,\"TYPE\":\"冬季蔬果\",\"QTY\":\"1\",\"PRICE\":200,\"SUB_TOTAL\":200,\"PROMOTIONS_ID\":0}]','payment',NULL,'[\"home\",\"normal\"]',NULL,'[\"\",\"morning\"]','cashdelivery','asdsa','1233123','123@21312.asda',NULL,NULL,'ADDRESSS','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'43567','duplicate','',NULL,NULL,NULL,'5673','2016-04-24 02:50:56','2016-04-24 02:50:56',NULL,NULL,NULL,NULL),(2,1,'[{\"ID\":49,\"TYPE\":\"\",\"QTY\":\"1\",\"PRICE\":123,\"SUB_TOTAL\":\"123\",\"PROMOTIONS_ID\":0}]','payment',NULL,'[null,null]','0','[\"\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'123','2016-07-29 08:06:47','2016-07-29 08:06:47',NULL,NULL,NULL,NULL),(3,1,'[{\"ID\":49,\"TYPE\":\"\",\"QTY\":\"1\",\"PRICE\":123,\"SUB_TOTAL\":\"123\",\"PROMOTIONS_ID\":0}]','payment',NULL,'[null,null]','0','[\"2016-07-22\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'123','2016-07-29 08:18:01','2016-07-29 08:18:01',NULL,NULL,NULL,NULL),(4,1,'[{\"ID\":49,\"TYPE\":\"\",\"QTY\":\"1\",\"PRICE\":123,\"SUB_TOTAL\":\"123\",\"PROMOTIONS_ID\":0}]','payment',NULL,'[null,null]','0','[\"2016-07-22\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'123','2016-07-29 08:18:52','2016-07-29 08:18:52',NULL,NULL,NULL,NULL),(5,1,'[{\"ID\":49,\"TYPE\":\"\",\"QTY\":\"1\",\"PRICE\":123,\"SUB_TOTAL\":\"123\",\"PROMOTIONS_ID\":0}]','payment',NULL,'[null,null]','0','[\"2016-07-22\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'123','2016-07-29 08:19:16','2016-07-29 08:19:16',NULL,NULL,NULL,NULL),(6,1,'[{\"ID\":49,\"TYPE\":\"\",\"QTY\":\"1\",\"PRICE\":123,\"SUB_TOTAL\":\"123\",\"PROMOTIONS_ID\":0}]','payment',NULL,'[null,null]','0','[\"2016-07-22\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'123','2016-07-29 08:20:26','2016-07-29 08:20:26',NULL,NULL,NULL,NULL),(7,1,'[{\"ID\":49,\"TYPE\":\"\",\"QTY\":\"1\",\"PRICE\":123,\"SUB_TOTAL\":\"123\",\"PROMOTIONS_ID\":0}]','payment',NULL,'[null,null]','0','[\"2016-07-22\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'123','2016-07-29 08:20:57','2016-07-29 08:20:57',NULL,NULL,NULL,NULL),(8,1,'[{\"ID\":49,\"TYPE\":\"\",\"QTY\":\"2\",\"PRICE\":123,\"SUB_TOTAL\":\"246\",\"PROMOTIONS_ID\":0}]','payment',NULL,'[\"home\",\"normal\"]','50','[\"2016-07-27\",\"morning\"]','cashdelivery','test2','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test2','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'246','2016-07-29 08:27:46','2016-07-29 08:27:46',NULL,NULL,NULL,NULL),(9,1,'[{\"ID\":2,\"TYPE\":\"地板清潔\",\"QTY\":\"2\",\"PRICE\":100,\"SUB_TOTAL\":\"200\",\"PROMOTIONS_ID\":0}]','payment','EJ513309341JP','[\"home\",\"normal\"]','65','[\"\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','中山區','104',NULL,'','','','','','','118','','test','0952736897','test@gmail.com',NULL,'臺北市','中山區','104',NULL,'','','','','','','118','','','',NULL,NULL,'null',NULL,NULL,'',NULL,'200','2016-09-14 17:41:51','2016-09-14 17:41:51',NULL,NULL,NULL,NULL),(10,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"QTY\":\"1\",\"PRICE\":22,\"SUB_TOTAL\":\"22\",\"PROMOTIONS_ID\":0}]','payment','EJ513309341JP','[\"home\",\"normal\"]','65','[\"2016-09-15\",\"morning\"]','cashdelivery','test','0952736897','test@gmail.com',NULL,'臺北市','中山區','104',NULL,'','','','','','','118','4-1','test','0952736897','test@gmail.com',NULL,'臺北市','中山區','104',NULL,'','','','','','','118','4','','','',NULL,'null',NULL,NULL,'test',NULL,'22','2016-09-14 18:36:09','2016-09-14 18:57:48',NULL,NULL,NULL,NULL),(11,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"QTY\":\"6\",\"PRICE\":22,\"SUB_TOTAL\":\"132\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','120','[\"\",null]','creditcard','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','null','null',NULL,NULL,'null',NULL,NULL,'',NULL,'132','2016-10-29 19:26:20','2016-10-29 19:26:20',NULL,NULL,NULL,NULL),(12,1,'[{\"ID\":73,\"TYPE\":\"22233\",\"QTY\":\"1\",\"PRICE\":11,\"SUB_TOTAL\":\"369\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"2016-10-05\",null]','creditcard','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','null','null',NULL,NULL,'null',NULL,NULL,'',NULL,'11','2016-10-29 19:44:38','2016-10-29 19:44:38',NULL,NULL,NULL,NULL),(13,1,'[{\"ID\":73,\"TYPE\":\"22233\",\"QTY\":\"1\",\"PRICE\":11,\"SUB_TOTAL\":\"369\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"2016-11-01\",null]','creditcard','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','null','null',NULL,NULL,'null',NULL,NULL,'',NULL,'11','2016-10-29 19:50:11','2016-10-29 19:50:11',NULL,NULL,NULL,NULL),(14,1,'[{\"ID\":73,\"TYPE\":\"22233\",\"COLOR\":\"white\",\"STYLE\":\"men\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":11,\"SUB_TOTAL\":\"369\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"2016-10-10\",\"morning\"]','creditcard','test','0952736897','test@gmail.com',NULL,'臺北市','內湖區','104',NULL,'','','','','','','','','test','0952736897','test@gmail.com',NULL,'臺北市','null','104',NULL,'','','','','','','','','null','null','',NULL,'null',NULL,NULL,'',NULL,'11','2016-10-29 20:12:05','2016-10-30 10:51:13',NULL,NULL,NULL,NULL),(15,1,'[{\"ID\":73,\"TYPE\":\"22233\",\"COLOR\":\"white\",\"STYLE\":\"men\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":11,\"SUB_TOTAL\":\"11\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"2016-11-10\",\"morning\"]','creditcard','WU YUAN YU','952736897','gn02158263@gmail.com','台灣','名間鄉','null','551','中正村董門巷87之5號','','','','','','','','','WU YUAN YU','952736897','gn02158263@gmail.com','台灣','名間鄉','null','551','中正村董門巷87之5號','','','','','','','','','null','null',NULL,NULL,'null',NULL,NULL,'',NULL,'11','2016-10-30 20:06:45','2016-10-31 16:44:14',NULL,NULL,NULL,NULL),(16,1,'[{\"ID\":73,\"TYPE\":\"22233\",\"COLOR\":\"white\",\"STYLE\":\"men\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":11,\"SUB_TOTAL\":\"11\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"2016-11-11\",null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'note',NULL,'11','2016-11-01 20:25:44','2016-11-01 20:25:44',NULL,NULL,NULL,NULL),(17,1,'[{\"ID\":73,\"TYPE\":\"22233\",\"COLOR\":\"white\",\"STYLE\":\"men\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":11,\"SUB_TOTAL\":\"11\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"\",null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'11','2016-11-04 08:30:56','2016-11-04 08:30:56',NULL,NULL,NULL,NULL),(18,1,'[{\"ID\":73,\"TYPE\":\"22233\",\"COLOR\":\"white\",\"STYLE\":\"men\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":11,\"SUB_TOTAL\":\"11\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"2016-11-11\",null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'來電通知','[\"\\u5fc3\\u5f97\\u554f\\u5377\\u586b\\u5beb\\u8005\",\"1691490\"]','11','2016-11-04 10:06:33','2016-11-04 10:06:33','100',NULL,NULL,NULL),(19,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"QTY\":\"2\",\"PRICE\":22,\"SUB_TOTAL\":\"44\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"\",null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','[\"Image Gallery - Add, Select & Delete Thumbnai\",\"asd1232\"]','44','2016-11-26 18:34:10','2016-11-26 18:34:10','50',NULL,NULL,NULL),(20,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":22,\"SUB_TOTAL\":\"22\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"\",null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','[\"\\u6bcd\\u89aa\\u7bc0\",\"asd123\"]','22','2016-11-26 18:49:47','2016-11-26 18:49:47','100',NULL,NULL,NULL),(21,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":22,\"SUB_TOTAL\":\"22\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[\"\",null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','[\"\\u6bcd\\u89aa\\u7bc0\",\"asd123\"]','22','2016-11-26 18:56:23','2016-11-26 18:56:23','100',NULL,NULL,NULL),(22,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"QTY\":\"5\",\"PRICE\":22,\"SUB_TOTAL\":\"110\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[null,null]','creditcard','test123','0952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test123','0952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','[\"\\u6bcd\\u89aa\\u7bc0\",\"asd123\"]','110','2016-11-27 09:11:43','2016-11-27 09:11:43','100',NULL,NULL,NULL),(23,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":22,\"SUB_TOTAL\":\"22\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[null,null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'22','2016-11-28 03:04:20','2016-11-28 03:04:20',NULL,NULL,NULL,NULL),(24,1,'[{\"ID\":38,\"TYPE\":\"洗滌(脫脂)劑\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"QTY\":\"2\",\"PRICE\":22,\"SUB_TOTAL\":\"44\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[null,null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'44','2016-11-28 03:05:26','2016-11-28 03:05:26',NULL,NULL,NULL,NULL),(25,1,'[{\"ID\":38,\"TYPE\":\"托指\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"QTY\":\"1\",\"PRICE\":22,\"SUB_TOTAL\":\"22\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,'[\"ems\",null]','60','[null,null]','creditcard','test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test','952736897','test@gmail.com','台灣','名間鄉',NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'22','2016-12-27 01:24:28','2016-12-27 01:24:28',NULL,NULL,NULL,NULL),(26,1,'[{\"ID\":38,\"TYPE\":\"托指\",\"PACKAGE\":[{\"ID\":\"1\",\"NAME\":\"禮盒裝\",\"PRICE\":\"100\",\"PRICE\":22,\"SUB_TOTAL\":\"22\",\"FREE_SHIPPING\":\"free\",\"SHIPPING_COST\":\"50\",\"STYLE\": [{\"ID\":\"1\",\"COLOR\":\"black\",\"STYLE\":\"tee\",\"SIZE\":\"s\",\"TASTE\":\"apple\",\"QTY\":\"1\"}]}],\"PROMOTIONS_ID\":0}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,5,'[{\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"2\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"3\"}],\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\"},\"QTY\":\"3\",\"PRICE\":1,\"SUB_TOTAL\":\"3\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,NULL,'1',NULL,NULL,'WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3','2017-01-26 05:29:37','2017-01-26 05:29:37',NULL,NULL,NULL,NULL),(28,5,'{\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"5\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"0\"}],\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\"},\"QTY\":\"2\",\"PRICE\":1,\"SUB_TOTAL\":\"2\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'1',NULL,NULL,'WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2017-01-26 05:32:08','2017-01-26 05:32:08',NULL,NULL,NULL,NULL),(29,5,'{\"STYLE\":[],\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\"},\"QTY\":\"1\",\"PRICE\":1,\"SUB_TOTAL\":\"1\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'1',NULL,NULL,'WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','2017-01-26 05:38:52','2017-01-26 05:38:52',NULL,NULL,NULL,NULL),(30,5,'{\"STYLE\":[],\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"5\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"0\"}]},\"QTY\":\"2\",\"PRICE\":1,\"SUB_TOTAL\":\"2\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'1',NULL,NULL,'WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2017-01-26 05:40:10','2017-01-26 05:40:10',NULL,NULL,NULL,NULL),(31,5,'{\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"4\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"1\"}]},\"ID\":1,\"QTY\":\"2\",\"PRICE\":1,\"SUB_TOTAL\":\"2\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'1',NULL,NULL,'WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2017-01-26 05:43:48','2017-01-26 05:43:48',NULL,NULL,NULL,NULL),(32,5,'{\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"5\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"0\"}]},\"ID\":1,\"QTY\":\"1\",\"PRICE\":1,\"SUB_TOTAL\":\"1\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'1',NULL,NULL,'WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','2017-01-26 05:47:25','2017-01-26 05:47:25',NULL,NULL,NULL,NULL),(33,5,'{\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"5\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"0\"}]},\"ID\":1,\"QTY\":\"1\",\"PRICE\":1,\"SUB_TOTAL\":\"1\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'1',NULL,'creditcard','test',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','2017-01-26 05:54:20','2017-01-26 05:54:20',NULL,NULL,NULL,NULL),(34,5,'[{\"PACKAGE\":{\"ID\":3,\"PID\":1,\"NAME\":\"3\",\"PRICE\":1,\"DETAIL\":\"2\",\"QTY\":\"5\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 10:41:37\",\"UPDATED_AT\":\"2017-01-22 17:24:59\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"4\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"1\"}]},\"ID\":1,\"QTY\":\"1\",\"PRICE\":1,\"SUB_TOTAL\":\"1\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,NULL,'123',NULL,'creditcard','WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','2017-01-26 06:06:24','2017-01-26 06:06:24',NULL,NULL,NULL,NULL),(35,1,'{\"PACKAGE\":{\"ID\":5,\"PID\":1,\"NAME\":\"test\",\"PRICE\":100,\"DETAIL\":\"test\",\"QTY\":\"10\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 17:25:24\",\"UPDATED_AT\":\"2017-01-22 17:25:24\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"4\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"6\"}]},\"ID\":1,\"QTY\":\"1\",\"PRICE\":100,\"SUB_TOTAL\":\"100\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'123',NULL,'creditcard','test',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','2017-02-14 14:26:51','2017-02-14 14:26:51',NULL,NULL,NULL,NULL),(36,1,'{\"PACKAGE\":{\"ID\":5,\"PID\":1,\"NAME\":\"test\",\"PRICE\":100,\"DETAIL\":\"test\",\"QTY\":\"10\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 17:25:24\",\"UPDATED_AT\":\"2017-01-22 17:25:24\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"2\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"8\"}]},\"ID\":1,\"QTY\":\"1\",\"PRICE\":100,\"SUB_TOTAL\":\"100\",\"PROMOTIONS_ID\":0}','not-payment',NULL,NULL,'123',NULL,'creditcard','WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','2017-02-14 14:29:38','2017-02-14 14:29:38',NULL,NULL,NULL,NULL),(37,1,'[{\"PACKAGE\":{\"ID\":5,\"PID\":1,\"NAME\":\"test\",\"PRICE\":100,\"DETAIL\":\"test\",\"QTY\":\"10\",\"STATUS\":\"open\",\"CREATED_AT\":\"2017-01-22 17:25:24\",\"UPDATED_AT\":\"2017-01-22 17:25:24\",\"STYLE\":[{\"ID\":2,\"COLOR\":\"5\",\"STYLE\":\"5\",\"SIZE\":\"5\",\"TASTE\":\"5\",\"QTY\":\"2\"},{\"ID\":7,\"COLOR\":\"test\",\"STYLE\":\"test\",\"SIZE\":\"test\",\"TASTE\":\"test\",\"QTY\":\"8\"}]},\"ID\":1,\"QTY\":\"1\",\"PRICE\":100,\"SUB_TOTAL\":\"100\",\"PROMOTIONS_ID\":0}]','not-payment',NULL,NULL,'123',NULL,'creditcard','WU YUAN YU',NULL,NULL,NULL,NULL,NULL,'551',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'WU YUAN YU','952736897',NULL,NULL,NULL,NULL,'551','中正村董門巷87之5號',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','2017-02-14 14:31:36','2017-02-14 14:31:36',NULL,NULL,NULL,NULL);
541/*!40000 ALTER TABLE `ORDER` ENABLE KEYS */;
542UNLOCK TABLES;
543
544--
545-- Table structure for table `PASSWORD_RESETS`
546--
547
548DROP TABLE IF EXISTS `PASSWORD_RESETS`;
549/*!40101 SET @saved_cs_client     = @@character_set_client */;
550/*!40101 SET character_set_client = utf8 */;
551CREATE TABLE `PASSWORD_RESETS` (
552  `ID` int(11) NOT NULL AUTO_INCREMENT,
553  `EMAIL` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
554  `TOKEN` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
555  `CREATED_AT` timestamp NULL DEFAULT NULL,
556  `UPDATED_AT` timestamp NULL DEFAULT NULL,
557  PRIMARY KEY (`ID`)
558) ENGINE=InnoDB AUTO_INCREMENT=192 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
559/*!40101 SET character_set_client = @saved_cs_client */;
560
561--
562-- Dumping data for table `PASSWORD_RESETS`
563--
564
565LOCK TABLES `PASSWORD_RESETS` WRITE;
566/*!40000 ALTER TABLE `PASSWORD_RESETS` DISABLE KEYS */;
567INSERT INTO `PASSWORD_RESETS` VALUES (182,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-26 23:52:13','2016-07-25 09:13:44'),(183,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-26 23:52:13','2016-07-25 09:18:19'),(184,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:26:22','2016-07-25 09:23:51'),(185,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:26:26','2016-07-25 09:28:21'),(186,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:26:43','2016-07-25 09:28:22'),(187,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:26:50','2016-07-25 09:32:10'),(188,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:26:54','2016-07-25 09:33:40'),(189,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:26:57','2016-07-25 09:33:54'),(190,'sues.wu@hacktech.tw','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:27:08','2016-07-25 09:43:45'),(191,'test@gmail.com','tzbZLIJa0cnQq8bR8tcHtiorVpy17JrMax0JV2Hv','2016-01-27 09:27:30','2016-07-25 09:44:16');
568/*!40000 ALTER TABLE `PASSWORD_RESETS` ENABLE KEYS */;
569UNLOCK TABLES;
570
571--
572-- Table structure for table `PRODUCT`
573--
574
575DROP TABLE IF EXISTS `PRODUCT`;
576/*!40101 SET @saved_cs_client     = @@character_set_client */;
577/*!40101 SET character_set_client = utf8 */;
578CREATE TABLE `PRODUCT` (
579  `ID` int(11) NOT NULL AUTO_INCREMENT,
580  `SORT` int(11) NOT NULL COMMENT '排序',
581  `TYPE_ID` int(11) NOT NULL COMMENT '類型編號',
582  `PROMOTIONS_ID` int(11) DEFAULT '0' COMMENT '促銷編號',
583  `NAME` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '名稱\n只存繁體中文 提供後台快速搜尋',
584  `SERIAL_NUMBER` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品序號',
585  `PRICE` int(11) NOT NULL COMMENT '價錢(新台幣TWD為準)',
586  `PROMOTIONS_PRICE` int(11) DEFAULT NULL COMMENT '加購優惠價',
587  `POINT` int(11) DEFAULT NULL COMMENT '回饋紅利',
588  `QTY` int(11) DEFAULT '0' COMMENT '數量',
589  `TEXT_DETAIL` text COLLATE utf8_unicode_ci COMMENT '文字簡介',
590  `DETAIL` text COLLATE utf8_unicode_ci COMMENT '詳細內容',
591  `PLACE_ORIGIN` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '產地',
592  `SHELF_LIFE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '保存期限',
593  `PRESERVATION` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '保存方法',
594  `KIND` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品種類',
595  `PACKAGE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '包裝方案 \nJSON格式\n[{“package”:”禮盒”,”detail”:”包裝內含24顆”,”qty”:”24”}]',
596  `WEIGHT_UNIT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '重量單位\n公斤 公克 包 條 片',
597  `FREE_SHIPPING` varchar(45) COLLATE utf8_unicode_ci DEFAULT 'close' COMMENT '是否免運',
598  `IMG_ID` text COLLATE utf8_unicode_ci COMMENT '圖片清單\n[1,2,3]',
599  `STATUS` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '狀態',
600  `CREATED_AT` timestamp NULL DEFAULT NULL COMMENT '建置時間',
601  `UPDATED_AT` timestamp NULL DEFAULT NULL COMMENT '更新時間',
602  PRIMARY KEY (`ID`)
603) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
604/*!40101 SET character_set_client = @saved_cs_client */;
605
606--
607-- Dumping data for table `PRODUCT`
608--
609
610LOCK TABLES `PRODUCT` WRITE;
611/*!40000 ALTER TABLE `PRODUCT` DISABLE KEYS */;
612INSERT INTO `PRODUCT` VALUES (2,1,0,0,'aa','',100,0,0,0,'<p>透氣舒適簡約俐落的顯瘦版型</p><p>可拉至落肩小性感的一字型寬領</p><p>是春夏必備的百搭純色系T恤</p>','<img src=\"/img/frontend/da0108/shoes_show.jpg\" alt=\"\"/>','','','',NULL,NULL,NULL,'open','[272,274]','open','2016-01-29 08:36:35','2017-03-12 16:15:06'),(38,3,3,0,'ttttttttttttttttttttttttttttttttttttt','',22,0,0,0,NULL,'\n                                            \n                                            \n                                            <p>\n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            <span style=\"background-color: rgb(255, 255, 0);\">haha</span></p><p><span style=\"background-color: rgb(255, 255, 0);\"><br></span></p><p>透氣舒適簡約俐落的顯瘦版型</p><p>可拉至落肩小性感的一字型寬領</p><p><span style=\"background-color: rgb(255, 255, 0);\"></span>\n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          </p><p>是春夏必備的百搭純色系T恤透氣舒適簡約俐落的顯瘦版型</p><p>可拉至落肩小性感的一字型寬領</p><p>是春夏必備的百搭純色系T恤透氣舒適簡約俐落的顯瘦版型</p><p>可拉至落肩小性感的一字型寬領</p><p>是春夏必備的百搭純色系T恤透氣舒適簡約俐落的顯瘦版型</p><p>可拉至落肩小性感的一字型寬領</p><p>是春夏必備的百搭純色系T恤透氣舒適簡約俐落的顯瘦版型</p><p>可拉至落肩小性感的一字型寬領</p><p>是春夏必備的百搭純色系T恤</p>\n                                          \n                                          \n                                          ','','','',NULL,'八兩禮盒裝',NULL,'close','[272]','open','2016-03-02 05:23:09','2016-12-26 23:54:40'),(47,1,0,0,'WU YUAN YU','',1,0,0,0,NULL,'<div>透氣舒適簡約俐落的顯瘦版型</div><div>可拉至落肩小性感的一字型寬領</div><div>是春夏必備的百搭純色系T恤</div>\n                                            \n                                            \n                                          \n                                          \n                                          ','','','',NULL,NULL,NULL,'close','[274]','close','2016-03-02 18:01:53','2016-12-04 13:34:10'),(48,0,2,0,'bear tw','',100,0,0,0,NULL,'\n                                            \n                                            <div>透氣舒適簡約俐落的顯瘦版型</div><div>可拉至落肩小性感的一字型寬領</div><div>是春夏必備的百搭純色系T恤</div><div><img src=\"http://i.imgur.com/ONtbCaz.jpg\" style=\"width: 100%;\"></div><div><img src=\"http://i.imgur.com/dEK8oMU.jpg\" style=\"width: 100%;\"><br></div>\n                                            \n                                            \n                                            \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          ','','','',NULL,'四兩禮盒裝',NULL,'close','[296,298]','close','2016-05-10 10:10:10','2017-02-22 11:58:34'),(58,1,0,0,'11222','',66,0,0,0,NULL,NULL,'a','1','6',NULL,NULL,NULL,'open','[277]','sold-out','2016-09-27 21:37:37','2016-12-04 13:49:39'),(59,1,0,0,'11','',15,0,0,0,NULL,NULL,'','','',NULL,NULL,NULL,'open','[]','close','2016-12-25 20:40:06','2016-12-25 20:42:17'),(60,1,0,0,'test type','',150,99999,0,0,NULL,NULL,'','','',NULL,NULL,NULL,'close','[]','close','2017-02-08 07:51:16','2017-02-08 07:51:16'),(61,5,0,0,'TEST','',100,0,0,0,NULL,NULL,'','','',NULL,NULL,NULL,'close','[291,290]','open','2017-02-17 08:28:10','2017-02-17 16:57:56'),(62,5,0,0,'測試商品','',500,99999,0,0,NULL,NULL,'','','',NULL,NULL,NULL,'close','[292]','open','2017-02-18 06:34:15','2017-02-18 06:34:15'),(63,5,0,0,'測試商品jk','',500,0,0,0,NULL,NULL,'','','',NULL,NULL,NULL,'close','[293]','open','2017-02-18 06:39:39','2017-02-22 07:23:28'),(64,5,0,0,'測試商品j','',500,0,0,0,NULL,NULL,'','','',NULL,NULL,NULL,'close','[295,294]','open','2017-02-18 06:40:47','2017-02-20 02:32:11');
613/*!40000 ALTER TABLE `PRODUCT` ENABLE KEYS */;
614UNLOCK TABLES;
615
616--
617-- Table structure for table `PRODUCT_INFO`
618--
619
620DROP TABLE IF EXISTS `PRODUCT_INFO`;
621/*!40101 SET @saved_cs_client     = @@character_set_client */;
622/*!40101 SET character_set_client = utf8 */;
623CREATE TABLE `PRODUCT_INFO` (
624  `ID` int(11) NOT NULL AUTO_INCREMENT,
625  `PID` int(11) NOT NULL COMMENT '產品ID',
626  `LANGUAGE` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '多國語言\ntw台灣\nko韓國',
627  `NAME` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '名稱',
628  `DETAIL` text COLLATE utf8_unicode_ci COMMENT '詳細內容',
629  `PLACE_ORIGIN` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '產地',
630  `SHELF_LIFE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '保存期限',
631  `PRESERVATION` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '保存方法',
632  `CREATED_AT` timestamp NULL DEFAULT NULL,
633  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
634  PRIMARY KEY (`ID`)
635) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
636/*!40101 SET character_set_client = @saved_cs_client */;
637
638--
639-- Dumping data for table `PRODUCT_INFO`
640--
641
642LOCK TABLES `PRODUCT_INFO` WRITE;
643/*!40000 ALTER TABLE `PRODUCT_INFO` DISABLE KEYS */;
644INSERT INTO `PRODUCT_INFO` VALUES (11,58,'tw','11222','\n                                              \n                                              \n                                              \n                                              q\n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ','a','1','6','2016-09-27 21:37:37','2016-12-04 13:49:39'),(12,58,'cn','22','\n                                              \n                                              \n                                              \n                                              2w\n                                            \n                                            \n                                            \n                                            ','s','2','7','2016-09-27 21:37:37','2016-12-04 13:49:39'),(13,58,'en','33','\n                                              \n                                              \n                                              \n                                              3e\n                                            \n                                            \n                                            \n                                            ','d','3','8','2016-09-27 21:37:37','2016-12-04 13:49:39'),(14,58,'jp','44','\n                                              \n                                              \n                                              \n                                              4r\n                                            \n                                            \n                                            \n                                            ','f','4','9','2016-09-27 21:37:37','2016-12-04 13:49:39'),(15,58,'ko','55','\n                                              \n                                              \n                                              \n                                              t\n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ','g','5',NULL,'2016-09-27 21:37:37','2016-12-04 13:49:39'),(16,59,'tw','11','\n                                              \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-26 14:55:58','2016-12-25 20:42:06'),(17,59,'cn','22','\n                                              \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-26 14:55:58','2016-12-25 20:42:06'),(18,59,'en','33','\n                                              \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-26 14:55:58','2016-12-25 20:42:06'),(19,59,'jp','44','\n                                              \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-26 14:55:58','2016-12-25 20:42:06'),(20,59,'ko','55','\n                                              \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-26 14:55:58','2016-12-25 20:42:06'),(21,60,'tw','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:03','2016-10-26 14:56:03'),(22,60,'cn','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:03','2016-10-26 14:56:03'),(23,60,'en','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:03','2016-10-26 14:56:03'),(24,60,'jp','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:03','2016-10-26 14:56:03'),(25,60,'ko','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:03','2016-10-26 14:56:03'),(26,61,'tw','TEST','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:11','2017-02-17 08:28:42'),(27,61,'cn','TEST','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:11','2017-02-17 08:28:42'),(28,61,'en','TEST','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:11','2017-02-17 08:28:42'),(29,61,'jp','TEST','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:11','2017-02-17 08:28:42'),(30,61,'ko','TEST','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:56:11','2017-02-17 08:28:42'),(31,62,'tw','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:58:48','2016-10-26 14:58:48'),(32,62,'cn','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:58:48','2016-10-26 14:58:48'),(33,62,'en','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:58:48','2016-10-26 14:58:48'),(34,62,'jp','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:58:48','2016-10-26 14:58:48'),(35,62,'ko','WU YUAN YU','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:58:48','2016-10-26 14:58:48'),(36,63,'tw','測試商品jk','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 14:59:21','2017-02-22 07:23:28'),(37,63,'cn','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 14:59:21','2017-02-22 07:23:28'),(38,63,'en','測試商品','\n                                            ',NULL,NULL,NULL,'2016-10-26 14:59:21','2017-02-22 07:23:28'),(39,63,'jp','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 14:59:21','2017-02-22 07:23:28'),(40,63,'ko','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 14:59:21','2017-02-22 07:23:28'),(41,64,'tw','測試商品j','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 15:00:02','2017-02-18 06:41:24'),(42,64,'cn','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 15:00:02','2017-02-18 06:41:24'),(43,64,'en','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 15:00:02','2017-02-18 06:41:24'),(44,64,'jp','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 15:00:02','2017-02-18 06:41:24'),(45,64,'ko','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2016-10-26 15:00:02','2017-02-18 06:41:24'),(46,65,'tw','1','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:00:53','2016-10-26 15:00:53'),(47,65,'cn','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:00:53','2016-10-26 15:00:53'),(48,65,'en','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:00:53','2016-10-26 15:00:53'),(49,65,'jp','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:00:53','2016-10-26 15:00:53'),(50,65,'ko','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:00:53','2016-10-26 15:00:53'),(51,66,'tw','1','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:16','2016-10-26 15:33:16'),(52,66,'cn','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:16','2016-10-26 15:33:16'),(53,66,'en','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:16','2016-10-26 15:33:16'),(54,66,'jp','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:16','2016-10-26 15:33:16'),(55,66,'ko','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:16','2016-10-26 15:33:16'),(56,67,'tw','1','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:45','2016-10-26 15:33:45'),(57,67,'cn','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:45','2016-10-26 15:33:45'),(58,67,'en','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:45','2016-10-26 15:33:45'),(59,67,'jp','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:45','2016-10-26 15:33:45'),(60,67,'ko','','\n                                            ',NULL,NULL,NULL,'2016-10-26 15:33:45','2016-10-26 15:33:45'),(61,69,'tw','style','\n                                            ',NULL,NULL,NULL,'2016-10-28 08:25:30','2016-10-28 08:25:30'),(62,69,'cn','','\n                                            ',NULL,NULL,NULL,'2016-10-28 08:25:30','2016-10-28 08:25:30'),(63,69,'en','','\n                                            ',NULL,NULL,NULL,'2016-10-28 08:25:30','2016-10-28 08:25:30'),(64,69,'jp','','\n                                            ',NULL,NULL,NULL,'2016-10-28 08:25:30','2016-10-28 08:25:30'),(65,69,'ko','','\n                                            ',NULL,NULL,NULL,'2016-10-28 08:25:30','2016-10-28 08:25:30'),(76,72,'tw','style','\n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:36:48','2016-10-30 13:54:49'),(77,72,'cn','','\n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:36:48','2016-10-30 13:54:49'),(78,72,'en','','\n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:36:48','2016-10-30 13:54:49'),(79,72,'jp','','\n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:36:48','2016-10-30 13:54:49'),(80,72,'ko','','\n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:36:48','2016-10-30 13:54:49'),(81,73,'tw','style','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:37:35','2016-10-28 18:14:03'),(82,73,'cn','','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:37:35','2016-10-28 18:14:03'),(83,73,'en','','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:37:35','2016-10-28 18:14:03'),(84,73,'jp','','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:37:35','2016-10-28 18:14:03'),(85,73,'ko','','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-10-28 08:37:35','2016-10-28 18:14:03'),(86,76,'tw','type test','\n                                            ',NULL,NULL,NULL,'2016-11-04 05:42:44','2016-11-04 05:42:44'),(87,76,'cn','','\n                                            ',NULL,NULL,NULL,'2016-11-04 05:42:44','2016-11-04 05:42:44'),(88,76,'en','','\n                                            ',NULL,NULL,NULL,'2016-11-04 05:42:44','2016-11-04 05:42:44'),(89,76,'jp','','\n                                            ',NULL,NULL,NULL,'2016-11-04 05:42:44','2016-11-04 05:42:44'),(90,76,'ko','','\n                                            ',NULL,NULL,NULL,'2016-11-04 05:42:44','2016-11-04 05:42:44'),(91,94,'tw','test type1','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-11-04 06:36:42','2016-11-04 09:40:12'),(92,94,'cn','','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-11-04 06:36:42','2016-11-04 09:40:12'),(93,94,'en','','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-11-04 06:36:42','2016-11-04 09:40:12'),(94,94,'jp','','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-11-04 06:36:42','2016-11-04 09:40:12'),(95,94,'ko','','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-11-04 06:36:42','2016-11-04 09:40:12'),(96,38,'tw','ttttttttttttttttttttttttttttttttttttt','<p>123</p>',NULL,NULL,NULL,'2016-12-04 13:32:44','2017-02-08 07:49:33'),(97,38,'cn','cc','<p>4444</p>',NULL,NULL,NULL,'2016-12-04 13:32:44','2017-02-08 07:49:33'),(98,38,'en','ee','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:32:44','2016-12-26 23:54:40'),(99,38,'jp','jj','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:32:44','2016-12-26 23:54:40'),(100,38,'ko','kk','\n                                              \n                                              \n                                              \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:32:44','2016-12-26 23:54:40'),(101,47,'tw','WU YUAN YU','\n                                              \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:10','2016-12-04 13:34:10'),(102,47,'cn','WU YUAN YU','\n                                              \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:10','2016-12-04 13:34:10'),(103,47,'en','WU YUAN YU','\n                                              \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:10','2016-12-04 13:34:10'),(104,47,'jp','WU YUAN YU','\n                                              \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:10','2016-12-04 13:34:10'),(105,47,'ko','WU YUAN YU','\n                                              \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:10','2016-12-04 13:34:10'),(106,2,'tw','aa','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:52','2016-12-04 13:35:37'),(107,2,'cn','bb','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:52','2016-12-04 13:35:37'),(108,2,'en','cc','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:52','2016-12-04 13:35:37'),(109,2,'jp','dd','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:52','2016-12-04 13:35:37'),(110,2,'ko','ee','\n                                              \n                                              \n                                              \n                                              \n                                            \n                                            \n                                            \n                                            ',NULL,NULL,NULL,'2016-12-04 13:34:52','2016-12-04 13:35:37'),(111,59,'tw','11','\n                                            ',NULL,NULL,NULL,'2016-12-25 20:40:06','2016-12-25 20:40:06'),(112,59,'cn','22','\n                                            ',NULL,NULL,NULL,'2016-12-25 20:40:06','2016-12-25 20:40:06'),(113,59,'en','33','\n                                            ',NULL,NULL,NULL,'2016-12-25 20:40:06','2016-12-25 20:40:06'),(114,59,'jp','44','\n                                            ',NULL,NULL,NULL,'2016-12-25 20:40:06','2016-12-25 20:40:06'),(115,59,'ko','55','\n                                            ',NULL,NULL,NULL,'2016-12-25 20:40:06','2016-12-25 20:40:06'),(116,60,'tw','test type','<p>test</p>',NULL,NULL,NULL,'2017-02-08 07:51:16','2017-02-08 07:51:16'),(117,60,'cn','test type','<p>ttt</p>',NULL,NULL,NULL,'2017-02-08 07:51:16','2017-02-08 07:51:16'),(118,60,'en','test type',NULL,NULL,NULL,NULL,'2017-02-08 07:51:16','2017-02-08 07:51:16'),(119,60,'jp','test type1',NULL,NULL,NULL,NULL,'2017-02-08 07:51:16','2017-02-08 07:51:16'),(120,60,'ko','test type',NULL,NULL,NULL,NULL,'2017-02-08 07:51:16','2017-02-08 07:51:16'),(121,48,'tw','bear tw','<p>1</p>',NULL,NULL,NULL,'2017-02-14 09:02:14','2017-02-14 09:02:14'),(122,48,'cn','bear cn','<p>5</p>',NULL,NULL,NULL,'2017-02-14 09:02:14','2017-02-14 09:02:14'),(123,48,'en','bear en','<p>2</p>',NULL,NULL,NULL,'2017-02-14 09:02:14','2017-02-14 09:02:14'),(124,48,'jp','bear jp','<p>3</p>',NULL,NULL,NULL,'2017-02-14 09:02:14','2017-02-14 09:02:14'),(125,48,'ko','bear ko','<p>4</p>',NULL,NULL,NULL,'2017-02-14 09:02:14','2017-02-14 09:02:14'),(126,61,'tw','TEST',NULL,NULL,NULL,NULL,'2017-02-17 08:28:10','2017-02-17 08:28:10'),(127,61,'cn','TEST',NULL,NULL,NULL,NULL,'2017-02-17 08:28:10','2017-02-17 08:28:10'),(128,61,'en','TEST',NULL,NULL,NULL,NULL,'2017-02-17 08:28:10','2017-02-17 08:28:10'),(129,61,'jp','TEST',NULL,NULL,NULL,NULL,'2017-02-17 08:28:10','2017-02-17 08:28:10'),(130,61,'ko','TEST',NULL,NULL,NULL,NULL,'2017-02-17 08:28:10','2017-02-17 08:28:10'),(131,63,'tw','測試商品jk','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:39:39','2017-02-18 06:39:39'),(132,63,'cn','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:39:39','2017-02-18 06:39:39'),(133,63,'en','測試商品',NULL,NULL,NULL,NULL,'2017-02-18 06:39:39','2017-02-18 06:39:39'),(134,63,'jp','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:39:39','2017-02-18 06:39:39'),(135,63,'ko','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:39:39','2017-02-18 06:39:39'),(136,64,'tw','測試商品j','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:40:47','2017-02-18 06:40:47'),(137,64,'cn','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:40:47','2017-02-18 06:40:47'),(138,64,'en','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:40:47','2017-02-18 06:40:47'),(139,64,'jp','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:40:47','2017-02-18 06:40:47'),(140,64,'ko','測試商品','<p>測試商品</p>',NULL,NULL,NULL,'2017-02-18 06:40:47','2017-02-18 06:40:47');
645/*!40000 ALTER TABLE `PRODUCT_INFO` ENABLE KEYS */;
646UNLOCK TABLES;
647
648--
649-- Table structure for table `PRODUCT_STYLE`
650--
651
652DROP TABLE IF EXISTS `PRODUCT_STYLE`;
653/*!40101 SET @saved_cs_client     = @@character_set_client */;
654/*!40101 SET character_set_client = utf8 */;
655CREATE TABLE `PRODUCT_STYLE` (
656  `ID` int(11) NOT NULL AUTO_INCREMENT,
657  `PID` int(11) NOT NULL,
658  `COLOR` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '主要英文為主\n或存色碼',
659  `STYLE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
660  `SIZE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
661  `QTY` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
662  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
663  `CREATED_AT` timestamp NULL DEFAULT NULL,
664  `UPDATED_AT` timestamp NULL DEFAULT NULL,
665  PRIMARY KEY (`ID`)
666) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
667/*!40101 SET character_set_client = @saved_cs_client */;
668
669--
670-- Dumping data for table `PRODUCT_STYLE`
671--
672
673LOCK TABLES `PRODUCT_STYLE` WRITE;
674/*!40000 ALTER TABLE `PRODUCT_STYLE` DISABLE KEYS */;
675INSERT INTO `PRODUCT_STYLE` VALUES (1,38,'black','tee','s','49','open','2016-10-26 15:00:02','2016-12-27 01:24:28'),(2,64,'white','women','S','5','open','2016-10-26 15:00:02','2016-10-26 15:00:02'),(3,65,'black','men','M','10','open','2016-10-26 15:00:53','2016-10-26 15:00:53'),(4,65,'white','women','S','5','open','2016-10-26 15:00:53','2016-10-26 15:00:53'),(5,70,'black','men','M','10','delete','2016-10-26 17:30:15','2016-10-28 12:06:50'),(6,70,'white','women','S','5','delete','2016-10-26 17:30:15','2016-10-28 12:06:50'),(7,73,'black','men','s','10','delete','2016-10-28 08:37:35','2016-10-28 18:14:03'),(8,73,'black','women','m','0','open','2016-10-28 08:37:35','2016-10-28 18:11:02'),(9,73,'white','men','s','1','open','2016-10-28 18:14:03','2016-11-04 10:06:33'),(10,72,'yellow','men','L','20','open','2016-10-30 13:51:01','2016-10-30 13:54:49'),(11,2,'aa','aa','aa','1','open','2016-12-04 13:35:26','2016-12-04 13:35:26'),(12,58,'a','b','c','10','open','2016-12-04 13:37:35','2016-12-04 13:37:35'),(13,61,'1','2','3','4','open','2017-02-17 08:28:10','2017-02-17 08:28:10'),(14,63,'測試商品','測試商品','測試商品','10','open','2017-02-18 06:39:39','2017-02-18 06:39:39'),(15,64,'測試商品','測試商品','測試商品','10','open','2017-02-18 06:40:47','2017-02-18 06:40:47');
676/*!40000 ALTER TABLE `PRODUCT_STYLE` ENABLE KEYS */;
677UNLOCK TABLES;
678
679--
680-- Table structure for table `PRODUCT_TYPE`
681--
682
683DROP TABLE IF EXISTS `PRODUCT_TYPE`;
684/*!40101 SET @saved_cs_client     = @@character_set_client */;
685/*!40101 SET character_set_client = utf8 */;
686CREATE TABLE `PRODUCT_TYPE` (
687  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水號',
688  `PARENT_ID` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父層級 ID',
689  `LEVEL` int(11) NOT NULL COMMENT '層級等級',
690  `NAME` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '名稱\n只存繁體中文 提供後台快速搜尋',
691  `SORT` int(50) NOT NULL COMMENT '排序',
692  `STATUS` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '狀態',
693  `CREATED_AT` timestamp NULL DEFAULT NULL COMMENT '建立時間',
694  `UPDATED_AT` timestamp NULL DEFAULT NULL COMMENT '更新時間',
695  PRIMARY KEY (`ID`),
696  KEY `ID` (`ID`)
697) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='商品類型管理';
698/*!40101 SET character_set_client = @saved_cs_client */;
699
700--
701-- Dumping data for table `PRODUCT_TYPE`
702--
703
704LOCK TABLES `PRODUCT_TYPE` WRITE;
705/*!40000 ALTER TABLE `PRODUCT_TYPE` DISABLE KEYS */;
706INSERT INTO `PRODUCT_TYPE` VALUES (1,'3',2,'洗條',2,'open','2016-06-24 06:01:12','2016-12-04 13:37:55'),(2,'NULL',1,'test tw',33,'open','2016-06-24 06:01:55','2016-12-04 13:33:17'),(3,'NULL',1,'托指',2,'open','2016-06-29 09:09:50','2016-12-04 13:38:10'),(5,'NULL',1,'地板清潔',2,'close','2016-06-29 09:09:50','2016-08-31 10:10:30'),(6,'2',2,'tww',1,'open','2016-11-07 20:51:36','2016-12-04 13:35:58');
707/*!40000 ALTER TABLE `PRODUCT_TYPE` ENABLE KEYS */;
708UNLOCK TABLES;
709
710--
711-- Table structure for table `PRODUCT_TYPE_INFO`
712--
713
714DROP TABLE IF EXISTS `PRODUCT_TYPE_INFO`;
715/*!40101 SET @saved_cs_client     = @@character_set_client */;
716/*!40101 SET character_set_client = utf8 */;
717CREATE TABLE `PRODUCT_TYPE_INFO` (
718  `ID` int(11) NOT NULL AUTO_INCREMENT,
719  `TYPE_ID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
720  `LANGUAGE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
721  `NAME` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
722  `CREATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
723  `UPDATED_AT` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
724  PRIMARY KEY (`ID`)
725) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
726/*!40101 SET character_set_client = @saved_cs_client */;
727
728--
729-- Dumping data for table `PRODUCT_TYPE_INFO`
730--
731
732LOCK TABLES `PRODUCT_TYPE_INFO` WRITE;
733/*!40000 ALTER TABLE `PRODUCT_TYPE_INFO` DISABLE KEYS */;
734INSERT INTO `PRODUCT_TYPE_INFO` VALUES (1,'6','tw','tww','2016-11-08 04:51:36','2016-11-08 05:17:37'),(2,'6','cn','cn','2016-11-08 04:51:36','2016-11-08 04:51:36'),(3,'6','en','en','2016-11-08 04:51:36','2016-11-08 04:51:36'),(4,'6','jp','jp','2016-11-08 04:51:36','2016-11-08 04:51:36'),(5,'6','ko','ko','2016-11-08 04:51:36','2016-11-08 04:51:36'),(6,'2','tw','test tw','2016-12-04 21:33:17','2016-12-04 21:33:17'),(7,'2','cn','test cn','2016-12-04 21:33:17','2016-12-04 21:33:17'),(8,'2','en','test en','2016-12-04 21:33:17','2016-12-04 21:33:17'),(9,'2','jp','test jp','2016-12-04 21:33:17','2016-12-04 21:33:17'),(10,'2','ko','test ko','2016-12-04 21:33:17','2016-12-04 21:33:17'),(11,'1','tw','洗條','2016-12-04 21:37:55','2016-12-04 21:37:55'),(12,'1','cn','洗條','2016-12-04 21:37:55','2016-12-04 21:37:55'),(13,'1','en','洗條','2016-12-04 21:37:55','2016-12-04 21:37:55'),(14,'1','jp','洗條','2016-12-04 21:37:55','2016-12-04 21:37:55'),(15,'1','ko','洗條','2016-12-04 21:37:55','2016-12-04 21:37:55'),(16,'3','tw','托指','2016-12-04 21:38:10','2016-12-04 21:38:10'),(17,'3','cn','托指','2016-12-04 21:38:10','2016-12-04 21:38:10'),(18,'3','en','托指','2016-12-04 21:38:10','2016-12-04 21:38:10'),(19,'3','jp','托指','2016-12-04 21:38:10','2016-12-04 21:38:10'),(20,'3','ko','托指','2016-12-04 21:38:10','2016-12-04 21:38:10');
735/*!40000 ALTER TABLE `PRODUCT_TYPE_INFO` ENABLE KEYS */;
736UNLOCK TABLES;
737
738--
739-- Table structure for table `PRODUCT_TYPE_TAG`
740--
741
742DROP TABLE IF EXISTS `PRODUCT_TYPE_TAG`;
743/*!40101 SET @saved_cs_client     = @@character_set_client */;
744/*!40101 SET character_set_client = utf8 */;
745CREATE TABLE `PRODUCT_TYPE_TAG` (
746  `ID` int(11) NOT NULL AUTO_INCREMENT,
747  `TYPE_ID` int(11) NOT NULL,
748  `PRODUCT_ID` int(11) NOT NULL,
749  `CREATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
750  `UPDATED_AT` timestamp NULL DEFAULT NULL,
751  PRIMARY KEY (`ID`)
752) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
753/*!40101 SET character_set_client = @saved_cs_client */;
754
755--
756-- Dumping data for table `PRODUCT_TYPE_TAG`
757--
758
759LOCK TABLES `PRODUCT_TYPE_TAG` WRITE;
760/*!40000 ALTER TABLE `PRODUCT_TYPE_TAG` DISABLE KEYS */;
761INSERT INTO `PRODUCT_TYPE_TAG` VALUES (1,6,1,'2017-01-22 20:49:40','2017-01-22 12:49:40'),(4,2,2,'2017-01-22 20:49:40','2017-01-22 12:49:40'),(5,2,61,'2017-02-17 16:28:10','2017-02-17 08:28:10');
762/*!40000 ALTER TABLE `PRODUCT_TYPE_TAG` ENABLE KEYS */;
763UNLOCK TABLES;
764
765--
766-- Table structure for table `PROMOTIONS`
767--
768
769DROP TABLE IF EXISTS `PROMOTIONS`;
770/*!40101 SET @saved_cs_client     = @@character_set_client */;
771/*!40101 SET character_set_client = utf8 */;
772CREATE TABLE `PROMOTIONS` (
773  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水號\n',
774  `TYPE` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '優惠類別\ncash 現金卷\ndiscount 打折卷\npoint 購物點數<-暫不考慮',
775  `EVENT` varchar(45) CHARACTER SET utf8 NOT NULL COMMENT '觸發事件\nsign_up 會員註冊優惠-自動\nfull_limit 滿額消費優惠-自動\nrating 評論推廣優惠-自動\npublic 公開儲值優惠-手動\nprivate 隨機產生私人優惠-手動\n',
776  `TITLE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '標題',
777  `DISCOUNT` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '折數\n依照TYPE優惠類別不同 塞入不同值',
778  `FULL_LIMIT` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '滿額限',
779  `DEADLINE` timestamp NULL DEFAULT NULL COMMENT '期限',
780  `DISCOUNT_CODE` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '優惠卷序號\n',
781  `STATUS` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '狀態\n',
782  `UPDATED_AT` timestamp NULL DEFAULT NULL,
783  `CREATED_AT` timestamp NULL DEFAULT NULL,
784  `PROMOTIONScol` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
785  PRIMARY KEY (`ID`)
786) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
787/*!40101 SET character_set_client = @saved_cs_client */;
788
789--
790-- Dumping data for table `PROMOTIONS`
791--
792
793LOCK TABLES `PROMOTIONS` WRITE;
794/*!40000 ALTER TABLE `PROMOTIONS` DISABLE KEYS */;
795INSERT INTO `PROMOTIONS` VALUES (1,'cash','sign_up','母親節','100','',NULL,'asd123','delete','2016-11-17 09:38:15','2016-06-08 07:57:07',NULL),(3,'cash','rating','Image Gallery - Add, Select & Delete','10',NULL,NULL,'asd1231','open','2016-06-08 09:09:55','2016-06-08 08:03:52',NULL),(4,'cash','public','Image Gallery - Add, Select & Delete Thumbnai','50',NULL,NULL,'asd1232','open','2016-06-08 09:10:13','2016-06-08 09:10:13',NULL);
796/*!40000 ALTER TABLE `PROMOTIONS` ENABLE KEYS */;
797UNLOCK TABLES;
798
799--
800-- Table structure for table `PROMOTIONS_COUPON`
801--
802
803DROP TABLE IF EXISTS `PROMOTIONS_COUPON`;
804/*!40101 SET @saved_cs_client     = @@character_set_client */;
805/*!40101 SET character_set_client = utf8 */;
806CREATE TABLE `PROMOTIONS_COUPON` (
807  `ID` int(11) NOT NULL AUTO_INCREMENT,
808  `PROMOTIONS_ID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
809  `DISCOUNT_CODE` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
810  `MID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
811  `ORDER_ID` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
812  `STATUS` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'used 已使用\ndelete 刪除\nopen 未使用\nexpired 過期',
813  `UPDATED_AT` timestamp NULL DEFAULT NULL,
814  `CREATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
815  PRIMARY KEY (`ID`)
816) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
817/*!40101 SET character_set_client = @saved_cs_client */;
818
819--
820-- Dumping data for table `PROMOTIONS_COUPON`
821--
822
823LOCK TABLES `PROMOTIONS_COUPON` WRITE;
824/*!40000 ALTER TABLE `PROMOTIONS_COUPON` DISABLE KEYS */;
825INSERT INTO `PROMOTIONS_COUPON` VALUES (1,'1','asd123','1',NULL,'expired','2016-11-28 14:32:59','0000-00-00 00:00:00'),(2,'1','asd123','1',NULL,'used','2016-11-27 09:11:43','2016-11-25 13:43:19'),(3,'1','asd123','2',NULL,'expired','2016-11-28 14:32:59','2016-11-25 13:43:19'),(4,'4','asd1232','1',NULL,'used','2016-11-26 18:34:10','2016-11-26 18:34:10'),(5,'3','asd1231','1','1','open','2016-11-29 18:25:50','2016-11-29 18:25:50');
826/*!40000 ALTER TABLE `PROMOTIONS_COUPON` ENABLE KEYS */;
827UNLOCK TABLES;
828
829--
830-- Table structure for table `QA_ANSWER`
831--
832
833DROP TABLE IF EXISTS `QA_ANSWER`;
834/*!40101 SET @saved_cs_client     = @@character_set_client */;
835/*!40101 SET character_set_client = utf8 */;
836CREATE TABLE `QA_ANSWER` (
837  `ID` int(11) NOT NULL AUTO_INCREMENT,
838  `QID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
839  `MID` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
840  `NAME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
841  `DETAIL` text COLLATE utf8_unicode_ci,
842  `URL` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
843  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
844  `CREATED_AT` timestamp NULL DEFAULT NULL,
845  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
846  PRIMARY KEY (`ID`)
847) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
848/*!40101 SET character_set_client = @saved_cs_client */;
849
850--
851-- Dumping data for table `QA_ANSWER`
852--
853
854LOCK TABLES `QA_ANSWER` WRITE;
855/*!40000 ALTER TABLE `QA_ANSWER` DISABLE KEYS */;
856INSERT INTO `QA_ANSWER` VALUES (1,'1',NULL,'haha','已經為你解決問題','https://tw.yahoo.com/','open',NULL,'2016-12-01 01:25:04'),(2,'3',NULL,'hihi','感謝你的回報','https://tw.yahoo.com/','open',NULL,'0000-00-00 00:00:00'),(3,'2',NULL,'yo','我們會盡快處理','https://tw.yahoo.com/','open',NULL,'0000-00-00 00:00:00'),(8,'5',NULL,'nana','test',NULL,'open','2016-12-01 01:35:32','2016-12-01 01:35:32');
857/*!40000 ALTER TABLE `QA_ANSWER` ENABLE KEYS */;
858UNLOCK TABLES;
859
860--
861-- Table structure for table `QA_QUESTION`
862--
863
864DROP TABLE IF EXISTS `QA_QUESTION`;
865/*!40101 SET @saved_cs_client     = @@character_set_client */;
866/*!40101 SET character_set_client = utf8 */;
867CREATE TABLE `QA_QUESTION` (
868  `ID` int(11) NOT NULL AUTO_INCREMENT,
869  `MID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
870  `DETAIL` text COLLATE utf8_unicode_ci,
871  `URL` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
872  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
873  `CREATED_AT` timestamp NULL DEFAULT NULL,
874  `UPDATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
875  PRIMARY KEY (`ID`)
876) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
877/*!40101 SET character_set_client = @saved_cs_client */;
878
879--
880-- Dumping data for table `QA_QUESTION`
881--
882
883LOCK TABLES `QA_QUESTION` WRITE;
884/*!40000 ALTER TABLE `QA_QUESTION` DISABLE KEYS */;
885INSERT INTO `QA_QUESTION` VALUES (1,'1','你好我想詢問一下','https://www.google.com.tw','classic',NULL,'2016-12-01 00:42:38'),(2,'1','我想投訴！！','https://www.google.com.tw','classic',NULL,'0000-00-00 00:00:00'),(3,'1','我想投訴！！','https://www.google.com.tw','solved',NULL,'2016-12-01 00:54:03'),(4,'1','這是我的意見','https://www.google.com.tw','open',NULL,'0000-00-00 00:00:00'),(5,'1','測試',NULL,'solved','2016-12-01 00:00:30','2016-12-01 01:35:32'),(6,'1','1',NULL,'open','2016-12-01 00:04:01','2016-12-01 00:04:01');
886/*!40000 ALTER TABLE `QA_QUESTION` ENABLE KEYS */;
887UNLOCK TABLES;
888
889--
890-- Table structure for table `RATING`
891--
892
893DROP TABLE IF EXISTS `RATING`;
894/*!40101 SET @saved_cs_client     = @@character_set_client */;
895/*!40101 SET character_set_client = utf8 */;
896CREATE TABLE `RATING` (
897  `ID` int(11) NOT NULL AUTO_INCREMENT,
898  `ORDER_ID` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
899  `PID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
900  `MID` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
901  `SCORE` int(11) NOT NULL,
902  `DETAIL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
903  `STATUS` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
904  `UPDATED_AT` timestamp NULL DEFAULT NULL,
905  `CREATED_AT` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
906  PRIMARY KEY (`ID`)
907) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
908/*!40101 SET character_set_client = @saved_cs_client */;
909
910--
911-- Dumping data for table `RATING`
912--
913
914LOCK TABLES `RATING` WRITE;
915/*!40000 ALTER TABLE `RATING` DISABLE KEYS */;
916INSERT INTO `RATING` VALUES (1,'3','38','1',5,'測試測試測試測試測試測試測試測試測試測試測試測試測試測試測試測試','open','2016-11-30 08:18:03','0000-00-00 00:00:00'),(2,'2','38','1',3,NULL,'open',NULL,'0000-00-00 00:00:00'),(3,'3','38','1',5,'測試','open',NULL,'0000-00-00 00:00:00'),(4,'10','38','1',5,'測試','open',NULL,'0000-00-00 00:00:00'),(14,'1','47','1',5,'ddd','open','2016-11-29 18:25:50','2016-11-29 18:25:50'),(15,'1','48','1',5,'2','open','2016-11-29 18:26:12','2016-11-29 18:26:12');
917/*!40000 ALTER TABLE `RATING` ENABLE KEYS */;
918UNLOCK TABLES;
919
920--
921-- Table structure for table `SHOPPING_LIST`
922--
923
924DROP TABLE IF EXISTS `SHOPPING_LIST`;
925/*!40101 SET @saved_cs_client     = @@character_set_client */;
926/*!40101 SET character_set_client = utf8 */;
927CREATE TABLE `SHOPPING_LIST` (
928  `ID` int(11) NOT NULL AUTO_INCREMENT,
929  `MEMBER_ID` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
930  `PRODUCT_ID` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
931  `COLOR` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
932  `STYLE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
933  `SIZE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
934  `QTY` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
935  `SUB_TOTAL` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
936  `CREATED_AT` timestamp NULL DEFAULT NULL,
937  `UPDATED_AT` timestamp NULL DEFAULT NULL,
938  PRIMARY KEY (`ID`)
939) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
940/*!40101 SET character_set_client = @saved_cs_client */;
941
942--
943-- Dumping data for table `SHOPPING_LIST`
944--
945
946LOCK TABLES `SHOPPING_LIST` WRITE;
947/*!40000 ALTER TABLE `SHOPPING_LIST` DISABLE KEYS */;
948INSERT INTO `SHOPPING_LIST` VALUES (9,'314','4',NULL,NULL,NULL,'5','615','2016-06-29 11:29:44','2016-06-29 11:30:15'),(17,'1','2','aa','aa','aa','1','100','2017-03-12 16:16:13','2017-03-12 16:16:13'),(20,'1','64','white','women','S','2','1000','2017-03-12 17:52:40','2017-03-12 18:11:45'),(21,'1','64','測試商品','測試商品','測試商品','2','1000','2017-03-12 18:05:44','2017-03-12 18:05:44'),(22,'6','38','black','tee','s','1','22','2017-03-14 05:06:49','2017-03-14 05:06:49');
949/*!40000 ALTER TABLE `SHOPPING_LIST` ENABLE KEYS */;
950UNLOCK TABLES;
951
952--
953-- Table structure for table `SIGN_RECORD`
954--
955
956DROP TABLE IF EXISTS `SIGN_RECORD`;
957/*!40101 SET @saved_cs_client     = @@character_set_client */;
958/*!40101 SET character_set_client = utf8 */;
959CREATE TABLE `SIGN_RECORD` (
960  `ID` int(11) NOT NULL AUTO_INCREMENT,
961  `ACCOUNT` varchar(45) CHARACTER SET utf8 NOT NULL,
962  `EMAIL` varchar(45) COLLATE utf8_latvian_ci NOT NULL,
963  `CREATED_AT` timestamp NULL DEFAULT NULL,
964  `UPDATED_AT` timestamp NULL DEFAULT NULL,
965  PRIMARY KEY (`ID`)
966) ENGINE=InnoDB AUTO_INCREMENT=455 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
967/*!40101 SET character_set_client = @saved_cs_client */;
968
969--
970-- Dumping data for table `SIGN_RECORD`
971--
972
973LOCK TABLES `SIGN_RECORD` WRITE;
974/*!40000 ALTER TABLE `SIGN_RECORD` DISABLE KEYS */;
975INSERT INTO `SIGN_RECORD` VALUES (102,'eee','j2560248@trbvm.coms','2016-02-09 08:25:38',NULL),(107,'eee','j2560248@trbvm.coms','2016-02-11 08:25:38','2016-03-11 08:25:38'),(108,'eee','j2560248@trbvm.coms','2016-02-14 08:31:50','2016-03-11 08:31:50'),(109,'eee','j2560248@trbvm.coms','2016-02-16 08:31:56','2016-03-11 08:31:56'),(110,'eee','j2560248@trbvm.coms','2016-02-23 08:31:58','2016-03-11 08:31:58'),(111,'eee','j2560248@trbvm.coms','0000-00-00 00:00:00','2016-03-11 08:32:00'),(112,'eee','j2560248@trbvm.coms','2016-03-01 08:32:02','2016-03-11 08:32:02'),(113,'eee','j2560248@trbvm.coms','2016-03-03 08:32:05','2016-03-11 08:32:05'),(114,'eee','j2560248@trbvm.coms','2016-03-07 08:32:07','2016-03-11 08:32:07'),(115,'eee','j2560248@trbvm.coms','2016-03-11 08:32:09','2016-03-11 08:32:09'),(116,'eee','j2560248@trbvm.coms','2016-03-11 08:32:16','2016-03-11 08:32:16'),(117,'eee','j2560248@trbvm.coms','2016-03-13 02:49:12','2016-03-13 02:49:12'),(118,'eee','j2560248@trbvm.coms','2016-03-13 10:31:04','2016-03-13 10:31:04'),(119,'eee','j2560248@trbvm.coms','2016-03-14 03:18:08','2016-03-14 03:18:08'),(120,'created_at','123@123.sd','2016-03-14 08:11:07','2016-03-14 08:11:07'),(121,'eee','j2560248@trbvm.coms','2016-03-14 08:12:23','2016-03-14 08:12:23'),(122,'eee','j2560248@trbvm.coms','2016-03-14 10:00:10','2016-03-14 10:00:10'),(123,'eee','aa0930101298@gmail.com','2016-03-14 10:04:38','2016-03-14 10:04:38'),(124,'eee','aa0930101298@gmail.com','2016-03-15 03:40:39','2016-03-15 03:40:39'),(125,'eee','aa0930101298@gmail.com','2016-03-16 03:14:29','2016-03-16 03:14:29'),(126,'eee','aa0930101298@gmail.com','2016-03-16 03:14:35','2016-03-16 03:14:35'),(127,'eee','aa0930101298@gmail.com','2016-03-17 07:55:51','2016-03-17 07:55:51'),(128,'eee','aa0930101298@gmail.com','2016-03-18 05:25:23','2016-03-18 05:25:23'),(129,'eee','aa0930101298@gmail.com','2016-03-18 06:40:23','2016-03-18 06:40:23'),(130,'eee','aa0930101298@gmail.com','2016-03-18 06:52:53','2016-03-18 06:52:53'),(131,'eee','aa0930101298@gmail.com','2016-03-20 10:25:58','2016-03-20 10:25:58'),(132,'eee','aa0930101298@gmail.com','2016-03-21 02:41:10','2016-03-21 02:41:10'),(133,'eee','aa0930101298@gmail.com','2016-03-22 03:09:41','2016-03-22 03:09:41'),(134,'eee','aa0930101298@gmail.com','2016-03-22 04:32:42','2016-03-22 04:32:42'),(135,'eee','aa0930101298@gmail.com','2016-03-22 08:52:36','2016-03-22 08:52:36'),(136,'eee','aa0930101298@gmail.com','2016-03-22 09:04:22','2016-03-22 09:04:22'),(137,'eee','aa0930101298@gmail.com','2016-03-22 09:12:25','2016-03-22 09:12:25'),(138,'eee','aa0930101298@gmail.com','2016-03-23 03:49:06','2016-03-23 03:49:06'),(139,'eee','aa0930101298@gmail.com','2016-03-24 04:23:20','2016-03-24 04:23:20'),(140,'eee','aa0930101298@gmail.com','2016-03-25 08:28:24','2016-03-25 08:28:24'),(141,'eee','aa0930101298@gmail.com','2016-03-25 09:48:21','2016-03-25 09:48:21'),(142,'eee','aa0930101298@gmail.com','2016-03-26 06:06:31','2016-03-26 06:06:31'),(143,'eee','aa0930101298@gmail.com','2016-03-26 06:06:33','2016-03-26 06:06:33'),(144,'eee','aa0930101298@gmail.com','2016-03-27 06:06:49','2016-03-27 06:06:49'),(145,'eee','aa0930101298@gmail.com','2016-03-29 08:28:04','2016-03-29 08:28:04'),(146,'eee','aa0930101298@gmail.com','2016-03-31 11:12:15','2016-03-31 11:12:15'),(147,'eee','aa0930101298@gmail.com','2016-04-01 04:15:56','2016-04-01 04:15:56'),(148,'eee','aa0930101298@gmail.com','2016-04-01 09:18:32','2016-04-01 09:18:32'),(149,'eee','aa0930101298@gmail.com','2016-04-02 05:13:28','2016-04-02 05:13:28'),(150,'eee','aa0930101298@gmail.com','2016-04-03 04:50:12','2016-04-03 04:50:12'),(151,'eee','aa0930101298@gmail.com','2016-04-03 07:16:28','2016-04-03 07:16:28'),(152,'eee','aa0930101298@gmail.com','2016-04-03 07:34:48','2016-04-03 07:34:48'),(153,'eee','aa0930101298@gmail.com','2016-04-05 03:51:04','2016-04-05 03:51:04'),(154,'eee','aa0930101298@gmail.com','2016-04-05 05:37:00','2016-04-05 05:37:00'),(155,'eee','aa0930101298@gmail.com','2016-04-06 03:53:05','2016-04-06 03:53:05'),(156,'eee','aa0930101298@gmail.com','2016-04-06 05:33:18','2016-04-06 05:33:18'),(157,'eee','aa0930101298@gmail.com','2016-04-06 06:23:30','2016-04-06 06:23:30'),(158,'eee','aa0930101298@gmail.com','2016-04-06 06:25:46','2016-04-06 06:25:46'),(159,'eee','aa0930101298@gmail.com','2016-04-06 06:47:38','2016-04-06 06:47:38'),(160,'eee','aa0930101298@gmail.com','2016-04-06 06:52:50','2016-04-06 06:52:50'),(161,'eee','aa0930101298@gmail.com','2016-04-06 09:03:19','2016-04-06 09:03:19'),(162,'eee','aa0930101298@gmail.com','2016-04-06 09:04:15','2016-04-06 09:04:15'),(163,'eee','aa0930101298@gmail.com','2016-04-06 09:06:10','2016-04-06 09:06:10'),(164,'eee','aa0930101298@gmail.com','2016-04-07 04:53:47','2016-04-07 04:53:47'),(165,'eee','aa0930101298@gmail.com','2016-04-08 03:52:10','2016-04-08 03:52:10'),(166,'eee','aa0930101298@gmail.com','2016-04-08 03:52:26','2016-04-08 03:52:26'),(167,'eee','aa0930101298@gmail.com','2016-04-08 03:52:34','2016-04-08 03:52:34'),(168,'eee','aa0930101298@gmail.com','2016-04-08 03:52:38','2016-04-08 03:52:38'),(169,'eee','aa0930101298@gmail.com','2016-04-08 08:45:09','2016-04-08 08:45:09'),(170,'eee','aa0930101298@gmail.com','2016-04-08 10:14:48','2016-04-08 10:14:48'),(171,'eee','aa0930101298@gmail.com','2016-04-08 10:14:50','2016-04-08 10:14:50'),(172,'eee','aa0930101298@gmail.com','2016-04-08 10:14:51','2016-04-08 10:14:51'),(173,'eee','aa0930101298@gmail.com','2016-04-08 10:14:57','2016-04-08 10:14:57'),(174,'eee','aa0930101298@gmail.com','2016-04-09 04:03:21','2016-04-09 04:03:21'),(175,'eee','aa0930101298@gmail.com','2016-04-09 08:34:36','2016-04-09 08:34:36'),(176,'eee','aa0930101298@gmail.com','2016-04-09 12:21:29','2016-04-09 12:21:29'),(177,'eee','aa0930101298@gmail.com','2016-04-10 07:36:26','2016-04-10 07:36:26'),(178,'eee','aa0930101298@gmail.com','2016-04-10 07:55:48','2016-04-10 07:55:48'),(179,'eee','aa0930101298@gmail.com','2016-04-11 03:45:36','2016-04-11 03:45:36'),(180,'eee','aa0930101298@gmail.com','2016-04-11 08:21:04','2016-04-11 08:21:04'),(181,'eee','aa0930101298@gmail.com','2016-04-11 09:24:30','2016-04-11 09:24:30'),(182,'eee','aa0930101298@gmail.com','2016-04-12 03:51:04','2016-04-12 03:51:04'),(183,'eee','aa0930101298@gmail.com','2016-04-12 09:20:53','2016-04-12 09:20:53'),(184,'eee','aa0930101298@gmail.com','2016-04-13 08:24:03','2016-04-13 08:24:03'),(185,'eee','aa0930101298@gmail.com','2016-04-13 10:27:13','2016-04-13 10:27:13'),(186,'eee','aa0930101298@gmail.com','2016-04-14 02:09:41','2016-04-14 02:09:41'),(187,'eee','aa0930101298@gmail.com','2016-04-14 08:24:02','2016-04-14 08:24:02'),(188,'eee','aa0930101298@gmail.com','2016-04-15 04:17:05','2016-04-15 04:17:05'),(189,'eee','aa0930101298@gmail.com','2016-04-15 04:17:47','2016-04-15 04:17:47'),(190,'eee','aa0930101298@gmail.com','2016-04-16 04:32:12','2016-04-16 04:32:12'),(191,'eee','aa0930101298@gmail.com','2016-04-16 09:10:18','2016-04-16 09:10:18'),(192,'eee','aa0930101298@gmail.com','2016-04-16 09:16:10','2016-04-16 09:16:10'),(193,'eee','aa0930101298@gmail.com','2016-04-16 11:45:30','2016-04-16 11:45:30'),(194,'eee','aa0930101298@gmail.com','2016-04-16 12:27:48','2016-04-16 12:27:48'),(195,'eee','aa0930101298@gmail.com','2016-04-16 12:46:13','2016-04-16 12:46:13'),(196,'eee','aa0930101298@gmail.com','2016-04-17 09:26:14','2016-04-17 09:26:14'),(197,'eee','aa0930101298@gmail.com','2016-04-18 10:33:15','2016-04-18 10:33:15'),(198,'eee','aa0930101298@gmail.com','2016-04-19 09:49:22','2016-04-19 09:49:22'),(199,'eee','aa0930101298@gmail.com','2016-04-19 09:53:36','2016-04-19 09:53:36'),(200,'eee','aa0930101298@gmail.com','2016-04-20 03:35:48','2016-04-20 03:35:48'),(201,'eee','aa0930101298@gmail.com','2016-04-20 07:07:47','2016-04-20 07:07:47'),(202,'eee','aa0930101298@gmail.com','2016-04-20 08:58:08','2016-04-20 08:58:08'),(203,'eee','aa0930101298@gmail.com','2016-04-21 04:36:47','2016-04-21 04:36:47'),(204,'eee','aa0930101298@gmail.com','2016-04-21 09:13:57','2016-04-21 09:13:57'),(205,'eee','aa0930101298@gmail.com','2016-04-22 04:21:15','2016-04-22 04:21:15'),(206,'eee','aa0930101298@gmail.com','2016-04-23 05:30:20','2016-04-23 05:30:20'),(207,'eee','aa0930101298@gmail.com','2016-04-24 04:38:17','2016-04-24 04:38:17'),(208,'eee','aa0930101298@gmail.com','2016-04-24 10:38:31','2016-04-24 10:38:31'),(209,'eee','aa0930101298@gmail.com','2016-04-25 04:41:19','2016-04-25 04:41:19'),(210,'eee','aa0930101298@gmail.com','2016-04-25 09:14:42','2016-04-25 09:14:42'),(211,'eee','aa0930101298@gmail.com','2016-04-25 09:17:55','2016-04-25 09:17:55'),(212,'eee','aa0930101298@gmail.com','2016-04-25 09:27:55','2016-04-25 09:27:55'),(213,'eee','aa0930101298@gmail.com','2016-04-25 09:58:38','2016-04-25 09:58:38'),(214,'eee','aa0930101298@gmail.com','2016-04-26 04:00:33','2016-04-26 04:00:33'),(215,'eee','aa0930101298@gmail.com','2016-04-27 04:10:18','2016-04-27 04:10:18'),(216,'eee','aa0930101298@gmail.com','2016-04-27 08:32:02','2016-04-27 08:32:02'),(217,'eee','aa0930101298@gmail.com','2016-04-27 10:14:09','2016-04-27 10:14:09'),(218,'eee','aa0930101298@gmail.com','2016-04-28 12:17:04','2016-04-28 12:17:04'),(219,'eee','aa0930101298@gmail.com','2016-04-28 15:56:20','2016-04-28 15:56:20'),(220,'eee','aa0930101298@gmail.com','2016-04-30 10:26:02','2016-04-30 10:26:02'),(221,'eee','aa0930101298@gmail.com','2016-05-03 06:43:06','2016-05-03 06:43:06'),(222,'eee','aa0930101298@gmail.com','2016-05-06 08:20:30','2016-05-06 08:20:30'),(223,'eee','aa0930101298@gmail.com','2016-05-10 08:21:30','2016-05-10 08:21:30'),(224,'eee','aa0930101298@gmail.com','2016-05-11 04:49:13','2016-05-11 04:49:13'),(225,'eee','aa0930101298@gmail.com','2016-05-13 07:00:53','2016-05-13 07:00:53'),(226,'eee','aa0930101298@gmail.com','2016-05-16 03:44:43','2016-05-16 03:44:43'),(227,'eee','aa0930101298@gmail.com','2016-05-17 05:57:09','2016-05-17 05:57:09'),(228,'eee','aa0930101298@gmail.com','2016-05-18 05:48:40','2016-05-18 05:48:40'),(229,'eee','aa0930101298@gmail.com','2016-05-19 11:12:23','2016-05-19 11:12:23'),(230,'eee','aa0930101298@gmail.com','2016-05-20 04:29:32','2016-05-20 04:29:32'),(231,'eee','aa0930101298@gmail.com','2016-05-20 06:37:07','2016-05-20 06:37:07'),(232,'eee','aa0930101298@gmail.com','2016-05-20 06:37:09','2016-05-20 06:37:09'),(233,'eee','aa0930101298@gmail.com','2016-05-20 08:57:54','2016-05-20 08:57:54'),(234,'eee','aa0930101298@gmail.com','2016-05-20 08:58:26','2016-05-20 08:58:26'),(235,'eee','aa0930101298@gmail.com','2016-05-25 10:14:53','2016-05-25 10:14:53'),(236,'eee','aa0930101298@gmail.com','2016-05-26 06:16:26','2016-05-26 06:16:26'),(237,'eee','aa0930101298@gmail.com','2016-05-27 06:57:47','2016-05-27 06:57:47'),(238,'eee','aa0930101298@gmail.com','2016-05-27 09:40:59','2016-05-27 09:40:59'),(239,'eee','aa0930101298@gmail.com','2016-05-27 13:56:33','2016-05-27 13:56:33'),(240,'eee','aa0930101298@gmail.com','2016-05-29 05:36:00','2016-05-29 05:36:00'),(241,'eee','aa0930101298@gmail.com','2016-05-30 08:47:08','2016-05-30 08:47:08'),(242,'eee','aa0930101298@gmail.com','2016-05-31 10:31:13','2016-05-31 10:31:13'),(243,'eee','aa0930101298@gmail.com','2016-05-31 13:30:02','2016-05-31 13:30:02'),(244,'eee','aa0930101298@gmail.com','2016-06-01 04:49:48','2016-06-01 04:49:48'),(245,'eee','aa0930101298@gmail.com','2016-06-01 05:07:51','2016-06-01 05:07:51'),(246,'eee','aa0930101298@gmail.com','2016-06-01 05:32:13','2016-06-01 05:32:13'),(247,'eee','aa0930101298@gmail.com','2016-06-01 05:59:53','2016-06-01 05:59:53'),(248,'eee','aa0930101298@gmail.com','2016-06-02 05:29:45','2016-06-02 05:29:45'),(249,'eee','aa0930101298@gmail.com','2016-06-03 05:45:43','2016-06-03 05:45:43'),(250,'eee','aa0930101298@gmail.com','2016-06-04 08:10:29','2016-06-04 08:10:29'),(251,'eee','aa0930101298@gmail.com','2016-06-06 06:43:25','2016-06-06 06:43:25'),(252,'eee','aa0930101298@gmail.com','2016-06-06 09:33:48','2016-06-06 09:33:48'),(253,'eee','aa0930101298@gmail.com','2016-06-07 05:26:47','2016-06-07 05:26:47'),(254,'eee','aa0930101298@gmail.com','2016-06-07 06:54:30','2016-06-07 06:54:30'),(255,'eee','aa0930101298@gmail.com','2016-06-07 09:56:13','2016-06-07 09:56:13'),(256,'eee','aa0930101298@gmail.com','2016-06-08 04:11:13','2016-06-08 04:11:13'),(257,'eee','aa0930101298@gmail.com','2016-06-08 04:38:30','2016-06-08 04:38:30'),(258,'eee','aa0930101298@gmail.com','2016-06-08 06:09:12','2016-06-08 06:09:12'),(259,'eee','aa0930101298@gmail.com','2016-06-08 07:16:03','2016-06-08 07:16:03'),(260,'eee','aa0930101298@gmail.com','2016-06-14 07:53:45','2016-06-14 07:53:45'),(261,'eee','aa0930101298@gmail.com','2016-06-14 08:40:51','2016-06-14 08:40:51'),(262,'eee','aa0930101298@gmail.com','2016-06-14 08:56:30','2016-06-14 08:56:30'),(263,'eee','aa0930101298@gmail.com','2016-06-14 09:55:19','2016-06-14 09:55:19'),(264,'eee','aa0930101298@gmail.com','2016-06-16 07:46:51','2016-06-16 07:46:51'),(265,'eee','aa0930101298@gmail.com','2016-06-16 07:47:07','2016-06-16 07:47:07'),(266,'eee','aa0930101298@gmail.com','2016-06-16 07:47:54','2016-06-16 07:47:54'),(267,'eee','aa0930101298@gmail.com','2016-06-17 05:00:30','2016-06-17 05:00:30'),(268,'eee','aa0930101298@gmail.com','2016-06-17 10:06:08','2016-06-17 10:06:08'),(269,'eee','aa0930101298@gmail.com','2016-06-17 10:07:20','2016-06-17 10:07:20'),(270,'eee','aa0930101298@gmail.com','2016-06-18 09:28:01','2016-06-18 09:28:01'),(271,'eee','aa0930101298@gmail.com','2016-06-18 10:15:02','2016-06-18 10:15:02'),(272,'eee','aa0930101298@gmail.com','2016-06-20 04:07:07','2016-06-20 04:07:07'),(273,'eee','aa0930101298@gmail.com','2016-06-20 04:11:05','2016-06-20 04:11:05'),(274,'eee','aa0930101298@gmail.com','2016-06-20 04:12:23','2016-06-20 04:12:23'),(275,'eee','aa0930101298@gmail.com','2016-06-20 04:12:50','2016-06-20 04:12:50'),(276,'eee','aa0930101298@gmail.com','2016-06-20 04:14:10','2016-06-20 04:14:10'),(277,'eee','aa0930101298@gmail.com','2016-06-20 04:38:43','2016-06-20 04:38:43'),(278,'eee','aa0930101298@gmail.com','2016-06-20 04:40:15','2016-06-20 04:40:15'),(279,'eee','aa0930101298@gmail.com','2016-06-20 05:28:04','2016-06-20 05:28:04'),(280,'eee','aa0930101298@gmail.com','2016-06-20 05:31:19','2016-06-20 05:31:19'),(281,'eee','aa0930101298@gmail.com','2016-06-20 08:07:57','2016-06-20 08:07:57'),(282,'eee','aa0930101298@gmail.com','2016-06-20 09:08:42','2016-06-20 09:08:42'),(283,'eee','aa0930101298@gmail.com','2016-06-21 03:38:27','2016-06-21 03:38:27'),(284,'eee','aa0930101298@gmail.com','2016-06-21 03:59:51','2016-06-21 03:59:51'),(285,'eee','aa0930101298@gmail.com','2016-06-21 08:58:57','2016-06-21 08:58:57'),(286,'eee','aa0930101298@gmail.com','2016-06-22 04:15:05','2016-06-22 04:15:05'),(287,'eee','aa0930101298@gmail.com','2016-06-23 05:39:37','2016-06-23 05:39:37'),(288,'eee','aa0930101298@gmail.com','2016-06-23 08:27:22','2016-06-23 08:27:22'),(289,'eee','aa0930101298@gmail.com','2016-06-23 09:30:33','2016-06-23 09:30:33'),(290,'eee','aa0930101298@gmail.com','2016-06-24 05:41:36','2016-06-24 05:41:36'),(291,'eee','aa0930101298@gmail.com','2016-06-24 13:04:02','2016-06-24 13:04:02'),(292,'eee','aa0930101298@gmail.com','2016-06-25 02:22:48','2016-06-25 02:22:48'),(293,'eee','aa0930101298@gmail.com','2016-06-29 08:37:31','2016-06-29 08:37:31'),(294,'eee','aa0930101298@gmail.com','2016-07-01 03:21:04','2016-07-01 03:21:04'),(295,'eee','aa0930101298@gmail.com','2016-07-01 14:35:47','2016-07-01 14:35:47'),(296,'eee','aa0930101298@gmail.com','2016-07-02 07:19:50','2016-07-02 07:19:50'),(297,'eee','aa0930101298@gmail.com','2016-07-02 07:52:05','2016-07-02 07:52:05'),(298,'eee','aa0930101298@gmail.com','2016-07-03 08:27:17','2016-07-03 08:27:17'),(299,'eee','aa0930101298@gmail.com','2016-07-04 04:18:04','2016-07-04 04:18:04'),(300,'created_at12','123@123.sde','2016-07-04 04:18:35','2016-07-04 04:18:35'),(301,'eee','aa0930101298@gmail.com','2016-07-04 09:05:21','2016-07-04 09:05:21'),(302,'eee','aa0930101298@gmail.com','2016-07-05 08:51:52','2016-07-05 08:51:52'),(303,'eee','aa0930101298@gmail.com','2016-07-06 15:03:09','2016-07-06 15:03:09'),(304,'eee','aa0930101298@gmail.com','2016-07-11 10:09:05','2016-07-11 10:09:05'),(305,'test','gn02158263@gmail.com','2016-07-12 09:24:15','2016-07-12 09:24:15'),(306,'test','gn02158263@gmail.com','2016-07-16 08:09:22','2016-07-16 08:09:22'),(307,'eee','aa0930101298@gmail.com','2016-07-18 07:35:37','2016-07-18 07:35:37'),(308,'eee','aa0930101298@gmail.com','2016-07-19 20:40:18','2016-07-19 20:40:18'),(309,'eee','aa0930101298@gmail.com','2016-07-19 20:40:23','2016-07-19 20:40:23'),(310,'eee','aa0930101298@gmail.com','2016-07-20 12:19:52','2016-07-20 12:19:52'),(311,'eee','aa0930101298@gmail.com','2016-07-21 11:39:59','2016-07-21 11:39:59'),(312,'eee','aa0930101298@gmail.com','2016-07-22 11:35:39','2016-07-22 11:35:39'),(313,'eee','aa0930101298@gmail.com','2016-07-22 16:18:01','2016-07-22 16:18:01'),(314,'eee','aa0930101298@gmail.com','2016-07-22 21:58:24','2016-07-22 21:58:24'),(315,'eee','aa0930101298@gmail.com','2016-07-24 17:06:13','2016-07-24 17:06:13'),(316,'eee','aa0930101298@gmail.com','2016-07-24 22:16:12','2016-07-24 22:16:12'),(317,'eee','aa0930101298@gmail.com','2016-07-25 03:35:06','2016-07-25 03:35:06'),(318,'eee','aa0930101298@gmail.com','2016-07-25 08:51:39','2016-07-25 08:51:39'),(319,'eee','aa0930101298@gmail.com','2016-07-26 10:07:16','2016-07-26 10:07:16'),(320,'eee','aa0930101298@gmail.com','2016-07-26 13:59:56','2016-07-26 13:59:56'),(321,'eee','aa0930101298@gmail.com','2016-07-26 22:29:01','2016-07-26 22:29:01'),(322,'eee','aa0930101298@gmail.com','2016-07-27 11:19:36','2016-07-27 11:19:36'),(323,'eee','aa0930101298@gmail.com','2016-07-29 02:37:34','2016-07-29 02:37:34'),(324,'eee','aa0930101298@gmail.com','2016-07-30 05:47:49','2016-07-30 05:47:49'),(325,'eee','aa0930101298@gmail.com','2016-08-01 11:08:09','2016-08-01 11:08:09'),(326,'eee','aa0930101298@gmail.com','2016-08-01 11:09:29','2016-08-01 11:09:29'),(327,'eee','aa0930101298@gmail.com','2016-08-12 09:21:05','2016-08-12 09:21:05'),(328,'eee','aa0930101298@gmail.com','2016-08-16 22:42:31','2016-08-16 22:42:31'),(329,'eee','aa0930101298@gmail.com','2016-08-23 13:09:31','2016-08-23 13:09:31'),(330,'eee','aa0930101298@gmail.com','2016-08-23 13:57:54','2016-08-23 13:57:54'),(331,'eee','aa0930101298@gmail.com','2016-08-23 13:59:46','2016-08-23 13:59:46'),(332,'eee','aa0930101298@gmail.com','2016-08-23 14:01:27','2016-08-23 14:01:27'),(333,'eee','aa0930101298@gmail.com','2016-08-31 06:40:57','2016-08-31 06:40:57'),(334,'eee','aa0930101298@gmail.com','2016-08-31 06:41:49','2016-08-31 06:41:49'),(335,'eee','aa0930101298@gmail.com','2016-08-31 10:00:32','2016-08-31 10:00:32'),(336,'eee','aa0930101298@gmail.com','2016-09-11 10:04:34','2016-09-11 10:04:34'),(337,'eee','aa0930101298@gmail.com','2016-09-14 14:00:20','2016-09-14 14:00:20'),(338,'eee','aa0930101298@gmail.com','2016-09-16 00:07:28','2016-09-16 00:07:28'),(339,'eee','aa0930101298@gmail.com','2016-09-18 03:39:39','2016-09-18 03:39:39'),(340,'eee','aa0930101298@gmail.com','2016-09-18 15:31:27','2016-09-18 15:31:27'),(341,'eee','aa0930101298@gmail.com','2016-09-22 03:51:45','2016-09-22 03:51:45'),(342,'eee','aa0930101298@gmail.com','2016-09-25 08:49:38','2016-09-25 08:49:38'),(343,'eee','aa0930101298@gmail.com','2016-09-27 02:37:33','2016-09-27 02:37:33'),(344,'eee','aa0930101298@gmail.com','2016-09-27 21:13:19','2016-09-27 21:13:19'),(345,'eee','aa0930101298@gmail.com','2016-09-29 03:42:57','2016-09-29 03:42:57'),(346,'eee','aa0930101298@gmail.com','2016-09-30 06:05:11','2016-09-30 06:05:11'),(347,'eee','aa0930101298@gmail.com','2016-10-01 03:33:50','2016-10-01 03:33:50'),(348,'eee','aa0930101298@gmail.com','2016-10-01 13:07:00','2016-10-01 13:07:00'),(349,'eee','aa0930101298@gmail.com','2016-10-01 17:53:27','2016-10-01 17:53:27'),(350,'eee','aa0930101298@gmail.com','2016-10-02 05:34:12','2016-10-02 05:34:12'),(351,'eee','aa0930101298@gmail.com','2016-10-02 07:23:12','2016-10-02 07:23:12'),(352,'eee','aa0930101298@gmail.com','2016-10-02 12:20:08','2016-10-02 12:20:08'),(353,'eee','aa0930101298@gmail.com','2016-10-03 04:11:28','2016-10-03 04:11:28'),(354,'eee','aa0930101298@gmail.com','2016-10-03 13:50:23','2016-10-03 13:50:23'),(355,'eee','aa0930101298@gmail.com','2016-10-04 08:23:32','2016-10-04 08:23:32'),(356,'eee','aa0930101298@gmail.com','2016-10-11 09:18:23','2016-10-11 09:18:23'),(357,'eee','aa0930101298@gmail.com','2016-10-11 09:42:59','2016-10-11 09:42:59'),(358,'eee','aa0930101298@gmail.com','2016-10-12 02:38:28','2016-10-12 02:38:28'),(359,'eee','aa0930101298@gmail.com','2016-10-12 03:03:58','2016-10-12 03:03:58'),(360,'eee','aa0930101298@gmail.com','2016-10-12 08:20:07','2016-10-12 08:20:07'),(361,'eee','aa0930101298@gmail.com','2016-10-12 13:53:06','2016-10-12 13:53:06'),(362,'eee','aa0930101298@gmail.com','2016-10-17 11:13:01','2016-10-17 11:13:01'),(363,'eee','aa0930101298@gmail.com','2016-10-17 14:36:33','2016-10-17 14:36:33'),(364,'eee','aa0930101298@gmail.com','2016-10-18 02:57:55','2016-10-18 02:57:55'),(365,'eee','aa0930101298@gmail.com','2016-10-24 16:56:05','2016-10-24 16:56:05'),(366,'eee','aa0930101298@gmail.com','2016-10-26 10:00:29','2016-10-26 10:00:29'),(367,'eee','aa0930101298@gmail.com','2016-10-26 14:54:55','2016-10-26 14:54:55'),(368,'eee','aa0930101298@gmail.com','2016-10-27 15:52:46','2016-10-27 15:52:46'),(369,'eee','aa0930101298@gmail.com','2016-10-28 06:39:15','2016-10-28 06:39:15'),(370,'eee','aa0930101298@gmail.com','2016-10-28 11:54:36','2016-10-28 11:54:36'),(371,'eee','aa0930101298@gmail.com','2016-10-29 11:19:50','2016-10-29 11:19:50'),(372,'eee','aa0930101298@gmail.com','2016-10-29 19:00:29','2016-10-29 19:00:29'),(373,'eee','aa0930101298@gmail.com','2016-10-30 09:15:03','2016-10-30 09:15:03'),(374,'eee','aa0930101298@gmail.com','2016-10-30 20:06:01','2016-10-30 20:06:01'),(375,'eee','aa0930101298@gmail.com','2016-10-31 10:12:15','2016-10-31 10:12:15'),(376,'eee','aa0930101298@gmail.com','2016-10-31 16:38:14','2016-10-31 16:38:14'),(377,'eee','aa0930101298@gmail.com','2016-11-01 08:40:50','2016-11-01 08:40:50'),(378,'eee','aa0930101298@gmail.com','2016-11-01 18:35:49','2016-11-01 18:35:49'),(379,'eee','aa0930101298@gmail.com','2016-11-02 14:57:49','2016-11-02 14:57:49'),(380,'eee','aa0930101298@gmail.com','2016-11-03 12:38:00','2016-11-03 12:38:00'),(381,'eee','aa0930101298@gmail.com','2016-11-03 17:05:13','2016-11-03 17:05:13'),(382,'eee','aa0930101298@gmail.com','2016-11-03 20:18:42','2016-11-03 20:18:42'),(383,'eee','aa0930101298@gmail.com','2016-11-04 04:48:02','2016-11-04 04:48:02'),(384,'eee','aa0930101298@gmail.com','2016-11-07 20:00:16','2016-11-07 20:00:16'),(385,'eee','aa0930101298@gmail.com','2016-11-13 05:08:33','2016-11-13 05:08:33'),(386,'eee','aa0930101298@gmail.com','2016-11-14 05:09:23','2016-11-14 05:09:23'),(387,'eee','aa0930101298@gmail.com','2016-11-14 05:44:43','2016-11-14 05:44:43'),(388,'eee','aa0930101298@gmail.com','2016-11-15 06:23:04','2016-11-15 06:23:04'),(389,'eee','aa0930101298@gmail.com','2016-11-15 17:56:04','2016-11-15 17:56:04'),(390,'eee','aa0930101298@gmail.com','2016-11-15 17:56:17','2016-11-15 17:56:17'),(391,'eee','aa0930101298@gmail.com','2016-11-16 01:29:29','2016-11-16 01:29:29'),(392,'eee','aa0930101298@gmail.com','2016-11-16 06:56:03','2016-11-16 06:56:03'),(393,'eee','aa0930101298@gmail.com','2016-11-17 06:30:22','2016-11-17 06:30:22'),(394,'eee','aa0930101298@gmail.com','2016-11-17 13:42:21','2016-11-17 13:42:21'),(395,'eee','aa0930101298@gmail.com','2016-11-18 22:32:46','2016-11-18 22:32:46'),(396,'eee','aa0930101298@gmail.com','2016-11-20 06:16:12','2016-11-20 06:16:12'),(397,'eee','aa0930101298@gmail.com','2016-11-23 09:11:57','2016-11-23 09:11:57'),(398,'eee','aa0930101298@gmail.com','2016-11-24 07:17:11','2016-11-24 07:17:11'),(399,'eee','aa0930101298@gmail.com','2016-11-24 14:31:55','2016-11-24 14:31:55'),(400,'eee','aa0930101298@gmail.com','2016-11-25 10:55:41','2016-11-25 10:55:41'),(401,'eee','aa0930101298@gmail.com','2016-11-25 16:39:32','2016-11-25 16:39:32'),(402,'eee','aa0930101298@gmail.com','2016-11-26 10:50:38','2016-11-26 10:50:38'),(403,'eee','aa0930101298@gmail.com','2016-11-27 08:47:59','2016-11-27 08:47:59'),(404,'eee','aa0930101298@gmail.com','2016-11-27 16:54:25','2016-11-27 16:54:25'),(405,'eee','aa0930101298@gmail.com','2016-11-28 03:04:39','2016-11-28 03:04:39'),(406,'eee','aa0930101298@gmail.com','2016-11-29 19:08:00','2016-11-29 19:08:00'),(407,'eee','aa0930101298@gmail.com','2016-11-30 08:04:44','2016-11-30 08:04:44'),(408,'eee','aa0930101298@gmail.com','2016-11-30 15:02:05','2016-11-30 15:02:05'),(409,'eee','aa0930101298@gmail.com','2016-12-01 00:09:32','2016-12-01 00:09:32'),(410,'eee','aa0930101298@gmail.com','2016-12-04 13:31:13','2016-12-04 13:31:13'),(411,'eee','aa0930101298@gmail.com','2016-12-11 08:30:36','2016-12-11 08:30:36'),(412,'eee','aa0930101298@gmail.com','2016-12-11 10:40:52','2016-12-11 10:40:52'),(413,'eee','aa0930101298@gmail.com','2016-12-14 09:55:00','2016-12-14 09:55:00'),(414,'eee','aa0930101298@gmail.com','2016-12-17 13:49:30','2016-12-17 13:49:30'),(415,'eee','aa0930101298@gmail.com','2016-12-17 13:53:05','2016-12-17 13:53:05'),(416,'eee','aa0930101298@gmail.com','2016-12-17 14:01:08','2016-12-17 14:01:08'),(417,'eee','aa0930101298@gmail.com','2016-12-17 14:16:23','2016-12-17 14:16:23'),(418,'eee','aa0930101298@gmail.com','2016-12-25 20:34:52','2016-12-25 20:34:52'),(419,'eee','aa0930101298@gmail.com','2016-12-26 23:53:31','2016-12-26 23:53:31'),(420,'eee','aa0930101298@gmail.com','2017-01-15 08:45:29','2017-01-15 08:45:29'),(421,'eee','aa0930101298@gmail.com','2017-01-15 10:02:17','2017-01-15 10:02:17'),(422,'eee','aa0930101298@gmail.com','2017-01-15 10:20:46','2017-01-15 10:20:46'),(423,'eee','aa0930101298@gmail.com','2017-01-15 13:00:45','2017-01-15 13:00:45'),(424,'eee','aa0930101298@gmail.com','2017-01-15 20:02:25','2017-01-15 20:02:25'),(425,'eee','aa0930101298@gmail.com','2017-01-16 19:16:46','2017-01-16 19:16:46'),(426,'eee','aa0930101298@gmail.com','2017-01-17 08:46:27','2017-01-17 08:46:27'),(427,'eee','aa0930101298@gmail.com','2017-01-17 18:25:48','2017-01-17 18:25:48'),(428,'eee','aa0930101298@gmail.com','2017-01-18 11:55:00','2017-01-18 11:55:00'),(429,'eee','aa0930101298@gmail.com','2017-01-19 19:34:07','2017-01-19 19:34:07'),(430,'eee','aa0930101298@gmail.com','2017-01-21 23:54:59','2017-01-21 23:54:59'),(431,'eee','aa0930101298@gmail.com','2017-01-22 09:19:07','2017-01-22 09:19:07'),(432,'eee','aa0930101298@gmail.com','2017-01-22 12:49:31','2017-01-22 12:49:31'),(433,'eee','aa0930101298@gmail.com','2017-01-24 23:16:30','2017-01-24 23:16:30'),(434,'eee','aa0930101298@gmail.com','2017-01-25 18:40:42','2017-01-25 18:40:42'),(435,'eee','aa0930101298@gmail.com','2017-02-08 07:29:42','2017-02-08 07:29:42'),(436,'eee','aa0930101298@gmail.com','2017-02-08 08:09:08','2017-02-08 08:09:08'),(437,'eee','aa0930101298@gmail.com','2017-02-10 07:47:21','2017-02-10 07:47:21'),(438,'eee','aa0930101298@gmail.com','2017-02-14 08:59:00','2017-02-14 08:59:00'),(439,'eee','aa0930101298@gmail.com','2017-02-14 11:08:53','2017-02-14 11:08:53'),(440,'eee','aa0930101298@gmail.com','2017-02-14 14:19:44','2017-02-14 14:19:44'),(441,'eee','aa0930101298@gmail.com','2017-02-17 08:26:51','2017-02-17 08:26:51'),(442,'eee','aa0930101298@gmail.com','2017-02-17 12:20:46','2017-02-17 12:20:46'),(443,'eee','aa0930101298@gmail.com','2017-02-17 16:43:05','2017-02-17 16:43:05'),(444,'eee','aa0930101298@gmail.com','2017-02-18 06:31:48','2017-02-18 06:31:48'),(445,'eee','aa0930101298@gmail.com','2017-02-20 02:31:48','2017-02-20 02:31:48'),(446,'eee','aa0930101298@gmail.com','2017-02-21 10:21:20','2017-02-21 10:21:20'),(447,'eee','aa0930101298@gmail.com','2017-02-22 07:23:11','2017-02-22 07:23:11'),(448,'eee','aa0930101298@gmail.com','2017-02-22 11:57:49','2017-02-22 11:57:49'),(449,'eee','aa0930101298@gmail.com','2017-02-22 14:40:20','2017-02-22 14:40:20'),(450,'eee','aa0930101298@gmail.com','2017-02-23 07:48:30','2017-02-23 07:48:30'),(451,'eee','aa0930101298@gmail.com','2017-02-26 06:13:18','2017-02-26 06:13:18'),(452,'eee','aa0930101298@gmail.com','2017-02-26 10:30:45','2017-02-26 10:30:45'),(453,'eee','aa0930101298@gmail.com','2017-03-12 16:14:40','2017-03-12 16:14:40'),(454,'eee','aa0930101298@gmail.com','2017-03-14 03:37:07','2017-03-14 03:37:07');
976/*!40000 ALTER TABLE `SIGN_RECORD` ENABLE KEYS */;
977UNLOCK TABLES;
978
979--
980-- Table structure for table `SLIDER`
981--
982
983DROP TABLE IF EXISTS `SLIDER`;
984/*!40101 SET @saved_cs_client     = @@character_set_client */;
985/*!40101 SET character_set_client = utf8 */;
986CREATE TABLE `SLIDER` (
987  `ID` int(11) NOT NULL AUTO_INCREMENT,
988  `IMG_ID` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
989  `TYPE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
990  `URL` text COLLATE utf8_unicode_ci,
991  `SORT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
992  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
993  `CREATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
994  `UPDATED_AT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
995  PRIMARY KEY (`ID`)
996) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
997/*!40101 SET character_set_client = @saved_cs_client */;
998
999--
1000-- Dumping data for table `SLIDER`
1001--
1002
1003LOCK TABLES `SLIDER` WRITE;
1004/*!40000 ALTER TABLE `SLIDER` DISABLE KEYS */;
1005INSERT INTO `SLIDER` VALUES (17,'[184]','curation_index',NULL,'',NULL,'2016-06-01 14:06:23','2016-06-02 19:08:02'),(18,'[185]','curation_index',NULL,'',NULL,'2016-06-01 14:08:23','2016-06-20 18:41:52'),(20,'[187]','curation_index',NULL,'',NULL,'2016-06-01 14:38:09','2016-06-24 15:17:08'),(23,'[198]','curation_pre_order',NULL,'',NULL,'2016-06-01 14:56:22','2016-06-24 15:16:50'),(27,'[211]','curation_pre_order',NULL,'2',NULL,'2016-06-02 18:53:34','2016-06-24 15:16:50'),(48,'[275]','index',NULL,'1',NULL,'2016-09-27 10:38:24','2016-11-02 23:31:07'),(51,'[283]','index','https://www.google.com.tw/','2',NULL,'2016-11-02 23:30:53','2016-11-02 23:31:07');
1006/*!40000 ALTER TABLE `SLIDER` ENABLE KEYS */;
1007UNLOCK TABLES;
1008
1009--
1010-- Table structure for table `SNAPPY_EXHIBITION`
1011--
1012
1013DROP TABLE IF EXISTS `SNAPPY_EXHIBITION`;
1014/*!40101 SET @saved_cs_client     = @@character_set_client */;
1015/*!40101 SET character_set_client = utf8 */;
1016CREATE TABLE `SNAPPY_EXHIBITION` (
1017  `ID` int(11) NOT NULL AUTO_INCREMENT,
1018  `CURATOR_NAME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '策展人名稱',
1019  `VEMUE_NAME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '場地資訊',
1020  `IMG_ID` text CHARACTER SET utf8 COMMENT '圖片List',
1021  `SUBJECT` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '標題',
1022  `CONTENT` longtext CHARACTER SET utf8 COMMENT '內文',
1023  `CITY` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1024  `ZONE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1025  `ZIP` int(11) DEFAULT NULL,
1026  `ADDRESS` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '地址',
1027  `START_DATE` date DEFAULT NULL COMMENT '活動日期',
1028  `START_TIME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '開始',
1029  `END_DATE` date DEFAULT NULL,
1030  `END_TIME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '結束',
1031  `INGREDIENTS_ID` int(11) DEFAULT NULL COMMENT '食材ＩＤ',
1032  `CREATED_AT` timestamp NULL DEFAULT NULL,
1033  `UPDATED_AT` timestamp NULL DEFAULT NULL,
1034  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1035  PRIMARY KEY (`ID`)
1036) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1037/*!40101 SET character_set_client = @saved_cs_client */;
1038
1039--
1040-- Dumping data for table `SNAPPY_EXHIBITION`
1041--
1042
1043LOCK TABLES `SNAPPY_EXHIBITION` WRITE;
1044/*!40000 ALTER TABLE `SNAPPY_EXHIBITION` DISABLE KEYS */;
1045/*!40000 ALTER TABLE `SNAPPY_EXHIBITION` ENABLE KEYS */;
1046UNLOCK TABLES;
1047
1048--
1049-- Table structure for table `SNAPPY_PRODUCT`
1050--
1051
1052DROP TABLE IF EXISTS `SNAPPY_PRODUCT`;
1053/*!40101 SET @saved_cs_client     = @@character_set_client */;
1054/*!40101 SET character_set_client = utf8 */;
1055CREATE TABLE `SNAPPY_PRODUCT` (
1056  `ID` int(11) NOT NULL AUTO_INCREMENT,
1057  `SORT` int(11) NOT NULL COMMENT '排序',
1058  `PROMOTIONS_ID` int(11) DEFAULT '0' COMMENT '促銷編號',
1059  `NAME` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '名稱\n只存繁體中文 提供後台快速搜尋',
1060  `SERIAL_NUMBER` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品序號',
1061  `PROMOTIONS_PRICE` int(11) DEFAULT NULL COMMENT '加購優惠價',
1062  `POINT` int(11) DEFAULT NULL COMMENT '回饋紅利',
1063  `STORE_NAME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商店名稱',
1064  `STORE_AREA` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1065  `STORE_ADDRESS` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商店地址',
1066  `STORE_DETAIL` text COLLATE utf8_unicode_ci,
1067  `STORE_EMAIL` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
1068  `PRE_ORDER_START_DATE` timestamp NULL DEFAULT NULL COMMENT '預購開始日期',
1069  `PRE_ORDER_END_DATE` timestamp NULL DEFAULT NULL COMMENT '預購結束日期',
1070  `TEXT_DETAIL` text COLLATE utf8_unicode_ci COMMENT '文字簡介',
1071  `DETAIL` text COLLATE utf8_unicode_ci COMMENT '詳細內容',
1072  `KIND` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '商品種類\ngoods 一般商品\nfood 食品',
1073  `WEIGHT_UNIT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '重量單位\n公斤 公克 包 條 片',
1074  `PRESERVATION` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '保存方法',
1075  `SHELF_LIFE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '保存期限',
1076  `PRECAUTIONS` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '注意事項',
1077  `NOTE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '其他備註',
1078  `FREE_SHIPPING` varchar(45) COLLATE utf8_unicode_ci DEFAULT 'close' COMMENT '是否免運',
1079  `SHIPPING_COST` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1080  `IMG_ID` text COLLATE utf8_unicode_ci COMMENT '圖片清單\n[1,2,3]',
1081  `STATUS` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '狀態',
1082  `CREATED_AT` timestamp NULL DEFAULT NULL COMMENT '建置時間',
1083  `UPDATED_AT` timestamp NULL DEFAULT NULL COMMENT '更新時間',
1084  PRIMARY KEY (`ID`)
1085) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1086/*!40101 SET character_set_client = @saved_cs_client */;
1087
1088--
1089-- Dumping data for table `SNAPPY_PRODUCT`
1090--
1091
1092LOCK TABLES `SNAPPY_PRODUCT` WRITE;
1093/*!40000 ALTER TABLE `SNAPPY_PRODUCT` DISABLE KEYS */;
1094INSERT INTO `SNAPPY_PRODUCT` VALUES (1,1,0,'1111123123','sss',0,0,'332323','north','123','\n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            <p><br>sss</p>\n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          ',NULL,'2017-01-19 16:00:00','2017-02-27 16:00:00','333','\n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              <p><br></p>\n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ','food','33','因為果醬完全不含防腐劑及色素，保存上較不易，請避免於陽光直射與高溫處存放，以免影響品質與色澤。','果醬未開封時，置於陰涼處，可保存12個月。<br>*果醬開封後皆需冷藏，最佳賞味期２個星期內為最佳。','本產品皆為素食者可用。','1.糖就是天然的防腐劑。糖的高滲透壓可以使細菌和黴菌生理脫水，因而細菌黴菌無法生長與繁殖。我們的祖先利用鹽或糖來醃漬蔬菜，也是這個原理。<br>\n              2.在果醬煮好之後必需在溫度退到８５℃之前將果醬裝罐，由於果醬冷卻後體積會縮小，罐子裡會形成半真空狀態，這樣有利於保存。','close','123','[283]','open','2017-01-17 23:21:28','2017-02-10 07:52:31'),(2,2,0,'test','sss',0,0,'332323','north','123','\n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            <p><br>sss</p>\n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          \n                                          ',NULL,'2017-01-19 16:00:00','2017-02-27 16:00:00','333','\n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              \n                                              <p><br></p>\n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            \n                                            ','food','33','因為果醬完全不含防腐劑及色素，保存上較不易，請避免於陽光直射與高溫處存放，以免影響品質與色澤。','果醬未開封時，置於陰涼處，可保存12個月。<br>*果醬開封後皆需冷藏，最佳賞味期２個星期內為最佳。','本產品皆為素食者可用。','1.糖就是天然的防腐劑。糖的高滲透壓可以使細菌和黴菌生理脫水，因而細菌黴菌無法生長與繁殖。我們的祖先利用鹽或糖來醃漬蔬菜，也是這個原理。<br>\n              2.在果醬煮好之後必需在溫度退到８５℃之前將果醬裝罐，由於果醬冷卻後體積會縮小，罐子裡會形成半真空狀態，這樣有利於保存。','close','123','[]','open','2017-01-17 23:21:28','2017-01-22 12:49:40');
1095/*!40000 ALTER TABLE `SNAPPY_PRODUCT` ENABLE KEYS */;
1096UNLOCK TABLES;
1097
1098--
1099-- Table structure for table `SNAPPY_PRODUCT_PACKAGE`
1100--
1101
1102DROP TABLE IF EXISTS `SNAPPY_PRODUCT_PACKAGE`;
1103/*!40101 SET @saved_cs_client     = @@character_set_client */;
1104/*!40101 SET character_set_client = utf8 */;
1105CREATE TABLE `SNAPPY_PRODUCT_PACKAGE` (
1106  `ID` int(11) NOT NULL AUTO_INCREMENT,
1107  `PID` int(11) NOT NULL COMMENT '商品ＩＤ\n',
1108  `NAME` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '包裝方案名稱',
1109  `PRICE` int(11) NOT NULL COMMENT '價錢(新台幣TWD為準)',
1110  `DETAIL` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '介紹內文',
1111  `QTY` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT '購買限制數量 一盒24個',
1112  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '狀態',
1113  `CREATED_AT` timestamp NULL DEFAULT NULL COMMENT '建置時間',
1114  `UPDATED_AT` timestamp NULL DEFAULT NULL COMMENT '更新時間',
1115  PRIMARY KEY (`ID`)
1116) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1117/*!40101 SET character_set_client = @saved_cs_client */;
1118
1119--
1120-- Dumping data for table `SNAPPY_PRODUCT_PACKAGE`
1121--
1122
1123LOCK TABLES `SNAPPY_PRODUCT_PACKAGE` WRITE;
1124/*!40000 ALTER TABLE `SNAPPY_PRODUCT_PACKAGE` DISABLE KEYS */;
1125INSERT INTO `SNAPPY_PRODUCT_PACKAGE` VALUES (1,1,'1',3,'2','4','delete','2017-01-17 23:21:28','2017-01-22 09:24:59'),(3,1,'3',1,'2','5','open','2017-01-22 02:41:37','2017-01-22 09:24:59'),(4,1,'test',0,'test','10','delete','2017-01-22 09:24:59','2017-01-22 09:25:24'),(5,1,'test',100,'test','10','open','2017-01-22 09:25:24','2017-01-22 09:25:24');
1126/*!40000 ALTER TABLE `SNAPPY_PRODUCT_PACKAGE` ENABLE KEYS */;
1127UNLOCK TABLES;
1128
1129--
1130-- Table structure for table `SNAPPY_PRODUCT_STYLE`
1131--
1132
1133DROP TABLE IF EXISTS `SNAPPY_PRODUCT_STYLE`;
1134/*!40101 SET @saved_cs_client     = @@character_set_client */;
1135/*!40101 SET character_set_client = utf8 */;
1136CREATE TABLE `SNAPPY_PRODUCT_STYLE` (
1137  `ID` int(11) NOT NULL AUTO_INCREMENT,
1138  `PID` int(11) NOT NULL COMMENT '產品ID',
1139  `COLOR` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '顏色\n主要英文為主\n或存色碼',
1140  `STYLE` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '款式\n男款 女款 經典款',
1141  `SIZE` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '尺寸',
1142  `TASTE` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '口味',
1143  `QTY` int(11) NOT NULL COMMENT '庫存數量',
1144  `IMG_ICON` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '款式縮圖',
1145  `IMG_URL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '款式介紹圖',
1146  `NUTRITION_FACTS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '營養成分表-僅限食品顯示\n對照口味切換',
1147  `DETAIL` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '介紹內文',
1148  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '狀態',
1149  `CREATED_AT` timestamp NULL DEFAULT NULL,
1150  `UPDATED_AT` timestamp NULL DEFAULT NULL,
1151  PRIMARY KEY (`ID`)
1152) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1153/*!40101 SET character_set_client = @saved_cs_client */;
1154
1155--
1156-- Dumping data for table `SNAPPY_PRODUCT_STYLE`
1157--
1158
1159LOCK TABLES `SNAPPY_PRODUCT_STYLE` WRITE;
1160/*!40000 ALTER TABLE `SNAPPY_PRODUCT_STYLE` DISABLE KEYS */;
1161INSERT INTO `SNAPPY_PRODUCT_STYLE` VALUES (1,1,'3','33','3','3',10,'http://static2.businessinsider.com/image/5654150584307663008b4ed8-480/hamilton.jpg','http://static2.businessinsider.com/image/5654150584307663008b4ed8-480/hamilton.jpg','http://static2.businessinsider.com/image/5654150584307663008b4ed8-480/hamilton.jpg','detail','delete','2017-01-17 23:21:28','2017-01-22 09:24:59'),(2,1,'5','5','5','5',82,'','','','none','open','2017-01-17 23:21:28','2017-02-14 14:31:36'),(3,2,'test','test','test',NULL,10,NULL,NULL,NULL,NULL,'open','2017-01-22 09:24:59','2017-01-22 09:25:48'),(4,1,'test','test','test',NULL,10,NULL,NULL,NULL,NULL,'delete','2017-01-22 09:25:48','2017-01-22 09:29:25'),(5,1,'test','test','test',NULL,10,NULL,NULL,NULL,NULL,'delete','2017-01-22 09:29:25','2017-01-22 09:30:05'),(6,1,'test','test','test',NULL,10,NULL,NULL,NULL,NULL,'delete','2017-01-22 09:30:05','2017-01-22 09:32:01'),(7,1,'test','test','test','test',53,'https://i2.wp.com/farm2.staticflickr.com/1511/24840660351_1732552d65_z.jpg?zoom=2&w=960&quality=100&ssl=1','https://i2.wp.com/farm2.staticflickr.com/1511/24840660351_1732552d65_z.jpg?zoom=2&w=960&quality=100&ssl=1','https://i2.wp.com/farm2.staticflickr.com/1511/24840660351_1732552d65_z.jpg?zoom=2&w=960&quality=100&ssl=1','test','open','2017-01-22 09:32:01','2017-02-14 14:31:36');
1162/*!40000 ALTER TABLE `SNAPPY_PRODUCT_STYLE` ENABLE KEYS */;
1163UNLOCK TABLES;
1164
1165--
1166-- Table structure for table `SNAPPY_RECIPES`
1167--
1168
1169DROP TABLE IF EXISTS `SNAPPY_RECIPES`;
1170/*!40101 SET @saved_cs_client     = @@character_set_client */;
1171/*!40101 SET character_set_client = utf8 */;
1172CREATE TABLE `SNAPPY_RECIPES` (
1173  `ID` int(11) NOT NULL AUTO_INCREMENT,
1174  `TITLE` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
1175  `DETAILS` mediumtext COLLATE utf8_unicode_ci,
1176  `IMG_ID` mediumtext COLLATE utf8_unicode_ci,
1177  `CREATED_AT` timestamp NULL DEFAULT NULL,
1178  `UPDATED_AT` timestamp NULL DEFAULT NULL,
1179  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1180  `SORT` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1181  PRIMARY KEY (`ID`)
1182) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1183/*!40101 SET character_set_client = @saved_cs_client */;
1184
1185--
1186-- Dumping data for table `SNAPPY_RECIPES`
1187--
1188
1189LOCK TABLES `SNAPPY_RECIPES` WRITE;
1190/*!40000 ALTER TABLE `SNAPPY_RECIPES` DISABLE KEYS */;
1191/*!40000 ALTER TABLE `SNAPPY_RECIPES` ENABLE KEYS */;
1192UNLOCK TABLES;
1193
1194--
1195-- Table structure for table `SNAPPY_SHOPPING_LIST`
1196--
1197
1198DROP TABLE IF EXISTS `SNAPPY_SHOPPING_LIST`;
1199/*!40101 SET @saved_cs_client     = @@character_set_client */;
1200/*!40101 SET character_set_client = utf8 */;
1201CREATE TABLE `SNAPPY_SHOPPING_LIST` (
1202  `ID` int(11) NOT NULL AUTO_INCREMENT,
1203  `MEMBER_ID` varchar(45) CHARACTER SET utf8 NOT NULL,
1204  `PRODUCT_ID` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
1205  `PACKAGE_ID` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1206  `STYLE` text COLLATE utf8_unicode_ci COMMENT '[\n        {\n          "ID": "1",\n          "COLOR": "black",\n          "STYLE": "tee",\n          "SIZE": "s",\n          "TASTE": "apple",\n          "QTY": "1"\n        }\n      ]',
1207  `PACKAGE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '包裝\n[\n    {\n      "ID": "1",\n      "NAME": "禮盒裝",\n      "PRICE": 22,\n      "SUB_TOTAL": "22",\n      "FREE_SHIPPING": "free",\n      "SHIPPING_COST": "50",\n}\n  ]',
1208  `QTY` varchar(45) CHARACTER SET utf8 NOT NULL,
1209  `SUB_TOTAL` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
1210  `CREATED_AT` timestamp NULL DEFAULT NULL,
1211  `UPDATED_AT` timestamp NULL DEFAULT NULL,
1212  PRIMARY KEY (`ID`)
1213) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1214/*!40101 SET character_set_client = @saved_cs_client */;
1215
1216--
1217-- Dumping data for table `SNAPPY_SHOPPING_LIST`
1218--
1219
1220LOCK TABLES `SNAPPY_SHOPPING_LIST` WRITE;
1221/*!40000 ALTER TABLE `SNAPPY_SHOPPING_LIST` DISABLE KEYS */;
1222INSERT INTO `SNAPPY_SHOPPING_LIST` VALUES (1,'1','1','3','[{\"ID\":\"2\",\"QTY\":\"1\"},{\"ID\":\"7\",\"QTY\":\"1\"}]','{\"ID\":3,\"NAME\":\"3\",\"PRICE\":1}','1','1','2017-02-22 14:05:05','2017-02-22 14:05:09');
1223/*!40000 ALTER TABLE `SNAPPY_SHOPPING_LIST` ENABLE KEYS */;
1224UNLOCK TABLES;
1225
1226--
1227-- Table structure for table `STORE_SETTING`
1228--
1229
1230DROP TABLE IF EXISTS `STORE_SETTING`;
1231/*!40101 SET @saved_cs_client     = @@character_set_client */;
1232/*!40101 SET character_set_client = utf8 */;
1233CREATE TABLE `STORE_SETTING` (
1234  `ID` int(11) NOT NULL AUTO_INCREMENT,
1235  `CURRENCY` varchar(250) CHARACTER SET utf8 NOT NULL COMMENT '貨幣種類',
1236  `PAYMENT` varchar(250) CHARACTER SET utf8 NOT NULL COMMENT '付款方式',
1237  `SHIPPING_WAY` varchar(250) CHARACTER SET utf8 NOT NULL COMMENT '運送方式\n按照運送方式區分 運費將以寄送方式的不同相加差額\n[“HOME”:65,”STORE”:”55”]',
1238  `SHIPPING_AREA` varchar(250) CHARACTER SET utf8 NOT NULL COMMENT '運送地區\n按照國家名稱為主 運費將以寄送的國家相加差額\n[“Taiwan”:100,”Japan”:250]',
1239  `SHIPPING_MULTIPLE_QTY` int(11) NOT NULL DEFAULT '2' COMMENT '運費數量的倍數\n只能一個int數字\n5=> 5、10、15個數量區間倍數',
1240  `SHIPPING_COST` varchar(250) COLLATE utf8_latvian_ci NOT NULL COMMENT '運費成本按照倍數相乘數量順序計算\n1~5=50, 6~10=100 -> [“50”,”100”]',
1241  `COMPANY` varchar(8) CHARACTER SET utf8 NOT NULL COMMENT '公司名稱',
1242  `TAXID` varchar(90) CHARACTER SET utf8 DEFAULT NULL COMMENT '統編',
1243  `COUNTRY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1244  `CITY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1245  `ZONE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1246  `ZIP` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1247  `ADDRESS` varchar(45) CHARACTER SET utf8 NOT NULL COMMENT '地址',
1248  `VILLAGE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT '村里\n',
1249  `ROAD` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT '路街',
1250  `NEIGHBOR` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT 'é„°',
1251  `SECTION` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT '段',
1252  `ALLEY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT '弄\n',
1253  `LANE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT 'å··',
1254  `NUMBER` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT '號',
1255  `FLOOR` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL COMMENT '樓\n',
1256  `AREA_CODE` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '電話區碼',
1257  `PHONE` varchar(45) COLLATE utf8_latvian_ci NOT NULL COMMENT '電話',
1258  `EXTENSION` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1259  `EMAIL` varchar(45) CHARACTER SET utf8 NOT NULL,
1260  `FAX_AREA` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT '傳真區碼\n',
1261  `FAX_NUMBER` varchar(45) CHARACTER SET utf8 NOT NULL COMMENT '傳真電話',
1262  `FAX_EXTENSION` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1263  `CREATED_AT` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1264  `UPDATED_AT` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1265  `SKYPE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1266  `FACEBOOK` varchar(300) CHARACTER SET utf8 DEFAULT NULL,
1267  `LINEID` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1268  `PAY_TYPE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1269  `PAY_ID` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1270  `PAY_HASH_KEY` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1271  `PAY_HASH_IV` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1272  `COMPANY_DISCOUNT` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1273  `FACEBOOKID` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1274  `INSTAGRAM` varchar(300) COLLATE utf8_latvian_ci DEFAULT NULL,
1275  `TEMPLATE_NO` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1276  `STORE_TYPE` varchar(45) COLLATE utf8_latvian_ci DEFAULT NULL,
1277  `IMG_ID` varchar(250) COLLATE utf8_latvian_ci DEFAULT NULL,
1278  `META_KEYWORD` text COLLATE utf8_latvian_ci,
1279  `META_DESCRIPTION` varchar(250) COLLATE utf8_latvian_ci DEFAULT NULL,
1280  `META_AUTHOR` varchar(250) COLLATE utf8_latvian_ci DEFAULT NULL,
1281  `META_IMG_URL` text COLLATE utf8_latvian_ci,
1282  PRIMARY KEY (`ID`)
1283) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
1284/*!40101 SET character_set_client = @saved_cs_client */;
1285
1286--
1287-- Dumping data for table `STORE_SETTING`
1288--
1289
1290LOCK TABLES `STORE_SETTING` WRITE;
1291/*!40000 ALTER TABLE `STORE_SETTING` DISABLE KEYS */;
1292INSERT INTO `STORE_SETTING` VALUES (2,'[]','[]','{\"HOME\":\"60\",\"EMS\":\"0\"}','[\"overseas\"]',5,'[\"60\",\"120\",\"200\",\"0\",\"0\"]','一二三四五六七八','00000000',NULL,'臺北市','中正區','104','','','[\"中原\",\"街\"]','','','','','118','4','952','952736897','952','gn02158263@gmail.com','952','952736897','','2016-07-12 17:40:29','2016-10-25 01:59:02','','','',NULL,NULL,NULL,NULL,NULL,'',NULL,'6',NULL,'[266]',NULL,NULL,NULL,NULL);
1293/*!40000 ALTER TABLE `STORE_SETTING` ENABLE KEYS */;
1294UNLOCK TABLES;
1295
1296--
1297-- Table structure for table `WEBEDITOR`
1298--
1299
1300DROP TABLE IF EXISTS `WEBEDITOR`;
1301/*!40101 SET @saved_cs_client     = @@character_set_client */;
1302/*!40101 SET character_set_client = utf8 */;
1303CREATE TABLE `WEBEDITOR` (
1304  `ID` int(11) NOT NULL AUTO_INCREMENT,
1305  `LANGUAGE` varchar(45) COLLATE utf8_unicode_ci DEFAULT 'tw' COMMENT '多國語言\ntw台灣\nko韓國',
1306  `SITE` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'about 關於我們\ncontact 聯絡我們\nservice 服務政策\nrefund 退款政策',
1307  `DETAIL_1` longtext CHARACTER SET utf8,
1308  `DETAIL_2` longtext CHARACTER SET utf8,
1309  `IMG_1` longtext CHARACTER SET utf8,
1310  `IMG_2` longtext CHARACTER SET utf8,
1311  `CREATED_AT` timestamp NULL DEFAULT NULL,
1312  `UPDATED_AT` timestamp NULL DEFAULT NULL,
1313  PRIMARY KEY (`ID`)
1314) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1315/*!40101 SET character_set_client = @saved_cs_client */;
1316
1317--
1318-- Dumping data for table `WEBEDITOR`
1319--
1320
1321LOCK TABLES `WEBEDITOR` WRITE;
1322/*!40000 ALTER TABLE `WEBEDITOR` DISABLE KEYS */;
1323INSERT INTO `WEBEDITOR` VALUES (1,'tw','about','\n                                            \n                                            \n                                            \n                                            \n                                            <div class=\"about01\">\n      	<img src=\"/img/frontend/da0108/about_img01.jpg\" alt=\"\">\n      </div>\n    <div class=\"about02\">\n      	關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108\n      </div>\n      <div class=\"about03\"><img src=\"img/frontend/da0108/about_img02.jpg\" alt=\"\"></div>\n      <div class=\"about04\">\n      	關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108關於da0108\n      </div>\n      <div class=\"about05\">\n      	<img src=\"/img/frontend/da0108/logo02.png\" alt=\"\">\n      </div>\n      <div class=\"about06\">\n      	<div class=\"about07\">\n          	<img src=\"/img/frontend/da0108/about_img03.jpg\" alt=\"\">\n          </div>\n          <div class=\"about08\">\n          	<img src=\"/img/frontend/da0108/about_img04.png\" alt=\"\">\n          </div>\n          <div class=\"about08\">\n          	<img src=\"/img/frontend/da0108/about_img05.png\" alt=\"\">\n          </div>\n      </div>\n                                          \n                                          \n                                          \n                                          \n                                          ','1','http://localhost:8000/img/1467545020-img1.jpg',NULL,NULL,'2016-11-03 12:54:05'),(2,'tw','refund_policy','<div id=\"video\">\n    <div class=\"content\">\n    	<div class=\"videoitem\">\n        	<a href=\"#\"><img src=\"/img/frontend/da0108/video_img.jpg\" alt=\"\"></a>\n        </div>\n     	<!--<div class=\"videoplay\">\n        	<a href=\"#\"><img src=\"/img/frontend/da0108/play_btn.png\" alt=\"\"/></a>\n        </div>-->\n    </div>\n</div>\n<div id=\"magazine\">\n	<div class=\"content\">\n    	<div class=\"magazineitem\">\n        	<img src=\"/img/frontend/da0108/style _img.jpg\" alt=\"\">\n        </div>\n    </div>\n</div>','1','http://www.tophcc.com.tw/img/photo-7.jpg',NULL,NULL,'2016-09-30 06:36:04'),(3,'tw','terms_conditions','tww','1',NULL,NULL,NULL,'2016-11-03 12:54:05'),(4,'tw','index_page','\n                                            <div id=\"video\">\n    <div class=\"content\">\n    	<div class=\"videoitem\">\n        	<a href=\"#\"><img src=\"/img/frontend/da0108/video_img.jpg\" alt=\"\"></a>\n        </div>\n     	<!--<div class=\"videoplay\">\n        	<a href=\"#\"><img src=\"/img/frontend/da0108/play_btn.png\" alt=\"\"/></a>\n        </div>-->\n    </div>\n</div>\n<div id=\"magazine\">\n	<div class=\"content\">\n    	<div class=\"magazineitem\">\n        	<img src=\"/img/frontend/da0108/style _img.jpg\" alt=\"\">\n        </div>\n    </div>\n</div>\n                                          ',NULL,NULL,NULL,NULL,'2016-09-30 06:53:22'),(5,'tw','product_type','<div class=\"shopitem\">\n	        	<ul class=\"shopselect tabs\">\n	            	<li>\n                    <a href=\"#tab1\"><p>跟鞋</p><span></span>Heels</a>\n                </li>\n                <li>\n                    <a href=\"#tab2\"><p>涼鞋</p><span></span>Sandals</a>\n                </li>\n                <li>\n                    <a href=\"#tab3\"><p>平底鞋</p><span></span>Flats</a>\n                </li>\n                <li>\n                    <a href=\"#tab4\"><p>楔型鞋</p><span></span>Wedges</a>\n                </li>\n                <li>\n                    <a href=\"#tab5\"><p>休閒鞋</p><span></span>Sneakers</a>\n                </li>\n            </ul>\n            <div class=\"tab_container\">\n                <div id=\"tab1\" class=\"tab_content\">\n                    <div class=\"row\">\n                    	<div class=\"col4\">\n                    	<img src=\"/img/frontend/da0108/shop01.jpg\" alt=\"\"/>\n                        </div>\n                        <div class=\"col4\">\n                            <img src=\"/img/frontend/da0108/shop02.jpg\" alt=\"\"/>\n                        </div>\n                        <div class=\"col4\">\n                            <img src=\"/img/frontend/da0108/shop03.jpg\" alt=\"\"/>\n                        </div>\n                    </div>\n                	<div class=\"row\">\n                    	<div class=\"col8\">\n                            <img src=\"/img/frontend/da0108/shop04.jpg\" alt=\"\"/>\n                        </div>\n                        <div class=\"col4\">\n                            <img src=\"/img/frontend/da0108/shop09.jpg\" alt=\"\"/>\n                        </div>\n                    </div>\n                    <div class=\"row\">\n                    	<div class=\"col4\">\n                            <img src=\"/img/frontend/da0108/shop05.jpg\" alt=\"\"/>\n                        </div>\n                        <div class=\"col4\">\n                            <img src=\"/img/frontend/da0108/shop06.jpg\" alt=\"\"/>\n                        </div>\n                        <div class=\"shopaddress\">\n                        	<img src=\"/img/frontend/da0108/shop10.jpg\" alt=\"\"/>\n                        	<div class=\"shopinfo\">\n                                <div class=\"shoptitle\">\n                                    Online SERVICE\n                                </div>\n                                <div class=\"shoptext\">\n                                    <p>service@da0108.com.tw</p>\n                                    <p>MON-FRI<br>9:30-12:30, 13:30-18:30</p>\n                                    <p>T 02-29991311<br>F 02-29991242</p>\n                                </div>\n                            </div>\n                        </div>\n                    </div>\n                </div>\n                <div id=\"tab2\" class=\"tab_content\">\n                </div>\n                <div id=\"tab3\" class=\"tab_content\">\n                </div>\n                <div id=\"tab4\" class=\"tab_content\">\n                </div>\n                <div id=\"tab5\" class=\"tab_content\">\n                </div>\n	            </div>\n	        </div>',NULL,NULL,NULL,NULL,'2016-09-30 06:53:22'),(6,'cn','about','cn',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05'),(7,'en','about','en',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05'),(8,'jp','about','jp',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05'),(9,'ko','about','ko',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05'),(10,'cn','terms_conditions','cnn',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05'),(11,'en','terms_conditions','enn',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05'),(12,'jp','terms_conditions','jpp',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05'),(13,'ko','terms_conditions','koo',NULL,NULL,NULL,'2016-11-03 12:54:05','2016-11-03 12:54:05');
1324/*!40000 ALTER TABLE `WEBEDITOR` ENABLE KEYS */;
1325UNLOCK TABLES;
1326
1327--
1328-- Table structure for table `WORK_TEAM`
1329--
1330
1331DROP TABLE IF EXISTS `WORK_TEAM`;
1332/*!40101 SET @saved_cs_client     = @@character_set_client */;
1333/*!40101 SET character_set_client = utf8 */;
1334CREATE TABLE `WORK_TEAM` (
1335  `ID` int(11) NOT NULL AUTO_INCREMENT,
1336  `NAME` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
1337  `IMG_URL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
1338  `COMPANY_NAME` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
1339  `JOB_TITLE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '工作職位',
1340  `EDUCATION` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '教育',
1341  `PROFESSION` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '專業',
1342  `FACEBOOK` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'fb網址',
1343  `STATUS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1344  `SORT` int(11) DEFAULT NULL,
1345  `CREATED_AT` timestamp NULL DEFAULT NULL,
1346  `UPDATED_AT` timestamp NULL DEFAULT NULL,
1347  PRIMARY KEY (`ID`)
1348) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1349/*!40101 SET character_set_client = @saved_cs_client */;
1350
1351--
1352-- Dumping data for table `WORK_TEAM`
1353--
1354
1355LOCK TABLES `WORK_TEAM` WRITE;
1356/*!40000 ALTER TABLE `WORK_TEAM` DISABLE KEYS */;
1357/*!40000 ALTER TABLE `WORK_TEAM` ENABLE KEYS */;
1358UNLOCK TABLES;
1359/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1360
1361/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1362/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1363/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1364/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1365/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1366/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1367/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1368
1369-- Dump completed on 2017-03-15 20:16:36