table.sql

一个jsp写的bbs

CREATE TABLE `bbscs_agreeagainst` (
  `ID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `PostID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `VoteType` tinyint(1) default '0',
  `CreateTime` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `id` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_board` (
  `ID` bigint(20) NOT NULL auto_increment,
  `ParentID` bigint(20) NOT NULL default '0',
  `ParentIDs` varchar(255) default NULL,
  `ChildIDs` varchar(255) default NULL,
  `BoardName` varchar(60) NOT NULL default '',
  `Explains` text,
  `Bulletin` text,
  `BoardPic` varchar(200) default NULL,
  `UseStat` tinyint(1) default '1',
  `Orders` int(11) default '0',
  `NeedPasswd` tinyint(1) default '0',
  `Passwd` varchar(100) default NULL,
  `BoardLevel` int(11) default '0',
  `BoardType` tinyint(3) default '0',
  `AllowHTML` tinyint(1) default '0',
  `AllowUBB` tinyint(1) default '0',
  `AuditPost` tinyint(1) default '0',
  `AuditAttach` tinyint(1) default '0',
  `AddUserPostNum` tinyint(1) default '1',
  `IsHidden` tinyint(1) default '0',
  `IsAuth` tinyint(1) default '0',
  `MainPostNum` int(11) default '0',
  `PostNum` int(11) default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_boardauthuser` (
  `ID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `UserID` varchar(40) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `CreateTime` bigint(20) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_boardmaster` (
  `ID` bigint(20) NOT NULL auto_increment,
  `BoardID` bigint(20) NOT NULL default '0',
  `UserName` varchar(20) NOT NULL default '',
  `Purview` varchar(200) default NULL,
  `RoleID` int(11) default '0',
  `OverChildPurview` tinyint(3) default '0',
  `IsHidden` tinyint(3) default '0',
  PRIMARY KEY  (`ID`),
  KEY `BoardID` (`BoardID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_boardpermission` (
  `ID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `GroupID` int(11) NOT NULL default '0',
  `Permissions` text,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `BoardID_GroupID` (`BoardID`,`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_boardsave` (
  `ID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  UNIQUE KEY `UserID` (`UserID`,`BoardID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_boardtag` (
  `ID` varchar(40) NOT NULL,
  `BoardID` bigint(20) NOT NULL,
  `TagName` varchar(255) NOT NULL,
  `Orders` int(11) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_bookmark` (
  `ID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `BookMarkName` varchar(255) NOT NULL default '',
  `Url` varchar(255) default NULL,
  `Alt` varchar(255) default NULL,
  `IsShare` tinyint(1) default '1',
  `CreateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `UserID` (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_choice` (
  `ID` varchar(40) NOT NULL default '',
  `CategoryID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) NOT NULL default '',
  `PostID` varchar(40) NOT NULL default '',
  `PostMainID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `UserNickName` varchar(60) default NULL,
  `Title` varchar(150) default NULL,
  `CreateTime` bigint(20) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_choicecategory` (
  `ID` varchar(40) NOT NULL default '',
  `CategoryName` varchar(60) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `UseStat` tinyint(1) NOT NULL default '1',
  `Orders` int(11) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_commend` (
  `ID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) NOT NULL default '',
  `PostID` varchar(40) NOT NULL default '',
  `PostMainID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `CommendBoardID` bigint(20) NOT NULL default '0',
  `CommendTop` tinyint(1) NOT NULL default '0',
  `Title` varchar(150) default NULL,
  `BoardCategory` varchar(40) default NULL,
  `TopCategory` varchar(40) default NULL,
  `CreateTime` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_config` (
  `ID` varchar(50) NOT NULL default '',
  `ConfContext` text,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_elite` (
  `ID` bigint(20) NOT NULL auto_increment,
  `BoardID` bigint(20) NOT NULL default '0',
  `ParentID` bigint(20) NOT NULL default '0',
  `ParentIDs` text,
  `EliteName` varchar(90) default NULL,
  `CreateUser` varchar(60) default NULL,
  `EliteTime` bigint(20) default '0',
  `Orders` int(11) default '0',
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_forum` (
  `ID` varchar(40) NOT NULL default '',
  `ParentID` varchar(40) NOT NULL default '',
  `MainID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) default NULL,
  `ReNum` int(11) default '0',
  `Face` tinyint(2) default '1',
  `UserID` varchar(40) default NULL,
  `UserName` varchar(20) default NULL,
  `NickName` varchar(60) default NULL,
  `Title` varchar(150) default NULL,
  `Detail` text,
  `Sign` text,
  `ArtSize` int(11) default '0',
  `Click` int(11) default '0',
  `PostTime` bigint(20) default '0',
  `LastTime` bigint(20) default '0',
  `IPAddress` varchar(20) default NULL,
  `IsNew` tinyint(1) default '0',
  `Elite` bigint(20) default '0',
  `EliteID` bigint(20) default '0',
  `Agree` int(11) default '0',
  `BeAgainst` int(11) default '0',
  `CanNotDel` tinyint(1) default '0',
  `CanNotRe` tinyint(1) default '0',
  `Commend` bigint(20) default '0',
  `DelSign` tinyint(1) default '0',
  `DelUserID` varchar(40) default NULL,
  `DelUserName` varchar(20) default NULL,
  `DelTime` bigint(20) default '0',
  `DelIP` varchar(20) default NULL,
  `Amend` varchar(255) default NULL,
  `DoEliteName` varchar(20) default '0',
  `DoEliteTime` bigint(20) default '0',
  `HaveAttachFile` tinyint(1) default '0',
  `AttachFileName` text,
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTitle` varchar(150) default NULL,
  `LastPostNickName` varchar(60) default NULL,
  `IsTop` bigint(20) default '0',
  `IsLock` tinyint(1) default '0',
  `Auditing` tinyint(1) default '0',
  `AuditingAttachFile` tinyint(1) default '0',
  `IsVote` tinyint(1) default '0',
  `IsHidden` tinyint(4) default '0',
  `IsHiddenValue` int(11) default '1',
  `EditType` tinyint(1) default '0',
  `QuoteText` text,
  `QuoteEditType` tinyint(1) default '0',
  `PostType` tinyint(1) default '0',
  `TitleColor` tinyint(2) default '0',
  `UserBlog` tinyint(1) default '0',
  `IndexStatus` tinyint(1) default '0',
  `EmailInform` tinyint(1) default '0',
  `MsgInform` tinyint(1) default '0',
  `VoteID` varchar(40) default NULL,
  `TagID` varchar(40) default '0',
  `TagName` varchar(255) default NULL,
  `IsGuest` tinyint(1) default '0',
  `PreviewAttach` tinyint(1) DEFAULT '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `MainID` (`MainID`),
  KEY `BoardID` (`BoardID`),
  KEY `IsNew` (`IsNew`),
  KEY `DelSign` (`DelSign`),
  KEY `LastTime` (`LastTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_forum_history` (
  `ID` varchar(40) NOT NULL default '',
  `ParentID` varchar(40) NOT NULL default '',
  `MainID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) default NULL,
  `ReNum` int(11) default '0',
  `Face` tinyint(2) default '1',
  `UserID` varchar(40) default NULL,
  `UserName` varchar(20) default NULL,
  `NickName` varchar(60) default NULL,
  `Title` varchar(150) default NULL,
  `Detail` text,
  `Sign` text,
  `ArtSize` int(11) default '0',
  `Click` int(11) default '0',
  `PostTime` bigint(20) default '0',
  `LastTime` bigint(20) default '0',
  `IPAddress` varchar(20) default NULL,
  `IsNew` tinyint(1) default '0',
  `Elite` bigint(20) default '0',
  `EliteID` bigint(20) default '0',
  `Agree` int(11) default '0',
  `BeAgainst` int(11) default '0',
  `CanNotDel` tinyint(1) default '0',
  `CanNotRe` tinyint(1) default '0',
  `Commend` bigint(20) default '0',
  `DelSign` tinyint(1) default '0',
  `DelUserID` varchar(40) default NULL,
  `DelUserName` varchar(20) default NULL,
  `DelTime` bigint(20) default '0',
  `DelIP` varchar(20) default NULL,
  `Amend` varchar(255) default NULL,
  `DoEliteName` varchar(20) default '0',
  `DoEliteTime` bigint(20) default '0',
  `HaveAttachFile` tinyint(1) default '0',
  `AttachFileName` text,
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTitle` varchar(150) default NULL,
  `LastPostNickName` varchar(60) default NULL,
  `IsTop` bigint(20) default '0',
  `IsLock` tinyint(1) default '0',
  `Auditing` tinyint(1) default '0',
  `AuditingAttachFile` tinyint(1) default '0',
  `IsVote` tinyint(1) default '0',
  `IsHidden` tinyint(4) default '0',
  `IsHiddenValue` int(11) default '1',
  `EditType` tinyint(1) default '0',
  `QuoteText` text,
  `QuoteEditType` tinyint(1) default '0',
  `PostType` tinyint(1) default '0',
  `TitleColor` tinyint(2) default '0',
  `UserBlog` tinyint(1) default '0',