/*
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');
-- -----------