?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
extend the style columns (style_id, template_id, imageset_id, image_id...)
[phpbb.git] / phpBB / install / schemas / schema_data.php
blob12046be437ce31bb8095c5d3dddbf90cc2155ed1
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_legend' => array('BOOL', 1),
345 ),
346 'PRIMARY_KEY' => 'group_id',
347 'KEYS' => array(
348 'group_legend' => array('INDEX', 'group_legend'),
349 ),
350 );
351
352 $schema_data['phpbb_icons'] = array(
353 'COLUMNS' => array(
354 'icons_id' => array('UINT', NULL, 'auto_increment'),
355 'icons_url' => array('VCHAR', ''),
356 'icons_width' => array('TINT:4', 0),
357 'icons_height' => array('TINT:4', 0),
358 'icons_order' => array('UINT', 0),
359 'display_on_posting' => array('BOOL', 1),
360 ),
361 'PRIMARY_KEY' => 'icons_id',
362 'KEYS' => array(
363 'display_on_posting' => array('INDEX', 'display_on_posting'),
364 ),
365 );
366
367 $schema_data['phpbb_lang'] = array(
368 'COLUMNS' => array(
369 'lang_id' => array('TINT:4', NULL, 'auto_increment'),
370 'lang_iso' => array('VCHAR:30', ''),
371 'lang_dir' => array('VCHAR:30', ''),
372 'lang_english_name' => array('VCHAR_UNI:100', ''),
373 'lang_local_name' => array('VCHAR_UNI:255', ''),
374 'lang_author' => array('VCHAR_UNI:255', ''),
375 ),
376 'PRIMARY_KEY' => 'lang_id',
377 'KEYS' => array(
378 'lang_iso' => array('INDEX', 'lang_iso'),
379 ),
380 );
381
382 $schema_data['phpbb_log'] = array(
383 'COLUMNS' => array(
384 'log_id' => array('UINT', NULL, 'auto_increment'),
385 'log_type' => array('TINT:4', 0),
386 'user_id' => array('UINT', 0),
387 'forum_id' => array('UINT', 0),
388 'topic_id' => array('UINT', 0),
389 'reportee_id' => array('UINT', 0),
390 'log_ip' => array('VCHAR:40', ''),
391 'log_time' => array('TIMESTAMP', 0),
392 'log_operation' => array('TEXT_UNI', ''),
393 'log_data' => array('MTEXT_UNI', ''),
394 ),
395 'PRIMARY_KEY' => 'log_id',
396 'KEYS' => array(
397 'log_type' => array('INDEX', 'log_type'),
398 'forum_id' => array('INDEX', 'forum_id'),
399 'topic_id' => array('INDEX', 'topic_id'),
400 'reportee_id' => array('INDEX', 'reportee_id'),
401 'user_id' => array('INDEX', 'user_id'),
402 ),
403 );
404
405 $schema_data['phpbb_moderator_cache'] = array(
406 'COLUMNS' => array(
407 'forum_id' => array('UINT', 0),
408 'user_id' => array('UINT', 0),
409 'username' => array('VCHAR_UNI:255', ''),
410 'group_id' => array('UINT', 0),
411 'group_name' => array('VCHAR_UNI', ''),
412 'display_on_index' => array('BOOL', 1),
413 ),
414 'KEYS' => array(
415 'disp_idx' => array('INDEX', 'display_on_index'),
416 'forum_id' => array('INDEX', 'forum_id'),
417 ),
418 );
419
420 $schema_data['phpbb_modules'] = array(
421 'COLUMNS' => array(
422 'module_id' => array('UINT', NULL, 'auto_increment'),
423 'module_enabled' => array('BOOL', 1),
424 'module_display' => array('BOOL', 1),
425 'module_basename' => array('VCHAR', ''),
426 'module_class' => array('VCHAR:10', ''),
427 'parent_id' => array('UINT', 0),
428 'left_id' => array('UINT', 0),
429 'right_id' => array('UINT', 0),
430 'module_langname' => array('VCHAR', ''),
431 'module_mode' => array('VCHAR', ''),
432 'module_auth' => array('VCHAR', ''),
433 ),
434 'PRIMARY_KEY' => 'module_id',
435 'KEYS' => array(
436 'left_right_id' => array('INDEX', array('left_id', 'right_id')),
437 'module_enabled' => array('INDEX', 'module_enabled'),
438 'class_left_id' => array('INDEX', array('module_class', 'left_id')),
439 ),
440 );
441
442 $schema_data['phpbb_poll_options'] = array(
443 'COLUMNS' => array(
444 'poll_option_id' => array('TINT:4', 0),
445 'topic_id' => array('UINT', 0),
446 'poll_option_text' => array('TEXT_UNI', ''),
447 'poll_option_total' => array('UINT', 0),
448 ),
449 'KEYS' => array(
450 'poll_opt_id' => array('INDEX', 'poll_option_id'),
451 'topic_id' => array('INDEX', 'topic_id'),
452 ),
453 );
454
455 $schema_data['phpbb_poll_votes'] = array(
456 'COLUMNS' => array(
457 'topic_id' => array('UINT', 0),
458 'poll_option_id' => array('TINT:4', 0),
459 'vote_user_id' => array('UINT', 0),
460 'vote_user_ip' => array('VCHAR:40', ''),
461 ),
462 'KEYS' => array(
463 'topic_id' => array('INDEX', 'topic_id'),
464 'vote_user_id' => array('INDEX', 'vote_user_id'),
465 'vote_user_ip' => array('INDEX', 'vote_user_ip'),
466 ),
467 );
468
469 $schema_data['phpbb_posts'] = array(
470 'COLUMNS' => array(
471 'post_id' => array('UINT', NULL, 'auto_increment'),
472 'topic_id' => array('UINT', 0),
473 'forum_id' => array('UINT', 0),
474 'poster_id' => array('UINT', 0),
475 'icon_id' => array('UINT', 0),
476 'poster_ip' => array('VCHAR:40', ''),
477 'post_time' => array('TIMESTAMP', 0),
478 'post_approved' => array('BOOL', 1),
479 'post_reported' => array('BOOL', 0),
480 'enable_bbcode' => array('BOOL', 1),
481 'enable_smilies' => array('BOOL', 1),
482 'enable_magic_url' => array('BOOL', 1),
483 'enable_sig' => array('BOOL', 1),
484 'post_username' => array('VCHAR_UNI:255', ''),
485 'post_subject' => array('STEXT_UNI', '', 'true_sort'),
486 'post_text' => array('MTEXT_UNI', ''),
487 'post_checksum' => array('VCHAR:32', ''),
488 'post_attachment' => array('BOOL', 0),
489 'bbcode_bitfield' => array('VCHAR:255', ''),
490 'bbcode_uid' => array('VCHAR:8', ''),
491 'post_postcount' => array('BOOL', 1),
492 'post_edit_time' => array('TIMESTAMP', 0),
493 'post_edit_reason' => array('STEXT_UNI', ''),
494 'post_edit_user' => array('UINT', 0),
495 'post_edit_count' => array('USINT', 0),
496 'post_edit_locked' => array('BOOL', 0),
497 ),
498 'PRIMARY_KEY' => 'post_id',
499 'KEYS' => array(
500 'forum_id' => array('INDEX', 'forum_id'),
501 'topic_id' => array('INDEX', 'topic_id'),
502 'poster_ip' => array('INDEX', 'poster_ip'),
503 'poster_id' => array('INDEX', 'poster_id'),
504 'post_approved' => array('INDEX', 'post_approved'),
505 'tid_post_time' => array('INDEX', array('topic_id', 'post_time')),
506 ),
507 );
508
509 $schema_data['phpbb_privmsgs'] = array(
510 'COLUMNS' => array(
511 'msg_id' => array('UINT', NULL, 'auto_increment'),
512 'root_level' => array('UINT', 0),
513 'author_id' => array('UINT', 0),
514 'icon_id' => array('UINT', 0),
515 'author_ip' => array('VCHAR:40', ''),
516 'message_time' => array('TIMESTAMP', 0),
517 'enable_bbcode' => array('BOOL', 1),
518 'enable_smilies' => array('BOOL', 1),
519 'enable_magic_url' => array('BOOL', 1),
520 'enable_sig' => array('BOOL', 1),
521 'message_subject' => array('STEXT_UNI', ''),
522 'message_text' => array('MTEXT_UNI', ''),
523 'message_edit_reason' => array('STEXT_UNI', ''),
524 'message_edit_user' => array('UINT', 0),
525 'message_attachment' => array('BOOL', 0),
526 'bbcode_bitfield' => array('VCHAR:255', ''),
527 'bbcode_uid' => array('VCHAR:8', ''),
528 'message_edit_time' => array('TIMESTAMP', 0),
529 'message_edit_count' => array('USINT', 0),
530 'to_address' => array('TEXT_UNI', ''),
531 'bcc_address' => array('TEXT_UNI', ''),
532 ),
533 'PRIMARY_KEY' => 'msg_id',
534 'KEYS' => array(
535 'author_ip' => array('INDEX', 'author_ip'),
536 'message_time' => array('INDEX', 'message_time'),
537 'author_id' => array('INDEX', 'author_id'),
538 'root_level' => array('INDEX', 'root_level'),
539 ),
540 );
541
542 $schema_data['phpbb_privmsgs_folder'] = array(
543 'COLUMNS' => array(
544 'folder_id' => array('UINT', NULL, 'auto_increment'),
545 'user_id' => array('UINT', 0),
546 'folder_name' => array('VCHAR_UNI', ''),
547 'pm_count' => array('UINT', 0),
548 ),
549 'PRIMARY_KEY' => 'folder_id',
550 'KEYS' => array(
551 'user_id' => array('INDEX', 'user_id'),
552 ),
553 );
554
555 $schema_data['phpbb_privmsgs_rules'] = array(
556 'COLUMNS' => array(
557 'rule_id' => array('UINT', NULL, 'auto_increment'),
558 'user_id' => array('UINT', 0),
559 'rule_check' => array('UINT', 0),
560 'rule_connection' => array('UINT', 0),
561 'rule_string' => array('VCHAR_UNI', ''),
562 'rule_user_id' => array('UINT', 0),
563 'rule_group_id' => array('UINT', 0),
564 'rule_action' => array('UINT', 0),
565 'rule_folder_id' => array('INT:11', 0),
566 ),
567 'PRIMARY_KEY' => 'rule_id',
568 'KEYS' => array(
569 'user_id' => array('INDEX', 'user_id'),
570 ),
571 );
572
573 $schema_data['phpbb_privmsgs_to'] = array(
574 'COLUMNS' => array(
575 'msg_id' => array('UINT', 0),
576 'user_id' => array('UINT', 0),
577 'author_id' => array('UINT', 0),
578 'pm_deleted' => array('BOOL', 0),
579 'pm_new' => array('BOOL', 1),
580 'pm_unread' => array('BOOL', 1),
581 'pm_replied' => array('BOOL', 0),
582 'pm_marked' => array('BOOL', 0),
583 'pm_forwarded' => array('BOOL', 0),
584 'folder_id' => array('INT:11', 0),
585 ),
586 'KEYS' => array(
587 'msg_id' => array('INDEX', 'msg_id'),
588 'author_id' => array('INDEX', 'author_id'),
589 'usr_flder_id' => array('INDEX', array('user_id', 'folder_id')),
590 ),
591 );
592
593 $schema_data['phpbb_profile_fields'] = array(
594 'COLUMNS' => array(
595 'field_id' => array('UINT', NULL, 'auto_increment'),
596 'field_name' => array('VCHAR_UNI', ''),
597 'field_type' => array('TINT:4', 0),
598 'field_ident' => array('VCHAR:20', ''),
599 'field_length' => array('VCHAR:20', ''),
600 'field_minlen' => array('VCHAR', ''),
601 'field_maxlen' => array('VCHAR', ''),
602 'field_novalue' => array('VCHAR_UNI', ''),
603 'field_default_value' => array('VCHAR_UNI', ''),
604 'field_validation' => array('VCHAR_UNI:20', ''),
605 'field_required' => array('BOOL', 0),
606 'field_show_on_reg' => array('BOOL', 0),
607 'field_hide' => array('BOOL', 0),
608 'field_no_view' => array('BOOL', 0),
609 'field_active' => array('BOOL', 0),
610 'field_order' => array('UINT', 0),
611 ),
612 'PRIMARY_KEY' => 'field_id',
613 'KEYS' => array(
614 'fld_type' => array('INDEX', 'field_type'),
615 'fld_ordr' => array('INDEX', 'field_order'),
616 ),
617 );
618
619 $schema_data['phpbb_profile_fields_data'] = array(
620 'COLUMNS' => array(
621 'user_id' => array('UINT', 0),
622 ),
623 'PRIMARY_KEY' => 'user_id',
624 );
625
626 $schema_data['phpbb_profile_fields_lang'] = array(
627 'COLUMNS' => array(
628 'field_id' => array('UINT', 0),
629 'lang_id' => array('UINT', 0),
630 'option_id' => array('UINT', 0),
631 'field_type' => array('TINT:4', 0),
632 'lang_value' => array('VCHAR_UNI', ''),
633 ),
634 'PRIMARY_KEY' => array('field_id', 'lang_id', 'option_id'),
635 );
636
637 $schema_data['phpbb_profile_lang'] = array(
638 'COLUMNS' => array(
639 'field_id' => array('UINT', 0),
640 'lang_id' => array('UINT', 0),
641 'lang_name' => array('VCHAR_UNI', ''),
642 'lang_explain' => array('TEXT_UNI', ''),
643 'lang_default_value' => array('VCHAR_UNI', ''),
644 ),
645 'PRIMARY_KEY' => array('field_id', 'lang_id'),
646 );
647
648 $schema_data['phpbb_ranks'] = array(
649 'COLUMNS' => array(
650 'rank_id' => array('UINT', NULL, 'auto_increment'),
651 'rank_title' => array('VCHAR_UNI', ''),
652 'rank_min' => array('UINT', 0),
653 'rank_special' => array('BOOL', 0),
654 'rank_image' => array('VCHAR', ''),
655 ),
656 'PRIMARY_KEY' => 'rank_id',
657 );
658
659 $schema_data['phpbb_reports'] = array(
660 'COLUMNS' => array(
661 'report_id' => array('UINT', NULL, 'auto_increment'),
662 'reason_id' => array('USINT', 0),
663 'post_id' => array('UINT', 0),
664 'user_id' => array('UINT', 0),
665 'user_notify' => array('BOOL', 0),
666 'report_closed' => array('BOOL', 0),
667 'report_time' => array('TIMESTAMP', 0),
668 'report_text' => array('MTEXT_UNI', ''),
669 ),
670 'PRIMARY_KEY' => 'report_id',
671 );
672
673 $schema_data['phpbb_reports_reasons'] = array(
674 'COLUMNS' => array(
675 'reason_id' => array('USINT', NULL, 'auto_increment'),
676 'reason_title' => array('VCHAR_UNI', ''),
677 'reason_description' => array('MTEXT_UNI', ''),
678 'reason_order' => array('USINT', 0),
679 ),
680 'PRIMARY_KEY' => 'reason_id',
681 );
682
683 $schema_data['phpbb_search_results'] = array(
684 'COLUMNS' => array(
685 'search_key' => array('VCHAR:32', ''),
686 'search_time' => array('TIMESTAMP', 0),
687 'search_keywords' => array('MTEXT_UNI', ''),
688 'search_authors' => array('MTEXT', ''),
689 ),
690 'PRIMARY_KEY' => 'search_key',
691 );
692
693 $schema_data['phpbb_search_wordlist'] = array(
694 'COLUMNS' => array(
695 'word_id' => array('UINT', NULL, 'auto_increment'),
696 'word_text' => array('VCHAR_UNI', ''),
697 'word_common' => array('BOOL', 0),
698 'word_count' => array('UINT', 0),
699 ),
700 'PRIMARY_KEY' => 'word_id',
701 'KEYS' => array(
702 'wrd_txt' => array('UNIQUE', 'word_text'),
703 'wrd_cnt' => array('INDEX', 'word_count'),
704 ),
705 );
706
707 $schema_data['phpbb_search_wordmatch'] = array(
708 'COLUMNS' => array(
709 'post_id' => array('UINT', 0),
710 'word_id' => array('UINT', 0),
711 'title_match' => array('BOOL', 0),
712 ),
713 'KEYS' => array(
714 'unq_mtch' => array('UNIQUE', array('word_id', 'post_id', 'title_match')),
715 'word_id' => array('INDEX', 'word_id'),
716 'post_id' => array('INDEX', 'post_id'),
717 ),
718 );
719
720 $schema_data['phpbb_sessions'] = array(
721 'COLUMNS' => array(
722 'session_id' => array('CHAR:32', ''),
723 'session_user_id' => array('UINT', 0),
724 'session_forum_id' => array('UINT', 0),
725 'session_last_visit' => array('TIMESTAMP', 0),
726 'session_start' => array('TIMESTAMP', 0),
727 'session_time' => array('TIMESTAMP', 0),
728 'session_ip' => array('VCHAR:40', ''),
729 'session_browser' => array('VCHAR:150', ''),
730 'session_forwarded_for' => array('VCHAR:255', ''),
731 'session_page' => array('VCHAR_UNI', ''),
732 'session_viewonline' => array('BOOL', 1),
733 'session_autologin' => array('BOOL', 0),
734 'session_admin' => array('BOOL', 0),
735 ),
736 'PRIMARY_KEY' => 'session_id',
737 'KEYS' => array(
738 'session_time' => array('INDEX', 'session_time'),
739 'session_uid' => array('INDEX', 'session_user_id'),
740 'session_fid' => array('INDEX', 'session_forum_id'),
741 ),
742 );
743
744 $schema_data['phpbb_sessions_keys'] = array(
745 'COLUMNS' => array(
746 'key_id' => array('CHAR:32', ''),
747 'user_id' => array('UINT', 0),
748 'last_ip' => array('VCHAR:40', ''),
749 'last_login' => array('TIMESTAMP', 0),
750 ),
751 'PRIMARY_KEY' => array('key_id', 'user_id'),
752 'KEYS' => array(
753 'last_login' => array('INDEX', 'last_login'),
754 ),
755 );
756
757 $schema_data['phpbb_sitelist'] = array(
758 'COLUMNS' => array(
759 'site_id' => array('UINT', NULL, 'auto_increment'),
760 'site_ip' => array('VCHAR:40', ''),
761 'site_hostname' => array('VCHAR', ''),
762 'ip_exclude' => array('BOOL', 0),
763 ),
764 'PRIMARY_KEY' => 'site_id',
765 );
766
767 $schema_data['phpbb_smilies'] = array(
768 'COLUMNS' => array(
769 'smiley_id' => array('UINT', NULL, 'auto_increment'),
770 // We may want to set 'code' to VCHAR:50 or check if unicode support is possible... at the moment only ASCII characters are allowed.
771 'code' => array('VCHAR_UNI:50', ''),
772 'emotion' => array('VCHAR_UNI:50', ''),
773 'smiley_url' => array('VCHAR:50', ''),
774 'smiley_width' => array('USINT', 0),
775 'smiley_height' => array('USINT', 0),
776 'smiley_order' => array('UINT', 0),
777 'display_on_posting'=> array('BOOL', 1),
778 ),
779 'PRIMARY_KEY' => 'smiley_id',
780 'KEYS' => array(
781 'display_on_post' => array('INDEX', 'display_on_posting'),
782 ),
783 );
784
785 $schema_data['phpbb_styles'] = array(
786 'COLUMNS' => array(
787 'style_id' => array('UINT', NULL, 'auto_increment'),
788 'style_name' => array('VCHAR_UNI:255', ''),
789 'style_copyright' => array('VCHAR_UNI', ''),
790 'style_active' => array('BOOL', 1),
791 'template_id' => array('UINT', 0),
792 'theme_id' => array('UINT', 0),
793 'imageset_id' => array('UINT', 0),
794 ),
795 'PRIMARY_KEY' => 'style_id',
796 'KEYS' => array(
797 'style_name' => array('UNIQUE', 'style_name'),
798 'template_id' => array('INDEX', 'template_id'),
799 'theme_id' => array('INDEX', 'theme_id'),
800 'imageset_id' => array('INDEX', 'imageset_id'),
801 ),
802 );
803
804 $schema_data['phpbb_styles_template'] = array(
805 'COLUMNS' => array(
806 'template_id' => array('UINT', NULL, 'auto_increment'),
807 'template_name' => array('VCHAR_UNI:255', ''),
808 'template_copyright' => array('VCHAR_UNI', ''),
809 'template_path' => array('VCHAR:100', ''),
810 'bbcode_bitfield' => array('VCHAR:255', 'kNg='),
811 ),
812 'PRIMARY_KEY' => 'template_id',
813 'KEYS' => array(
814 'tmplte_nm' => array('UNIQUE', 'template_name'),
815 ),
816 );
817
818 $schema_data['phpbb_styles_theme'] = array(
819 'COLUMNS' => array(
820 'theme_id' => array('UINT', NULL, 'auto_increment'),
821 'theme_name' => array('VCHAR_UNI:255', ''),
822 'theme_copyright' => array('VCHAR_UNI', ''),
823 'theme_path' => array('VCHAR:100', ''),
824 'theme_storedb' => array('BOOL', 0),
825 'theme_mtime' => array('TIMESTAMP', 0),
826 'theme_data' => array('MTEXT_UNI', ''),
827 ),
828 'PRIMARY_KEY' => 'theme_id',
829 'KEYS' => array(
830 'theme_name' => array('UNIQUE', 'theme_name'),
831 ),
832 );
833
834 $schema_data['phpbb_styles_imageset'] = array(
835 'COLUMNS' => array(
836 'imageset_id' => array('UINT', NULL, 'auto_increment'),
837 'imageset_name' => array('VCHAR_UNI:255', ''),
838 'imageset_copyright' => array('VCHAR_UNI', ''),
839 'imageset_path' => array('VCHAR:100', ''),
840 ),
841 'PRIMARY_KEY' => 'imageset_id',
842 'KEYS' => array(
843 'imgset_nm' => array('UNIQUE', 'imageset_name'),
844 ),
845 );
846
847 $schema_data['phpbb_styles_imageset_data'] = array(
848 'COLUMNS' => array(
849 'image_id' => array('UINT', NULL, 'auto_increment'),
850 'image_name' => array('VCHAR:200', ''),
851 'image_filename' => array('VCHAR:200', ''),
852 'image_lang' => array('VCHAR:30', ''),
853 'image_height' => array('USINT', 0),
854 'image_width' => array('USINT', 0),
855 'imageset_id' => array('UINT', 0),
856 ),
857 'PRIMARY_KEY' => 'image_id',
858 'KEYS' => array(
859 'i_d' => array('INDEX', 'imageset_id'),
860 ),
861 );
862
863 $schema_data['phpbb_topics'] = array(
864 'COLUMNS' => array(
865 'topic_id' => array('UINT', NULL, 'auto_increment'),
866 'forum_id' => array('UINT', 0),
867 'icon_id' => array('UINT', 0),
868 'topic_attachment' => array('BOOL', 0),
869 'topic_approved' => array('BOOL', 1),
870 'topic_reported' => array('BOOL', 0),
871 'topic_title' => array('STEXT_UNI', '', 'true_sort'),
872 'topic_poster' => array('UINT', 0),
873 'topic_time' => array('TIMESTAMP', 0),
874 'topic_time_limit' => array('TIMESTAMP', 0),
875 'topic_views' => array('UINT', 0),
876 'topic_replies' => array('UINT', 0),
877 'topic_replies_real' => array('UINT', 0),
878 'topic_status' => array('TINT:3', 0),
879 'topic_type' => array('TINT:3', 0),
880 'topic_first_post_id' => array('UINT', 0),
881 'topic_first_poster_name' => array('VCHAR_UNI', ''),
882 'topic_first_poster_colour' => array('VCHAR:6', ''),
883 'topic_last_post_id' => array('UINT', 0),
884 'topic_last_poster_id' => array('UINT', 0),
885 'topic_last_poster_name' => array('VCHAR_UNI', ''),
886 'topic_last_poster_colour' => array('VCHAR:6', ''),
887 'topic_last_post_subject' => array('STEXT_UNI', ''),
888 'topic_last_post_time' => array('TIMESTAMP', 0),
889 'topic_last_view_time' => array('TIMESTAMP', 0),
890 'topic_moved_id' => array('UINT', 0),
891 'topic_bumped' => array('BOOL', 0),
892 'topic_bumper' => array('UINT', 0),
893 'poll_title' => array('STEXT_UNI', ''),
894 'poll_start' => array('TIMESTAMP', 0),
895 'poll_length' => array('TIMESTAMP', 0),
896 'poll_max_options' => array('TINT:4', 1),
897 'poll_last_vote' => array('TIMESTAMP', 0),
898 'poll_vote_change' => array('BOOL', 0),
899 ),
900 'PRIMARY_KEY' => 'topic_id',
901 'KEYS' => array(
902 'forum_id' => array('INDEX', 'forum_id'),
903 'forum_id_type' => array('INDEX', array('forum_id', 'topic_type')),
904 'last_post_time' => array('INDEX', 'topic_last_post_time'),
905 'topic_approved' => array('INDEX', 'topic_approved'),
906 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_approved', 'topic_last_post_id')),
907 'fid_time_moved' => array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),
908 ),
909 );
910
911 $schema_data['phpbb_topics_track'] = array(
912 'COLUMNS' => array(
913 'user_id' => array('UINT', 0),
914 'topic_id' => array('UINT', 0),
915 'forum_id' => array('UINT', 0),
916 'mark_time' => array('TIMESTAMP', 0),
917 ),
918 'PRIMARY_KEY' => array('user_id', 'topic_id'),
919 'KEYS' => array(
920 'forum_id' => array('INDEX', 'forum_id'),
921 ),
922 );
923
924 $schema_data['phpbb_topics_posted'] = array(
925 'COLUMNS' => array(
926 'user_id' => array('UINT', 0),
927 'topic_id' => array('UINT', 0),
928 'topic_posted' => array('BOOL', 0),
929 ),
930 'PRIMARY_KEY' => array('user_id', 'topic_id'),
931 );
932
933 $schema_data['phpbb_topics_watch'] = array(
934 'COLUMNS' => array(
935 'topic_id' => array('UINT', 0),
936 'user_id' => array('UINT', 0),
937 'notify_status' => array('BOOL', 0),
938 ),
939 'KEYS' => array(
940 'topic_id' => array('INDEX', 'topic_id'),
941 'user_id' => array('INDEX', 'user_id'),
942 'notify_stat' => array('INDEX', 'notify_status'),
943 ),
944 );
945
946 $schema_data['phpbb_user_group'] = array(
947 'COLUMNS' => array(
948 'group_id' => array('UINT', 0),
949 'user_id' => array('UINT', 0),
950 'group_leader' => array('BOOL', 0),
951 'user_pending' => array('BOOL', 1),
952 ),
953 'KEYS' => array(
954 'group_id' => array('INDEX', 'group_id'),
955 'user_id' => array('INDEX', 'user_id'),
956 'group_leader' => array('INDEX', 'group_leader'),
957 ),
958 );
959
960 $schema_data['phpbb_users'] = array(
961 'COLUMNS' => array(
962 'user_id' => array('UINT', NULL, 'auto_increment'),
963 'user_type' => array('TINT:2', 0),
964 'group_id' => array('UINT', 3),
965 'user_permissions' => array('MTEXT', ''),
966 'user_perm_from' => array('UINT', 0),
967 'user_ip' => array('VCHAR:40', ''),
968 'user_regdate' => array('TIMESTAMP', 0),
969 'username' => array('VCHAR_UNI', ''),
970 'username_clean' => array('VCHAR_UNI', ''),
971 'user_password' => array('VCHAR_UNI:40', ''),
972 'user_passchg' => array('TIMESTAMP', 0),
973 'user_pass_convert' => array('BOOL', 0),
974 'user_email' => array('VCHAR_UNI:100', ''),
975 'user_email_hash' => array('BINT', 0),
976 'user_birthday' => array('VCHAR:10', ''),
977 'user_lastvisit' => array('TIMESTAMP', 0),
978 'user_lastmark' => array('TIMESTAMP', 0),
979 'user_lastpost_time' => array('TIMESTAMP', 0),
980 'user_lastpage' => array('VCHAR_UNI:200', ''),
981 'user_last_confirm_key' => array('VCHAR:10', ''),
982 'user_last_search' => array('TIMESTAMP', 0),
983 'user_warnings' => array('TINT:4', 0),
984 'user_last_warning' => array('TIMESTAMP', 0),
985 'user_login_attempts' => array('TINT:4', 0),
986 'user_inactive_reason' => array('TINT:2', 0),
987 'user_inactive_time' => array('TIMESTAMP', 0),
988 'user_posts' => array('UINT', 0),
989 'user_lang' => array('VCHAR:30', ''),
990 'user_timezone' => array('DECIMAL', 0),
991 'user_dst' => array('BOOL', 0),
992 'user_dateformat' => array('VCHAR_UNI:30', 'd M Y H:i'),
993 'user_style' => array('UINT', 0),
994 'user_rank' => array('UINT', 0),
995 'user_colour' => array('VCHAR:6', ''),
996 'user_new_privmsg' => array('INT:4', 0),
997 'user_unread_privmsg' => array('INT:4', 0),
998 'user_last_privmsg' => array('TIMESTAMP', 0),
999 'user_message_rules' => array('BOOL', 0),
1000 'user_full_folder' => array('INT:11', -3),
1001 'user_emailtime' => array('TIMESTAMP', 0),
1002 'user_topic_show_days' => array('USINT', 0),
1003 'user_topic_sortby_type' => array('VCHAR:1', 't'),
1004 'user_topic_sortby_dir' => array('VCHAR:1', 'd'),
1005 'user_post_show_days' => array('USINT', 0),
1006 'user_post_sortby_type' => array('VCHAR:1', 't'),
1007 'user_post_sortby_dir' => array('VCHAR:1', 'a'),
1008 'user_notify' => array('BOOL', 0),
1009 'user_notify_pm' => array('BOOL', 1),
1010 'user_notify_type' => array('TINT:4', 0),
1011 'user_allow_pm' => array('BOOL', 1),
1012 'user_allow_viewonline' => array('BOOL', 1),
1013 'user_allow_viewemail' => array('BOOL', 1),
1014 'user_allow_massemail' => array('BOOL', 1),
1015 'user_options' => array('UINT:11', 895),
1016 'user_avatar' => array('VCHAR', ''),
1017 'user_avatar_type' => array('TINT:2', 0),
1018 'user_avatar_width' => array('USINT', 0),
1019 'user_avatar_height' => array('USINT', 0),
1020 'user_sig' => array('MTEXT_UNI', ''),
1021 'user_sig_bbcode_uid' => array('VCHAR:8', ''),
1022 'user_sig_bbcode_bitfield' => array('VCHAR:255', ''),
1023 'user_from' => array('VCHAR_UNI:100', ''),
1024 'user_icq' => array('VCHAR:15', ''),
1025 'user_aim' => array('VCHAR_UNI', ''),
1026 'user_yim' => array('VCHAR_UNI', ''),
1027 'user_msnm' => array('VCHAR_UNI', ''),
1028 'user_jabber' => array('VCHAR_UNI', ''),
1029 'user_website' => array('VCHAR_UNI:200', ''),
1030 'user_occ' => array('TEXT_UNI', ''),
1031 'user_interests' => array('TEXT_UNI', ''),
1032 'user_actkey' => array('VCHAR:32', ''),
1033 'user_newpasswd' => array('VCHAR_UNI:40', ''),
1034 'user_form_salt' => array('VCHAR_UNI:32', ''),
1035
1036 ),
1037 'PRIMARY_KEY' => 'user_id',
1038 'KEYS' => array(
1039 'user_birthday' => array('INDEX', 'user_birthday'),
1040 'user_email_hash' => array('INDEX', 'user_email_hash'),
1041 'user_type' => array('INDEX', 'user_type'),
1042 'username_clean' => array('UNIQUE', 'username_clean'),
1043 ),
1044 );
1045
1046 $schema_data['phpbb_warnings'] = array(
1047 'COLUMNS' => array(
1048 'warning_id' => array('UINT', NULL, 'auto_increment'),
1049 'user_id' => array('UINT', 0),
1050 'post_id' => array('UINT', 0),
1051 'log_id' => array('UINT', 0),
1052 'warning_time' => array('TIMESTAMP', 0),
1053 ),
1054 'PRIMARY_KEY' => 'warning_id',
1055 );
1056
1057 $schema_data['phpbb_words'] = array(
1058 'COLUMNS' => array(
1059 'word_id' => array('UINT', NULL, 'auto_increment'),
1060 'word' => array('VCHAR_UNI', ''),
1061 'replacement' => array('VCHAR_UNI', ''),
1062 ),
1063 'PRIMARY_KEY' => 'word_id',
1064 );
1065
1066 $schema_data['phpbb_zebra'] = array(
1067 'COLUMNS' => array(
1068 'user_id' => array('UINT', 0),
1069 'zebra_id' => array('UINT', 0),
1070 'friend' => array('BOOL', 0),
1071 'foe' => array('BOOL', 0),
1072 ),
1073 'PRIMARY_KEY' => array('user_id', 'zebra_id'),
1074 'KEYS' => array(
1075 'zebra_user' => array('INDEX', array('zebra_id', 'user_id')),
1076 ),
1077 );
1078
1079 ?>
phpbb is a php-based BBS (buletin board system)