?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
schema data and schema structure for installations
[phpbb.git] / phpBB / install / schemas / schema_structure.php
blobf438ff22152c30fbd9f322d11bb9238ac1e823bb
1 <?php
2
3 $schema_data = array();
4
5 $schema_data['phpbb_attachments'] = array(
6 'COLUMNS' => array(
7 'attach_id' => array('UINT', NULL, 'auto_increment'),
8 'post_msg_id' => array('UINT', 0),
9 'topic_id' => array('UINT', 0),
10 'in_message' => array('BOOL', 0),
11 'poster_id' => array('UINT', 0),
12 'is_orphan' => array('BOOL', 1),
13 'physical_filename' => array('VCHAR', ''),
14 'real_filename' => array('VCHAR', ''),
15 'download_count' => array('UINT', 0),
16 'attach_comment' => array('TEXT_UNI', ''),
17 'extension' => array('VCHAR:100', ''),
18 'mimetype' => array('VCHAR:100', ''),
19 'filesize' => array('UINT:20', 0),
20 'filetime' => array('TIMESTAMP', 0),
21 'thumbnail' => array('BOOL', 0),
22 ),
23 'PRIMARY_KEY' => 'attach_id',
24 'KEYS' => array(
25 'filetime' => array('INDEX', 'filetime'),
26 'post_msg_id' => array('INDEX', 'post_msg_id'),
27 'topic_id' => array('INDEX', 'topic_id'),
28 'poster_id' => array('INDEX', 'poster_id'),
29 'is_orphan' => array('INDEX', 'is_orphan'),
30 ),
31 );
32
33 $schema_data['phpbb_acl_groups'] = array(
34 'COLUMNS' => array(
35 'group_id' => array('UINT', 0),
36 'forum_id' => array('UINT', 0),
37 'auth_option_id' => array('UINT', 0),
38 'auth_role_id' => array('UINT', 0),
39 'auth_setting' => array('TINT:2', 0),
40 ),
41 'KEYS' => array(
42 'group_id' => array('INDEX', 'group_id'),
43 'auth_opt_id' => array('INDEX', 'auth_option_id'),
44 'auth_role_id' => array('INDEX', 'auth_role_id'),
45 ),
46 );
47
48 $schema_data['phpbb_acl_options'] = array(
49 'COLUMNS' => array(
50 'auth_option_id' => array('UINT', NULL, 'auto_increment'),
51 'auth_option' => array('VCHAR:50', ''),
52 'is_global' => array('BOOL', 0),
53 'is_local' => array('BOOL', 0),
54 'founder_only' => array('BOOL', 0),
55 ),
56 'PRIMARY_KEY' => 'auth_option_id',
57 'KEYS' => array(
58 'auth_option' => array('INDEX', 'auth_option'),
59 ),
60 );
61
62 $schema_data['phpbb_acl_roles'] = array(
63 'COLUMNS' => array(
64 'role_id' => array('UINT', NULL, 'auto_increment'),
65 'role_name' => array('VCHAR_UNI', ''),
66 'role_description' => array('TEXT_UNI', ''),
67 'role_type' => array('VCHAR:10', ''),
68 'role_order' => array('USINT', 0),
69 ),
70 'PRIMARY_KEY' => 'role_id',
71 'KEYS' => array(
72 'role_type' => array('INDEX', 'role_type'),
73 'role_order' => array('INDEX', 'role_order'),
74 ),
75 );
76
77 $schema_data['phpbb_acl_roles_data'] = array(
78 'COLUMNS' => array(
79 'role_id' => array('UINT', 0),
80 'auth_option_id' => array('UINT', 0),
81 'auth_setting' => array('TINT:2', 0),
82 ),
83 'PRIMARY_KEY' => array('role_id', 'auth_option_id'),
84 'KEYS' => array(
85 'ath_op_id' => array('INDEX', 'auth_option_id'),
86 ),
87 );
88
89 $schema_data['phpbb_acl_users'] = array(
90 'COLUMNS' => array(
91 'user_id' => array('UINT', 0),
92 'forum_id' => array('UINT', 0),
93 'auth_option_id' => array('UINT', 0),
94 'auth_role_id' => array('UINT', 0),
95 'auth_setting' => array('TINT:2', 0),
96 ),
97 'KEYS' => array(
98 'user_id' => array('INDEX', 'user_id'),
99 'auth_option_id' => array('INDEX', 'auth_option_id'),
100 'auth_role_id' => array('INDEX', 'auth_role_id'),
101 ),
102 );
103
104 $schema_data['phpbb_banlist'] = array(
105 'COLUMNS' => array(
106 'ban_id' => array('UINT', NULL, 'auto_increment'),
107 'ban_userid' => array('UINT', 0),
108 'ban_ip' => array('VCHAR:40', ''),
109 'ban_email' => array('VCHAR_UNI:100', ''),
110 'ban_start' => array('TIMESTAMP', 0),
111 'ban_end' => array('TIMESTAMP', 0),
112 'ban_exclude' => array('BOOL', 0),
113 'ban_reason' => array('VCHAR_UNI', ''),
114 'ban_give_reason' => array('VCHAR_UNI', ''),
115 ),
116 'PRIMARY_KEY' => 'ban_id',
117 'KEYS' => array(
118 'ban_end' => array('INDEX', 'ban_end'),
119 'ban_user' => array('INDEX', array('ban_userid', 'ban_exclude')),
120 'ban_email' => array('INDEX', array('ban_email', 'ban_exclude')),
121 'ban_ip' => array('INDEX', array('ban_ip', 'ban_exclude')),
122 ),
123 );
124
125 $schema_data['phpbb_bbcodes'] = array(
126 'COLUMNS' => array(
127 'bbcode_id' => array('TINT:3', 0),
128 'bbcode_tag' => array('VCHAR:16', ''),
129 'bbcode_helpline' => array('VCHAR_UNI', ''),
130 'display_on_posting' => array('BOOL', 0),
131 'bbcode_match' => array('TEXT_UNI', ''),
132 'bbcode_tpl' => array('MTEXT_UNI', ''),
133 'first_pass_match' => array('MTEXT_UNI', ''),
134 'first_pass_replace' => array('MTEXT_UNI', ''),
135 'second_pass_match' => array('MTEXT_UNI', ''),
136 'second_pass_replace' => array('MTEXT_UNI', ''),
137 ),
138 'PRIMARY_KEY' => 'bbcode_id',
139 'KEYS' => array(
140 'display_on_post' => array('INDEX', 'display_on_posting'),
141 ),
142 );
143
144 $schema_data['phpbb_bookmarks'] = array(
145 'COLUMNS' => array(
146 'topic_id' => array('UINT', 0),
147 'user_id' => array('UINT', 0),
148 ),
149 'PRIMARY_KEY' => array('topic_id', 'user_id'),
150 );
151
152 $schema_data['phpbb_bots'] = array(
153 'COLUMNS' => array(
154 'bot_id' => array('UINT', NULL, 'auto_increment'),
155 'bot_active' => array('BOOL', 1),
156 'bot_name' => array('STEXT_UNI', ''),
157 'user_id' => array('UINT', 0),
158 'bot_agent' => array('VCHAR', ''),
159 'bot_ip' => array('VCHAR', ''),
160 ),
161 'PRIMARY_KEY' => 'bot_id',
162 'KEYS' => array(
163 'bot_active' => array('INDEX', 'bot_active'),
164 ),
165 );
166
167 $schema_data['phpbb_config'] = array(
168 'COLUMNS' => array(
169 'config_name' => array('VCHAR', ''),
170 'config_value' => array('VCHAR_UNI', ''),
171 'is_dynamic' => array('BOOL', 0),
172 ),
173 'PRIMARY_KEY' => 'config_name',
174 'KEYS' => array(
175 'is_dynamic' => array('INDEX', 'is_dynamic'),
176 ),
177 );
178
179 $schema_data['phpbb_confirm'] = array(
180 'COLUMNS' => array(
181 'confirm_id' => array('CHAR:32', ''),
182 'session_id' => array('CHAR:32', ''),
183 'confirm_type' => array('TINT:3', 0),
184 'code' => array('VCHAR:8', ''),
185 'seed' => array('UINT:10', 0),
186 ),
187 'PRIMARY_KEY' => array('session_id', 'confirm_id'),
188 'KEYS' => array(
189 'confirm_type' => array('INDEX', 'confirm_type'),
190 ),
191 );
192
193 $schema_data['phpbb_disallow'] = array(
194 'COLUMNS' => array(
195 'disallow_id' => array('UINT', NULL, 'auto_increment'),
196 'disallow_username' => array('VCHAR_UNI:255', ''),
197 ),
198 'PRIMARY_KEY' => 'disallow_id',
199 );
200
201 $schema_data['phpbb_drafts'] = array(
202 'COLUMNS' => array(
203 'draft_id' => array('UINT', NULL, 'auto_increment'),
204 'user_id' => array('UINT', 0),
205 'topic_id' => array('UINT', 0),
206 'forum_id' => array('UINT', 0),
207 'save_time' => array('TIMESTAMP', 0),
208 'draft_subject' => array('STEXT_UNI', ''),
209 'draft_message' => array('MTEXT_UNI', ''),
210 ),
211 'PRIMARY_KEY' => 'draft_id',
212 'KEYS' => array(
213 'save_time' => array('INDEX', 'save_time'),
214 ),
215 );
216
217 $schema_data['phpbb_extensions'] = array(
218 'COLUMNS' => array(
219 'extension_id' => array('UINT', NULL, 'auto_increment'),
220 'group_id' => array('UINT', 0),
221 'extension' => array('VCHAR:100', ''),
222 ),
223 'PRIMARY_KEY' => 'extension_id',
224 );
225
226 $schema_data['phpbb_extension_groups'] = array(
227 'COLUMNS' => array(
228 'group_id' => array('UINT', NULL, 'auto_increment'),
229 'group_name' => array('VCHAR_UNI', ''),
230 'cat_id' => array('TINT:2', 0),
231 'allow_group' => array('BOOL', 0),
232 'download_mode' => array('BOOL', 1),
233 'upload_icon' => array('VCHAR', ''),
234 'max_filesize' => array('UINT:20', 0),
235 'allowed_forums' => array('TEXT', ''),
236 'allow_in_pm' => array('BOOL', 0),
237 ),
238 'PRIMARY_KEY' => 'group_id',
239 );
240
241 $schema_data['phpbb_forums'] = array(
242 'COLUMNS' => array(
243 'forum_id' => array('UINT', NULL, 'auto_increment'),
244 'parent_id' => array('UINT', 0),
245 'left_id' => array('UINT', 0),
246 'right_id' => array('UINT', 0),
247 'forum_parents' => array('MTEXT', ''),
248 'forum_name' => array('STEXT_UNI', ''),
249 'forum_desc' => array('TEXT_UNI', ''),
250 'forum_desc_bitfield' => array('VCHAR:255', ''),
251 'forum_desc_options' => array('UINT:11', 7),
252 'forum_desc_uid' => array('VCHAR:8', ''),
253 'forum_link' => array('VCHAR_UNI', ''),
254 'forum_password' => array('VCHAR_UNI:40', ''),
255 'forum_style' => array('UINT', 0),
256 'forum_image' => array('VCHAR', ''),
257 'forum_rules' => array('TEXT_UNI', ''),
258 'forum_rules_link' => array('VCHAR_UNI', ''),
259 'forum_rules_bitfield' => array('VCHAR:255', ''),
260 'forum_rules_options' => array('UINT:11', 7),
261 'forum_rules_uid' => array('VCHAR:8', ''),
262 'forum_topics_per_page' => array('TINT:4', 0),
263 'forum_type' => array('TINT:4', 0),
264 'forum_status' => array('TINT:4', 0),
265 'forum_posts' => array('UINT', 0),
266 'forum_topics' => array('UINT', 0),
267 'forum_topics_real' => array('UINT', 0),
268 'forum_last_post_id' => array('UINT', 0),
269 'forum_last_poster_id' => array('UINT', 0),
270 'forum_last_post_subject' => array('STEXT_UNI', ''),
271 'forum_last_post_time' => array('TIMESTAMP', 0),
272 'forum_last_poster_name'=> array('VCHAR_UNI', ''),
273 'forum_last_poster_colour'=> array('VCHAR:6', ''),
274 'forum_flags' => array('TINT:4', 32),
275 'display_subforum_list' => array('BOOL', 1),
276 'display_on_index' => array('BOOL', 1),
277 'enable_indexing' => array('BOOL', 1),
278 'enable_icons' => array('BOOL', 1),
279 'enable_prune' => array('BOOL', 0),
280 'prune_next' => array('TIMESTAMP', 0),
281 'prune_days' => array('UINT', 0),
282 'prune_viewed' => array('UINT', 0),
283 'prune_freq' => array('UINT', 0),
284 ),
285 'PRIMARY_KEY' => 'forum_id',
286 'KEYS' => array(
287 'left_right_id' => array('INDEX', array('left_id', 'right_id')),
288 'forum_lastpost_id' => array('INDEX', 'forum_last_post_id'),
289 ),
290 );
291
292 $schema_data['phpbb_forums_access'] = array(
293 'COLUMNS' => array(
294 'forum_id' => array('UINT', 0),
295 'user_id' => array('UINT', 0),
296 'session_id' => array('CHAR:32', ''),
297 ),
298 'PRIMARY_KEY' => array('forum_id', 'user_id', 'session_id'),
299 );
300
301 $schema_data['phpbb_forums_track'] = array(
302 'COLUMNS' => array(
303 'user_id' => array('UINT', 0),
304 'forum_id' => array('UINT', 0),
305 'mark_time' => array('TIMESTAMP', 0),
306 ),
307 'PRIMARY_KEY' => array('user_id', 'forum_id'),
308 );
309
310 $schema_data['phpbb_forums_watch'] = array(
311 'COLUMNS' => array(
312 'forum_id' => array('UINT', 0),
313 'user_id' => array('UINT', 0),
314 'notify_status' => array('BOOL', 0),
315 ),
316 'KEYS' => array(
317 'forum_id' => array('INDEX', 'forum_id'),
318 'user_id' => array('INDEX', 'user_id'),
319 'notify_stat' => array('INDEX', 'notify_status'),
320 ),
321 );
322
323 $schema_data['phpbb_groups'] = array(
324 'COLUMNS' => array(
325 'group_id' => array('UINT', NULL, 'auto_increment'),
326 'group_type' => array('TINT:4', 1),
327 'group_founder_manage' => array('BOOL', 0),
328 'group_name' => array('VCHAR_UNI', ''),
329 'group_name_clean' => array('VCHAR_UNI', ''),
330 'group_desc' => array('TEXT_UNI', ''),
331 'group_desc_bitfield' => array('VCHAR:255', ''),
332 'group_desc_options' => array('UINT:11', 7),
333 'group_desc_uid' => array('VCHAR:8', ''),
334 'group_display' => array('BOOL', 0),
335 'group_avatar' => array('VCHAR', ''),
336 'group_avatar_type' => array('TINT:2', 0),
337 'group_avatar_width' => array('USINT', 0),
338 'group_avatar_height' => array('USINT', 0),
339 'group_rank' => array('UINT', 0),
340 'group_colour' => array('VCHAR:6', ''),
341 'group_sig_chars' => array('UINT', 0),
342 'group_receive_pm' => array('BOOL', 0),
343 'group_message_limit' => array('UINT', 0),
344 'group_max_recipients' => array('UINT', 0),
345 'group_legend' => array('BOOL', 1),
346 ),
347 'PRIMARY_KEY' => 'group_id',
348 'KEYS' => array(
349 'group_legend_name' => array('INDEX', array('group_legend', 'group_name')),
350 ),
351 );
352
353 $schema_data['phpbb_icons'] = array(
354 'COLUMNS' => array(
355 'icons_id' => array('UINT', NULL, 'auto_increment'),
356 'icons_url' => array('VCHAR', ''),
357 'icons_width' => array('TINT:4', 0),
358 'icons_height' => array('TINT:4', 0),
359 'icons_order' => array('UINT', 0),
360 'display_on_posting' => array('BOOL', 1),
361 ),
362 'PRIMARY_KEY' => 'icons_id',
363 'KEYS' => array(
364 'display_on_posting' => array('INDEX', 'display_on_posting'),
365 ),
366 );
367
368 $schema_data['phpbb_lang'] = array(
369 'COLUMNS' => array(
370 'lang_id' => array('TINT:4', NULL, 'auto_increment'),
371 'lang_iso' => array('VCHAR:30', ''),
372 'lang_dir' => array('VCHAR:30', ''),
373 'lang_english_name' => array('VCHAR_UNI:100', ''),
374 'lang_local_name' => array('VCHAR_UNI:255', ''),
375 'lang_author' => array('VCHAR_UNI:255', ''),
376 ),
377 'PRIMARY_KEY' => 'lang_id',
378 'KEYS' => array(
379 'lang_iso' => array('INDEX', 'lang_iso'),
380 ),
381 );
382
383 $schema_data['phpbb_log'] = array(
384 'COLUMNS' => array(
385 'log_id' => array('UINT', NULL, 'auto_increment'),
386 'log_type' => array('TINT:4', 0),
387 'user_id' => array('UINT', 0),
388 'forum_id' => array('UINT', 0),
389 'topic_id' => array('UINT', 0),
390 'reportee_id' => array('UINT', 0),
391 'log_ip' => array('VCHAR:40', ''),
392 'log_time' => array('TIMESTAMP', 0),
393 'log_operation' => array('TEXT_UNI', ''),
394 'log_data' => array('MTEXT_UNI', ''),
395 ),
396 'PRIMARY_KEY' => 'log_id',
397 'KEYS' => array(
398 'log_type' => array('INDEX', 'log_type'),
399 'forum_id' => array('INDEX', 'forum_id'),
400 'topic_id' => array('INDEX', 'topic_id'),
401 'reportee_id' => array('INDEX', 'reportee_id'),
402 'user_id' => array('INDEX', 'user_id'),
403 ),
404 );
405
406 $schema_data['phpbb_moderator_cache'] = array(
407 'COLUMNS' => array(
408 'forum_id' => array('UINT', 0),
409 'user_id' => array('UINT', 0),
410 'username' => array('VCHAR_UNI:255', ''),
411 'group_id' => array('UINT', 0),
412 'group_name' => array('VCHAR_UNI', ''),
413 'display_on_index' => array('BOOL', 1),
414 ),
415 'KEYS' => array(
416 'disp_idx' => array('INDEX', 'display_on_index'),
417 'forum_id' => array('INDEX', 'forum_id'),
418 ),
419 );
420
421 $schema_data['phpbb_modules'] = array(
422 'COLUMNS' => array(
423 'module_id' => array('UINT', NULL, 'auto_increment'),
424 'module_enabled' => array('BOOL', 1),
425 'module_display' => array('BOOL', 1),
426 'module_basename' => array('VCHAR', ''),
427 'module_class' => array('VCHAR:10', ''),
428 'parent_id' => array('UINT', 0),
429 'left_id' => array('UINT', 0),
430 'right_id' => array('UINT', 0),
431 'module_langname' => array('VCHAR', ''),
432 'module_mode' => array('VCHAR', ''),
433 'module_auth' => array('VCHAR', ''),
434 ),
435 'PRIMARY_KEY' => 'module_id',
436 'KEYS' => array(
437 'left_right_id' => array('INDEX', array('left_id', 'right_id')),
438 'module_enabled' => array('INDEX', 'module_enabled'),
439 'class_left_id' => array('INDEX', array('module_class', 'left_id')),
440 ),
441 );
442
443 $schema_data['phpbb_poll_options'] = array(
444 'COLUMNS' => array(
445 'poll_option_id' => array('TINT:4', 0),
446 'topic_id' => array('UINT', 0),
447 'poll_option_text' => array('TEXT_UNI', ''),
448 'poll_option_total' => array('UINT', 0),
449 ),
450 'KEYS' => array(
451 'poll_opt_id' => array('INDEX', 'poll_option_id'),
452 'topic_id' => array('INDEX', 'topic_id'),
453 ),
454 );
455
456 $schema_data['phpbb_poll_votes'] = array(
457 'COLUMNS' => array(
458 'topic_id' => array('UINT', 0),
459 'poll_option_id' => array('TINT:4', 0),
460 'vote_user_id' => array('UINT', 0),
461 'vote_user_ip' => array('VCHAR:40', ''),
462 ),
463 'KEYS' => array(
464 'topic_id' => array('INDEX', 'topic_id'),
465 'vote_user_id' => array('INDEX', 'vote_user_id'),
466 'vote_user_ip' => array('INDEX', 'vote_user_ip'),
467 ),
468 );
469
470 $schema_data['phpbb_posts'] = array(
471 'COLUMNS' => array(
472 'post_id' => array('UINT', NULL, 'auto_increment'),
473 'topic_id' => array('UINT', 0),
474 'forum_id' => array('UINT', 0),
475 'poster_id' => array('UINT', 0),
476 'icon_id' => array('UINT', 0),
477 'poster_ip' => array('VCHAR:40', ''),
478 'post_time' => array('TIMESTAMP', 0),
479 'post_approved' => array('BOOL', 1),
480 'post_reported' => array('BOOL', 0),
481 'enable_bbcode' => array('BOOL', 1),
482 'enable_smilies' => array('BOOL', 1),
483 'enable_magic_url' => array('BOOL', 1),
484 'enable_sig' => array('BOOL', 1),
485 'post_username' => array('VCHAR_UNI:255', ''),
486 'post_subject' => array('STEXT_UNI', '', 'true_sort'),
487 'post_text' => array('MTEXT_UNI', ''),
488 'post_checksum' => array('VCHAR:32', ''),
489 'post_attachment' => array('BOOL', 0),
490 'bbcode_bitfield' => array('VCHAR:255', ''),
491 'bbcode_uid' => array('VCHAR:8', ''),
492 'post_postcount' => array('BOOL', 1),
493 'post_edit_time' => array('TIMESTAMP', 0),
494 'post_edit_reason' => array('STEXT_UNI', ''),
495 'post_edit_user' => array('UINT', 0),
496 'post_edit_count' => array('USINT', 0),
497 'post_edit_locked' => array('BOOL', 0),
498 ),
499 'PRIMARY_KEY' => 'post_id',
500 'KEYS' => array(
501 'forum_id' => array('INDEX', 'forum_id'),
502 'topic_id' => array('INDEX', 'topic_id'),
503 'poster_ip' => array('INDEX', 'poster_ip'),
504 'poster_id' => array('INDEX', 'poster_id'),
505 'post_approved' => array('INDEX', 'post_approved'),
506 'tid_post_time' => array('INDEX', array('topic_id', 'post_time')),
507 ),
508 );
509
510 $schema_data['phpbb_privmsgs'] = array(
511 'COLUMNS' => array(
512 'msg_id' => array('UINT', NULL, 'auto_increment'),
513 'root_level' => array('UINT', 0),
514 'author_id' => array('UINT', 0),
515 'icon_id' => array('UINT', 0),
516 'author_ip' => array('VCHAR:40', ''),
517 'message_time' => array('TIMESTAMP', 0),
518 'enable_bbcode' => array('BOOL', 1),
519 'enable_smilies' => array('BOOL', 1),
520 'enable_magic_url' => array('BOOL', 1),
521 'enable_sig' => array('BOOL', 1),
522 'message_subject' => array('STEXT_UNI', ''),
523 'message_text' => array('MTEXT_UNI', ''),
524 'message_edit_reason' => array('STEXT_UNI', ''),
525 'message_edit_user' => array('UINT', 0),
526 'message_attachment' => array('BOOL', 0),
527 'bbcode_bitfield' => array('VCHAR:255', ''),
528 'bbcode_uid' => array('VCHAR:8', ''),
529 'message_edit_time' => array('TIMESTAMP', 0),
530 'message_edit_count' => array('USINT', 0),
531 'to_address' => array('TEXT_UNI', ''),
532 'bcc_address' => array('TEXT_UNI', ''),
533 ),
534 'PRIMARY_KEY' => 'msg_id',
535 'KEYS' => array(
536 'author_ip' => array('INDEX', 'author_ip'),
537 'message_time' => array('INDEX', 'message_time'),
538 'author_id' => array('INDEX', 'author_id'),
539 'root_level' => array('INDEX', 'root_level'),
540 ),
541 );
542
543 $schema_data['phpbb_privmsgs_folder'] = array(
544 'COLUMNS' => array(
545 'folder_id' => array('UINT', NULL, 'auto_increment'),
546 'user_id' => array('UINT', 0),
547 'folder_name' => array('VCHAR_UNI', ''),
548 'pm_count' => array('UINT', 0),
549 ),
550 'PRIMARY_KEY' => 'folder_id',
551 'KEYS' => array(
552 'user_id' => array('INDEX', 'user_id'),
553 ),
554 );
555
556 $schema_data['phpbb_privmsgs_rules'] = array(
557 'COLUMNS' => array(
558 'rule_id' => array('UINT', NULL, 'auto_increment'),
559 'user_id' => array('UINT', 0),
560 'rule_check' => array('UINT', 0),
561 'rule_connection' => array('UINT', 0),
562 'rule_string' => array('VCHAR_UNI', ''),
563 'rule_user_id' => array('UINT', 0),
564 'rule_group_id' => array('UINT', 0),
565 'rule_action' => array('UINT', 0),
566 'rule_folder_id' => array('INT:11', 0),
567 ),
568 'PRIMARY_KEY' => 'rule_id',
569 'KEYS' => array(
570 'user_id' => array('INDEX', 'user_id'),
571 ),
572 );
573
574 $schema_data['phpbb_privmsgs_to'] = array(
575 'COLUMNS' => array(
576 'msg_id' => array('UINT', 0),
577 'user_id' => array('UINT', 0),
578 'author_id' => array('UINT', 0),
579 'pm_deleted' => array('BOOL', 0),
580 'pm_new' => array('BOOL', 1),
581 'pm_unread' => array('BOOL', 1),
582 'pm_replied' => array('BOOL', 0),
583 'pm_marked' => array('BOOL', 0),
584 'pm_forwarded' => array('BOOL', 0),
585 'folder_id' => array('INT:11', 0),
586 ),
587 'KEYS' => array(
588 'msg_id' => array('INDEX', 'msg_id'),
589 'author_id' => array('INDEX', 'author_id'),
590 'usr_flder_id' => array('INDEX', array('user_id', 'folder_id')),
591 ),
592 );
593
594 $schema_data['phpbb_profile_fields'] = array(
595 'COLUMNS' => array(
596 'field_id' => array('UINT', NULL, 'auto_increment'),
597 'field_name' => array('VCHAR_UNI', ''),
598 'field_type' => array('TINT:4', 0),
599 'field_ident' => array('VCHAR:20', ''),
600 'field_length' => array('VCHAR:20', ''),
601 'field_minlen' => array('VCHAR', ''),
602 'field_maxlen' => array('VCHAR', ''),
603 'field_novalue' => array('VCHAR_UNI', ''),
604 'field_default_value' => array('VCHAR_UNI', ''),
605 'field_validation' => array('VCHAR_UNI:20', ''),
606 'field_required' => array('BOOL', 0),
607 'field_show_on_reg' => array('BOOL', 0),
608 'field_show_profile' => array('BOOL', 0),
609 'field_hide' => array('BOOL', 0),
610 'field_no_view' => array('BOOL', 0),
611 'field_active' => array('BOOL', 0),
612 'field_order' => array('UINT', 0),
613 ),
614 'PRIMARY_KEY' => 'field_id',
615 'KEYS' => array(
616 'fld_type' => array('INDEX', 'field_type'),
617 'fld_ordr' => array('INDEX', 'field_order'),
618 ),
619 );
620
621 $schema_data['phpbb_profile_fields_data'] = array(
622 'COLUMNS' => array(
623 'user_id' => array('UINT', 0),
624 ),
625 'PRIMARY_KEY' => 'user_id',
626 );
627
628 $schema_data['phpbb_profile_fields_lang'] = array(
629 'COLUMNS' => array(
630 'field_id' => array('UINT', 0),
631 'lang_id' => array('UINT', 0),
632 'option_id' => array('UINT', 0),
633 'field_type' => array('TINT:4', 0),
634 'lang_value' => array('VCHAR_UNI', ''),
635 ),
636 'PRIMARY_KEY' => array('field_id', 'lang_id', 'option_id'),
637 );
638
639 $schema_data['phpbb_profile_lang'] = array(
640 'COLUMNS' => array(
641 'field_id' => array('UINT', 0),
642 'lang_id' => array('UINT', 0),
643 'lang_name' => array('VCHAR_UNI', ''),
644 'lang_explain' => array('TEXT_UNI', ''),
645 'lang_default_value' => array('VCHAR_UNI', ''),
646 ),
647 'PRIMARY_KEY' => array('field_id', 'lang_id'),
648 );
649
650 $schema_data['phpbb_ranks'] = array(
651 'COLUMNS' => array(
652 'rank_id' => array('UINT', NULL, 'auto_increment'),
653 'rank_title' => array('VCHAR_UNI', ''),
654 'rank_min' => array('UINT', 0),
655 'rank_special' => array('BOOL', 0),
656 'rank_image' => array('VCHAR', ''),
657 ),
658 'PRIMARY_KEY' => 'rank_id',
659 );
660
661 $schema_data['phpbb_reports'] = array(
662 'COLUMNS' => array(
663 'report_id' => array('UINT', NULL, 'auto_increment'),
664 'reason_id' => array('USINT', 0),
665 'post_id' => array('UINT', 0),
666 'user_id' => array('UINT', 0),
667 'user_notify' => array('BOOL', 0),
668 'report_closed' => array('BOOL', 0),
669 'report_time' => array('TIMESTAMP', 0),
670 'report_text' => array('MTEXT_UNI', ''),
671 ),
672 'PRIMARY_KEY' => 'report_id',
673 );
674
675 $schema_data['phpbb_reports_reasons'] = array(
676 'COLUMNS' => array(
677 'reason_id' => array('USINT', NULL, 'auto_increment'),
678 'reason_title' => array('VCHAR_UNI', ''),
679 'reason_description' => array('MTEXT_UNI', ''),
680 'reason_order' => array('USINT', 0),
681 ),
682 'PRIMARY_KEY' => 'reason_id',
683 );
684
685 $schema_data['phpbb_search_results'] = array(
686 'COLUMNS' => array(
687 'search_key' => array('VCHAR:32', ''),
688 'search_time' => array('TIMESTAMP', 0),
689 'search_keywords' => array('MTEXT_UNI', ''),
690 'search_authors' => array('MTEXT', ''),
691 ),
692 'PRIMARY_KEY' => 'search_key',
693 );
694
695 $schema_data['phpbb_search_wordlist'] = array(
696 'COLUMNS' => array(
697 'word_id' => array('UINT', NULL, 'auto_increment'),
698 'word_text' => array('VCHAR_UNI', ''),
699 'word_common' => array('BOOL', 0),
700 'word_count' => array('UINT', 0),
701 ),
702 'PRIMARY_KEY' => 'word_id',
703 'KEYS' => array(
704 'wrd_txt' => array('UNIQUE', 'word_text'),
705 'wrd_cnt' => array('INDEX', 'word_count'),
706 ),
707 );
708
709 $schema_data['phpbb_search_wordmatch'] = array(
710 'COLUMNS' => array(
711 'post_id' => array('UINT', 0),
712 'word_id' => array('UINT', 0),
713 'title_match' => array('BOOL', 0),
714 ),
715 'KEYS' => array(
716 'unq_mtch' => array('UNIQUE', array('word_id', 'post_id', 'title_match')),
717 'word_id' => array('INDEX', 'word_id'),
718 'post_id' => array('INDEX', 'post_id'),
719 ),
720 );
721
722 $schema_data['phpbb_sessions'] = array(
723 'COLUMNS' => array(
724 'session_id' => array('CHAR:32', ''),
725 'session_user_id' => array('UINT', 0),
726 'session_forum_id' => array('UINT', 0),
727 'session_last_visit' => array('TIMESTAMP', 0),
728 'session_start' => array('TIMESTAMP', 0),
729 'session_time' => array('TIMESTAMP', 0),
730 'session_ip' => array('VCHAR:40', ''),
731 'session_browser' => array('VCHAR:150', ''),
732 'session_forwarded_for' => array('VCHAR:255', ''),
733 'session_page' => array('VCHAR_UNI', ''),
734 'session_viewonline' => array('BOOL', 1),
735 'session_autologin' => array('BOOL', 0),
736 'session_admin' => array('BOOL', 0),
737 ),
738 'PRIMARY_KEY' => 'session_id',
739 'KEYS' => array(
740 'session_time' => array('INDEX', 'session_time'),
741 'session_user_id' => array('INDEX', 'session_user_id'),
742 'session_fid' => array('INDEX', 'session_forum_id'),
743 ),
744 );
745
746 $schema_data['phpbb_sessions_keys'] = array(
747 'COLUMNS' => array(
748 'key_id' => array('CHAR:32', ''),
749 'user_id' => array('UINT', 0),
750 'last_ip' => array('VCHAR:40', ''),
751 'last_login' => array('TIMESTAMP', 0),
752 ),
753 'PRIMARY_KEY' => array('key_id', 'user_id'),
754 'KEYS' => array(
755 'last_login' => array('INDEX', 'last_login'),
756 ),
757 );
758
759 $schema_data['phpbb_sitelist'] = array(
760 'COLUMNS' => array(
761 'site_id' => array('UINT', NULL, 'auto_increment'),
762 'site_ip' => array('VCHAR:40', ''),
763 'site_hostname' => array('VCHAR', ''),
764 'ip_exclude' => array('BOOL', 0),
765 ),
766 'PRIMARY_KEY' => 'site_id',
767 );
768
769 $schema_data['phpbb_smilies'] = array(
770 'COLUMNS' => array(
771 'smiley_id' => array('UINT', NULL, 'auto_increment'),
772 // We may want to set 'code' to VCHAR:50 or check if unicode support is possible... at the moment only ASCII characters are allowed.
773 'code' => array('VCHAR_UNI:50', ''),
774 'emotion' => array('VCHAR_UNI:50', ''),
775 'smiley_url' => array('VCHAR:50', ''),
776 'smiley_width' => array('USINT', 0),
777 'smiley_height' => array('USINT', 0),
778 'smiley_order' => array('UINT', 0),
779 'display_on_posting'=> array('BOOL', 1),
780 ),
781 'PRIMARY_KEY' => 'smiley_id',
782 'KEYS' => array(
783 'display_on_post' => array('INDEX', 'display_on_posting'),
784 ),
785 );
786
787 $schema_data['phpbb_styles'] = array(
788 'COLUMNS' => array(
789 'style_id' => array('UINT', NULL, 'auto_increment'),
790 'style_name' => array('VCHAR_UNI:255', ''),
791 'style_copyright' => array('VCHAR_UNI', ''),
792 'style_active' => array('BOOL', 1),
793 'template_id' => array('UINT', 0),
794 'theme_id' => array('UINT', 0),
795 'imageset_id' => array('UINT', 0),
796 ),
797 'PRIMARY_KEY' => 'style_id',
798 'KEYS' => array(
799 'style_name' => array('UNIQUE', 'style_name'),
800 'template_id' => array('INDEX', 'template_id'),
801 'theme_id' => array('INDEX', 'theme_id'),
802 'imageset_id' => array('INDEX', 'imageset_id'),
803 ),
804 );
805
806 $schema_data['phpbb_styles_template'] = array(
807 'COLUMNS' => array(
808 'template_id' => array('UINT', NULL, 'auto_increment'),
809 'template_name' => array('VCHAR_UNI:255', ''),
810 'template_copyright' => array('VCHAR_UNI', ''),
811 'template_path' => array('VCHAR:100', ''),
812 'bbcode_bitfield' => array('VCHAR:255', 'kNg='),
813 'template_storedb' => array('BOOL', 0),
814 'template_inherits_id' => array('UINT:4', 0),
815 'template_inherit_path' => array('VCHAR', ''),
816 ),
817 'PRIMARY_KEY' => 'template_id',
818 'KEYS' => array(
819 'tmplte_nm' => array('UNIQUE', 'template_name'),
820 ),
821 );
822
823 $schema_data['phpbb_styles_theme'] = array(
824 'COLUMNS' => array(
825 'theme_id' => array('UINT', NULL, 'auto_increment'),
826 'theme_name' => array('VCHAR_UNI:255', ''),
827 'theme_copyright' => array('VCHAR_UNI', ''),
828 'theme_path' => array('VCHAR:100', ''),
829 'theme_storedb' => array('BOOL', 0),
830 'theme_mtime' => array('TIMESTAMP', 0),
831 'theme_data' => array('MTEXT_UNI', ''),
832 ),
833 'PRIMARY_KEY' => 'theme_id',
834 'KEYS' => array(
835 'theme_name' => array('UNIQUE', 'theme_name'),
836 ),
837 );
838
839 $schema_data['phpbb_styles_imageset'] = array(
840 'COLUMNS' => array(
841 'imageset_id' => array('UINT', NULL, 'auto_increment'),
842 'imageset_name' => array('VCHAR_UNI:255', ''),
843 'imageset_copyright' => array('VCHAR_UNI', ''),
844 'imageset_path' => array('VCHAR:100', ''),
845 ),
846 'PRIMARY_KEY' => 'imageset_id',
847 'KEYS' => array(
848 'imgset_nm' => array('UNIQUE', 'imageset_name'),
849 ),
850 );
851
852 $schema_data['phpbb_styles_imageset_data'] = array(
853 'COLUMNS' => array(
854 'image_id' => array('UINT', NULL, 'auto_increment'),
855 'image_name' => array('VCHAR:200', ''),
856 'image_filename' => array('VCHAR:200', ''),
857 'image_lang' => array('VCHAR:30', ''),
858 'image_height' => array('USINT', 0),
859 'image_width' => array('USINT', 0),
860 'imageset_id' => array('UINT', 0),
861 ),
862 'PRIMARY_KEY' => 'image_id',
863 'KEYS' => array(
864 'i_d' => array('INDEX', 'imageset_id'),
865 ),
866 );
867
868 $schema_data['phpbb_topics'] = array(
869 'COLUMNS' => array(
870 'topic_id' => array('UINT', NULL, 'auto_increment'),
871 'forum_id' => array('UINT', 0),
872 'icon_id' => array('UINT', 0),
873 'topic_attachment' => array('BOOL', 0),
874 'topic_approved' => array('BOOL', 1),
875 'topic_reported' => array('BOOL', 0),
876 'topic_title' => array('STEXT_UNI', '', 'true_sort'),
877 'topic_poster' => array('UINT', 0),
878 'topic_time' => array('TIMESTAMP', 0),
879 'topic_time_limit' => array('TIMESTAMP', 0),
880 'topic_views' => array('UINT', 0),
881 'topic_replies' => array('UINT', 0),
882 'topic_replies_real' => array('UINT', 0),
883 'topic_status' => array('TINT:3', 0),
884 'topic_type' => array('TINT:3', 0),
885 'topic_first_post_id' => array('UINT', 0),
886 'topic_first_poster_name' => array('VCHAR_UNI', ''),
887 'topic_first_poster_colour' => array('VCHAR:6', ''),
888 'topic_last_post_id' => array('UINT', 0),
889 'topic_last_poster_id' => array('UINT', 0),
890 'topic_last_poster_name' => array('VCHAR_UNI', ''),
891 'topic_last_poster_colour' => array('VCHAR:6', ''),
892 'topic_last_post_subject' => array('STEXT_UNI', ''),
893 'topic_last_post_time' => array('TIMESTAMP', 0),
894 'topic_last_view_time' => array('TIMESTAMP', 0),
895 'topic_moved_id' => array('UINT', 0),
896 'topic_bumped' => array('BOOL', 0),
897 'topic_bumper' => array('UINT', 0),
898 'poll_title' => array('STEXT_UNI', ''),
899 'poll_start' => array('TIMESTAMP', 0),
900 'poll_length' => array('TIMESTAMP', 0),
901 'poll_max_options' => array('TINT:4', 1),
902 'poll_last_vote' => array('TIMESTAMP', 0),
903 'poll_vote_change' => array('BOOL', 0),
904 ),
905 'PRIMARY_KEY' => 'topic_id',
906 'KEYS' => array(
907 'forum_id' => array('INDEX', 'forum_id'),
908 'forum_id_type' => array('INDEX', array('forum_id', 'topic_type')),
909 'last_post_time' => array('INDEX', 'topic_last_post_time'),
910 'topic_approved' => array('INDEX', 'topic_approved'),
911 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_approved', 'topic_last_post_id')),
912 'fid_time_moved' => array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),
913 ),
914 );
915
916 $schema_data['phpbb_topics_track'] = array(
917 'COLUMNS' => array(
918 'user_id' => array('UINT', 0),
919 'topic_id' => array('UINT', 0),
920 'forum_id' => array('UINT', 0),
921 'mark_time' => array('TIMESTAMP', 0),
922 ),
923 'PRIMARY_KEY' => array('user_id', 'topic_id'),
924 'KEYS' => array(
925 'forum_id' => array('INDEX', 'forum_id'),
926 ),
927 );
928
929 $schema_data['phpbb_topics_posted'] = array(
930 'COLUMNS' => array(
931 'user_id' => array('UINT', 0),
932 'topic_id' => array('UINT', 0),
933 'topic_posted' => array('BOOL', 0),
934 ),
935 'PRIMARY_KEY' => array('user_id', 'topic_id'),
936 );
937
938 $schema_data['phpbb_topics_watch'] = array(
939 'COLUMNS' => array(
940 'topic_id' => array('UINT', 0),
941 'user_id' => array('UINT', 0),
942 'notify_status' => array('BOOL', 0),
943 ),
944 'KEYS' => array(
945 'topic_id' => array('INDEX', 'topic_id'),
946 'user_id' => array('INDEX', 'user_id'),
947 'notify_stat' => array('INDEX', 'notify_status'),
948 ),
949 );
950
951 $schema_data['phpbb_user_group'] = array(
952 'COLUMNS' => array(
953 'group_id' => array('UINT', 0),
954 'user_id' => array('UINT', 0),
955 'group_leader' => array('BOOL', 0),
956 'user_pending' => array('BOOL', 1),
957 ),
958 'KEYS' => array(
959 'group_id' => array('INDEX', 'group_id'),
960 'user_id' => array('INDEX', 'user_id'),
961 'group_leader' => array('INDEX', 'group_leader'),
962 ),
963 );
964
965 $schema_data['phpbb_users'] = array(
966 'COLUMNS' => array(
967 'user_id' => array('UINT', NULL, 'auto_increment'),
968 'user_type' => array('TINT:2', 0),
969 'group_id' => array('UINT', 3),
970 'user_permissions' => array('MTEXT', ''),
971 'user_perm_from' => array('UINT', 0),
972 'user_ip' => array('VCHAR:40', ''),
973 'user_regdate' => array('TIMESTAMP', 0),
974 'username' => array('VCHAR_UNI', ''),
975 'username_clean' => array('VCHAR_UNI', ''),
976 'user_password' => array('VCHAR_UNI:40', ''),
977 'user_passchg' => array('TIMESTAMP', 0),
978 'user_pass_convert' => array('BOOL', 0),
979 'user_email' => array('VCHAR_UNI:100', ''),
980 'user_email_hash' => array('BINT', 0),
981 'user_birthday' => array('VCHAR:10', ''),
982 'user_lastvisit' => array('TIMESTAMP', 0),
983 'user_lastmark' => array('TIMESTAMP', 0),
984 'user_lastpost_time' => array('TIMESTAMP', 0),
985 'user_lastpage' => array('VCHAR_UNI:200', ''),
986 'user_last_confirm_key' => array('VCHAR:10', ''),
987 'user_last_search' => array('TIMESTAMP', 0),
988 'user_warnings' => array('TINT:4', 0),
989 'user_last_warning' => array('TIMESTAMP', 0),
990 'user_login_attempts' => array('TINT:4', 0),
991 'user_inactive_reason' => array('TINT:2', 0),
992 'user_inactive_time' => array('TIMESTAMP', 0),
993 'user_posts' => array('UINT', 0),
994 'user_lang' => array('VCHAR:30', ''),
995 'user_timezone' => array('DECIMAL', 0),
996 'user_dst' => array('BOOL', 0),
997 'user_dateformat' => array('VCHAR_UNI:30', 'd M Y H:i'),
998 'user_style' => array('UINT', 0),
999 'user_rank' => array('UINT', 0),
1000 'user_colour' => array('VCHAR:6', ''),
1001 'user_new_privmsg' => array('INT:4', 0),
1002 'user_unread_privmsg' => array('INT:4', 0),
1003 'user_last_privmsg' => array('TIMESTAMP', 0),
1004 'user_message_rules' => array('BOOL', 0),
1005 'user_full_folder' => array('INT:11', -3),
1006 'user_emailtime' => array('TIMESTAMP', 0),
1007 'user_topic_show_days' => array('USINT', 0),
1008 'user_topic_sortby_type' => array('VCHAR:1', 't'),
1009 'user_topic_sortby_dir' => array('VCHAR:1', 'd'),
1010 'user_post_show_days' => array('USINT', 0),
1011 'user_post_sortby_type' => array('VCHAR:1', 't'),
1012 'user_post_sortby_dir' => array('VCHAR:1', 'a'),
1013 'user_notify' => array('BOOL', 0),
1014 'user_notify_pm' => array('BOOL', 1),
1015 'user_notify_type' => array('TINT:4', 0),
1016 'user_allow_pm' => array('BOOL', 1),
1017 'user_allow_viewonline' => array('BOOL', 1),
1018 'user_allow_viewemail' => array('BOOL', 1),
1019 'user_allow_massemail' => array('BOOL', 1),
1020 'user_options' => array('UINT:11', 895),
1021 'user_avatar' => array('VCHAR', ''),
1022 'user_avatar_type' => array('TINT:2', 0),
1023 'user_avatar_width' => array('USINT', 0),
1024 'user_avatar_height' => array('USINT', 0),
1025 'user_sig' => array('MTEXT_UNI', ''),
1026 'user_sig_bbcode_uid' => array('VCHAR:8', ''),
1027 'user_sig_bbcode_bitfield' => array('VCHAR:255', ''),
1028 'user_from' => array('VCHAR_UNI:100', ''),
1029 'user_icq' => array('VCHAR:15', ''),
1030 'user_aim' => array('VCHAR_UNI', ''),
1031 'user_yim' => array('VCHAR_UNI', ''),
1032 'user_msnm' => array('VCHAR_UNI', ''),
1033 'user_jabber' => array('VCHAR_UNI', ''),
1034 'user_website' => array('VCHAR_UNI:200', ''),
1035 'user_occ' => array('TEXT_UNI', ''),
1036 'user_interests' => array('TEXT_UNI', ''),
1037 'user_actkey' => array('VCHAR:32', ''),
1038 'user_newpasswd' => array('VCHAR_UNI:40', ''),
1039 'user_form_salt' => array('VCHAR_UNI:32', ''),
1040
1041 ),
1042 'PRIMARY_KEY' => 'user_id',
1043 'KEYS' => array(
1044 'user_birthday' => array('INDEX', 'user_birthday'),
1045 'user_email_hash' => array('INDEX', 'user_email_hash'),
1046 'user_type' => array('INDEX', 'user_type'),
1047 'username_clean' => array('UNIQUE', 'username_clean'),
1048 ),
1049 );
1050
1051 $schema_data['phpbb_warnings'] = array(
1052 'COLUMNS' => array(
1053 'warning_id' => array('UINT', NULL, 'auto_increment'),
1054 'user_id' => array('UINT', 0),
1055 'post_id' => array('UINT', 0),
1056 'log_id' => array('UINT', 0),
1057 'warning_time' => array('TIMESTAMP', 0),
1058 ),
1059 'PRIMARY_KEY' => 'warning_id',
1060 );
1061
1062 $schema_data['phpbb_words'] = array(
1063 'COLUMNS' => array(
1064 'word_id' => array('UINT', NULL, 'auto_increment'),
1065 'word' => array('VCHAR_UNI', ''),
1066 'replacement' => array('VCHAR_UNI', ''),
1067 ),
1068 'PRIMARY_KEY' => 'word_id',
1069 );
1070
1071 $schema_data['phpbb_zebra'] = array(
1072 'COLUMNS' => array(
1073 'user_id' => array('UINT', 0),
1074 'zebra_id' => array('UINT', 0),
1075 'friend' => array('BOOL', 0),
1076 'foe' => array('BOOL', 0),
1077 ),
1078 'PRIMARY_KEY' => array('user_id', 'zebra_id'),
1079 );
1080
1081 ?>
phpbb is a php-based BBS (buletin board system)