API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 15th, 2017
341
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 203.34 KB | None | 0 0
raw download clone embed print report
  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.  
  22. DROP TABLE IF EXISTS `ABOUT`;
  23. /*!40101 SET @saved_cs_client = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE 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.  
  41. LOCK TABLES `ABOUT` WRITE;
  42. /*!40000 ALTER TABLE `ABOUT` DISABLE KEYS */;
  43. INSERT 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 */;
  45. UNLOCK TABLES;
  46.  
  47. --
  48. -- Table structure for table `ADMIN`
  49. --
  50.  
  51. DROP TABLE IF EXISTS `ADMIN`;
  52. /*!40101 SET @saved_cs_client = @@character_set_client */;
  53. /*!40101 SET character_set_client = utf8 */;
  54. CREATE 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.  
  72. LOCK TABLES `ADMIN` WRITE;
  73. /*!40000 ALTER TABLE `ADMIN` DISABLE KEYS */;
  74. INSERT 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 */;
  76. UNLOCK TABLES;
  77.  
  78. --
  79. -- Table structure for table `BRANCH`
  80. --
  81.  
  82. DROP TABLE IF EXISTS `BRANCH`;
  83. /*!40101 SET @saved_cs_client = @@character_set_client */;
  84. /*!40101 SET character_set_client = utf8 */;
  85. CREATE 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.  
  106. LOCK TABLES `BRANCH` WRITE;
  107. /*!40000 ALTER TABLE `BRANCH` DISABLE KEYS */;
  108. INSERT 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 */;
  110. UNLOCK TABLES;
  111.  
  112. --
  113. -- Table structure for table `BUGREPORT`
  114. --
  115.  
  116. DROP TABLE IF EXISTS `BUGREPORT`;
  117. /*!40101 SET @saved_cs_client = @@character_set_client */;
  118. /*!40101 SET character_set_client = utf8 */;
  119. CREATE 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.  
  134. LOCK TABLES `BUGREPORT` WRITE;
  135. /*!40000 ALTER TABLE `BUGREPORT` DISABLE KEYS */;
  136. /*!40000 ALTER TABLE `BUGREPORT` ENABLE KEYS */;
  137. UNLOCK TABLES;
  138.  
  139. --
  140. -- Table structure for table `BUSINESS_SERVICES`
  141. --
  142.  
  143. DROP TABLE IF EXISTS `BUSINESS_SERVICES`;
  144. /*!40101 SET @saved_cs_client = @@character_set_client */;
  145. /*!40101 SET character_set_client = utf8 */;
  146. CREATE 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.  
  166. LOCK TABLES `BUSINESS_SERVICES` WRITE;
  167. /*!40000 ALTER TABLE `BUSINESS_SERVICES` DISABLE KEYS */;
  168. /*!40000 ALTER TABLE `BUSINESS_SERVICES` ENABLE KEYS */;
  169. UNLOCK TABLES;
  170.  
  171. --
  172. -- Table structure for table `CONTACT_BACKUP`
  173. --
  174.  
  175. DROP TABLE IF EXISTS `CONTACT_BACKUP`;
  176. /*!40101 SET @saved_cs_client = @@character_set_client */;
  177. /*!40101 SET character_set_client = utf8 */;
  178. CREATE 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.  
  196. LOCK TABLES `CONTACT_BACKUP` WRITE;
  197. /*!40000 ALTER TABLE `CONTACT_BACKUP` DISABLE KEYS */;
  198. INSERT 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 */;
  200. UNLOCK TABLES;
  201.  
  202. --
  203. -- Table structure for table `IMG`
  204. --
  205.  
  206. DROP TABLE IF EXISTS `IMG`;
  207. /*!40101 SET @saved_cs_client = @@character_set_client */;
  208. /*!40101 SET character_set_client = utf8 */;
  209. CREATE 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.  
  224. LOCK TABLES `IMG` WRITE;
  225. /*!40000 ALTER TABLE `IMG` DISABLE KEYS */;
  226. INSERT 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 */;
  228. UNLOCK TABLES;
  229.  
  230. --
  231. -- Table structure for table `JOB`
  232. --
  233.  
  234. DROP TABLE IF EXISTS `JOB`;
  235. /*!40101 SET @saved_cs_client = @@character_set_client */;
  236. /*!40101 SET character_set_client = utf8 */;
  237. CREATE 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.  
  263. LOCK TABLES `JOB` WRITE;
  264. /*!40000 ALTER TABLE `JOB` DISABLE KEYS */;
  265. INSERT 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 */;
  267. UNLOCK TABLES;
  268.  
  269. --
  270. -- Table structure for table `JOB_SEEKER`
  271. --
  272.  
  273. DROP TABLE IF EXISTS `JOB_SEEKER`;
  274. /*!40101 SET @saved_cs_client = @@character_set_client */;
  275. /*!40101 SET character_set_client = utf8 */;
  276. CREATE 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.  
  297. LOCK TABLES `JOB_SEEKER` WRITE;
  298. /*!40000 ALTER TABLE `JOB_SEEKER` DISABLE KEYS */;
  299. INSERT 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 */;
  301. UNLOCK TABLES;
  302.  
  303. --
  304. -- Table structure for table `MEMBER`
  305. --
  306.  
  307. DROP TABLE IF EXISTS `MEMBER`;
  308. /*!40101 SET @saved_cs_client = @@character_set_client */;
  309. /*!40101 SET character_set_client = utf8 */;
  310. CREATE 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.  
  345. LOCK TABLES `MEMBER` WRITE;
  346. /*!40000 ALTER TABLE `MEMBER` DISABLE KEYS */;
  347. INSERT 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 */;
  349. UNLOCK TABLES;
  350.  
  351. --
  352. -- Table structure for table `NEWS`
  353. --
  354.  
  355. DROP TABLE IF EXISTS `NEWS`;
  356. /*!40101 SET @saved_cs_client = @@character_set_client */;
  357. /*!40101 SET character_set_client = utf8 */;
  358. CREATE 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.  
  376. LOCK TABLES `NEWS` WRITE;
  377. /*!40000 ALTER TABLE `NEWS` DISABLE KEYS */;
  378. INSERT 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 */;
  380. UNLOCK TABLES;
  381.  
  382. --
  383. -- Table structure for table `NEWS_INFO`
  384. --
  385.  
  386. DROP TABLE IF EXISTS `NEWS_INFO`;
  387. /*!40101 SET @saved_cs_client = @@character_set_client */;
  388. /*!40101 SET character_set_client = utf8 */;
  389. CREATE 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.  
  405. LOCK TABLES `NEWS_INFO` WRITE;
  406. /*!40000 ALTER TABLE `NEWS_INFO` DISABLE KEYS */;
  407. /*!40000 ALTER TABLE `NEWS_INFO` ENABLE KEYS */;
  408. UNLOCK TABLES;
  409.  
  410. --
  411. -- Table structure for table `NEWS_TYPE`
  412. --
  413.  
  414. DROP TABLE IF EXISTS `NEWS_TYPE`;
  415. /*!40101 SET @saved_cs_client = @@character_set_client */;
  416. /*!40101 SET character_set_client = utf8 */;
  417. CREATE 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.  
  432. LOCK TABLES `NEWS_TYPE` WRITE;
  433. /*!40000 ALTER TABLE `NEWS_TYPE` DISABLE KEYS */;
  434. INSERT 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 */;
  436. UNLOCK TABLES;
  437.  
  438. --
  439. -- Table structure for table `NEWS_TYPE_INFO`
  440. --
  441.  
  442. DROP TABLE IF EXISTS `NEWS_TYPE_INFO`;
  443. /*!40101 SET @saved_cs_client = @@character_set_client */;
  444. /*!40101 SET character_set_client = utf8 */;
  445. CREATE 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.  
  460. LOCK TABLES `NEWS_TYPE_INFO` WRITE;
  461. /*!40000 ALTER TABLE `NEWS_TYPE_INFO` DISABLE KEYS */;
  462. /*!40000 ALTER TABLE `NEWS_TYPE_INFO` ENABLE KEYS */;
  463. UNLOCK TABLES;
  464.  
  465. --
  466. -- Table structure for table `ORDER`
  467. --
  468.  
  469. DROP TABLE IF EXISTS `ORDER`;
  470. /*!40101 SET @saved_cs_client = @@character_set_client */;
  471. /*!40101 SET character_set_client = utf8 */;
  472. CREATE 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.  
  538. LOCK TABLES `ORDER` WRITE;
  539. /*!40000 ALTER TABLE `ORDER` DISABLE KEYS */;
  540. INSERT 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 */;
  542. UNLOCK TABLES;
  543.  
  544. --
  545. -- Table structure for table `PASSWORD_RESETS`
  546. --
  547.  
  548. DROP TABLE IF EXISTS `PASSWORD_RESETS`;
  549. /*!40101 SET @saved_cs_client = @@character_set_client */;
  550. /*!40101 SET character_set_client = utf8 */;
  551. CREATE 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.  
  565. LOCK TABLES `PASSWORD_RESETS` WRITE;
  566. /*!40000 ALTER TABLE `PASSWORD_RESETS` DISABLE KEYS */;
  567. INSERT 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 */;
  569. UNLOCK TABLES;
  570.  
  571. --
  572. -- Table structure for table `PRODUCT`
  573. --
  574.  
  575. DROP TABLE IF EXISTS `PRODUCT`;
  576. /*!40101 SET @saved_cs_client = @@character_set_client */;
  577. /*!40101 SET character_set_client = utf8 */;
  578. CREATE 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.  
  610. LOCK TABLES `PRODUCT` WRITE;
  611. /*!40000 ALTER TABLE `PRODUCT` DISABLE KEYS */;
  612. INSERT 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 */;
  614. UNLOCK TABLES;
  615.  
  616. --
  617. -- Table structure for table `PRODUCT_INFO`
  618. --
  619.  
  620. DROP TABLE IF EXISTS `PRODUCT_INFO`;
  621. /*!40101 SET @saved_cs_client = @@character_set_client */;
  622. /*!40101 SET character_set_client = utf8 */;
  623. CREATE 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.  
  642. LOCK TABLES `PRODUCT_INFO` WRITE;
  643. /*!40000 ALTER TABLE `PRODUCT_INFO` DISABLE KEYS */;
  644. INSERT 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 */;
  646. UNLOCK TABLES;
  647.  
  648. --
  649. -- Table structure for table `PRODUCT_STYLE`
  650. --
  651.  
  652. DROP TABLE IF EXISTS `PRODUCT_STYLE`;
  653. /*!40101 SET @saved_cs_client = @@character_set_client */;
  654. /*!40101 SET character_set_client = utf8 */;
  655. CREATE 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.  
  673. LOCK TABLES `PRODUCT_STYLE` WRITE;
  674. /*!40000 ALTER TABLE `PRODUCT_STYLE` DISABLE KEYS */;
  675. INSERT 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 */;
  677. UNLOCK TABLES;
  678.  
  679. --
  680. -- Table structure for table `PRODUCT_TYPE`
  681. --
  682.  
  683. DROP TABLE IF EXISTS `PRODUCT_TYPE`;
  684. /*!40101 SET @saved_cs_client = @@character_set_client */;
  685. /*!40101 SET character_set_client = utf8 */;
  686. CREATE 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.  
  704. LOCK TABLES `PRODUCT_TYPE` WRITE;
  705. /*!40000 ALTER TABLE `PRODUCT_TYPE` DISABLE KEYS */;
  706. INSERT 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 */;
  708. UNLOCK TABLES;
  709.  
  710. --
  711. -- Table structure for table `PRODUCT_TYPE_INFO`
  712. --
  713.  
  714. DROP TABLE IF EXISTS `PRODUCT_TYPE_INFO`;
  715. /*!40101 SET @saved_cs_client = @@character_set_client */;
  716. /*!40101 SET character_set_client = utf8 */;
  717. CREATE 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.  
  732. LOCK TABLES `PRODUCT_TYPE_INFO` WRITE;
  733. /*!40000 ALTER TABLE `PRODUCT_TYPE_INFO` DISABLE KEYS */;
  734. INSERT 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 */;
  736. UNLOCK TABLES;
  737.  
  738. --
  739. -- Table structure for table `PRODUCT_TYPE_TAG`
  740. --
  741.  
  742. DROP TABLE IF EXISTS `PRODUCT_TYPE_TAG`;
  743. /*!40101 SET @saved_cs_client = @@character_set_client */;
  744. /*!40101 SET character_set_client = utf8 */;
  745. CREATE 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.  
  759. LOCK TABLES `PRODUCT_TYPE_TAG` WRITE;
  760. /*!40000 ALTER TABLE `PRODUCT_TYPE_TAG` DISABLE KEYS */;
  761. INSERT 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 */;
  763. UNLOCK TABLES;
  764.  
  765. --
  766. -- Table structure for table `PROMOTIONS`
  767. --
  768.  
  769. DROP TABLE IF EXISTS `PROMOTIONS`;
  770. /*!40101 SET @saved_cs_client = @@character_set_client */;
  771. /*!40101 SET character_set_client = utf8 */;
  772. CREATE 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.  
  793. LOCK TABLES `PROMOTIONS` WRITE;
  794. /*!40000 ALTER TABLE `PROMOTIONS` DISABLE KEYS */;
  795. INSERT 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 */;
  797. UNLOCK TABLES;
  798.  
  799. --
  800. -- Table structure for table `PROMOTIONS_COUPON`
  801. --
  802.  
  803. DROP TABLE IF EXISTS `PROMOTIONS_COUPON`;
  804. /*!40101 SET @saved_cs_client = @@character_set_client */;
  805. /*!40101 SET character_set_client = utf8 */;
  806. CREATE 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.  
  823. LOCK TABLES `PROMOTIONS_COUPON` WRITE;
  824. /*!40000 ALTER TABLE `PROMOTIONS_COUPON` DISABLE KEYS */;
  825. INSERT 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 */;
  827. UNLOCK TABLES;
  828.  
  829. --
  830. -- Table structure for table `QA_ANSWER`
  831. --
  832.  
  833. DROP TABLE IF EXISTS `QA_ANSWER`;
  834. /*!40101 SET @saved_cs_client = @@character_set_client */;
  835. /*!40101 SET character_set_client = utf8 */;
  836. CREATE 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.  
  854. LOCK TABLES `QA_ANSWER` WRITE;
  855. /*!40000 ALTER TABLE `QA_ANSWER` DISABLE KEYS */;
  856. INSERT 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 */;
  858. UNLOCK TABLES;
  859.  
  860. --
  861. -- Table structure for table `QA_QUESTION`
  862. --
  863.  
  864. DROP TABLE IF EXISTS `QA_QUESTION`;
  865. /*!40101 SET @saved_cs_client = @@character_set_client */;
  866. /*!40101 SET character_set_client = utf8 */;
  867. CREATE 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.  
  883. LOCK TABLES `QA_QUESTION` WRITE;
  884. /*!40000 ALTER TABLE `QA_QUESTION` DISABLE KEYS */;
  885. INSERT 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 */;
  887. UNLOCK TABLES;
  888.  
  889. --
  890. -- Table structure for table `RATING`
  891. --
  892.  
  893. DROP TABLE IF EXISTS `RATING`;
  894. /*!40101 SET @saved_cs_client = @@character_set_client */;
  895. /*!40101 SET character_set_client = utf8 */;
  896. CREATE 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.  
  914. LOCK TABLES `RATING` WRITE;
  915. /*!40000 ALTER TABLE `RATING` DISABLE KEYS */;
  916. INSERT 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 */;
  918. UNLOCK TABLES;
  919.  
  920. --
  921. -- Table structure for table `SHOPPING_LIST`
  922. --
  923.  
  924. DROP TABLE IF EXISTS `SHOPPING_LIST`;
  925. /*!40101 SET @saved_cs_client = @@character_set_client */;
  926. /*!40101 SET character_set_client = utf8 */;
  927. CREATE 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.  
  946. LOCK TABLES `SHOPPING_LIST` WRITE;
  947. /*!40000 ALTER TABLE `SHOPPING_LIST` DISABLE KEYS */;
  948. INSERT 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 */;
  950. UNLOCK TABLES;
  951.  
  952. --
  953. -- Table structure for table `SIGN_RECORD`
  954. --
  955.  
  956. DROP TABLE IF EXISTS `SIGN_RECORD`;
  957. /*!40101 SET @saved_cs_client = @@character_set_client */;
  958. /*!40101 SET character_set_client = utf8 */;
  959. CREATE 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.  
  973. LOCK TABLES `SIGN_RECORD` WRITE;
  974. /*!40000 ALTER TABLE `SIGN_RECORD` DISABLE KEYS */;
  975. INSERT 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 */;
  977. UNLOCK TABLES;
  978.  
  979. --
  980. -- Table structure for table `SLIDER`
  981. --
  982.  
  983. DROP TABLE IF EXISTS `SLIDER`;
  984. /*!40101 SET @saved_cs_client = @@character_set_client */;
  985. /*!40101 SET character_set_client = utf8 */;
  986. CREATE 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.  
  1003. LOCK TABLES `SLIDER` WRITE;
  1004. /*!40000 ALTER TABLE `SLIDER` DISABLE KEYS */;
  1005. INSERT 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 */;
  1007. UNLOCK TABLES;
  1008.  
  1009. --
  1010. -- Table structure for table `SNAPPY_EXHIBITION`
  1011. --
  1012.  
  1013. DROP TABLE IF EXISTS `SNAPPY_EXHIBITION`;
  1014. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1015. /*!40101 SET character_set_client = utf8 */;
  1016. CREATE 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.  
  1043. LOCK TABLES `SNAPPY_EXHIBITION` WRITE;
  1044. /*!40000 ALTER TABLE `SNAPPY_EXHIBITION` DISABLE KEYS */;
  1045. /*!40000 ALTER TABLE `SNAPPY_EXHIBITION` ENABLE KEYS */;
  1046. UNLOCK TABLES;
  1047.  
  1048. --
  1049. -- Table structure for table `SNAPPY_PRODUCT`
  1050. --
  1051.  
  1052. DROP TABLE IF EXISTS `SNAPPY_PRODUCT`;
  1053. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1054. /*!40101 SET character_set_client = utf8 */;
  1055. CREATE 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.  
  1092. LOCK TABLES `SNAPPY_PRODUCT` WRITE;
  1093. /*!40000 ALTER TABLE `SNAPPY_PRODUCT` DISABLE KEYS */;
  1094. INSERT 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 */;
  1096. UNLOCK TABLES;
  1097.  
  1098. --
  1099. -- Table structure for table `SNAPPY_PRODUCT_PACKAGE`
  1100. --
  1101.  
  1102. DROP TABLE IF EXISTS `SNAPPY_PRODUCT_PACKAGE`;
  1103. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1104. /*!40101 SET character_set_client = utf8 */;
  1105. CREATE 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.  
  1123. LOCK TABLES `SNAPPY_PRODUCT_PACKAGE` WRITE;
  1124. /*!40000 ALTER TABLE `SNAPPY_PRODUCT_PACKAGE` DISABLE KEYS */;
  1125. INSERT 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 */;
  1127. UNLOCK TABLES;
  1128.  
  1129. --
  1130. -- Table structure for table `SNAPPY_PRODUCT_STYLE`
  1131. --
  1132.  
  1133. DROP TABLE IF EXISTS `SNAPPY_PRODUCT_STYLE`;
  1134. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1135. /*!40101 SET character_set_client = utf8 */;
  1136. CREATE 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.  
  1159. LOCK TABLES `SNAPPY_PRODUCT_STYLE` WRITE;
  1160. /*!40000 ALTER TABLE `SNAPPY_PRODUCT_STYLE` DISABLE KEYS */;
  1161. INSERT 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 */;
  1163. UNLOCK TABLES;
  1164.  
  1165. --
  1166. -- Table structure for table `SNAPPY_RECIPES`
  1167. --
  1168.  
  1169. DROP TABLE IF EXISTS `SNAPPY_RECIPES`;
  1170. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1171. /*!40101 SET character_set_client = utf8 */;
  1172. CREATE 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.  
  1189. LOCK TABLES `SNAPPY_RECIPES` WRITE;
  1190. /*!40000 ALTER TABLE `SNAPPY_RECIPES` DISABLE KEYS */;
  1191. /*!40000 ALTER TABLE `SNAPPY_RECIPES` ENABLE KEYS */;
  1192. UNLOCK TABLES;
  1193.  
  1194. --
  1195. -- Table structure for table `SNAPPY_SHOPPING_LIST`
  1196. --
  1197.  
  1198. DROP TABLE IF EXISTS `SNAPPY_SHOPPING_LIST`;
  1199. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1200. /*!40101 SET character_set_client = utf8 */;
  1201. CREATE 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.  
  1220. LOCK TABLES `SNAPPY_SHOPPING_LIST` WRITE;
  1221. /*!40000 ALTER TABLE `SNAPPY_SHOPPING_LIST` DISABLE KEYS */;
  1222. INSERT 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 */;
  1224. UNLOCK TABLES;
  1225.  
  1226. --
  1227. -- Table structure for table `STORE_SETTING`
  1228. --
  1229.  
  1230. DROP TABLE IF EXISTS `STORE_SETTING`;
  1231. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1232. /*!40101 SET character_set_client = utf8 */;
  1233. CREATE 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.  
  1290. LOCK TABLES `STORE_SETTING` WRITE;
  1291. /*!40000 ALTER TABLE `STORE_SETTING` DISABLE KEYS */;
  1292. INSERT 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 */;
  1294. UNLOCK TABLES;
  1295.  
  1296. --
  1297. -- Table structure for table `WEBEDITOR`
  1298. --
  1299.  
  1300. DROP TABLE IF EXISTS `WEBEDITOR`;
  1301. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1302. /*!40101 SET character_set_client = utf8 */;
  1303. CREATE 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.  
  1321. LOCK TABLES `WEBEDITOR` WRITE;
  1322. /*!40000 ALTER TABLE `WEBEDITOR` DISABLE KEYS */;
  1323. INSERT 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 */;
  1325. UNLOCK TABLES;
  1326.  
  1327. --
  1328. -- Table structure for table `WORK_TEAM`
  1329. --
  1330.  
  1331. DROP TABLE IF EXISTS `WORK_TEAM`;
  1332. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1333. /*!40101 SET character_set_client = utf8 */;
  1334. CREATE 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.  
  1355. LOCK TABLES `WORK_TEAM` WRITE;
  1356. /*!40000 ALTER TABLE `WORK_TEAM` DISABLE KEYS */;
  1357. /*!40000 ALTER TABLE `WORK_TEAM` ENABLE KEYS */;
  1358. UNLOCK 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!