group_id

MEDIUMINT

references phpbb_groups.group_id

forum_id

MEDIUMINT

references phpbb_forums.forum_id

auth_option_id

MEDIUMINT

references phpbb_acl_options.auth_option_id

auth_role_id

MEDIUMINT

references phpbb_acl_roles.role_id

auth_setting

TINYINT

ACL_YES, ACL_NO or ACL_NEVER

auth_option_id

PKMEDIUMINT

primary key

auth_option

VARCHAR

the name of the permission, e.g. "f_post"

is_global

TINYINT

this permission can be granted globally (once for all forums)

is_local

TINYINT

this permission can be granted locally (individual setting for each forum)

founder_only

TINYINT

only founders can have this permission

role_id

PKMEDIUMINT

primary key

role_name

VARCHAR

Name of this role, can also be a language string

role_description

TEXT

description of this role, can also be a language string

role_type

VARCHAR

role_order

SMALLINT

role_id

PKMEDIUMINT

primary key

auth_option_id

PKMEDIUMINT

primary key

auth_setting

TINYINT

ACL_YES, ACL_NO or ACL_NEVER

user_id

MEDIUMINT

references phpbb_users.user_id

forum_id

MEDIUMINT

references phpbb_forums.forum_id

auth_option_id

MEDIUMINT

references phpbb_acl_options.auth_option_id

auth_role_id

MEDIUMINT

references phpbb_acl_roles.role_id

auth_setting

TINYINT

ACL_YES, ACL_NO or ACL_NEVER

attach_id

PKMEDIUMINT

primary key

post_msg_id

MEDIUMINT

references phpbb_posts.post_id

topic_id

MEDIUMINT

references phpbb_topics.topic_id

in_message

TINYINT

1 if attachment is used inside private message, 0 if used inside post

poster_id

MEDIUMINT

references phpbb_users.user_id

is_orphan

TINYINT

1 if attachment is unused (user left posting.php without submiting post)

physical_filename

VARCHAR

name of the file stored inside the $config['upload_path'] directory

real_filename

VARCHAR

name of the file before the user uploaded it

download_count

MEDIUMINT

how many times was this attachment downloaded/viewed

attach_comment

TEXT

comment

extension

VARCHAR

self explaining

mimetype

VARCHAR

mime-type

filesize

INT

file size in bytes

filetime

INT

unix timestamp

thumbnail

TINYINT

has this attachment a thumbnail (1/0)? The thumbnails physical filename is prefixed with thumb_

ban_id

PKMEDIUMINT

primary key

ban_userid

MEDIUMINT

ban_ip

VARCHAR

ban_email

VARCHAR

ban_start

INT

ban_end

INT

ban_exclude

TINYINT

ban_reason

VARCHAR

ban_give_reason

VARCHAR

bbcode_id

PKTINYINT

primary key

bbcode_tag

VARCHAR

bbcode_helpline

VARCHAR

display_on_posting

TINYINT

bbcode_match

TEXT

bbcode_tpl

MEDIUMTEXT

first_pass_match

MEDIUMTEXT

first_pass_replace

MEDIUMTEXT

second_pass_match

MEDIUMTEXT

second_pass_replace

MEDIUMTEXT

topic_id

PKMEDIUMINT

user_id

PKMEDIUMINT

bot_id

PKMEDIUMINT

primary key

bot_active

TINYINT

bot_name

VARCHAR

user_id

MEDIUMINT

primary key

bot_agent

VARCHAR

bot_ip

VARCHAR

config_name

PKVARCHAR

primary key

config_value

VARCHAR

Value of config

is_dynamic

TINYINT

Is dynamic?

confirm_id

PKCHAR

primary key

session_id

PKCHAR

primary key

confirm_type

TINYINT

code

VARCHAR

seed

INT

disallow_id

PKMEDIUMINT

primary key

disallow_username

VARCHAR

draft_id

PKMEDIUMINT

