Differences
This shows you the differences between the selected revision and the current version of the page.
| punbb13:database_tables_reference 2009/07/16 15:35 | punbb13:database_tables_reference 2020/02/06 11:04 current | ||
|---|---|---|---|
| Line 10: | Line 10: | ||
| | message | varchar(255) | NULL | A message that is displayed for the banned user. | | | 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. | | | 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| | + | | ban_creator | int | 0 | An ID number of user who create the ban. | |
| ==== categories ==== | ==== categories ==== | ||
| Line 196: | Line 196: | ||
| | moved_to | int | NULL | The forum to which the topic has been moved. | | | moved_to | int | NULL | The forum to which the topic has been moved. | | ||
| | forum_id | int | 0 | The forum in which the topic resides. | | | forum_id | int | 0 | The forum in which the topic resides. | | ||
| - | |||
| - | |||
| - | |||
| ==== users ==== | ==== users ==== | ||
| Line 222: | Line 219: | ||
| | 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. | | | 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. | | | 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 | | | + | | auto_notify | tinyint | 0 | Subscribe to topics by default when posting. | |
| | show_smilies | tinyint | 1 | Show smilies as images. | | | show_smilies | tinyint | 1 | Show smilies as images. | | ||
| | show_img | tinyint | 1 | Show images in posts. | | | show_img | tinyint | 1 | Show images in posts. | | ||
| Line 228: | Line 225: | ||
| | show_avatars | tinyint | 1 | Show avatars. | | | show_avatars | tinyint | 1 | Show avatars. | | ||
| | show_sig | tinyint | 1 | Show signatures. | | | show_sig | tinyint | 1 | Show signatures. | | ||
| - | | access_key | tinyint | 0 | | | + | | access_keys | tinyint | 0 | | |
| | timezone | float | 0 | The user's timezone. | | | timezone | float | 0 | The user's timezone. | | ||
| - | | dst | tinyint | 0 | | | + | | 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. | | | time_format | int | 0 | Set the specify format of time for user. | | ||
| | date_format | int | 0 | Set the specify format of date for user. | | | date_format | int | 0 | Set the specify format of date for user. | | ||
