bbs_mysql.sql

来自「java管理项目的程序用Eclipse开发」· SQL 代码 · 共 84 行

# MySQL-Front 3.2  (Build 8.3)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;

/*!40101 SET NAMES gbk */;
/*!40103 SET TIME_ZONE='SYSTEM' */;

USE `easyjf`;
CREATE TABLE `bbsdir` (
  `cid` varchar(16) NOT NULL,
  `sn` varchar(16) NOT NULL,
  `title` varchar(100) default NULL,
  `parentSN` varchar(50) default NULL,
  `dirPath` varchar(250) default NULL,
  `intro` text,
  `tagImg` varchar(50) default NULL,
  `manager` varchar(50) default NULL,
  `subManager` varchar(50) default NULL,
  `vRType` varchar(50) default NULL,
  `vRValue` varchar(10) default NULL,
  `status` int(11) default NULL,
  `sequence` int(11) default NULL,
  `types` int(11) default NULL,
  `inputUser` varchar(16) default NULL,
  `inputTime` datetime default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

CREATE TABLE `bbsdoc` (
  `cid` varchar(16) NOT NULL,
  `dirSn` varchar(50) default NULL,
  `parentId` varchar(50) default NULL,
  `title` varchar(150) default NULL,
  `content` longtext,
  `intro` text,
  `files` varchar(50) default NULL,
  `imgs` varchar(150) default NULL,
  `readTimes` int(11) default NULL,
  `tagPic` varchar(50) default NULL,
  `voteScore` int(11) default NULL,
  `score` int(11) default NULL,
  `vRType` varchar(50) default NULL,
  `vRValue` varchar(50) default NULL,
  `inputTime` datetime default NULL,
  `inputUser` varchar(50) default NULL,
  `modifyTime` datetime default NULL,
  `ip` varchar(50) default NULL,
  `clientInfo` varchar(150) default NULL,
  `bad` int(11) default NULL,
  `good` int(11) default NULL,
  `source` varchar(50) default NULL,
  `topMessage` int(11) default NULL,
  `eliteMessage` int(11) default NULL,
  `status` int(11) default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

CREATE TABLE `bbsuser` (
  `cid` varchar(16) NOT NULL,
  `userName` varchar(16) NOT NULL,
  `password` varchar(16) NOT NULL,
  `sex` varchar(10) default NULL,
  `email` varchar(50) default NULL,
  `tel` varchar(50) default NULL,
  `loginTimes` int(11) default NULL,
  `status` int(11) default NULL,
  `inputTime` datetime default NULL,
  `intro` text,
  `lastLoginTime` datetime default NULL,
  `lastLoginIP` varchar(50) default NULL,
  `photo` varchar(50) default NULL,
  `qq` varchar(50) default NULL,
  `score` int(11) default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;