基于springboot论坛bbs系统-010

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50732 Source Host : localhost:3306 Source Schema : forum Target Server Type : MySQL Target Server Version : 50732 File Encoding : 65001 Date: 16/11/2022 23:54:24 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for cczu_forum_adminuser -- ---------------------------- DROP TABLE IF EXISTS `cczu_forum_adminuser`; CREATE TABLE `cczu_forum_adminuser` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员编号', `enable` int(11) NOT NULL COMMENT '账号是否禁用', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录密码', `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `UK_4erqa44qkwwkl539xouso7v4c`(`username`) USING BTREE COMMENT '账号唯一性约束' ) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '论坛管理员表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of cczu_forum_adminuser -- ---------------------------- INSERT INTO `cczu_forum_adminuser` VALUES (58, 1, 'c6ac59a147fa349f1032c521b7e521a3', 'admin'); -- ---------------------------- -- Table structure for cczu_forum_adminuser_role -- ---------------------------- DROP TABLE IF EXISTS `cczu_forum_adminuser_role`; CREATE TABLE `cczu_forum_adminuser_role` ( `adminuser_id` int(11) NOT NULL COMMENT '管理员编号', `role_id` int(11) NOT NULL COMMENT '角色编号', PRIMARY KEY (`adminuser_id`, `role_id`) USING BTREE, INDEX `FK26lllx1jn0c1k8f8oj2qt4io1`(`role_id`) USING BTREE COMMENT '普通索引：角色编号', CONSTRAINT `FK26lllx1jn0c1k8f8oj2qt4io1` FOREIGN KEY (`role_id`) REFERENCES `cczu_forum_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKatv5o94k3fooskwr53rvqfven` FOREIGN KEY (`adminuser_id`) REFERENCES `cczu_forum_adminuser` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKj4gxd3cf2jrxm3rc2a7wq4l1o` FOREIGN KEY (`role_id`) REFERENCES `cczu_forum_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKnpr70x6qtlmt0ltisj5e5j1k7` FOREIGN KEY (`adminuser_id`) REFERENCES `cczu_forum_adminuser` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员角色管理表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of cczu_forum_adminuser_role -- ---------------------------- INSERT INTO `cczu_forum_adminuser_role` VALUES (58, 1); -- ---------------------------- -- Table structure for cczu_forum_collect -- ---------------------------- DROP TABLE IF EXISTS `cczu_forum_collect`; CREATE TABLE `cczu_forum_collect` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '收藏编号', `init_time` datetime(0) NULL DEFAULT NULL COMMENT '收藏时间', `posts_id` int(11) NOT NULL COMMENT '帖子编号', `user_id` int(11) NOT NULL COMMENT '收藏的用户编号', PRIMARY KEY (`id`) USING BTREE, INDEX `FK5a8rh83fve6ug3utggpy8wdvi`(`posts_id`) USING BTREE COMMENT '普通索引：帖子编号', INDEX `FKg4gtyqabrsuwr5y35lxvjy515`(`user_id`) USING BTREE COMMENT '普通索引：用户编号', CONSTRAINT `FK5a8rh83fve6ug3utggpy8wdvi` FOREIGN KEY (`posts_id`) REFERENCES `cczu_forum_posts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKdx99au8k6gwee63xsx3s7j41x` FOREIGN KEY (`posts_id`) REFERENCES `cczu_forum_posts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKg4gtyqabrsuwr5y35lxvjy515` FOREIGN KEY (`user_id`) REFERENCES `cczu_forum_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKqn9gc7gknb4oowy18qxcjliop` FOREIGN KEY (`user_id`) REFERENCES `cczu_forum_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '帖子收藏记录表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of cczu_forum_collect -- ---------------------------- -- ---------------------------- -- Table structure for cczu_forum_label -- ---------------------------- DROP TABLE IF EXISTS `cczu_forum_label`; CREATE TABLE `cczu_forum_label` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '标签编号', `details` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签详情', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标签名称', `posts_count` int(11) NULL DEFAULT NULL COMMENT '帖子统计', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `UK_6vml4ba2itmaor84892v92b1f`(`name`) USING BTREE COMMENT '标签名称唯一性约束' ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '标签表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of cczu_forum_label -- ---------------------------- INSERT INTO `cczu_forum_label` VALUES (1, '专注日常灌水，消磨时光', '闲聊', 7); INSERT INTO `cczu_forum_label` VALUES (2, '可尽情抒发同学情、友情、爱情、师生情、母校情', '情感交流', 4); INSERT INTO `cczu_forum_label` VALUES (3, '学习使我快乐，请互相指教', '学习专区', 18); INSERT INTO `cczu_forum_label` VALUES (4, '俊男靓女的美妆秘籍集散地', '时尚', 6); INSERT INTO `cczu_forum_label` VALUES (5, '日常发布勤工俭学，周末及寒暑假兼职', '兼职', 7); INSERT INTO `cczu_forum_label` VALUES (6, '二手书、二手代步工具、二手电子产品应有尽有', '二手交易', 6); -- ---------------------------- -- Table structure for cczu_forum_notification -- ---------------------------- DROP TABLE IF EXISTS `cczu_forum_notification`; CREATE TABLE `cczu_forum_notification` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '通知编号', `is_read` bit(1) NULL DEFAULT NULL COMMENT '是否已读', `fromuser_id` int(11) NOT NULL COMMENT '发起通知的用户', `posts_id` int(11) NOT NULL COMMENT '帖子编号', `touser_id` int(11) NOT NULL COMMENT '要通知的用户', `init_time` datetime(0) NOT NULL COMMENT '发布时间', PRIMARY KEY (`id`) USING BTREE, INDEX `FKac4wjs0b3992ohkf61jy4ilmj`(`fromuser_id`) USING BTREE COMMENT '普通索引：发起通知用户编号', INDEX `FKilg05a7ki3vkv7lfjnn57pdw2`(`posts_id`) USING BTREE COMMENT '普通索引：帖子编号', INDEX `FKquscxmtiqggsch7w833ywubux`(`touser_id`) USING BTREE COMMENT '普通索引：要通知的用户', CONSTRAINT `FK1ripp8dro8i84so1m7tknf2rx` FOREIGN KEY (`fromuser_id`) REFERENCES `cczu_forum_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKa9ku7evil79e7mxd3o5gxwb7l` FOREIGN KEY (`touser_id`) REFERENCES `cczu_forum_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKac4wjs0b3992ohkf61jy4ilmj` FOREIGN KEY (`fromuser_id`) REFERENCES `cczu_forum_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKhfe90l9o37q5bu1cngbw2hrcf` FOREIGN KEY (`posts_id`) REFERENCES `cczu_forum_posts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKilg05a7ki3vkv7lfjnn57pdw2` FOREIGN KEY (`posts_id`) REFERENCES `cczu_forum_posts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FKquscxmtiqggsch7w833ywubux` FOREIGN KEY (`touser_id`) REFERENCES `cczu_forum_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of cczu_forum_notification -- ---------------------------- INSERT INTO `cczu_forum_notification` VALUES (10, b'0', 98, 269, 96, '2022-11-16 23:36:47'); -- -----------