v2.0

分支 (3)

管理

管理

v2.0

master

v1.0

java_ecommerce_website
/
mmall.sql

/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50720
Source Host           : localhost:3306
Source Database       : business

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

Date: 2018-06-04 16:56:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `mmall_cart`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_cart`;
CREATE TABLE `mmall_cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL COMMENT '商品id',
  `quantity` int(11) DEFAULT NULL COMMENT '商品数量',
  `checked` int(11) DEFAULT NULL COMMENT '是否选择 1-已勾选 0未勾选',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `user_id_index` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mmall_cart
-- ----------------------------

-- ----------------------------
-- Table structure for `mmall_category`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_category`;
CREATE TABLE `mmall_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '类别ID',
  `parent_id` int(11) DEFAULT NULL COMMENT '父类别id 当id为0 时说明是根节点，一级类别，可扩展至无限层级',
  `name` varchar(50) DEFAULT NULL COMMENT '类别名称',
  `status` tinyint(1) DEFAULT '1' COMMENT '类别状态1-正常 2-已废弃   MYSQL中没有boolean类型，0表示false,1表示true',
  `sort_order` int(4) DEFAULT NULL COMMENT '排序编号，同类展示顺序，数值相等则自然排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100034 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mmall_category
-- ----------------------------
INSERT INTO `mmall_category` VALUES ('100001', '0', '家用电器', '1', null, '2017-03-25 16:46:00', '2017-03-25 16:46:00');
INSERT INTO `mmall_category` VALUES ('100002', '0', '数码3C', '1', null, '2017-03-25 16:46:21', '2017-03-25 16:46:21');
INSERT INTO `mmall_category` VALUES ('100003', '0', '服装箱包', '1', null, '2017-03-25 16:49:53', '2017-03-25 16:49:53');
INSERT INTO `mmall_category` VALUES ('100004', '0', '食品生鲜', '1', null, '2017-03-25 16:50:19', '2017-03-25 16:50:19');
INSERT INTO `mmall_category` VALUES ('100005', '0', '酒水饮料', '1', null, '2017-03-25 16:50:29', '2017-03-25 16:50:29');
INSERT INTO `mmall_category` VALUES ('100006', '100001', '冰箱', '1', null, '2017-03-25 16:52:15', '2017-03-25 16:52:15');
INSERT INTO `mmall_category` VALUES ('100007', '100001', '电视', '1', null, '2017-03-25 16:52:26', '2017-03-25 16:52:26');
INSERT INTO `mmall_category` VALUES ('100008', '100001', '洗衣机', '1', null, '2017-03-25 16:52:39', '2017-03-25 16:52:39');
INSERT INTO `mmall_category` VALUES ('100009', '100001', '空调', '1', null, '2017-03-25 16:52:45', '2017-03-25 16:52:45');
INSERT INTO `mmall_category` VALUES ('100010', '100001', '电热水器', '1', null, '2017-03-25 16:52:54', '2017-03-25 16:52:54');
INSERT INTO `mmall_category` VALUES ('100011', '100002', '电脑', '1', null, '2017-03-25 16:53:18', '2017-03-25 16:53:18');
INSERT INTO `mmall_category` VALUES ('100012', '100002', '手机', '1', null, '2017-03-25 16:53:27', '2017-03-25 16:53:27');
INSERT INTO `mmall_category` VALUES ('100013', '100002', '平板电脑', '1', null, '2017-03-25 16:53:35', '2017-03-25 16:53:35');
INSERT INTO `mmall_category` VALUES ('100014', '100002', '数码相机', '1', null, '2017-03-25 16:53:56', '2017-03-25 16:53:56');
INSERT INTO `mmall_category` VALUES ('100015', '100002', '3C配件', '1', null, '2017-03-25 16:54:07', '2017-03-25 16:54:07');
INSERT INTO `mmall_category` VALUES ('100016', '100003', '女装', '1', null, '2017-03-25 16:54:44', '2017-03-25 16:54:44');
INSERT INTO `mmall_category` VALUES ('100017', '100003', '帽子', '1', null, '2017-03-25 16:54:51', '2017-03-25 16:54:51');
INSERT INTO `mmall_category` VALUES ('100018', '100003', '旅行箱', '1', null, '2017-03-25 16:55:02', '2017-03-25 16:55:02');
INSERT INTO `mmall_category` VALUES ('100019', '100003', '手提包', '1', null, '2017-03-25 16:55:09', '2017-03-25 16:55:09');
INSERT INTO `mmall_category` VALUES ('100020', '100003', '保暖内衣', '1', null, '2017-03-25 16:55:18', '2017-03-25 16:55:18');
INSERT INTO `mmall_category` VALUES ('100021', '100004', '零食', '1', null, '2017-03-25 16:55:30', '2017-03-25 16:55:30');
INSERT INTO `mmall_category` VALUES ('100022', '100004', '生鲜', '1', null, '2017-03-25 16:55:37', '2017-03-25 16:55:37');
INSERT INTO `mmall_category` VALUES ('100023', '100004', '半成品菜', '1', null, '2017-03-25 16:55:47', '2017-03-25 16:55:47');
INSERT INTO `mmall_category` VALUES ('100024', '100004', '速冻食品', '1', null, '2017-03-25 16:55:56', '2017-03-25 16:55:56');
INSERT INTO `mmall_category` VALUES ('100025', '100004', '进口食品', '1', null, '2017-03-25 16:56:06', '2017-03-25 16:56:06');
INSERT INTO `mmall_category` VALUES ('100026', '100005', '白酒', '1', null, '2017-03-25 16:56:22', '2017-03-25 16:56:22');
INSERT INTO `mmall_category` VALUES ('100027', '100005', '红酒', '1', null, '2017-03-25 16:56:30', '2017-03-25 16:56:30');
INSERT INTO `mmall_category` VALUES ('100028', '100005', '饮料', '1', null, '2017-03-25 16:56:37', '2017-03-25 16:56:37');
INSERT INTO `mmall_category` VALUES ('100029', '100005', '调制鸡尾酒', '1', null, '2017-03-25 16:56:45', '2017-03-25 16:56:45');
INSERT INTO `mmall_category` VALUES ('100030', '100005', '进口洋酒', '1', null, '2017-03-25 16:57:05', '2017-03-25 16:57:05');
INSERT INTO `mmall_category` VALUES ('100031', '0', '已修改', '1', null, '2018-04-14 12:31:33', '2018-04-14 12:31:33');
INSERT INTO `mmall_category` VALUES ('100032', '0', '新增', '1', null, '2018-04-20 10:45:23', '2018-04-20 10:45:23');
INSERT INTO `mmall_category` VALUES ('100033', '0', '新增', '1', null, '2018-05-19 09:53:01', '2018-05-19 09:53:01');

