master

分支 (1)

管理

管理

master

ssmsqhdgxlt
/
sqhdglxt.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80036
 Source Host           : localhost:3306
 Source Schema         : sqhdglxt

 Target Server Type    : MySQL
 Target Server Version : 80036
 File Encoding         : 65001

 Date: 08/04/2024 19:27:42
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint NOT NULL COMMENT '用户id',
  `adminid` bigint NULL DEFAULT NULL COMMENT '管理员id',
  `ask` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '提问',
  `reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '回复',
  `isreply` int NULL DEFAULT NULL COMMENT '是否回复',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376647504 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '在线咨询' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES (81, '2024-04-14 12:27:13', 1, 1, '提问1', '回复1', 1);
INSERT INTO `chat` VALUES (82, '2024-04-14 12:27:13', 2, 2, '提问2', '回复2', 2);
INSERT INTO `chat` VALUES (83, '2024-04-14 12:27:13', 3, 3, '提问3', '回复3', 3);
INSERT INTO `chat` VALUES (84, '2024-04-14 12:27:13', 4, 4, '提问4', '回复4', 4);
INSERT INTO `chat` VALUES (85, '2024-04-14 12:27:13', 5, 5, '提问5', '回复5', 5);
INSERT INTO `chat` VALUES (86, '2024-04-14 12:27:13', 6, 6, '提问6', '回复6', 6);
INSERT INTO `chat` VALUES (1618376647503, '2024-04-14 13:04:07', 1618376563186, NULL, '你好啊', NULL, 1);

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (1, 'picture1', 'http://localhost:8080/ssmhn4b5/upload/picture1.jpg');
INSERT INTO `config` VALUES (2, 'picture2', 'http://localhost:8080/ssmhn4b5/upload/picture2.jpg');
INSERT INTO `config` VALUES (3, 'picture3', 'http://localhost:8080/ssmhn4b5/upload/picture3.jpg');
INSERT INTO `config` VALUES (6, 'homepage', NULL);

-- ----------------------------
-- Table structure for huiyuan
-- ----------------------------
DROP TABLE IF EXISTS `huiyuan`;
CREATE TABLE `huiyuan`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学号',
  `mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '姓名',
  `xingbie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别',
  `nianling` int NULL DEFAULT NULL COMMENT '年龄',
  `dianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '电话',
  `youxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `shenfenzheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '身份证',
  `zhaopian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '照片',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `xuehao`(`xuehao`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376563187 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of huiyuan
-- ----------------------------
INSERT INTO `huiyuan` VALUES (51, '2024-04-14 12:27:13', '会员1', '123456', '姓名1', '男', 1, '13823888881', '773890001@qq.com', '440300199101010001', 'http://localhost:8080/ssmhn4b5/upload/huiyuan_zhaopian1.jpg');
INSERT INTO `huiyuan` VALUES (52, '2024-04-14 12:27:13', '会员2', '123456', '姓名2', '女', 23, '13823888882', '773890002@qq.com', '440300199202020002', 'http://localhost:8080/ssmhn4b5/upload/huiyuan_zhaopian2.jpg');
INSERT INTO `huiyuan` VALUES (53, '2024-04-14 12:27:13', '会员3', '123456', '姓名3', '男', 3, '13823888883', '773890003@qq.com', '440300199303030003', 'http://localhost:8080/ssmhn4b5/upload/huiyuan_zhaopian3.jpg');
INSERT INTO `huiyuan` VALUES (54, '2024-04-14 12:27:13', '会员4', '123456', '姓名4', '男', 4, '13823888884', '773890004@qq.com', '440300199404040004', 'http://localhost:8080/ssmhn4b5/upload/huiyuan_zhaopian4.jpg');
INSERT INTO `huiyuan` VALUES (55, '2024-04-14 12:27:13', '会员5', '123456', '姓名5', '男', 5, '13823888885', '773890005@qq.com', '440300199505050005', 'http://localhost:8080/ssmhn4b5/upload/huiyuan_zhaopian5.jpg');
INSERT INTO `huiyuan` VALUES (56, '2024-04-14 12:27:13', '会员6', '123456', '姓名6', '男', 6, '13823888886', '773890006@qq.com', '440300199606060006', 'http://localhost:8080/ssmhn4b5/upload/huiyuan_zhaopian6.jpg');
INSERT INTO `huiyuan` VALUES (1618376430224, '2024-04-14 13:00:30', '333', '333', '李大哥', '男', 33, '12312312312', '2@qq.com', '123123123123123123', 'http://localhost:8080/ssmhn4b5/upload/1618376429498.jpg');
INSERT INTO `huiyuan` VALUES (1618376563186, '2024-04-14 13:02:43', '100', '123456', '李四', '男', 21, '12312312312', '213@qq.com', '123131123123123123', 'http://localhost:8080/ssmhn4b5/upload/1618376532578.jpg');

-- ----------------------------
-- Table structure for huiyuanshenqing
-- ----------------------------
DROP TABLE IF EXISTS `huiyuanshenqing`;
CREATE TABLE `huiyuanshenqing`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学号',
  `mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '姓名',
  `xingbie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别',
  `nianling` int NULL DEFAULT NULL COMMENT '年龄',
  `dianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '电话',
  `youxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `shenfenzheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '身份证',
  `zhaopian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '照片',
  `sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复',
  `userid` bigint NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376538421 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员申请' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of huiyuanshenqing
