7 # Table: 'phpbb_attachments'
8 CREATE TABLE phpbb_attachments (
9 attach_id INTEGER PRIMARY KEY NOT NULL ,
10 post_msg_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
11 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
12 in_message INTEGER UNSIGNED NOT NULL DEFAULT '0',
13 poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
14 is_orphan INTEGER UNSIGNED NOT NULL DEFAULT '1',
15 physical_filename varchar(255) NOT NULL DEFAULT '',
16 real_filename varchar(255) NOT NULL DEFAULT '',
17 download_count INTEGER UNSIGNED NOT NULL DEFAULT '0',
18 attach_comment text(65535) NOT NULL DEFAULT '',
19 extension varchar(100) NOT NULL DEFAULT '',
20 mimetype varchar(100) NOT NULL DEFAULT '',
21 filesize INTEGER UNSIGNED NOT NULL DEFAULT '0',
22 filetime INTEGER UNSIGNED NOT NULL DEFAULT '0',
23 thumbnail INTEGER UNSIGNED NOT NULL DEFAULT '0'
26 CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments (filetime);
27 CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments (post_msg_id);
28 CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments (topic_id);
29 CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments (poster_id);
30 CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments (is_orphan);
32 # Table: 'phpbb_acl_groups'
33 CREATE TABLE phpbb_acl_groups (
34 group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
35 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
36 auth_option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
37 auth_role_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
38 auth_setting tinyint(2) NOT NULL DEFAULT '0'
41 CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups (group_id);
42 CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups (auth_option_id);
43 CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups (auth_role_id);
45 # Table: 'phpbb_acl_options'
46 CREATE TABLE phpbb_acl_options (
47 auth_option_id INTEGER PRIMARY KEY NOT NULL ,
48 auth_option varchar(50) NOT NULL DEFAULT '',
49 is_global INTEGER UNSIGNED NOT NULL DEFAULT '0',
50 is_local INTEGER UNSIGNED NOT NULL DEFAULT '0',
51 founder_only INTEGER UNSIGNED NOT NULL DEFAULT '0'
54 CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options (auth_option);
56 # Table: 'phpbb_acl_roles'
57 CREATE TABLE phpbb_acl_roles (
58 role_id INTEGER PRIMARY KEY NOT NULL ,
59 role_name varchar(255) NOT NULL DEFAULT '',
60 role_description text(65535) NOT NULL DEFAULT '',
61 role_type varchar(10) NOT NULL DEFAULT '',
62 role_order INTEGER UNSIGNED NOT NULL DEFAULT '0'
65 CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles (role_type);
66 CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles (role_order);
68 # Table: 'phpbb_acl_roles_data'
69 CREATE TABLE phpbb_acl_roles_data (
70 role_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
71 auth_option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
72 auth_setting tinyint(2) NOT NULL DEFAULT '0',
73 PRIMARY KEY (role_id, auth_option_id)
76 CREATE INDEX phpbb_acl_roles_data_ath_opt_id ON phpbb_acl_roles_data (auth_option_id);
78 # Table: 'phpbb_acl_users'
79 CREATE TABLE phpbb_acl_users (
80 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
81 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
82 auth_option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
83 auth_role_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
84 auth_setting tinyint(2) NOT NULL DEFAULT '0'
87 CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id);
88 CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id);
89 CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id);
91 # Table: 'phpbb_banlist'
92 CREATE TABLE phpbb_banlist (
93 ban_id INTEGER PRIMARY KEY NOT NULL ,
94 ban_userid INTEGER UNSIGNED NOT NULL DEFAULT '0',
95 ban_ip varchar(40) NOT NULL DEFAULT '',
96 ban_email varchar(100) NOT NULL DEFAULT '',
97 ban_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
98 ban_end INTEGER UNSIGNED NOT NULL DEFAULT '0',
99 ban_exclude INTEGER UNSIGNED NOT NULL DEFAULT '0',
100 ban_reason text(65535) NOT NULL DEFAULT '',
101 ban_give_reason text(65535) NOT NULL DEFAULT ''
104 CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end);
105 CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist (ban_userid, ban_exclude);
106 CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist (ban_email, ban_exclude);
107 CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist (ban_ip, ban_exclude);
109 # Table: 'phpbb_bbcodes'
110 CREATE TABLE phpbb_bbcodes (
111 bbcode_id tinyint(3) NOT NULL DEFAULT '0',
112 bbcode_tag varchar(16) NOT NULL DEFAULT '',
113 bbcode_helpline varchar(255) NOT NULL DEFAULT '',
114 display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '0',
115 bbcode_match text(65535) NOT NULL DEFAULT '',
116 bbcode_tpl mediumtext(16777215) NOT NULL DEFAULT '',
117 first_pass_match mediumtext(16777215) NOT NULL DEFAULT '',
118 first_pass_replace mediumtext(16777215) NOT NULL DEFAULT '',
119 second_pass_match mediumtext(16777215) NOT NULL DEFAULT '',
120 second_pass_replace mediumtext(16777215) NOT NULL DEFAULT '',
121 PRIMARY KEY (bbcode_id)
124 CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes (display_on_posting);
126 # Table: 'phpbb_bookmarks'
127 CREATE TABLE phpbb_bookmarks (
128 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
129 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
130 order_id INTEGER UNSIGNED NOT NULL DEFAULT '0'
133 CREATE INDEX phpbb_bookmarks_order_id ON phpbb_bookmarks (order_id);
134 CREATE INDEX phpbb_bookmarks_topic_user_id ON phpbb_bookmarks (topic_id, user_id);
136 # Table: 'phpbb_bots'
137 CREATE TABLE phpbb_bots (
138 bot_id INTEGER PRIMARY KEY NOT NULL ,
139 bot_active INTEGER UNSIGNED NOT NULL DEFAULT '1',
140 bot_name text(65535) NOT NULL DEFAULT '',
141 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
142 bot_agent varchar(255) NOT NULL DEFAULT '',
143 bot_ip varchar(255) NOT NULL DEFAULT ''
146 CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active);
148 # Table: 'phpbb_config'
149 CREATE TABLE phpbb_config (
150 config_name varchar(255) NOT NULL DEFAULT '',
151 config_value varchar(255) NOT NULL DEFAULT '',
152 is_dynamic INTEGER UNSIGNED NOT NULL DEFAULT '0',
153 PRIMARY KEY (config_name)
156 CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic);
158 # Table: 'phpbb_confirm'
159 CREATE TABLE phpbb_confirm (
160 confirm_id char(32) NOT NULL DEFAULT '',
161 session_id char(32) NOT NULL DEFAULT '',
162 confirm_type tinyint(3) NOT NULL DEFAULT '0',
163 code varchar(8) NOT NULL DEFAULT '',
164 seed INTEGER UNSIGNED NOT NULL DEFAULT '0',
165 PRIMARY KEY (session_id, confirm_id)
168 CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type);
170 # Table: 'phpbb_disallow'
171 CREATE TABLE phpbb_disallow (
172 disallow_id INTEGER PRIMARY KEY NOT NULL ,
173 disallow_username varchar(255) NOT NULL DEFAULT ''
177 # Table: 'phpbb_drafts'
178 CREATE TABLE phpbb_drafts (
179 draft_id INTEGER PRIMARY KEY NOT NULL ,
180 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
181 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
182 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
183 save_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
184 draft_subject text(65535) NOT NULL DEFAULT '',
185 draft_message mediumtext(16777215) NOT NULL DEFAULT ''
188 CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time);
190 # Table: 'phpbb_extensions'
191 CREATE TABLE phpbb_extensions (
192 extension_id INTEGER PRIMARY KEY NOT NULL ,
193 group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
194 extension varchar(100) NOT NULL DEFAULT ''
198 # Table: 'phpbb_extension_groups'
199 CREATE TABLE phpbb_extension_groups (
200 group_id INTEGER PRIMARY KEY NOT NULL ,
201 group_name varchar(255) NOT NULL DEFAULT '',
202 cat_id tinyint(2) NOT NULL DEFAULT '0',
203 allow_group INTEGER UNSIGNED NOT NULL DEFAULT '0',
204 download_mode INTEGER UNSIGNED NOT NULL DEFAULT '1',
205 upload_icon varchar(255) NOT NULL DEFAULT '',
206 max_filesize INTEGER UNSIGNED NOT NULL DEFAULT '0',
207 allowed_forums text(65535) NOT NULL DEFAULT '',
208 allow_in_pm INTEGER UNSIGNED NOT NULL DEFAULT '0'
212 # Table: 'phpbb_forums'
213 CREATE TABLE phpbb_forums (
214 forum_id INTEGER PRIMARY KEY NOT NULL ,
215 parent_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
216 left_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
217 right_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
218 forum_parents mediumtext(16777215) NOT NULL DEFAULT '',
219 forum_name text(65535) NOT NULL DEFAULT '',
220 forum_desc text(65535) NOT NULL DEFAULT '',
221 forum_desc_bitfield varchar(255) NOT NULL DEFAULT '',
222 forum_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',
223 forum_desc_uid varchar(5) NOT NULL DEFAULT '',
224 forum_link varchar(255) NOT NULL DEFAULT '',
225 forum_password varchar(40) NOT NULL DEFAULT '',
226 forum_style tinyint(4) NOT NULL DEFAULT '0',
227 forum_image varchar(255) NOT NULL DEFAULT '',
228 forum_rules text(65535) NOT NULL DEFAULT '',
229 forum_rules_link varchar(255) NOT NULL DEFAULT '',
230 forum_rules_bitfield varchar(255) NOT NULL DEFAULT '',
231 forum_rules_options INTEGER UNSIGNED NOT NULL DEFAULT '7',
232 forum_rules_uid varchar(5) NOT NULL DEFAULT '',
233 forum_topics_per_page tinyint(4) NOT NULL DEFAULT '0',
234 forum_type tinyint(4) NOT NULL DEFAULT '0',
235 forum_status tinyint(4) NOT NULL DEFAULT '0',
236 forum_posts INTEGER UNSIGNED NOT NULL DEFAULT '0',
237 forum_topics INTEGER UNSIGNED NOT NULL DEFAULT '0',
238 forum_topics_real INTEGER UNSIGNED NOT NULL DEFAULT '0',
239 forum_last_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
240 forum_last_poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
241 forum_last_post_subject text(65535) NOT NULL DEFAULT '',
242 forum_last_post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
243 forum_last_poster_name varchar(255) NOT NULL DEFAULT '',
244 forum_last_poster_colour varchar(6) NOT NULL DEFAULT '',
245 forum_flags tinyint(4) NOT NULL DEFAULT '32',
246 display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1',
247 enable_indexing INTEGER UNSIGNED NOT NULL DEFAULT '1',
248 enable_icons INTEGER UNSIGNED NOT NULL DEFAULT '1',
249 enable_prune INTEGER UNSIGNED NOT NULL DEFAULT '0',
250 prune_next INTEGER UNSIGNED NOT NULL DEFAULT '0',
251 prune_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
252 prune_viewed INTEGER UNSIGNED NOT NULL DEFAULT '0',
253 prune_freq INTEGER UNSIGNED NOT NULL DEFAULT '0'
256 CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums (left_id, right_id);
257 CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums (forum_last_post_id);
259 # Table: 'phpbb_forums_access'
260 CREATE TABLE phpbb_forums_access (
261 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
262 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
263 session_id char(32) NOT NULL DEFAULT '',
264 PRIMARY KEY (forum_id, user_id, session_id)
268 # Table: 'phpbb_forums_track'
269 CREATE TABLE phpbb_forums_track (
270 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
271 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
272 mark_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
273 PRIMARY KEY (user_id, forum_id)
277 # Table: 'phpbb_forums_watch'
278 CREATE TABLE phpbb_forums_watch (
279 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
280 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
281 notify_status INTEGER UNSIGNED NOT NULL DEFAULT '0'
284 CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id);
285 CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id);
286 CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch (notify_status);
288 # Table: 'phpbb_groups'
289 CREATE TABLE phpbb_groups (
290 group_id INTEGER PRIMARY KEY NOT NULL ,
291 group_type tinyint(4) NOT NULL DEFAULT '1',
292 group_founder_manage INTEGER UNSIGNED NOT NULL DEFAULT '0',
293 group_name varchar(255) NOT NULL DEFAULT '',
294 group_desc text(65535) NOT NULL DEFAULT '',
295 group_desc_bitfield varchar(255) NOT NULL DEFAULT '',
296 group_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',
297 group_desc_uid varchar(5) NOT NULL DEFAULT '',
298 group_display INTEGER UNSIGNED NOT NULL DEFAULT '0',
299 group_avatar varchar(255) NOT NULL DEFAULT '',
300 group_avatar_type tinyint(4) NOT NULL DEFAULT '0',
301 group_avatar_width tinyint(4) NOT NULL DEFAULT '0',
302 group_avatar_height tinyint(4) NOT NULL DEFAULT '0',
303 group_rank INTEGER UNSIGNED NOT NULL DEFAULT '0',
304 group_colour varchar(6) NOT NULL DEFAULT '',
305 group_sig_chars INTEGER UNSIGNED NOT NULL DEFAULT '0',
306 group_receive_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',
307 group_message_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',
308 group_legend INTEGER UNSIGNED NOT NULL DEFAULT '1'
311 CREATE INDEX phpbb_groups_group_legend ON phpbb_groups (group_legend);
313 # Table: 'phpbb_icons'
314 CREATE TABLE phpbb_icons (
315 icons_id INTEGER PRIMARY KEY NOT NULL ,
316 icons_url varchar(255) NOT NULL DEFAULT '',
317 icons_width tinyint(4) NOT NULL DEFAULT '0',
318 icons_height tinyint(4) NOT NULL DEFAULT '0',
319 icons_order INTEGER UNSIGNED NOT NULL DEFAULT '0',
320 display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '1'
323 CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting);
325 # Table: 'phpbb_lang'
326 CREATE TABLE phpbb_lang (
327 lang_id INTEGER PRIMARY KEY NOT NULL ,
328 lang_iso varchar(30) NOT NULL DEFAULT '',
329 lang_dir varchar(30) NOT NULL DEFAULT '',
330 lang_english_name varchar(100) NOT NULL DEFAULT '',
331 lang_local_name varchar(255) NOT NULL DEFAULT '',
332 lang_author varchar(255) NOT NULL DEFAULT ''
335 CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso);
338 CREATE TABLE phpbb_log (
339 log_id INTEGER PRIMARY KEY NOT NULL ,
340 log_type tinyint(4) NOT NULL DEFAULT '0',
341 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
342 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
343 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
344 reportee_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
345 log_ip varchar(40) NOT NULL DEFAULT '',
346 log_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
347 log_operation text(65535) NOT NULL DEFAULT '',
348 log_data mediumtext(16777215) NOT NULL DEFAULT ''
351 CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type);
352 CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id);
353 CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id);
354 CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id);
355 CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);
357 # Table: 'phpbb_moderator_cache'
358 CREATE TABLE phpbb_moderator_cache (
359 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
360 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
361 username varchar(255) NOT NULL DEFAULT '',
362 group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
363 group_name varchar(255) NOT NULL DEFAULT '',
364 display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1'
367 CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index);
368 CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id);
370 # Table: 'phpbb_modules'
371 CREATE TABLE phpbb_modules (
372 module_id INTEGER PRIMARY KEY NOT NULL ,
373 module_enabled INTEGER UNSIGNED NOT NULL DEFAULT '1',
374 module_display INTEGER UNSIGNED NOT NULL DEFAULT '1',
375 module_basename varchar(255) NOT NULL DEFAULT '',
376 module_class varchar(10) NOT NULL DEFAULT '',
377 parent_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
378 left_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
379 right_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
380 module_langname varchar(255) NOT NULL DEFAULT '',
381 module_mode varchar(255) NOT NULL DEFAULT '',
382 module_auth varchar(255) NOT NULL DEFAULT ''
385 CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules (left_id, right_id);
386 CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules (module_enabled);
387 CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules (module_class, left_id);
389 # Table: 'phpbb_poll_options'
390 CREATE TABLE phpbb_poll_options (
391 poll_option_id tinyint(4) NOT NULL DEFAULT '0',
392 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
393 poll_option_text text(65535) NOT NULL DEFAULT '',
394 poll_option_total INTEGER UNSIGNED NOT NULL DEFAULT '0'
397 CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options (poll_option_id);
398 CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id);
400 # Table: 'phpbb_poll_votes'
401 CREATE TABLE phpbb_poll_votes (
402 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
403 poll_option_id tinyint(4) NOT NULL DEFAULT '0',
404 vote_user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
405 vote_user_ip varchar(40) NOT NULL DEFAULT ''
408 CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes (topic_id);
409 CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes (vote_user_id);
410 CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes (vote_user_ip);
412 # Table: 'phpbb_posts'
413 CREATE TABLE phpbb_posts (
414 post_id INTEGER PRIMARY KEY NOT NULL ,
415 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
416 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
417 poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
418 icon_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
419 poster_ip varchar(40) NOT NULL DEFAULT '',
420 post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
421 post_approved INTEGER UNSIGNED NOT NULL DEFAULT '1',
422 post_reported INTEGER UNSIGNED NOT NULL DEFAULT '0',
423 enable_bbcode INTEGER UNSIGNED NOT NULL DEFAULT '1',
424 enable_smilies INTEGER UNSIGNED NOT NULL DEFAULT '1',
425 enable_magic_url INTEGER UNSIGNED NOT NULL DEFAULT '1',
426 enable_sig INTEGER UNSIGNED NOT NULL DEFAULT '1',
427 post_username varchar(255) NOT NULL DEFAULT '',
428 post_subject text(65535) NOT NULL DEFAULT '',
429 post_text mediumtext(16777215) NOT NULL DEFAULT '',
430 post_checksum varchar(32) NOT NULL DEFAULT '',
431 post_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',
432 bbcode_bitfield varchar(255) NOT NULL DEFAULT '',
433 bbcode_uid varchar(5) NOT NULL DEFAULT '',
434 post_postcount INTEGER UNSIGNED NOT NULL DEFAULT '1',
435 post_edit_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
436 post_edit_reason text(65535) NOT NULL DEFAULT '',
437 post_edit_user INTEGER UNSIGNED NOT NULL DEFAULT '0',
438 post_edit_count INTEGER UNSIGNED NOT NULL DEFAULT '0',
439 post_edit_locked INTEGER UNSIGNED NOT NULL DEFAULT '0'
442 CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id);
443 CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id);
444 CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip);
445 CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id);
446 CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved);
447 CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time);
449 # Table: 'phpbb_privmsgs'
450 CREATE TABLE phpbb_privmsgs (
451 msg_id INTEGER PRIMARY KEY NOT NULL ,
452 root_level INTEGER UNSIGNED NOT NULL DEFAULT '0',
453 author_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
454 icon_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
455 author_ip varchar(40) NOT NULL DEFAULT '',
456 message_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
457 enable_bbcode INTEGER UNSIGNED NOT NULL DEFAULT '1',
458 enable_smilies INTEGER UNSIGNED NOT NULL DEFAULT '1',
459 enable_magic_url INTEGER UNSIGNED NOT NULL DEFAULT '1',
460 enable_sig INTEGER UNSIGNED NOT NULL DEFAULT '1',
461 message_subject text(65535) NOT NULL DEFAULT '',
462 message_text mediumtext(16777215) NOT NULL DEFAULT '',
463 message_edit_reason text(65535) NOT NULL DEFAULT '',
464 message_edit_user INTEGER UNSIGNED NOT NULL DEFAULT '0',
465 message_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',
466 bbcode_bitfield varchar(255) NOT NULL DEFAULT '',
467 bbcode_uid varchar(5) NOT NULL DEFAULT '',
468 message_edit_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
469 message_edit_count INTEGER UNSIGNED NOT NULL DEFAULT '0',
470 to_address text(65535) NOT NULL DEFAULT '',
471 bcc_address text(65535) NOT NULL DEFAULT ''
474 CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs (author_ip);
475 CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs (message_time);
476 CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs (author_id);
477 CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs (root_level);
479 # Table: 'phpbb_privmsgs_folder'
480 CREATE TABLE phpbb_privmsgs_folder (
481 folder_id INTEGER PRIMARY KEY NOT NULL ,
482 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
483 folder_name varchar(255) NOT NULL DEFAULT '',
484 pm_count INTEGER UNSIGNED NOT NULL DEFAULT '0'
487 CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder (user_id);
489 # Table: 'phpbb_privmsgs_rules'
490 CREATE TABLE phpbb_privmsgs_rules (
491 rule_id INTEGER PRIMARY KEY NOT NULL ,
492 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
493 rule_check INTEGER UNSIGNED NOT NULL DEFAULT '0',
494 rule_connection INTEGER UNSIGNED NOT NULL DEFAULT '0',
495 rule_string varchar(255) NOT NULL DEFAULT '',
496 rule_user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
497 rule_group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
498 rule_action INTEGER UNSIGNED NOT NULL DEFAULT '0',
499 rule_folder_id int(11) NOT NULL DEFAULT '0'
502 CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules (user_id);
504 # Table: 'phpbb_privmsgs_to'
505 CREATE TABLE phpbb_privmsgs_to (
506 msg_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
507 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
508 author_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
509 pm_deleted INTEGER UNSIGNED NOT NULL DEFAULT '0',
510 pm_new INTEGER UNSIGNED NOT NULL DEFAULT '1',
511 pm_unread INTEGER UNSIGNED NOT NULL DEFAULT '1',
512 pm_replied INTEGER UNSIGNED NOT NULL DEFAULT '0',
513 pm_marked INTEGER UNSIGNED NOT NULL DEFAULT '0',
514 pm_forwarded INTEGER UNSIGNED NOT NULL DEFAULT '0',
515 folder_id int(11) NOT NULL DEFAULT '0'
518 CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id);
519 CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to (author_id);
520 CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to (user_id, folder_id);
522 # Table: 'phpbb_profile_fields'
523 CREATE TABLE phpbb_profile_fields (
524 field_id INTEGER PRIMARY KEY NOT NULL ,
525 field_name varchar(255) NOT NULL DEFAULT '',
526 field_type tinyint(4) NOT NULL DEFAULT '0',
527 field_ident varchar(20) NOT NULL DEFAULT '',
528 field_length varchar(20) NOT NULL DEFAULT '',
529 field_minlen varchar(255) NOT NULL DEFAULT '',
530 field_maxlen varchar(255) NOT NULL DEFAULT '',
531 field_novalue varchar(255) NOT NULL DEFAULT '',
532 field_default_value varchar(255) NOT NULL DEFAULT '',
533 field_validation varchar(20) NOT NULL DEFAULT '',
534 field_required INTEGER UNSIGNED NOT NULL DEFAULT '0',
535 field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',
536 field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',
537 field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',
538 field_active INTEGER UNSIGNED NOT NULL DEFAULT '0',
539 field_order INTEGER UNSIGNED NOT NULL DEFAULT '0'
542 CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields (field_type);
543 CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields (field_order);
545 # Table: 'phpbb_profile_fields_data'
546 CREATE TABLE phpbb_profile_fields_data (
547 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
548 PRIMARY KEY (user_id)
552 # Table: 'phpbb_profile_fields_lang'
553 CREATE TABLE phpbb_profile_fields_lang (
554 field_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
555 lang_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
556 option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
557 field_type tinyint(4) NOT NULL DEFAULT '0',
558 lang_value varchar(255) NOT NULL DEFAULT '',
559 PRIMARY KEY (field_id, lang_id, option_id)
563 # Table: 'phpbb_profile_lang'
564 CREATE TABLE phpbb_profile_lang (
565 field_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
566 lang_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
567 lang_name varchar(255) NOT NULL DEFAULT '',
568 lang_explain text(65535) NOT NULL DEFAULT '',
569 lang_default_value varchar(255) NOT NULL DEFAULT '',
570 PRIMARY KEY (field_id, lang_id)
574 # Table: 'phpbb_ranks'
575 CREATE TABLE phpbb_ranks (
576 rank_id INTEGER PRIMARY KEY NOT NULL ,
577 rank_title varchar(255) NOT NULL DEFAULT '',
578 rank_min INTEGER UNSIGNED NOT NULL DEFAULT '0',
579 rank_special INTEGER UNSIGNED NOT NULL DEFAULT '0',
580 rank_image varchar(255) NOT NULL DEFAULT ''
584 # Table: 'phpbb_reports'
585 CREATE TABLE phpbb_reports (
586 report_id INTEGER PRIMARY KEY NOT NULL ,
587 reason_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
588 post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
589 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
590 user_notify INTEGER UNSIGNED NOT NULL DEFAULT '0',
591 report_closed INTEGER UNSIGNED NOT NULL DEFAULT '0',
592 report_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
593 report_text mediumtext(16777215) NOT NULL DEFAULT ''
597 # Table: 'phpbb_reports_reasons'
598 CREATE TABLE phpbb_reports_reasons (
599 reason_id INTEGER PRIMARY KEY NOT NULL ,
600 reason_title varchar(255) NOT NULL DEFAULT '',
601 reason_description mediumtext(16777215) NOT NULL DEFAULT '',
602 reason_order INTEGER UNSIGNED NOT NULL DEFAULT '0'
606 # Table: 'phpbb_search_results'
607 CREATE TABLE phpbb_search_results (
608 search_key varchar(32) NOT NULL DEFAULT '',
609 search_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
610 search_keywords mediumtext(16777215) NOT NULL DEFAULT '',
611 search_authors mediumtext(16777215) NOT NULL DEFAULT '',
612 PRIMARY KEY (search_key)
616 # Table: 'phpbb_search_wordlist'
617 CREATE TABLE phpbb_search_wordlist (
618 word_id INTEGER PRIMARY KEY NOT NULL ,
619 word_text varchar(255) NOT NULL DEFAULT '',
620 word_common INTEGER UNSIGNED NOT NULL DEFAULT '0',
621 word_count INTEGER UNSIGNED NOT NULL DEFAULT '0'
624 CREATE UNIQUE INDEX phpbb_search_wordlist_wrd_txt ON phpbb_search_wordlist (word_text);
625 CREATE INDEX phpbb_search_wordlist_wrd_cnt ON phpbb_search_wordlist (word_count);
627 # Table: 'phpbb_search_wordmatch'
628 CREATE TABLE phpbb_search_wordmatch (
629 post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
630 word_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
631 title_match INTEGER UNSIGNED NOT NULL DEFAULT '0'
634 CREATE UNIQUE INDEX phpbb_search_wordmatch_unq_mtch ON phpbb_search_wordmatch (word_id, post_id, title_match);
635 CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch (word_id);
636 CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch (post_id);
638 # Table: 'phpbb_sessions'
639 CREATE TABLE phpbb_sessions (
640 session_id char(32) NOT NULL DEFAULT '',
641 session_user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
642 session_last_visit INTEGER UNSIGNED NOT NULL DEFAULT '0',
643 session_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
644 session_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
645 session_ip varchar(40) NOT NULL DEFAULT '',
646 session_browser varchar(150) NOT NULL DEFAULT '',
647 session_forwarded_for varchar(255) NOT NULL DEFAULT '',
648 session_page varchar(255) NOT NULL DEFAULT '',
649 session_viewonline INTEGER UNSIGNED NOT NULL DEFAULT '1',
650 session_autologin INTEGER UNSIGNED NOT NULL DEFAULT '0',
651 session_admin INTEGER UNSIGNED NOT NULL DEFAULT '0',
652 PRIMARY KEY (session_id)
655 CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time);
656 CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id);
658 # Table: 'phpbb_sessions_keys'
659 CREATE TABLE phpbb_sessions_keys (
660 key_id char(32) NOT NULL DEFAULT '',
661 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
662 last_ip varchar(40) NOT NULL DEFAULT '',
663 last_login INTEGER UNSIGNED NOT NULL DEFAULT '0',
664 PRIMARY KEY (key_id, user_id)
667 CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys (last_login);
669 # Table: 'phpbb_sitelist'
670 CREATE TABLE phpbb_sitelist (
671 site_id INTEGER PRIMARY KEY NOT NULL ,
672 site_ip varchar(40) NOT NULL DEFAULT '',
673 site_hostname varchar(255) NOT NULL DEFAULT '',
674 ip_exclude INTEGER UNSIGNED NOT NULL DEFAULT '0'
678 # Table: 'phpbb_smilies'
679 CREATE TABLE phpbb_smilies (
680 smiley_id INTEGER PRIMARY KEY NOT NULL ,
681 code varchar(50) NOT NULL DEFAULT '',
682 emotion varchar(50) NOT NULL DEFAULT '',
683 smiley_url varchar(50) NOT NULL DEFAULT '',
684 smiley_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
685 smiley_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
686 smiley_order INTEGER UNSIGNED NOT NULL DEFAULT '0',
687 display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '1'
690 CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies (display_on_posting);
692 # Table: 'phpbb_styles'
693 CREATE TABLE phpbb_styles (
694 style_id INTEGER PRIMARY KEY NOT NULL ,
695 style_name varchar(255) NOT NULL DEFAULT '',
696 style_copyright varchar(255) NOT NULL DEFAULT '',
697 style_active INTEGER UNSIGNED NOT NULL DEFAULT '1',
698 template_id tinyint(4) NOT NULL DEFAULT '0',
699 theme_id tinyint(4) NOT NULL DEFAULT '0',
700 imageset_id tinyint(4) NOT NULL DEFAULT '0'
703 CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);
704 CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id);
705 CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id);
706 CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);
708 # Table: 'phpbb_styles_template'
709 CREATE TABLE phpbb_styles_template (
710 template_id INTEGER PRIMARY KEY NOT NULL ,
711 template_name varchar(255) NOT NULL DEFAULT '',
712 template_copyright varchar(255) NOT NULL DEFAULT '',
713 template_path varchar(100) NOT NULL DEFAULT '',
714 bbcode_bitfield varchar(255) NOT NULL DEFAULT 'kNg=',
715 template_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0'
718 CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);
720 # Table: 'phpbb_styles_template_data'
721 CREATE TABLE phpbb_styles_template_data (
722 template_id INTEGER PRIMARY KEY NOT NULL ,
723 template_filename varchar(100) NOT NULL DEFAULT '',
724 template_included text(65535) NOT NULL DEFAULT '',
725 template_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
726 template_data mediumtext(16777215) NOT NULL DEFAULT ''
729 CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id);
730 CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename);
732 # Table: 'phpbb_styles_theme'
733 CREATE TABLE phpbb_styles_theme (
734 theme_id INTEGER PRIMARY KEY NOT NULL ,
735 theme_name varchar(255) NOT NULL DEFAULT '',
736 theme_copyright varchar(255) NOT NULL DEFAULT '',
737 theme_path varchar(100) NOT NULL DEFAULT '',
738 theme_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0',
739 theme_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
740 theme_data mediumtext(16777215) NOT NULL DEFAULT ''
743 CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);
745 # Table: 'phpbb_styles_imageset'
746 CREATE TABLE phpbb_styles_imageset (
747 imageset_id INTEGER PRIMARY KEY NOT NULL ,
748 imageset_name varchar(255) NOT NULL DEFAULT '',
749 imageset_copyright varchar(255) NOT NULL DEFAULT '',
750 imageset_path varchar(100) NOT NULL DEFAULT ''
753 CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);
755 # Table: 'phpbb_styles_imageset_data'
756 CREATE TABLE phpbb_styles_imageset_data (
757 image_id INTEGER PRIMARY KEY NOT NULL ,
758 image_name varchar(200) NOT NULL DEFAULT '',
759 image_filename varchar(200) NOT NULL DEFAULT '',
760 image_lang varchar(30) NOT NULL DEFAULT '',
761 image_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
762 image_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
763 imageset_id tinyint(4) NOT NULL DEFAULT '0'
766 CREATE INDEX phpbb_styles_imageset_data_i_id ON phpbb_styles_imageset_data (imageset_id);
768 # Table: 'phpbb_topics'
769 CREATE TABLE phpbb_topics (
770 topic_id INTEGER PRIMARY KEY NOT NULL ,
771 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
772 icon_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
773 topic_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',
774 topic_approved INTEGER UNSIGNED NOT NULL DEFAULT '1',
775 topic_reported INTEGER UNSIGNED NOT NULL DEFAULT '0',
776 topic_title text(65535) NOT NULL DEFAULT '',
777 topic_poster INTEGER UNSIGNED NOT NULL DEFAULT '0',
778 topic_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
779 topic_time_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',
780 topic_views INTEGER UNSIGNED NOT NULL DEFAULT '0',
781 topic_replies INTEGER UNSIGNED NOT NULL DEFAULT '0',
782 topic_replies_real INTEGER UNSIGNED NOT NULL DEFAULT '0',
783 topic_status tinyint(3) NOT NULL DEFAULT '0',
784 topic_type tinyint(3) NOT NULL DEFAULT '0',
785 topic_first_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
786 topic_first_poster_name varchar(255) NOT NULL DEFAULT '',
787 topic_first_poster_colour varchar(6) NOT NULL DEFAULT '',
788 topic_last_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
789 topic_last_poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
790 topic_last_poster_name varchar(255) NOT NULL DEFAULT '',
791 topic_last_poster_colour varchar(6) NOT NULL DEFAULT '',
792 topic_last_post_subject text(65535) NOT NULL DEFAULT '',
793 topic_last_post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
794 topic_last_view_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
795 topic_moved_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
796 topic_bumped INTEGER UNSIGNED NOT NULL DEFAULT '0',
797 topic_bumper INTEGER UNSIGNED NOT NULL DEFAULT '0',
798 poll_title text(65535) NOT NULL DEFAULT '',
799 poll_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
800 poll_length INTEGER UNSIGNED NOT NULL DEFAULT '0',
801 poll_max_options tinyint(4) NOT NULL DEFAULT '1',
802 poll_last_vote INTEGER UNSIGNED NOT NULL DEFAULT '0',
803 poll_vote_change INTEGER UNSIGNED NOT NULL DEFAULT '0'
806 CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id);
807 CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type);
808 CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time);
809 CREATE INDEX phpbb_topics_topic_approved ON phpbb_topics (topic_approved);
810 CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics (forum_id, topic_last_post_time, topic_moved_id);
812 # Table: 'phpbb_topics_track'
813 CREATE TABLE phpbb_topics_track (
814 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
815 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
816 forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
817 mark_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
818 PRIMARY KEY (user_id, topic_id)
821 CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id);
823 # Table: 'phpbb_topics_posted'
824 CREATE TABLE phpbb_topics_posted (
825 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
826 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
827 topic_posted INTEGER UNSIGNED NOT NULL DEFAULT '0',
828 PRIMARY KEY (user_id, topic_id)
832 # Table: 'phpbb_topics_watch'
833 CREATE TABLE phpbb_topics_watch (
834 topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
835 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
836 notify_status INTEGER UNSIGNED NOT NULL DEFAULT '0'
839 CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch (topic_id);
840 CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch (user_id);
841 CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch (notify_status);
843 # Table: 'phpbb_user_group'
844 CREATE TABLE phpbb_user_group (
845 group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
846 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
847 group_leader INTEGER UNSIGNED NOT NULL DEFAULT '0',
848 user_pending INTEGER UNSIGNED NOT NULL DEFAULT '1'
851 CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id);
852 CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id);
853 CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group (group_leader);
855 # Table: 'phpbb_users'
856 CREATE TABLE phpbb_users (
857 user_id INTEGER PRIMARY KEY NOT NULL ,
858 user_type tinyint(2) NOT NULL DEFAULT '0',
859 group_id INTEGER UNSIGNED NOT NULL DEFAULT '3',
860 user_permissions mediumtext(16777215) NOT NULL DEFAULT '',
861 user_perm_from INTEGER UNSIGNED NOT NULL DEFAULT '0',
862 user_ip varchar(40) NOT NULL DEFAULT '',
863 user_regdate INTEGER UNSIGNED NOT NULL DEFAULT '0',
864 username varchar(255) NOT NULL DEFAULT '',
865 username_clean varchar(255) NOT NULL DEFAULT '',
866 user_password varchar(40) NOT NULL DEFAULT '',
867 user_passchg INTEGER UNSIGNED NOT NULL DEFAULT '0',
868 user_pass_convert INTEGER UNSIGNED NOT NULL DEFAULT '0',
869 user_email varchar(100) NOT NULL DEFAULT '',
870 user_email_hash bigint(20) NOT NULL DEFAULT '0',
871 user_birthday varchar(10) NOT NULL DEFAULT '',
872 user_lastvisit INTEGER UNSIGNED NOT NULL DEFAULT '0',
873 user_lastmark INTEGER UNSIGNED NOT NULL DEFAULT '0',
874 user_lastpost_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
875 user_lastpage varchar(200) NOT NULL DEFAULT '',
876 user_last_confirm_key varchar(10) NOT NULL DEFAULT '',
877 user_last_search INTEGER UNSIGNED NOT NULL DEFAULT '0',
878 user_warnings tinyint(4) NOT NULL DEFAULT '0',
879 user_last_warning INTEGER UNSIGNED NOT NULL DEFAULT '0',
880 user_login_attempts tinyint(4) NOT NULL DEFAULT '0',
881 user_inactive_reason tinyint(2) NOT NULL DEFAULT '0',
882 user_inactive_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
883 user_posts INTEGER UNSIGNED NOT NULL DEFAULT '0',
884 user_lang varchar(30) NOT NULL DEFAULT '',
885 user_timezone decimal(5,2) NOT NULL DEFAULT '0',
886 user_dst INTEGER UNSIGNED NOT NULL DEFAULT '0',
887 user_dateformat varchar(30) NOT NULL DEFAULT 'd M Y H:i',
888 user_style tinyint(4) NOT NULL DEFAULT '0',
889 user_rank INTEGER UNSIGNED NOT NULL DEFAULT '0',
890 user_colour varchar(6) NOT NULL DEFAULT '',
891 user_new_privmsg tinyint(4) NOT NULL DEFAULT '0',
892 user_unread_privmsg tinyint(4) NOT NULL DEFAULT '0',
893 user_last_privmsg INTEGER UNSIGNED NOT NULL DEFAULT '0',
894 user_message_rules INTEGER UNSIGNED NOT NULL DEFAULT '0',
895 user_full_folder int(11) NOT NULL DEFAULT '-3',
896 user_emailtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
897 user_topic_show_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
898 user_topic_sortby_type varchar(1) NOT NULL DEFAULT 't',
899 user_topic_sortby_dir varchar(1) NOT NULL DEFAULT 'd',
900 user_post_show_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
901 user_post_sortby_type varchar(1) NOT NULL DEFAULT 't',
902 user_post_sortby_dir varchar(1) NOT NULL DEFAULT 'a',
903 user_notify INTEGER UNSIGNED NOT NULL DEFAULT '0',
904 user_notify_pm INTEGER UNSIGNED NOT NULL DEFAULT '1',
905 user_notify_type tinyint(4) NOT NULL DEFAULT '0',
906 user_allow_pm INTEGER UNSIGNED NOT NULL DEFAULT '1',
907 user_allow_viewonline INTEGER UNSIGNED NOT NULL DEFAULT '1',
908 user_allow_viewemail INTEGER UNSIGNED NOT NULL DEFAULT '1',
909 user_allow_massemail INTEGER UNSIGNED NOT NULL DEFAULT '1',
910 user_options INTEGER UNSIGNED NOT NULL DEFAULT '895',
911 user_avatar varchar(255) NOT NULL DEFAULT '',
912 user_avatar_type tinyint(2) NOT NULL DEFAULT '0',
913 user_avatar_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
914 user_avatar_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
915 user_sig mediumtext(16777215) NOT NULL DEFAULT '',
916 user_sig_bbcode_uid varchar(5) NOT NULL DEFAULT '',
917 user_sig_bbcode_bitfield varchar(255) NOT NULL DEFAULT '',
918 user_from varchar(100) NOT NULL DEFAULT '',
919 user_icq varchar(15) NOT NULL DEFAULT '',
920 user_aim varchar(255) NOT NULL DEFAULT '',
921 user_yim varchar(255) NOT NULL DEFAULT '',
922 user_msnm varchar(255) NOT NULL DEFAULT '',
923 user_jabber varchar(255) NOT NULL DEFAULT '',
924 user_website varchar(200) NOT NULL DEFAULT '',
925 user_occ text(65535) NOT NULL DEFAULT '',
926 user_interests text(65535) NOT NULL DEFAULT '',
927 user_actkey varchar(32) NOT NULL DEFAULT '',
928 user_newpasswd varchar(32) NOT NULL DEFAULT ''
931 CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday);
932 CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash);
933 CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type);
934 CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);
936 # Table: 'phpbb_warnings'
937 CREATE TABLE phpbb_warnings (
938 warning_id INTEGER PRIMARY KEY NOT NULL ,
939 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
940 post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
941 log_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
942 warning_time INTEGER UNSIGNED NOT NULL DEFAULT '0'
946 # Table: 'phpbb_words'
947 CREATE TABLE phpbb_words (
948 word_id INTEGER PRIMARY KEY NOT NULL ,
949 word varchar(255) NOT NULL DEFAULT '',
950 replacement varchar(255) NOT NULL DEFAULT ''
954 # Table: 'phpbb_zebra'
955 CREATE TABLE phpbb_zebra (
956 user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
957 zebra_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
958 friend INTEGER UNSIGNED NOT NULL DEFAULT '0',
959 foe INTEGER UNSIGNED NOT NULL DEFAULT '0',
960 PRIMARY KEY (user_id, zebra_id)