phpBB

Development Wiki

Difference between revisions of "Table.phpbb users"

From phpBB Development Wiki

(Add more descriptions)
Line 55: Line 55:
 
| user_password
 
| user_password
 
| varchar(40)
 
| varchar(40)
| tbd
+
| The hashed version of the user's pass
 
|  
 
|  
 
|-
 
|-
Line 115: Line 115:
 
| user_warnings
 
| user_warnings
 
| tinyint(4)
 
| tinyint(4)
| tbd
+
| Warnings the user has
 
| 0
 
| 0
 
|-
 
|-
Line 130: Line 130:
 
| user_inactive_reason
 
| user_inactive_reason
 
| tinyint(2)
 
| tinyint(2)
| tbd
+
| Reason for being inactive
 
| 0
 
| 0
 
|-
 
|-
Line 140: Line 140:
 
| user_posts
 
| user_posts
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
| tbd
+
| Amount of posts the user has posted
 
| 0
 
| 0
 
|-
 
|-
 
| user_lang
 
| user_lang
 
| varchar(30)
 
| varchar(30)
| tbd
+
| The language the user uses default on the board
 
|  
 
|  
 
|-
 
|-
Line 155: Line 155:
 
| user_dst
 
| user_dst
 
| tinyint(1) unsigned
 
| tinyint(1) unsigned
| tbd
+
| Is the user on Daylight Savings Time
 
| 0
 
| 0
 
|-
 
|-
 
| user_dateformat
 
| user_dateformat
 
| varchar(30)
 
| varchar(30)
| tbd
+
| How dates are shown in the user's format
 
| d M Y H:i
 
| d M Y H:i
 
|-
 
|-
 
| user_style
 
| user_style
 
| tinyint(4)
 
| tinyint(4)
| tbd
+
| Style user uses to browse the board
 
| 0
 
| 0
 
|-
 
|-
 
| user_rank
 
| user_rank
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
| tbd
+
| User's rank
 
| 0
 
| 0
 
|-
 
|-
 
| user_colour
 
| user_colour
 
| varchar(6)
 
| varchar(6)
| tbd
+
| User's colour
 
|  
 
|  
 
|-
 
|-
Line 315: Line 315:
 
| user_from
 
| user_from
 
| varchar(100)
 
| varchar(100)
| tbd
+
| User's location field value
 
|  
 
|  
 
|-
 
|-
 
| user_icq
 
| user_icq
 
| varchar(15)
 
| varchar(15)
| tbd
+
| User's ICQ field value
 
|  
 
|  
 
|-
 
|-
 
| user_aim
 
| user_aim
 
| varchar(255)
 
| varchar(255)
| tbd
+
| User's AIM field value
 
|  
 
|  
 
|-
 
|-
 
| user_yim
 
| user_yim
 
| varchar(255)
 
| varchar(255)
| tbd
+
| User's YIM field value
 
|  
 
|  
 
|-
 
|-
 
| user_msnm
 
| user_msnm
 
| varchar(255)
 
| varchar(255)
| tbd
+
| User's MSN field value
 
|  
 
|  
 
|-
 
|-
 
| user_jabber
 
| user_jabber
 
| varchar(255)
 
| varchar(255)
| tbd
+
| User's Jabber field value
 
|  
 
|  
 
|-
 
|-
 
| user_website
 
| user_website
 
| varchar(200)
 
| varchar(200)
| tbd
+
| User's website field value
 
|  
 
|  
 
|-
 
|-
 
| user_occ
 
| user_occ
 
| text
 
| text
| tbd
+
| User's occupation field value
 
|  
 
|  
 
|-
 
|-
 
| user_interests
 
| user_interests
 
| text
 
| text
| tbd
+
| User's interests field value
 
|  
 
|  
 
|-
 
|-

Revision as of 14:00, 29 January 2010

description goes here

Fields