-- ----------------------------
INSERT INTO `huiyuanshenqing` VALUES (71, '2024-04-14 12:27:13', '学号1', '密码1', '姓名1', '性别1', 1, '13823888881', '773890001@qq.com', '440300199101010001', 'http://localhost:8080/ssmhn4b5/upload/huiyuanshenqing_zhaopian1.jpg', '是', '', 1);
INSERT INTO `huiyuanshenqing` VALUES (72, '2024-04-14 12:27:13', '学号2', '密码2', '姓名2', '性别2', 2, '13823888882', '773890002@qq.com', '440300199202020002', 'http://localhost:8080/ssmhn4b5/upload/huiyuanshenqing_zhaopian2.jpg', '是', '', 2);
INSERT INTO `huiyuanshenqing` VALUES (73, '2024-04-14 12:27:13', '学号3', '密码3', '姓名3', '性别3', 3, '13823888883', '773890003@qq.com', '440300199303030003', 'http://localhost:8080/ssmhn4b5/upload/huiyuanshenqing_zhaopian3.jpg', '是', '', 3);
INSERT INTO `huiyuanshenqing` VALUES (74, '2024-04-14 12:27:13', '学号4', '密码4', '姓名4', '性别4', 4, '13823888884', '773890004@qq.com', '440300199404040004', 'http://localhost:8080/ssmhn4b5/upload/huiyuanshenqing_zhaopian4.jpg', '是', '', 4);
INSERT INTO `huiyuanshenqing` VALUES (75, '2024-04-14 12:27:13', '学号5', '密码5', '姓名5', '性别5', 5, '13823888885', '773890005@qq.com', '440300199505050005', 'http://localhost:8080/ssmhn4b5/upload/huiyuanshenqing_zhaopian5.jpg', '是', '', 5);
INSERT INTO `huiyuanshenqing` VALUES (76, '2024-04-14 12:27:13', '学号6', '密码6', '姓名6', '性别6', 6, '13823888886', '773890006@qq.com', '440300199606060006', 'http://localhost:8080/ssmhn4b5/upload/huiyuanshenqing_zhaopian6.jpg', '是', '', 6);
INSERT INTO `huiyuanshenqing` VALUES (1618376538420, '2024-04-14 13:02:17', '100', '123456', '李四', '男', 21, '12312312312', '213@qq.com', '123131123123123123', 'http://localhost:8080/ssmhn4b5/upload/1618376532578.jpg', '是', 'tongguo', 1618376476788);

-- ----------------------------
-- Table structure for huodongcanyu
-- ----------------------------
DROP TABLE IF EXISTS `huodongcanyu`;
CREATE TABLE `huodongcanyu`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `huodongmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '活动名称',
  `huodongleixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '活动类型',
  `zhaopian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '照片',
  `jubanriqi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '举办日期',
  `jubanshetuan` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '举办社区',
  `huodongdidian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '活动地点',
  `canyushijian` datetime NULL DEFAULT NULL COMMENT '参与时间',
  `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复',
  `userid` bigint NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376634102 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '活动参与' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of huodongcanyu
