/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : u-shop

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

 Date: 10/01/2024 10:50:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员uid',
  `username` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收获人姓名',
  `userphone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货人手机号',
  `regioncode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行政区码，冗余字段，如：100,1001,10001',
  `location` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行政区字符串冗余字段：山东省，滨州市，无棣县',
  `useraddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货人详情地址，如：山东省滨州市无棣县县一中',
  `status` tinyint(1) NULL DEFAULT 0 COMMENT '默认地址状态：1是默认 0不是',
  `label` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '地址标签：公司、家、学校',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES (1, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', '关羽', '13716052241', '', '安徽省合肥市瑶海区', '五方桥中公教育基地', 0, '学校');
INSERT INTO `address` VALUES (21, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', '刘备', '13716052241', '', '山东省滨州市无棣县', '棣新一路圣豪购物广场', 0, '家');
INSERT INTO `address` VALUES (22, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', '周瑜', '13716052241', '', '北京市市辖区朝阳区', '五方桥中公教育基地', 0, '公司');
INSERT INTO `address` VALUES (23, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', '曹操', '13716052241', '', '北京市市辖区朝阳区', '五方桥中公教育基地', 1, '公司');
INSERT INTO `address` VALUES (33, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', '鲁班', '13788995678', '', '黑龙江省哈尔滨市道里区', '王者峡谷', 1, '学校');
INSERT INTO `address` VALUES (34, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', '鲁班大师', '13716052241', '', '山东省滨州市无棣县', '棣新一路', 0, '公司');
INSERT INTO `address` VALUES (35, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', '亚瑟', '13767782879', '', '山东省滨州市无棣县', '棣新一路', 1, '学校');

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '轮播图id',
  `first_cateid` int(11) NULL DEFAULT NULL COMMENT '一级商品分类',
  `second_cateid` int(11) NULL DEFAULT NULL COMMENT '商品二级分类',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图标题',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图图片地址',
  `status` tinyint(1) NOT NULL COMMENT '状态',
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '轮播图表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of banner
-- ----------------------------
INSERT INTO `banner` VALUES (1, NULL, NULL, '轮播图7', '/uploads/banner/27cae4c0-aea1-11ee-a2fe-472a241e7258.jpg', 1, NULL);
INSERT INTO `banner` VALUES (4, NULL, NULL, '轮播图6', '/uploads/banner/6e494a60-aeb3-11ee-9bcf-d919aa649679.jpg', 1, NULL);

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '购物车主键',
  `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `goodsid` int(11) NOT NULL COMMENT '商品编号',
  `num` tinyint(3) NOT NULL COMMENT '数量',
  `status` tinyint(1) NOT NULL COMMENT '选中状态',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uid`(`uid`, `goodsid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '购物车表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of cart
-- ----------------------------

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类编号',
  `pid` smallint(5) UNSIGNED NOT NULL COMMENT '上级分类编号',
  `catename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类图片',
  `status` tinyint(1) UNSIGNED NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, 0, '家用电器', '', 1);
INSERT INTO `category` VALUES (2, 1, '冰箱', '', 1);
INSERT INTO `category` VALUES (3, 1, '洗衣机', '', 1);
INSERT INTO `category` VALUES (4, 0, '水果', '', 1);
INSERT INTO `category` VALUES (5, 4, '苹果', '', 1);
INSERT INTO `category` VALUES (6, 4, '橙子', '', 1);
INSERT INTO `category` VALUES (7, 1, '电饭煲', '', 1);

-- ----------------------------
-- Table structure for code
-- ----------------------------
DROP TABLE IF EXISTS `code`;
CREATE TABLE `code`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `code` int(4) NULL DEFAULT NULL COMMENT '验证码',
  `addtime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of code