primary key

user_id

MEDIUMINT

topic_id

MEDIUMINT

forum_id

MEDIUMINT

save_time

INT

draft_subject

VARCHAR

draft_message

MEDIUMTEXT

group_id

PKMEDIUMINT

primary key

group_name

VARCHAR

cat_id

TINYINT

allow_group

TINYINT

download_mode

TINYINT

upload_icon

VARCHAR

max_filesize

INT

allowed_forums

TEXT

allow_in_pm

TINYINT

extension_id

PKMEDIUMINT

primary key

group_id

MEDIUMINT

extension

VARCHAR

forum_id

PKMEDIUMINT

primary key

parent_id

MEDIUMINT

the forum_id of the parent forum (or category)

left_id

MEDIUMINT

forum_id of the forum left to the current forum in the binary tree (used e. g. to retrieve the list of all parents very fast to create the forum navigation)

right_id

MEDIUMINT

forum_id of the forum right to the current forum in the binary tree (used e. g. to retrieve the list of all parents very fast to create the forum navigation)

forum_parents

MEDIUMTEXT

Holds an serialized array of parent forums name, id
and type, used for generating forum navigation.

forum_name

VARCHAR

forum_desc

TEXT

forum_desc_bitfield

VARCHAR

see Parsing text

forum_desc_options

INT

see Parsing text

forum_desc_uid

VARCHAR

see Parsing text

forum_link

VARCHAR

forum_password

VARCHAR

forum_style

MEDIUMINT

forum_image

VARCHAR

forum_rules

TEXT

forum_rules_link

VARCHAR

forum_rules_bitfield

VARCHAR

see Parsing text

forum_rules_options

INT

see Parsing text

forum_rules_uid

VARCHAR

see Parsing text

forum_topics_per_page

TINYINT

forum_type

TINYINT

category (forum_type = FORUM_CAT = 0) or forum (forum_type = FORUM_POST = 1) or link (forum_type = FORUM_LINK = 2)

forum_status

TINYINT

forum_posts

MEDIUMINT

forum_topics

MEDIUMINT

forum_topics_real

MEDIUMINT

forum_last_post_id

MEDIUMINT

forum_last_poster_id

MEDIUMINT

forum_last_post_subject

VARCHAR

forum_last_post_time

INT

forum_last_poster_name

VARCHAR

forum_last_poster_colour

VARCHAR

forum_flags

TINYINT

display_subforum_list

TINYINT

display_on_index

TINYINT

enable_indexing

TINYINT

enable_icons

TINYINT

enable_prune

TINYINT

prune_next

INT

prune_days

MEDIUMINT

prune_viewed

MEDIUMINT

prune_freq

MEDIUMINT

forum_id

PKMEDIUMINT

primary key

user_id

PKMEDIUMINT

primary key

session_id

PKCHAR

primary key

user_id

PKMEDIUMINT

primary key

forum_id

PKMEDIUMINT

primary key

mark_time

INT

forum_id

MEDIUMINT

user_id

MEDIUMINT

notify_status

TINYINT

group_id

PKMEDIUMINT

primary key

group_type

TINYINT

group_founder_manage

TINYINT

group_name

VARCHAR

group_desc

TEXT

group_desc_bitfield

VARCHAR

group_desc_options

INT

group_desc_uid

VARCHAR

group_display

TINYINT

group_avatar

VARCHAR

group_avatar_type

TINYINT

group_avatar_width

SMALLINT

group_avatar_height

SMALLINT

group_rank

MEDIUMINT

group_colour

VARCHAR

group_sig_chars

MEDIUMINT

group_receive_pm

TINYINT

group_message_limit

MEDIUMINT

group_max_recipients

MEDIUMINT

group_legend

TINYINT

icons_id

PKMEDIUMINT

primary key

icons_url

VARCHAR

icons_width

TINYINT

icons_height

TINYINT

icons_order

MEDIUMINT