-- ----------------------------
INSERT INTO `huodongcanyu` VALUES (61, '2024-04-14 12:27:13', '活动名称1', '活动类型1', 'http://localhost:8080/ssmhn4b5/upload/huodongcanyu_zhaopian1.jpg', '举办日期1', '举办社区1', '活动地点1', '2024-04-14 12:27:13', '学号1', '姓名1', '是', '', 1);
INSERT INTO `huodongcanyu` VALUES (62, '2024-04-14 12:27:13', '活动名称2', '活动类型2', 'http://localhost:8080/ssmhn4b5/upload/huodongcanyu_zhaopian2.jpg', '举办日期2', '举办社区2', '活动地点2', '2024-04-14 12:27:13', '学号2', '姓名2', '是', '', 2);
INSERT INTO `huodongcanyu` VALUES (63, '2024-04-14 12:27:13', '活动名称3', '活动类型3', 'http://localhost:8080/ssmhn4b5/upload/huodongcanyu_zhaopian3.jpg', '举办日期3', '举办社区3', '活动地点3', '2024-04-14 12:27:13', '学号3', '姓名3', '是', '', 3);
INSERT INTO `huodongcanyu` VALUES (64, '2024-04-14 12:27:13', '活动名称4', '活动类型4', 'http://localhost:8080/ssmhn4b5/upload/huodongcanyu_zhaopian4.jpg', '举办日期4', '举办社区4', '活动地点4', '2024-04-14 12:27:13', '学号4', '姓名4', '是', '', 4);
INSERT INTO `huodongcanyu` VALUES (65, '2024-04-14 12:27:13', '活动名称5', '活动类型5', 'http://localhost:8080/ssmhn4b5/upload/huodongcanyu_zhaopian5.jpg', '举办日期5', '举办社区5', '活动地点5', '2024-04-14 12:27:13', '学号5', '姓名5', '是', '', 5);
INSERT INTO `huodongcanyu` VALUES (66, '2024-04-14 12:27:13', '活动名称6', '活动类型6', 'http://localhost:8080/ssmhn4b5/upload/huodongcanyu_zhaopian6.jpg', '举办日期6', '举办社区6', '活动地点6', '2024-04-14 12:27:13', '学号6', '姓名6', '是', '', 6);
INSERT INTO `huodongcanyu` VALUES (1618376634101, '2024-04-14 13:03:54', '代码大赛', '编程', 'http://localhost:8080/ssmhn4b5/upload/1618376367834.jpg', '2024-04-15', '程序员社', '西科楼', '2024-04-14 13:03:52', '100', '李四', '是', '准予参加', 1618376563186);

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '标题',
  `introduction` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '简介',
  `picture` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图片',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 107 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '校园资讯' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (101, '2024-04-14 12:27:13', '标题1', '简介1', 'http://localhost:8080/ssmhn4b5/upload/news_picture1.jpg', '内容1');
INSERT INTO `news` VALUES (102, '2024-04-14 12:27:13', '标题2', '简介2', 'http://localhost:8080/ssmhn4b5/upload/news_picture2.jpg', '内容2');
INSERT INTO `news` VALUES (103, '2024-04-14 12:27:13', '标题3', '简介3', 'http://localhost:8080/ssmhn4b5/upload/news_picture3.jpg', '内容3');
INSERT INTO `news` VALUES (104, '2024-04-14 12:27:13', '标题4', '简介4', 'http://localhost:8080/ssmhn4b5/upload/news_picture4.jpg', '内容4');
INSERT INTO `news` VALUES (105, '2024-04-14 12:27:13', '标题5', '简介5', 'http://localhost:8080/ssmhn4b5/upload/news_picture5.jpg', '内容5');
INSERT INTO `news` VALUES (106, '2024-04-14 12:27:13', '标题6', '简介6', 'http://localhost:8080/ssmhn4b5/upload/news_picture6.jpg', '内容6');

-- ----------------------------
-- Table structure for shetuanhuodong
-- ----------------------------
DROP TABLE IF EXISTS `shetuanhuodong`;
CREATE TABLE `shetuanhuodong`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `huodongmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '活动名称',
  `huodongleixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '活动类型',
  `zhaopian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '照片',
  `jubanriqi` date NULL DEFAULT NULL COMMENT '举办日期',
  `jubanshetuan` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '举办社区',
  `huodongdidian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '活动地点',
  `huodongshizhang` int NULL DEFAULT NULL COMMENT '活动时长',
  `huodongneirong` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '活动内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376387694 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '社区活动' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of shetuanhuodong
