mysql.sql

来自「LiteBlaster 是一款基于 .NET Framework 原创的 ASP」· SQL 代码 · 共 549 行 · 第 1/2 页

  `System` tinyint(1) default '0',
  `SendTime` datetime NOT NULL,
  `MsgRead` tinyint(1) default '0',
  `Body` varchar(255) NOT NULL,
  KEY `MsgTo` (`MsgTo`,`SendTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `messages`
--

--
-- Definition of table `online`
--

DROP TABLE IF EXISTS `online`;
CREATE TABLE `online` (
  `UserName` varchar(20) NOT NULL,
  `IP` varchar(30) default '没有记录',
  `Hidden` tinyint(1) default '0',
  PRIMARY KEY  (`UserName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `online`
--

--
-- Definition of table `posts`
--

DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `ID` int(11) NOT NULL auto_increment,
  `TopicID` int(11) NOT NULL,
  `UserName` varchar(20) NOT NULL,
  `PostTime` datetime NOT NULL,
  `LastOperator` varchar(20) default NULL,
  `LastEditTime` datetime default '2006-07-01 00:00:00',
  `IP` varchar(30) default '没有记录',
  `Floor` smallint(6) default '0',
  `Remark` int(11) default '0',
  `UploadCount` smallint(6) default '0',
  `Status` tinyint(4) default '0',
  `MoodEnabled` tinyint(1) default '0',
  `CodeEnabled` tinyint(1) default '0',
  `ExtraReason` varchar(50) default NULL,
  `Body` text NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `TopicID` (`TopicID`,`UserName`,`Floor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `posts`
--

--
-- Definition of table `sections`
--

DROP TABLE IF EXISTS `sections`;
CREATE TABLE `sections` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(30) NOT NULL,
  `Sequence` datetime NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `Sequence` (`Sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sections`
--

--
-- Definition of table `setup`
--

DROP TABLE IF EXISTS `setup`;
CREATE TABLE `setup` (
  `ForumTitle` varchar(50) NOT NULL,
  `ForumDomain` varchar(255) NOT NULL default 'http://localhost/',
  `ForumLogoPath` varchar(255) default NULL,
  `ForumAd` text,
  `ForbiddenUserNames` text,
  `Badwords` text,
  `TopicCount` int(11) default '0',
  `PostCount` int(11) default '0',
  `UserCount` int(11) default '0',
  `MaxOnlineCount` int(11) default '0',
  `MaxOnlineTime` datetime default '2006-07-01 00:00:00',
  `MoodEnabled` tinyint(1) default '1',
  `CodeEnabled` tinyint(1) default '1',
  `VoteEnabled` tinyint(1) default '1',
  `UploadSizeLimit` int(11) default '600000',
  `UploadCountLimitPerPost` int(11) default '2',
  `UploadTypeLimit` varchar(255) default NULL,
  `EPRemarkLimitPerTopic` int(11) default '30',
  `EPRemarkLimitPerPost` int(11) default '5',
  `MaintainingOnStart` tinyint(1) default '0',
  `LockNewUser` tinyint(1) default '0',
  `NotifyAdminWhenRegInfoChanged` tinyint(1) default '1',
  `SystemEmailSmtpServer` varchar(255) default NULL,
  `SystemEmailSslEnabled` tinyint(1) default '0',
  `SystemEmailAddress` varchar(100) default NULL,
  `SystemEmailUserName` varchar(50) default NULL,
  `SystemEmailPassword` varchar(50) default NULL,
  `LastRegUser` varchar(20) default NULL,
  `Copyright` varchar(255) default NULL,
  `Maintain` varchar(255) default NULL,
  `Product` varchar(20) default NULL,
  `Version` varchar(20) default NULL,
  `OtherInfo` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setup`
--
INSERT INTO `setup` (`ForumTitle`,`ForumDomain`,`ForumLogoPath`,`ForumAd`,`ForbiddenUserNames`,`Badwords`,`TopicCount`,`PostCount`,`UserCount`,`MaxOnlineCount`,`MaxOnlineTime`,`MoodEnabled`,`CodeEnabled`,`VoteEnabled`,`UploadSizeLimit`,`UploadCountLimitPerPost`,`UploadTypeLimit`,`EPRemarkLimitPerTopic`,`EPRemarkLimitPerPost`,`MaintainingOnStart`,`LockNewUser`,`NotifyAdminWhenRegInfoChanged`,`SystemEmailSmtpServer`,`SystemEmailSslEnabled`,`SystemEmailAddress`,`SystemEmailUserName`,`SystemEmailPassword`,`LastRegUser`,`Copyright`,`Maintain`,`Product`,`Version`,`OtherInfo`) VALUES 
 ('LiteBlaster 社区论坛','http://localhost/',NULL,NULL,'毛泽东|邓小平|江泽民|胡锦涛|希特勒|布什|administrator','我靠|我操|我日|fuck|bitch|asshole|傻B|他妈的|法轮功|操你妈|A片|三级片|普光网络|月赚千元',0,0,1,1,'2006-08-20 17:43:35',1,1,1,600000,2,'zip|rar|txt|doc|mdb|pdf|wps|ppt|dll|png|bmp|jpg|gif|htm|mp3|wav|wma|torrent',30,5,0,0,1,NULL,0,NULL,NULL,NULL,'admin','2001-2007 Auway Soft. All rights reserved.','由 Auway 制作与维护',NULL,NULL,'ICP证：  托管地点：');

--
-- Definition of table `topics`
--

DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(30) NOT NULL,
  `BoardID` int(11) NOT NULL,
  `UserName` varchar(20) NOT NULL,
  `PostTime` datetime NOT NULL,
  `Best` tinyint(1) default '0',
  `OnTop` tinyint(1) default '0',
  `Striking` tinyint(1) default '0',
  `Closed` tinyint(1) default '0',
  `Locked` tinyint(1) default '0',
  `Attachment` tinyint(4) default '0',
  `BestAnswerID` int(11) default '0',
  `HitCount` int(11) default '0',
  `ReplyCount` smallint(6) default '0',
  `DeletedCount` smallint(6) default '0',
  `Remark` int(11) default '0',
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTime` datetime default '2006-07-01 00:00:00',
  `NotifyPosterWhenReplied` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  KEY `BoardID` (`BoardID`,`PostTime`,`LastPostTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `topics`
--

--
-- Definition of table `uploads`
--

DROP TABLE IF EXISTS `uploads`;
CREATE TABLE `uploads` (
  `ID` int(11) NOT NULL auto_increment,
  `PostID` int(11) NOT NULL,
  `UserName` varchar(20) NOT NULL,
  `FileName` varchar(255) NOT NULL,
  `FileType` varchar(10) NOT NULL,
  `FileSize` int(11) NOT NULL,
  `ServerSideName` varchar(255) NOT NULL,
  `Description` varchar(255) default NULL,
  `MinEP` int(11) default '0',
  `DownTimes` int(11) default '0',
  `UploadTime` datetime NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ServerSideName` (`ServerSideName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `uploads`
--

--
-- Definition of table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(20) NOT NULL,
  `RealName` varchar(20) NOT NULL,
  `ShowRealName` tinyint(1) default '0',
  `Password` varchar(40) NOT NULL,
  `Male` tinyint(1) default '1',
  `ShowGender` tinyint(1) default '1',
  `Birthday` datetime NOT NULL,
  `ShowBirthday` tinyint(1) default '1',
  `Email` varchar(100) NOT NULL,
  `ShowEmail` tinyint(1) default '1',
  `Address` varchar(255) NOT NULL,
  `ShowAddress` tinyint(1) default '0',
  `IM` varchar(100) default NULL,
  `ShowIM` tinyint(1) default '1',
  `Question` varchar(50) NOT NULL,
  `Answer` varchar(40) NOT NULL,
  `CustomTitle` varchar(20) default NULL,
  `ComeFrom` varchar(50) default NULL,
  `Description` varchar(255) default NULL,
  `Signature` varchar(255) default NULL,
  `FacePath` varchar(255) default NULL,
  `TopicCountPerPage` int(11) default '25',
  `PostCountPerPage` int(11) default '10',
  `ParentBoardDisplayChildrenTopics` tinyint(1) default '0',
  `TimeZone` float default '8',
  `TimeFormat` varchar(50) default 'yyyy-MM-dd HH:mm',
  `DSTMode` tinyint(4) default '0',
  `GroupType` tinyint(4) default '1',
  `SecondGroup` tinyint(4) default '0',
  `MasterBoards` varchar(255) default NULL,
  `BookmarkBoards` varchar(255) default NULL,
  `BookmarkTopics` text,
  `JoinTime` datetime NOT NULL,
  `LastLogin` datetime default '2006-07-01 00:00:00',
  `LoginCount` int(11) default '0',
  `PostCount` int(11) default '0',
  `TopicCount` int(11) default '0',
  `BestCount` int(11) default '0',
  `EP` int(11) default '0',
  `Locked` tinyint(1) default '0',
  `Comment` varchar(255) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `users`
--
INSERT INTO `users` (`ID`,`Name`,`RealName`,`ShowRealName`,`Password`,`Male`,`ShowGender`,`Birthday`,`ShowBirthday`,`Email`,`ShowEmail`,`Address`,`ShowAddress`,`IM`,`ShowIM`,`Question`,`Answer`,`CustomTitle`,`ComeFrom`,`Description`,`Signature`,`FacePath`,`TopicCountPerPage`,`PostCountPerPage`,`ParentBoardDisplayChildrenTopics`,`TimeZone`,`TimeFormat`,`DSTMode`,`GroupType`,`SecondGroup`,`MasterBoards`,`BookmarkBoards`,`BookmarkTopics`,`JoinTime`,`LastLogin`,`LoginCount`,`PostCount`,`TopicCount`,`BestCount`,`EP`,`Locked`,`Comment`) VALUES 
 (1,'admin','管理员',0,'EE10C315EBA2C75B403EA99136F5B48D',1,0,'2006-08-07 00:00:00',0,'[e-mail]',0,'Admin, LiteBlaster Forum',0,NULL,0,'admin','EE10C315EBA2C75B403EA99136F5B48D',NULL,NULL,NULL,NULL,NULL,25,10,0,8,'yyyy-MM-dd HH:mm',0,6,0,NULL,NULL,NULL,'2006-08-20 17:46:39','2006-07-01 00:00:00',0,0,0,0,0,0,NULL);

--
-- Definition of table `votes`
--

DROP TABLE IF EXISTS `votes`;
CREATE TABLE `votes` (
  `ID` int(11) NOT NULL auto_increment,
  `TopicID` int(11) NOT NULL,
  `SurveyID` int(11) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `Locked` tinyint(1) default '0',
  `OtherEnabled` tinyint(1) default '0',
  `OptionLimit` tinyint(4) default '1',
  `VoteTimes` int(11) default '0',
  `Body` text NOT NULL,
  `Results` text NOT NULL,
  `OtherBody` text,
  `OtherResults` text,
  `Details` text NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `TopicID` (`TopicID`),
  KEY `SurveyID` (`SurveyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `votes`
--



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;