springboot酒类商城项目及源码和数据库

/* 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