table.sql

一个jsp写的bbs

  `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_forumbuy` (
  `ID` varchar(40) NOT NULL,
  `PostID` varchar(40) NOT NULL,
  `BuyFromID` varchar(40) NOT NULL,
  `BuyFromName` varchar(20) NOT NULL,
  `BuyToID` varchar(40) NOT NULL,
  `BuyToName` varchar(20) NOT NULL,
  `BuyPrice` int(11) NOT NULL default '0',
  `BuyToUserIncome` int(11) NOT NULL default '0',
  `BuyTime` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_friend` (
  `ID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `FriendID` varchar(40) NOT NULL default '',
  `FriendName` varchar(20) NOT NULL default '',
  `FriendComment` text,
  `IsBlack` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `UserID` (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_grouprole` (
  `GroupID` int(11) NOT NULL default '0',
  `RoleID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`GroupID`,`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_loginerror` (
  `ID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `ErrorTimes` int(11) NOT NULL default '0',
  `LoginTime` bigint(20) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  UNIQUE KEY `UserID` (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_note` (
  `ID` varchar(40) NOT NULL default '',
  `FromID` varchar(40) NOT NULL default '',
  `FromUserName` varchar(20) NOT NULL default '',
  `FromNickName` varchar(60) NOT NULL default '',
  `ToID` varchar(40) NOT NULL default '',
  `ToUserName` varchar(20) NOT NULL default '',
  `ToNickName` varchar(60) NOT NULL default '',
  `NoteType` tinyint(1) NOT NULL default '0',
  `NoteTitle` varchar(150) NOT NULL default '',
  `NoteContext` text NOT NULL,
  `CreateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `IsNew` tinyint(1) default '1',
  `NeedRe` tinyint(1) default '0',
  `IsRe` tinyint(1) default '0',
  `SysMsg` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `FromID` (`FromID`),
  KEY `ToID` (`ToID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_permission` (
  `ID` bigint(20) NOT NULL default '0',
  `PermissionName` varchar(255) NOT NULL default '',
  `PermissionResource` varchar(255) default NULL,
  `Action` varchar(255) default NULL,
  `TypeID` int(2) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_role` (
  `ID` int(11) NOT NULL auto_increment,
  `RoleName` varchar(255) NOT NULL default '',
  `TypeID` int(2) NOT NULL default '0',
  `Permissions` text,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_subscibe` (
  `ID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `NickName` varchar(60) NOT NULL default '',
  `PostID` varchar(40) NOT NULL default '',
  `PostTitle` varchar(150) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `Emailinform` tinyint(1) default '1',
  `Msginform` tinyint(1) default '1',
  `UserEmail` varchar(255) default NULL,
  `CreateTime` datetime default NULL,
  `UserLocale` varchar(20) default 'zh_CN',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_sysnumstat` (
  `ID` varchar(20) NOT NULL,
  `RecDate` varchar(20) NOT NULL,
  `Num0` int(11) default '0',
  `NumInc0` int(11) NOT NULL default '0',
  `Num1` int(11) NOT NULL default '0',
  `NumInc1` int(11) NOT NULL default '0',
  `Num2` int(11) NOT NULL default '0',
  `NumInc2` int(11) NOT NULL default '0',
  `Num3` int(11) NOT NULL default '0',
  `NumInc3` int(11) NOT NULL default '0',
  `Num4` int(11) NOT NULL default '0',
  `NumInc4` int(11) NOT NULL default '0',
  `Num5` int(11) NOT NULL default '0',
  `NumInc5` int(11) NOT NULL default '0',
  `CreateTime` bigint(20) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_userinfo` (
  `ID` varchar(40) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `NickName` varchar(60) NOT NULL default '',
  `Passwd` varchar(40) NOT NULL default '',
  `RePasswd` varchar(40) NOT NULL default '',
  `Email` varchar(255) NOT NULL default '',
  `Question` varchar(255) NOT NULL default '',
  `Answer` varchar(255) NOT NULL default '',
  `RegTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `LoginTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `LoginIP` varchar(20) NOT NULL default '',
  `LoginTimes` int(11) NOT NULL default '0',
  `LastLoginTime` datetime default NULL,
  `LastLoginIP` varchar(20) default NULL,
  `ArticleNum` int(11) default '0',
  `StayTime` bigint(20) default '0',
  `ArticleEliteNum` int(11) default '0',
  `LifeForce` int(11) default '0',
  `UserTitle` tinyint(3) default '0',
  `Coin` int(11) default '0',
  `Literary` int(11) default '0',
  `Experience` int(11) default '0',
  `UserKnow` int(11) default '0',
  `SignName0` varchar(30) default NULL,
  `SignDetail0` text,
  `SignName1` varchar(30) default NULL,
  `SignDetail1` text,
  `SignName2` varchar(30) default NULL,
  `SignDetail2` text,
  `HavePic` tinyint(3) default '0',
  `PicFileName` varchar(255) default NULL,
  `ForumPerNum` tinyint(3) default '20',
  `PostPerNum` tinyint(3) default '10',
  `UserFrom` varchar(255) default NULL,
  `TimeZone` varchar(20) default 'GMT+08:00',
  `BirthYear` int(4) default '1980',
  `BirthMonth` tinyint(2) default '1',
  `BirthDay` tinyint(2) default '1',
  `ReceiveNote` tinyint(1) default '1',
  `AcceptFriend` tinyint(1) default '1',
  `ForumViewMode` tinyint(1) default '0',
  `Validated` tinyint(1) default '1',
  `GroupID` int(11) default '0',
  `HiddenLogin` tinyint(1) default '0',
  `EditType` tinyint(1) default '-1',
  `UserLocale` varchar(20) default 'zh_CN',
  `ValidateCode` varchar(20) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `UserName` (`UserName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_userdetail` (
  `ID` varchar(40) NOT NULL default '',
  `Height` varchar(255) default NULL,
  `Weight` varchar(255) default NULL,
  `Interest` varchar(255) default NULL,
  `Graduate` varchar(255) default NULL,
  `FavourPeople` varchar(255) default NULL,
  `DreamJob` varchar(255) default NULL,
  `FavourArt` varchar(255) default NULL,
  `FavourMusic` varchar(255) default NULL,
  `FavourPlace` varchar(255) default NULL,
  `FavourMovie` varchar(255) default NULL,
  `FavourChat` varchar(255) default NULL,
  `FavourBook` varchar(255) default NULL,
  `DreamLover` varchar(255) default NULL,
  `FavourTeam` varchar(255) default NULL,
  `HomePage` varchar(255) default '',
  `OicqNo` varchar(255) default '',
  `IcqNo` varchar(255) default '',
  `MSN` varchar(255) default NULL,
  `Yahoo` varchar(255) default NULL,
  `Sex` tinyint(1) default '0',
  `Brief` text,
  PRIMARY KEY  (`ID`),
  CONSTRAINT `FK_USERDETAIL_ID` FOREIGN KEY (`ID`) REFERENCES `bbscs_userinfo` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_usergroup` (
  `ID` int(11) NOT NULL auto_increment,
  `GroupName` varchar(255) NOT NULL default '',
  `GroupDesc` varchar(255) default NULL,
  `TypeID` int(2) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_userlevel` (
  `ID` varchar(40) NOT NULL,
  `LevelName` varchar(60) NOT NULL,
  `LevelValue` int(11) NOT NULL default '0',
  `LevelType` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_useronline` (
  `ID` varchar(40) NOT NULL default '',
  `UserID` varchar(40) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `NickName` varchar(60) NOT NULL default '',
  `OnlineTime` bigint(20) default NULL,
  `BoardID` bigint(20) default '0',
  `AtPlace` varchar(255) default NULL,
  `UserGroupID` int(11) default NULL,
  `ValidateCode` varchar(100) default NULL,
  `HiddenUser` tinyint(1) default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_usertop` (
  `ID` varchar(40) NOT NULL,
  `UserID` varchar(40) NOT NULL,
  `UserName` varchar(20) NOT NULL,
  `NickName` varchar(60) NOT NULL,
  `ValueType` tinyint(2) NOT NULL default '0',
  `UserValue` int(11) default '0',
  `ValueInc` int(11) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ValueType` (`ValueType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_vote` (
  `ID` varchar(40) NOT NULL default '',
  `Title` varchar(255) NOT NULL default '',
  `IsM` tinyint(1) default '0',
  `DeadLine` bigint(20) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `id` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_voteitem` (
  `ID` varchar(40) NOT NULL default '',
  `VoteID` varchar(40) NOT NULL default '',
  `Item` varchar(255) NOT NULL default '',
  `ItemValue` int(11) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `id` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_voteuser` (
  `ID` varchar(40) NOT NULL default '',
  `VoteID` varchar(40) NOT NULL default '',
  `VoteUserID` varchar(40) NOT NULL default '',
  `VoteTime` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `id` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;