-- ----------------------------
INSERT INTO `shetuanhuodong` VALUES (41, '2024-04-14 12:27:13', '活动名称1', '活动类型1', 'http://localhost:8080/ssmhn4b5/upload/shetuanhuodong_zhaopian1.jpg', '2024-04-14', '举办社区1', '活动地点1', 1, '活动内容1');
INSERT INTO `shetuanhuodong` VALUES (42, '2024-04-14 12:27:13', '活动名称2', '活动类型2', 'http://localhost:8080/ssmhn4b5/upload/shetuanhuodong_zhaopian2.jpg', '2024-04-14', '举办社区2', '活动地点2', 2, '活动内容2');
INSERT INTO `shetuanhuodong` VALUES (43, '2024-04-14 12:27:13', '活动名称3', '活动类型3', 'http://localhost:8080/ssmhn4b5/upload/shetuanhuodong_zhaopian3.jpg', '2024-04-14', '举办社区3', '活动地点3', 3, '活动内容3');
INSERT INTO `shetuanhuodong` VALUES (44, '2024-04-14 12:27:13', '活动名称4', '活动类型4', 'http://localhost:8080/ssmhn4b5/upload/shetuanhuodong_zhaopian4.jpg', '2024-04-14', '举办社区4', '活动地点4', 4, '活动内容4');
INSERT INTO `shetuanhuodong` VALUES (45, '2024-04-14 12:27:13', '活动名称5', '活动类型5', 'http://localhost:8080/ssmhn4b5/upload/shetuanhuodong_zhaopian5.jpg', '2024-04-14', '举办社区5', '活动地点5', 5, '活动内容5');
INSERT INTO `shetuanhuodong` VALUES (46, '2024-04-14 12:27:13', '活动名称6', '活动类型6', 'http://localhost:8080/ssmhn4b5/upload/shetuanhuodong_zhaopian6.jpg', '2024-04-14', '举办社区6', '活动地点6', 6, '活动内容6');
INSERT INTO `shetuanhuodong` VALUES (1618376387693, '2024-04-14 12:59:47', '代码大赛', '编程', 'http://localhost:8080/ssmhn4b5/upload/1618376367834.jpg', '2024-04-15', '程序员社', '西科楼', 2, '<p>比赛打代码，头越秃越强</p>');

-- ----------------------------
-- Table structure for shetuanshenqingxinxi
-- ----------------------------
DROP TABLE IF EXISTS `shetuanshenqingxinxi`;
CREATE TABLE `shetuanshenqingxinxi`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `shetuanmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '社区名称',
  `shetuantupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '社区图片',
  `shetuanleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '社区类别',
  `shenqingshijian` date NULL DEFAULT NULL COMMENT '申请时间',
  `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `shenqingliyou` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '申请理由',
  `sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复',
  `userid` bigint NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376615540 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '社区申请信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of shetuanshenqingxinxi
-- ----------------------------
INSERT INTO `shetuanshenqingxinxi` VALUES (21, '2024-04-14 12:27:13', '社区名称1', 'http://localhost:8080/ssmhn4b5/upload/shetuanshenqingxinxi_shetuantupian1.jpg', '社区类别1', '2024-04-14', '学号1', '姓名1', '申请理由1', '是', '', 1);
INSERT INTO `shetuanshenqingxinxi` VALUES (22, '2024-04-14 12:27:13', '社区名称2', 'http://localhost:8080/ssmhn4b5/upload/shetuanshenqingxinxi_shetuantupian2.jpg', '社区类别2', '2024-04-14', '学号2', '姓名2', '申请理由2', '是', '', 2);
INSERT INTO `shetuanshenqingxinxi` VALUES (23, '2024-04-14 12:27:13', '社区名称3', 'http://localhost:8080/ssmhn4b5/upload/shetuanshenqingxinxi_shetuantupian3.jpg', '社区类别3', '2024-04-14', '学号3', '姓名3', '申请理由3', '是', '', 3);
INSERT INTO `shetuanshenqingxinxi` VALUES (24, '2024-04-14 12:27:13', '社区名称4', 'http://localhost:8080/ssmhn4b5/upload/shetuanshenqingxinxi_shetuantupian4.jpg', '社区类别4', '2024-04-14', '学号4', '姓名4', '申请理由4', '是', '', 4);
INSERT INTO `shetuanshenqingxinxi` VALUES (25, '2024-04-14 12:27:13', '社区名称5', 'http://localhost:8080/ssmhn4b5/upload/shetuanshenqingxinxi_shetuantupian5.jpg', '社区类别5', '2024-04-14', '学号5', '姓名5', '申请理由5', '是', '', 5);
INSERT INTO `shetuanshenqingxinxi` VALUES (26, '2024-04-14 12:27:13', '社区名称6', 'http://localhost:8080/ssmhn4b5/upload/shetuanshenqingxinxi_shetuantupian6.jpg', '社区类别6', '2024-04-14', '学号6', '姓名6', '申请理由6', '是', '666', 6);
INSERT INTO `shetuanshenqingxinxi` VALUES (1618376615539, '2024-04-14 13:03:35', '程序员社', 'http://localhost:8080/ssmhn4b5/upload/1618376333075.jpg', '编程', '2024-04-14', '100', '李四', '<p>我想变秃也想变强</p>', '是', '好好好', 1618376563186);

-- ----------------------------
-- Table structure for storeup
-- ----------------------------
DROP TABLE IF EXISTS `storeup`;
CREATE TABLE `storeup`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint NOT NULL COMMENT '用户id',
  `refid` bigint NULL DEFAULT NULL COMMENT '收藏id',
  `tablename` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表名',
  `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收藏名称',
  `picture` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收藏图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '收藏表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of storeup