-- ----------------------------
INSERT INTO `code` VALUES (1, '13716052241', 1234, '1602333418000');
INSERT INTO `code` VALUES (2, '13716052241', 1111, '1602333418030');
INSERT INTO `code` VALUES (3, '13716052242', 7313, '1602336569581');
INSERT INTO `code` VALUES (4, '13716052245', 5768, '1602336608496');
INSERT INTO `code` VALUES (5, '13716052241', 1289, '1603412923487');
INSERT INTO `code` VALUES (6, '13716052241', 5275, '1610544545930');
INSERT INTO `code` VALUES (7, '13716052241', 1489, '1610590852378');
INSERT INTO `code` VALUES (8, '13716052241', 6830, '1611131913771');
INSERT INTO `code` VALUES (9, '13716052241', 8562, '1611192562187');
INSERT INTO `code` VALUES (10, '13716052241', 6515, '1611231827525');
INSERT INTO `code` VALUES (11, '13716052241', 8407, '1611573777821');
INSERT INTO `code` VALUES (12, '13716052241', 1055, '1611625595895');
INSERT INTO `code` VALUES (13, '13716052241', 6875, '1611648422899');

-- ----------------------------
-- Table structure for courier
-- ----------------------------
DROP TABLE IF EXISTS `courier`;
CREATE TABLE `courier`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `companyname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '快递公司代码',
  `companycode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '快递公司名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of courier
-- ----------------------------
INSERT INTO `courier` VALUES (1, '顺丰速运', 'SFSY');
INSERT INTO `courier` VALUES (2, '韵达快递', 'YDKD');
INSERT INTO `courier` VALUES (3, '圆通速递', 'YTSD');
INSERT INTO `courier` VALUES (4, '菜鸟裹裹', 'GUOGUO');
INSERT INTO `courier` VALUES (5, '德邦快递', 'DBKD');

-- ----------------------------
-- Table structure for evaluate
-- ----------------------------
DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户uid',
  `orderid` int(11) NULL DEFAULT NULL COMMENT '主订单id',
  `desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品评价描述',
  `addtime` datetime NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of evaluate
-- ----------------------------

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品编号',
  `first_cateid` smallint(5) UNSIGNED NOT NULL COMMENT '一级分类编号',
  `second_cateid` smallint(6) NOT NULL COMMENT '二级分类编号',
  `goodsname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
  `price` decimal(10, 2) NOT NULL COMMENT '商品价格',
  `market_price` decimal(10, 2) NOT NULL COMMENT '市场价格',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品图片',
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品描述',
  `specsid` int(11) NOT NULL COMMENT '规格id',
  `specsattr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则属性值',
  `isnew` tinyint(1) NOT NULL COMMENT '是否新品1是2不是',
  `ishot` tinyint(1) NOT NULL COMMENT '是否热卖1是2不是',
  `status` tinyint(1) NOT NULL COMMENT '状态1启用2禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, 1, 2, '格力冰箱', 1999.00, 1899.00, '', '<p>空间大</p>', 9, '黑色', 1, 1, 1);
INSERT INTO `goods` VALUES (2, 1, 3, '洗衣机11', 1299.00, 1199.00, '', '', 9, '黑色', 1, 1, 1);

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户编号',
  `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `avatarurl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/uploads/tou.jpg' COMMENT '会员头像',
  `sex` tinyint(2) NULL DEFAULT 1 COMMENT '会员性别 1代表男  2 代表女',
  `birthday` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出生日期',
  `region` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员住址',
  `profession` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员职业',
  `randstr` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码随机串',
  `addtime` char(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册时间',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of member
-- ----------------------------

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单编号',
  `pid` smallint(6) NOT NULL COMMENT '上级菜单编号',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称',
  `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单图标',
  `type` tinyint(1) NOT NULL COMMENT '菜单类型1目录2菜单',
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单地址',
  `status` tinyint(1) NOT NULL COMMENT '菜单状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台菜单权限表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (2, 0, '系统管理', 'el-icon-setting', 1, '', 1);
