大学生期末大作业 SpringBoot+Thymeleaf美食文化后台管理

/* Navicat Premium Data Transfer Source Server : 腾讯云 Source Server Type : MySQL Source Server Version : 50736 Source Host : 119.91.220.11:3306 Source Schema : food_culture_history Target Server Type : MySQL Target Server Version : 50736 File Encoding : 65001 Date: 25/12/2021 16:02:52 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_article -- ---------------------------- DROP TABLE IF EXISTS `t_article`; CREATE TABLE `t_article` ( `aid` int(10) NOT NULL AUTO_INCREMENT COMMENT '文章唯一标识', `uid` int(10) NOT NULL COMMENT '用户id', `sid` int(10) NULL DEFAULT NULL COMMENT '菜系id', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章的标题', `digest` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章摘要', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文章内容', `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章标签', `create_time` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布时间', `update_time` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新时间', `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章logo', `thumbsUp` int(10) NULL DEFAULT NULL COMMENT '点赞数量', `visit_count` int(10) NULL DEFAULT NULL COMMENT '访问量', `isOpen` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章性质（0-不公开，1-公开）', `isComment` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论权限（0-禁止评论，1-可以评论）', PRIMARY KEY (`aid`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `sid`(`sid`) USING BTREE, CONSTRAINT `sid` FOREIGN KEY (`sid`) REFERENCES `t_foodtype` (`sid`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `uid` FOREIGN KEY (`uid`) REFERENCES `t_user` (`uid`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_articlecomment -- ---------------------------- DROP TABLE IF EXISTS `t_articlecomment`; CREATE TABLE `t_articlecomment` ( `article_cid` int(10) NOT NULL AUTO_INCREMENT COMMENT '文章评论的唯一标识', `uid` int(10) NULL DEFAULT NULL, `aid` int(10) NOT NULL COMMENT '所属文章', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论内容', `createTime` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发表评论时间', PRIMARY KEY (`article_cid`) USING BTREE, INDEX `aid`(`aid`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, CONSTRAINT `t_articlecomment_ibfk_1` FOREIGN KEY (`aid`) REFERENCES `t_article` (`aid`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `t_articlecomment_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `t_user` (`uid`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_food -- ---------------------------- DROP TABLE IF EXISTS `t_food`; CREATE TABLE `t_food` ( `fid` int(10) NOT NULL AUTO_INCREMENT COMMENT '美食的唯一标识', `sid` int(10) NOT NULL COMMENT '所属菜系', `lid` int(10) NOT NULL COMMENT '所属链接', `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '菜系名称', `describe` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '美食详细介绍', `picture` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '美食图片', `notability` int(10) NULL DEFAULT NULL COMMENT '关注度', `area` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属地区', PRIMARY KEY (`fid`) USING BTREE, INDEX `lid`(`lid`) USING BTREE, INDEX `sid`(`sid`) USING BTREE, CONSTRAINT `t_food_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `t_foodtype` (`sid`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '美食表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_foodcomment -- ---------------------------- DROP TABLE IF EXISTS `t_foodcomment`; CREATE TABLE `t_foodcomment` ( `food_cid` int(10) NOT NULL AUTO_INCREMENT COMMENT '美食评论的唯一标识', `uid` int(10) NULL DEFAULT NULL, `fid` int(10) NOT NULL COMMENT '所属美食', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论内容', `createTime` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发表评论时间', PRIMARY KEY (`food_cid`) USING BTREE, INDEX `fid`(`fid`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, CONSTRAINT `fid` FOREIGN KEY (`fid`) REFERENCES `t_food` (`fid`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `t_foodcomment_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `t_user` (`uid`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_foodtype -- ---------------------------- DROP TABLE IF EXISTS `t_foodtype`; CREATE TABLE `t_foodtype` ( `sid` int(10) NOT NULL AUTO_INCREMENT COMMENT '菜系分类的唯一标识(02-粤菜，03-鲁菜，04-川菜，05-苏菜，06-浙菜，07-闽菜，08-湘菜，09-徽菜)', `foodType` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜系分类名称', PRIMARY KEY (`sid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ddd' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_link -- ---------------------------- DROP TABLE IF EXISTS `t_link`; CREATE TABLE `t_link` ( `lid` int(10) NOT NULL AUTO_INCREMENT, `sid` int(10) NOT NULL, `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '美食名称', `describe` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简单描述', `link` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详细链接', PRIMARY KEY (`lid`) USING BTREE, CONSTRAINT `lib` FOREIGN KEY (`lid`) REFERENCES `t_food` (`lid`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_message -- ---------------------------- DROP TABLE IF EXISTS `t_message`; CREATE TABLE `t_message` ( `mid` int(10) NOT NULL AUTO_INCREMENT COMMENT '留言唯一的标识', `uid` int(10) NULL DEFAULT NULL, `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容', PRIMARY KEY (`mid`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, CONSTRAINT `t_message_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `t_user` (`uid`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_problem -- ---------------------------- DROP TABLE IF EXISTS `t_problem`; CREATE TABLE `t_problem` ( `mid` int(11) NOT NULL COMMENT '题目唯一的标识', `question` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `answer