shequ
/
完整数据库代码.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50726
Source Host           : localhost:3306
Source Database       : shequ1

Target Server Type    : MYSQL
Target Server Version : 50726
File Encoding         : 65001

Date: 2022-04-30 09:34:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tb_member
-- ----------------------------
DROP TABLE IF EXISTS `tb_member`;
CREATE TABLE `tb_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) DEFAULT NULL,
  `nickname` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `avatar` varchar(50) DEFAULT NULL,
  `sex` int(1) DEFAULT '0',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  `delete_time` int(11) DEFAULT NULL,
  `signature` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `hits_comment` int(11) DEFAULT '0',
  `points` int(11) DEFAULT '0',
  `ident` int(11) DEFAULT '0' COMMENT '认证情况',
  `vip` int(11) DEFAULT '0',
  `hitsfans` int(11) DEFAULT '0',
  `hitsfollows` int(11) DEFAULT '0',
  `hitsthreads` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `openid_qq` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='前台会员';

-- ----------------------------
-- Records of tb_member
-- ----------------------------

-- ----------------------------
-- Table structure for tb_member_follow
-- ----------------------------
DROP TABLE IF EXISTS `tb_member_follow`;
CREATE TABLE `tb_member_follow` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `follow_who` int(11) NOT NULL COMMENT '关注谁',
  `who_follow` int(11) NOT NULL COMMENT '谁关注',
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='关注表';

-- ----------------------------
-- Records of tb_member_follow
-- ----------------------------

-- ----------------------------
-- Table structure for tb_member_ident
-- ----------------------------
DROP TABLE IF EXISTS `tb_member_ident`;
CREATE TABLE `tb_member_ident` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `identification` varchar(55) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_member_ident
-- ----------------------------

-- ----------------------------
-- Table structure for tb_member_sign
-- ----------------------------
DROP TABLE IF EXISTS `tb_member_sign`;
CREATE TABLE `tb_member_sign` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `points` int(6) NOT NULL COMMENT '签到积分',
  `num` int(8) NOT NULL DEFAULT '0' COMMENT '连续签到次数',
  `sign_time` int(10) NOT NULL COMMENT '签到时间',
  `create_time` int(10) NOT NULL,
  `sign_ip` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_member_sign
-- ----------------------------

-- ----------------------------
-- Table structure for tb_member_wish_thread
-- ----------------------------
DROP TABLE IF EXISTS `tb_member_wish_thread`;
CREATE TABLE `tb_member_wish_thread` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_member_wish_thread
-- ----------------------------

-- ----------------------------
-- Table structure for tb_message
-- ----------------------------
DROP TABLE IF EXISTS `tb_message`;
CREATE TABLE `tb_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `send_id` int(11) DEFAULT '0',
  `recv_id` int(11) DEFAULT '0' COMMENT '如果是0，则发给所有人',
  `message_id` int(11) DEFAULT '0',
  `status` tinyint(4) DEFAULT '0' COMMENT '0未读，1读了',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_message
-- ----------------------------

-- ----------------------------
-- Table structure for tb_message_text
-- ----------------------------
DROP TABLE IF EXISTS `tb_message_text`;
CREATE TABLE `tb_message_text` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `message` text,
  `create_time` int(10) DEFAULT NULL COMMENT '站内信发送的时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_message_text
-- ----------------------------

-- ----------------------------
-- Table structure for tb_nav
-- ----------------------------
DROP TABLE IF EXISTS `tb_nav`;
CREATE TABLE `tb_nav` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `image` varchar(255) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `listorder` int(11) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `href` varchar(255) DEFAULT NULL,
  `target` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `expire_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_nav
-- ----------------------------

-- ----------------------------
-- Table structure for tb_nav_cat
-- ----------------------------
DROP TABLE IF EXISTS `tb_nav_cat`;
CREATE TABLE `tb_nav_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `listorder` int(11) DEFAULT NULL,
  `alias` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_nav_cat
-- ----------------------------
INSERT INTO `tb_nav_cat` VALUES ('3', '友情链接', '0', 'friend_links');
INSERT INTO `tb_nav_cat` VALUES ('5', '温馨通道', null, 'quick');

