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