/*
 Navicat Premium Data Transfer

 Source Server         : 本机
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : volunteer

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

 Date: 10/07/2023 09:46:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for activity
-- ----------------------------
DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `brief_Introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `detail_Introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `time_Begin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `time_End` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `register_Begin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `register_End` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `register_Max` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `state` int NULL DEFAULT NULL,
  `image_Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `image_Location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of activity
-- ----------------------------
INSERT INTO `activity` VALUES (3, '宣传环保知识', '宣传环保知识，共创绿色校园', '保护环境，人人有责，速来参与！', '2023-7-1 9:00', '2023-7-1 12:00', '2023-6-1 9:00', '2023-7-1 9:00', '虎溪校区二食堂', '100', 0, '未定', '未定');
INSERT INTO `activity` VALUES (4, '让轮椅飞', '飞轮椅', '芜湖起飞', '2023-7-2 8:00', '2023-7-2 19:00', '2023-6-2 00:00', '2023-7-2 8:00', '重大养老院', '10', 0, '未定', '未定');
INSERT INTO `activity` VALUES (5, '名师一堂课', '听课', '在xxxx听名师讲课', '2023-7-2 8:00', '2023-7-2 8:00', '2023-7-2 8:00', '2023-7-2 8:00', '图书馆', '20', 0, '未定', '未定');
INSERT INTO `activity` VALUES (6, '睡前讲故事', '睡前故事', '给xxx讲故事', '2023-7-2 8:00', '2023-7-2 8:00', '2023-7-2 8:00', '2023-7-2 8:00', '床上', '5', 0, '未定', '未定');

-- ----------------------------
-- Table structure for advertisement
-- ----------------------------
DROP TABLE IF EXISTS `advertisement`;
CREATE TABLE `advertisement`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `image_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `state` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of advertisement
-- ----------------------------
INSERT INTO `advertisement` VALUES (1, '不能在丢垃圾时，丢了自己的脸', '共建绿色校园，不乱扔垃圾', '未定', '未定', 1);
INSERT INTO `advertisement` VALUES (2, '讲文明 树新风', '讲文明，有礼貌', '未定', '未定', 1);
INSERT INTO `advertisement` VALUES (3, '图说价值观', '公益广告，图说价值观', '未定', '未定', 1);

-- ----------------------------
-- Table structure for ask_for_help
-- ----------------------------
DROP TABLE IF EXISTS `ask_for_help`;
CREATE TABLE `ask_for_help`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `request_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `request_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `answer_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `answer_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ask_for_help
-- ----------------------------
INSERT INTO `ask_for_help` VALUES (1, '20204273', '蒋佐方', NULL, NULL, '带饭', '松园635带饭', '2023-7-9', '松园', '1');
INSERT INTO `ask_for_help` VALUES (2, '20204261', '曾一航', '20204273', '蒋佐方', '签到', '帮忙签到', '2023-7-8', 'DS3401', '0');
INSERT INTO `ask_for_help` VALUES (3, '20204000', '张三', NULL, NULL, '搬运行李', '搬运行李，从松园到梅园', '2013-7-9 12:00', '松园', '1');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `writter_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `contain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (1, '曾一航同学评为635雷锋', '曾一航', '2023-7-1', '该同学坚持带饭，风雨无阻，评为雷锋', '4');
INSERT INTO `news` VALUES (2, '文明重大', '教务处', '2023-7-1', '建设文明重大取得突破性进展，重大同学文质彬彬有礼貌', '1');
INSERT INTO `news` VALUES (3, '志愿者网站年度报告', '重庆大学学生会', '2023-6-1', '志愿者网站年度报告', '3');
INSERT INTO `news` VALUES (4, '志愿者App注册人数突破', '重庆大学', '2023-6-1', '志愿者App注册用户实现0的突破，可喜可贺', '2');

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `brief_introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `detail_introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of project
-- ----------------------------
INSERT INTO `project` VALUES (1, '重庆大学志愿者APP', '项目介绍', '详细介绍', '1', '暂无');
INSERT INTO `project` VALUES (2, '重庆大学志愿者网', '项目介绍', '详细介绍', '2', '暂无');
INSERT INTO `project` VALUES (3, '雷锋热线', '项目介绍', '详细介绍', '3', '暂无');

-- ----------------------------
-- Table structure for promotion_video
-- ----------------------------
DROP TABLE IF EXISTS `promotion_video`;
CREATE TABLE `promotion_video`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of promotion_video
-- ----------------------------
INSERT INTO `promotion_video` VALUES (1, 'cqu志愿者网宣传视频', '1', 'cqu志愿者网宣传视频');
INSERT INTO `promotion_video` VALUES (2, '雷锋热线宣传视频', '2', '雷锋热线宣传视频');
INSERT INTO `promotion_video` VALUES (3, '志愿者曾一航同学视频介绍', '1', '志愿者曾一航同学视频介绍');

-- ----------------------------
-- Table structure for volunteer
-- ----------------------------
DROP TABLE IF EXISTS `volunteer`;
CREATE TABLE `volunteer`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `true_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `register_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `politic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `occupation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `zipcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of volunteer
-- ----------------------------
INSERT INTO `volunteer` VALUES (1, '热心的大白菜', '123456', '12345678901', '111@qq.com', '张三', '男', '2023-7-1', '20204200', '共青团员', '本科生', '重庆市沙坪坝区', '重庆大学', '400000', '1', '志愿者');
INSERT INTO `volunteer` VALUES (2, '热心的志愿者', '123456', '12345678901', '111@qq.com', '李四', '男', '2023-1-1', '20204201', '群众', '本科生', '重庆市沙坪坝区', '重庆大学', '400000', '1', '志愿者');
INSERT INTO `volunteer` VALUES (3, '重大雷锋', '123456', '12345678901', '111@qq.com', '王五', '男', '2023-4-1', '20204202', '党员', '本科生', '重庆市沙坪坝区', '重庆大学', '400000', '1', '管理员');

-- ----------------------------
-- Table structure for volunteer_activity
-- ----------------------------
DROP TABLE IF EXISTS `volunteer_activity`;
CREATE TABLE `volunteer_activity`  (
  `volunteer_id` int NULL DEFAULT NULL,
  `activity_id` int NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of volunteer_activity
-- ----------------------------
INSERT INTO `volunteer_activity` VALUES (20204200, 1);
INSERT INTO `volunteer_activity` VALUES (20204200, 2);

-- ----------------------------
-- Table structure for volunteer_help
-- ----------------------------
DROP TABLE IF EXISTS `volunteer_help`;
CREATE TABLE `volunteer_help`  (
  `volunteer_id` int NULL DEFAULT NULL,
  `ask_for_help_id` int NULL DEFAULT NULL,
  `give_help_id` int NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of volunteer_help
-- ----------------------------
INSERT INTO `volunteer_help` VALUES (20204200, 3, NULL);
INSERT INTO `volunteer_help` VALUES (20204260, 2, NULL);
INSERT INTO `volunteer_help` VALUES (20204273, 1, 2);

SET FOREIGN_KEY_CHECKS = 1;