shopping

KO | EN

gitlite — search

#python #java #python3 #arduino #golang #machine-learning #rust #html #flask #javascript #seismology #nodejs

★ 22 Open GitHub ↗

分布式电商项目源码，分模块

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# shopping
分布式电商项目源码，分模块
```sql
/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50611
Source Host           : localhost:3306
Source Database       : e3mall

Target Server Type    : MYSQL
Target Server Version : 50611
File Encoding         : 65001

Date: 2016-10-05 15:27:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tb_content
-- ----------------------------
DROP TABLE IF EXISTS `tb_content`;
CREATE TABLE `tb_content` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) NOT NULL COMMENT '内容类目ID',
  `title` varchar(200) DEFAULT NULL COMMENT '内容标题',
  `sub_title` varchar(100) DEFAULT NULL COMMENT '子标题',
  `title_desc` varchar(500) DEFAULT NULL COMMENT '标题描述',
  `url` varchar(500) DEFAULT NULL COMMENT '链接',
  `pic` varchar(300) DEFAULT NULL COMMENT '图片绝对路径',
  `pic2` varchar(300) DEFAULT NULL COMMENT '图片2',
  `content` text COMMENT '内容',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `updated` (`updated`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_content
-- ----------------------------
INSERT INTO `tb_content` VALUES ('28', '89', '标题1', '标题1', '标题1', 'http://www.jd.com', 'http://localhost:9000/images/2015/07/27/1437979301511057.jpg', null, '标题1', '2015-07-27 14:41:57', '2015-07-27 14:41:57');
INSERT INTO `tb_content` VALUES ('29', '89', 'ad2', 'ad2', 'ad2', 'http://www.baidu.com', 'http://localhost:9000/images/2015/07/27/1437979349040954.jpg', null, 'ad2', '2015-07-27 14:42:36', '2015-07-27 14:42:36');
INSERT INTO `tb_content` VALUES ('30', '89', 'ad3', 'ad3', 'ad3', 'http://www.sina.com.cn', 'http://localhost:9000/images/2015/07/27/1437979377450366.jpg', null, '', '2015-07-27 14:42:58', '2015-07-27 14:42:58');
INSERT INTO `tb_content` VALUES ('31', '89', 'ad4', 'ad4', 'ad4', 'ad4', 'http://localhost:9000/images/2015/07/27/1437979392186756.jpg', null, 'ad4', '2015-07-27 14:43:15', '2015-07-27 14:43:15');

-- ----------------------------
-- Table structure for tb_content_category
-- ----------------------------
DROP TABLE IF EXISTS `tb_content_category`;
CREATE TABLE `tb_content_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '类目ID',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父类目ID=0时，代表的是一级的类目',
  `name` varchar(50) DEFAULT NULL COMMENT '分类名称',
  `status` int(1) DEFAULT '1' COMMENT '状态。可选值:1(正常),2(删除)',
  `sort_order` int(4) DEFAULT NULL COMMENT '排列序号，表示同级类目的展现次序，如数值相等则按名称次序排列。取值范围:大于零的整数',
  `is_parent` tinyint(1) DEFAULT '1' COMMENT '该类目是否为父类目，1为true，0为false',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`,`status`) USING BTREE,
  KEY `sort_order` (`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8 COMMENT='内容分类';

-- ----------------------------
-- Records of tb_content_category
-- ----------------------------
INSERT INTO `tb_content_category` VALUES ('30', '0', '淘淘商城', '1', '1', '1', '2015-04-03 16:51:38', '2015-04-03 16:51:40');
INSERT INTO `tb_content_category` VALUES ('86', '30', '首页', '1', '1', '1', '2015-06-07 15:36:07', '2015-06-07 15:36:07');
INSERT INTO `tb_content_category` VALUES ('87', '30', '列表页面', '1', '1', '1', '2015-06-07 15:36:16', '2015-06-07 15:36:16');
INSERT INTO `tb_content_category` VALUES ('88', '30', '详细页面', '1', '1', '1', '2015-06-07 15:36:27', '2015-06-07 15:36:27');
INSERT INTO `tb_content_category` VALUES ('89', '86', '大广告', '1', '1', '0', '2015-06-07 15:36:38', '2015-06-07 15:36:38');
INSERT INTO `tb_content_category` VALUES ('90', '86', '小广告', '1', '1', '0', '2015-06-07 15:36:45', '2015-06-07 15:36:45');
INSERT INTO `tb_content_category` VALUES ('91', '86', '淘淘快报', '1', '1', '0', '2015-06-07 15:36:55', '2015-06-07 15:36:55');
INSERT INTO `tb_content_category` VALUES ('92', '87', '边栏广告', '1', '1', '0', '2015-06-07 15:37:07', '2015-06-07 15:37:07');
INSERT INTO `tb_content_category` VALUES ('93', '87', '页头广告', '1', '1', '0', '2015-06-07 15:37:17', '2015-06-07 15:37:17');
INSERT INTO `tb_content_category` VALUES ('94', '87', '页脚广告', '1', '1', '0', '2015-06-07 15:37:31', '2015-06-07 15:37:31');
INSERT INTO `tb_content_category` VALUES ('95', '88', '边栏广告', '1', '1', '0', '2015-06-07 15:37:56', '2015-06-07 15:37:56');
INSERT INTO `tb_content_category` VALUES ('96', '86', '中广告', '1', '1', '1', '2015-07-25 18:58:52', '2015-07-25 18:58:52');
INSERT INTO `tb_content_category` VALUES ('97', '96', '中广告1', '1', '1', '0', '2015-07-25 18:59:43', '2015-07-25 18:59:43');

