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. |
| 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. |
