pet-rescue-platform
/
pet_rescue.sql

/*
 Navicat Premium Data Transfer

 Source Server         : ubuntu_Mysql
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : 112.74.74.89:3306
 Source Schema         : pet_rescue

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

 Date: 10/05/2020 23:16:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for check_info
-- ----------------------------
DROP TABLE IF EXISTS `check_info`;
CREATE TABLE `check_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `rescue_id` int(11) NOT NULL COMMENT '救助者id外键',
  `seeker_id` int(11) NOT NULL COMMENT '求助者id外键',
  `post_id` int(11) NOT NULL COMMENT '帖子id外键',
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `post_id_check`(`post_id`) USING BTREE,
  INDEX `rescue_id_check`(`rescue_id`) USING BTREE,
  INDEX `seeker_id_check`(`seeker_id`) USING BTREE,
  CONSTRAINT `post_id_check` FOREIGN KEY (`post_id`) REFERENCES `post_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `rescue_id_check` FOREIGN KEY (`rescue_id`) REFERENCES `user_info` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `seeker_id_check` FOREIGN KEY (`seeker_id`) REFERENCES `user_info` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for comment_info
-- ----------------------------
DROP TABLE IF EXISTS `comment_info`;
CREATE TABLE `comment_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论表id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '评论者id',
  `post_id` int(11) NULL DEFAULT NULL COMMENT '内容id(在哪个内容下评论的)',
  `createtime` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '插入时间',
  `content` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论的内容',
  `author_id` int(11) NULL DEFAULT NULL COMMENT '给谁（该内容id的作者）留言',
  `state` int(11) NULL DEFAULT NULL COMMENT '0-未读，1-已读',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `userid`(`user_id`) USING BTREE,
  INDEX `contentid`(`post_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for image_info
-- ----------------------------
DROP TABLE IF EXISTS `image_info`;
CREATE TABLE `image_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '图片编号\r\n图片编号',
  `post_id` int(11) NOT NULL COMMENT '帖子id外键',
  `href` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片地址',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `post_id_pic`(`post_id`) USING BTREE,
  CONSTRAINT `post_id_pic` FOREIGN KEY (`post_id`) REFERENCES `post_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for post_info
-- ----------------------------
DROP TABLE IF EXISTS `post_info`;
CREATE TABLE `post_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '审核编号',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题',
  `gist` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '概要',
  `main` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详细信息',
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态',
  `time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '城市',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '求助类型',
  `user_id` int(11) NOT NULL COMMENT '所属用户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `post_user`(`user_id`) USING BTREE,
  CONSTRAINT `post_user` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1012 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of post_info
-- ----------------------------
INSERT INTO `post_info` VALUES (1008, 'aaa', 'aa', 'aaa', 'aaa', '2020-05-08 21:00:00', 'aaa', '已上传', 4);
INSERT INTO `post_info` VALUES (1009, 'aaa', 'aaa', 'aaa', '已上传', '2020-05-08 21:00:30', 'aaa', 'aaa', 4);
INSERT INTO `post_info` VALUES (1010, 'aaa', 'aaa', 'aaa', '已上传', '2020-05-08 22:17:57', 'aaa', 'aaa', 4);
INSERT INTO `post_info` VALUES (1011, 'aaa', 'aaa', 'aaa', '已上传', '2020-05-08 22:18:53', 'aaa', 'aaa', 4);

-- ----------------------------
-- Table structure for reply_info
-- ----------------------------
DROP TABLE IF EXISTS `reply_info`;
CREATE TABLE `reply_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '回复表id',
  `user_id` int(50) NULL DEFAULT NULL COMMENT '回复的用户账号',
  `createtime` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '插入时间',
  `content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复的内容',
  `other_id` int(11) NULL DEFAULT NULL COMMENT '给谁回复',
  `comment_id` int(11) NULL DEFAULT NULL COMMENT '在哪个留言下的回复',
  `post_id` int(11) NULL DEFAULT NULL COMMENT '那篇分享下的回复',
  `state` int(11) NULL DEFAULT NULL COMMENT '0-未读，1-已读',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
  `sex` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户性别',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户电话',
  `qq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户qq',
  `wechat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户微信',
  `experience` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '经验',
  `role` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0,管理员 1.用户',
  `birth` date NULL DEFAULT NULL COMMENT '出生日期',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (4, 'aaa', 'aaa', 'aaa', '男', '1111111', '111111111', '11111111111', '1111111111111', '1', '2000-01-01', '广州');
INSERT INTO `user_info` VALUES (5, 'bbb', 'bbb', 'bbb', '男', '222222222', '222222222222', '2222222222', '22222222222222', '1', '2000-02-02', '广州');
INSERT INTO `user_info` VALUES (6, 'ccc', 'ccc', 'ccc', '女', '33333333', '3333333', '33333333', '33333333', '1', '2000-03-03', '广州');
INSERT INTO `user_info` VALUES (9, NULL, 'alan', 'alan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;