5 # Table: 'phpbb_attachments'
6 CREATE TABLE phpbb_attachments (
7 attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
8 post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
9 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
10 in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
11 poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
12 is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
13 physical_filename varbinary(255) DEFAULT '' NOT NULL,
14 real_filename varbinary(255) DEFAULT '' NOT NULL,
15 download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
16 attach_comment blob NOT NULL,
17 extension varbinary(100) DEFAULT '' NOT NULL,
18 mimetype varbinary(100) DEFAULT '' NOT NULL,
19 filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
20 filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
21 thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
22 PRIMARY KEY (attach_id),
23 KEY filetime (filetime),
24 KEY post_msg_id (post_msg_id),
25 KEY topic_id (topic_id),
26 KEY poster_id (poster_id),
27 KEY is_orphan (is_orphan)
31 # Table: 'phpbb_acl_groups'
32 CREATE TABLE phpbb_acl_groups (
33 group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
34 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
35 auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
36 auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
37 auth_setting tinyint(2) DEFAULT '0' NOT NULL,
38 KEY group_id (group_id),
39 KEY auth_opt_id (auth_option_id),
40 KEY auth_role_id (auth_role_id)
44 # Table: 'phpbb_acl_options'
45 CREATE TABLE phpbb_acl_options (
46 auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
47 auth_option varbinary(50) DEFAULT '' NOT NULL,
48 is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
49 is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
50 founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
51 PRIMARY KEY (auth_option_id),
52 KEY auth_option (auth_option)
56 # Table: 'phpbb_acl_roles'
57 CREATE TABLE phpbb_acl_roles (
58 role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
59 role_name blob NOT NULL,
60 role_description blob NOT NULL,
61 role_type varbinary(10) DEFAULT '' NOT NULL,
62 role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
63 PRIMARY KEY (role_id),
64 KEY role_type (role_type),
65 KEY role_order (role_order)
69 # Table: 'phpbb_acl_roles_data'
70 CREATE TABLE phpbb_acl_roles_data (
71 role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
72 auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
73 auth_setting tinyint(2) DEFAULT '0' NOT NULL,
74 PRIMARY KEY (role_id, auth_option_id),
75 KEY ath_op_id (auth_option_id)
79 # Table: 'phpbb_acl_users'
80 CREATE TABLE phpbb_acl_users (
81 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
82 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
83 auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
84 auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
85 auth_setting tinyint(2) DEFAULT '0' NOT NULL,
86 KEY user_id (user_id),
87 KEY auth_option_id (auth_option_id),
88 KEY auth_role_id (auth_role_id)
92 # Table: 'phpbb_banlist'
93 CREATE TABLE phpbb_banlist (
94 ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
95 ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
96 ban_ip varbinary(40) DEFAULT '' NOT NULL,
97 ban_email blob NOT NULL,
98 ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
99 ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,
100 ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
101 ban_reason blob NOT NULL,
102 ban_give_reason blob NOT NULL,
103 PRIMARY KEY (ban_id),
104 KEY ban_end (ban_end),
105 KEY ban_user (ban_userid, ban_exclude),
106 KEY ban_email (ban_email(255), ban_exclude),
107 KEY ban_ip (ban_ip, ban_exclude)
111 # Table: 'phpbb_bbcodes'
112 CREATE TABLE phpbb_bbcodes (
113 bbcode_id tinyint(3) DEFAULT '0' NOT NULL,
114 bbcode_tag varbinary(16) DEFAULT '' NOT NULL,
115 bbcode_helpline blob NOT NULL,
116 display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
117 bbcode_match blob NOT NULL,
118 bbcode_tpl mediumblob NOT NULL,
119 first_pass_match mediumblob NOT NULL,
120 first_pass_replace mediumblob NOT NULL,
121 second_pass_match mediumblob NOT NULL,
122 second_pass_replace mediumblob NOT NULL,
123 PRIMARY KEY (bbcode_id),
124 KEY display_on_post (display_on_posting)
128 # Table: 'phpbb_bookmarks'
129 CREATE TABLE phpbb_bookmarks (
130 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
131 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
132 PRIMARY KEY (topic_id, user_id)
136 # Table: 'phpbb_bots'
137 CREATE TABLE phpbb_bots (
138 bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,
139 bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
140 bot_name blob NOT NULL,
141 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
142 bot_agent varbinary(255) DEFAULT '' NOT NULL,
143 bot_ip varbinary(255) DEFAULT '' NOT NULL,
144 PRIMARY KEY (bot_id),
145 KEY bot_active (bot_active)
149 # Table: 'phpbb_config'
150 CREATE TABLE phpbb_config (
151 config_name varbinary(255) DEFAULT '' NOT NULL,
152 config_value blob NOT NULL,
153 is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
154 PRIMARY KEY (config_name),
155 KEY is_dynamic (is_dynamic)
159 # Table: 'phpbb_confirm'
160 CREATE TABLE phpbb_confirm (
161 confirm_id binary(32) DEFAULT '' NOT NULL,
162 session_id binary(32) DEFAULT '' NOT NULL,
163 confirm_type tinyint(3) DEFAULT '0' NOT NULL,
164 code varbinary(8) DEFAULT '' NOT NULL,
165 seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
166 PRIMARY KEY (session_id, confirm_id),
167 KEY confirm_type (confirm_type)
171 # Table: 'phpbb_disallow'
172 CREATE TABLE phpbb_disallow (
173 disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
174 disallow_username blob NOT NULL,
175 PRIMARY KEY (disallow_id)
179 # Table: 'phpbb_drafts'
180 CREATE TABLE phpbb_drafts (
181 draft_id mediumint(8) UNSIGNED NOT NULL auto_increment,
182 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
183 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
184 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
185 save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
186 draft_subject blob NOT NULL,
187 draft_message mediumblob NOT NULL,
188 PRIMARY KEY (draft_id),
189 KEY save_time (save_time)
193 # Table: 'phpbb_extensions'
194 CREATE TABLE phpbb_extensions (
195 extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
196 group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
197 extension varbinary(100) DEFAULT '' NOT NULL,
198 PRIMARY KEY (extension_id)
202 # Table: 'phpbb_extension_groups'
203 CREATE TABLE phpbb_extension_groups (
204 group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
205 group_name blob NOT NULL,
206 cat_id tinyint(2) DEFAULT '0' NOT NULL,
207 allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
208 download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
209 upload_icon varbinary(255) DEFAULT '' NOT NULL,
210 max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
211 allowed_forums blob NOT NULL,
212 allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
213 PRIMARY KEY (group_id)
217 # Table: 'phpbb_forums'
218 CREATE TABLE phpbb_forums (
219 forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
220 parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
221 left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
222 right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
223 forum_parents mediumblob NOT NULL,
224 forum_name blob NOT NULL,
225 forum_desc blob NOT NULL,
226 forum_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
227 forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
228 forum_desc_uid varbinary(5) DEFAULT '' NOT NULL,
229 forum_link blob NOT NULL,
230 forum_password varbinary(120) DEFAULT '' NOT NULL,
231 forum_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
232 forum_image varbinary(255) DEFAULT '' NOT NULL,
233 forum_rules blob NOT NULL,
234 forum_rules_link blob NOT NULL,
235 forum_rules_bitfield varbinary(255) DEFAULT '' NOT NULL,
236 forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
237 forum_rules_uid varbinary(5) DEFAULT '' NOT NULL,
238 forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
239 forum_type tinyint(4) DEFAULT '0' NOT NULL,
240 forum_status tinyint(4) DEFAULT '0' NOT NULL,
241 forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
242 forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
243 forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
244 forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
245 forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
246 forum_last_post_subject blob NOT NULL,
247 forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
248 forum_last_poster_name blob NOT NULL,
249 forum_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,
250 forum_flags tinyint(4) DEFAULT '32' NOT NULL,
251 display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
252 enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
253 enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
254 enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
255 prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,
256 prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
257 prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
258 prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
259 PRIMARY KEY (forum_id),
260 KEY left_right_id (left_id, right_id),
261 KEY forum_lastpost_id (forum_last_post_id)
265 # Table: 'phpbb_forums_access'
266 CREATE TABLE phpbb_forums_access (
267 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
268 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
269 session_id binary(32) DEFAULT '' NOT NULL,
270 PRIMARY KEY (forum_id, user_id, session_id)
274 # Table: 'phpbb_forums_track'
275 CREATE TABLE phpbb_forums_track (
276 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
277 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
278 mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
279 PRIMARY KEY (user_id, forum_id)
283 # Table: 'phpbb_forums_watch'
284 CREATE TABLE phpbb_forums_watch (
285 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
286 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
287 notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
288 KEY forum_id (forum_id),
289 KEY user_id (user_id),
290 KEY notify_stat (notify_status)
294 # Table: 'phpbb_groups'
295 CREATE TABLE phpbb_groups (
296 group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
297 group_type tinyint(4) DEFAULT '1' NOT NULL,
298 group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
299 group_name blob NOT NULL,
300 group_desc blob NOT NULL,
301 group_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
302 group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
303 group_desc_uid varbinary(5) DEFAULT '' NOT NULL,
304 group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
305 group_avatar varbinary(255) DEFAULT '' NOT NULL,
306 group_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
307 group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
308 group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
309 group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
310 group_colour varbinary(6) DEFAULT '' NOT NULL,
311 group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
312 group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
313 group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
314 group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
315 PRIMARY KEY (group_id),
316 KEY group_legend (group_legend)
320 # Table: 'phpbb_icons'
321 CREATE TABLE phpbb_icons (
322 icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
323 icons_url varbinary(255) DEFAULT '' NOT NULL,
324 icons_width tinyint(4) DEFAULT '0' NOT NULL,
325 icons_height tinyint(4) DEFAULT '0' NOT NULL,
326 icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
327 display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
328 PRIMARY KEY (icons_id),
329 KEY display_on_posting (display_on_posting)
333 # Table: 'phpbb_lang'
334 CREATE TABLE phpbb_lang (
335 lang_id tinyint(4) NOT NULL auto_increment,
336 lang_iso varbinary(30) DEFAULT '' NOT NULL,
337 lang_dir varbinary(30) DEFAULT '' NOT NULL,
338 lang_english_name blob NOT NULL,
339 lang_local_name blob NOT NULL,
340 lang_author blob NOT NULL,
341 PRIMARY KEY (lang_id),
342 KEY lang_iso (lang_iso)
347 CREATE TABLE phpbb_log (
348 log_id mediumint(8) UNSIGNED NOT NULL auto_increment,
349 log_type tinyint(4) DEFAULT '0' NOT NULL,
350 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
351 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
352 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
353 reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
354 log_ip varbinary(40) DEFAULT '' NOT NULL,
355 log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
356 log_operation blob NOT NULL,
357 log_data mediumblob NOT NULL,
358 PRIMARY KEY (log_id),
359 KEY log_type (log_type),
360 KEY forum_id (forum_id),
361 KEY topic_id (topic_id),
362 KEY reportee_id (reportee_id),
363 KEY user_id (user_id)
367 # Table: 'phpbb_moderator_cache'
368 CREATE TABLE phpbb_moderator_cache (
369 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
370 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
371 username blob NOT NULL,
372 group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
373 group_name blob NOT NULL,
374 display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
375 KEY disp_idx (display_on_index),
376 KEY forum_id (forum_id)
380 # Table: 'phpbb_modules'
381 CREATE TABLE phpbb_modules (
382 module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
383 module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
384 module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
385 module_basename varbinary(255) DEFAULT '' NOT NULL,
386 module_class varbinary(10) DEFAULT '' NOT NULL,
387 parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
388 left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
389 right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
390 module_langname varbinary(255) DEFAULT '' NOT NULL,
391 module_mode varbinary(255) DEFAULT '' NOT NULL,
392 module_auth varbinary(255) DEFAULT '' NOT NULL,
393 PRIMARY KEY (module_id),
394 KEY left_right_id (left_id, right_id),
395 KEY module_enabled (module_enabled),
396 KEY class_left_id (module_class, left_id)
400 # Table: 'phpbb_poll_options'
401 CREATE TABLE phpbb_poll_options (
402 poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
403 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
404 poll_option_text blob NOT NULL,
405 poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
406 KEY poll_opt_id (poll_option_id),
407 KEY topic_id (topic_id)
411 # Table: 'phpbb_poll_votes'
412 CREATE TABLE phpbb_poll_votes (
413 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
414 poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
415 vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
416 vote_user_ip varbinary(40) DEFAULT '' NOT NULL,
417 KEY topic_id (topic_id),
418 KEY vote_user_id (vote_user_id),
419 KEY vote_user_ip (vote_user_ip)
423 # Table: 'phpbb_posts'
424 CREATE TABLE phpbb_posts (
425 post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
426 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
427 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
428 poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
429 icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
430 poster_ip varbinary(40) DEFAULT '' NOT NULL,
431 post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
432 post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
433 post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
434 enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
435 enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
436 enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
437 enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
438 post_username blob NOT NULL,
439 post_subject blob NOT NULL,
440 post_text mediumblob NOT NULL,
441 post_checksum varbinary(32) DEFAULT '' NOT NULL,
442 post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
443 bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
444 bbcode_uid varbinary(8) DEFAULT '' NOT NULL,
445 post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
446 post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
447 post_edit_reason blob NOT NULL,
448 post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
449 post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
450 post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
451 PRIMARY KEY (post_id),
452 KEY forum_id (forum_id),
453 KEY topic_id (topic_id),
454 KEY poster_ip (poster_ip),
455 KEY poster_id (poster_id),
456 KEY post_approved (post_approved),
457 KEY tid_post_time (topic_id, post_time)
461 # Table: 'phpbb_privmsgs'
462 CREATE TABLE phpbb_privmsgs (
463 msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
464 root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
465 author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
466 icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
467 author_ip varbinary(40) DEFAULT '' NOT NULL,
468 message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
469 enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
470 enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
471 enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
472 enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
473 message_subject blob NOT NULL,
474 message_text mediumblob NOT NULL,
475 message_edit_reason blob NOT NULL,
476 message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
477 message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
478 bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
479 bbcode_uid varbinary(8) DEFAULT '' NOT NULL,
480 message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
481 message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
482 to_address blob NOT NULL,
483 bcc_address blob NOT NULL,
484 PRIMARY KEY (msg_id),
485 KEY author_ip (author_ip),
486 KEY message_time (message_time),
487 KEY author_id (author_id),
488 KEY root_level (root_level)
492 # Table: 'phpbb_privmsgs_folder'
493 CREATE TABLE phpbb_privmsgs_folder (
494 folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
495 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
496 folder_name blob NOT NULL,
497 pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
498 PRIMARY KEY (folder_id),
499 KEY user_id (user_id)
503 # Table: 'phpbb_privmsgs_rules'
504 CREATE TABLE phpbb_privmsgs_rules (
505 rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,
506 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
507 rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
508 rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
509 rule_string blob NOT NULL,
510 rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
511 rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
512 rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
513 rule_folder_id int(11) DEFAULT '0' NOT NULL,
514 PRIMARY KEY (rule_id),
515 KEY user_id (user_id)
519 # Table: 'phpbb_privmsgs_to'
520 CREATE TABLE phpbb_privmsgs_to (
521 msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
522 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
523 author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
524 pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
525 pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
526 pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
527 pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
528 pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
529 pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
530 folder_id int(11) DEFAULT '0' NOT NULL,
532 KEY author_id (author_id),
533 KEY usr_flder_id (user_id, folder_id)
537 # Table: 'phpbb_profile_fields'
538 CREATE TABLE phpbb_profile_fields (
539 field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
540 field_name blob NOT NULL,
541 field_type tinyint(4) DEFAULT '0' NOT NULL,
542 field_ident varbinary(20) DEFAULT '' NOT NULL,
543 field_length varbinary(20) DEFAULT '' NOT NULL,
544 field_minlen varbinary(255) DEFAULT '' NOT NULL,
545 field_maxlen varbinary(255) DEFAULT '' NOT NULL,
546 field_novalue blob NOT NULL,
547 field_default_value blob NOT NULL,
548 field_validation varbinary(60) DEFAULT '' NOT NULL,
549 field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
550 field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
551 field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
552 field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
553 field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
554 field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
555 PRIMARY KEY (field_id),
556 KEY fld_type (field_type),
557 KEY fld_ordr (field_order)
561 # Table: 'phpbb_profile_fields_data'
562 CREATE TABLE phpbb_profile_fields_data (
563 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
564 PRIMARY KEY (user_id)
568 # Table: 'phpbb_profile_fields_lang'
569 CREATE TABLE phpbb_profile_fields_lang (
570 field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
571 lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
572 option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
573 field_type tinyint(4) DEFAULT '0' NOT NULL,
574 lang_value blob NOT NULL,
575 PRIMARY KEY (field_id, lang_id, option_id)
579 # Table: 'phpbb_profile_lang'
580 CREATE TABLE phpbb_profile_lang (
581 field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
582 lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
583 lang_name blob NOT NULL,
584 lang_explain blob NOT NULL,
585 lang_default_value blob NOT NULL,
586 PRIMARY KEY (field_id, lang_id)
590 # Table: 'phpbb_ranks'
591 CREATE TABLE phpbb_ranks (
592 rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
593 rank_title blob NOT NULL,
594 rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
595 rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
596 rank_image varbinary(255) DEFAULT '' NOT NULL,
597 PRIMARY KEY (rank_id)
601 # Table: 'phpbb_reports'
602 CREATE TABLE phpbb_reports (
603 report_id mediumint(8) UNSIGNED NOT NULL auto_increment,
604 reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
605 post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
606 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
607 user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
608 report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
609 report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
610 report_text mediumblob NOT NULL,
611 PRIMARY KEY (report_id)
615 # Table: 'phpbb_reports_reasons'
616 CREATE TABLE phpbb_reports_reasons (
617 reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
618 reason_title blob NOT NULL,
619 reason_description mediumblob NOT NULL,
620 reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
621 PRIMARY KEY (reason_id)
625 # Table: 'phpbb_search_results'
626 CREATE TABLE phpbb_search_results (
627 search_key varbinary(32) DEFAULT '' NOT NULL,
628 search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
629 search_keywords mediumblob NOT NULL,
630 search_authors mediumblob NOT NULL,
631 PRIMARY KEY (search_key)
635 # Table: 'phpbb_search_wordlist'
636 CREATE TABLE phpbb_search_wordlist (
637 word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
638 word_text blob NOT NULL,
639 word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
640 word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
641 PRIMARY KEY (word_id),
642 UNIQUE wrd_txt (word_text(255)),
643 KEY wrd_cnt (word_count)
647 # Table: 'phpbb_search_wordmatch'
648 CREATE TABLE phpbb_search_wordmatch (
649 post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
650 word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
651 title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
652 UNIQUE unq_mtch (word_id, post_id, title_match),
653 KEY word_id (word_id),
654 KEY post_id (post_id)
658 # Table: 'phpbb_sessions'
659 CREATE TABLE phpbb_sessions (
660 session_id binary(32) DEFAULT '' NOT NULL,
661 session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
662 session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
663 session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
664 session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
665 session_ip varbinary(40) DEFAULT '' NOT NULL,
666 session_browser varbinary(150) DEFAULT '' NOT NULL,
667 session_forwarded_for varbinary(255) DEFAULT '' NOT NULL,
668 session_page blob NOT NULL,
669 session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
670 session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
671 session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
672 PRIMARY KEY (session_id),
673 KEY session_time (session_time),
674 KEY session_user_id (session_user_id)
678 # Table: 'phpbb_sessions_keys'
679 CREATE TABLE phpbb_sessions_keys (
680 key_id binary(32) DEFAULT '' NOT NULL,
681 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
682 last_ip varbinary(40) DEFAULT '' NOT NULL,
683 last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,
684 PRIMARY KEY (key_id, user_id),
685 KEY last_login (last_login)
689 # Table: 'phpbb_sitelist'
690 CREATE TABLE phpbb_sitelist (
691 site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
692 site_ip varbinary(40) DEFAULT '' NOT NULL,
693 site_hostname varbinary(255) DEFAULT '' NOT NULL,
694 ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
695 PRIMARY KEY (site_id)
699 # Table: 'phpbb_smilies'
700 CREATE TABLE phpbb_smilies (
701 smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
702 code varbinary(150) DEFAULT '' NOT NULL,
703 emotion varbinary(150) DEFAULT '' NOT NULL,
704 smiley_url varbinary(50) DEFAULT '' NOT NULL,
705 smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
706 smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
707 smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
708 display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
709 PRIMARY KEY (smiley_id),
710 KEY display_on_post (display_on_posting)
714 # Table: 'phpbb_styles'
715 CREATE TABLE phpbb_styles (
716 style_id smallint(4) UNSIGNED NOT NULL auto_increment,
717 style_name blob NOT NULL,
718 style_copyright blob NOT NULL,
719 style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
720 template_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
721 theme_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
722 imageset_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
723 PRIMARY KEY (style_id),
724 UNIQUE style_name (style_name(255)),
725 KEY template_id (template_id),
726 KEY theme_id (theme_id),
727 KEY imageset_id (imageset_id)
731 # Table: 'phpbb_styles_template'
732 CREATE TABLE phpbb_styles_template (
733 template_id smallint(4) UNSIGNED NOT NULL auto_increment,
734 template_name blob NOT NULL,
735 template_copyright blob NOT NULL,
736 template_path varbinary(100) DEFAULT '' NOT NULL,
737 bbcode_bitfield varbinary(255) DEFAULT 'kNg=' NOT NULL,
738 template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
739 PRIMARY KEY (template_id),
740 UNIQUE tmplte_nm (template_name(255))
744 # Table: 'phpbb_styles_template_data'
745 CREATE TABLE phpbb_styles_template_data (
746 template_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
747 template_filename varbinary(100) DEFAULT '' NOT NULL,
748 template_included blob NOT NULL,
749 template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
750 template_data mediumblob NOT NULL,
751 KEY tid (template_id),
752 KEY tfn (template_filename)
756 # Table: 'phpbb_styles_theme'
757 CREATE TABLE phpbb_styles_theme (
758 theme_id smallint(4) UNSIGNED NOT NULL auto_increment,
759 theme_name blob NOT NULL,
760 theme_copyright blob NOT NULL,
761 theme_path varbinary(100) DEFAULT '' NOT NULL,
762 theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
763 theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
764 theme_data mediumblob NOT NULL,
765 PRIMARY KEY (theme_id),
766 UNIQUE theme_name (theme_name(255))
770 # Table: 'phpbb_styles_imageset'
771 CREATE TABLE phpbb_styles_imageset (
772 imageset_id smallint(4) UNSIGNED NOT NULL auto_increment,
773 imageset_name blob NOT NULL,
774 imageset_copyright blob NOT NULL,
775 imageset_path varbinary(100) DEFAULT '' NOT NULL,
776 PRIMARY KEY (imageset_id),
777 UNIQUE imgset_nm (imageset_name(255))
781 # Table: 'phpbb_styles_imageset_data'
782 CREATE TABLE phpbb_styles_imageset_data (
783 image_id smallint(4) UNSIGNED NOT NULL auto_increment,
784 image_name varbinary(200) DEFAULT '' NOT NULL,
785 image_filename varbinary(200) DEFAULT '' NOT NULL,
786 image_lang varbinary(30) DEFAULT '' NOT NULL,
787 image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
788 image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
789 imageset_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
790 PRIMARY KEY (image_id),
791 KEY i_d (imageset_id)
795 # Table: 'phpbb_topics'
796 CREATE TABLE phpbb_topics (
797 topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
798 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
799 icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
800 topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
801 topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
802 topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
803 topic_title blob NOT NULL,
804 topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
805 topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
806 topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
807 topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
808 topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
809 topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
810 topic_status tinyint(3) DEFAULT '0' NOT NULL,
811 topic_type tinyint(3) DEFAULT '0' NOT NULL,
812 topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
813 topic_first_poster_name blob NOT NULL,
814 topic_first_poster_colour varbinary(6) DEFAULT '' NOT NULL,
815 topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
816 topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
817 topic_last_poster_name blob NOT NULL,
818 topic_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,
819 topic_last_post_subject blob NOT NULL,
820 topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
821 topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
822 topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
823 topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
824 topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
825 poll_title blob NOT NULL,
826 poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
827 poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
828 poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
829 poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,
830 poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
831 PRIMARY KEY (topic_id),
832 KEY forum_id (forum_id),
833 KEY forum_id_type (forum_id, topic_type),
834 KEY last_post_time (topic_last_post_time),
835 KEY topic_approved (topic_approved),
836 KEY forum_appr_last (forum_id, topic_approved, topic_last_post_id),
837 KEY fid_time_moved (forum_id, topic_last_post_time, topic_moved_id)
841 # Table: 'phpbb_topics_track'
842 CREATE TABLE phpbb_topics_track (
843 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
844 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
845 forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
846 mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
847 PRIMARY KEY (user_id, topic_id),
848 KEY forum_id (forum_id)
852 # Table: 'phpbb_topics_posted'
853 CREATE TABLE phpbb_topics_posted (
854 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
855 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
856 topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
857 PRIMARY KEY (user_id, topic_id)
861 # Table: 'phpbb_topics_watch'
862 CREATE TABLE phpbb_topics_watch (
863 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
864 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
865 notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
866 KEY topic_id (topic_id),
867 KEY user_id (user_id),
868 KEY notify_stat (notify_status)
872 # Table: 'phpbb_user_group'
873 CREATE TABLE phpbb_user_group (
874 group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
875 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
876 group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
877 user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
878 KEY group_id (group_id),
879 KEY user_id (user_id),
880 KEY group_leader (group_leader)
884 # Table: 'phpbb_users'
885 CREATE TABLE phpbb_users (
886 user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
887 user_type tinyint(2) DEFAULT '0' NOT NULL,
888 group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
889 user_permissions mediumblob NOT NULL,
890 user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
891 user_ip varbinary(40) DEFAULT '' NOT NULL,
892 user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
893 username blob NOT NULL,
894 username_clean blob NOT NULL,
895 user_password varbinary(120) DEFAULT '' NOT NULL,
896 user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
897 user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
898 user_email blob NOT NULL,
899 user_email_hash bigint(20) DEFAULT '0' NOT NULL,
900 user_birthday varbinary(10) DEFAULT '' NOT NULL,
901 user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
902 user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
903 user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
904 user_lastpage blob NOT NULL,
905 user_last_confirm_key varbinary(10) DEFAULT '' NOT NULL,
906 user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
907 user_warnings tinyint(4) DEFAULT '0' NOT NULL,
908 user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
909 user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
910 user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
911 user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
912 user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
913 user_lang varbinary(30) DEFAULT '' NOT NULL,
914 user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
915 user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
916 user_dateformat varbinary(90) DEFAULT 'd M Y H:i' NOT NULL,
917 user_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
918 user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
919 user_colour varbinary(6) DEFAULT '' NOT NULL,
920 user_new_privmsg tinyint(4) DEFAULT '0' NOT NULL,
921 user_unread_privmsg tinyint(4) DEFAULT '0' NOT NULL,
922 user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
923 user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
924 user_full_folder int(11) DEFAULT '-3' NOT NULL,
925 user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
926 user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
927 user_topic_sortby_type varbinary(1) DEFAULT 't' NOT NULL,
928 user_topic_sortby_dir varbinary(1) DEFAULT 'd' NOT NULL,
929 user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
930 user_post_sortby_type varbinary(1) DEFAULT 't' NOT NULL,
931 user_post_sortby_dir varbinary(1) DEFAULT 'a' NOT NULL,
932 user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
933 user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
934 user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
935 user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
936 user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
937 user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
938 user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
939 user_options int(11) UNSIGNED DEFAULT '895' NOT NULL,
940 user_avatar varbinary(255) DEFAULT '' NOT NULL,
941 user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
942 user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
943 user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
944 user_sig mediumblob NOT NULL,
945 user_sig_bbcode_uid varbinary(8) DEFAULT '' NOT NULL,
946 user_sig_bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
947 user_from blob NOT NULL,
948 user_icq varbinary(15) DEFAULT '' NOT NULL,
949 user_aim blob NOT NULL,
950 user_yim blob NOT NULL,
951 user_msnm blob NOT NULL,
952 user_jabber blob NOT NULL,
953 user_website blob NOT NULL,
954 user_occ blob NOT NULL,
955 user_interests blob NOT NULL,
956 user_actkey varbinary(32) DEFAULT '' NOT NULL,
957 user_newpasswd varbinary(96) DEFAULT '' NOT NULL,
958 user_form_salt varbinary(96) DEFAULT '' NOT NULL,
959 PRIMARY KEY (user_id),
960 KEY user_birthday (user_birthday),
961 KEY user_email_hash (user_email_hash),
962 KEY user_type (user_type),
963 UNIQUE username_clean (username_clean(255))
967 # Table: 'phpbb_warnings'
968 CREATE TABLE phpbb_warnings (
969 warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
970 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
971 post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
972 log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
973 warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
974 PRIMARY KEY (warning_id)
978 # Table: 'phpbb_words'
979 CREATE TABLE phpbb_words (
980 word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
982 replacement blob NOT NULL,
983 PRIMARY KEY (word_id)
987 # Table: 'phpbb_zebra'
988 CREATE TABLE phpbb_zebra (
989 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
990 zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
991 friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
992 foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
993 PRIMARY KEY (user_id, zebra_id)