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:47 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** ^
| __id__ | int | | The auto-incrementing (identity) primary key identifier for this table. | | __id__ | int | | The auto-incrementing (identity) primary key identifier for this table. |
| username | varchar(200) | NULL | The username this ban applies to. | | username | varchar(200) | NULL | The username this ban applies to. |
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 ====
-^       **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. |
| cat_name | varchar(80) | 'New Category' | The name of the category. | | cat_name | varchar(80) | 'New Category' | The name of the category. |
Line 21: Line 21:
==== censoring ==== ==== censoring ====
-^       **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. |
| search_for | varchar(60) |  | The term to search for. | | search_for | varchar(60) |  | The term to search for. |
Line 28: Line 28:
==== config ==== ==== config ====
-^       **Field**       ^ **Type** ^ **Default** ^ **Description** ^+^ **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_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 ==== ==== extension_hooks ====
-^       **Field**       ^ **Type** ^ **Default** ^ **Description** ^ +^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id           | varchar(50) |      | The text identification of extension hook. | +| __id__           | varchar(150) |      | The name of hook of extension. | 
-| __extension_id__ | varchar(50) |      | The text identification of extension name. | +| __extension_id__ | carchar(50) |      | The name of extension. | 
-| code         | text       | NULL | The code of extension hook. | +| code             | text         | NULL | The code which will place into the hook. | 
-| installed   | int         | 0    | The UNIX timestamp representing the day when extension installed. | +| installed       | int         | 0    | The UNIX timestamp representing the day when the extension was installed. | 
-| priority     | tinyint     | 5    | The priority of extension hook. |+| priority         | tinyint     | 5    | The priority of hook. |
==== extensions ==== ==== extensions ====
-^       **Field**       ^ **Type** ^ **Default** ^ **Description** ^ +^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id              | varchar(50) |      | The text identification of extension. It's name of extension. | +| __id__        | varchar(150) |      | The identificator of extension which is used in the code of extension. | 
-| title           | varchar(255) |      | The official name of extension. | +| title         | varchar(255) |      | The official name of extension. | 
-| version         | varchar(25)  |      | The version of extension. | +| version       | varchar(25)  |      | The version of extension. | 
-| description     | text        | NULL | The description of extension. What it must do. | +| description   | text        | NULL | The description of extension whick containe short functionality of extension. | 
-| author         | varchar(50)  |      | The author of extension. | +| author         | varchar(50)  |      | The author or group of authors of extension. | 
-| uninstall       | text        | NULL | Code for uninstall. | +| uninstall     | text        | NULL | The script for uninstall extension. | 
-| uninstall_node  | text        | NULL | .+| uninstall_note | text        | NULL |
-| disabled       | tinyint      | 0    | Set extension to enable or disable mode. | +| disabled       | tinyint      | 0    | The status of extension - enable or disable. | 
-| dependencies   | varchar(255) |      | Describe dependence extensions. |+| 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 165: 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 171: 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. | 

Personal Tools