/*
 Navicat Premium Data Transfer

 Source Server         : WUHAORAN
 Source Server Type    : MySQL
 Source Server Version : 50711
 Source Host           : localhost:3306
 Source Schema         : myproject

 Target Server Type    : MySQL
 Target Server Version : 50711
 File Encoding         : 65001

 Date: 24/02/2019 18:25:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `consignee` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人',
  `shipping` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货地址',
  `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `postcode` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
  `label` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 64 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES (63, 28, '111', '123456', '18512128010', '1111', NULL);
INSERT INTO `address` VALUES (57, 25, '4545', '1111111', '18512128010', '1111', NULL);
INSERT INTO `address` VALUES (60, 25, '111', '1111111', '18512128010', '1111', NULL);
INSERT INTO `address` VALUES (61, 26, '分公司答复', '1111111', '18512128010', '1111', NULL);
INSERT INTO `address` VALUES (62, 26, '吴Aran', '啊大大', '18512128010', '1111', NULL);

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `pwd` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '18512128010', 'e10adc3949ba59abbe56e057f20f883e');

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名',
  `pid` int(11) NOT NULL DEFAULT 0 COMMENT '父级id',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '分类路径信息',
  `display` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1-显示 2-隐藏',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 65 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (47, 'X1系列', 39, '0,39,', 1);
INSERT INTO `category` VALUES (46, '台机', 0, '0,', 1);
INSERT INTO `category` VALUES (45, '开创者系列', 0, '0,', 1);
INSERT INTO `category` VALUES (39, '黑色智慧', 0, '0,', 1);
INSERT INTO `category` VALUES (40, '飞行家系列', 0, '0,', 1);
INSERT INTO `category` VALUES (41, '工程师系列', 0, '0,', 1);
INSERT INTO `category` VALUES (42, '潮极客系列', 0, '0,', 1);
INSERT INTO `category` VALUES (43, '先锋派系列', 0, '0,', 1);
INSERT INTO `category` VALUES (44, '巨匠系列', 0, '0,', 1);
INSERT INTO `category` VALUES (48, 'X系列', 40, '0,40,', 1);
INSERT INTO `category` VALUES (49, 'T系列', 41, '0,41,', 1);
INSERT INTO `category` VALUES (50, 'S系列', 42, '0,42,', 1);
INSERT INTO `category` VALUES (51, 'E系列', 43, '0,43,', 1);
INSERT INTO `category` VALUES (52, 'P系列', 44, '0,44,', 1);
INSERT INTO `category` VALUES (53, 'R系列', 45, '0,45,', 1);
INSERT INTO `category` VALUES (54, '台式机', 46, '0,46,', 1);
INSERT INTO `category` VALUES (55, 'ThinkPad X1', 47, '0,39,47,', 1);
INSERT INTO `category` VALUES (57, 'ThinkPad X', 48, '0,40,48,', 1);
INSERT INTO `category` VALUES (58, 'ThinkPad T', 49, '0,41,49,', 1);
INSERT INTO `category` VALUES (59, 'ThinkPad S', 50, '0,42,50,', 1);
INSERT INTO `category` VALUES (60, 'ThinkPad E', 51, '0,43,51,', 1);
INSERT INTO `category` VALUES (61, 'ThinkPad p', 52, '0,44,52,', 1);
INSERT INTO `category` VALUES (62, 'ThinkPad R', 53, '0,45,53,', 1);
INSERT INTO `category` VALUES (63, '主机', 54, '0,46,54,', 1);

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL COMMENT '分类id',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名',
  `price` decimal(10, 2) NOT NULL COMMENT '商品价格',
  `stock` int(11) NOT NULL COMMENT '商品库存',
  `sold` int(11) NULL DEFAULT 0 COMMENT '已售数量',
  `up` tinyint(1) NULL DEFAULT 1 COMMENT '1-上架 2-下架',
  `hot` tinyint(1) NULL DEFAULT 2 COMMENT '1-热销 2-滞销',
  `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  `uptime` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (29, 55, 'ThinkPad X1 Carbon 2018 笔记本电脑', 9999.00, 1000, 0, 1, 1, 'i5-8250U/Windows 10 家庭版/8GB/256GB SSD/UHD 620显示芯片/黑色', 1544887101, NULL);
INSERT INTO `goods` VALUES (30, 57, 'ThinkPad X280 笔记本电脑', 6999.00, 1000, 0, 1, 1, 'i5-8250U/Windows 10 家庭版/8GB/256GB SSD/UHD 620显示芯片/HD/1年保修', 1544887153, NULL);
INSERT INTO `goods` VALUES (31, 58, 'ThinkPad T480 笔记本电脑', 8999.00, 1000, 0, 1, 1, 'i5-8250U/Windows 10 家庭版/8GB/1TB+128GB SSD/独显', 1544887226, NULL);
INSERT INTO `goods` VALUES (32, 59, 'ThinkPad New S2 2018 银色', 7499.00, 1000, 0, 1, 1, 'i5-8250U/Windows 10 家庭版/8GB/256GB SSD/UHD 620显示芯片/FHD/银色', 1544887420, NULL);
INSERT INTO `goods` VALUES (33, 60, 'ThinkPad  E480  笔记本电脑', 8999.00, 1000, 0, 1, 1, 'i5-8250U/Windows 10 家庭版/8GB/500GB+128GB SSD/独显/黑色', 1544887503, NULL);
INSERT INTO `goods` VALUES (34, 61, 'ThinkPad P52s 笔记本电脑', 99999.00, 1000, 0, 1, 1, 'i7-8550U/Windows 10 家庭版/8G/500GB/独显/黑色', 1544887566, NULL);
INSERT INTO `goods` VALUES (35, 62, 'ThinkPad R480 笔记本电脑', 9999.00, 1000, 0, 1, 1, 'i5-8250U/Windows 10 家庭版/8GB/500GB/独显', 1544887640, NULL);
INSERT INTO `goods` VALUES (36, 63, 'ThinkCentre E75 台式机', 8999.00, 1000, 0, 1, 1, 'i3-7100/Windows 10 家庭中文版/4GB/500GB/集显/光驱', 1544887684, NULL);

-- ----------------------------
-- Table structure for goodsimg
-- ----------------------------
DROP TABLE IF EXISTS `goodsimg`;
CREATE TABLE `goodsimg`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL COMMENT '商品id',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品图片名',
  `face` tinyint(1) NULL DEFAULT 2 COMMENT '1-封面 2-非封面',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 93 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goodsimg
-- ----------------------------
INSERT INTO `goodsimg` VALUES (92, 35, '201812155c15212d94c90.jpg', 1);
INSERT INTO `goodsimg` VALUES (91, 35, '201812155c15211ff296d.jpg', 2);
INSERT INTO `goodsimg` VALUES (90, 35, '201812155c15211462626.jpg', 2);
INSERT INTO `goodsimg` VALUES (89, 34, '201812155c15210776393.jpg', 1);
INSERT INTO `goodsimg` VALUES (88, 34, '201812155c1520fa685e8.jpg', 2);
INSERT INTO `goodsimg` VALUES (87, 34, '201812155c1520ed94de3.jpg', 2);
INSERT INTO `goodsimg` VALUES (86, 33, '201812155c1520d7d34f0.jpg', 1);
INSERT INTO `goodsimg` VALUES (85, 33, '201812155c1520c21ba7b.jpg', 2);
INSERT INTO `goodsimg` VALUES (84, 33, '201812155c1520adb6667.jpg', 2);
INSERT INTO `goodsimg` VALUES (83, 32, '201812155c1520839e9e7.jpg', 1);
INSERT INTO `goodsimg` VALUES (82, 32, '201812155c15207b25e51.jpg', 2);
INSERT INTO `goodsimg` VALUES (81, 32, '201812155c1520689f37f.jpg', 2);
INSERT INTO `goodsimg` VALUES (80, 31, '201812155c1520565097f.jpg', 1);
INSERT INTO `goodsimg` VALUES (79, 31, '201812155c15204ab4490.jpg', 2);
INSERT INTO `goodsimg` VALUES (78, 31, '201812155c15203e8b580.jpg', 2);
INSERT INTO `goodsimg` VALUES (77, 30, '201812155c15202be79cf.jpg', 1);
INSERT INTO `goodsimg` VALUES (76, 30, '201812155c152022dd7a1.jpg', 2);
INSERT INTO `goodsimg` VALUES (75, 30, '201812155c152019df0f7.jpg', 2);
INSERT INTO `goodsimg` VALUES (74, 29, '201812155c15200b189c8.jpg', 2);
INSERT INTO `goodsimg` VALUES (73, 29, '201812155c15200174079.jpg', 1);
INSERT INTO `goodsimg` VALUES (72, 29, '201812155c151ff914741.jpg', 2);
INSERT INTO `goodsimg` VALUES (71, 36, '201812155c151e6bce500.jpg', 1);
INSERT INTO `goodsimg` VALUES (70, 36, '201812155c151e3ad011e.jpg', 2);
INSERT INTO `goodsimg` VALUES (69, 36, '201812155c151dff42db7.jpg', 2);

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `orderNum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单编号',
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `consignee` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收货人',
  `shipping` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收货地址',
  `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
  `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总价',
  `time` int(10) NULL DEFAULT NULL COMMENT '下单时间',
  `orderWay` tinyint(1) NULL DEFAULT 1 COMMENT '1-货到付款 2-在线支付',
  `status` tinyint(1) NULL DEFAULT 2 COMMENT '1-已发货 2-未发货 3-已收货',
  `isPay` tinyint(1) NULL DEFAULT 1 COMMENT '1-已支付 2-未支付',
  `cancel` tinyint(1) NULL DEFAULT 2 COMMENT '1-取消 2-未取消',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `orderNum`(`orderNum`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 94 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (88, '20181221823463', 28, '111', '123456', '18512128010', 16998.00, 1545363519, 1, 1, 1, 2);
INSERT INTO `orders` VALUES (90, '20181221339784', 28, '111', '123456', '18512128010', 9999.00, 1545372730, 1, 2, 1, 2);
INSERT INTO `orders` VALUES (91, '20181221664211', 28, '111', '123456', '18512128010', 0.00, 1545373125, 1, 2, 1, 2);
INSERT INTO `orders` VALUES (92, '20181221283806', 28, '111', '123456', '18512128010', 9999.00, 1545380976, 1, 2, 1, 2);
INSERT INTO `orders` VALUES (93, '20190221846316', 28, '111', '123456', '18512128010', 16998.00, 1550757156, 1, 2, 1, 2);

-- ----------------------------
-- Table structure for ordersgood
-- ----------------------------
DROP TABLE IF EXISTS `ordersgood`;
CREATE TABLE `ordersgood`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `oid` int(11) NOT NULL COMMENT '订单id',
  `gid` int(11) NOT NULL COMMENT '商品id',
  `price` decimal(10, 2) NOT NULL COMMENT '当时购买价格,不是最新价格',
  `count` int(11) NOT NULL COMMENT '数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of ordersgood
-- ----------------------------
INSERT INTO `ordersgood` VALUES (17, 67, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (18, 68, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (19, 69, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (20, 69, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (21, 69, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (22, 70, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (23, 71, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (24, 71, 31, 8999.00, 1);
INSERT INTO `ordersgood` VALUES (25, 72, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (26, 73, 36, 8999.00, 1);
INSERT INTO `ordersgood` VALUES (27, 74, 32, 7499.00, 1);
INSERT INTO `ordersgood` VALUES (28, 76, 31, 8999.00, 1);
INSERT INTO `ordersgood` VALUES (29, 77, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (30, 78, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (31, 79, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (32, 79, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (33, 81, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (34, 81, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (35, 82, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (36, 82, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (37, 82, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (38, 83, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (39, 83, 32, 7499.00, 1);
INSERT INTO `ordersgood` VALUES (40, 84, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (41, 84, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (42, 85, 31, 8999.00, 1);
INSERT INTO `ordersgood` VALUES (43, 86, 36, 8999.00, 1);
INSERT INTO `ordersgood` VALUES (44, 87, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (45, 88, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (46, 88, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (47, 89, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (48, 89, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (49, 90, 35, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (50, 92, 29, 9999.00, 1);
INSERT INTO `ordersgood` VALUES (51, 93, 30, 6999.00, 1);
INSERT INTO `ordersgood` VALUES (52, 93, 29, 9999.00, 1);

-- ----------------------------
-- Table structure for user_table
-- ----------------------------
DROP TABLE IF EXISTS `user_table`;
CREATE TABLE `user_table`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `account` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `nickname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` tinyint(1) NULL DEFAULT 1,
  `birthday` date NULL DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `regtime` int(10) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_table
-- ----------------------------
INSERT INTO `user_table` VALUES (25, '201812215c1c524c7304b.jpg', '18512128010', '6cf82ee1020caef069e753c67a97a70d', '455454', 1, '2018-12-10', 'ed', NULL, '18512128055', 1, NULL);
INSERT INTO `user_table` VALUES (27, '', '123456', 'e10adc3949ba59abbe56e057f20f883e', '1212', 1, NULL, NULL, NULL, '18512128010', 1, 1545357016);
INSERT INTO `user_table` VALUES (28, '201812215c1c524c7304b.jpg', '18512128010', 'e10adc3949ba59abbe56e057f20f883e', '455454', 1, '2018-12-10', 'ed', NULL, '18512128055', 1, 1545357036);
INSERT INTO `user_table` VALUES (29, '201812215c1c524c7304b.jpg', '18512128010', 'e10adc3949ba59abbe56e057f20f883e', '455454', 1, '2018-12-10', 'ed', NULL, '18512128055', 1, 1545357055);

SET FOREIGN_KEY_CHECKS = 1;