-- ----------------------------
-- Table structure for `mmall_comment`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_comment`;
CREATE TABLE `mmall_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL COMMENT '产品id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `main_image` varchar(500) DEFAULT NULL COMMENT '商品主图',
  `comment_star` int(11) DEFAULT '5' COMMENT '星型评价',
  `comment_text` varchar(500) DEFAULT NULL COMMENT '商品评价正文',
  `delivery_comment` int(11) DEFAULT '5' COMMENT '快递评价',
  `comment_time` datetime DEFAULT NULL COMMENT '评论时间',
  `order_no` bigint(20) DEFAULT NULL COMMENT '订单号，根据订单号和产品id来唯一标识某个订单的某个产品是否已经评论过',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of mmall_comment
-- ----------------------------
INSERT INTO `mmall_comment` VALUES ('23', '26', '1', 'test.jpg', '4', '五星好评', '5', '2018-05-10 18:16:39', '1492091089794');
INSERT INTO `mmall_comment` VALUES ('25', '26', '1', 'test.jpg', '1', '五星好评', '5', '2018-05-10 18:19:13', '1491830695216');
INSERT INTO `mmall_comment` VALUES ('26', '26', '1', 'test.jpg', '5', '五星好评', '5', '2018-05-10 18:20:53', '1492090946105');
INSERT INTO `mmall_comment` VALUES ('28', '26', '1', 'test.jpg', '5', '五星好评', '5', '2018-05-10 18:23:48', '1492091141269');
INSERT INTO `mmall_comment` VALUES ('29', '26', '1', 'test.jpg', '5', '五星好评', '5', '2018-05-10 18:56:07', '1525782450784');
INSERT INTO `mmall_comment` VALUES ('30', '28', '1', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1', '五星好评', '1', '2018-05-19 10:40:16', '1526695967001');
INSERT INTO `mmall_comment` VALUES ('31', '28', '1', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '5', '五星好评', '1', '2018-05-19 10:48:17', '1526698014860');

-- ----------------------------
-- Table structure for `mmall_order`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_order`;
CREATE TABLE `mmall_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `order_no` bigint(20) DEFAULT NULL COMMENT '订单号',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `shipping_id` int(11) DEFAULT NULL,
  `payment` decimal(20,2) DEFAULT NULL COMMENT '实际付款金额。两位小数',
  `payment_type` int(4) DEFAULT NULL COMMENT '支付类型 1-在线支付',
  `postage` int(10) DEFAULT NULL COMMENT '运费',
  `status` int(10) DEFAULT NULL COMMENT '订单状态 0-已取消 10-未付款 20-已付款 40-已发货 50-交易成功 60-交易关闭',
  `payment_time` datetime DEFAULT NULL COMMENT '支付时间',
  `send_time` datetime DEFAULT NULL COMMENT '发货时间',
  `end_time` datetime DEFAULT NULL COMMENT '交易完成时间',
  `close_time` datetime DEFAULT NULL COMMENT '交易关闭时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `com` varchar(64) DEFAULT NULL COMMENT '快递公司',
  `delivery_no` varchar(100) DEFAULT NULL COMMENT '快递单号',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_no_index` (`order_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mmall_order
-- ----------------------------
INSERT INTO `mmall_order` VALUES ('113', '1492091089794', '1', '29', '6999.00', '1', '0', '40', null, '2018-05-08 16:35:20', null, null, '2017-04-13 21:44:49', '2018-05-08 16:35:20', 'JD', '73320347514');
INSERT INTO `mmall_order` VALUES ('114', '1492091096400', '1', '29', '6598.00', '1', '0', '40', null, '2018-05-08 16:36:29', null, null, '2017-04-13 21:44:56', '2018-05-08 16:36:29', 'YTO', '889410701323964211');
INSERT INTO `mmall_order` VALUES ('115', '1492091102371', '1', '29', '3299.00', '1', '0', '0', null, null, null, null, '2017-04-13 21:45:02', '2018-05-08 12:58:09', '', '');
INSERT INTO `mmall_order` VALUES ('116', '1492091110004', '1', '29', '8598.00', '1', '0', '40', '2017-04-13 21:55:16', '2017-04-13 21:55:31', null, null, '2017-04-13 21:45:09', '2018-05-08 12:58:39', '', '');
INSERT INTO `mmall_order` VALUES ('117', '1492091141269', '1', '29', '22894.00', '1', '0', '40', '2017-04-13 21:46:06', '2018-04-17 21:06:38', null, null, '2017-04-13 21:45:41', '2018-05-08 13:00:30', '', '');
INSERT INTO `mmall_order` VALUES ('118', '120120120120', '1', '25', '199.00', '1', '0', '10', null, null, null, null, null, null, null, null);
INSERT INTO `mmall_order` VALUES ('119', '1492091141270', '1', '29', '3000.00', '1', '0', '10', null, null, null, null, null, null, null, null);
INSERT INTO `mmall_order` VALUES ('120', '1492091141271', '1', '29', '2000.00', '1', '0', '10', null, null, null, null, null, null, null, null);
INSERT INTO `mmall_order` VALUES ('122', null, '1', '29', '3000.00', '1', '0', '40', '2018-04-17 12:29:16', '2018-05-08 15:35:13', null, null, null, null, 'JD', '73320347514');
INSERT INTO `mmall_order` VALUES ('123', '1492091141276', '1', '29', '30.00', '1', '0', '40', '2018-04-17 12:33:31', '2018-05-08 15:38:02', null, null, null, null, 'JD', '73320347514');
INSERT INTO `mmall_order` VALUES ('124', '1492091141277', '1', '29', '100.00', '1', '0', '20', '2018-04-17 12:39:13', null, null, null, null, null, null, null);
INSERT INTO `mmall_order` VALUES ('125', '1492091141278', '1', '29', '2000.00', '1', '0', '10', null, null, null, null, null, null, null, null);
INSERT INTO `mmall_order` VALUES ('126', '1523962819603', '1', '7', '19990.00', '1', '0', '0', null, null, null, null, '2018-04-17 19:00:19', '2018-04-17 19:00:19', null, null);
INSERT INTO `mmall_order` VALUES ('127', '1523968864492', '1', '7', '19990.00', '1', '0', '0', null, null, null, null, '2018-04-17 20:41:04', '2018-04-17 20:41:04', null, null);
INSERT INTO `mmall_order` VALUES ('128', '1523969112887', '1', '7', '19990.00', '1', '0', '0', null, null, null, null, '2018-04-17 20:45:12', '2018-05-08 14:10:40', 'YTO', '889410701323964211');
INSERT INTO `mmall_order` VALUES ('129', '1525321851051', '1', '7', '19990.00', '1', '0', '0', null, null, null, null, '2018-05-03 12:30:50', '2018-05-08 14:08:22', 'JD', '73320347514');
INSERT INTO `mmall_order` VALUES ('130', '1525779674537', '1', '7', '19990.00', '1', '0', '10', null, null, null, null, '2018-05-08 19:41:14', '2018-05-08 19:41:14', null, null);
INSERT INTO `mmall_order` VALUES ('131', '1525779981900', '1', '7', '19990.00', '1', '0', '10', null, null, null, null, '2018-05-08 19:46:21', '2018-05-08 19:46:21', null, null);
INSERT INTO `mmall_order` VALUES ('132', '1525780524908', '1', '7', '19990.00', '1', '0', '10', null, null, null, null, '2018-05-08 19:55:24', '2018-05-08 19:55:24', null, null);
INSERT INTO `mmall_order` VALUES ('133', '1525782450784', '1', '7', '19990.00', '1', '0', '10', null, null, null, null, '2018-05-08 20:27:30', '2018-05-08 20:27:30', null, null);
INSERT INTO `mmall_order` VALUES ('134', '1526011908230', '1', '7', '30000.00', '1', '0', '10', null, null, null, null, '2018-05-11 12:11:48', '2018-05-11 12:11:48', null, null);
INSERT INTO `mmall_order` VALUES ('135', '1526102608351', '1', '7', '60000.00', '1', '0', '10', null, null, null, null, '2018-05-12 13:23:28', '2018-05-12 13:23:28', null, null);
INSERT INTO `mmall_order` VALUES ('136', '1526105594334', '1', '7', '90000.00', '1', '0', '10', null, null, null, null, '2018-05-12 14:13:14', '2018-05-12 14:13:14', null, null);
INSERT INTO `mmall_order` VALUES ('137', '1526113012130', '1', '7', '19990.00', '1', '0', '10', null, null, null, null, '2018-05-12 16:16:52', '2018-05-12 16:16:52', null, null);
INSERT INTO `mmall_order` VALUES ('138', '1526695967001', '1', '7', '39980.00', '1', '0', '40', '2018-05-19 10:13:24', '2018-05-19 10:17:04', null, null, '2018-05-19 10:12:46', '2018-05-19 10:17:04', 'JD', '73320347514');
INSERT INTO `mmall_order` VALUES ('139', '1526698014860', '1', '7', '19990.00', '1', '0', '40', '2018-05-19 10:47:45', '2018-05-19 10:48:34', null, null, '2018-05-19 10:46:54', '2018-05-19 10:48:34', 'JD', '73320347514');

-- ----------------------------
-- Table structure for `mmall_order_item`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_order_item`;
CREATE TABLE `mmall_order_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `order_no` bigint(20) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL COMMENT '商品id',
  `product_name` varchar(100) DEFAULT NULL COMMENT '商品名称',
  `product_image` varchar(500) DEFAULT NULL COMMENT '商品图片地址',
  `current_unit_price` decimal(20,2) DEFAULT NULL COMMENT '生成订单时的单价',
  `quantity` int(10) DEFAULT NULL COMMENT '商品数量',
  `total_price` decimal(20,2) DEFAULT NULL COMMENT '商品总价，保留两位小数',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_no_index` (`order_no`) USING BTREE,
  KEY `order_no_user_id_index` (`user_id`,`order_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mmall_order_item
-- ----------------------------
INSERT INTO `mmall_order_item` VALUES ('113', '1', '1491753014256', '26', 'Apple iPhone 7 Plus (A1661) 128G 玫瑰金色 移动联通电信4G手机', '241997c4-9e62-4824-b7f0-7425c3c28917.jpeg', '6999.00', '2', '13998.00', '2017-04-09 23:50:14', '2017-04-09 23:50:14');
INSERT INTO `mmall_order_item` VALUES ('114', '1', '1491830695216', '26', 'Apple iPhone 7 Plus (A1661) 128G 玫瑰金色 移动联通电信4G手机', '241997c4-9e62-4824-b7f0-7425c3c28917.jpeg', '6999.00', '2', '13998.00', '2017-04-10 21:24:55', '2017-04-10 21:24:55');
INSERT INTO `mmall_order_item` VALUES ('115', '1', '1492089528889', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '1', '3299.00', '2017-04-13 21:18:48', '2017-04-13 21:18:48');
INSERT INTO `mmall_order_item` VALUES ('116', '1', '1492090946105', '29', 'Haier/海尔HJ100-1HU1 10公斤滚筒洗衣机全自动带烘干家用大容量 洗烘一体', '173335a4-5dce-4afd-9f18-a10623724c4e.jpeg', '4299.00', '2', '8598.00', '2017-04-13 21:42:26', '2017-04-13 21:42:26');
INSERT INTO `mmall_order_item` VALUES ('117', '1', '1492090946105', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '1', '1999.00', '2017-04-13 21:42:26', '2017-04-13 21:42:26');
INSERT INTO `mmall_order_item` VALUES ('118', '1', '1492090946105', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '1', '3299.00', '2017-04-13 21:42:26', '2017-04-13 21:42:26');
INSERT INTO `mmall_order_item` VALUES ('119', '1', '1492090946105', '26', 'Apple iPhone 7 Plus (A1661) 128G 玫瑰金色 移动联通电信4G手机', '241997c4-9e62-4824-b7f0-7425c3c28917.jpeg', '6999.00', '2', '13998.00', '2017-04-13 21:42:26', '2017-04-13 21:42:26');
INSERT INTO `mmall_order_item` VALUES ('120', '1', '1492091003128', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '2', '6598.00', '2017-04-13 21:43:23', '2017-04-13 21:43:23');
INSERT INTO `mmall_order_item` VALUES ('121', '1', '1492091003128', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '1', '1999.00', '2017-04-13 21:43:23', '2017-04-13 21:43:23');
INSERT INTO `mmall_order_item` VALUES ('122', '1', '1492091051313', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '1', '1999.00', '2017-04-13 21:44:11', '2017-04-13 21:44:11');
INSERT INTO `mmall_order_item` VALUES ('123', '1', '1492091061513', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '2', '6598.00', '2017-04-13 21:44:21', '2017-04-13 21:44:21');
INSERT INTO `mmall_order_item` VALUES ('124', '1', '1492091069563', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '1', '3299.00', '2017-04-13 21:44:29', '2017-04-13 21:44:29');
INSERT INTO `mmall_order_item` VALUES ('125', '1', '1492091076073', '29', 'Haier/海尔HJ100-1HU1 10公斤滚筒洗衣机全自动带烘干家用大容量 洗烘一体', '173335a4-5dce-4afd-9f18-a10623724c4e.jpeg', '4299.00', '1', '4299.00', '2017-04-13 21:44:36', '2017-04-13 21:44:36');
INSERT INTO `mmall_order_item` VALUES ('126', '1', '1492091083720', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '1', '3299.00', '2017-04-13 21:44:43', '2017-04-13 21:44:43');
INSERT INTO `mmall_order_item` VALUES ('127', '1', '1492091089794', '26', 'Apple iPhone 7 Plus (A1661) 128G 玫瑰金色 移动联通电信4G手机', '241997c4-9e62-4824-b7f0-7425c3c28917.jpeg', '6999.00', '1', '6999.00', '2017-04-13 21:44:49', '2017-04-13 21:44:49');
INSERT INTO `mmall_order_item` VALUES ('128', '1', '1492091096400', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '2', '6598.00', '2017-04-13 21:44:56', '2017-04-13 21:44:56');
INSERT INTO `mmall_order_item` VALUES ('129', '1', '1492091102371', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '1', '3299.00', '2017-04-13 21:45:02', '2017-04-13 21:45:02');
INSERT INTO `mmall_order_item` VALUES ('130', '1', '1492091110004', '29', 'Haier/海尔HJ100-1HU1 10公斤滚筒洗衣机全自动带烘干家用大容量 洗烘一体', '173335a4-5dce-4afd-9f18-a10623724c4e.jpeg', '4299.00', '2', '8598.00', '2017-04-13 21:45:09', '2017-04-13 21:45:09');
INSERT INTO `mmall_order_item` VALUES ('131', '1', '1492091141269', '26', 'Apple iPhone 7 Plus (A1661) 128G 玫瑰金色 移动联通电信4G手机', '241997c4-9e62-4824-b7f0-7425c3c28917.jpeg', '6999.00', '1', '6999.00', '2017-04-13 21:45:41', '2017-04-13 21:45:41');
INSERT INTO `mmall_order_item` VALUES ('132', '1', '1492091141269', '27', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', '3299.00', '1', '3299.00', '2017-04-13 21:45:41', '2017-04-13 21:45:41');
INSERT INTO `mmall_order_item` VALUES ('133', '1', '1492091141269', '29', 'Haier/海尔HJ100-1HU1 10公斤滚筒洗衣机全自动带烘干家用大容量 洗烘一体', '173335a4-5dce-4afd-9f18-a10623724c4e.jpeg', '4299.00', '2', '8598.00', '2017-04-13 21:45:41', '2017-04-13 21:45:41');
INSERT INTO `mmall_order_item` VALUES ('134', '1', '1492091141269', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '2', '3998.00', '2017-04-13 21:45:41', '2017-04-13 21:45:41');
INSERT INTO `mmall_order_item` VALUES ('135', '1', '1523962819603', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-04-17 19:00:19', '2018-04-17 19:00:19');
INSERT INTO `mmall_order_item` VALUES ('136', '1', '1523968864492', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-04-17 20:41:04', '2018-04-17 20:41:04');
INSERT INTO `mmall_order_item` VALUES ('137', '1', '1523969112887', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-04-17 20:45:13', '2018-04-17 20:45:13');
INSERT INTO `mmall_order_item` VALUES ('138', '1', '1525321851051', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-05-03 12:30:51', '2018-05-03 12:30:51');
INSERT INTO `mmall_order_item` VALUES ('139', '1', '1525779674537', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-05-08 19:41:14', '2018-05-08 19:41:14');
INSERT INTO `mmall_order_item` VALUES ('140', '1', '1525779981900', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-05-08 19:46:21', '2018-05-08 19:46:21');
INSERT INTO `mmall_order_item` VALUES ('141', '1', '1525780524908', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-05-08 19:55:24', '2018-05-08 19:55:24');
INSERT INTO `mmall_order_item` VALUES ('142', '1', '1525782450784', '26', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-05-08 20:27:30', '2018-05-08 20:27:30');
INSERT INTO `mmall_order_item` VALUES ('143', '1', '1526011908230', '26', '三星洗衣机', 'test.jpg', '3000.00', '10', '30000.00', '2018-05-11 12:11:48', '2018-05-11 12:11:48');
INSERT INTO `mmall_order_item` VALUES ('144', '1', '1526102608351', '26', '三星洗衣机', 'test.jpg', '3000.00', '20', '60000.10', '2018-05-12 13:23:28', '2018-05-12 13:23:28');
INSERT INTO `mmall_order_item` VALUES ('145', '1', '1526105594334', '26', '三星洗衣机', 'test.jpg', '3000.00', '30', '90000.00', '2018-05-12 14:13:14', '2018-05-12 14:13:14');
INSERT INTO `mmall_order_item` VALUES ('146', '1', '1526113012130', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-05-12 16:16:52', '2018-05-12 16:16:52');
INSERT INTO `mmall_order_item` VALUES ('147', '1', '1526695967001', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '20', '39980.00', '2018-05-19 10:12:47', '2018-05-19 10:12:47');
INSERT INTO `mmall_order_item` VALUES ('148', '1', '1526698014860', '28', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '1999.00', '10', '19990.00', '2018-05-19 10:46:54', '2018-05-19 10:46:54');

-- ----------------------------
-- Table structure for `mmall_pay_info`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_pay_info`;
CREATE TABLE `mmall_pay_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `order_no` bigint(20) DEFAULT NULL COMMENT '订单号',
  `pay_platform` int(10) DEFAULT NULL COMMENT '支付平台1-支付宝 2-微信',
  `platform_number` varchar(200) DEFAULT NULL COMMENT '支付宝支付流水号',
  `platform_status` varchar(20) DEFAULT NULL COMMENT '支付宝支付状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mmall_pay_info
-- ----------------------------
INSERT INTO `mmall_pay_info` VALUES ('67', '1', '1492091141276', '1', '2018041721001004660200663807', 'TRADE_SUCCESS', '2018-04-17 12:33:33', '2018-04-17 12:33:33');
INSERT INTO `mmall_pay_info` VALUES ('68', '1', '1492091141275', '1', '2018041721001004660200663994', 'TRADE_SUCCESS', '2018-04-17 12:35:14', '2018-04-17 12:35:14');
INSERT INTO `mmall_pay_info` VALUES ('69', '1', '1492091141277', '1', '2018041721001004660200663995', 'TRADE_SUCCESS', '2018-04-17 12:39:15', '2018-04-17 12:39:15');
INSERT INTO `mmall_pay_info` VALUES ('70', '1', '1526695967001', '1', '2018051921001004660200683959', 'TRADE_SUCCESS', '2018-05-19 10:13:31', '2018-05-19 10:13:31');
INSERT INTO `mmall_pay_info` VALUES ('71', '1', '1526698014860', '1', '2018051921001004660200683960', 'TRADE_SUCCESS', '2018-05-19 10:47:50', '2018-05-19 10:47:50');

-- ----------------------------
-- Table structure for `mmall_product`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_product`;
CREATE TABLE `mmall_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `category_id` int(11) NOT NULL COMMENT '分类id，队友mmall_category表的主键',
  `name` varchar(100) NOT NULL COMMENT '商品名称',
  `subtitle` varchar(200) DEFAULT NULL COMMENT '商品副标题',
  `main_image` varchar(500) DEFAULT NULL COMMENT '产品主图，url相对地址',
  `sub_images` text COMMENT '图片地址，json格式，扩展用',
  `detail` text COMMENT '商品详情',
  `price` decimal(20,2) NOT NULL COMMENT '价格，两位小数',
  `stock` int(11) NOT NULL COMMENT '库存数量',
  `status` int(6) DEFAULT '1' COMMENT '商品状态1-在售2-下架3-删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `sale_acount` int(11) DEFAULT '0' COMMENT '销量',
  `praise` double(5,4) DEFAULT '0.1000' COMMENT '好评度，默认四位小数',
  `comment_num` int(11) DEFAULT NULL COMMENT '该商品的评论数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mmall_product
-- ----------------------------
INSERT INTO `mmall_product` VALUES ('26', '1', '三星洗衣机', '三星大促销', 'test.jpg', 'test.jpg', 'detailtext', '3000.00', '40', '1', null, '2018-05-12 14:13:14', '10', '0.7868', '1');
INSERT INTO `mmall_product` VALUES ('27', '100006', 'Midea/美的 BCD-535WKZM(E)冰箱双开门对开门风冷无霜智能电家用', '送品牌烤箱，五一大促', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg', 'ac3e571d-13ce-4fad-89e8-c92c2eccf536.jpeg,4bb02f1c-62d5-48cc-b358-97b05af5740d.jpeg,36bdb49c-72ae-4185-9297-78829b54b566.jpeg', '<p><img alt=\"miaoshu.jpg\" src=\"http://img.happymmall.com/9c5c74e6-6615-4aa0-b1fc-c17a1eff6027.jpg\" width=\"790\" height=\"444\"><br></p><p><img alt=\"miaoshu2.jpg\" src=\"http://img.happymmall.com/31dc1a94-f354-48b8-a170-1a1a6de8751b.jpg\" width=\"790\" height=\"1441\"><img alt=\"miaoshu3.jpg\" src=\"http://img.happymmall.com/7862594b-3063-4b52-b7d4-cea980c604e0.jpg\" width=\"790\" height=\"1442\"><img alt=\"miaoshu4.jpg\" src=\"http://img.happymmall.com/9a650563-dc85-44d6-b174-d6960cfb1d6a.jpg\" width=\"790\" height=\"1441\"><br></p>', '3299.00', '8879', '2', '2017-04-13 18:51:54', '2017-04-13 21:45:41', '0', '0.0000', '0');
INSERT INTO `mmall_product` VALUES ('28', '100012', '4+64G送手环/Huawei/华为 nova 手机P9/P10plus青春', 'NOVA青春版1999元', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg', '0093f5d3-bdb4-4fb0-bec5-5465dfd26363.jpeg,13da2172-4445-4eb5-a13f-c5d4ede8458c.jpeg,58d5d4b7-58d4-4948-81b6-2bae4f79bf02.jpeg', '<p><img alt=\"11TB2fKK3cl0kpuFjSsziXXa.oVXa_!!1777180618.jpg\" src=\"http://img.happymmall.com/5c2d1c6d-9e09-48ce-bbdb-e833b42ff664.jpg\" width=\"790\" height=\"966\"><img alt=\"22TB2YP3AkEhnpuFjSZFpXXcpuXXa_!!1777180618.jpg\" src=\"http://img.happymmall.com/9a10b877-818f-4a27-b6f7-62887f3fb39d.jpg\" width=\"790\" height=\"1344\"><img alt=\"33TB2Yyshk.hnpuFjSZFpXXcpuXXa_!!1777180618.jpg\" src=\"http://img.happymmall.com/7d7fbd69-a3cb-4efe-8765-423bf8276e3e.jpg\" width=\"790\" height=\"700\"><img alt=\"TB2diyziB8kpuFjSspeXXc7IpXa_!!1777180618.jpg\" src=\"http://img.happymmall.com/1d7160d2-9dba-422f-b2a0-e92847ba6ce9.jpg\" width=\"790\" height=\"393\"><br></p>', '1999.00', '9904', '1', '2017-04-13 18:57:18', '2018-05-19 10:48:17', '30', '0.4000', '2');
INSERT INTO `mmall_product` VALUES ('29', '100008', 'Haier/海尔HJ100-1HU1 10公斤滚筒洗衣机全自动带烘干家用大容量 洗烘一体', '门店机型 德邦送货', '173335a4-5dce-4afd-9f18-a10623724c4e.jpeg', '173335a4-5dce-4afd-9f18-a10623724c4e.jpeg,42b1b8bc-27c7-4ee1-80ab-753d216a1d49.jpeg,2f1b3de1-1eb1-4c18-8ca2-518934931bec.jpeg', '<p><img alt=\"1TB2WLZrcIaK.eBjSspjXXXL.XXa_!!2114960396.jpg\" src=\"http://img.happymmall.com/ffcce953-81bd-463c-acd1-d690b263d6df.jpg\" width=\"790\" height=\"920\"><img alt=\"2TB2zhOFbZCO.eBjSZFzXXaRiVXa_!!2114960396.jpg\" src=\"http://img.happymmall.com/58a7bd25-c3e7-4248-9dba-158ef2a90e70.jpg\" width=\"790\" height=\"1052\"><img alt=\"3TB27mCtb7WM.eBjSZFhXXbdWpXa_!!2114960396.jpg\" src=\"http://img.happymmall.com/2edbe9b3-28be-4a8b-a9c3-82e40703f22f.jpg\" width=\"790\" height=\"820\"><br></p>', '4299.00', '9993', '1', '2017-04-13 19:07:47', '2017-04-13 21:45:41', '0', '0.0000', '0');
INSERT INTO `mmall_product` VALUES ('30', '1', '三星洗衣机', '三星大促销', 'test.jpg', 'test.jpg', 'detailtext', '1000.00', '100', '1', '2018-04-14 20:47:22', '2018-04-14 20:47:22', '0', '0.0000', '0');
INSERT INTO `mmall_product` VALUES ('31', '1', '三星洗衣机', '三星大促销', 'test.jpg', 'test.jpg', 'detailtext', '2000.00', '100', '1', '2018-04-20 14:01:17', '2018-04-20 14:01:17', '5', '0.0000', '0');
INSERT INTO `mmall_product` VALUES ('32', '1', '三星洗衣机', '三星大促销', 'test.jpg', 'test.jpg', 'detailtext', '1000.00', '100', '1', '2018-05-19 09:55:30', '2018-05-19 09:55:30', null, null, null);

-- ----------------------------
-- Table structure for `mmall_shipping`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_shipping`;
CREATE TABLE `mmall_shipping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `receiver_name` varchar(20) DEFAULT NULL,
  `receiver_phone` varchar(20) DEFAULT NULL,
  `receiver_mobile` varchar(20) DEFAULT NULL,
  `receiver_province` varchar(20) DEFAULT NULL,
  `receiver_city` varchar(20) DEFAULT NULL,
  `receiver_district` varchar(20) DEFAULT NULL,
  `receiver_address` varchar(20) DEFAULT NULL,
  `receiver_zip` varchar(6) DEFAULT NULL COMMENT '邮编',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mmall_shipping
-- ----------------------------
INSERT INTO `mmall_shipping` VALUES ('4', '13', 'geely', '010', '18688888888', '北京', '北京市', '海淀区', '中关村', '100000', '2017-01-22 14:26:25', '2017-01-22 14:26:25');
INSERT INTO `mmall_shipping` VALUES ('7', '17', 'Rosen', '13800138000', '13800138000', '北京', '北京', null, '中关村', '100000', '2017-03-29 12:11:01', '2017-03-29 12:11:01');
INSERT INTO `mmall_shipping` VALUES ('8', '1', 'geely', '0107', '186888888887', '北京', '北京市', null, '中关村', '100000', '2018-04-17 13:53:53', '2018-04-17 13:53:53');
INSERT INTO `mmall_shipping` VALUES ('9', '1', 'geely', '0107', '186888888887', '北京', '北京市', null, '中关村', '100000', '2018-04-20 16:02:23', '2018-04-20 16:02:23');

-- ----------------------------
-- Table structure for `mmall_user`
-- ----------------------------
DROP TABLE IF EXISTS `mmall_user`;
CREATE TABLE `mmall_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户表id',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(50) NOT NULL COMMENT '用户密码，MD5加密',
  `email` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `question` varchar(100) DEFAULT NULL COMMENT '找回密码问题',
  `answer` varchar(100) DEFAULT NULL COMMENT '找回密码答案',
  `role` int(4) NOT NULL COMMENT '角色0-管理员1-普通用户',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '最后一次更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_name_unique` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of mmall_user
-- ----------------------------
INSERT INTO `mmall_user` VALUES ('1', 'admin', '427338237BD929443EC5D48E24FD2B1A', 'admin@happymmall.com', '13800138000', '问题', '答案', '1', '2016-11-06 16:56:45', '2017-04-04 19:27:36');
INSERT INTO `mmall_user` VALUES ('13', 'geely', '08E9A6EA287E70E7E3F7C982BF7923AC', 'geely@happymmall.com', '13800138000', '问题', '答案', '0', '2016-11-19 22:19:25', '2016-11-19 22:19:25');
INSERT INTO `mmall_user` VALUES ('17', 'rosen', '095AC193FE2212EEC7A93E8FEFF11902', 'rosen1@happymmall.com', '13800138000', '问题', '答案', '0', '2017-03-17 10:51:33', '2017-04-09 23:13:26');
INSERT INTO `mmall_user` VALUES ('21', 'soonerbetter', 'DE6D76FE7C40D5A1A8F04213F2BEFBEE', 'test06@happymmall.com', '13800138000', '105204', '105204', '0', '2017-04-13 21:26:22', '2017-04-13 21:26:22');
INSERT INTO `mmall_user` VALUES ('26', 'admin1', 'EFA5C7B600BBAA5E94F5373E162B41B9', 'test10@qq.com', '666', '问题', '回答', '0', '2018-04-15 15:00:06', '2018-04-15 15:00:06');