-- ----------------------------
-- Table structure for tb_item
-- ----------------------------
DROP TABLE IF EXISTS `tb_item`;
CREATE TABLE `tb_item` (
  `id` bigint(20) NOT NULL COMMENT '商品id，同时也是商品编号',
  `title` varchar(100) NOT NULL COMMENT '商品标题',
  `sell_point` varchar(500) DEFAULT NULL COMMENT '商品卖点',
  `price` bigint(20) NOT NULL COMMENT '商品价格，单位为：分',
  `num` int(10) NOT NULL COMMENT '库存数量',
  `barcode` varchar(30) DEFAULT NULL COMMENT '商品条形码',
  `image` varchar(500) DEFAULT NULL COMMENT '商品图片',
  `cid` bigint(10) NOT NULL COMMENT '所属类目，叶子类目',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '商品状态，1-正常，2-下架，3-删除',
  `created` datetime NOT NULL COMMENT '创建时间',
  `updated` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `cid` (`cid`),
  KEY `status` (`status`),
  KEY `updated` (`updated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Records of tb_item
-- ----------------------------
INSERT INTO `tb_item` VALUES ('536563', 'new2 - 阿尔卡特 (OT-927) 炭黑 联通3G手机 双卡双待', '清仓！仅北京，武汉仓有货！', '29900000', '99999', '', 'http://image.e3mall.cn/jd/4ef8861cf6854de9889f3db9b24dc371.jpg', '560', '1', '2015-03-08 21:33:18', '2015-04-11 20:38:38');
INSERT INTO `tb_item` VALUES ('562379', 'new8- 三星 W999 黑色 电信3G手机 双卡双待双通', '下单送12000毫安移动电源！双3.5英寸魔焕炫屏，以非凡视野纵观天下时局，尊崇翻盖设计，张弛中，尽显从容气度！', '1100', '99999', '', 'http://image.e3mall.cn/jd/d2ac340e728d4c6181e763e772a9944a.jpg', '560', '1', '2015-03-08 21:27:54', '2015-04-12 17:10:43');
INSERT INTO `tb_item` VALUES ('605616', '阿尔卡特 (OT-979) 冰川白 联通3G手机', '清仓！仅上海仓有货！', '30900', '99999', null, 'http://image.e3mall.cn/jd/a69d0d09a1a04164969c2d0369659b1a.jpg', '560', '1', '2015-03-08 21:33:18', '2015-03-08 21:33:18');

-- ----------------------------
-- Table structure for tb_item_cat
-- ----------------------------
DROP TABLE IF EXISTS `tb_item_cat`;
CREATE TABLE `tb_item_cat` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '类目ID',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父类目ID=0时，代表的是一级的类目',
  `name` varchar(50) DEFAULT NULL COMMENT '类目名称',
  `status` int(1) DEFAULT '1' COMMENT '状态。可选值:1(正常),2(删除)',
  `sort_order` int(4) DEFAULT NULL COMMENT '排列序号，表示同级类目的展现次序，如数值相等则按名称次序排列。取值范围:大于零的整数',
  `is_parent` tinyint(1) DEFAULT '1' COMMENT '该类目是否为父类目，1为true，0为false',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`,`status`) USING BTREE,
  KEY `sort_order` (`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=1183 DEFAULT CHARSET=utf8 COMMENT='商品类目';

-- ----------------------------
-- Records of tb_item_cat
-- ----------------------------
INSERT INTO `tb_item_cat` VALUES ('1', '0', '图书、音像、电子书刊', '1', '1', '1', '2014-10-15 18:31:55', '2014-10-15 18:31:55');
INSERT INTO `tb_item_cat` VALUES ('2', '1', '电子书刊', '1', '1', '1', '2014-10-15 18:31:55', '2014-10-15 18:31:55');
INSERT INTO `tb_item_cat` VALUES ('3', '2', '电子书', '1', '1', '0', '2014-10-15 18:31:55', '2014-10-15 18:31:55');
INSERT INTO `tb_item_cat` VALUES ('4', '2', '网络原创', '1', '2', '0', '2014-10-15 18:31:55', '2014-10-15 18:31:55');

-- ----------------------------
-- Table structure for tb_item_desc
-- ----------------------------
DROP TABLE IF EXISTS `tb_item_desc`;
CREATE TABLE `tb_item_desc` (
  `item_id` bigint(20) NOT NULL COMMENT '商品ID',
  `item_desc` text COMMENT '商品描述',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品描述表';

-- ----------------------------
-- Records of tb_item_desc
-- ----------------------------
INSERT INTO `tb_item_desc` VALUES ('536563', '111111111111111\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/XaMLOrYAH3MPJGbl.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/wXQkLXR3uGR2uVQ2.gif\" alt=\"\" border=\"0\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/2kZKaLDmnLsPG0Eg.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/lSwjUG1ZzubIBKi0.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"111\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td width=\"78\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/uASNw0Nhxbk21bC5.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"333\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					采用Android 2.2操作系统,更加优化的系统内核带来卓越性能,同时预装QQ、新浪微博等热门应用\r\n				</div>\r\n			</td>\r\n			<td width=\"8\">\r\n				&nbsp;\r\n			</td>\r\n			<td width=\"78\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/8BjUn5BJV4ChgBE7.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"353\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					一机两用，无需换号；惬意生活，智“用”双全。谈笑间捕捉点滴信息，专属私享倍感温馨。\r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"111\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td width=\"78\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/kjPt78VIkxrbvzjW.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"333\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					3.2英寸炫彩电容触摸屏支持多点触控手指滑动间发现生活点滴细节\r\n				</div>\r\n			</td>\r\n			<td width=\"8\">\r\n				&nbsp;\r\n			</td>\r\n			<td width=\"78\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/7bC2f6LYB4ROO7Bg.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"353\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					320万像素摄像头,轻松记录精彩瞬间。更可将生活点滴通过预置微博分享\r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"111\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td width=\"78\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/DrtlVpc5KOJ7Oo9T.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"333\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					3G/WLAN高速接入互联网,QQ聊天、实时微博、在线听歌,速度有保证\r\n				</div>\r\n			</td>\r\n			<td width=\"8\">\r\n				&nbsp;\r\n			</td>\r\n			<td width=\"78\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/EMX4AvilXnOxff9b.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"353\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					内置“ALCATEL乐园”在线音乐播放器，随时随地畅享高品质音乐生活\r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/FdkvXqmxfqmLcnBN.gif\" alt=\"\" border=\"0\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/7ReuGiUYMpcc1A4v.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/08XIDvbOyLHr5TFh.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/ivwfr0sEKFrnoYXY.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/RlyKbCyJqCAKbnjU.gif\" alt=\"\" border=\"0\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/nihX1mBqOpLrR6N8.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/kANw4Di0YoV2DVHW.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/wEv3UUxp01Sa7tqe.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/kDkMCmaSRRvcQ6v6.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/XGyZXm6ckLMShyW8.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/aIab5g4ibTlipRwj.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/qOjSI5NDLTXtiyk0.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/PJfQsp7yzKWeqJlC.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/4hxF7djjffwbL0Ul.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/MP7SbGD7x6td4mW6.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/DO8BaCMdbPo6z8IX.gif\" alt=\"\" border=\"0\" height=\"44\" width=\"753\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td height=\"210\" width=\"360\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/qfPNzIg2Wuc1XAcW.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"442\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					我支持AGPS/GPS，并预装导航软件，<br />\r\n甭管到哪里，咱都不会迷路啦！\r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td width=\"442\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					我还预装了搜狗输入法，<br />\r\n不仅支持拼音、笔画，还能手写呢，<br />\r\n想怎么输入咱都行！\r\n				</div>\r\n			</td>\r\n			<td height=\"210\" width=\"360\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/OIwggBizqF0p02Cj.jpg\" alt=\"\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td height=\"210\" width=\"360\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/8TXsdeIW3axWFftu.jpg\" alt=\"\" /> \r\n			</td>\r\n			<td width=\"442\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					我有独特的智能距离感应器，<br />\r\n当您接电话靠近我时，我就会自动熄灭屏幕，<br />\r\n拿开我时，会自动点亮屏幕，<br />\r\n不仅方便，还能给你省电呢！\r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td width=\"442\">\r\n				<div class=\"pcp_title\">\r\n				</div>\r\n				<div class=\"pcp_zhengzi\">\r\n					您是否还经常为漏装、查找没有安装的程序苦恼呢？<br />\r\n现在不用啦，我预装“轻松安装”程序，<br />\r\n只需轻轻一点，就能自动扫描没有安装的程序，很给力！\r\n				</div>\r\n			</td>\r\n			<td height=\"210\" width=\"360\" align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/TbeBJZyAt9USLIDR.jpg\" alt=\"\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/qEDjs0vUlSH34Thx.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/97y8iH59dd022V6I.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/hXT4Q2XmOZamNZ7j.gif\" alt=\"\" border=\"0\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/488SagrbBtmSg85F.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/dWlmeuxc1IbuqVU4.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/spE18vI6HvlkY0KI.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table width=\"750\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/WzKgJERzxB6x7tLc.jpg\" alt=\"\" border=\"0\" height=\"44\" width=\"750\" /> \r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n				<div align=\"center\">\r\n					<img src=\"http://img30.360buyimg.com/jgsq-productsoa/g4/M01/04/14/rBEGFU-rDU8IAAAAAALH-stG5eIAAA54AMYGf4AAsgS224.jpg\" alt=\"\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td align=\"center\">\r\n				<img src=\"http://img30.360buyimg.com/erpWareDetail/VrMYpSO0JUQhJUQY.gif\" alt=\"\" border=\"0\" /> \r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/gIHFRdp8F3CYy2ko.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" align=\"center\" class=\"ke-zeroborder\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"center\" align=\"center\">\r\n				<div class=\"bigapic\">\r\n					<img src=\"http://img30.360buyimg.com/erpWareDetail/nS3UZUVALGd8yPEP.jpg\" alt=\"\" border=\"0\" /> \r\n				</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<br />', '2015-03-08 21:33:18', '2015-04-11 20:38:38');
INSERT INTO `tb_item_desc` VALUES ('562379', '<div class=\"content_tpl\">\r\n	<p>\r\n		<br />\r\n	</p>\r\n	<p>\r\n		aaaaaaaaaaaaaaa\r\n	</p>\r\n	<p>\r\n		<img src=\"http://img30.360buyimg.com/jgsq-productsoa/g13/M08/02/0D/rBEhU1HH-oQIAAAAAABGTIeJHiAAAAeGAAl8W0AAEZk102.jpg\" alt=\"\" /> \r\n	</p>\r\n<img src=\"http://img30.360buyimg.com/jgsq-productsoa/g13/M01/01/1F/rBEhUlHC4HMIAAAAAACcfxP6teMAAAYnwBYxA8AAJyX056.jpg\" alt=\"\" /> \r\n	<div class=\"formwork_img\" style=\"font-family:Arial, Helvetica, sans-serif;font-size:14px;\">\r\n		<table class=\" ke-zeroborder\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">\r\n			<tbody>\r\n				<tr>\r\n					<td colspan=\"2\">\r\n						<div style=\"padding:5px 5px 5px 7px;font-size:14px;\">\r\n							<span style=\"font-family:\'Microsoft YaHei\';\"><span style=\"font-size:14px;line-height:21px;\">尊敬的顾客：</span><br />\r\n<span style=\"font-size:14px;line-height:21px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 在选购手机的同时可参加京东商城与中国电信合作推出购机送话费活动（新入网用户）：该手机属于电信定制机，3G网络制式为电信CDMA2000，您只需点击“购机入网送话费”按钮加入购物车选择套餐、赠费档位、号码后即可享受当地电信的高额话费赠送，订单提交后京东相关人员会为您办理入网，手机和号卡一同配送，具体赠费明细可加入购物车后查看：</span></span> \r\n						</div>\r\n					</td>\r\n				</tr>\r\n				<tr>\r\n					<td align=\"center\">\r\n						&nbsp;\r\n					</td>\r\n					<td align=\"center\">\r\n						<span style=\"font-family:\'Microsoft YaHei\';\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<a href=\"http://www.360buy.com/knowledge/1-55-1449.html\" target=\"_blank\"><img alt=\"\" src=\"http://img30.360buyimg.com/jgsq-productsoa/g10/M00/17/05/rBEQWFFxNNkIAAAAAAA4vfAW_P4AAEh1wKE4W0AADjV789.png\" height=\"57\" width=\"252\" /></a></span> \r\n					</td>\r\n				</tr>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n	<div class=\"formwork_img\" style=\"font-family:Arial, Helvetica, sans-serif;font-size:14px;\">\r\n		<span style=\"font-family:\'Microsoft YaHei\';\"><br />\r\n</span><img src=\"http://img30.360buyimg.com/jgsq-productsoa/g13/M02/13/1E/rBEhUlJw3dUIAAAAAAG7ysP0IbEAAEyeQHnzAQAAbvi516.jpg\" alt=\"\" /><br />\r\n	</div>\r\n	<div style=\"font-family:Arial, Helvetica, sans-serif;font-size:14px;text-align:-webkit-center;\">\r\n		<span style=\"font-size:12px;\"><span style=\"font-family:\'Microsoft YaHei\';\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></span><span style=\"font-family:\'Microsoft YaHei\';font-size:12px;\"> 注：选择购机入网送话费的方式购买合约，话费为赠品不开具发票</span> \r\n	</div>\r\n	<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td valign=\"top\">\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/Maf3RzWQlsmXD32V.gif\" border=\"0\" height=\"44\" width=\"753\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/chkRlVjaRXDGJS64.jpg\" border=\"0\" height=\"298\" width=\"749\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/uAdqfuUuFnQSReru.jpg\" border=\"0\" height=\"486\" width=\"750\" /> \r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/8czFAhCudb5rLs00.jpg\" border=\"0\" height=\"486\" width=\"750\" /> \r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/U0H5fMO2YCHrRHWY.jpg\" border=\"0\" height=\"540\" width=\"750\" /> \r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/fPAdjaiKjhLGAiKj.jpg\" border=\"0\" height=\"536\" width=\"749\" /> \r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/QKPdwQ2Ocnd1CGE1.jpg\" border=\"0\" height=\"447\" width=\"750\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/jN4A2kAlcyrggrjL.gif\" border=\"0\" height=\"44\" width=\"753\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td width=\"128\">\r\n					<p align=\"center\">\r\n						<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/BiFzjtXILvHL0wbF.gif\" border=\"0\" height=\"102\" width=\"128\" /> \r\n					</p>\r\n				</td>\r\n				<td width=\"251\">\r\n					<div style=\"font-family:\'微软雅黑\';color:#000;font-size:14px;font-weight:bold;\">\r\n						<strong>尊崇翻盖设计</strong> \r\n					</div>\r\n					<div style=\"font-family:\'微软雅黑\';font-size:14px;\">\r\n						- 尊崇翻盖设计，张弛中，尽显从容气度。\r\n					</div>\r\n				</td>\r\n				<td width=\"128\">\r\n					<p>\r\n						<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/nInNfCLVSRWQ6MGP.gif\" border=\"0\" height=\"102\" width=\"128\" /> \r\n					</p>\r\n				</td>\r\n				<td valign=\"top\" width=\"243\">\r\n					<div style=\"font-family:\'微软雅黑\';color:#000;font-size:14px;font-weight:bold;\">\r\n						<strong>1.2GHz高速双核处理器</strong> \r\n					</div>\r\n					<div style=\"font-family:\'微软雅黑\';font-size:14px;\">\r\n						- 1.2GHz高速双核处理器，指掌之间超越平凡。\r\n					</div>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td height=\"145\" width=\"128\">\r\n					<p align=\"center\">\r\n						<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/DJHbNJoT2t6XHctu.gif\" border=\"0\" height=\"102\" width=\"128\" /> \r\n					</p>\r\n				</td>\r\n				<td width=\"244\">\r\n					<div style=\"font-family:\'微软雅黑\';color:#000;font-size:14px;font-weight:bold;\">\r\n						<strong>双3.5英寸WVGA SUPER AMOLED魔焕炫屏</strong> \r\n					</div>\r\n					<div style=\"font-family:\'微软雅黑\';font-size:14px;\">\r\n						- 双3.5英寸WVGA SUPER AMOLED魔焕炫屏，以非凡视野纵观天下时局。\r\n					</div>\r\n				</td>\r\n				<td width=\"128\">\r\n					<p>\r\n						<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/Fj6jw4quSktyCNPu.gif\" border=\"0\" height=\"102\" width=\"128\" /> \r\n					</p>\r\n				</td>\r\n				<td valign=\"top\" width=\"250\">\r\n					<div style=\"font-family:\'微软雅黑\';color:#000;font-size:14px;font-weight:bold;\">\r\n						<strong>Android? 2.3 智能操作系统</strong> \r\n					</div>\r\n					<div style=\"font-family:\'微软雅黑\';font-size:14px;\">\r\n						- Android? 2.3 智能操作系统，助力阁下运筹帷幄之中。\r\n					</div>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td width=\"128\">\r\n					<p align=\"center\">\r\n						<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/O1r7hCQVohsn29LE.gif\" border=\"0\" height=\"102\" width=\"128\" /> \r\n					</p>\r\n				</td>\r\n				<td width=\"244\">\r\n					<div style=\"font-family:\'微软雅黑\';color:#000;font-size:14px;font-weight:bold;\">\r\n						<strong>内置Samsung Apps</strong> \r\n					</div>\r\n					<div style=\"font-family:\'微软雅黑\';font-size:14px;\">\r\n						- 内置Samsung Apps, 汇聚热门应用，精彩尽在掌握。\r\n					</div>\r\n				</td>\r\n				<td width=\"128\">\r\n					<p>\r\n						<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/NoYbBUIxD2Pny4Pd.gif\" border=\"0\" height=\"102\" width=\"128\" /> \r\n					</p>\r\n				</td>\r\n				<td valign=\"top\" width=\"250\">\r\n					<div style=\"font-family:\'微软雅黑\';color:#000;font-size:14px;font-weight:bold;\">\r\n						<strong>内置丰富电信应用</strong> \r\n					</div>\r\n					<div style=\"font-family:\'微软雅黑\';font-size:14px;\">\r\n						- 内置丰富电信应用，天翼空间、天翼视讯、189邮箱，定制服务专属为您。\r\n					</div>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/4SG8oNzLQHpeIJ1W.gif\" border=\"0\" height=\"44\" width=\"753\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/krYMgm1QWK1cvyE2.gif\" border=\"0\" height=\"335\" width=\"350\" /> \r\n				</td>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/YiBKbaFG3efkjmyg.gif\" border=\"0\" height=\"305\" width=\"350\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/sNw1b5joHZP7cpoC.gif\" border=\"0\" height=\"333\" width=\"350\" /> \r\n				</td>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/OeNBD1WHTbiRjZTP.gif\" border=\"0\" height=\"349\" width=\"350\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					&nbsp;\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<table align=\"center\" border=\"0\" width=\"750\" class=\"ke-zeroborder\">\r\n		<tbody>\r\n			<tr>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/X4Fnihnhh4Y4dJQj.gif\" border=\"0\" height=\"337\" width=\"350\" /> \r\n				</td>\r\n				<td>\r\n					<img alt=\"\" src=\"http://img30.360buyimg.com/erpWareDetail/3JGhZ2YRe9udc2Kh.gif\" border=\"0\" height=\"374\" width=\"350\" /> \r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n	<p>\r\n		<br />\r\n	</p>\r\n</div>', '2015-03-08 21:27:54', '2015-04-12 17:10:43');
INSERT INTO `tb_item_desc` VALUES ('605616', '	<table align=\"center\" border=\"0\" cellpadding=\"7\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td><iframe marginheight=\"0px\" marginwidth=\"0px\" src=\"http://cloud.letv.com/bcloud.html?uu=82abd5491f&vu=09c9c9c885&width=750&height=422&auto_play=0\" frameborder=\"0\" height=\"422px\" width=\"750px\"></iframe></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/ohMXjnSM6HsbBCcK.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g5/M02/13/0F/rBEIC0_6gbkIAAAAAAJoyIOxI1kAADzpwCe8zEAAmjg578.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td><img src=\"http://img30.360buyimg.com/erpWareDetail/28kvW8zLcozLcBxI.gif\" alt=\"\" border=\"0\" /></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/blgANEFOiSE1FdU6.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\">  <tbody><tr>    <td align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/wXQkLXR3uGR2uVQ2.gif\" alt=\"\" border=\"0\" /></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/PwTBCVlfsjUdocFN.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style type=\"text/css\"></style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td width=\"442\"><div class=\"pcp_title\"></div></td>  </tr>  <tr>    <td><div class=\"pcp_zhengzi\"> 4.0英寸WVGA宽视角IPS屏幕，1600万色画面清晰亮丽，支持5点触控，耐磨玻璃电容屏。</div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/pCO1NqGwWZ8XlF3n.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style type=\"text/css\"></style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td width=\"442\"><div class=\"pcp_title\"></div></td>  </tr>  <tr>    <td><div class=\"pcp_zhengzi\"> 1.0GHZ高速处理器，512MB RAM 512MB ROM，支持多任务处理。</div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/XZ4bSCBpN0uq6596.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/9XGYD3VA1zlTX4Ne.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style type=\"text/css\"></style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td width=\"442\"><div class=\"pcp_title\"></div></td>  </tr>  <tr>    <td><div class=\"pcp_zhengzi\"> 安卓2.3.7智能操作系统，海量应用任您下载。预装安装助手，祝您轻松安装喜爱应用。</div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/ku0ciG8VnQWjP7yb.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/6BfCW0FKEdijMqJ7.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style type=\"text/css\"></style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody>    <tr>      <td align=\"center\"><div class=\"pcp_title\"></div></td>      <td rowspan=\"3\" width=\"10\">&nbsp;</td>      <td align=\"center\"><div class=\"pcp_title\"></div></td>    </tr>    <tr>      <td align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/QNgGQmIg43J80wX1.jpg\" alt=\"\" /></td>      <td align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/Fhv9hHtRHfACtXnB.jpg\" alt=\"\" /></td>    </tr>    <tr>      <td align=\"center\"><div class=\"pcp_zhengzi\">全新晒纹工艺，时尚外观，握感极佳。</div></td>      <td align=\"center\"><div class=\"pcp_zhengzi\">支持A-GPS/GPS，支持重力传感，轻松使用多种应用。</div></td>    </tr>  </tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/bP6Pbghf777Ee8tP.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/99Xda8gAEo7xHSGT.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\">  <tbody><tr>    <td align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/RlyKbCyJqCAKbnjU.gif\" alt=\"\" border=\"0\" /></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/6OzLM51G76JXjwGK.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\">  <tbody><tr>    <td align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/VrMYpSO0JUQhJUQY.gif\" alt=\"\" border=\"0\" /></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/EhirUNBqCZyji601.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"753\">  <tbody><tr>    <td align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/FdkvXqmxfqmLcnBN.gif\" alt=\"\" border=\"0\" /></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/1FEsfRyEVPuWodle.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/YgtCr4BJgxZHp7l2.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table><style>.bigapic{ width:750px; height:auto;}</style><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"750\">  <tbody><tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img src=\"http://img30.360buyimg.com/erpWareDetail/s6hBdpY3qKLoBTak.jpg\" alt=\"\" border=\"0\" /></div></td>  </tr></tbody></table>', '2015-03-08 21:33:18', '2015-03-08 21:33:18');
INSERT INTO `tb_item_desc` VALUES ('635906', '<style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g3/M03/04/1A/rBEGE0-z4WoIAAAAAAAR0WQ-QcQAAA8fAD_zFwAABHp697.jpg\" border=\"0\" /></div></td>  </tr></table><table width=\"753\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\"><img border=\"0\" src=\"http://img30.360buyimg.com/erpWareDetail/DO8BaCMdbPo6z8IX.gif\" width=\"753\" height=\"44\" /></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g2/M04/04/1A/rBEGEU-z4WoIAAAAAAFR4P5UwpoAAA8gwGUj1QAAVH4219.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFU-z4YYIAAAAAAC8uN8TyOIAAA8fgC734oAALzQ341.jpg\" border=\"0\" /></div></td>  </tr></table><style type=\"text/css\"></style><table height=\"111\" cellspacing=\"0\" cellpadding=\"0\" width=\"750\" align=\"center\" border=\"0\">  <tbody>    <tr>      <td align=\"middle\" width=\"78\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g3/M03/04/1A/rBEGE0-z4XcIAAAAAAAQeJJSqv0AAA8fAD_3kUAABCQ168.jpg\"></td>      <td width=\"333\"><div class=\"pcp_title\"></div>      <div class=\"pcp_zhengzi\">采用Android 2.2操作系统<br/>更加优化的系统内核带来卓越性能<br/>同时预装QQ、新浪微博等热门应用</div></td>      <td width=\"8\">&nbsp;</td>      <td align=\"middle\" width=\"78\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g1/M05/04/1A/rBEGDk-z4YMIAAAAAAAPIdGf4k8AAA8fgIqp34AAA85336.jpg\"></td>      <td width=\"353\"><div class=\"pcp_title\"></div>      <div class=\"pcp_zhengzi\">一机两用，无需换号；<br/>惬意生活，智&ldquo;用&rdquo;双全。<br/>谈笑间捕捉点滴信息，<br/>专属私享倍感温馨。</div></td>    </tr>  </tbody></table><style type=\"text/css\"></style><table height=\"111\" cellspacing=\"0\" cellpadding=\"0\" width=\"750\" align=\"center\" border=\"0\">  <tbody>    <tr>      <td align=\"middle\" width=\"78\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g2/M03/04/1A/rBEGEE-z4ZEIAAAAAAAPE2teaz8AAA8ggP_6WIAAA8r608.jpg\"></td>      <td width=\"333\"><div class=\"pcp_title\"></div>      <div class=\"pcp_zhengzi\">3.2英寸炫彩电容触摸屏<br/>支持多点触控<br/>手指滑动间发现生活点滴细节</div></td>      <td width=\"8\">&nbsp;</td>      <td align=\"middle\" width=\"78\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFk-z4aQIAAAAAAAQcfdpeZ4AAA8fgC8nFoAABCJ693.jpg\"></td>      <td width=\"353\"><div class=\"pcp_title\"></div>      <div class=\"pcp_zhengzi\">320万像素摄像头<br/>轻松记录精彩瞬间<br/>更可将生活点滴通过预置微博分享</div></td>    </tr>  </tbody></table><style type=\"text/css\"></style><table height=\"111\" cellspacing=\"0\" cellpadding=\"0\" width=\"750\" align=\"center\" border=\"0\">  <tbody>    <tr>      <td align=\"middle\" width=\"78\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFk-z4dEIAAAAAAASGs4QOGcAAA8fgDAgJQAABIy527.jpg\"></td>      <td width=\"333\"><div class=\"pcp_title\"></div>      <div class=\"pcp_zhengzi\">3G/WLAN高速接入互联网<br/>QQ聊天、实时微博、在线听歌<br/>速度有保证</div></td>      <td width=\"8\">&nbsp;</td>      <td align=\"middle\" width=\"78\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g1/M05/04/1A/rBEGDU-z4aUIAAAAAAAQ3n2cXcMAAA8fgIri2QAABD2599.jpg\"></td>      <td width=\"353\"><div class=\"pcp_title\"></div>      <div class=\"pcp_zhengzi\">内置&ldquo;ALCATEL乐园&rdquo;在线音乐播放器<br/>随时随地畅享高品质音乐生活</div></td>    </tr>  </tbody></table><table width=\"753\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\"><img border=\"0\" src=\"http://img30.360buyimg.com/erpWareDetail/FdkvXqmxfqmLcnBN.gif\"/></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g3/M03/04/1A/rBEGFE-z4esIAAAAAACjwSDBZ34AAA8fAECY3MAAKPZ352.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFU-z4fIIAAAAAADLDjc0HvIAAA8fgDAksYAAMsm218.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g1/M05/04/1A/rBEGDk-z4fMIAAAAAADIDspxk74AAA8fgIsArUAAMgm117.jpg\" border=\"0\" /></div></td>  </tr></table><table width=\"753\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\"><img border=\"0\" src=\"http://img30.360buyimg.com/erpWareDetail/RlyKbCyJqCAKbnjU.gif\"/></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g2/M04/04/1A/rBEGEE-z4eAIAAAAAAEMkmIsMAUAAA8gwGapagAAQyq435.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFk-z4fMIAAAAAADy49Xy-FwAAA8fgDBXewAAPL7222.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g2/M04/04/1A/rBEGEk-z4fkIAAAAAAEWfgahsTQAAA8gwGbslIAARaW741.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFk-z4foIAAAAAADOTnQ1ywkAAA8fgDCUOcAAM5m170.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g1/M05/04/1A/rBEGD0-z4goIAAAAAAEnqkuVv2MAAA8fgIutIAAASfC340.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g2/M04/04/1A/rBEGEU-z4fgIAAAAAAEl-JaDU0sAAA8gwGcyOgAASYQ355.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g3/M03/04/1A/rBEGFE-z4g4IAAAAAABuBGY9Xh0AAA8fAEGq9sAAG4c293.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFU-z4hUIAAAAAADwjqVEtJYAAA8fgDRNcEAAPCm333.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g1/M05/04/1A/rBEGDU-z4eIIAAAAAAEn1E5J4fYAAA8fgIwQp0AASfs799.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g2/M04/04/1A/rBEGEk-z4hUIAAAAAAEuexWesLwAAA8gwGeVVMAAS6T146.jpg\" border=\"0\" /></div></td>  </tr></table><table width=\"753\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\"><img border=\"0\" src=\"http://img30.360buyimg.com/erpWareDetail/wXQkLXR3uGR2uVQ2.gif\"/></td>  </tr></table><style type=\"text/css\"></style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td width=\"360\" height=\"210\" align=\"center\" ><img src=\"http://img30.360buyimg.com/erpWareDetail/g2/M04/04/1A/rBEGEU-z4gkIAAAAAAAlWOH8QIQAAA8gwGfg-YAACVw810.jpg\" /></td>    <td width=\"442\"><div class=\"pcp_title\"></div>    <div class=\"pcp_zhengzi\"> 我支持AGPS/GPS，并预装导航软件，甭管到哪里，咱都不会迷路啦！</div></td>  </tr></table><style type=\"text/css\"></style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td  width=\"442\"><div class=\"pcp_title\"></div>    <div class=\"pcp_zhengzi\"> 我还预装了搜狗输入法，不仅支持拼音、笔画，还能手写呢，想怎么输入咱都行！</div></td>    <td width=\"360\" height=\"210\" align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFk-z4ikIAAAAAAAm4caJ7PQAAA8fgDc-q0AACb5505.jpg\" /></td>  </tr></table><style type=\"text/css\"></style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td width=\"360\" height=\"210\" align=\"center\" ><img src=\"http://img30.360buyimg.com/erpWareDetail/g3/M03/04/1A/rBEGE0-z4jAIAAAAAAAsZg8YJGsAAA8fAEJ7fIAACx-181.jpg\" /></td>    <td width=\"442\"><div class=\"pcp_title\"></div>    <div class=\"pcp_zhengzi\"> 我有独特的智能距离感应器，当您接电话靠近我时，我就会自动熄灭屏幕，拿开我时，会自动点亮屏幕，不仅方便，还能给你省电呢！</div></td>  </tr></table><style type=\"text/css\"></style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td  width=\"442\"><div class=\"pcp_title\"></div>    <div class=\"pcp_zhengzi\"> 您是否还经常为漏装、查找没有安装的程序苦恼呢？现在不用啦，我预装&ldquo;轻松安装&rdquo;程序，只需轻轻一点，就能自动扫描没有安装的程序，很给力！</div></td>    <td width=\"360\" height=\"210\" align=\"center\"><img src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFU-z4kYIAAAAAAAl0CzTzJEAAA8fgDdIaYAACXo291.jpg\" /></td>  </tr></table><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\"><img src=\"http://img30.360buyimg.com/jgsq-productsoa/g3/M03/00/06/rBEGE0-LjmIIAAAAAACR6dxSFkQAAACkgBBPuMAAJIB597.jpg\" /></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g1/M05/04/1A/rBEGDk-z4k0IAAAAAABwGmBbPjkAAA8fgI0wH8AAHAy589.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g2/M04/04/1A/rBEGEE-z4joIAAAAAABgb1ZKZKIAAA8gwGfqVYAAGCH432.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g4/M05/04/1A/rBEGFU-z4loIAAAAAAEjIcFYfd8AAA8fgDdR44AASM5754.jpg\" border=\"0\" /></div></td>  </tr></table><style>.bigapic{ width:750px; height:auto;}</style><table width=\"750\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">  <tr>    <td align=\"center\" valign=\"middle\"><div class=\"bigapic\"><img  src=\"http://img30.360buyimg.com/erpWareDetail/g3/M03/04/1A/rBEGFE-z4lYIAAAAAAAR0WQ-QcQAAA8fAEKGnAAABHp355.jpg\" border=\"0\" /></div></td>  </tr></table>', '2015-03-08 21:33:18', '2015-03-08 21:33:18');

-- ----------------------------
-- Table structure for tb_item_param
-- ----------------------------
DROP TABLE IF EXISTS `tb_item_param`;
CREATE TABLE `tb_item_param` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `item_cat_id` bigint(20) DEFAULT NULL COMMENT '商品类目ID',
  `param_data` text COMMENT '参数数据，格式为json格式',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item_cat_id` (`item_cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='商品规则参数';

-- ----------------------------
-- Records of tb_item_param
-- ----------------------------
INSERT INTO `tb_item_param` VALUES ('1', '3', '[{\"group\":\"组名1\",\"params\":[\"组员1\",\"组员2\"]},{\"group\":\"组名2\",\"params\":[\"组员1\",\"组员2\"]},{\"group\":\"组名3\",\"params\":[\"组员1\",\"组员2\",\"组员3\",\"组员4\"]}]', '2015-04-03 10:21:22', '2015-04-03 10:21:22');
INSERT INTO `tb_item_param` VALUES ('2', '560', '[{\"group\":\"主体\",\"params\":[\"品牌\",\"型号\",\"颜色\",\"上市年份\"]},{\"group\":\"网络\",\"params\":[\"4G网络制式\",\"3G网络制式\",\"2G网络制式\"]},{\"group\":\"存储\",\"params\":[\"机身内存\",\"储存卡类型\"]}]', '2015-04-03 10:40:12', '2015-04-03 10:40:12');
INSERT INTO `tb_item_param` VALUES ('3', '298', '[{\"group\":\"g1\",\"params\":[\"aa\",\"bb\",\"cc\"]},{\"group\":\"g2\",\"params\":[\"ad\",\"sd\"]},{\"group\":\"g3\",\"params\":[\"sdd\",\"sdfs\",\"dfg\"]}]', '2015-06-05 11:59:45', '2015-06-05 11:59:45');
INSERT INTO `tb_item_param` VALUES ('21', '440', '[{\"group\":\"1\",\"params\":[\"2w\"]},{\"group\":\"2\",\"params\":[\"1\"]},{\"group\":\"3\",\"params\":[\"1\"]},{\"group\":\"4\",\"params\":[\"1\"]}]', '2015-06-05 12:04:41', '2015-06-05 12:04:41');
INSERT INTO `tb_item_param` VALUES ('22', '298', '[{\"group\":\"f1\",\"params\":[\"1\"]},{\"group\":\"f2\",\"params\":[\"2\"]}]', '2015-06-05 12:08:07', '2015-06-05 12:08:07');
INSERT INTO `tb_item_param` VALUES ('23', '257', '[{\"group\":\"12\",\"params\":[\"12\"]}]', '2015-06-05 12:10:45', '2015-06-05 12:10:45');
INSERT INTO `tb_item_param` VALUES ('24', '443', '[{\"group\":\"股氯气\",\"params\":[\"撒旦法\"]}]', '2015-06-05 12:11:16', '2015-06-05 12:11:16');
INSERT INTO `tb_item_param` VALUES ('25', '298', '[{\"group\":\"1\",\"params\":[\"1\"]}]', '2015-06-05 12:21:01', '2015-06-05 12:21:01');
INSERT INTO `tb_item_param` VALUES ('26', '582', '[{\"group\":\"分组1\",\"params\":[\"参数1\",\"参数2\",\"参数3\",\"参数4\",\"参数5\"]},{\"group\":\"分组2\",\"params\":[\"参数21\",\"参数22\",\"参数23\",\"参数24\"]}]', '2015-07-23 16:44:32', '2015-07-23 16:44:32');

-- ----------------------------
-- Table structure for tb_item_param_item
-- ----------------------------
DROP TABLE IF EXISTS `tb_item_param_item`;
CREATE TABLE `tb_item_param_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) DEFAULT NULL COMMENT '商品ID',
  `param_data` text COMMENT '参数数据，格式为json格式',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item_id` (`item_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='商品规格和商品的关系表';

-- ----------------------------
-- Records of tb_item_param_item
-- ----------------------------
INSERT INTO `tb_item_param_item` VALUES ('1', '48', '[{\"group\":\"主体\",\"params\":[{\"k\":\"品牌\",\"v\":\"苹果（Apple）\"},{\"k\":\"型号\",\"v\":\"iPhone 6 A1586\"},{\"k\":\"颜色\",\"v\":\"金色\"},{\"k\":\"上市年份\",\"v\":\"2014\"}]},{\"group\":\"网络\",\"params\":[{\"k\":\"4G网络制式\",\"v\":\"移动4G(TD-LTE)/联通4G(FDD-LTE)/电信4G(FDD-LTE)\"},{\"k\":\"3G网络制式\",\"v\":\"移动3G(TD-SCDMA)/联通3G(WCDMA)/电信3G（CDMA2000）\"},{\"k\":\"2G网络制式\",\"v\":\"移动2G/联通2G(GSM)/电信2G(CDMA)\"}]},{\"group\":\"存储\",\"params\":[{\"k\":\"机身内存\",\"v\":\"16GB ROM\"},{\"k\":\"储存卡类型\",\"v\":\"不支持\"}]}]', '2015-04-03 10:52:55', '2015-04-03 10:52:55');
INSERT INTO `tb_item_param_item` VALUES ('2', '1188043', '[{\"group\":\"主体\",\"params\":[{\"k\":\"品牌\",\"v\":\"锤子\"},{\"k\":\"型号\",\"v\":\"T1(SM705)\"},{\"k\":\"颜色\",\"v\":\"黑色\"},{\"k\":\"上市年份\",\"v\":\"2014年\"}]},{\"group\":\"网络\",\"params\":[{\"k\":\"4G网络制式\",\"v\":\"移动4G（TD-LTE）/联通4G（FDD-LTE）\"},{\"k\":\"3G网络制式\",\"v\":\"移动3G(TD-SCDMA)/联通3G(WCDMA)\"},{\"k\":\"2G网络制式\",\"v\":\"移动2G/联通2G(GSM)\"}]},{\"group\":\"存储\",\"params\":[{\"k\":\"机身内存\",\"v\":\"32GB ROM\"},{\"k\":\"储存卡类型\",\"v\":\"2GB RAM\"}]}]', '2015-04-06 11:24:10', '2015-04-06 11:24:10');
INSERT INTO `tb_item_param_item` VALUES ('3', '1433500495290', '[{\"group\":\"主体\",\"params\":[{\"k\":\"品牌\",\"v\":\"1\"},{\"k\":\"型号\",\"v\":\"2\"},{\"k\":\"颜色\",\"v\":\"3\"},{\"k\":\"上市年份\",\"v\":\"4\"}]},{\"group\":\"网络\",\"params\":[{\"k\":\"4G网络制式\",\"v\":\"a\"},{\"k\":\"3G网络制式\",\"v\":\"b\"},{\"k\":\"2G网络制式\",\"v\":\"c\"}]},{\"group\":\"存储\",\"params\":[{\"k\":\"机身内存\",\"v\":\"de\"},{\"k\":\"储存卡类型\",\"v\":\"ef\"}]}]', '2015-06-05 18:34:52', '2015-06-05 18:34:52');
INSERT INTO `tb_item_param_item` VALUES ('4', '1001434271015869', '[{\"group\":\"主体\",\"params\":[{\"k\":\"品牌\",\"v\":\"华为（HUAWEI）\"},{\"k\":\"型号\",\"v\":\"P8\"},{\"k\":\"颜色\",\"v\":\"皓月银\"},{\"k\":\"上市年份\",\"v\":\"2015年\"}]},{\"group\":\"网络\",\"params\":[{\"k\":\"4G网络制式\",\"v\":\"移动4G(TDD-LTE)/联通4G(TDD-LTE/FDD-LTE)\"},{\"k\":\"3G网络制式\",\"v\":\"移动3G(TD-SCDMA)/联通3G(WCDMA)\"},{\"k\":\"2G网络制式\",\"v\":\"移动2G/联通2G(GSM)\"}]},{\"group\":\"存储\",\"params\":[{\"k\":\"机身内存\",\"v\":\"16GB ROM\"},{\"k\":\"储存卡类型\",\"v\":\"MicroSD(TF)\"}]}]', '2015-06-14 16:36:55', '2015-06-14 16:36:55');
INSERT INTO `tb_item_param_item` VALUES ('5', '101434521126763', '[{\"group\":\"组名1\",\"params\":[{\"k\":\"组员1\",\"v\":\"a\"},{\"k\":\"组员2\",\"v\":\"a\"}]},{\"group\":\"组名2\",\"params\":[{\"k\":\"组员1\",\"v\":\"sd\"},{\"k\":\"组员2\",\"v\":\"ss\"}]},{\"group\":\"组名3\",\"params\":[{\"k\":\"组员1\",\"v\":\"sd\"},{\"k\":\"组员2\",\"v\":\"sd\"},{\"k\":\"组员3\",\"v\":\"sd\"},{\"k\":\"组员4\",\"v\":\"sda\"}]}]', '2015-06-17 14:05:26', '2015-06-17 14:05:26');
INSERT INTO `tb_item_param_item` VALUES ('8', '143771131488369', '[{\"group\":\"主体\",\"params\":[{\"k\":\"品牌\",\"v\":\"1\"},{\"k\":\"型号\",\"v\":\"1\"},{\"k\":\"颜色\",\"v\":\"2\"},{\"k\":\"上市年份\",\"v\":\"3\"}]},{\"group\":\"网络\",\"params\":[{\"k\":\"4G网络制式\",\"v\":\"1\"},{\"k\":\"3G网络制式\",\"v\":\"2\"},{\"k\":\"2G网络制式\",\"v\":\"3\"}]},{\"group\":\"存储\",\"params\":[{\"k\":\"机身内存\",\"v\":\"4\"},{\"k\":\"储存卡类型\",\"v\":\"2\"}]}]', '2015-07-24 12:15:14', '2015-07-24 12:15:14');

-- ----------------------------
-- Table structure for tb_order
-- ----------------------------
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
  `order_id` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '订单id',
  `payment` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '实付金额。精确到2位小数;单位:元。如:200.07，表示:200元7分',
  `payment_type` int(2) DEFAULT NULL COMMENT '支付类型，1、在线支付，2、货到付款',
  `post_fee` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '邮费。精确到2位小数;单位:元。如:200.07，表示:200元7分',
  `status` int(10) DEFAULT NULL COMMENT '状态：1、未付款，2、已付款，3、未发货，4、已发货，5、交易成功，6、交易关闭',
  `create_time` datetime DEFAULT NULL COMMENT '订单创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '订单更新时间',
  `payment_time` datetime DEFAULT NULL COMMENT '付款时间',
  `consign_time` datetime DEFAULT NULL COMMENT '发货时间',
  `end_time` datetime DEFAULT NULL COMMENT '交易完成时间',
  `close_time` datetime DEFAULT NULL COMMENT '交易关闭时间',
  `shipping_name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '物流名称',
  `shipping_code` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '物流单号',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `buyer_message` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '买家留言',
  `buyer_nick` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '买家昵称',
  `buyer_rate` int(2) DEFAULT NULL COMMENT '买家是否已经评价',
  PRIMARY KEY (`order_id`),
  KEY `create_time` (`create_time`),
  KEY `buyer_nick` (`buyer_nick`),
  KEY `status` (`status`),
  KEY `payment_type` (`payment_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of tb_order
-- ----------------------------

-- ----------------------------
-- Table structure for tb_order_item
-- ----------------------------
DROP TABLE IF EXISTS `tb_order_item`;
CREATE TABLE `tb_order_item` (
  `id` varchar(20) COLLATE utf8_bin NOT NULL,
  `item_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '商品id',
  `order_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '订单id',
  `num` int(10) DEFAULT NULL COMMENT '商品购买数量',
  `title` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '商品标题',
  `price` bigint(50) DEFAULT NULL COMMENT '商品单价',
  `total_fee` bigint(50) DEFAULT NULL COMMENT '商品总金额',
  `pic_path` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '商品图片地址',
  PRIMARY KEY (`id`),
  KEY `item_id` (`item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of tb_order_item
-- ----------------------------

-- ----------------------------
-- Table structure for tb_order_shipping
-- ----------------------------
DROP TABLE IF EXISTS `tb_order_shipping`;
CREATE TABLE `tb_order_shipping` (
  `order_id` varchar(50) NOT NULL COMMENT '订单ID',
  `receiver_name` varchar(20) DEFAULT NULL COMMENT '收货人全名',
  `receiver_phone` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `receiver_mobile` varchar(30) DEFAULT NULL COMMENT '移动电话',
  `receiver_state` varchar(10) DEFAULT NULL COMMENT '省份',
  `receiver_city` varchar(10) DEFAULT NULL COMMENT '城市',
  `receiver_district` varchar(20) DEFAULT NULL COMMENT '区/县',
  `receiver_address` varchar(200) DEFAULT NULL COMMENT '收货地址，如：xx路xx号',
  `receiver_zip` varchar(6) DEFAULT NULL COMMENT '邮政编码,如：310001',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_order_shipping
-- ----------------------------

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码，加密存储',
  `phone` varchar(20) DEFAULT NULL COMMENT '注册手机号',
  `email` varchar(50) DEFAULT NULL COMMENT '注册邮箱',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `phone` (`phone`) USING BTREE,
  UNIQUE KEY `email` (`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('1', 'zhangsan', 'e10adc3949ba59abbe56e057f20f883e', '13488888888', 'aa@a.cn', '2015-04-06 17:03:55', '2015-04-06 17:03:55');
INSERT INTO `tb_user` VALUES ('2', 'lisi', '202cb962ac59075b964b07152d234b70', '12344444444', null, '2015-06-19 10:02:11', '2015-06-19 10:02:11');
INSERT INTO `tb_user` VALUES ('3', 'tidy', '202cb962ac59075b964b07152d234b70', '13600112243', null, '2015-07-30 17:26:25', '2015-07-30 17:26:25');
INSERT INTO `tb_user` VALUES ('4', 'niuniu', '202cb962ac59075b964b07152d234b70', '15866777744', '', '2015-08-01 11:48:42', '2015-08-01 11:48:42');

```

shopping

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README