宜立方商城 E3mall32 数据库脚本

/* 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'); INSERT INTO `tb_item` VALUES ('635906', '阿尔卡特 (OT-927) 单电版 炭黑 联通3G手机 双卡双待', '清仓！仅北京，武汉仓有货！', '24900', '99999', null, 'http://image.e3mall.cn/jd/9c1fcdf2bf20450788195c707da00a87.jpg', '560', '1', '2015-03-08 21:33:18', '2015-03-08 21:33:18'); INSERT INTO `tb_item` VALUES ('679532', '阿尔卡特 (OT-986+) 玫红 AK47 加强版 联通3G手机', '仅上海，广州，沈阳仓有货！预购从速！', '49900', '99999', null, 'http://image.e3mall.cn/jd/65e2007d41dc4e3cb308833a1a910f8d.jpg', '560', '1', '2015-03-08 21:32:31', '2015-03-08 21:32:31'); INSERT INTO `tb_item` VALUES ('679533', '阿尔卡特 (OT-986+) 曜石黑 AK47 加强版 联通3G手机', '少量库存，抢完即止！<a target=\"blank\" href=\"http://sale.jd.com/act/bxYeI1346g.ht