홈 탐색 도움말
가입하기 로그인
liangc
/
shaozhangmenBack
1
0
포크 0
파일 이슈 0 풀 리퀘스트 0 위키
트리: e2a9957ccb
브랜치 태그
shaozhangmenBac...
/
container
/
sendApi
/
doc
/
jpa_demo.sql

jpa_demo.sql 33 KB
히스토리 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323 
  1. /*
    2. 

  2. Navicat MySQL Data Transfer
    3. 

  3. 

  4. Source Server         : localhostDB
    5. 

  5. Source Server Version : 50527
    6. 

  6. Source Host           : 127.0.0.1:3306
    7. 

  7. Source Database       : jpa_demo
    8. 

  8. 

  9. Target Server Type    : MYSQL
    10. 

  10. Target Server Version : 50527
    11. 

  11. File Encoding         : 65001
    12. 

  12. 

  13. Date: 2016-01-27 23:53:30
    14. 

  14. */
    15. 

  15. 

  16. SET FOREIGN_KEY_CHECKS=0;
    17. 

  17. 

  18. -- ----------------------------
    19. 

  19. -- Table structure for image
    20. 

  20. -- ----------------------------
    21. 

  21. DROP TABLE IF EXISTS `image`;
    22. 

  22. CREATE TABLE `image` (
    23. 

  23.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '图片编号',
    24. 

  24.   `path` varchar(500) NOT NULL DEFAULT '' COMMENT '图片路径',
    25. 

  25.   `thumbs` varchar(500) DEFAULT NULL COMMENT '图片尺寸数据',
    26. 

  26.   `attribute` varchar(50) DEFAULT NULL,
    27. 

  27.   `create_date` datetime NOT NULL COMMENT '创建时间',
    28. 

  28.   PRIMARY KEY (`id`)
    29. 

  29. ) ENGINE=InnoDB AUTO_INCREMENT=1569 DEFAULT CHARSET=utf8 COMMENT='图片表';
    30. 

  30. 

  31. -- ----------------------------
    32. 

  32. -- Records of image
    33. 

  33. -- ----------------------------
    34. 

  34. INSERT INTO `image` VALUES ('1429', 'images/2015/8/1439539842204.jpg', '{\"480x800\":\"images/2015/8/1439539842204_480x800.jpg\"}', '{\"width\":720,\"height\":1280}', '2015-08-14 16:10:43');
    35. 

  35. INSERT INTO `image` VALUES ('1430', 'images/2015/8/1439540354318.jpg', '{\"480x800\":\"images/2015/8/1439540354318_480x800.jpg\"}', '{\"width\":720,\"height\":1280}', '2015-08-14 16:19:15');
    36. 

  36. INSERT INTO `image` VALUES ('1431', 'images/2015/8/1439540892175.jpg', '{\"480x800\":\"images/2015/8/1439540892175_480x800.jpg\"}', '{\"width\":720,\"height\":1280}', '2015-08-14 16:28:13');
    37. 

  37. INSERT INTO `image` VALUES ('1432', 'images/2015/8/1439541595477.jpg', '{\"480x800\":\"images/2015/8/1439541595477_480x800.jpg\"}', '{\"width\":720,\"height\":1280}', '2015-08-14 16:39:56');
    38. 

  38. INSERT INTO `image` VALUES ('1433', 'images/2015/8/1439541917875.jpg', '{\"480x800\":\"images/2015/8/1439541917875_480x800.jpg\"}', '{\"width\":720,\"height\":1280}', '2015-08-14 16:45:18');
    39. 

  39. INSERT INTO `image` VALUES ('1434', 'images/2015/8/1439542460075.jpg', '{\"480x800\":\"images/2015/8/1439542460075_480x800.jpg\"}', '{\"width\":720,\"height\":1280}', '2015-08-14 16:54:20');
    40. 

  40. INSERT INTO `image` VALUES ('1435', 'images/2015/8/1439543512619.jpg', '{\"480x800\":\"images/2015/8/1439543512619_480x800.jpg\"}', '{\"width\":720,\"height\":1280}', '2015-08-14 17:11:53');
    41. 

  41. INSERT INTO `image` VALUES ('1436', 'images/2015/8/1439892293554_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-18 18:04:55');
    42. 

  42. INSERT INTO `image` VALUES ('1437', 'images/2015/8/1439892294903_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-18 18:04:55');
    43. 

  43. INSERT INTO `image` VALUES ('1438', 'images/2015/8/1440055637049_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 15:27:19');
    44. 

  44. INSERT INTO `image` VALUES ('1439', 'images/2015/8/1440055638694_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 15:27:19');
    45. 

  45. INSERT INTO `image` VALUES ('1440', 'images/2015/8/1440063341756_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:35:42');
    46. 

  46. INSERT INTO `image` VALUES ('1441', 'images/2015/8/1440063342931_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:35:43');
    47. 

  47. INSERT INTO `image` VALUES ('1442', 'images/2015/8/1440063473864_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:37:54');
    48. 

  48. INSERT INTO `image` VALUES ('1443', 'images/2015/8/1440063474081_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:37:54');
    49. 

  49. INSERT INTO `image` VALUES ('1444', 'images/2015/8/1440064463111_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:54:24');
    50. 

  50. INSERT INTO `image` VALUES ('1445', 'images/2015/8/1440064464060_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:54:24');
    51. 

  51. INSERT INTO `image` VALUES ('1446', 'images/2015/8/1440064603899_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:56:44');
    52. 

  52. INSERT INTO `image` VALUES ('1447', 'images/2015/8/1440064604111_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:56:44');
    53. 

  53. INSERT INTO `image` VALUES ('1448', 'images/2015/8/1440123376689_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:16:19');
    54. 

  54. INSERT INTO `image` VALUES ('1449', 'images/2015/8/1440123723791_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:22:04');
    55. 

  55. INSERT INTO `image` VALUES ('1450', 'images/2015/8/1440125622928_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:53:43');
    56. 

  56. INSERT INTO `image` VALUES ('1451', 'images/2015/8/1440125623220_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:53:44');
    57. 

  57. INSERT INTO `image` VALUES ('1452', 'images/2015/8/1440125790664_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:56:31');
    58. 

  58. INSERT INTO `image` VALUES ('1453', 'images/2015/8/1440125824783_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:57:05');
    59. 

  59. INSERT INTO `image` VALUES ('1454', 'images/2015/8/1440125825118_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:57:05');
    60. 

  60. INSERT INTO `image` VALUES ('1455', 'images/2015/8/1440125998851_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:59:59');
    61. 

  61. INSERT INTO `image` VALUES ('1456', 'images/2015/8/1440126560118_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:09:21');
    62. 

  62. INSERT INTO `image` VALUES ('1457', 'images/2015/8/1440126560617_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:09:21');
    63. 

  63. INSERT INTO `image` VALUES ('1458', 'images/2015/8/1440126590016_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:09:50');
    64. 

  64. INSERT INTO `image` VALUES ('1459', 'images/2015/8/1440127054717_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:17:36');
    65. 

  65. INSERT INTO `image` VALUES ('1460', 'images/2015/8/1440127145729_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:19:06');
    66. 

  66. INSERT INTO `image` VALUES ('1461', 'images/2015/8/1440127787160_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:29:49');
    67. 

  67. INSERT INTO `image` VALUES ('1462', 'images/2015/8/1440127788742_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:29:49');
    68. 

  68. INSERT INTO `image` VALUES ('1463', 'images/2015/8/1440127831648_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:30:32');
    69. 

  69. INSERT INTO `image` VALUES ('1464', 'images/2015/8/1440127832107_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:30:32');
    70. 

  70. INSERT INTO `image` VALUES ('1465', 'images/2015/8/1440128508270_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:41:49');
    71. 

  71. INSERT INTO `image` VALUES ('1466', 'images/2015/8/1440128508980_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:41:49');
    72. 

  72. INSERT INTO `image` VALUES ('1467', 'images/2015/8/1440128940700_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:49:01');
    73. 

  73. INSERT INTO `image` VALUES ('1468', 'images/2015/8/1440128941208_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:49:02');
    74. 

  74. INSERT INTO `image` VALUES ('1469', 'images/2015/8/1440129065518_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:51:06');
    75. 

  75. INSERT INTO `image` VALUES ('1470', 'images/2015/8/1440129065852_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:51:06');
    76. 

  76. INSERT INTO `image` VALUES ('1471', 'images/2015/8/1440129126005_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:52:06');
    77. 

  77. INSERT INTO `image` VALUES ('1472', 'images/2015/8/1440129131949_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:52:12');
    78. 

  78. INSERT INTO `image` VALUES ('1473', 'images/2015/8/1440129209894_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:53:30');
    79. 

  79. INSERT INTO `image` VALUES ('1474', 'images/2015/8/1440129217424_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:53:38');
    80. 

  80. INSERT INTO `image` VALUES ('1475', 'images/2015/8/1440129587232_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:59:48');
    81. 

  81. INSERT INTO `image` VALUES ('1476', 'images/2015/8/1440129587626_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:59:48');
    82. 

  82. INSERT INTO `image` VALUES ('1477', 'images/2015/8/1440129629126_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:00:29');
    83. 

  83. INSERT INTO `image` VALUES ('1478', 'images/2015/8/1440129629456_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:00:30');
    84. 

  84. INSERT INTO `image` VALUES ('1479', 'images/2015/8/1440129674734_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:01:15');
    85. 

  85. INSERT INTO `image` VALUES ('1480', 'images/2015/8/1440129675062_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:01:15');
    86. 

  86. INSERT INTO `image` VALUES ('1481', 'images/2015/8/1440129760155_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:02:40');
    87. 

  87. INSERT INTO `image` VALUES ('1482', 'images/2015/8/1440137019048_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:03:40');
    88. 

  88. INSERT INTO `image` VALUES ('1483', 'images/2015/8/1440137065621_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:04:26');
    89. 

  89. INSERT INTO `image` VALUES ('1484', 'images/2015/8/1440137142401_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:05:43');
    90. 

  90. INSERT INTO `image` VALUES ('1485', 'images/2015/8/1440137142623_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:05:43');
    91. 

  91. INSERT INTO `image` VALUES ('1486', 'images/2015/8/1440137283568_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:08:04');
    92. 

  92. INSERT INTO `image` VALUES ('1487', 'images/2015/8/1440138018439_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:20:19');
    93. 

  93. INSERT INTO `image` VALUES ('1488', 'images/2015/8/1440138019399_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:20:20');
    94. 

  94. INSERT INTO `image` VALUES ('1489', 'images/2015/8/1440138067885_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:08');
    95. 

  95. INSERT INTO `image` VALUES ('1490', 'images/2015/8/1440138068119_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:08');
    96. 

  96. INSERT INTO `image` VALUES ('1491', 'images/2015/8/1440138068307_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:09');
    97. 

  97. INSERT INTO `image` VALUES ('1492', 'images/2015/8/1440138068549_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:09');
    98. 

  98. INSERT INTO `image` VALUES ('1493', 'images/2015/8/1440138390255_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:26:30');
    99. 

  99. INSERT INTO `image` VALUES ('1494', 'images/2015/8/1440138871877_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:34:33');
    100. 

  100. INSERT INTO `image` VALUES ('1496', 'images/2015/8/1440485482782.jpg', null, '{\"width\":662,\"height\":580}', '2015-08-25 14:51:23');
    101. 

  101. INSERT INTO `image` VALUES ('1497', 'images/2015/8/1440485483479_compact.jpg', null, '{\"width\":1280,\"height\":960}', '2015-08-25 14:51:25');
    102. 

  102. INSERT INTO `image` VALUES ('1498', 'images/2015/9/1441178293489.jpg', '{\"480x800\":\"images/2015/9/1441178293489_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 15:18:15');
    103. 

  103. INSERT INTO `image` VALUES ('1499', 'images/2015/9/1441178545034.jpg', '{\"480x800\":\"images/2015/9/1441178545034_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 15:22:25');
    104. 

  104. INSERT INTO `image` VALUES ('1500', 'images/2015/9/1441180928635.jpg', '{\"480x800\":\"images/2015/9/1441180928635_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 16:02:09');
    105. 

  105. INSERT INTO `image` VALUES ('1501', 'images/2015/9/1441180992528.jpg', '{\"480x800\":\"images/2015/9/1441180992528_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 16:03:13');
    106. 

  106. INSERT INTO `image` VALUES ('1502', 'images/2015/9/1441181518449.jpg', '{\"480x800\":\"images/2015/9/1441181518449_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 16:11:59');
    107. 

  107. INSERT INTO `image` VALUES ('1503', 'images/2015/9/1441181564642.jpg', '{\"480x800\":\"images/2015/9/1441181564642_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 16:12:45');
    108. 

  108. INSERT INTO `image` VALUES ('1504', 'images/2015/9/1441181709835.jpg', '{\"480x800\":\"images/2015/9/1441181709835_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 16:15:10');
    109. 

  109. INSERT INTO `image` VALUES ('1505', 'images/2015/9/1441181721775.jpg', '{\"480x800\":\"images/2015/9/1441181721775_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 16:15:22');
    110. 

  110. INSERT INTO `image` VALUES ('1506', 'images/2015/9/1441182062698.jpg', '{\"480x800\":\"images/2015/9/1441182062698_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-02 16:21:03');
    111. 

  111. INSERT INTO `image` VALUES ('1507', 'images/2015/9/1441619133161.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:34');
    112. 

  112. INSERT INTO `image` VALUES ('1508', 'images/2015/9/1441619133808.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:34');
    113. 

  113. INSERT INTO `image` VALUES ('1509', 'images/2015/9/1441619133876_compact.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:35');
    114. 

  114. INSERT INTO `image` VALUES ('1510', 'images/2015/9/1441619135232.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:35');
    115. 

  115. INSERT INTO `image` VALUES ('1511', 'images/2015/9/1441704373551.jpg', '{\"480x800\":\"images/2015/9/1441704373551_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-08 17:26:15');
    116. 

  116. INSERT INTO `image` VALUES ('1512', 'images/2015/9/1441704639067.jpg', '{\"480x800\":\"images/2015/9/1441704639067_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-08 17:30:40');
    117. 

  117. INSERT INTO `image` VALUES ('1513', 'images/2015/9/1441704650710.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-08 17:30:51');
    118. 

  118. INSERT INTO `image` VALUES ('1514', 'images/2015/9/1441704650793.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-08 17:30:51');
    119. 

  119. INSERT INTO `image` VALUES ('1515', 'images/2015/9/1441704650909.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-08 17:30:51');
    120. 

  120. INSERT INTO `image` VALUES ('1516', 'images/2015/9/1441793927994.jpg', '{\"480x800\":\"images/2015/9/1441793927994_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-09 18:18:49');
    121. 

  121. INSERT INTO `image` VALUES ('1517', 'images/2015/9/1441794295331.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:24:56');
    122. 

  122. INSERT INTO `image` VALUES ('1518', 'images/2015/9/1441794295586.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:24:56');
    123. 

  123. INSERT INTO `image` VALUES ('1519', 'images/2015/9/1441794524988.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:28:45');
    124. 

  124. INSERT INTO `image` VALUES ('1520', 'images/2015/9/1441794525051_compact.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:28:46');
    125. 

  125. INSERT INTO `image` VALUES ('1521', 'images/2015/9/1441794635597.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:30:36');
    126. 

  126. INSERT INTO `image` VALUES ('1522', 'images/2015/9/1441794635896.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:30:36');
    127. 

  127. INSERT INTO `image` VALUES ('1523', 'images/2015/9/1441794666920.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:07');
    128. 

  128. INSERT INTO `image` VALUES ('1524', 'images/2015/9/1441794666990.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:07');
    129. 

  129. INSERT INTO `image` VALUES ('1525', 'images/2015/9/1441794717168.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:57');
    130. 

  130. INSERT INTO `image` VALUES ('1526', 'images/2015/9/1441794717262.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:57');
    131. 

  131. INSERT INTO `image` VALUES ('1527', 'images/2015/9/1441794775875.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:32:56');
    132. 

  132. INSERT INTO `image` VALUES ('1528', 'images/2015/9/1441794775929.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:32:56');
    133. 

  133. INSERT INTO `image` VALUES ('1530', 'images/2015/9/1441794808419.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:33:28');
    134. 

  134. INSERT INTO `image` VALUES ('1531', 'images/2015/9/1441794917152.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:35:17');
    135. 

  135. INSERT INTO `image` VALUES ('1532', 'images/2015/9/1441794917218.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:35:17');
    136. 

  136. INSERT INTO `image` VALUES ('1533', 'images/2015/9/1441794929352.jpg', '{\"480x800\":\"images/2015/9/1441794929352_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-09 18:35:30');
    137. 

  137. INSERT INTO `image` VALUES ('1534', 'images/2015/9/1441794936533.jpg', '{\"480x800\":\"images/2015/9/1441794936533_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-09 18:35:37');
    138. 

  138. INSERT INTO `image` VALUES ('1535', 'images/2015/9/1441795053695.jpg', '{\"480x800\":\"images/2015/9/1441795053695_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-09 18:37:34');
    139. 

  139. INSERT INTO `image` VALUES ('1536', 'images/2015/9/1441795066134.jpg', '{\"480x800\":\"images/2015/9/1441795066134_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-09 18:37:46');
    140. 

  140. INSERT INTO `image` VALUES ('1537', 'images/2015/9/1441874721770.jpg', '{\"480x800\":\"images/2015/9/1441874721770_480x800.jpg\"}', '{\"width\":146,\"height\":220}', '2015-09-10 16:45:22');
    141. 

  141. INSERT INTO `image` VALUES ('1538', 'images/2015/9/1441874744043.jpg', null, '{\"width\":146,\"height\":220}', '2015-09-10 16:45:44');
    142. 

  142. INSERT INTO `image` VALUES ('1539', 'images/2015/9/1441881931909.jpg', '{\"480x800\":\"images/2015/9/1441881931909_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-10 18:45:33');
    143. 

  143. INSERT INTO `image` VALUES ('1540', 'images/2015/9/1441881966534.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:46:07');
    144. 

  144. INSERT INTO `image` VALUES ('1541', 'images/2015/9/1441881966677.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:46:07');
    145. 

  145. INSERT INTO `image` VALUES ('1542', 'images/2015/9/1441882106769.jpg', '{\"480x800\":\"images/2015/9/1441882106769_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-10 18:48:27');
    146. 

  146. INSERT INTO `image` VALUES ('1543', 'images/2015/9/1441882118682.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:48:39');
    147. 

  147. INSERT INTO `image` VALUES ('1544', 'images/2015/9/1441882118766.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:48:39');
    148. 

  148. INSERT INTO `image` VALUES ('1545', 'images/2015/9/1441882207373.jpg', '{\"480x800\":\"images/2015/9/1441882207373_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:08');
    149. 

  149. INSERT INTO `image` VALUES ('1546', 'images/2015/9/1441882222620.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:23');
    150. 

  150. INSERT INTO `image` VALUES ('1547', 'images/2015/9/1441882222716.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:23');
    151. 

  151. INSERT INTO `image` VALUES ('1548', 'images/2015/9/1441882245517.jpg', '{\"480x800\":\"images/2015/9/1441882245517_480x800.jpg\"}', '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:46');
    152. 

  152. INSERT INTO `image` VALUES ('1549', 'images/2015/9/1441882258385.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:58');
    153. 

  153. INSERT INTO `image` VALUES ('1550', 'images/2015/9/1441882258481.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:59');
    154. 

  154. INSERT INTO `image` VALUES ('1551', 'images/2015/9/1441882891687.jpg', '{\"480x800\":\"images/2015/9/1441882891687_480x800.jpg\"}', '{\"width\":303,\"height\":359}', '2015-09-10 19:01:32');
    155. 

  155. INSERT INTO `image` VALUES ('1552', 'images/2015/9/1441882937302.jpg', '{\"480x800\":\"images/2015/9/1441882937302_480x800.jpg\"}', '{\"width\":303,\"height\":359}', '2015-09-10 19:02:17');
    156. 

  156. INSERT INTO `image` VALUES ('1553', 'images/2015/9/1443518603848.jpg', '{\"480x800\":\"images/2015/9/1443518603848_480x800.jpg\"}', '{\"width\":750,\"height\":750}', '2015-09-29 17:23:25');
    157. 

  157. INSERT INTO `image` VALUES ('1554', 'images/2015/10/1444890919860.jpg', '{\"480x800\":\"images/2015/10/1444890919860_480x800.jpg\"}', '{\"width\":750,\"height\":750}', '2015-10-15 14:35:21');
    158. 

  158. INSERT INTO `image` VALUES ('1555', 'images/2015/10/1444890969009.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 14:36:09');
    159. 

  159. INSERT INTO `image` VALUES ('1556', 'images/2015/10/1444890969035.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 14:36:09');
    160. 

  160. INSERT INTO `image` VALUES ('1557', 'images/2015/10/1444890969066.jpg', null, '{\"width\":800,\"height\":800}', '2015-10-15 14:36:09');
    161. 

  161. INSERT INTO `image` VALUES ('1558', 'images/2015/10/1444892662823.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 15:04:23');
    162. 

  162. INSERT INTO `image` VALUES ('1559', 'images/2015/10/1444892663114.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 15:04:23');
    163. 

  163. INSERT INTO `image` VALUES ('1560', 'images/2015/10/1444892663220.jpg', null, '{\"width\":800,\"height\":800}', '2015-10-15 15:04:23');
    164. 

  164. INSERT INTO `image` VALUES ('1561', 'images/2015/10/1444892667664.jpg', '{\"480x800\":\"images/2015/10/1444892667664_480x800.jpg\"}', '{\"width\":750,\"height\":750}', '2015-10-15 15:04:28');
    165. 

  165. INSERT INTO `image` VALUES ('1562', 'images/2015/10/1444892905223.jpg', '{\"480x800\":\"images/2015/10/1444892905223_480x800.jpg\"}', '{\"width\":750,\"height\":750}', '2015-10-15 15:08:25');
    166. 

  166. INSERT INTO `image` VALUES ('1563', 'images/2015/10/1444892931497.jpg', null, '{\"width\":350,\"height\":263}', '2015-10-15 15:08:52');
    167. 

  167. INSERT INTO `image` VALUES ('1564', 'images/2015/10/1444892931517.jpg', null, '{\"width\":266,\"height\":220}', '2015-10-15 15:08:52');
    168. 

  168. INSERT INTO `image` VALUES ('1565', 'images/2015/10/1444892931555.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 15:08:52');
    169. 

  169. INSERT INTO `image` VALUES ('1566', 'images/2015/10/1445224183382.jpg', null, '{\"width\":610,\"height\":699}', '2015-10-19 11:09:44');
    170. 

  170. INSERT INTO `image` VALUES ('1567', 'images/2015/10/1445224184482.jpg', null, '{\"width\":610,\"height\":638}', '2015-10-19 11:09:45');
    171. 

  171. INSERT INTO `image` VALUES ('1568', 'images/2015/10/1445224184592.jpg', null, '{\"width\":610,\"height\":594}', '2015-10-19 11:09:45');
    172. 

  172. 

  173. -- ----------------------------
    174. 

  174. -- Table structure for member
    175. 

  175. -- ----------------------------
    176. 

  176. DROP TABLE IF EXISTS `member`;
    177. 

  177. CREATE TABLE `member` (
    178. 

  178.   `id` int(11) NOT NULL AUTO_INCREMENT,
    179. 

  179.   `username` varchar(255) NOT NULL COMMENT '用户名',
    180. 

  180.   `password` varchar(255) DEFAULT NULL COMMENT '密码',
    181. 

  181.   `type` varchar(255) NOT NULL COMMENT '类型(globle总后台，business商家后台)',
    182. 

  182.   `create_date` datetime NOT NULL COMMENT '创建时间',
    183. 

  183.   `update_date` datetime DEFAULT NULL,
    184. 

  184.   PRIMARY KEY (`id`),
    185. 

  185.   KEY `username` (`username`)
    186. 

  186. ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
    187. 

  187. 

  188. -- ----------------------------
    189. 

  189. -- Records of member
    190. 

  190. -- ----------------------------
    191. 

  191. INSERT INTO `member` VALUES ('1', 'admin', 'E10ADC3949BA59ABBE56E057F20F883E', 'GLOBLE', '2015-08-11 10:11:43', '2015-08-11 10:11:45');
    192. 

  192. INSERT INTO `member` VALUES ('4', 'wangbin', 'C33367701511B4F6020EC61DED352059', 'BUSINESS', '2015-08-12 10:14:13', '2015-08-12 10:14:13');
    193. 

  193. INSERT INTO `member` VALUES ('5', 'wangbin1', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:40:50', '2015-09-10 18:40:50');
    194. 

  194. INSERT INTO `member` VALUES ('6', 'wangbin2', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:43:38', '2015-09-10 18:43:38');
    195. 

  195. INSERT INTO `member` VALUES ('7', 'wangbin3', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:43:46', '2015-09-10 18:43:46');
    196. 

  196. INSERT INTO `member` VALUES ('8', 'wangbin4', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:43:55', '2015-09-10 18:43:55');
    197. 

  197. INSERT INTO `member` VALUES ('9', 'wangbin7', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-13 17:26:42', '2015-09-13 17:26:42');
    198. 

  198. INSERT INTO `member` VALUES ('13', 'wangb', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-14 14:23:11', '2015-10-14 14:23:11');
    199. 

  199. INSERT INTO `member` VALUES ('16', 'wangb', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 10:04:43', '2015-10-15 10:04:43');
    200. 

  200. INSERT INTO `member` VALUES ('17', 'wangb1', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 10:04:43', '2015-10-15 10:04:43');
    201. 

  201. INSERT INTO `member` VALUES ('18', 'wangb2', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 10:04:43', '2015-10-15 10:04:43');
    202. 

  202. INSERT INTO `member` VALUES ('19', 'wangb', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 14:14:40', '2015-10-15 14:14:40');
    203. 

  203. INSERT INTO `member` VALUES ('20', 'wangb1', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 14:14:41', '2015-10-15 14:14:41');
    204. 

  204. INSERT INTO `member` VALUES ('21', 'wangb2', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 14:14:41', '2015-10-15 14:14:41');
    205. 

  205. 

  206. -- ----------------------------
    207. 

  207. -- Table structure for product
    208. 

  208. -- ----------------------------
    209. 

  209. DROP TABLE IF EXISTS `product`;
    210. 

  210. CREATE TABLE `product` (
    211. 

  211.   `id` int(11) NOT NULL AUTO_INCREMENT,
    212. 

  212.   `code` varchar(255) DEFAULT NULL COMMENT '商品编码',
    213. 

  213.   `name` varchar(255) DEFAULT NULL COMMENT '商品名称',
    214. 

  214.   `image_id` int(11) DEFAULT NULL,
    215. 

  215.   `market_price` decimal(10,2) DEFAULT NULL COMMENT '商品价格',
    216. 

  216.   `price` decimal(10,2) DEFAULT NULL,
    217. 

  217.   `content` varchar(5000) DEFAULT NULL COMMENT '商品描述',
    218. 

  218.   `brand` varchar(255) DEFAULT NULL COMMENT '品牌',
    219. 

  219.   `is_added` bit(1) DEFAULT b'0',
    220. 

  220.   `product_area_id` int(11) DEFAULT NULL,
    221. 

  221.   `product_type_id` int(11) DEFAULT NULL,
    222. 

  222.   `sales_count` int(11) DEFAULT '0',
    223. 

  223.   `collect_count` int(11) DEFAULT '0',
    224. 

  224.   `sort` int(11) DEFAULT '0' COMMENT '排序',
    225. 

  225.   `create_date` datetime DEFAULT NULL,
    226. 

  226.   `update_date` datetime DEFAULT NULL,
    227. 

  227.   PRIMARY KEY (`id`),
    228. 

  228.   UNIQUE KEY `code` (`code`),
    229. 

  229.   KEY `product_area_id` (`product_area_id`),
    230. 

  230.   KEY `product_type_id` (`product_type_id`),
    231. 

  231.   KEY `image_id` (`image_id`),
    232. 

  232.   CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_area_id`) REFERENCES `product_area` (`id`),
    233. 

  233.   CONSTRAINT `product_ibfk_2` FOREIGN KEY (`product_type_id`) REFERENCES `product_type` (`id`),
    234. 

  234.   CONSTRAINT `product_ibfk_3` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`)
    235. 

  235. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
    236. 

  236. 

  237. -- ----------------------------
    238. 

  238. -- Records of product
    239. 

  239. -- ----------------------------
    240. 

  240. INSERT INTO `product` VALUES ('3', '2', '拉拉干红', '1553', '600.00', '100.00', '&ltp&gt啦啦啦简介啦啦啦简介啦啦啦简介啦啦啦简介啦啦啦简介&ltimg src=\"/files/upload/image/ueditor/20151014/1444819706841096505.jpg\" title=\"1444819706841096505.jpg\" alt=\"2522840_19_b.jpg\"/&gt&ltimg src=\"/files/upload/image/ueditor/20151014/1444819709957005643.jpg\" title=\"1444819709957005643.jpg\" alt=\"55cb1513N80969b2b.jpg!q80.jpg\"/&gt&lt/p&gt', '拉拉', '', '1', '2', null, null, null, null, '2015-09-07 16:08:35');
    241. 

  241. INSERT INTO `product` VALUES ('4', '1', '拉萨酒', '1512', '65.00', '120.00', '短短的', '啦啦啦', '', '3', '2', null, null, null, null, '2015-08-21 14:49:56');
    242. 

  242. INSERT INTO `product` VALUES ('5', 'fff', 'sdasd', '1512', '660.00', '150.00', '<p><img src=\"/winetast/ueditor/jsp/upload/image/20150825/1440486664657044091.jpg\" title=\"1440486664657044091.jpg\" alt=\"1423041680935.jpg\"/></p><p><br/></p><p>我我我</p>', 'asdasd', '', '1', '2', null, null, null, '2015-08-25 14:51:25', '2015-09-07 17:05:40');
    243. 

  243. INSERT INTO `product` VALUES ('6', 's66541', '拉拉干红', '1512', '60.00', '230.00', '&ltp&gt&ltbr/&gt&lt/p&gt&ltp&gt&ltimg src=\"/winetast/ueditor/jsp/upload/image/20151014/1444815067344025784.jpg\" title=\"1444815067344025784.jpg\" alt=\"548675ffNaef78887.jpg!q80.jpg\"/&gt&lt/p&gt', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    244. 

  244. INSERT INTO `product` VALUES ('7', 's665412', '拉拉干红', '1512', '60.00', '250.00', '&ltp&gt点点滴滴&ltbr/&gt&lt/p&gt', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    245. 

  245. INSERT INTO `product` VALUES ('8', 's665413', '拉拉干红', '1512', '60.00', '300.00', '&ltp&gt点点滴滴&ltbr/&gt&lt/p&gt', '拉菲', '', '1', '3', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    246. 

  246. INSERT INTO `product` VALUES ('9', 's665414', '拉拉干红', '1512', '60.00', '400.00', '&ltp&gt点点滴滴&ltbr/&gt&lt/p&gt', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    247. 

  247. INSERT INTO `product` VALUES ('10', 's665415', '拉拉干红', '1512', '60.00', '450.00', '&ltp&gt点点滴滴&ltbr/&gt&lt/p&gt', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    248. 

  248. INSERT INTO `product` VALUES ('11', 's665416', '拉拉干红', '1512', '60.00', '101.00', '&ltp&gt点点滴滴&ltbr/&gt&lt/p&gt', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    249. 

  249. INSERT INTO `product` VALUES ('12', 's665417', '拉拉干红', '1511', '60.00', '500.00', '&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224156789088193.jpg\" style=\"\" title=\"1445224156789088193.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224156805055637.jpg\" style=\"\" title=\"1445224156805055637.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224156835067970.jpg\" style=\"\" title=\"1445224156835067970.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224156860040988.jpg\" style=\"\" title=\"1445224156860040988.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224156878092547.jpg\" style=\"\" title=\"1445224156878092547.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224157013014528.jpg\" style=\"\" title=\"1445224157013014528.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224157046074903.jpg\" style=\"\" title=\"1445224157046074903.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224157062028350.jpg\" style=\"\" title=\"1445224157062028350.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224157079018025.jpg\" style=\"\" title=\"1445224157079018025.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224157139042714.jpg\" style=\"\" title=\"1445224157139042714.jpg\"/&gt&lt/p&gt&ltp&gt&ltimg src=\"/files/upload/image/ueditor/20151019/1445224157147002906.jpg\" style=\"\" title=\"1445224157147002906.jpg\"/&gt&lt/p&gt&ltp&gt&ltbr/&gt&lt/p&gt', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    250. 

  250. INSERT INTO `product` VALUES ('13', 's665418', '拉拉干红', '1513', '60.00', '700.00', '&ltp&gt点点滴滴&ltbr/&gt&lt/p&gt', '拉菲', '\0', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47');
    251. 

  251. 

  252. -- ----------------------------
    253. 

  253. -- Table structure for product_area
    254. 

  254. -- ----------------------------
    255. 

  255. DROP TABLE IF EXISTS `product_area`;
    256. 

  256. CREATE TABLE `product_area` (
    257. 

  257.   `id` int(11) NOT NULL AUTO_INCREMENT,
    258. 

  258.   `name` varchar(255) DEFAULT NULL,
    259. 

  259.   `create_date` datetime NOT NULL,
    260. 

  260.   `update_date` datetime DEFAULT NULL,
    261. 

  261.   PRIMARY KEY (`id`)
    262. 

  262. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='产品产地';
    263. 

  263. 

  264. -- ----------------------------
    265. 

  265. -- Records of product_area
    266. 

  266. -- ----------------------------
    267. 

  267. INSERT INTO `product_area` VALUES ('1', '德国', '2015-08-20 11:58:12', '2015-08-20 15:20:43');
    268. 

  268. INSERT INTO `product_area` VALUES ('3', '法国', '2015-08-20 14:10:59', '2015-08-20 15:20:29');
    269. 

  269. 

  270. -- ----------------------------
    271. 

  271. -- Table structure for product_images
    272. 

  272. -- ----------------------------
    273. 

  273. DROP TABLE IF EXISTS `product_images`;
    274. 

  274. CREATE TABLE `product_images` (
    275. 

  275.   `id` int(11) NOT NULL AUTO_INCREMENT,
    276. 

  276.   `product_id` int(11) DEFAULT NULL,
    277. 

  277.   `image_id` int(11) DEFAULT NULL,
    278. 

  278.   PRIMARY KEY (`id`),
    279. 

  279.   KEY `product_id` (`product_id`),
    280. 

  280.   KEY `image_id` (`image_id`),
    281. 

  281.   CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`),
    282. 

  282.   CONSTRAINT `product_images_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`)
    283. 

  283. ) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;
    284. 

  284. 

  285. -- ----------------------------
    286. 

  286. -- Records of product_images
    287. 

  287. -- ----------------------------
    288. 

  288. INSERT INTO `product_images` VALUES ('48', '4', '1489');
    289. 

  289. INSERT INTO `product_images` VALUES ('49', '4', '1490');
    290. 

  290. INSERT INTO `product_images` VALUES ('50', '4', '1491');
    291. 

  291. INSERT INTO `product_images` VALUES ('51', '4', '1492');
    292. 

  292. INSERT INTO `product_images` VALUES ('53', '3', '1494');
    293. 

  293. INSERT INTO `product_images` VALUES ('55', '5', '1496');
    294. 

  294. INSERT INTO `product_images` VALUES ('56', '5', '1497');
    295. 

  295. INSERT INTO `product_images` VALUES ('57', '6', '1507');
    296. 

  296. INSERT INTO `product_images` VALUES ('58', '6', '1508');
    297. 

  297. INSERT INTO `product_images` VALUES ('59', '6', '1509');
    298. 

  298. INSERT INTO `product_images` VALUES ('60', '6', '1510');
    299. 

  299. INSERT INTO `product_images` VALUES ('67', '13', '1563');
    300. 

  300. INSERT INTO `product_images` VALUES ('68', '13', '1564');
    301. 

  301. INSERT INTO `product_images` VALUES ('69', '13', '1565');
    302. 

  302. INSERT INTO `product_images` VALUES ('70', '12', '1566');
    303. 

  303. INSERT INTO `product_images` VALUES ('71', '12', '1567');
    304. 

  304. INSERT INTO `product_images` VALUES ('72', '12', '1568');
    305. 

  305. 

  306. -- ----------------------------
    307. 

  307. -- Table structure for product_type
    308. 

  308. -- ----------------------------
    309. 

  309. DROP TABLE IF EXISTS `product_type`;
    310. 

  310. CREATE TABLE `product_type` (
    311. 

  311.   `id` int(11) NOT NULL AUTO_INCREMENT,
    312. 

  312.   `name` varchar(255) DEFAULT NULL COMMENT '商品类别',
    313. 

  313.   `create_date` datetime DEFAULT NULL,
    314. 

  314.   `update_date` datetime DEFAULT NULL,
    315. 

  315.   PRIMARY KEY (`id`)
    316. 

  316. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='产品类别';
    317. 

  317. 

  318. -- ----------------------------
    319. 

  319. -- Records of product_type
    320. 

  320. -- ----------------------------
    321. 

  321. INSERT INTO `product_type` VALUES ('2', '干红', '2015-08-20 14:29:41', '2015-08-20 15:21:04');
    322. 

  322. INSERT INTO `product_type` VALUES ('3', '葡萄酒', '2015-08-20 14:29:59', '2015-08-20 15:20:58');
    323. 

  323. INSERT INTO `product_type` VALUES ('4', 'll', '2016-01-27 23:51:30', '2016-01-27 23:51:36');
    324.