Translations of this page: en bg cs de fi fr hu it ja pl ru tr zh

This is an old revision of the document!


Database Tables Reference

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

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.

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.

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.

Personal Tools