display_on_posting

TINYINT

lang_id

PKTINYINT

primary key

lang_iso

VARCHAR

lang_dir

VARCHAR

lang_english_name

VARCHAR

lang_local_name

VARCHAR

lang_author

VARCHAR

log_id

PKMEDIUMINT

primary key

log_type

TINYINT

user_id

MEDIUMINT

forum_id

MEDIUMINT

topic_id

MEDIUMINT

reportee_id

MEDIUMINT

log_ip

VARCHAR

log_time

INT

log_operation

TEXT

log_data

MEDIUMTEXT

forum_id

MEDIUMINT

user_id

MEDIUMINT

username

VARCHAR

group_id

MEDIUMINT

group_name

VARCHAR

display_on_index

TINYINT

module_id

PKMEDIUMINT

primary key

module_enabled

TINYINT

module_display

TINYINT

module_basename

VARCHAR

module_class

VARCHAR

parent_id

MEDIUMINT

left_id

MEDIUMINT

right_id

MEDIUMINT

module_langname

VARCHAR

module_mode

VARCHAR

module_auth

VARCHAR

poll_option_id

TINYINT

topic_id

MEDIUMINT

poll_option_text

TEXT

poll_option_total

MEDIUMINT

topic_id

MEDIUMINT

poll_option_id

TINYINT

vote_user_id

MEDIUMINT

vote_user_ip

VARCHAR

post_id

PKMEDIUMINT

primary key

topic_id

MEDIUMINT

forum_id

MEDIUMINT

poster_id

MEDIUMINT

icon_id

MEDIUMINT

poster_ip

VARCHAR

post_time

INT

post_approved

TINYINT

post_reported

TINYINT

enable_bbcode

TINYINT

enable_smilies

TINYINT

enable_magic_url

TINYINT

enable_sig

TINYINT

post_username

VARCHAR

post_subject

VARCHAR

post_text

MEDIUMTEXT

post_checksum

VARCHAR

post_attachment

TINYINT

bbcode_bitfield

VARCHAR

see Parsing text

bbcode_uid

VARCHAR

see Parsing text

post_postcount

TINYINT

post_edit_time

INT

post_edit_reason

VARCHAR

post_edit_user

MEDIUMINT

post_edit_count

SMALLINT

post_edit_locked

TINYINT

msg_id

PKMEDIUMINT

primary key

root_level

MEDIUMINT