-- ----------------------------

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint NOT NULL COMMENT '用户id',
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
  `tablename` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表名',
  `role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色',
  `token` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'token表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of token
-- ----------------------------
INSERT INTO `token` VALUES (1, 1, 'abo', 'users', '管理员', 'ng70wrrep0aqty2a8pwzjnqfxzqq9r3w', '2024-04-14 12:57:38', '2024-04-08 12:23:20');
INSERT INTO `token` VALUES (2, 1618376476788, '100', 'xuesheng', '学生', 'ntw0u0a0pal5st5m60rcf4cchanguvwa', '2024-04-14 13:01:23', '2024-04-14 14:02:55');
INSERT INTO `token` VALUES (3, 1618376563186, '100', 'huiyuan', '会员', 'md2p9zww3g6mau9ylwg07ca3ajh1aqxe', '2024-04-14 13:03:04', '2024-04-14 14:05:06');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', 'admin', '管理员', '2024-04-14 12:27:13');

-- ----------------------------
-- Table structure for xiaoyuanshetuan
-- ----------------------------
DROP TABLE IF EXISTS `xiaoyuanshetuan`;
CREATE TABLE `xiaoyuanshetuan`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `shetuanmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '社区名称',
  `shetuantupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '社区图片',
  `chenglishijian` date NULL DEFAULT NULL COMMENT '成立时间',
  `shetuanleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '社区类别',
  `shetuanrenshu` int NULL DEFAULT NULL COMMENT '社区人数',
  `shetuanjieshao` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '社区介绍',
  `clicktime` datetime NULL DEFAULT NULL COMMENT '最近点击时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376351267 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '校园社区' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xiaoyuanshetuan
