MYSQL创建BBS表，表外键自己加，仅供参考

最新推荐文章于 2021-03-05 19:57:19 发布

醉清凨

最新推荐文章于 2021-03-05 19:57:19 发布

阅读量869

点赞数

分类专栏： BBS之路文章标签： bbs mysql

本文链接：https://blog.csdn.net/studayit/article/details/17687053

版权

BBS之路专栏收录该内容

1 篇文章 0 订阅

订阅专栏

CREATE TABLE BBS_USER (
  uid int(11) NOT NULL AUTO_INCREMENT,
  uname varchar(20) NOT NULL UNIQUE,
  upwd varchar(40) NOT NULL,
  email varchar(50) NOT NULL UNIQUE,
  active_code varchar(36) NOT NULL,
  status int(1) not null,
  register_time DATE not null,
  active_time DATE default null,
  nikename varchar(50) not null,
  PRIMARY KEY (uid)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=GBK;


CREATE TABLE BBS_BOARD (
  id int(9) NOT NULL AUTO_INCREMENT,
  BOARD_NAME varchar(100) NOT NULL UNIQUE,
  BOARD_DESC varchar(500) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=GBK;

CREATE TABLE BBS_MODERATOR (
  id int(9) NOT NULL AUTO_INCREMENT,
  BOARD_id int(9) NOT NULL,
  MODERATOR varchar(20) NOT NULL UNIQUE,
  CREATE_TIME DATE NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=GBK;

CREATE TABLE BBS_POST (
  ID INT(9) NOT NULL AUTO_INCREMENT,
  SUBJECT VARCHAR(200) NOT NULL,
  POST_UNAME VARCHAR(20),
  POST_TIME DATE NOT NULL,
  BOARD_ID INT(9) NOT NULL,
  POST_CONTENT TEXT NOT NULL,
  REPLY_AMOUNT INT(9) NOT NULL,
  LAST_REPLY_UNAME VARCHAR(20),
  LAST_REPLY_TIME DATE,
  STATUS INT(2) NOT NULL,
  PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=GBK;

CREATE TABLE BBS_POST_PROCESS_HIS(
   ID INT(9) NOT NULL AUTO_INCREMENT,
   POST_ID INT(9) NOT NULL,
   MODERATOR vARCHAR(20) NOT NULL,
   STATUS INT(2) NOT NULL,
   CAUSE INT(2) NOT NULL,
   CONTENT VARCHAR(2000) NOT NULL,
   PRIMARY KEY (ID)
)ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=GBK;

CREATE TABLE BBS_REPLY(
   ID INT(9) NOT NULL AUTO_INCREMENT,
   REPLY_UNAME VARCHAR(20) NOT NULL,
   REPLY_TIME DATE NOT NULL,
   REPLY_CONTENT text NOT NULL,
   STATUS INT(2) NOT NULL,
   PRIMARY KEY (ID)
)ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=GBK;

CREATE TABLE BBS_POST_reply_HIS(
   ID INT(9) NOT NULL AUTO_INCREMENT,
   REPLY_ID INT(9) NOT NULL,
   MODERATOR vARCHAR(20) NOT NULL,
   STATUS INT(2) NOT NULL,
   CAUSE INT(2) NOT NULL,
   CONTENT VARCHAR(2000) NOT NULL,
   PRIMARY KEY (ID)
)ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=GBK;