Users
All informationabout the users of the system are in the WebGUI database. Here are the tables.
| userId |
varchar(22) |
NO |
PRI |
|
|
| username |
varchar(100) |
YES |
UNI |
|
|
| authMethod |
varchar(30) |
NO |
|
WebGUI |
|
| dateCreated |
int(11) |
NO |
|
1019867418 |
|
| lastUpdated |
int(11) |
NO |
|
1019867418 |
|
| karma |
int(11) |
NO |
|
0 |
|
| status |
varchar(35) |
NO |
|
Active |
|
| referringAffiliate |
varchar(22) |
NO |
|
|
|
| friendsGroup |
varchar(22) |
NO |
|
|
|
userProfileField
| fieldName |
varchar(128) |
NO |
PRI |
|
|
| label |
varchar(255) |
NO |
|
Undefined |
|
| visible |
int(11) |
NO |
|
0 |
|
| required |
int(11) |
NO |
|
0 |
|
| fieldType |
varchar(128) |
NO |
|
text |
|
| possibleValues |
text |
YES |
|
|
|
| dataDefault |
text |
YES |
|
|
|
| sequenceNumber |
int(11) |
NO |
|
1 |
|
| profileCategoryId |
varchar(22) |
NO |
|
|
|
| protected |
int(11) |
NO |
|
0 |
|
| editable |
int(11) |
NO |
|
1 |
|
| forceImageOnly |
int(11) |
YES |
|
1 |
|
| showAtRegistration |
int(11) |
NO |
|
0 |
|
| requiredForPasswordRecovery |
int(11) |
NO |
|
0 |
|
| extras |
text |
YES |
|
|
|
| defaultPrivacySetting |
char(128) |
YES |
|
|
|
userProfileData
| userId |
varchar(22) |
NO |
PRI |
|
|
| email |
char(255) |
YES |
|
|
|
| firstName |
char(255) |
YES |
|
|
|
| middleName |
char(255) |
YES |
|
|
|
| lastName |
char(255) |
YES |
|
|
|
| icq |
char(255) |
YES |
|
|
|
| aim |
char(255) |
YES |
|
|
|
| msnIM |
char(255) |
YES |
|
|
|
| yahooIM |
char(255) |
YES |
|
|
|
| cellPhone |
char(255) |
YES |
|
|
|
| pager |
char(255) |
YES |
|
|
|
| emailToPager |
char(255) |
YES |
|
|
|
| language |
char(255) |
YES |
|
|
|
| homeAddress |
char(255) |
YES |
|
|
|
| homeCity |
char(255) |
YES |
|
|
|
| homeState |
char(255) |
YES |
|
|
|
| homeZip |
char(255) |
YES |
|
|
|
| homeCountry |
char(255) |
YES |
|
|
|
| homePhone |
char(255) |
YES |
|
|
|
| workAddress |
char(255) |
YES |
|
|
|
| workCity |
char(255) |
YES |
|
|
|
| workState |
char(255) |
YES |
|
|
|
| workZip |
char(255) |
YES |
|
|
|
| workCountry |
char(255) |
YES |
|
|
|
| workPhone |
char(255) |
YES |
|
|
|
| gender |
char(255) |
YES |
|
|
|
| birthdate |
bigint(20) |
YES |
|
|
|
| homeURL |
char(255) |
YES |
|
|
|
| workURL |
char(255) |
YES |
|
|
|
| workName |
char(255) |
YES |
|
|
|
| timeZone |
char(255) |
YES |
|
|
|
| dateFormat |
char(255) |
YES |
|
|
|
| timeFormat |
char(255) |
YES |
|
|
|
| discussionLayout |
char(255) |
YES |
|
|
|
| firstDayOfWeek |
char(255) |
YES |
|
|
|
| uiLevel |
char(255) |
YES |
|
|
|
| alias |
char(255) |
YES |
|
|
|
| signature |
longtext |
YES |
|
|
|
| publicProfile |
longtext |
YES |
|
|
|
| toolbar |
char(255) |
YES |
|
|
|
| photo |
char(22) |
YES |
|
|
|
| avatar |
char(22) |
YES |
|
|
|
| department |
char(255) |
YES |
|
|
|
| allowPrivateMessages |
longtext |
YES |
|
|
|
| ableToBeFriend |
tinyint(4) |
YES |
|
|
|
| showMessageOnLoginSeen |
bigint(20) |
YES |
|
|
|
| showOnline |
tinyint(1) |
YES |
|
|
|
| versionTagMode |
char(255) |
YES |
|
|
|
| wg_privacySettings |
longtext |
YES |
|
|
|
| receiveInboxEmailNotifications |
tinyint(1) |
YES |
|
|
|
| receiveInboxSmsNotifications |
tinyint(1) |
YES |
|
|
|