?? bbsxp2008 數(shù)據(jù)結(jié)構(gòu)說明.htm
字號:
<td>0</td>
<td> </td>
</tr>
<tr>
<td>CommentFor</td>
<td>被評價的用戶 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td>FK</td>
</tr>
<tr>
<td>CommentBy</td>
<td>發(fā)表評價的用戶 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Comment</td>
<td>評論內(nèi)容 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>IPAddress</td>
<td>IP地址 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>DateCreated</td>
<td>評價時間 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="Roles"></a>表[Roles]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文說明</strong></td>
<td width="132"><strong>數(shù)據(jù)類型</strong></td>
<td width="120"><strong>默認值</strong></td>
<td width="120"><strong>備注</strong></td>
</tr>
<tr>
<td>RoleID</td>
<td>角色ID</td>
<td>Int</td>
<td> </td>
<td>自動編號、PK</td>
</tr>
<tr>
<td>Name</td>
<td>角色名稱 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Description</td>
<td>角色描述 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>RoleMaxFileSize</td>
<td>允許單個帖子附件的大小</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>RoleMaxPostAttachmentsSize</td>
<td>設置用戶上傳文件夾的最大容量</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="SiteSettings"></a>表[SiteSettings]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文說明</strong></td>
<td width="132"><strong>數(shù)據(jù)類型</strong></td>
<td width="120"><strong>默認值</strong></td>
<td width="120"><strong>備注</strong></td>
</tr>
<tr>
<td>SiteSettingsXML</td>
<td>論壇信息 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>CreateUserAgreement</td>
<td>注冊用戶協(xié)議 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>GenericHeader</td>
<td>頁面頭信息 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>GenericTop</td>
<td>頂部廣告代碼 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>GenericBottom</td>
<td>底部版權(quán)信息 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>BestOnline</td>
<td>最高在線人數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>BestOnlineTime</td>
<td>最高在線發(fā)生時間 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>AdminNotes</td>
<td>管理員便箋 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>BBSxpVersion</td>
<td>數(shù)據(jù)庫版本 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="Statistics"></a>表[Statistics]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文說明</strong></td>
<td width="132"><strong>數(shù)據(jù)類型</strong></td>
<td width="120"><strong>默認值</strong></td>
<td width="120"><strong>備注</strong></td>
</tr>
<tr>
<td>DaysUsers</td>
<td>今日用戶 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DaysPosts</td>
<td>今日帖子 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DaysTopics</td>
<td>今日主題 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalUsers</td>
<td>總用戶數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalPosts</td>
<td>總帖子數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalTopics</td>
<td>總主題數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>NewestUserName</td>
<td>新注冊用戶 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>DateCreated</td>
<td>生成時間 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="Subscriptions"></a>表[Subscriptions]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文說明</strong></td>
<td width="132"><strong>數(shù)據(jù)類型</strong></td>
<td width="120"><strong>默認值</strong></td>
<td width="120"><strong>備注</strong></td>
</tr>
<tr>
<td>SubscriptionID</td>
<td> </td>
<td>Int</td>
<td> </td>
<td>自動編號 </td>
</tr>
<tr>
<td>ThreadID</td>
<td>主題ID</td>
<td>Int</td>
<td>0</td>
<td>FK</td>
</tr>
<tr>
<td>UserName</td>
<td>訂閱用戶</td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Email</td>
<td>Email</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>SubscriptionDate</td>
<td>訂閱時間</td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="ThreadRating"></a>表[ThreadRating]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文說明</strong></td>
<td width="132"><strong>數(shù)據(jù)類型</strong></td>
<td width="120"><strong>默認值</strong></td>
<td width="120"><strong>備注</strong></td>
</tr>
<tr>
<td>ThreadID</td>
<td>主題ID</td>
<td>Int</td>
<td>0</td>
<td>FK</td>
</tr>
<tr>
<td>UserName</td>
<td>用戶 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Rating</td>
<td>評級 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DateCreated</td>
<td>參與時間 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="Threads"></a>表[Threads]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="120"><strong>字段名</strong></td>
<td width="242"><strong>字段中文說明</strong></td>
<td width="108"><strong>數(shù)據(jù)類型</strong></td>
<td width="120"><strong>默認值</strong></td>
<td width="120"><strong>備注</strong></td>
</tr>
<tr>
<td>ThreadID</td>
<td width="217">主題ID</td>
<td>Int</td>
<td> </td>
<td>自動編號、PK</td>
</tr>
<tr>
<td>ForumID</td>
<td width="217">所屬版塊 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadEmoticonID</td>
<td width="217">表情 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadStyle</td>
<td width="217">主題樣式 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Topic</td>
<td width="217">標題 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Category</td>
<td width="217">文章類別 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Description</td>
<td width="217">主題描述 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PostAuthor</td>
<td width="217">用戶名 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>LastName</td>
<td width="217">最后回復的用戶 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PostTime</td>
<td width="217">主題發(fā)表時間 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>LastTime</td>
<td width="217">最后回復時間 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>LastViewedDate</td>
<td width="217">最后查看日期 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>IsGood</td>
<td width="217">是否精華帖 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadTop</td>
<td width="217">是否置頂帖 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>StickyDate</td>
<td width="217">公告/置頂過期時間 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>IsLocked</td>
<td width="217">是否鎖帖 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>Visible</td>
<td width="217">是否可見<br>
0=未通過審核<br>
1=通過審核<br>
2=已刪除</td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>HiddenCount</td>
<td width="217">未審核帖子數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DeletedCount</td>
<td width="217">已刪除帖子數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>IsVote</td>
<td width="217">是否投票主題 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalViews</td>
<td width="217">總瀏覽數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalReplies</td>
<td width="217">總回復數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>RatingSum</td>
<td width="217">投票總得分數(shù) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalRatings</td>
<td width="217">共幾個用戶投票 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadStatus</td>
<td width="217">主題狀態(tài) </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
</table>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -