Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Database tables reference

KANekT edited this page · 1 revision

Database Tables Reference

The following is a complete list of all PunBB 1.3 database tables and their respective fields. Primary key fields are underlined.

bans

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
username varchar(200) NULL The username this ban applies to.
ip varchar(255) NULL The IP address(es) or partial IP address(es) this ban applies to.
email varchar(50) NULL The e-mail address or e-mail address domain name this ban applies to.
message varchar(255) NULL A message that is displayed for the banned user.
expire int NULL A UNIX timestamp representing the day when the ban expires.
ban_creator int 0 An ID number of user who create the ban.

categories

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
cat_name varchar(80) 'New Category' The name of the category.
disp_position int 0 The vertical display position of the category (relative to other categories).

censoring

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
search_for varchar(60) The term to search for.
replace_with varchar(60) The term to replace search_for with.

config

Field Type Default Description
conf_name varchar(255) The name of a configuration variable. General configuration options start with the prefix o_ and general permission options start with p_.
conf_value text NULL The value of the configuration variable conf_name.

extension_hooks

Field Type Default Description
id varchar(150) The name of hook of extension.
extension_id carchar(50) The name of extension.
code text NULL The code which will place into the hook.
installed int 0 The UNIX timestamp representing the day when the extension was installed.
priority tinyint 5 The priority of hook.

extensions

Field Type Default Description
id varchar(150) The identificator of extension which is used in the code of extension.
title varchar(255) The official name of extension.
version varchar(25) The version of extension.
description text NULL The description of extension whick containe short functionality of extension.
author varchar(50) The author or group of authors of extension.
uninstall text NULL The script for uninstall extension.
uninstall_note text NULL
disabled tinyint 0 The status of extension - enable or disable.
dependencies varchar(255) The dependence extensions which work specify extension.

forum_perms

Field Type Default Description
group_id int The user group for which these permissions apply. Primary key identifier together with forum_id for this table.
forum_id int The forum in which these permissions apply. Primary key identifier together with group_id for this table.
read_forum tinyint 1 Allow type of users to read forum.
post_replies tinyint 1 Allow type of users to post replies in topics.
post_topics tinyint 1 Allow type of users to post topics in forums.

forums

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
forum_name varchar(80) 'New forum' The name of the forum.
forum_desc text NULL A description of the forum.
redirect_url varchar(100) NULL The URL to redirect users to upon clicking the forum link on the index page.
moderators text NULL A serialized PHP array of moderators.
num_topics mediumint 0 The number of topics the forum contains.
num_posts mediumint 0 The number of posts the forum contains.
last_post int NULL A UNIX timestamp representing the date/time the last post was made in the forum.
last_post_id int NULL The ID of the last post that was made in the forum.
last_poster varchar(200) NULL The username (or guest name) of the user that made the last post in the forum.
sort_by tinyint 0 0 = Display topics sorted by last post. 1 = Display topics sorted by topic start.
disp_position int 0 The vertical display position of the forum (relative to other forums in the same category).
cat_id int 0 The category in which the forum resides.

groups

Field Type Default Description
g_id int The auto-incrementing (identity) primary key identifier for this table.
g_title varchar(50) The name of the group.
g_user_title varchar(50) NULL The title of users in this group.
g_moderator tinyint 0 Allow users moderator privileges. In order for a user in this group to have moderator abilities, he/she must be assigned to moderate one or more forums.
g_mod_edit_users tinyint 0 Allow moderators to edit user profiles.
g_mod_rename_users tinyint 0 Allow moderators to rename users.
g_mod_change_passwords tinyint 0 Allow moderators to change user passwords.
g_mod_ban_users tinyint 0 Allow moderators to ban users.
g_read_board tinyint 1 Allow users to view the board.
g_view_users tinyint 1 Allow users to view the user list and user profiles.
g_post_replies tinyint 1 Allow users to post replies in topics.
g_post_topics tinyint 1 Allow users to post a new topics.
g_edit_posts tinyint 1 Allow users to edit their own posts.
g_delete_posts tinyint 1 Allow users to delete their own posts.
g_delete_topics tinyint 1 Allow users to delete their own topics (including any replies).
g_set_title tinyint 1 Allow users to set their own user titles.
g_search tinyint 1 Allow users to use the search feature.
g_search_users tinyint 1 Allow users to freetext search for users in the user list.
g_send_email tinyint 1 Allow users to send e-mails to other users.
g_post_flood tinyint 30 Number of seconds that users in this group have to wait between posts.
g_search_flood tinyint 30 Number of seconds that users in this group have to wait between searches.
g_email_flood tinyint 60 Number of seconds that users in this group have to wait between e-mails. Set to 0 to disable.

online

Field Type Default Description
user_id int 1 ID of the user (always 1 for guests).
ident varchar(200) Identification string for the user. Username for logged in users and IP address for guests.
logged int 0 A UNIX timestamp representing the date/time for the user's last activity.
idle tinyint 0 0 = User has been active within the last “Online timeout” seconds. 1 = User has timed out.
csrf_token varchar(40) The random line which used for autentification and is active for session of user.
prev_url varchar(255) NULL The link for previous URL.
last_post int NULL The ID of last post which user post in topic.
last_search int NULL The ID of last users search.

