/* Navicat MySQL Data Transfer Source Server : localhostDB Source Server Version : 50527 Source Host : 127.0.0.1:3306 Source Database : jpa_demo Target Server Type : MYSQL Target Server Version : 50527 File Encoding : 65001 Date: 2016-01-27 23:53:30 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for image -- ---------------------------- DROP TABLE IF EXISTS `image`; CREATE TABLE `image` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '图片编号', `path` varchar(500) NOT NULL DEFAULT '' COMMENT '图片路径', `thumbs` varchar(500) DEFAULT NULL COMMENT '图片尺寸数据', `attribute` varchar(50) DEFAULT NULL, `create_date` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1569 DEFAULT CHARSET=utf8 COMMENT='图片表'; -- ---------------------------- -- Records of image -- ---------------------------- 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'); 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'); 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'); 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'); 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'); 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'); 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'); INSERT INTO `image` VALUES ('1436', 'images/2015/8/1439892293554_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-18 18:04:55'); INSERT INTO `image` VALUES ('1437', 'images/2015/8/1439892294903_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-18 18:04:55'); INSERT INTO `image` VALUES ('1438', 'images/2015/8/1440055637049_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 15:27:19'); INSERT INTO `image` VALUES ('1439', 'images/2015/8/1440055638694_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 15:27:19'); INSERT INTO `image` VALUES ('1440', 'images/2015/8/1440063341756_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:35:42'); INSERT INTO `image` VALUES ('1441', 'images/2015/8/1440063342931_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:35:43'); INSERT INTO `image` VALUES ('1442', 'images/2015/8/1440063473864_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:37:54'); INSERT INTO `image` VALUES ('1443', 'images/2015/8/1440063474081_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:37:54'); INSERT INTO `image` VALUES ('1444', 'images/2015/8/1440064463111_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:54:24'); INSERT INTO `image` VALUES ('1445', 'images/2015/8/1440064464060_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:54:24'); INSERT INTO `image` VALUES ('1446', 'images/2015/8/1440064603899_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:56:44'); INSERT INTO `image` VALUES ('1447', 'images/2015/8/1440064604111_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-20 17:56:44'); INSERT INTO `image` VALUES ('1448', 'images/2015/8/1440123376689_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:16:19'); INSERT INTO `image` VALUES ('1449', 'images/2015/8/1440123723791_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:22:04'); INSERT INTO `image` VALUES ('1450', 'images/2015/8/1440125622928_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:53:43'); INSERT INTO `image` VALUES ('1451', 'images/2015/8/1440125623220_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:53:44'); INSERT INTO `image` VALUES ('1452', 'images/2015/8/1440125790664_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:56:31'); INSERT INTO `image` VALUES ('1453', 'images/2015/8/1440125824783_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:57:05'); INSERT INTO `image` VALUES ('1454', 'images/2015/8/1440125825118_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:57:05'); INSERT INTO `image` VALUES ('1455', 'images/2015/8/1440125998851_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 10:59:59'); INSERT INTO `image` VALUES ('1456', 'images/2015/8/1440126560118_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:09:21'); INSERT INTO `image` VALUES ('1457', 'images/2015/8/1440126560617_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:09:21'); INSERT INTO `image` VALUES ('1458', 'images/2015/8/1440126590016_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:09:50'); INSERT INTO `image` VALUES ('1459', 'images/2015/8/1440127054717_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:17:36'); INSERT INTO `image` VALUES ('1460', 'images/2015/8/1440127145729_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:19:06'); INSERT INTO `image` VALUES ('1461', 'images/2015/8/1440127787160_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:29:49'); INSERT INTO `image` VALUES ('1462', 'images/2015/8/1440127788742_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:29:49'); INSERT INTO `image` VALUES ('1463', 'images/2015/8/1440127831648_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:30:32'); INSERT INTO `image` VALUES ('1464', 'images/2015/8/1440127832107_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:30:32'); INSERT INTO `image` VALUES ('1465', 'images/2015/8/1440128508270_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:41:49'); INSERT INTO `image` VALUES ('1466', 'images/2015/8/1440128508980_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:41:49'); INSERT INTO `image` VALUES ('1467', 'images/2015/8/1440128940700_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:49:01'); INSERT INTO `image` VALUES ('1468', 'images/2015/8/1440128941208_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:49:02'); INSERT INTO `image` VALUES ('1469', 'images/2015/8/1440129065518_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:51:06'); INSERT INTO `image` VALUES ('1470', 'images/2015/8/1440129065852_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:51:06'); INSERT INTO `image` VALUES ('1471', 'images/2015/8/1440129126005_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:52:06'); INSERT INTO `image` VALUES ('1472', 'images/2015/8/1440129131949_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:52:12'); INSERT INTO `image` VALUES ('1473', 'images/2015/8/1440129209894_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:53:30'); INSERT INTO `image` VALUES ('1474', 'images/2015/8/1440129217424_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:53:38'); INSERT INTO `image` VALUES ('1475', 'images/2015/8/1440129587232_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:59:48'); INSERT INTO `image` VALUES ('1476', 'images/2015/8/1440129587626_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 11:59:48'); INSERT INTO `image` VALUES ('1477', 'images/2015/8/1440129629126_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:00:29'); INSERT INTO `image` VALUES ('1478', 'images/2015/8/1440129629456_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:00:30'); INSERT INTO `image` VALUES ('1479', 'images/2015/8/1440129674734_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:01:15'); INSERT INTO `image` VALUES ('1480', 'images/2015/8/1440129675062_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:01:15'); INSERT INTO `image` VALUES ('1481', 'images/2015/8/1440129760155_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 12:02:40'); INSERT INTO `image` VALUES ('1482', 'images/2015/8/1440137019048_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:03:40'); INSERT INTO `image` VALUES ('1483', 'images/2015/8/1440137065621_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:04:26'); INSERT INTO `image` VALUES ('1484', 'images/2015/8/1440137142401_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:05:43'); INSERT INTO `image` VALUES ('1485', 'images/2015/8/1440137142623_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:05:43'); INSERT INTO `image` VALUES ('1486', 'images/2015/8/1440137283568_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:08:04'); INSERT INTO `image` VALUES ('1487', 'images/2015/8/1440138018439_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:20:19'); INSERT INTO `image` VALUES ('1488', 'images/2015/8/1440138019399_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:20:20'); INSERT INTO `image` VALUES ('1489', 'images/2015/8/1440138067885_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:08'); INSERT INTO `image` VALUES ('1490', 'images/2015/8/1440138068119_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:08'); INSERT INTO `image` VALUES ('1491', 'images/2015/8/1440138068307_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:09'); INSERT INTO `image` VALUES ('1492', 'images/2015/8/1440138068549_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:21:09'); INSERT INTO `image` VALUES ('1493', 'images/2015/8/1440138390255_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:26:30'); INSERT INTO `image` VALUES ('1494', 'images/2015/8/1440138871877_compact.jpg', null, '{\"width\":1024,\"height\":768}', '2015-08-21 14:34:33'); INSERT INTO `image` VALUES ('1496', 'images/2015/8/1440485482782.jpg', null, '{\"width\":662,\"height\":580}', '2015-08-25 14:51:23'); INSERT INTO `image` VALUES ('1497', 'images/2015/8/1440485483479_compact.jpg', null, '{\"width\":1280,\"height\":960}', '2015-08-25 14:51:25'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); INSERT INTO `image` VALUES ('1507', 'images/2015/9/1441619133161.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:34'); INSERT INTO `image` VALUES ('1508', 'images/2015/9/1441619133808.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:34'); INSERT INTO `image` VALUES ('1509', 'images/2015/9/1441619133876_compact.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:35'); INSERT INTO `image` VALUES ('1510', 'images/2015/9/1441619135232.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-07 17:45:35'); 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'); 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'); INSERT INTO `image` VALUES ('1513', 'images/2015/9/1441704650710.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-08 17:30:51'); INSERT INTO `image` VALUES ('1514', 'images/2015/9/1441704650793.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-08 17:30:51'); INSERT INTO `image` VALUES ('1515', 'images/2015/9/1441704650909.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-08 17:30:51'); 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'); INSERT INTO `image` VALUES ('1517', 'images/2015/9/1441794295331.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:24:56'); INSERT INTO `image` VALUES ('1518', 'images/2015/9/1441794295586.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:24:56'); INSERT INTO `image` VALUES ('1519', 'images/2015/9/1441794524988.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:28:45'); INSERT INTO `image` VALUES ('1520', 'images/2015/9/1441794525051_compact.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:28:46'); INSERT INTO `image` VALUES ('1521', 'images/2015/9/1441794635597.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:30:36'); INSERT INTO `image` VALUES ('1522', 'images/2015/9/1441794635896.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:30:36'); INSERT INTO `image` VALUES ('1523', 'images/2015/9/1441794666920.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:07'); INSERT INTO `image` VALUES ('1524', 'images/2015/9/1441794666990.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:07'); INSERT INTO `image` VALUES ('1525', 'images/2015/9/1441794717168.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:57'); INSERT INTO `image` VALUES ('1526', 'images/2015/9/1441794717262.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:31:57'); INSERT INTO `image` VALUES ('1527', 'images/2015/9/1441794775875.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:32:56'); INSERT INTO `image` VALUES ('1528', 'images/2015/9/1441794775929.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:32:56'); INSERT INTO `image` VALUES ('1530', 'images/2015/9/1441794808419.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:33:28'); INSERT INTO `image` VALUES ('1531', 'images/2015/9/1441794917152.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:35:17'); INSERT INTO `image` VALUES ('1532', 'images/2015/9/1441794917218.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-09 18:35:17'); 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'); 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'); 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'); 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'); 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'); INSERT INTO `image` VALUES ('1538', 'images/2015/9/1441874744043.jpg', null, '{\"width\":146,\"height\":220}', '2015-09-10 16:45:44'); 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'); INSERT INTO `image` VALUES ('1540', 'images/2015/9/1441881966534.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:46:07'); INSERT INTO `image` VALUES ('1541', 'images/2015/9/1441881966677.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:46:07'); 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'); INSERT INTO `image` VALUES ('1543', 'images/2015/9/1441882118682.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:48:39'); INSERT INTO `image` VALUES ('1544', 'images/2015/9/1441882118766.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:48:39'); 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'); INSERT INTO `image` VALUES ('1546', 'images/2015/9/1441882222620.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:23'); INSERT INTO `image` VALUES ('1547', 'images/2015/9/1441882222716.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:23'); 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'); INSERT INTO `image` VALUES ('1549', 'images/2015/9/1441882258385.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:58'); INSERT INTO `image` VALUES ('1550', 'images/2015/9/1441882258481.jpg', null, '{\"width\":1440,\"height\":1280}', '2015-09-10 18:50:59'); 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'); 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'); 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'); 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'); INSERT INTO `image` VALUES ('1555', 'images/2015/10/1444890969009.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 14:36:09'); INSERT INTO `image` VALUES ('1556', 'images/2015/10/1444890969035.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 14:36:09'); INSERT INTO `image` VALUES ('1557', 'images/2015/10/1444890969066.jpg', null, '{\"width\":800,\"height\":800}', '2015-10-15 14:36:09'); INSERT INTO `image` VALUES ('1558', 'images/2015/10/1444892662823.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 15:04:23'); INSERT INTO `image` VALUES ('1559', 'images/2015/10/1444892663114.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 15:04:23'); INSERT INTO `image` VALUES ('1560', 'images/2015/10/1444892663220.jpg', null, '{\"width\":800,\"height\":800}', '2015-10-15 15:04:23'); 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'); 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'); INSERT INTO `image` VALUES ('1563', 'images/2015/10/1444892931497.jpg', null, '{\"width\":350,\"height\":263}', '2015-10-15 15:08:52'); INSERT INTO `image` VALUES ('1564', 'images/2015/10/1444892931517.jpg', null, '{\"width\":266,\"height\":220}', '2015-10-15 15:08:52'); INSERT INTO `image` VALUES ('1565', 'images/2015/10/1444892931555.jpg', null, '{\"width\":750,\"height\":750}', '2015-10-15 15:08:52'); INSERT INTO `image` VALUES ('1566', 'images/2015/10/1445224183382.jpg', null, '{\"width\":610,\"height\":699}', '2015-10-19 11:09:44'); INSERT INTO `image` VALUES ('1567', 'images/2015/10/1445224184482.jpg', null, '{\"width\":610,\"height\":638}', '2015-10-19 11:09:45'); INSERT INTO `image` VALUES ('1568', 'images/2015/10/1445224184592.jpg', null, '{\"width\":610,\"height\":594}', '2015-10-19 11:09:45'); -- ---------------------------- -- Table structure for member -- ---------------------------- DROP TABLE IF EXISTS `member`; CREATE TABLE `member` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL COMMENT '用户名', `password` varchar(255) DEFAULT NULL COMMENT '密码', `type` varchar(255) NOT NULL COMMENT '类型(globle总后台，business商家后台)', `create_date` datetime NOT NULL COMMENT '创建时间', `update_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of member -- ---------------------------- INSERT INTO `member` VALUES ('1', 'admin', 'E10ADC3949BA59ABBE56E057F20F883E', 'GLOBLE', '2015-08-11 10:11:43', '2015-08-11 10:11:45'); INSERT INTO `member` VALUES ('4', 'wangbin', 'C33367701511B4F6020EC61DED352059', 'BUSINESS', '2015-08-12 10:14:13', '2015-08-12 10:14:13'); INSERT INTO `member` VALUES ('5', 'wangbin1', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:40:50', '2015-09-10 18:40:50'); INSERT INTO `member` VALUES ('6', 'wangbin2', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:43:38', '2015-09-10 18:43:38'); INSERT INTO `member` VALUES ('7', 'wangbin3', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:43:46', '2015-09-10 18:43:46'); INSERT INTO `member` VALUES ('8', 'wangbin4', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-10 18:43:55', '2015-09-10 18:43:55'); INSERT INTO `member` VALUES ('9', 'wangbin7', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-09-13 17:26:42', '2015-09-13 17:26:42'); INSERT INTO `member` VALUES ('13', 'wangb', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-14 14:23:11', '2015-10-14 14:23:11'); INSERT INTO `member` VALUES ('16', 'wangb', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 10:04:43', '2015-10-15 10:04:43'); INSERT INTO `member` VALUES ('17', 'wangb1', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 10:04:43', '2015-10-15 10:04:43'); INSERT INTO `member` VALUES ('18', 'wangb2', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 10:04:43', '2015-10-15 10:04:43'); INSERT INTO `member` VALUES ('19', 'wangb', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 14:14:40', '2015-10-15 14:14:40'); INSERT INTO `member` VALUES ('20', 'wangb1', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 14:14:41', '2015-10-15 14:14:41'); INSERT INTO `member` VALUES ('21', 'wangb2', 'E10ADC3949BA59ABBE56E057F20F883E', 'BUSINESS', '2015-10-15 14:14:41', '2015-10-15 14:14:41'); -- ---------------------------- -- Table structure for product -- ---------------------------- DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(255) DEFAULT NULL COMMENT '商品编码', `name` varchar(255) DEFAULT NULL COMMENT '商品名称', `image_id` int(11) DEFAULT NULL, `market_price` decimal(10,2) DEFAULT NULL COMMENT '商品价格', `price` decimal(10,2) DEFAULT NULL, `content` varchar(5000) DEFAULT NULL COMMENT '商品描述', `brand` varchar(255) DEFAULT NULL COMMENT '品牌', `is_added` bit(1) DEFAULT b'0', `product_area_id` int(11) DEFAULT NULL, `product_type_id` int(11) DEFAULT NULL, `sales_count` int(11) DEFAULT '0', `collect_count` int(11) DEFAULT '0', `sort` int(11) DEFAULT '0' COMMENT '排序', `create_date` datetime DEFAULT NULL, `update_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), KEY `product_area_id` (`product_area_id`), KEY `product_type_id` (`product_type_id`), KEY `image_id` (`image_id`), CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_area_id`) REFERENCES `product_area` (`id`), CONSTRAINT `product_ibfk_2` FOREIGN KEY (`product_type_id`) REFERENCES `product_type` (`id`), CONSTRAINT `product_ibfk_3` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of product -- ---------------------------- INSERT INTO `product` VALUES ('3', '2', '拉拉干红', '1553', '600.00', '100.00', '<p>啦啦啦简介啦啦啦简介啦啦啦简介啦啦啦简介啦啦啦简介<img src=\"/files/upload/image/ueditor/20151014/1444819706841096505.jpg\" title=\"1444819706841096505.jpg\" alt=\"2522840_19_b.jpg\"/><img src=\"/files/upload/image/ueditor/20151014/1444819709957005643.jpg\" title=\"1444819709957005643.jpg\" alt=\"55cb1513N80969b2b.jpg!q80.jpg\"/></p>', '拉拉', '', '1', '2', null, null, null, null, '2015-09-07 16:08:35'); INSERT INTO `product` VALUES ('4', '1', '拉萨酒', '1512', '65.00', '120.00', '短短的', '啦啦啦', '', '3', '2', null, null, null, null, '2015-08-21 14:49:56'); INSERT INTO `product` VALUES ('5', 'fff', 'sdasd', '1512', '660.00', '150.00', '

\"1423041680935.jpg\"/


我我我

', 'asdasd', '', '1', '2', null, null, null, '2015-08-25 14:51:25', '2015-09-07 17:05:40'); INSERT INTO `product` VALUES ('6', 's66541', '拉拉干红', '1512', '60.00', '230.00', '<p><br/></p><p><img src=\"/winetast/ueditor/jsp/upload/image/20151014/1444815067344025784.jpg\" title=\"1444815067344025784.jpg\" alt=\"548675ffNaef78887.jpg!q80.jpg\"/></p>', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); INSERT INTO `product` VALUES ('7', 's665412', '拉拉干红', '1512', '60.00', '250.00', '<p>点点滴滴<br/></p>', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); INSERT INTO `product` VALUES ('8', 's665413', '拉拉干红', '1512', '60.00', '300.00', '<p>点点滴滴<br/></p>', '拉菲', '', '1', '3', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); INSERT INTO `product` VALUES ('9', 's665414', '拉拉干红', '1512', '60.00', '400.00', '<p>点点滴滴<br/></p>', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); INSERT INTO `product` VALUES ('10', 's665415', '拉拉干红', '1512', '60.00', '450.00', '<p>点点滴滴<br/></p>', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); INSERT INTO `product` VALUES ('11', 's665416', '拉拉干红', '1512', '60.00', '101.00', '<p>点点滴滴<br/></p>', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); INSERT INTO `product` VALUES ('12', 's665417', '拉拉干红', '1511', '60.00', '500.00', '<p><img src=\"/files/upload/image/ueditor/20151019/1445224156789088193.jpg\" style=\"\" title=\"1445224156789088193.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224156805055637.jpg\" style=\"\" title=\"1445224156805055637.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224156835067970.jpg\" style=\"\" title=\"1445224156835067970.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224156860040988.jpg\" style=\"\" title=\"1445224156860040988.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224156878092547.jpg\" style=\"\" title=\"1445224156878092547.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224157013014528.jpg\" style=\"\" title=\"1445224157013014528.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224157046074903.jpg\" style=\"\" title=\"1445224157046074903.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224157062028350.jpg\" style=\"\" title=\"1445224157062028350.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224157079018025.jpg\" style=\"\" title=\"1445224157079018025.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224157139042714.jpg\" style=\"\" title=\"1445224157139042714.jpg\"/></p><p><img src=\"/files/upload/image/ueditor/20151019/1445224157147002906.jpg\" style=\"\" title=\"1445224157147002906.jpg\"/></p><p><br/></p>', '拉菲', '', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); INSERT INTO `product` VALUES ('13', 's665418', '拉拉干红', '1513', '60.00', '700.00', '<p>点点滴滴<br/></p>', '拉菲', '\0', '1', '2', '0', '0', null, '2015-09-07 17:45:36', '2015-09-07 17:45:47'); -- ---------------------------- -- Table structure for product_area -- ---------------------------- DROP TABLE IF EXISTS `product_area`; CREATE TABLE `product_area` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `create_date` datetime NOT NULL, `update_date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='产品产地'; -- ---------------------------- -- Records of product_area -- ---------------------------- INSERT INTO `product_area` VALUES ('1', '德国', '2015-08-20 11:58:12', '2015-08-20 15:20:43'); INSERT INTO `product_area` VALUES ('3', '法国', '2015-08-20 14:10:59', '2015-08-20 15:20:29'); -- ---------------------------- -- Table structure for product_images -- ---------------------------- DROP TABLE IF EXISTS `product_images`; CREATE TABLE `product_images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `image_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `product_id` (`product_id`), KEY `image_id` (`image_id`), CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`), CONSTRAINT `product_images_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of product_images -- ---------------------------- INSERT INTO `product_images` VALUES ('48', '4', '1489'); INSERT INTO `product_images` VALUES ('49', '4', '1490'); INSERT INTO `product_images` VALUES ('50', '4', '1491'); INSERT INTO `product_images` VALUES ('51', '4', '1492'); INSERT INTO `product_images` VALUES ('53', '3', '1494'); INSERT INTO `product_images` VALUES ('55', '5', '1496'); INSERT INTO `product_images` VALUES ('56', '5', '1497'); INSERT INTO `product_images` VALUES ('57', '6', '1507'); INSERT INTO `product_images` VALUES ('58', '6', '1508'); INSERT INTO `product_images` VALUES ('59', '6', '1509'); INSERT INTO `product_images` VALUES ('60', '6', '1510'); INSERT INTO `product_images` VALUES ('67', '13', '1563'); INSERT INTO `product_images` VALUES ('68', '13', '1564'); INSERT INTO `product_images` VALUES ('69', '13', '1565'); INSERT INTO `product_images` VALUES ('70', '12', '1566'); INSERT INTO `product_images` VALUES ('71', '12', '1567'); INSERT INTO `product_images` VALUES ('72', '12', '1568'); -- ---------------------------- -- Table structure for product_type -- ---------------------------- DROP TABLE IF EXISTS `product_type`; CREATE TABLE `product_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL COMMENT '商品类别', `create_date` datetime DEFAULT NULL, `update_date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='产品类别'; -- ---------------------------- -- Records of product_type -- ---------------------------- INSERT INTO `product_type` VALUES ('2', '干红', '2015-08-20 14:29:41', '2015-08-20 15:21:04'); INSERT INTO `product_type` VALUES ('3', '葡萄酒', '2015-08-20 14:29:59', '2015-08-20 15:20:58'); INSERT INTO `product_type` VALUES ('4', 'll', '2016-01-27 23:51:30', '2016-01-27 23:51:36');