Differences
This shows you the differences between the selected revision and the current version of the page.
| punbb12:database_tables_reference 2009/07/09 02:34 | punbb12:database_tables_reference 2020/02/06 11:04 current | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== Database Tables Reference ===== | ===== 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. | The following is a complete list of all PunBB 1.2 database tables and their respective fields. Primary key fields are underlined. | ||
| + | |||
| + | ==== bans ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ||
| | __id__ | int | | The auto-incrementing (identity) primary key identifier for this table. | | | __id__ | int | | The auto-incrementing (identity) primary key identifier for this table. | | ||
| Line 161: | Line 163: | ||
| | forum_id | int | 0 | The forum in which the topic resides. | | | 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. | | ||
| - | | email | varchar(50) | | 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(75) | NULL | The user's Jabber address. | | ||
| - | | icq | varchar(12) | NULL | The user's ICQ UIN. | | ||
| - | | msn | varchar(50) | 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. | | ||
| - | | use_avatar | tinyint/smallint | 0 | 0 = Don't show avatar to other users. 1 = Show avatar to other users. | | ||
| - | | 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. | | ||
| - | | 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. | | ||
| - | | 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. | | ||
| - | | 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(50) | 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. | | ||
| ==== users ==== | ==== users ==== | ||
