Database Tables Reference

The following is a complete list of all PunBB 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(80)	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	The user ID of the user that created 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.

extensions

Field	Type	Default	Description
id	varchar(50)		The primary key extension ID.
title	varchar(255)		The extension title.
version	varchar(25)		The extension version number.
description	text	NULL	A description of the extension.
author	varchar(50)		The author of the extension.
uninstall	text	NULL	PHP code that is executed when the extension is uninstalled.
uninstall_note	text	NULL	A note that is displayed to the administrator when the extension is uninstalled.
disabled	tinyint/smallint	0	0 = Extension is enabled. 1 = Extension is disabled.

extension_hooks

Field	Type	Default	Description
id	varchar(50)		The extension hook ID.
extension_id	varchar(50)		The ID of the extension the hook is a part of.
code	text	NULL	The PHP code for the hook.
installed	int	0	A UNIX timestamp representing the date/time when the hook was installed.

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/smallint	1	0 = Deny. 1 = Allow.
post_replies	tinyint/smallint	1	0 = Deny. 1 = Allow.
post_topics	tinyint/smallint	1	0 = Deny. 1 = Allow.

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/int	0	The number of topics the forum contains.
num_posts	mediumint/int	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/smallint	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/smallint	0	0 = Deny. 1 = Allow.
g_mod_edit_users	tinyint/smallint	0	0 = Deny. 1 = Allow.
g_mod_rename_users	tinyint/smallint	0	0 = Deny. 1 = Allow.
g_mod_change_password	tinyint/smallint	0	0 = Deny. 1 = Allow.
g_mod_ban_users	tinyint/smallint	0	0 = Deny. 1 = Allow.
g_read_board	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_post_replies	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_post_topics	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_edit_posts	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_delete_posts	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_delete_topics	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_set_title	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_search	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_search_users	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_send_email	tinyint/smallint	1	0 = Deny. 1 = Allow.
g_edit_subjects_interval	smallint	300	Number of seconds after post time that users in this group may edit the subject of topics they've posted.
g_post_flood	smallint	30	Number of seconds that users in this group have to wait between posts.
g_search_flood	smallint	30	Number of seconds that users in this group have to wait between searches.
g_email_flood	smallint	60	Number of seconds that users in this group have to wait between email messages.

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/smallint	0	0 = User has been active within the last "Online timeout" seconds. 1 = User has timed out.
csrf_token	varchar(40)		A randomly generated 160 bit SHA1 hash that is used for CSRF attack protection.
prev_url	varchar(255)	NULL	The URL of the previous page.

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(80)	NULL	The guest e-mail address (if supplied).
message	text		The actual message contents.
hide_smilies	tinyint/smallint	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/int	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

Note: The table search_cache exists only in PostgreSQL and SQLite installation.

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

Note: The table search_matches exists only in PostgreSQL and SQLite installation.

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

search_words

Note: The table search_words exists only in PostgreSQL and SQLite installation.

Field	Type	Default	Description
id	int		The auto-incrementing (identity) primary key 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 in the topic (i.e. the topic post).
last_post	int	0	A UNIX timestamp representing the date/time the last post was made in the topic.
last_post_id	int	0	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/int	0	The number of times the topic has been viewed.
num_replies	mediumint/int	0	The number of replies that have been posted in the topic.
closed	tinyint/smallint	0	0 = Topic is open. 1 = Topic is closed.
sticky	tinyint/smallint	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 password salt.
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/smallint	NULL	The number of topics to display on forum page (uses forum default if left blank).
disp_posts	tinyint/smallint	NULL	The number of posts to display on topic page (uses forum default if left blank).
email_setting	tinyint/smallint	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.
save_pass	tinyint/smallint	1	0 = Don't remember user between visits. 1 = Remember user between visits.
notify_with_post	tinyint/smallint	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/smallint	0	0 = Default to not subscribe to topics the user posts in. 1 = Default to subscribe to topics the user posts in.
show_smilies	tinyint/smallint	1	Show smilies as images.
show_img	tinyint/smallint	1	Show images in posts.
show_img_sig	tinyint/smallint	1	Show images in signatures.
show_avatars	tinyint/smallint	1	Show avatars.
show_sig	tinyint/smallint	1	Show signatures.
timezone	float	0	The user's timezone.
dst	tinyint/smallint	0	0 = Daylight Savings Time is not in effect. 1 = Daylight Savings Time is in effect.
time_format	int	0	The user's preferred time format.
date_format	int	0	The user's preferred date format.
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	NULL	A UNIX timestamp representing the date/time the last search was performed by the user.
last_email_sent	int	NULL	A UNIX timestamp representing the date/time the last email was sent by the user.
registered	int	0	A UNIX timestamp representing the date the user registered.
registration_ip	varchar(15)	'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.