Differences
This shows you the differences between the selected revision and the current version of the page.
| punbb13:database_tables_reference 2009/07/09 15:27 | punbb13: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.3 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 ==== | ==== bans ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ||
| 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 | NULL | The user ID that creates the ban. | | + | | ban_creator | int | 0 | An ID number of user who create the ban. | |
| ==== categories ==== | ==== categories ==== | ||
| Line 31: | Line 31: | ||
| | __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_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. | | | 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 ==== | ==== forum_perms ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **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. | | + | | __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. | | + | | __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. | | + | | read_forum | tinyint | 1 | Allow type of users to read forum. | |
| - | | post_replies | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | post_replies | tinyint | 1 | Allow type of users to post replies in topics. | |
| - | | post_topics | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | post_topics | tinyint | 1 | Allow type of users to post topics in forums. | |
| ==== forums ==== | ==== forums ==== | ||
| ^ **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. | |
| - | | forum_name | varchar(80) | 'New forum' | The name of the forum. | | + | | forum_name | varchar(80) | 'New forum' | The name of the forum. | |
| - | | forum_desc | text | NULL | A description 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. | | + | | 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. | | + | | moderators | text | NULL | A serialized PHP array of moderators. | |
| - | | num_topics | mediumint/int | 0 | The number of topics the forum contains. | | + | | num_topics | mediumint | 0 | The number of topics the forum contains. | |
| - | | num_posts | mediumint/int | 0 | The number of posts 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 | 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_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. | | + | | last_poster | varchar(200) | NULL | The username (or guest name) of the user that made the last post in the forum. | |
| - | | sort_by | tinyint/smallint | 0 | 0 = Display topics sorted by last post. 1 = Display topics sorted by topic start. | | + | | 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). | | + | | 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. | | + | | cat_id | int | 0 | The category in which the forum resides. | |
| ==== groups ==== | ==== groups ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ||
| - | | __g_id__ | int | | The auto-incrementing (identity) primary key identifier for this table. | | + | | __g_id__ | int | | The auto-incrementing (identity) primary key identifier for this table. | |
| - | | g_title | varchar(50) | | The name of the group. | | + | | g_title | varchar(50) | | The name of the group. | |
| - | | g_user_title | varchar(50) | NULL | The title of users in this group. | | + | | g_user_title | varchar(50) | NULL | The title of users in this group. | |
| - | | g_read_board | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | 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_post_replies | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_mod_edit_users | tinyint | 0 | Allow moderators to edit user profiles. | |
| - | | g_post_topics | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_mod_rename_users | tinyint | 0 | Allow moderators to rename users. | |
| - | | g_post_polls | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_mod_change_passwords | tinyint | 0 | Allow moderators to change user passwords. | |
| - | | g_edit_posts | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_mod_ban_users | tinyint | 0 | Allow moderators to ban users. | |
| - | | g_delete_posts | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_read_board | tinyint | 1 | Allow users to view the board. | |
| - | | g_delete_topics | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_view_users | tinyint | 1 | Allow users to view the user list and user profiles. | |
| - | | g_set_title | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_post_replies | tinyint | 1 | Allow users to post replies in topics. | |
| - | | g_search | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_post_topics | tinyint | 1 | Allow users to post a new topics. | |
| - | | g_search_users | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | | + | | g_edit_posts | tinyint | 1 | Allow users to edit their own posts. | |
| - | | g_edit_subjects_interval | smallint | 300 | Number of seconds after post time that users in this group may edit the subject of topics they've posted. | | + | | g_delete_posts | tinyint | 1 | Allow users to delete their own posts. | |
| - | | g_post_flood | smallint | 30 | Number of seconds that users in this group have to wait between posts. | | + | | g_delete_topics | tinyint | 1 | Allow users to delete their own topics (including any replies). | |
| - | | g_search_flood | smallint | 30 | Number of seconds that users in this group have to wait between searches. | | + | | 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 ==== | ==== online ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ||
| - | | user_id | int | 1 | ID of the user (always 1 for guests). | | + | | 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. | | + | | 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. | | + | | logged | int | 0 | A UNIX timestamp representing the date/time for the user's last activity. | |
| - | | idle | tinyint/smallint | 0 | 0 = User has been active within the last "Online timeout" seconds. 1 = User has timed out. | | + | | 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 ==== | ==== posts ==== | ||
| ^ **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. | |
| - | | poster | varchar(200) | | The username (or guest name) of the user that made the post. | | + | | 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_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_ip | varchar(15) | NULL | The IP address the post was made from. | |
| - | | poster_email | varchar(50) | NULL | The guest e-mail address (if supplied). | | + | | poster_email | varchar(50) | NULL | The guest e-mail address (if supplied). | |
| - | | message | text | | The actual message contents. | | + | | message | text | | The actual message contents. | |
| - | | hide_smilies | tinyint/smallint | 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. | | + | | 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. | | + | | 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 | 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. | | + | | 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. | | + | | topic_id | int | 0 | The topic ID in which the post resides. | |
| ==== ranks ==== | ==== ranks ==== | ||
| ^ **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. | |
| - | | rank | varchar(50) | | The rank title. | | + | | rank | varchar(50) | | The rank title. | |
| - | | min_posts | mediumint/int | 0 | The number of posts a user must attain in order to reach the rank. | | + | | min_posts | mediumint | 0 | The number of posts a user must attain in order to reach the rank. | |
| ==== reports ==== | ==== reports ==== | ||
| ^ **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. | |
| - | | post_id | int | 0 | The post the report relates to. | | + | | post_id | int | 0 | The post the report relates to. | |
| - | | topic_id | int | 0 | The topic in which the reported post resides in. | | + | | 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. | | + | | 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. | | + | | 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. | | + | | created | int | 0 | A UNIX timestamp representing the date/time the post was last edited. | |
| - | | message | text | | The report message. | | + | | message | text | | The report message. | |
| - | | zapped | int | NULL | A UNIX timestamp representing the date/time the report was zapped (marked as read). | | + | | 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. | | + | | zapped_by | int | NULL | The username of the administrator or moderator that zapped the report. | |
| ==== search_cache ==== | ==== search_cache ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ||
| - | | __id__ | int | 0 | The primary key identifier for this table. | | + | | __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. | | + | | 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_data | text | | A serialized PHP array of search data (e.g. post ID's, sort direction etc.). | |
| ==== search_matches ==== | ==== search_matches ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ||
| - | | post_id | int | 0 | The post this match relates to. | | + | | post_id | int | 0 | The post this match relates to. | |
| - | | word_id | mediumint/int | 0 | The word this match relates to. | | + | | word_id | mediumint | 0 | The word this match relates to. | |
| - | | subject_match | tinyint/smallint | 0 | 0 = Match is in the post message. 1 = Match is in the topic subject. | | + | | subject_match | tinyint | 0 | 0 = Match is in the post message. 1 = Match is in the topic subject. | |
| ==== search_words ==== | ==== search_words ==== | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ||
| - | | id | mediumint/int | | An integer identifier for this table. | | + | | id | mediumint | | An integer identifier for this table. | |
| | __word__ | varchar(20) | | The indexed word (primary key). | | | __word__ | varchar(20) | | The indexed word (primary key). | | ||
| Line 144: | Line 176: | ||
| ^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ | ^ **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. | | + | | __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. | | | __topic_id__ | int | 0 | The topic user_id subscribes to. Primary key identifier together with user_id for this table. | | ||
| Line 150: | Line 182: | ||
| ^ **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. | |
| - | | poster | varchar(200) | | The username (or guest name) of the user that posted the topic. | | + | | poster | varchar(200) | | The username (or guest name) of the user that posted the topic. | |
| - | | subject | varchar(255) | | The topic subject. | | + | | subject | varchar(255) | | The topic subject. | |
| - | | posted | int | 0 | A UNIX timestamp representing the date/time the topic was posted. | | + | | posted | int | 0 | A UNIX timestamp representing the date/time the topic was posted. | |
| - | | last_post | int | NULL | A UNIX timestamp representing the date/time the last post was made in the topic. | | + | | first_post_id | int | 0 | The ID of the first post that was made with the topic. | |
| - | | last_post_id | int | NULL | The ID of the last post that was made in the topic. | | + | | last_post | int | NULL | A UNIX timestamp representing the date/time the last post 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. | | + | | last_post_id | int | NULL | The ID of the last post that was made in the topic. | |
| - | | num_views | mediumint/int | 0 | The number of times the topic has been viewed. | | + | | last_poster | varchar(200) | NULL | The username (or guest name) of the user that made the last post in the topic. | |
| - | | num_replies | mediumint/int | 0 | The number of replies that have been posted in the topic. | | + | | num_views | mediumint | 0 | The number of times the topic has been viewed. | |
| - | | closed | tinyint/smallint | 0 | 0 = Topic is open. 1 = Topic is closed. | | + | | num_replies | mediumint | 0 | The number of replies that have been posted in the topic. | |
| - | | sticky | tinyint/smallint | 0 | 0 = Topic is a regular topic. 1 = Topic is a sticky topic. | | + | | closed | tinyint | 0 | 0 = Topic is open. 1 = Topic is closed. | |
| - | | moved_to | int | NULL | The forum to which the topic has been moved. | | + | | sticky | tinyint | 0 | 0 = Topic is a regular topic. 1 = Topic is a sticky topic. | |
| - | | forum_id | int | 0 | The forum in which the topic resides. | | + | | 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 ==== | ==== users ==== | ||
| ^ **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. | |
| - | | group_id | int | 4 | The user group to which this user belongs. | | + | | group_id | int | 4 | The user group to which this user belongs. | |
| - | | username | varchar(200) | | The user's username. | | + | | 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. | | + | | 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. | | + | | salt | varchar(12) | NULL | The random secure line for generation specify csrf-token for user. | |
| - | | title | varchar(50) | NULL | The user custom title. | | + | | email | varchar(80) | | The user e-mail address. | |
| - | | realname | varchar(40) | NULL | The user's name. | | + | | title | varchar(50) | NULL | The user custom title. | |
| - | | url | varchar(100) | NULL | A link to the user's website. | | + | | realname | varchar(40) | NULL | The user's name. | |
| - | | jabber | varchar(75) | NULL | The user's Jabber address. | | + | | url | varchar(100) | NULL | A link to the user's website. | |
| - | | icq | varchar(12) | NULL | The user's ICQ UIN. | | + | | jabber | varchar(80) | NULL | The user's Jabber address. | |
| - | | msn | varchar(50) | NULL | The user's MSN Messenger e-mail address. | | + | | icq | varchar(12) | NULL | The user's ICQ UIN. | |
| - | | aim | varchar(30) | NULL | The user's AOL Instant Messenger username. | | + | | msn | varchar(80) | NULL | The user's MSN Messenger e-mail address. | |
| - | | yahoo | varchar(30) | NULL | The user's Yahoo Messenger username. | | + | | aim | varchar(30) | NULL | The user's AOL Instant Messenger username. | |
| - | | location | varchar(30) | NULL | The user's geographical location. | | + | | yahoo | varchar(30) | NULL | The user's Yahoo Messenger username. | |
| - | | use_avatar | tinyint/smallint | 0 | 0 = Don't show avatar to other users. 1 = Show avatar to other users. | | + | | location | varchar(30) | NULL | The user's geographical location. | |
| - | | signature | text | NULL | The user's signature. | | + | | 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_topics | tinyint | 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). | | + | | disp_posts | tinyint | 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. | | + | | 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. | |
| - | | save_pass | tinyint/smallint | 1 | 0 = Don't remember user between visits. 1 = Remember user between visits. | | + | | 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/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. | | + | | auto_notify | tinyint | 0 | Subscribe to topics by default when posting. | |
| - | | show_smilies | tinyint/smallint | 1 | Show smilies as images. | | + | | show_smilies | tinyint | 1 | Show smilies as images. | |
| - | | show_img | tinyint/smallint | 1 | Show images in posts. | | + | | show_img | tinyint | 1 | Show images in posts. | |
| - | | show_img_sig | tinyint/smallint | 1 | Show images in signatures. | | + | | show_img_sig | tinyint | 1 | Show images in signatures. | |
| - | | show_avatars | tinyint/smallint | 1 | Show avatars. | | + | | show_avatars | tinyint | 1 | Show avatars. | |
| - | | show_sig | tinyint/smallint | 1 | Show signatures. | | + | | show_sig | tinyint | 1 | Show signatures. | |
| - | | timezone | float | 0 | The user's timezone. | | + | | access_keys | tinyint | 0 | | |
| - | | language | varchar(25) | 'English' | The user's preferred language for the forum UI. | | + | | timezone | float | 0 | The user's timezone. | |
| - | | style | varchar(25) | 'Oxygen' | The user's preferred style. | | + | | dst | tinyint | 0 | Enable the DST effect (DST Daylight Saving Time). Advance times by 1 hour. | |
| - | | num_posts | int | 0 | The number of posts the user has made. | | + | | time_format | int | 0 | Set the specify format of time for user. | |
| - | | last_post | int | NULL | A UNIX timestamp representing the date/time the last post by the user was made. | | + | | date_format | int | 0 | Set the specify format of date for user. | |
| - | | registered | int | 0 | A UNIX timestamp representing the date the user registered. | | + | | language | varchar(25) | 'English' | The user's preferred language for the forum UI. | |
| - | | registration_ip | varchar(15) | 0.0.0.0 | The IP address used when registering. | | + | | style | varchar(25) | 'Oxygen' | The user's preferred style. | |
| - | | last_visit | int | 0 | A UNIX timestamp representing the date/time the last visit by the user commenced. | | + | | num_posts | int | 0 | The number of posts the user has made. | |
| - | | admin_note | varchar(30) | NULL | A user note only viewable and editable by administrators and moderators. | | + | | last_post | int | NULL | A UNIX timestamp representing the date/time the last post by the user was made. | |
| - | | activate_string | varchar(50) | NULL | A temporary storage string for new passwords and new e-mail addresses. | | + | | last_search | int | 0 | The ID of last search which has used by user. | |
| - | | activate_key | varchar(8) | NULL | A temporary storage string for new password and new e-mail address activation keys. | | + | | 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. | | ||