the initial message in this message chain (i.e. if you write messages A -> B (reply to A) -> C (reply to B), then B and C will have root_level=msg_id of A

author_id

MEDIUMINT

references phpbb_users.user_id

icon_id

MEDIUMINT

references phpbb_icons.icons_id

author_ip

VARCHAR

ip address of sender

message_time

INT

unix timestamp

enable_bbcode

TINYINT

bbcode enabled? 1/0

enable_smilies

TINYINT

smilies enabled? 1/0

enable_magic_url

TINYINT

automatically convert urls to links? 1/0

enable_sig

TINYINT

attach signature? 1/0

message_subject

VARCHAR

subject

message_text

MEDIUMTEXT

the message itself

message_edit_reason

VARCHAR

reason for editing

message_edit_user

MEDIUMINT

who edited this message

message_attachment

TINYINT

does the message have files attached? 1/0

bbcode_bitfield

VARCHAR

see Parsing text

bbcode_uid

VARCHAR

see Parsing text

message_edit_time

INT

message_edit_count

SMALLINT

to_address

TEXT

colon separated list of recipients, e.g. u_1:u_23:g_5

bcc_address

TEXT

see to_address

folder_id

PKMEDIUMINT

primary key

user_id

MEDIUMINT

folder_name

VARCHAR

pm_count

MEDIUMINT

rule_id

PKMEDIUMINT

primary key

user_id

MEDIUMINT

rule_check

MEDIUMINT

rule_connection

MEDIUMINT

rule_string

VARCHAR

rule_user_id

MEDIUMINT

rule_group_id

MEDIUMINT

rule_action

MEDIUMINT

rule_folder_id

INT

msg_id

MEDIUMINT

user_id

MEDIUMINT

author_id

MEDIUMINT

pm_deleted

TINYINT

pm_new

TINYINT

pm_unread

TINYINT

pm_replied

TINYINT

pm_marked

TINYINT

pm_forwarded

TINYINT

folder_id

INT

field_id

PKMEDIUMINT

primary key

field_name

VARCHAR

field_type

TINYINT

field_ident

VARCHAR

field_length

VARCHAR

field_minlen

VARCHAR

field_maxlen

VARCHAR

field_novalue

VARCHAR

field_default_value

VARCHAR

field_validation

VARCHAR

field_required

TINYINT

field_show_on_reg

TINYINT

field_show_profile

TINYINT

field_hide

TINYINT

field_no_view

TINYINT

field_active

TINYINT

field_order

MEDIUMINT

user_id

PKMEDIUMINT

primary key

field_id

PKMEDIUMINT

primary key

lang_id

PKMEDIUMINT

primary key

option_id

PKMEDIUMINT

primary key

field_type

TINYINT

lang_value

VARCHAR

field_id

PKMEDIUMINT

primary key

lang_id

PKMEDIUMINT

primary key

lang_name

VARCHAR

lang_explain

TEXT

lang_default_value

VARCHAR

rank_id

PKMEDIUMINT

primary key

rank_title

VARCHAR

rank_min

MEDIUMINT

rank_special

TINYINT

rank_image

VARCHAR

report_id

PKMEDIUMINT

primary key

reason_id

SMALLINT

post_id

MEDIUMINT

user_id

MEDIUMINT

user_notify

TINYINT

report_closed

TINYINT

report_time

INT

report_text

MEDIUMTEXT

reason_id

PKSMALLINT

primary key

reason_title

VARCHAR

reason_description

MEDIUMTEXT

reason_order

SMALLINT

search_key

PKVARCHAR

primary key

search_time

INT

search_keywords

MEDIUMTEXT

search_authors

MEDIUMTEXT

word_id

PKMEDIUMINT

primary key

word_text

VARCHAR

word_common

TINYINT

word_count

MEDIUMINT

post_id

MEDIUMINT

word_id

MEDIUMINT

title_match

TINYINT

session_id

PKCHAR

primary key

session_user_id

MEDIUMINT

session_forum_id

MEDIUMINT

session_last_visit

INT

session_start

INT

session_time

INT

session_ip

VARCHAR

session_browser

VARCHAR

session_forwarded_for

VARCHAR

session_page

VARCHAR

session_viewonline

TINYINT

session_autologin

TINYINT

session_admin

TINYINT

key_id

PKCHAR

primary key

user_id

PKMEDIUMINT

primary key

last_ip

VARCHAR

last_login

INT

site_id

PKMEDIUMINT

primary key

site_ip

VARCHAR

site_hostname

VARCHAR

ip_exclude

TINYINT

smiley_id

PKMEDIUMINT

primary key

code

VARCHAR

emotion

VARCHAR

smiley_url

VARCHAR

smiley_width

SMALLINT

smiley_height

SMALLINT

smiley_order

MEDIUMINT

display_on_posting

TINYINT

style_id

PKMEDIUMINT

primary key

style_name

VARCHAR

style_copyright

VARCHAR

style_active

TINYINT

template_id

MEDIUMINT

theme_id

MEDIUMINT

imageset_id

MEDIUMINT

imageset_id

PKMEDIUMINT

imageset_name

VARCHAR

imageset_copyright

VARCHAR

imageset_path

VARCHAR

image_id

PKMEDIUMINT

primary key

image_name

VARCHAR

image_filename

VARCHAR

image_lang

VARCHAR

image_height

SMALLINT

image_width

SMALLINT

imageset_id

MEDIUMINT

template_id

PKMEDIUMINT

primary key

template_name

VARCHAR

template_copyright

VARCHAR

template_path

VARCHAR

bbcode_bitfield

VARCHAR

template_storedb

TINYINT

template_inherits_id

INT

template_inherit_path

VARCHAR

template_id

MEDIUMINT

template_filename

VARCHAR

template_included

TEXT

template_mtime

INT

template_data

MEDIUMTEXT

theme_id

PKMEDIUMINT

primary key

theme_name

VARCHAR

theme_copyright

VARCHAR

theme_path

VARCHAR

theme_storedb

TINYINT

theme_mtime

INT

theme_data

MEDIUMTEXT

topic_id

PKMEDIUMINT

primary key

forum_id

MEDIUMINT

references phpbb_forums.forum_id

icon_id

MEDIUMINT

references phpbb_icons.icon_id

topic_attachment

TINYINT

1=at least one post in this topic has attachment
0=no attachments in this topic

topic_approved

TINYINT

topic_reported

TINYINT

topic_title

VARCHAR

topic_poster

MEDIUMINT

references phpbb_users.user_id

topic_time

INT

topic_time_limit

INT

topic_views

MEDIUMINT

topic_replies

MEDIUMINT

the number of approved replies to this topic

topic_replies_real

MEDIUMINT

total replies to this topic (including posts waiting for approval)

topic_status

TINYINT

ITEM_UNLOCKED(0), ITEM_LOCKED(1) or ITEM_MOVED(2)

topic_type

TINYINT

POST_NORMAL(0), POST_STICKY(1), POST_ANNOUNCE(2) or POST_GLOBAL(3)
note that when topic_type is POST_GLOBAL (global announcement), then forum_id must be 0

topic_first_post_id

MEDIUMINT

references phpbb_posts.post_id

topic_first_poster_name

VARCHAR

topic_first_poster_colour

VARCHAR

topic_last_post_id

MEDIUMINT

references phpbb_posts.post_id

topic_last_poster_id

MEDIUMINT

references phpbb_users.user_id

topic_last_poster_name

VARCHAR

topic_last_poster_colour

VARCHAR

topic_last_post_subject

VARCHAR

topic_last_post_time

INT

unix timestamp

topic_last_view_time

INT

unix timestamp

topic_moved_id

MEDIUMINT

if topic_status is ITEM_MOVED, this field contains the topic id of the real topic

topic_bumped

TINYINT

has this topic been bumped? 1 (yes), 0(no)

topic_bumper

MEDIUMINT

references phpbb_users.user_id

poll_title

VARCHAR

poll_start

INT

unix timestamp

poll_length

INT

unix timestamp

poll_max_options

TINYINT

how many poll options can each user choose

poll_last_vote

INT

unix timestamp

poll_vote_change

TINYINT

are users allowed to change their vote(s)? 1 (yes), 0(no)

user_id

PKMEDIUMINT

primary key

topic_id

PKMEDIUMINT

primary key

topic_posted

TINYINT

user_id

PKMEDIUMINT

FOREIGN KEY, REFERENCES 'phpbb_users'

topic_id

PKMEDIUMINT

FOREIGN KEY, REFERENCES 'phpbb_topics'

forum_id

MEDIUMINT

FOREIGN KEY, REFERENCES 'phpbb_forums'

mark_time

INT

Last visit to this topic (timestamp)

topic_id

MEDIUMINT

user_id

MEDIUMINT

notify_status

TINYINT

group_id

MEDIUMINT

references phpbb_groups.group_id

user_id

MEDIUMINT

references phpbb_users.user_id

group_leader

TINYINT

1 (true) if this user is a group leader

user_pending

TINYINT

1 (true) if the user is waiting for approval

user_id

PKMEDIUMINT

primary key

user_type

TINYINT

Defines what type user is. 0 is normal user, 1 is inactive and needs to activate thier account through an activation link sent in an email, 2 is pre-defined type (i.e. bot) 3 is Founder.

group_id

MEDIUMINT

The user's default group.

user_permissions

MEDIUMTEXT

user_perm_from

MEDIUMINT

user_ip

VARCHAR

The IP of the user on registration, dotted QUAD style (ie: 127.0.0.1)

user_regdate

INT

User's registration date/time, UNIX timestamp

username

VARCHAR

the username as it is shown all over the board

username_clean

VARCHAR

The all lower-case normalized version of the username for comparisons.

user_password

VARCHAR

The hashed version of the user's pass

user_passchg

INT

user_pass_convert

TINYINT

user_email

VARCHAR

user's email on registration, PLAIN text

user_email_hash

BIGINT

user_birthday

VARCHAR

user_lastvisit

INT

User's last visit time, UNIX timestamp.

user_lastmark

INT

the last time the user clicked "Mark forums read"

user_lastpost_time

INT

the time of the latest post of the user, UNIX timestamp

user_lastpage

VARCHAR

user_last_confirm_key

VARCHAR

code used for security reasons by confirmation windows

user_last_search

INT

user_warnings

TINYINT

user_last_warning

INT

Warnings the user has

user_login_attempts

TINYINT

user_inactive_reason

TINYINT

Reason for being inactive

user_inactive_time

INT

user_posts

MEDIUMINT

Amount of posts the user has posted

user_lang

VARCHAR

The language the user uses default on the board

user_timezone

DECIMAL

user_dst

TINYINT

Is the user on Daylight Savings Time

user_dateformat

VARCHAR

How dates are shown in the user's format

user_style

MEDIUMINT

Style user uses to browse the board

user_rank

MEDIUMINT

User's rank

user_colour

VARCHAR

User's colour

user_new_privmsg

INT

user_unread_privmsg

INT

user_last_privmsg

INT

user_message_rules

TINYINT

user_full_folder

INT

user_emailtime

INT

user_topic_show_days

SMALLINT

Preferences for reading

user_topic_sortby_type

VARCHAR

Preferences for reading

user_topic_sortby_dir

VARCHAR

Preferences for reading

user_post_show_days

SMALLINT

Preferences for reading

user_post_sortby_type

VARCHAR

Preferences for reading

user_post_sortby_dir

VARCHAR

Preferences for reading

user_notify

TINYINT

user_notify_pm

TINYINT

user_notify_type

TINYINT

user_allow_pm

TINYINT

user_allow_viewonline

TINYINT

user_allow_viewemail

TINYINT

user_allow_massemail

TINYINT

user_options

INT

user_avatar

VARCHAR

user_avatar_type

TINYINT

user_avatar_width

SMALLINT

user_avatar_height

SMALLINT

user_sig

MEDIUMTEXT

user_sig_bbcode_uid

VARCHAR

Needed to render the signature.

user_sig_bbcode_bitfield

VARCHAR

Needed to render the signature.

user_from

VARCHAR

User's location field value

user_icq

VARCHAR

User's ICQ field value

user_aim

VARCHAR

User's AIM field value

user_yim

VARCHAR

User's YIM field value

user_msnm

VARCHAR

User's MSN field value

user_jabber

VARCHAR

User's Jabber field value

user_website

VARCHAR

User's website field value

user_occ

TEXT

User's occupation field value

user_interests

TEXT

User's interests field value

user_actkey

VARCHAR

user_newpasswd

VARCHAR

user_form_salt

VARCHAR

warning_id

PKMEDIUMINT

primary key

user_id

MEDIUMINT

post_id

MEDIUMINT

log_id

MEDIUMINT

warning_time

INT

word_id

PKMEDIUMINT

primary key

word

VARCHAR

replacement

VARCHAR

user_id

PKMEDIUMINT

zebra_id

PKMEDIUMINT

friend

TINYINT

foe

TINYINT