INSERT INTO `menu` VALUES (3, 2, '菜单管理', '', 2, '/menu', 1);
INSERT INTO `menu` VALUES (4, 2, '角色管理', '', 2, '/role', 1);
INSERT INTO `menu` VALUES (5, 2, '管理员管理', '', 2, '/user', 1);
INSERT INTO `menu` VALUES (6, 0, '商城管理', 'el-icon-goods', 1, '', 1);
INSERT INTO `menu` VALUES (11, 6, '规格管理', '', 2, '/specs', 1);
INSERT INTO `menu` VALUES (13, 6, '商品管理', '', 2, '/goods', 1);
INSERT INTO `menu` VALUES (15, 6, '商品分类', '', 2, '/cate', 1);
INSERT INTO `menu` VALUES (16, 6, '会员管理', '', 2, '/member', 1);
INSERT INTO `menu` VALUES (18, 6, '轮播图管理', '', 2, '/banners', 1);
INSERT INTO `menu` VALUES (19, 6, '活动管理', '', 2, '/seck', 1);

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员id',
  `orderid` int(11) NULL DEFAULT NULL COMMENT '主订单id',
  `subordernumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '子订单编号',
  `goodsid` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `goodsname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '商品的名称',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品的单价',
  `img` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '商品的图片路径',
  `num` tinyint(3) NULL DEFAULT NULL COMMENT '购买的商品数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 247 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (242, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 155, 'sub_0_1611630449709372294', 1, '小米10', 3999.00, '/uploads/d6a0eff0-70be-11ea-91a2-9395060d7390.jpg', 1);
INSERT INTO `orders` VALUES (243, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 155, 'sub_1_1611630449709372294', 5, '华为MateBook13', 4299.00, '/uploads/2a3e16d0-5ef6-11eb-8407-bb52993c067f.jpg', 1);
INSERT INTO `orders` VALUES (244, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 156, 'sub_0_1611630499451690726', 6, '华为MateBook14', 5299.00, '/uploads/08188b00-5ee5-11eb-9611-cfb4d6b321e9.jpg', 1);
INSERT INTO `orders` VALUES (245, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 157, 'sub_0_1611632778133558188', 1, '小米10', 3999.00, '/uploads/d6a0eff0-70be-11ea-91a2-9395060d7390.jpg', 1);
INSERT INTO `orders` VALUES (246, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 158, 'sub_0_1611642994191449126', 1, '小米10', 3999.00, '/uploads/d6a0eff0-70be-11ea-91a2-9395060d7390.jpg', 1);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色编号',
  `rolename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
  `menus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单权限 存放的是菜单编号，用逗号隔开',
  `status` tinyint(1) NOT NULL COMMENT '角色状态1正常2禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台用户角色表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (4, '超级管理员', '2,3,4,5,6,11,13,15,16,18,19', 1);
INSERT INTO `role` VALUES (5, '客服', '11,13,15,16', 1);

