/*
Navicat MySQL Data Transfer
Source Server : test
Source Server Version : 50560
Source Host : localhost:3306
Source Database : newbee_mall_schema
Target Server Type : MYSQL
Target Server Version : 50560
File Encoding : 65001
Date: 2021-03-22 21:07:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tb_newbee_mall_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_newbee_mall_admin_user`;
CREATE TABLE `tb_newbee_mall_admin_user` (
`admin_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
`login_user_name` varchar(50) NOT NULL COMMENT '管理员登陆名称',
`login_password` varchar(50) NOT NULL COMMENT '管理员登陆密码',
`nick_name` varchar(50) NOT NULL COMMENT '管理员显示昵称',
`locked` tinyint(4) DEFAULT '0' COMMENT '是否锁定 0未锁定 1已锁定无法登陆',
PRIMARY KEY (`admin_user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tb_newbee_mall_admin_user
-- ----------------------------
INSERT INTO `tb_newbee_mall_admin_user` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '十三', '0');
INSERT INTO `tb_newbee_mall_admin_user` VALUES ('2', 'newbee-admin1', 'e10adc3949ba59abbe56e057f20f883e', '新蜂01', '0');
INSERT INTO `tb_newbee_mall_admin_user` VALUES ('3', 'newbee-admin2', 'e10adc3949ba59abbe56e057f20f883e', '新蜂02', '0');
-- ----------------------------
-- Table structure for tb_newbee_mall_carousel
-- ----------------------------
DROP TABLE IF EXISTS `tb_newbee_mall_carousel`;
CREATE TABLE `tb_newbee_mall_carousel` (
`carousel_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '首页轮播图主键id',
`carousel_url` varchar(100) NOT NULL DEFAULT '' COMMENT '轮播图',
`redirect_url` varchar(100) NOT NULL DEFAULT '''##''' COMMENT '点击后的跳转地址(默认不跳转)',
`carousel_rank` int(11) NOT NULL DEFAULT '0' COMMENT '排序值(字段越大越靠前)',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识字段(0-未删除 1-已删除)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_user` int(11) NOT NULL DEFAULT '0' COMMENT '创建者id',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` int(11) NOT NULL DEFAULT '0' COMMENT '修改者id',
PRIMARY KEY (`carousel_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tb_newbee_mall_carousel
-- ----------------------------
INSERT INTO `tb_newbee_mall_carousel` VALUES ('2', 'http://localhost:8080/upload/20210319_20112018.png', 'https://www.china-moutai.com/', '13', '0', '2019-11-29 00:00:00', '0', '2021-03-19 20:11:21', '0');
INSERT INTO `tb_newbee_mall_carousel` VALUES ('5', 'http://localhost:8080/upload/20210319_20120478.png', 'https://wuliangye.fbu.cn/', '0', '0', '2019-11-29 00:00:00', '0', '2021-03-19 20:12:35', '0');
-- ----------------------------
-- Table structure for tb_newbee_mall_goods_category
-- ----------------------------
DROP TABLE IF EXISTS `tb_newbee_mall_goods_category`;
CREATE TABLE `tb_newbee_mall_goods_category` (
`category_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分类id',
`category_level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分类级别(1-一级分类 2-二级分类 3-三级分类)',
`parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父分类id',
`category_name` varchar(50) NOT NULL DEFAULT '' COMMENT '分类名称',
`category_rank` int(11) NOT NULL DEFAULT '0' COMMENT '排序值(字段越大越靠前)',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识字段(0-未删除 1-已删除)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_user` int(11) NOT NULL DEFAULT '0' COMMENT '创建者id',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` int(11) DEFAULT '0' COMMENT '修改者id',
PRIMARY KEY (`category_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tb_newbee_mall_goods_category
-- ----------------------------
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('15', '1', '0', '白酒', '100', '0', '2019-09-11 18:45:40', '0', '2019-09-11 18:45:40', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('16', '1', '0', '黄酒', '99', '0', '2019-09-11 18:46:07', '0', '2019-09-11 18:46:07', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('17', '2', '15', '酱香型白酒', '10', '0', '2019-09-11 18:46:32', '0', '2019-09-11 18:46:32', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('18', '2', '15', '浓香型白酒', '9', '0', '2019-09-11 18:46:43', '0', '2019-09-11 18:46:43', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('19', '2', '15', '清香型白酒', '8', '0', '2019-09-11 18:46:52', '0', '2019-09-11 18:46:52', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('29', '3', '17', '五粮液', '0', '0', '2019-09-11 18:49:09', '0', '2019-09-11 18:49:09', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('30', '3', '17', '茅台', '0', '0', '2019-09-11 18:49:19', '0', '2019-09-11 18:49:19', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('31', '3', '17', '山西汾酒', '0', '0', '2019-09-11 18:49:30', '0', '2019-09-11 18:49:30', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('42', '3', '18', '洋河', '0', '0', '2019-09-11 18:53:08', '0', '2019-09-11 18:53:08', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('43', '3', '18', '泸州老窖', '0', '0', '2019-09-11 18:53:14', '0', '2019-09-11 18:53:14', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('44', '3', '19', '河南龙兴酒', '89', '0', '2019-09-11 18:53:49', '0', '2019-09-11 18:54:38', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('45', '3', '19', '浙江同山烧', '99', '0', '2019-09-11 18:53:59', '0', '2019-09-18 13:40:59', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('46', '3', '19', '河南宝丰酒', '98', '0', '2019-09-11 18:54:20', '0', '2019-09-18 13:40:51', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('59', '1', '0', '果酒', '97', '0', '2019-09-12 00:08:46', '0', '2019-09-12 00:08:46', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('60', '1', '0', '药酒', '96', '0', '2019-09-12 00:09:00', '0', '2019-09-12 00:09:00', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('61', '1', '0', '啤酒', '98', '0', '2019-09-12 00:09:27', '0', '2019-09-12 00:09:27', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('62', '1', '0', '葡萄酒', '94', '0', '2019-09-12 00:09:51', '0', '2019-09-17 18:22:34', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('67', '2', '16', '干型黄酒', '10', '0', '2019-09-12 00:15:19', '0', '2019-09-12 00:15:19', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('68', '2', '16', '半干型黄酒', '9', '0', '2019-09-12 00:15:28', '0', '2019-09-12 00:15:28', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('69', '2', '16', '半甜型黄酒', '8', '0', '2019-09-12 00:15:35', '0', '2019-09-12 00:15:35', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('70', '2', '61', '黑啤', '10', '0', '2019-09-12 00:20:22', '0', '2019-09-12 00:20:22', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('73', '2', '59', '发酵果酒', '10', '0', '2019-09-12 00:20:49', '0', '2019-09-12 00:20:49', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('76', '3', '67', '塔牌元红酒', '10', '0', '2019-09-12 00:21:55', '0', '2019-09-12 00:21:55', '0');
INSERT INTO `tb_newbee_mall_goods_category` VALUES ('77', '3', '70', '青岛黑啤', '10', '0', '2019-09-12 00:22:21', '0', '2019-09-12 00:22:21', '0');
INSE