-- ----------------------------
INSERT INTO `xiaoyuanshetuan` VALUES (31, '2024-04-14 12:27:13', '社区名称1', 'http://localhost:8080/ssmhn4b5/upload/xiaoyuanshetuan_shetuantupian1.jpg', '2024-04-14', '社区类别1', 1, '社区介绍1', '2024-04-14 12:27:13');
INSERT INTO `xiaoyuanshetuan` VALUES (32, '2024-04-14 12:27:13', '社区名称2', 'http://localhost:8080/ssmhn4b5/upload/xiaoyuanshetuan_shetuantupian2.jpg', '2024-04-14', '社区类别2', 2, '社区介绍2', '2024-04-14 13:03:14');
INSERT INTO `xiaoyuanshetuan` VALUES (33, '2024-04-14 12:27:13', '社区名称3', 'http://localhost:8080/ssmhn4b5/upload/xiaoyuanshetuan_shetuantupian3.jpg', '2024-04-14', '社区类别3', 3, '社区介绍3', '2024-04-14 12:27:13');
INSERT INTO `xiaoyuanshetuan` VALUES (34, '2024-04-14 12:27:13', '社区名称4', 'http://localhost:8080/ssmhn4b5/upload/xiaoyuanshetuan_shetuantupian4.jpg', '2024-04-14', '社区类别4', 4, '社区介绍4', '2024-04-14 12:27:13');
INSERT INTO `xiaoyuanshetuan` VALUES (35, '2024-04-14 12:27:13', '社区名称5', 'http://localhost:8080/ssmhn4b5/upload/xiaoyuanshetuan_shetuantupian5.jpg', '2024-04-14', '社区类别5', 5, '社区介绍5', '2024-04-14 12:27:13');
INSERT INTO `xiaoyuanshetuan` VALUES (36, '2024-04-14 12:27:13', '社区名称6', 'http://localhost:8080/ssmhn4b5/upload/xiaoyuanshetuan_shetuantupian6.jpg', '2024-04-14', '社区类别6', 6, '社区介绍6', '2024-04-14 13:01:43');
INSERT INTO `xiaoyuanshetuan` VALUES (1618376351266, '2024-04-14 12:59:10', '程序员社', 'http://localhost:8080/ssmhn4b5/upload/1618376333075.jpg', '2024-04-14', '编程', 10, '<p>打代码，程序猿</p>', '2024-04-14 13:03:38');

-- ----------------------------
-- Table structure for xuesheng
-- ----------------------------
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学号',
  `mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '姓名',
  `xingbie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别',
  `nianling` int NULL DEFAULT NULL COMMENT '年龄',
  `dianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '电话',
  `youxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `shenfenzheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '身份证',
  `zhaopian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '照片',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `xuehao`(`xuehao`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1618376476789 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '学生' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xuesheng
-- ----------------------------
INSERT INTO `xuesheng` VALUES (11, '2024-04-14 12:27:13', '学生1', '123456', '姓名1', '男', 1, '13823888881', '773890001@qq.com', '440300199101010001', 'http://localhost:8080/ssmhn4b5/upload/xuesheng_zhaopian1.jpg');
INSERT INTO `xuesheng` VALUES (12, '2024-04-14 12:27:13', '学生2', '123456', '姓名2', '女', 22, '13823888882', '773890002@qq.com', '440300199202020002', 'http://localhost:8080/ssmhn4b5/upload/xuesheng_zhaopian2.jpg');
INSERT INTO `xuesheng` VALUES (13, '2024-04-14 12:27:13', '学生3', '123456', '姓名3', '男', 3, '13823888883', '773890003@qq.com', '440300199303030003', 'http://localhost:8080/ssmhn4b5/upload/xuesheng_zhaopian3.jpg');
INSERT INTO `xuesheng` VALUES (14, '2024-04-14 12:27:13', '学生4', '123456', '姓名4', '男', 4, '13823888884', '773890004@qq.com', '440300199404040004', 'http://localhost:8080/ssmhn4b5/upload/xuesheng_zhaopian4.jpg');
INSERT INTO `xuesheng` VALUES (15, '2024-04-14 12:27:13', '学生5', '123456', '姓名5', '男', 5, '13823888885', '773890005@qq.com', '440300199505050005', 'http://localhost:8080/ssmhn4b5/upload/xuesheng_zhaopian5.jpg');
INSERT INTO `xuesheng` VALUES (16, '2024-04-14 12:27:13', '学生6', '123456', '姓名6', '男', 6, '13823888886', '773890006@qq.com', '440300199606060006', 'http://localhost:8080/ssmhn4b5/upload/xuesheng_zhaopian6.jpg');
INSERT INTO `xuesheng` VALUES (1618376292837, '2024-04-14 12:58:12', '123', '123', '张三啊', '男', 33, '12312312312', '123@qq.com', '123123123123123123', 'http://localhost:8080/ssmhn4b5/upload/1618376292278.jpg');
INSERT INTO `xuesheng` VALUES (1618376476788, '2024-04-14 13:01:16', '100', '123456', '李四', '男', 21, '12312312312', '213@qq.com', '123131123123123123', 'http://localhost:8080/ssmhn4b5/upload/1618376494403.jpg');

SET FOREIGN_KEY_CHECKS = 1;