-- ----------------------------
-- Table structure for seckill
-- ----------------------------
DROP TABLE IF EXISTS `seckill`;
CREATE TABLE `seckill`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '秒杀表id',
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活动名称',
  `begintime` char(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '秒杀开始时间',
  `endtime` char(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '秒杀结束时间',
  `first_cateid` smallint(5) NOT NULL COMMENT '商品一级分类编号',
  `second_cateid` smallint(5) NOT NULL COMMENT '商品二级分类编号',
  `goodsid` int(11) NOT NULL COMMENT '商品编号',
  `status` tinyint(1) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '限时秒杀活动表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of seckill
-- ----------------------------
INSERT INTO `seckill` VALUES (6, '活动2', '1611158400000', '1611936000000', 2, 10, 1, 1);

-- ----------------------------
-- Table structure for shop_order
-- ----------------------------
DROP TABLE IF EXISTS `shop_order`;
CREATE TABLE `shop_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员id',
  `addressid` int(11) NULL DEFAULT NULL COMMENT '收货地址id',
  `ordernumber` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '订单编号',
  `tradeno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '微信、支付宝交易号',
  `paytype` tinyint(2) NULL DEFAULT NULL COMMENT '支付方式 1支付宝 2微信',
  `countmoney` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单支付金额',
  `countnumber` smallint(5) NULL DEFAULT NULL COMMENT '商品数量',
  `couriercode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '快递公司码',
  `couriernumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '快递单号',
  `addtime` timestamp NULL DEFAULT NULL COMMENT '订单添加时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单的状态：0是待支付 1是待发货  2待确认 3待评价 4订单完成 5订单取消',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 159 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of shop_order
-- ----------------------------
INSERT INTO `shop_order` VALUES (155, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 23, '1611630449709372294', '2021012622001420320501138046', 1, 8298.00, 2, '', '', '2021-01-26 11:07:29', 1);
INSERT INTO `shop_order` VALUES (156, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 1, '1611630499451690726', '', NULL, 5299.00, 1, '', '', '2021-01-26 11:08:19', 0);
INSERT INTO `shop_order` VALUES (157, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 23, '1611632778133558188', '', NULL, 3999.00, 1, '', '', '2021-01-26 11:46:18', 0);
INSERT INTO `shop_order` VALUES (158, '6e7dd8d0-f1b4-11ea-84da-07a5d6e2f2fe', 23, '1611642994191449126', '', NULL, 3999.00, 1, '', '', '2021-01-26 14:36:34', 0);

-- ----------------------------
-- Table structure for specs
-- ----------------------------
DROP TABLE IF EXISTS `specs`;
CREATE TABLE `specs`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '规格id',
  `specsname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规格名称',
  `status` tinyint(1) NOT NULL COMMENT '规格状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品规格表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of specs
-- ----------------------------
INSERT INTO `specs` VALUES (9, '颜色', 1);
INSERT INTO `specs` VALUES (11, '尺寸', 1);

-- ----------------------------
-- Table structure for specs_attr
-- ----------------------------
DROP TABLE IF EXISTS `specs_attr`;
CREATE TABLE `specs_attr`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '规格项编号',
  `specsid` int(11) NOT NULL COMMENT '规格的specsid',
  `specsval` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规格值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品规格明细表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of specs_attr
-- ----------------------------
INSERT INTO `specs_attr` VALUES (1, 1, '土豪金');
INSERT INTO `specs_attr` VALUES (2, 2, '大');
INSERT INTO `specs_attr` VALUES (3, 2, '小');
INSERT INTO `specs_attr` VALUES (4, 2, '中');
INSERT INTO `specs_attr` VALUES (5, 3, '土豪金');
INSERT INTO `specs_attr` VALUES (6, 3, '天空蓝');
INSERT INTO `specs_attr` VALUES (7, 3, '皓月白');
INSERT INTO `specs_attr` VALUES (8, 4, '大');
INSERT INTO `specs_attr` VALUES (9, 4, '小');
INSERT INTO `specs_attr` VALUES (10, 4, '中');
INSERT INTO `specs_attr` VALUES (11, 5, '天空蓝');
INSERT INTO `specs_attr` VALUES (12, 5, '皓月白');
INSERT INTO `specs_attr` VALUES (13, 6, '大');
INSERT INTO `specs_attr` VALUES (14, 6, '中');
INSERT INTO `specs_attr` VALUES (15, 6, '小');
INSERT INTO `specs_attr` VALUES (16, 7, '天空蓝');
INSERT INTO `specs_attr` VALUES (17, 7, '皓月白');
INSERT INTO `specs_attr` VALUES (18, 8, '大');
INSERT INTO `specs_attr` VALUES (19, 8, '小');
INSERT INTO `specs_attr` VALUES (20, 9, '黑色');
INSERT INTO `specs_attr` VALUES (21, 9, '天空蓝');
INSERT INTO `specs_attr` VALUES (22, 10, 'x');
INSERT INTO `specs_attr` VALUES (23, 10, 's');
INSERT INTO `specs_attr` VALUES (24, 10, 'xxl');
INSERT INTO `specs_attr` VALUES (25, 11, 's');
INSERT INTO `specs_attr` VALUES (26, 11, 'x');
INSERT INTO `specs_attr` VALUES (27, 11, 'xxl');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '住建',
  `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员编号',
  `roleid` smallint(5) NOT NULL COMMENT '角色编号',
  `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `randstr` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '随机加密串',
  `status` tinyint(1) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uid`(`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台管理员用户表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '399e9480-aa00-11ee-9c50-4dec64545ece', 4, 'admin', 'f10d043bf9bb5d0b8d2d29c1d385c3b6', 'guxGp', 1);
INSERT INTO `user` VALUES (2, '51922c00-aa00-11ee-9c50-4dec64545ece', 5, '小明', '3433611f8452bf9fc7158a9d55e75120', 'Yh22M', 1);

SET FOREIGN_KEY_CHECKS = 1;