column type (MySQL) content default
user_id mediumint(8) unsigned primary key auto_increment
user_type tinyint(2) Defines what type user is. 0 is normal user, 2 is pre-defined type (i.e. bot) 3 is Founder. 0
group_id mediumint(8) unsigned The user's default group. 3
user_permissions mediumtext tbd  
user_perm_from mediumint(8) unsigned tbd 0
user_ip varchar(40) The IP of the user on registration, dotted QUAD style (ie: 127.0.0.1)  
user_regdate int(11) unsigned User's registration date/time, UNIX timestamp 0
username varchar(255) the username as it is shown all over the board  
username_clean varchar(255) The all lower-case normalized version of the username for comparisons.  
user_password varchar(40) The hashed version of the user's pass  
user_passchg int(11) unsigned tbd 0
user_pass_convert tinyint(1) unsigned tbd 0
user_email varchar(100) user's email on registration, PLAIN text  
user_email_hash bigint(20) tbd 0
user_birthday varchar(10) tbd  
user_lastvisit int(11) unsigned User's last visit time, UNIX timestamp. 0
user_lastmark int(11) unsigned the last time the user clicked "Mark forums read" 0
user_lastpost_time int(11) unsigned the time of the latest post of the user, UNIX timestamp 0
user_lastpage varchar(200) tbd  
user_last_confirm_key varchar(10) code used for security reasons by confirmation windows  
user_last_search int(11) unsigned tbd 0
user_warnings tinyint(4) Warnings the user has 0
user_last_warning int(11) unsigned tbd 0
user_login_attempts tinyint(4) tbd 0
user_inactive_reason tinyint(2) Reason for being inactive 0
user_inactive_time int(11) unsigned tbd 0
user_posts mediumint(8) unsigned Amount of posts the user has posted 0
user_lang varchar(30) The language the user uses default on the board  
user_timezone decimal(5,2) tbd 0.00
user_dst tinyint(1) unsigned Is the user on Daylight Savings Time 0
user_dateformat varchar(30) How dates are shown in the user's format d M Y H:i
user_style tinyint(4) Style user uses to browse the board 0
user_rank mediumint(8) unsigned User's rank 0
user_colour varchar(6) User's colour  
user_new_privmsg tinyint(4) tbd 0
user_unread_privmsg tinyint(4) tbd 0
user_last_privmsg int(11) unsigned tbd 0
user_message_rules tinyint(1) unsigned tbd 0
user_full_folder int(11) tbd -3
user_emailtime int(11) unsigned tbd 0
user_topic_show_days smallint(4) unsigned Preferences for reading 0
user_topic_sortby_type char(1) Preferences for reading t
user_topic_sortby_dir char(1) Preferences for reading d
user_post_show_days smallint(4) unsigned Preferences for reading 0
user_post_sortby_type char(1) Preferences for reading t
user_post_sortby_dir char(1) Preferences for reading a
user_notify tinyint(1) unsigned tbd 0
user_notify_pm tinyint(1) unsigned tbd 1
user_notify_type tinyint(4) tbd 0
user_allow_pm tinyint(1) unsigned tbd 1
user_allow_viewonline tinyint(1) unsigned tbd 1
user_allow_viewemail tinyint(1) unsigned tbd 1
user_allow_massemail tinyint(1) unsigned tbd 1
user_options int(11) unsigned tbd 893
user_avatar varchar(255) tbd  
user_avatar_type tinyint(2) tbd 0
user_avatar_width smallint(4) unsigned tbd 0
user_avatar_height smallint(4) unsigned tbd 0
user_sig mediumtext tbd  
user_sig_bbcode_uid varchar(5) Needed to render the signature.  
user_sig_bbcode_bitfield varchar(255) Needed to render the signature.  
user_from varchar(100) User's location field value  
user_icq varchar(15) User's ICQ field value  
user_aim varchar(255) User's AIM field value  
user_yim varchar(255) User's YIM field value  
user_msnm varchar(255) User's MSN field value  
user_jabber varchar(255) User's Jabber field value  
user_website varchar(200) User's website field value  
user_occ text User's occupation field value  
user_interests text User's interests field value  
user_actkey varchar(32) tbd  
user_newpasswd varchar(32) tbd  

Keys

name fields
PRIMARY user_id
user_birthday user_birthday
user_email_hash user_email_hash
user_type user_type
username_clean username_clean