| Field |
Type |
Null |
Key |
Default |
Description
|
| uid |
int(10) |
No |
Primary
|
|
User ID
|
| username |
varchar(120) |
No |
Multiple
|
|
Username
|
| password |
varchar(120) |
No |
|
|
Password
|
| salt |
varchar(10) |
No |
|
|
Salt used to encrypt the password
|
| loginkey |
varchar(50) |
No |
|
|
Login key used to authenticate user's cookies
|
| email |
varchar(220) |
No |
|
|
Email address
|
| postnum |
int(10) |
No |
|
0
|
Post count
|
| avatar |
varchar(200) |
No |
|
|
URL to avatar
|
| avatardimensions |
varchar(10) |
No |
|
|
The dimensions of the avatar
|
| avatartype |
varchar(10) |
No |
|
0
|
Type of avatar
|
| usergroup |
smallint(5) |
No |
Multiple
|
0
|
Primary usergroup ID
|
| additionalgroups |
varchar(200) |
No |
|
|
Secondary usergroups in a comma-separated list
|
| displaygroup |
smallint(5) |
No |
|
0
|
Display group ID
|
| usertitle |
varchar(250) |
No |
|
|
Custom user title
|
| regdate |
bigint(30) |
No |
|
0
|
Registration date in UNIX timestamp
|
| lastactive |
bigint(30) |
No |
|
0
|
Last active date in UNIX timestamp
|
| lastvisit |
bigint(30) |
No |
|
0
|
Last visit date in UNIX timestamp
|
| lastpost |
bigint(30) |
No |
|
0
|
Last post date in UNIX timestamp
|
| website |
varchar(200) |
No |
|
|
URL to user's website
|
| icq |
varchar(10) |
No |
|
|
User's ICQ UIN
|
| aim |
varchar(50) |
No |
|
|
User's AOL IM screen name
|
| yahoo |
varchar(50) |
No |
|
|
User's Yahoo screen name
|
| msn |
varchar(75) |
No |
|
|
User's MSN Messenger address
|
| birthday |
varchar(15) |
No |
Multiple
|
|
Birthday
|
| birthdayprivacy |
varchar(4) |
No |
|
all
|
Birthday privacy setting
|
| signature |
text |
No |
|
|
User's signature
|
| allownotices |
int(1) |
No |
|
0
|
Option to allow administrators to mass-email the user
|
| hideemail |
int(1) |
No |
|
0
|
Option to hide email from members
|
| subscriptionmethod |
int(1) |
No |
|
0
|
Option to subscribe to threads posted in by default
|
| invisible |
int(1) |
No |
|
0
|
Option to surf the forum invisibly
|
| receivepms |
int(1) |
No |
|
0
|
Option to use the PM system
|
| receivefrombuddy |
int(1) |
No |
|
0
|
Option to receive PMs only from buddies
|
| pmnotice |
int(1) |
No |
|
0
|
Option to popup an alert when a PM is received
|
| pmnotify |
int(1) |
No |
|
0
|
Option to send an email alert when a PM is received
|
| threadmode |
varchar(8) |
No |
|
|
Default thread mode
|
| showsigs |
int(1) |
No |
|
0
|
Option to show/hide signatures
|
| showavatars |
int(1) |
No |
|
0
|
Option to show/hide avatars
|
| showquickreply |
int(1) |
No |
|
0
|
Option to show/hide quick reply
|
| showredirect |
int(1) |
No |
|
0
|
Option to show/hide "friendly" redirect pages
|
| ppp |
smallint(6) |
No |
|
0
|
Default posts per page
|
| tpp |
smallint(6) |
No |
|
0
|
Default threads per page
|
| daysprune |
smallint(6) |
No |
|
0
|
Default days cut-off for thread listings
|
| dateformat |
varchar(4) |
No |
|
|
Format to show dates
|
| timeformat |
varchar(4) |
No |
|
|
Format to show times
|
| timezone |
varchar(4) |
No |
|
|
User's timezone
|
| dst |
int(1) |
No |
|
0
|
Option to enable/disable daylight saving time
|
| dstcorrection |
int(1) |
No |
|
0
|
Type of daylight saving time correction used
|
| buddylist |
text |
No |
|
|
Comma-separated list of "buddy" users' IDs
|
| ignorelist |
text |
No |
|
|
Comma-separated list of "ignored" users' IDs
|
| style |
smallint(5) |
No |
|
0
|
Default forum theme ID
|
| away |
int(1) |
No |
|
0
|
Option to be shown as "away"
|
| awaydate |
int(10) |
No |
|
0
|
Date the user "left"
|
| returndate |
varchar(15) |
No |
|
|
Date the user will return
|
| awayreason |
varchar(200) |
No |
|
|
Reason for going "away"
|
| pmfolders |
text |
No |
|
|
PM folders
|
| notepad |
text |
No |
|
|
User's notepad
|
| referrer |
int(10) |
No |
|
0
|
User who referred this user to the board
|
| referrals |
int(10) |
No |
|
0
|
Number of users this user has referred
|
| reputation |
bigint(30) |
No |
|
0
|
User's overall reputation
|
| regip |
varchar(50) |
No |
|
|
User's registration IP
|
| lastip |
varchar(50) |
No |
|
|
User's last IP used
|
| longregip |
int(11) |
No |
Multiple
|
0
|
Long IP address of user's registration IP
|
| longlastip |
int(11) |
No |
Multiple
|
0
|
Long IP address of last IP used
|
| language |
varchar(50) |
No |
|
|
User's language
|
| timeonline |
bigint(30) |
No |
|
0
|
User's time online
|
| showcodebuttons |
int(1) |
No |
|
1
|
Option to show the MyCode toolbar when posting threads/replies
|
| totalpms |
int(10) |
No |
|
0
|
The total number of private messages the user has
|
| unreadpms |
int(10) |
No |
|
0
|
The total number of unread private messages the user has
|
| warningpoints |
int(3) |
No |
|
0
|
The total number of warning points the user has
|
| moderateposts |
int(1) |
No |
|
0
|
Option if the user should have their posts moderated
|
| moderationtime |
bigint(30) |
No |
|
0
|
Length of time post should be moderated for (in UNIX time)
|
| suspendposting |
int(1) |
No |
|
0
|
Option if the user should have their posting ability suspended
|
| suspensiontime |
bigint(30) |
No |
|
0
|
Length of time posting ability should be suspended for (in UNIX time)
|
| suspendsignature |
int(1) |
No |
|
0
|
Option if the user should have their signature suspended
|
| suspendsigtime |
bigint(30) |
No |
|
0
|
Length of time signature should be suspended for (in UNIX time)
|
| coppauser |
int(1) |
No |
|
0
|
Option if user is awaiting COPPA activation
|
| classicpostbit |
int(1) |
No |
|
0
|
Option if user is using classic postbit
|
| loginattempts |
tinyint(2) |
No |
|
1
|
Number of login attempts
|
| failedlogin |
bigint(30) |
No |
|
0
|
Failed login
|
| usernotes |
text |
No |
|
|
Moderator notepad on user
|