-
Notifications
You must be signed in to change notification settings - Fork 75
/
Database-Tables-mybb-stats.html
124 lines (119 loc) · 7.22 KB
/
Database-Tables-mybb-stats.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
---
layout: page
title: mybb_stats
categories: ["mybb16_db"]
---
<p>Stores daily statistic information.
</p>
<table border="1">
<tr>
<th>Field</th>
<th> Type</th>
<th> Null</th>
<th>Key</th>
<th> Default</th>
<th>Description
</th></tr>
<tr>
<td>dateline</td>
<td> bigint(30)</td>
<td> No</td>
<td>Primary
</td>
<td>
</td>
<td>UNIX Timestamp of when statistics started
</td></tr>
<tr>
<td>numusers</td>
<td> int(10)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td>Number of users
</td></tr>
<tr>
<td>numthreads</td>
<td> int(10)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td>Number of threads
</td></tr>
<tr>
<td>numposts</td>
<td> int(10)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td>Number of posts
</td></tr>
</table>
<p><br />
<b>Indexes:</b>
</p>
<table border="1">
<tr>
<th>Keyname</th>
<th> Type</th>
<th> Cardinality</th>
<th> Field
</th></tr>
<tr>
<td>PRIMARY</td>
<td> PRIMARY</td>
<td> 1</td>
<td> dateline
</td></tr>
</table>
<div style="clear:both;border: 1px solid #ddd; background-color: #f5f5f5; padding: 5px; margin: 5px;">
<div style="text-align: center; font-size: 18px; margin-bottom: 5px;"><b><a href="{{ site.baseurl }}/1.6/Documentation/" title="Documentation">MyBB Documentation</a></b></div>
<table cellpadding="3" cellspacing="3" style="font-size: 95%; line-spacing:1; border: 1px solid #ddd; width: 100%; margin-bottom: 5px; background: #fff;">
<tr>
<td style="vertical-align: middle; font-size: 14px;"><b><a href="{{ site.baseurl }}/1.6/Front-End/" title="Front End">Front End</a></b>
</td>
<td style="vertical-align: middle; width: 80%;"><a href="{{ site.baseurl }}/1.6/Index-Page/" title="Index Page">Index Page</a> - <a href="{{ site.baseurl }}/1.6/Portal/" title="Portal">Portal</a> - <a href="{{ site.baseurl }}/1.6/Forum-Display/" title="Forum Display">Forum Display</a> - <a href="{{ site.baseurl }}/1.6/Thread-Display/" title="Thread Display">Thread Display</a> - <a href="{{ site.baseurl }}/1.6/Posting/" title="Posting">Posting Threads and Replies</a> - <a href="{{ site.baseurl }}/1.6/Searching/" title="Searching">Searching</a> - <a href="{{ site.baseurl }}/1.6/User-CP/" title="User CP">User CP</a> - <a href="{{ site.baseurl }}/1.6/Member-Profile/" title="Member Profile">Member Profile</a> - <a href="{{ site.baseurl }}/1.6/Private-Messages/" title="Private Messages">Private Messages</a> - <a href="{{ site.baseurl }}/1.6/Calendar/" title="Calendar">Calendar</a> - <a href="{{ site.baseurl }}/1.6/Member-List/" title="Member List">Member List</a> - <a href="{{ site.baseurl }}/1.6/Help-Docs/" title="Help Docs">Help Docs</a> - <a href="{{ site.baseurl }}/1.6/Who-Is-Online/" title="Who Is Online">Who Is Online</a> - <a href="{{ site.baseurl }}/1.6/{{ site.baseurl }}/1.6/Lite-Archive-Mode/" title="Lite (Archive) Mode">Lite (Archive) Mode</a> - <a href="{{ site.baseurl }}/1.6/Forum-Team/" title="Forum Team">Forum Team</a> - <a href="{{ site.baseurl }}/1.6/Statistics/" title="Statistics">Statistics</a> - <a href="{{ site.baseurl }}/1.6/RSS-Syndication/" title="RSS Syndication">RSS Syndication</a> - <a href="{{ site.baseurl }}/1.6/Miscellaneous-Front-End/" title="Miscellaneous Front End">Miscellaneous</a>
</td></tr></table>
<table cellpadding="3" cellspacing="3" style="font-size: 95%; line-spacing:1; border: 1px solid #ddd; width: 100%; margin-bottom: 5px; background: #fff;">
<tr>
<td style="vertical-align: middle; font-size: 14px;"><b><a href="{{ site.baseurl }}/1.6/Moderating-Options/" title="Moderating Options">Moderation</a></b>
</td>
<td style="vertical-align: middle; width: 80%;"><a href="{{ site.baseurl }}/1.6/Moderating-Options/#Normal_Thread_Moderation" title="Moderating Options">Standard Thread Moderation</a> - <a href="{{ site.baseurl }}/1.6/Moderating-Options/#Inline_Thread_Moderation" title="Moderating Options">Inline Thread Moderation</a> - <a href="{{ site.baseurl }}/1.6/Moderating-Options/#Inline_Post_Moderation" title="Moderating Options">Inline Post Moderation</a> - <a href="{{ site.baseurl }}/1.6/Warning-System/" title="Warning System">Warning System</a>
</td></tr></table>
<table cellpadding="3" cellspacing="3" style="font-size: 95%; line-spacing:1; border: 1px solid #ddd; width: 100%; margin-bottom: 5px; background: #fff;">
<tr>
<td style="vertical-align: middle; font-size: 14px;"><b><a href="{{ site.baseurl }}/1.6/Mod-CP/" title="Mod CP">Mod CP</a></b>
</td>
<td style="vertical-align: middle; width: 80%;"><a href="{{ site.baseurl }}/1.6/Mod-CP/" title="Mod CP">Home</a> - <a href="{{ site.baseurl }}/1.6/Mod-CP-Forums-Posts/" title="Mod CP Forums Posts">Forums and Posts</a> - <a href="{{ site.baseurl }}/1.6/Mod-CP-Users/" title="Mod CP Users">Users</a>
</td></tr></table>
<table cellpadding="3" cellspacing="3" style="font-size: 95%; line-spacing:1; border: 1px solid #ddd; width: 100%; margin-bottom: 5px; background: #fff;">
<tr>
<td style="vertical-align: middle; font-size: 14px;"><b><a href="{{ site.baseurl }}/1.6/Admin-CP/" title="Admin CP">Admin CP</a></b>
</td>
<td style="vertical-align: middle; width: 80%;"><a href="{{ site.baseurl }}/1.6/Admin-CP-Home/" title="Admin CP Home">Home</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Config/" title="Admin CP Config">Configuration</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Forums-Posts/" title="Admin CP Forums Posts">Forums & Posts</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Users-Groups/" title="Admin CP Users Groups">Users & Groups</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Templates-Style/" title="Admin CP Templates Style">Templates & Style</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Tools/" title="Admin CP Tools">Tools & Maintenance</a>
</td></tr></table>
<table cellpadding="3" cellspacing="3" style="font-size: 95%; line-spacing:1; border: 1px solid #ddd; width: 100%; margin-bottom: 5px; background: #fff;">
<tr>
<td style="vertical-align: middle; font-size: 14px;"><b>Templates & Themes</b>
</td>
<td style="vertical-align: middle; width: 80%;"><a href="{{ site.baseurl }}/1.6/Images/" title="Images">Images</a> - <a href="{{ site.baseurl }}/1.6/Postbit/" title="Postbit">Postbit</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Templates/" title="Admin CP Templates">Templates</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Themes/" title="Admin CP Themes">Themes</a>
</td></tr></table>
<table cellpadding="3" cellspacing="3" style="font-size: 95%; line-spacing:1; border: 1px solid #ddd; width: 100%; margin-bottom: 5px; background: #fff;">
<tr>
<td style="vertical-align: middle; font-size: 14px;"><b>Developer</b>
</td>
<td style="vertical-align: middle; width: 80%;"><a href="{{ site.baseurl }}/1.6/Database-Methods/" title="Database Methods">Database Methods</a> - <a href="{{ site.baseurl }}/1.6/Database-Tables/" title="Database Tables">Database Tables</a>
</td></tr></table>
<table cellpadding="3" cellspacing="3" style="font-size: 95%; line-spacing:1; border: 1px solid #ddd; width: 100%; margin-bottom: 5px; background: #fff;">
<tr>
<td style="vertical-align: middle; font-size: 14px;"><b>Miscellaneous</b>
</td>
<td style="vertical-align: middle; width: 80%;"><a href="{{ site.baseurl }}/1.6/Cookies/" title="Cookies">Cookies</a> - <a href="{{ site.baseurl }}/1.6/UTF8_Setup.html" title="UTF8 Setup">UTF8 Setup</a> - <a href="{{ site.baseurl }}/1.6/Admin-CP-Board-Settings/" title="Admin CP Board Settings">Default Settings</a>
</td></tr></table>
</div>