posts

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
poster varchar(200) The username (or guest name) of the user that made the post.
poster_id int 1 The user ID of the user that made the post (always 1 for guests).
poster_ip varchar(15) NULL The IP address the post was made from.
poster_email varchar(50) NULL The guest e-mail address (if supplied).
message text The actual message contents.
hide_smilies tinyint 0 0 = Let users decide whether to show smilies as images or not in this post. 1 = Never show smilies as images in this post.
posted int 0 A UNIX timestamp representing the date/time the post was made.
edited int NULL A UNIX timestamp representing the date/time the post was last edited.
edited_by varchar(200) NULL The username of the user that last edited the post.
topic_id int 0 The topic ID in which the post resides.

ranks

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
rank varchar(50) The rank title.
min_posts mediumint 0 The number of posts a user must attain in order to reach the rank.

reports

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
post_id int 0 The post the report relates to.
topic_id int 0 The topic in which the reported post resides in.
forum_id int 0 The forum in which the reported post resides in.
reported_by int 0 The user ID of the user that reported the post.
created int 0 A UNIX timestamp representing the date/time the post was last edited.
message text The report message.
zapped int NULL A UNIX timestamp representing the date/time the report was zapped (marked as read).
zapped_by int NULL The username of the administrator or moderator that zapped the report.

search_cache

Field Type Default Description
id int 0 The primary key identifier for this table.
ident varchar(200) Identification string for the searcher. Username for logged in users and IP address for guests.
search_data text A serialized PHP array of search data (e.g. post ID's, sort direction etc.).

search_matches

Field Type Default Description
post_id int 0 The post this match relates to.
word_id mediumint 0 The word this match relates to.
subject_match tinyint 0 0 = Match is in the post message. 1 = Match is in the topic subject.

search_words

Field Type Default Description
id mediumint An integer identifier for this table.
word varchar(20) The indexed word (primary key).

subscriptions

Field Type Default Description
user_id int 0 The user that subscribes to topic_id. Primary key identifier together with topic_id for this table.
topic_id int 0 The topic user_id subscribes to. Primary key identifier together with user_id for this table.

topics

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
poster varchar(200) The username (or guest name) of the user that posted the topic.
subject varchar(255) The topic subject.
posted int 0 A UNIX timestamp representing the date/time the topic was posted.
first_post_id int 0 The ID of the first post that was made with the topic.
last_post int NULL A UNIX timestamp representing the date/time the last post was made in the topic.
last_post_id int NULL The ID of the last post that was made in the topic.
last_poster varchar(200) NULL The username (or guest name) of the user that made the last post in the topic.
num_views mediumint 0 The number of times the topic has been viewed.
num_replies mediumint 0 The number of replies that have been posted in the topic.
closed tinyint 0 0 = Topic is open. 1 = Topic is closed.
sticky tinyint 0 0 = Topic is a regular topic. 1 = Topic is a sticky topic.
moved_to int NULL The forum to which the topic has been moved.
forum_id int 0 The forum in which the topic resides.

users

Field Type Default Description
id int The auto-incrementing (identity) primary key identifier for this table.
group_id int 4 The user group to which this user belongs.
username varchar(200) The user's username.
password varchar(40) The user password as an 40 byte SHA1 hash or an 32 byte MD5 hash.
salt varchar(12) NULL The random secure line for generation specify csrf-token for user.
email varchar(80) The user e-mail address.
title varchar(50) NULL The user custom title.
realname varchar(40) NULL The user's name.
url varchar(100) NULL A link to the user's website.
jabber varchar(80) NULL The user's Jabber address.
icq varchar(12) NULL The user's ICQ UIN.
msn varchar(80) NULL The user's MSN Messenger e-mail address.
aim varchar(30) NULL The user's AOL Instant Messenger username.
yahoo varchar(30) NULL The user's Yahoo Messenger username.
location varchar(30) NULL The user's geographical location.
signature text NULL The user's signature.
disp_topics tinyint NULL The number of topics to display on forum page (uses forum default if left blank).
disp_posts tinyint NULL The number of posts to display on topic page (uses forum default if left blank).
email_setting tinyint 1 0 = Show e-mail address to other users. 1 = Hide e-mail address, but allow form e-mail. 2 = Hide e-mail address and disallow form e-mail.
notify_with_post tinyint 0 0 = Include only topic subject in subscription notification e-mails. 1 = Include both topic subject and post content in subscription notification e-mails.
auto_notify tinyint 0 Subscribe to topics by default when posting.
show_smilies tinyint 1 Show smilies as images.
show_img tinyint 1 Show images in posts.
show_img_sig tinyint 1 Show images in signatures.
show_avatars tinyint 1 Show avatars.
show_sig tinyint 1 Show signatures.
access_keys tinyint 0
timezone float 0 The user's timezone.
dst tinyint 0 Enable the DST effect (DST Daylight Saving Time). Advance times by 1 hour.
time_format int 0 Set the specify format of time for user.
date_format int 0 Set the specify format of date for user.
language varchar(25) 'English' The user's preferred language for the forum UI.
style varchar(25) 'Oxygen' The user's preferred style.
num_posts int 0 The number of posts the user has made.
last_post int NULL A UNIX timestamp representing the date/time the last post by the user was made.
last_search int 0 The ID of last search which has used by user.
last_email_sent int 0 The ID of last email which user sent.
registered int 0 A UNIX timestamp representing the date the user registered.
registration_ip varchar(39) 0.0.0.0 The IP address used when registering.
last_visit int 0 A UNIX timestamp representing the date/time the last visit by the user commenced.
admin_note varchar(30) NULL A user note only viewable and editable by administrators and moderators.
activate_string varchar(80) NULL A temporary storage string for new passwords and new e-mail addresses.
activate_key varchar(8) NULL A temporary storage string for new password and new e-mail address activation keys.
Something went wrong with that request. Please try again.