This is an old revision of the document!
Table of Contents
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. |
| 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. |
| 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. |
