/
Database-Tables-mybb-events.html
235 lines (230 loc) · 8.83 KB
/
Database-Tables-mybb-events.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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
---
layout: page
title: mybb_events
categories: ["mybb16_db"]
---
<p>Stores the calendar events
</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>eid</td>
<td> int(10)</td>
<td> No</td>
<td>Primary
</td>
<td>
</td>
<td> Event ID
</td></tr>
<tr>
<td>cid</td>
<td> int(10)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> Calendar ID
</td></tr>
<tr>
<td>uid</td>
<td> int(10)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> User ID
</td></tr>
<tr>
<td>name</td>
<td> varchar(120)</td>
<td> No</td>
<td>
</td>
<td>
</td>
<td> Event title
</td></tr>
<tr>
<td>description</td>
<td> text</td>
<td> No</td>
<td>
</td>
<td>
</td>
<td> Description of the event
</td></tr>
<tr>
<td>visible</td>
<td> int(1)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> Status of the event (visible, unapproved)
</td></tr>
<tr>
<td>private</td>
<td> int(1)</td>
<td> No</td>
<td>Index
</td>
<td>0
</td>
<td> '1'/'0' indicating private event
</td></tr>
<tr>
<td>dateline</td>
<td> int(10)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> UNIX Timestamp of the time the event was created
</td></tr>
<tr>
<td>starttime</td>
<td> int(10)</td>
<td> No</td>
<td>Multiple
</td>
<td>0
</td>
<td> UNIX Timestamp of the time the event is scheduled to start
</td></tr>
<tr>
<td>endtime</td>
<td> int(10)</td>
<td> No</td>
<td>Multiple
</td>
<td>0
</td>
<td> UNIX Timestamp of the time the event is scheduled to end
</td></tr>
<tr>
<td>timezone</td>
<td> varchar(4)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> Time zone the event dates are scheduled for
</td></tr>
<tr>
<td>ignoretimezone</td>
<td> int(1)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> '1'/'0' indicating whether a user's time zone should be ignored when determining event times
</td></tr>
<tr>
<td>usingtime</td>
<td> int(1)</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> '1'/'0' indicating whether an event has a specific start time
</td></tr>
<tr>
<td>repeats</td>
<td> text</td>
<td> No</td>
<td>
</td>
<td>0
</td>
<td> Information on when the event should be repeated
</td></tr>
</table>
<p><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> 0</td>
<td> eid
</td></tr>
<tr>
<td>daterange</td>
<td> INDEX</td>
<td> None</td>
<td> starttime, endtime
</td></tr>
<tr>
<td>private</td>
<td> INDEX</td>
<td> None</td>
<td> private
</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>