-- ----------------------------
-- Table structure for tb_pinyin
-- ----------------------------
DROP TABLE IF EXISTS `tb_pinyin`;
CREATE TABLE `tb_pinyin` (
  `py` char(1) NOT NULL,
  `begin` smallint(5) unsigned NOT NULL,
  `end` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`py`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_pinyin
-- ----------------------------
INSERT INTO `tb_pinyin` VALUES ('A', '45217', '45252');
INSERT INTO `tb_pinyin` VALUES ('B', '45253', '45760');
INSERT INTO `tb_pinyin` VALUES ('C', '45761', '46317');
INSERT INTO `tb_pinyin` VALUES ('D', '46318', '46825');
INSERT INTO `tb_pinyin` VALUES ('E', '46826', '47009');
INSERT INTO `tb_pinyin` VALUES ('F', '47010', '47296');
INSERT INTO `tb_pinyin` VALUES ('G', '47297', '47613');
INSERT INTO `tb_pinyin` VALUES ('H', '47614', '48118');
INSERT INTO `tb_pinyin` VALUES ('J', '48119', '49061');
INSERT INTO `tb_pinyin` VALUES ('K', '49062', '49323');
INSERT INTO `tb_pinyin` VALUES ('L', '49324', '49895');
INSERT INTO `tb_pinyin` VALUES ('M', '49896', '50370');
INSERT INTO `tb_pinyin` VALUES ('N', '50371', '50613');
INSERT INTO `tb_pinyin` VALUES ('O', '50614', '50621');
INSERT INTO `tb_pinyin` VALUES ('P', '50622', '50905');
INSERT INTO `tb_pinyin` VALUES ('Q', '50906', '51386');
INSERT INTO `tb_pinyin` VALUES ('R', '51387', '51445');
INSERT INTO `tb_pinyin` VALUES ('S', '51446', '52217');
INSERT INTO `tb_pinyin` VALUES ('T', '52218', '52697');
INSERT INTO `tb_pinyin` VALUES ('W', '52698', '52979');
INSERT INTO `tb_pinyin` VALUES ('X', '52980', '53640');
INSERT INTO `tb_pinyin` VALUES ('Y', '53689', '54480');
INSERT INTO `tb_pinyin` VALUES ('Z', '54481', '55289');

-- ----------------------------
-- Table structure for tb_system_route
-- ----------------------------
DROP TABLE IF EXISTS `tb_system_route`;
CREATE TABLE `tb_system_route` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `full_url` varchar(255) NOT NULL COMMENT '完整url， 如：portal/list/index?id=1',
  `url` varchar(255) NOT NULL COMMENT '实际显示的url',
  `listorder` int(5) NOT NULL DEFAULT '0' COMMENT '排序--优先级，越小优先级越高',
  `type` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='URL路由';

-- ----------------------------
-- Records of tb_system_route
-- ----------------------------

-- ----------------------------
-- Table structure for tb_system_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_system_user`;
CREATE TABLE `tb_system_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(55) NOT NULL,
  `password` varchar(55) NOT NULL,
  `nickname` varchar(55) NOT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='后台用户';

-- ----------------------------
-- Records of tb_system_user
-- ----------------------------
INSERT INTO `tb_system_user` VALUES ('1', 'admin', 'a1662a0ae9b29976985b3e57404b3419', '超级管理员', '1651282324', '1651282324');

-- ----------------------------
-- Table structure for tb_thread
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread`;
CREATE TABLE `tb_thread` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `content` text NOT NULL,
  `cid` int(11) NOT NULL COMMENT '所属栏目',
  `points` int(11) NOT NULL COMMENT '悬赏积分',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态 1精华',
  `recommend` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
  `top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  `delete_time` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `hits_zan` int(11) DEFAULT '0',
  `hits_comment` int(11) DEFAULT '0',
  `hits_wish` int(11) DEFAULT '0',
  `hits` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='帖子';

-- ----------------------------
-- Records of tb_thread
-- ----------------------------

-- ----------------------------
-- Table structure for tb_thread_column
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread_column`;
CREATE TABLE `tb_thread_column` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `alias` varchar(55) NOT NULL,
  `publish_type` int(11) NOT NULL DEFAULT '0' COMMENT '发贴权限',
  `join_type` int(11) NOT NULL DEFAULT '0' COMMENT '进入权限',
  `vip_limit` int(11) NOT NULL DEFAULT '0' COMMENT '进入权限(vip级别)',
  `points_limit` int(11) NOT NULL DEFAULT '0' COMMENT '进入权限(积分值)',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='论坛栏目';

-- ----------------------------
-- Records of tb_thread_column
-- ----------------------------
INSERT INTO `tb_thread_column` VALUES ('12', '提问', 'question', '0', '0', '0', '0');
INSERT INTO `tb_thread_column` VALUES ('13', '分享', 'share', '0', '0', '0', '0');
INSERT INTO `tb_thread_column` VALUES ('14', '讨论', 'discuss', '0', '0', '0', '0');
INSERT INTO `tb_thread_column` VALUES ('15', '建议', 'suggest', '0', '0', '0', '0');
INSERT INTO `tb_thread_column` VALUES ('16', '公告', 'notice', '0', '2', '1', '5');
INSERT INTO `tb_thread_column` VALUES ('17', '美女', 'prettily-girl', '0', '1', '1', '10');

-- ----------------------------
-- Table structure for tb_thread_column_member
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread_column_member`;
CREATE TABLE `tb_thread_column_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `column_id` int(11) NOT NULL,
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_thread_column_member
-- ----------------------------

-- ----------------------------
-- Table structure for tb_thread_comment
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread_comment`;
CREATE TABLE `tb_thread_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(500) NOT NULL,
  `create_time` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `is_take` int(1) NOT NULL DEFAULT '0' COMMENT '是否被采纳',
  `hits_zan` int(11) NOT NULL DEFAULT '0' COMMENT '赞数量',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='帖子回复';

-- ----------------------------
-- Records of tb_thread_comment
-- ----------------------------

-- ----------------------------
-- Table structure for tb_thread_comment_hits_zan
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread_comment_hits_zan`;
CREATE TABLE `tb_thread_comment_hits_zan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `thread_comment_id` int(11) NOT NULL,
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_thread_comment_hits_zan
-- ----------------------------

-- ----------------------------
-- Table structure for tb_thread_hits_comment
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread_hits_comment`;
CREATE TABLE `tb_thread_hits_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_thread_hits_comment
-- ----------------------------

-- ----------------------------
-- Table structure for tb_thread_hits_wish
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread_hits_wish`;
CREATE TABLE `tb_thread_hits_wish` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_thread_hits_wish
-- ----------------------------

-- ----------------------------
-- Table structure for tb_thread_hits_zan
-- ----------------------------
DROP TABLE IF EXISTS `tb_thread_hits_zan`;
CREATE TABLE `tb_thread_hits_zan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_thread_hits_zan
-- ----------------------------