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 varchar(255) DEFAULT '' NOT NULL,
14 real_filename varchar(255) DEFAULT '' NOT NULL,
15 download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
16 attach_comment text NOT NULL,
17 extension varchar(100) DEFAULT '' NOT NULL,
18 mimetype varchar(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)
28 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
41 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(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)
53 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
56 # Table: 'phpbb_acl_roles'
57 CREATE TABLE phpbb_acl_roles (
58 role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
59 role_name varchar(255) DEFAULT '' NOT NULL,
60 role_description text NOT NULL,
61 role_type varchar(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)
66 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
76 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
89 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(40) DEFAULT '' NOT NULL,
97 ban_email varchar(100) DEFAULT '' 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 varchar(255) DEFAULT '' NOT NULL,
102 ban_give_reason varchar(255) DEFAULT '' 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, ban_exclude),
107 KEY ban_ip (ban_ip, ban_exclude)
108 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
111 # Table: 'phpbb_bbcodes'
112 CREATE TABLE phpbb_bbcodes (
113 bbcode_id tinyint(3) DEFAULT '0' NOT NULL,
114 bbcode_tag varchar(16) DEFAULT '' NOT NULL,
115 bbcode_helpline varchar(255) DEFAULT '' NOT NULL,
116 display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
117 bbcode_match text NOT NULL,
118 bbcode_tpl mediumtext NOT NULL,
119 first_pass_match mediumtext NOT NULL,
120 first_pass_replace mediumtext NOT NULL,
121 second_pass_match mediumtext NOT NULL,
122 second_pass_replace mediumtext NOT NULL,
123 PRIMARY KEY (bbcode_id),
124 KEY display_on_post (display_on_posting)
125 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
133 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' NOT NULL,
141 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
142 bot_agent varchar(255) DEFAULT '' NOT NULL,
143 bot_ip varchar(255) DEFAULT '' NOT NULL,
144 PRIMARY KEY (bot_id),
145 KEY bot_active (bot_active)
146 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
149 # Table: 'phpbb_config'
150 CREATE TABLE phpbb_config (
151 config_name varchar(255) DEFAULT '' NOT NULL,
152 config_value varchar(255) DEFAULT '' NOT NULL,
153 is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
154 PRIMARY KEY (config_name),
155 KEY is_dynamic (is_dynamic)
156 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
159 # Table: 'phpbb_confirm'
160 CREATE TABLE phpbb_confirm (
161 confirm_id char(32) DEFAULT '' NOT NULL,
162 session_id char(32) DEFAULT '' NOT NULL,
163 confirm_type tinyint(3) DEFAULT '0' NOT NULL,
164 code varchar(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)
168 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
171 # Table: 'phpbb_disallow'
172 CREATE TABLE phpbb_disallow (
173 disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
174 disallow_username varchar(255) DEFAULT '' NOT NULL,
175 PRIMARY KEY (disallow_id)
176 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(100) DEFAULT '' NOT NULL,
187 draft_message mediumtext NOT NULL,
188 PRIMARY KEY (draft_id),
189 KEY save_time (save_time)
190 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(100) DEFAULT '' NOT NULL,
198 PRIMARY KEY (extension_id)
199 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
202 # Table: 'phpbb_extension_groups'
203 CREATE TABLE phpbb_extension_groups (
204 group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
205 group_name varchar(255) DEFAULT '' 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 varchar(255) DEFAULT '' NOT NULL,
210 max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
211 allowed_forums text NOT NULL,
212 allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
213 PRIMARY KEY (group_id)
214 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 mediumtext NOT NULL,
224 forum_name varchar(255) DEFAULT '' NOT NULL,
225 forum_desc text NOT NULL,
226 forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
227 forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
228 forum_desc_uid varchar(8) DEFAULT '' NOT NULL,
229 forum_link varchar(255) DEFAULT '' NOT NULL,
230 forum_password varchar(40) DEFAULT '' NOT NULL,
231 forum_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
232 forum_image varchar(255) DEFAULT '' NOT NULL,
233 forum_rules text NOT NULL,
234 forum_rules_link varchar(255) DEFAULT '' NOT NULL,
235 forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL,
236 forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
237 forum_rules_uid varchar(8) 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 varchar(100) DEFAULT '' NOT NULL,
247 forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
248 forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,
249 forum_last_poster_colour varchar(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)
262 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 char(32) DEFAULT '' NOT NULL,
270 PRIMARY KEY (forum_id, user_id, session_id)
271 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
280 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
291 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' NOT NULL,
300 group_desc text NOT NULL,
301 group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
302 group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
303 group_desc_uid varchar(8) DEFAULT '' NOT NULL,
304 group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
305 group_avatar varchar(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 varchar(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)
317 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
320 # Table: 'phpbb_icons'
321 CREATE TABLE phpbb_icons (
322 icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
323 icons_url varchar(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)
330 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
333 # Table: 'phpbb_lang'
334 CREATE TABLE phpbb_lang (
335 lang_id tinyint(4) NOT NULL auto_increment,
336 lang_iso varchar(30) DEFAULT '' NOT NULL,
337 lang_dir varchar(30) DEFAULT '' NOT NULL,
338 lang_english_name varchar(100) DEFAULT '' NOT NULL,
339 lang_local_name varchar(255) DEFAULT '' NOT NULL,
340 lang_author varchar(255) DEFAULT '' NOT NULL,
341 PRIMARY KEY (lang_id),
342 KEY lang_iso (lang_iso)
343 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(40) DEFAULT '' NOT NULL,
355 log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
356 log_operation text NOT NULL,
357 log_data mediumtext 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)
364 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' NOT NULL,
372 group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
373 group_name varchar(255) DEFAULT '' 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)
377 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' NOT NULL,
386 module_class varchar(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 varchar(255) DEFAULT '' NOT NULL,
391 module_mode varchar(255) DEFAULT '' NOT NULL,
392 module_auth varchar(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)
397 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 text 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)
408 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(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)
420 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(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 varchar(255) DEFAULT '' NOT NULL,
439 post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
440 post_text mediumtext NOT NULL,
441 post_checksum varchar(32) DEFAULT '' NOT NULL,
442 post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
443 bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
444 bbcode_uid varchar(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 varchar(255) DEFAULT '' 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)
458 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(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 varchar(100) DEFAULT '' NOT NULL,
474 message_text mediumtext NOT NULL,
475 message_edit_reason varchar(255) DEFAULT '' 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 varchar(255) DEFAULT '' NOT NULL,
479 bbcode_uid varchar(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 text NOT NULL,
483 bcc_address text 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)
489 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' NOT NULL,
497 pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
498 PRIMARY KEY (folder_id),
499 KEY user_id (user_id)
500 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' 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)
516 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
534 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
537 # Table: 'phpbb_profile_fields'
538 CREATE TABLE phpbb_profile_fields (
539 field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
540 field_name varchar(255) DEFAULT '' NOT NULL,
541 field_type tinyint(4) DEFAULT '0' NOT NULL,
542 field_ident varchar(20) DEFAULT '' NOT NULL,
543 field_length varchar(20) DEFAULT '' NOT NULL,
544 field_minlen varchar(255) DEFAULT '' NOT NULL,
545 field_maxlen varchar(255) DEFAULT '' NOT NULL,
546 field_novalue varchar(255) DEFAULT '' NOT NULL,
547 field_default_value varchar(255) DEFAULT '' NOT NULL,
548 field_validation varchar(20) 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)
558 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
565 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' NOT NULL,
575 PRIMARY KEY (field_id, lang_id, option_id)
576 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(255) DEFAULT '' NOT NULL,
584 lang_explain text NOT NULL,
585 lang_default_value varchar(255) DEFAULT '' NOT NULL,
586 PRIMARY KEY (field_id, lang_id)
587 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
590 # Table: 'phpbb_ranks'
591 CREATE TABLE phpbb_ranks (
592 rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
593 rank_title varchar(255) DEFAULT '' 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 varchar(255) DEFAULT '' NOT NULL,
597 PRIMARY KEY (rank_id)
598 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 mediumtext NOT NULL,
611 PRIMARY KEY (report_id)
612 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
615 # Table: 'phpbb_reports_reasons'
616 CREATE TABLE phpbb_reports_reasons (
617 reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
618 reason_title varchar(255) DEFAULT '' NOT NULL,
619 reason_description mediumtext NOT NULL,
620 reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
621 PRIMARY KEY (reason_id)
622 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
625 # Table: 'phpbb_search_results'
626 CREATE TABLE phpbb_search_results (
627 search_key varchar(32) DEFAULT '' NOT NULL,
628 search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
629 search_keywords mediumtext NOT NULL,
630 search_authors mediumtext NOT NULL,
631 PRIMARY KEY (search_key)
632 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
635 # Table: 'phpbb_search_wordlist'
636 CREATE TABLE phpbb_search_wordlist (
637 word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
638 word_text varchar(255) DEFAULT '' 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),
643 KEY wrd_cnt (word_count)
644 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
655 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
658 # Table: 'phpbb_sessions'
659 CREATE TABLE phpbb_sessions (
660 session_id char(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 varchar(40) DEFAULT '' NOT NULL,
666 session_browser varchar(150) DEFAULT '' NOT NULL,
667 session_forwarded_for varchar(255) DEFAULT '' NOT NULL,
668 session_page varchar(255) DEFAULT '' 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)
675 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
678 # Table: 'phpbb_sessions_keys'
679 CREATE TABLE phpbb_sessions_keys (
680 key_id char(32) DEFAULT '' NOT NULL,
681 user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
682 last_ip varchar(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)
686 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
689 # Table: 'phpbb_sitelist'
690 CREATE TABLE phpbb_sitelist (
691 site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
692 site_ip varchar(40) DEFAULT '' NOT NULL,
693 site_hostname varchar(255) DEFAULT '' NOT NULL,
694 ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
695 PRIMARY KEY (site_id)
696 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
699 # Table: 'phpbb_smilies'
700 CREATE TABLE phpbb_smilies (
701 smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
702 code varchar(50) DEFAULT '' NOT NULL,
703 emotion varchar(50) DEFAULT '' NOT NULL,
704 smiley_url varchar(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)
711 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
714 # Table: 'phpbb_styles'
715 CREATE TABLE phpbb_styles (
716 style_id smallint(4) UNSIGNED NOT NULL auto_increment,
717 style_name varchar(255) DEFAULT '' NOT NULL,
718 style_copyright varchar(255) DEFAULT '' 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),
725 KEY template_id (template_id),
726 KEY theme_id (theme_id),
727 KEY imageset_id (imageset_id)
728 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
731 # Table: 'phpbb_styles_template'
732 CREATE TABLE phpbb_styles_template (
733 template_id smallint(4) UNSIGNED NOT NULL auto_increment,
734 template_name varchar(255) DEFAULT '' NOT NULL,
735 template_copyright varchar(255) DEFAULT '' NOT NULL,
736 template_path varchar(100) DEFAULT '' NOT NULL,
737 bbcode_bitfield varchar(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)
741 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(100) DEFAULT '' NOT NULL,
748 template_included text NOT NULL,
749 template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
750 template_data mediumtext NOT NULL,
751 KEY tid (template_id),
752 KEY tfn (template_filename)
753 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
756 # Table: 'phpbb_styles_theme'
757 CREATE TABLE phpbb_styles_theme (
758 theme_id smallint(4) UNSIGNED NOT NULL auto_increment,
759 theme_name varchar(255) DEFAULT '' NOT NULL,
760 theme_copyright varchar(255) DEFAULT '' NOT NULL,
761 theme_path varchar(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 mediumtext NOT NULL,
765 PRIMARY KEY (theme_id),
766 UNIQUE theme_name (theme_name)
767 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
770 # Table: 'phpbb_styles_imageset'
771 CREATE TABLE phpbb_styles_imageset (
772 imageset_id smallint(4) UNSIGNED NOT NULL auto_increment,
773 imageset_name varchar(255) DEFAULT '' NOT NULL,
774 imageset_copyright varchar(255) DEFAULT '' NOT NULL,
775 imageset_path varchar(100) DEFAULT '' NOT NULL,
776 PRIMARY KEY (imageset_id),
777 UNIQUE imgset_nm (imageset_name)
778 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(200) DEFAULT '' NOT NULL,
785 image_filename varchar(200) DEFAULT '' NOT NULL,
786 image_lang varchar(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)
792 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
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 varchar(255) DEFAULT '' NOT NULL,
814 topic_first_poster_colour varchar(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 varchar(255) DEFAULT '' NOT NULL,
818 topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
819 topic_last_post_subject varchar(100) DEFAULT '' 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 varchar(255) DEFAULT '' 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)
838 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
849 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
858 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
869 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
881 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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 mediumtext NOT NULL,
890 user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
891 user_ip varchar(40) DEFAULT '' NOT NULL,
892 user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
893 username varchar(255) DEFAULT '' NOT NULL,
894 username_clean varchar(255) DEFAULT '' NOT NULL,
895 user_password varchar(40) 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 varchar(100) DEFAULT '' NOT NULL,
899 user_email_hash bigint(20) DEFAULT '0' NOT NULL,
900 user_birthday varchar(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 varchar(200) DEFAULT '' NOT NULL,
905 user_last_confirm_key varchar(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 varchar(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 varchar(30) 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 varchar(6) DEFAULT '' NOT NULL,
920 user_new_privmsg int(4) DEFAULT '0' NOT NULL,
921 user_unread_privmsg int(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 varchar(1) DEFAULT 't' NOT NULL,
928 user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL,
929 user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
930 user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL,
931 user_post_sortby_dir varchar(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 varchar(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 mediumtext NOT NULL,
945 user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
946 user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
947 user_from varchar(100) DEFAULT '' NOT NULL,
948 user_icq varchar(15) DEFAULT '' NOT NULL,
949 user_aim varchar(255) DEFAULT '' NOT NULL,
950 user_yim varchar(255) DEFAULT '' NOT NULL,
951 user_msnm varchar(255) DEFAULT '' NOT NULL,
952 user_jabber varchar(255) DEFAULT '' NOT NULL,
953 user_website varchar(200) DEFAULT '' NOT NULL,
954 user_occ text NOT NULL,
955 user_interests text NOT NULL,
956 user_actkey varchar(32) DEFAULT '' NOT NULL,
957 user_newpasswd varchar(40) DEFAULT '' NOT NULL,
958 user_form_salt varchar(32) 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)
964 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
975 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
978 # Table: 'phpbb_words'
979 CREATE TABLE phpbb_words (
980 word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
981 word varchar(255) DEFAULT '' NOT NULL,
982 replacement varchar(255) DEFAULT '' NOT NULL,
983 PRIMARY KEY (word_id)
984 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
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)
994 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;