基于Springboot的蛋糕商城管理系统源码和数据库文件

/* Navicat MySQL Data Transfer Source Server : testttt Source Server Version : 50621 Source Host : localhost:3306 Source Database : cake_shop Target Server Type : MYSQL Target Server Version : 50621 File Encoding : 65001 Date: 2023-05-31 19:42:47 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin_user -- ---------------------------- DROP TABLE IF EXISTS `admin_user`; CREATE TABLE `admin_user` ( `admin_user_id` varchar(255) NOT NULL, `login_user_name` varchar(255) DEFAULT NULL, `login_password` varchar(255) DEFAULT NULL, PRIMARY KEY (`admin_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin_user -- ---------------------------- INSERT INTO `admin_user` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3'); -- ---------------------------- -- Table structure for goods_category -- ---------------------------- DROP TABLE IF EXISTS `goods_category`; CREATE TABLE `goods_category` ( `is_deleted` int(11) DEFAULT '0', `category_id` varchar(255) DEFAULT '100001', `category_name` varchar(255) DEFAULT NULL, `create_time` datetime DEFAULT NULL, `update_time` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of goods_category -- ---------------------------- INSERT INTO `goods_category` VALUES ('0', '100001', '蛋挞', null, null); -- ---------------------------- -- Table structure for goods_info -- ---------------------------- DROP TABLE IF EXISTS `goods_info`; CREATE TABLE `goods_info` ( `goods_id` bigint(255) NOT NULL AUTO_INCREMENT, `goods_name` varchar(255) DEFAULT NULL, `goods_intro` varchar(255) DEFAULT NULL, `goods_category_id` bigint(11) DEFAULT NULL, `goods_cover_img` varchar(255) DEFAULT NULL, `goods_carousel` varchar(255) DEFAULT NULL, `original_price` int(11) DEFAULT NULL, `selling_price` int(10) DEFAULT NULL, `stock_num` int(11) DEFAULT NULL, `tag` varchar(255) DEFAULT NULL, `goods_sell_status` tinyint(255) DEFAULT NULL, `create_user` int(255) DEFAULT NULL, `create_time` date DEFAULT NULL, `update_user` int(255) DEFAULT NULL, `update_time` date DEFAULT NULL, `goods_detail_content` varchar(255) DEFAULT NULL, PRIMARY KEY (`goods_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of goods_info -- ---------------------------- INSERT INTO `goods_info` VALUES ('1', '长沙蛋挞', '好吃的长沙蛋挞', '100001', 'https://javaweb-study.oss-cn-beijing.aliyuncs.com/java%E5%9F%BA%E7%A1%80/2023-05-31/559649f5501d43c284b5fcbe3e2b781b-1598500925980827559.jpg', 'https://javaweb-study.oss-cn-beijing.aliyuncs.com/java%E5%9F%BA%E7%A1%80/2023-05-31/559649f5501d43c284b5fcbe3e2b781b-1598500925980827559.jpg', '11', '11', '11', '11', '0', null, null, null, null, '<p>好吃的长沙蛋挞，欢迎购买。<br/></p>'); -- ---------------------------- -- Table structure for shop_banner -- ---------------------------- DROP TABLE IF EXISTS `shop_banner`; CREATE TABLE `shop_banner` ( `banner_src_url` varchar(255) DEFAULT NULL, `banner_url` varchar(255) DEFAULT NULL, `banner_id` int(11) NOT NULL AUTO_INCREMENT, `is_deleted` tinyint(4) DEFAULT '0', `create_time` date DEFAULT NULL, `update_time` date DEFAULT NULL, PRIMARY KEY (`banner_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of shop_banner -- ---------------------------- INSERT INTO `shop_banner` VALUES ('https://javaweb-study.oss-cn-beijing.aliyuncs.com/java%E5%9F%BA%E7%A1%80/2023-05-31/a6146d243a7d452e83c223afb070fe68-1458096609174521318.jpg', '##', '4', '0', null, null); -- ---------------------------- -- Table structure for shop_user -- ---------------------------- DROP TABLE IF EXISTS `shop_user`; CREATE TABLE `shop_user` ( `user_id` bigint(255) NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) DEFAULT NULL, `login_name` varchar(255) DEFAULT NULL, `password_md5` varchar(255) DEFAULT NULL, `introduce_sign` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `is_deleted` tinyint(255) DEFAULT '0', `locked_flag` tinyint(255) DEFAULT '0', `create_time` date DEFAULT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of shop_user -- ---------------------------- INSERT INTO `shop_user` VALUES ('1', null, '13344445555', 'e10adc3949ba59abbe56e057f20f883e', null, null, '0', '0', null);