本人论坛数据库结构一览(最后更新于07.09.09)

-- 表结构 BBSXP_Affiche 的SQL语句。公告表
CREATE TABLE [BBSXP_Affiche] (
[ID] Integer  NOT NULL IDENTITY,
[Title] VarChar ,
[Content] Text ,
[UserName] VarChar ,
[PostTime] DateTime ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_Blogs 的SQL语句。博客文章表
CREATE TABLE [BBSXP_Blogs] (
[ID] Integer  NOT NULL IDENTITY,
[ParentID] Integer ,
[Content] Text ,
[UserName] VarChar ,
[Category] VarChar ,
[Subject] VarChar ,
[BlogDate] VarChar ,
[TotalReplies] Integer ,
[DateCreated] DateTime ,
[DateNew] DateTime ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_BlogSettings 的SQL语句。博客设置表
CREATE TABLE [BBSXP_BlogSettings] (
[BlogTitle] VarChar ,
[BlogTagline] VarChar ,
[UserName] VarChar ,
[BlogBgcolor] VarChar ,
[BlogPermissions] VarChar ,
[BlogBackground] VarChar ,
[BlogAudio] VarChar ,
[BlogComments] Integer ,
[NumBlogs] Integer ,
[UserSkinID] Integer ,
[BlogCount] Integer ,
[BlogReplies] Integer ,
[BlogViews] Integer ,
[BlogScore] Integer ,
PRIMARY KEY ([UserName]));

-- 表结构 BBSXP_Consort 的SQL语句。社区恋人表
CREATE TABLE [BBSXP_Consort] (
[ID] Integer  NOT NULL IDENTITY,
[UserName] VarChar ,
[Aim] VarChar ,
[Unburden] VarChar ,
[DateCreated] DateTime ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_Consortia 的SQL语句。公会表
CREATE TABLE [BBSXP_Consortia] (
[ID] Integer  NOT NULL IDENTITY,
[UserName] VarChar ,
[ConsortiaName] VarChar ,
[FullName] VarChar ,
[Tenet] VarChar ,
[DateCreated] DateTime ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_Favorites 的SQL语句。书签表
CREATE TABLE [BBSXP_Favorites] (
[ID] Integer  NOT NULL IDENTITY,
[UserName] VarChar ,
[Name] VarChar ,
> VarChar ,
[DateCreated] DateTime ,
[Category] VarChar ,
[Description] VarChar ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_ForumPermissions 的SQL语句。论坛权限表
CREATE TABLE [BBSXP_ForumPermissions] (
[ForumID] Integer ,
[RoleID] Integer ,
[PermissionsView] Integer ,
[PermissionsRead] Integer ,
[PermissionsPost] Integer ,
[PermissionsReply] Integer ,
[PermissionsEdit] Integer ,
[PermissionsDelete] Integer ,
[PermissionsCreatePoll] Integer ,
[PermissionsVote] Integer ,
[PermissionsAttachment] Integer ,
[PermissionsManage] Integer );

-- 表结构 BBSXP_Forums 的SQL语句。论坛版块表
CREATE TABLE [BBSXP_Forums] (
[ID] Integer  NOT NULL IDENTITY,
[FollowID] Integer ,
[SortNum] Integer ,
[ForumName] VarChar ,
[Moderated] VarChar ,
[TolSpecialTopic] VarChar ,
[ForumIntro] VarChar ,
[ForumToday] Integer ,
[ForumThreads] Integer ,
[ForumPosts] Integer ,
[ForumPass] Integer ,
[ForumLogo] VarChar ,
[ForumIcon] VarChar ,
[ForumHide] Integer ,
[LastTopic] VarChar ,
[LastName] VarChar ,
[LastTime] DateTime ,
[ForumPassword] VarChar ,
[ForumUserList] VarChar ,
[ForumRules] Text ,
[IsModerated] Integer ,
[ListMode] Integer ,
[BannedText] Text ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_Link 的SQL语句。友情连接表
CREATE TABLE [BBSXP_Link] (
[ID] Integer  NOT NULL IDENTITY,
[Name] VarChar ,
> VarChar ,
[Logo] VarChar ,
[Intro] VarChar ,
[Review] Integer ,
[TopLink] Integer ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_Log 的SQL语句。运行日志表
CREATE TABLE [BBSXP_Log] (
[UserName] VarChar ,
[IPAddress] VarChar ,
[UserAgent] VarChar ,
[DateCreated] DateTime ,
[HttpVerb] VarChar ,
[PathAndQuery] Text ,
[Referrer] VarChar ,
[ErrDescription] VarChar ,
[POSTData] Text ,
[Notes] Text );

-- 表结构 BBSXP_Menu 的SQL语句。菜单表
CREATE TABLE [BBSXP_Menu] (
[Name] VarChar ,
> VarChar ,
[FollowID] Integer ,
[SortNum] Integer ,
[ID] Integer  NOT NULL IDENTITY);

-- 表结构 BBSXP_Messages 的SQL语句。短信表
CREATE TABLE [BBSXP_Messages] (
[ID] Integer  NOT NULL IDENTITY,
[UserName] VarChar ,
[Incept] VarChar ,
[Content] Text ,
[DateCreated] DateTime ,
[ParentID] Integer ,
[IsPublish] Integer ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_PostInTags 的SQL语句。标签内容表
CREATE TABLE [BBSXP_PostInTags] (
[TagID] Integer ,
[ThreadID] Integer ,
[PostID] Integer );

-- 表结构 BBSXP_PostRating 的SQL语句。帖子评价表
CREATE TABLE [BBSXP_PostRating] (
[UserName] VarChar ,
[ThreadID] Integer ,
[Rating] Integer ,
[DateCreated] DateTime );

-- 表结构 BBSXP_Posts 的SQL语句。帖子数据表
CREATE TABLE [BBSXP_Posts] (
[ThreadID] Integer ,
[IsTopic] Integer ,
[UserName] VarChar ,
[Subject] VarChar ,
[Content] Text ,
[PostIP] VarChar ,
[PostTime] DateTime ,
[ID] Integer  NOT NULL IDENTITY,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_PostTags 的SQL语句。帖子标签表
CREATE TABLE [BBSXP_PostTags] (
[TagID] Integer  NOT NULL IDENTITY,
[TagName] VarChar ,
[IsEnabled] Integer ,
[TotalPosts] Integer ,
[MostRecentPostDate] DateTime ,
[DateCreated] DateTime ,
PRIMARY KEY ([TagID]));

-- 表结构 BBSXP_Prison 的SQL语句。监狱表
CREATE TABLE [BBSXP_Prison] (
[UserName] VarChar ,
[Causation] VarChar ,
[Constable] VarChar ,
[ComeTime] DateTime ,
[PrisonDay] Integer );

-- 表结构 BBSXP_Ranks 的SQL语句。用户权限表
CREATE TABLE [BBSXP_Ranks] (
[ID] Integer  NOT NULL IDENTITY,
[RankName] VarChar ,
[PostingCountMin] Integer ,
[RankIconUrl] VarChar ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_Roles 的SQL语句。用户等级表
CREATE TABLE [BBSXP_Roles] (
[ID] Integer  NOT NULL IDENTITY,
[Name] VarChar ,
[Description] VarChar ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_SiteSettings 的SQL语句。论坛设置表
CREATE TABLE [BBSXP_SiteSettings] (
[AdminPassword] VarChar ,
[Nowdate] DateTime ,
[DefaultPostsName] VarChar ,
[SiteName] VarChar ,
[SiteURL] VarChar ,
[metaDescription] VarChar ,
[metaKeywords] VarChar ,
[ThreadsPerPage] Integer ,
[PostsPerPage] Integer ,
[Timeout] Integer ,
[UserOnlineTime] Integer ,
[DefaultSiteStyle] VarChar ,
[CompanyName] VarChar ,
[CompanyURL] VarChar ,
[DisplayForumFloor] Integer ,
[DisplayWhoIsOnline] Integer ,
[DisplayLink] Integer ,
[DuplicatePostIntervalInMinutes] Integer ,
[RegUserTimePost] Integer ,
[PopularPostThresholdPosts] Integer ,
[PopularPostThresholdViews] Integer ,
[UpFileOption] VarChar ,
[UpFileTypes] VarChar ,
[MaxFileSize] Integer ,
[MaxFaceSize] Integer ,
[MaxPhotoSize] Integer ,
[MinVoteOptions] Integer ,
[MaxVoteOptions] Integer ,
[SelectMailMode] VarChar ,
[SmtpServer] VarChar ,
[SmtpServerUserName] VarChar ,
[SmtpServerPassword] VarChar ,
[SmtpServerMail] VarChar ,
[BannedHtmlLabel] Text ,
[BannedHtmlEvent] Text ,
[BannedText] Text ,
[BannedUserPost] Text ,
[BannedRegUserName] Text ,
[BannedIP] Text ,
[ForumApply] Integer ,
[SortShowForum] Integer ,
[OnlyMailReg] Integer ,
[EnableUser] Integer ,
[CloseRegUser] Integer ,
[IntegralAddThread] Integer ,
[IntegralAddPost] Integer ,
[IntegralAddValuedPost] Integer ,
[IntegralDeleteThread] Integer ,
[IntegralDeletePost] Integer ,
[IntegralDeleteValuedPost] Integer ,
[TopBanner] Text ,
[BottomAD] Text ,
[RegUserAgreement] Text ,
[CacheName] VarChar ,
[DisplayEditNotes] Integer ,
[EnableAntiSpamTextGenerateForRegister] Integer ,
[EnableAntiSpamTextGenerateForLogin] Integer ,
[EnableAntiSpamTextGenerateForPost] Integer ,
[DisplayPostIP] Integer ,
[MaxPostAttachmentsSize] Integer ,
[WatermarkOption] VarChar ,
[WatermarkType] Integer ,
[WatermarkImage] VarChar ,
[WatermarkText] VarChar ,
[WatermarkPosition] Integer ,
[AttachmentsSaveOption] Integer ,
[SiteDisabled] Integer ,
[DaysUsers] Integer ,
[DaysPosts] Integer ,
[DaysTopics] Integer ,
[TotalUsers] Integer ,
[TotalPosts] Integer ,
[TotalTopics] Integer ,
[NewUsers] VarChar ,
[BestOnline] Integer ,
[BestOnlineTime] DateTime ,
[DisplayStatistics] Integer ,
[DisplayBirthdays] Integer );

-- 表结构 BBSXP_Statistics 的SQL语句。社区统计表
CREATE TABLE [BBSXP_Statistics] (
[DaysUsers] Integer ,
[DaysPosts] Integer ,
[DaysTopics] Integer ,
[TotalUsers] Integer ,
[TotalPosts] Integer ,
[TotalTopics] Integer ,
[DaysDate] DateTime ,
[DateCreated] DateTime );

-- 表结构 BBSXP_Threads 的SQL语句。主题表
CREATE TABLE [BBSXP_Threads] (
[ID] Integer  NOT NULL IDENTITY,
[ForumID] Integer ,
[Icon] Integer ,
[Topic] VarChar ,
[SpecialTopic] VarChar ,
[UserName] VarChar ,
[LastName] VarChar ,
[PostTime] DateTime ,
[LastTime] DateTime ,
[IsGood] Integer ,
[IsTop] Integer ,
[IsLocked] Integer ,
[IsDel] Integer ,
[IsVote] Integer ,
[Views] Integer ,
[Replies] Integer ,
[RatingSum] Integer ,
[TotalRatings] Integer ,
[LastViewedDate] DateTime ,
[PostsTableName] Integer ,
[ThreadStyle] VarChar ,
[ThreadStatus] Integer ,
[Keywords] Text ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_UpFiles 的SQL语句。上传文件数据表
CREATE TABLE [BBSXP_UpFiles] (
[ID] Integer  NOT NULL IDENTITY,
[UserName] VarChar ,
[FileName] VarChar ,
[ContentType] VarChar ,
[FilePath] VarChar ,
[ContentSize] Integer ,
[Description] VarChar ,
[Category] VarChar ,
[Class] VarChar ,
[Created] DateTime ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_Users 的SQL语句。用户表
CREATE TABLE [BBSXP_Users] (
[ID] Integer  NOT NULL IDENTITY,
[UserName] VarChar ,
[UserPass] VarChar ,
[Membercode] Integer ,
[UserMail] VarChar ,
[UserHome] VarChar ,
[PasswordQuestion] VarChar ,
[PasswordAnswer] VarChar ,
[UserHonor] VarChar ,
[UserSex] VarChar ,
[Consortia] VarChar ,
[Consort] VarChar ,
[NewMessage] Integer ,
[PostTopic] Integer ,
[PostRevert] Integer ,
[DelTopic] Integer ,
[GoodTopic] Integer ,
[UserMoney] Integer ,
[SaveMoney] Integer ,
[Experience] Integer ,
[UserDegree] Integer ,
[UserFace] VarChar ,
[UserPhoto] VarChar ,
[UserMobile] VarChar ,
[UserLastIP] VarChar ,
[UserRegTime] DateTime ,
[UserLandTime] DateTime ,
[SaveMoneyTime] DateTime ,
[UserSign] Text ,
[UserFriend] Text ,
[UserInfo] Text ,
[UserIM] Text ,
[UserRoleID] Integer ,
[UserAccountStatus] Integer ,
[Birthday] DateTime ,
[Onlinetimes] Integer ,
[blacklist] Text ,
PRIMARY KEY ([ID]));

-- 表结构 BBSXP_UsersOnline 的SQL语句。在线表
CREATE TABLE [BBSXP_UsersOnline] (
[ForumID] Integer ,
[SessionID] VarChar ,
[UserName] VarChar ,
[IP] VarChar ,
[Eremite] Integer ,
[ForumName] VarChar ,
[Act] VarChar ,
[ActURL] VarChar ,
[ComeTime] DateTime ,
[LastTime] DateTime ,
[userie] VarChar ,
[userwin] VarChar ,
PRIMARY KEY ([SessionID]));

-- 表结构 BBSXP_Vote 的SQL语句。投票表
CREATE TABLE [BBSXP_Vote] (
[ThreadID] Integer ,
[Type] Integer ,
[Expiry] DateTime ,
[Items] Text ,
[Result] Text ,
[BallotUserList] Text ,
[BallotIPList] Text ,
[BallotItemsList] Text ,
PRIMARY KEY ([ThreadID]));

-- 表结构 DK_NEWPIC_PLUS 的SQL语句。DK贴图集表
CREATE TABLE [DK_NEWPIC_PLUS] (
[id] Integer  NOT NULL IDENTITY,
[picurl] VarChar ,
[username] VarChar ,
[picreadme] VarChar ,
[topicid] Integer ,
[addwhen] DateTime ,
[nosee] Integer ,
PRIMARY KEY ([id]));

-- 表结构 newprison 的SQL语句。新监狱表
CREATE TABLE [newprison] (
[id] Integer  NOT NULL IDENTITY,
[username] VarChar ,
[prisonname] VarChar ,
[followid] Integer ,
[SortNum] Integer ,

［此帖子已被 admin 在 2007-9-9 15:49:19 编辑过］

［此帖子已被 admin 在 2007-9-15 11:16:49 编辑过］

［此帖子已被 admin 在 2007-12-28 17:21:49 编辑过］