Users
Users
All informationabout the users of the system are in the WebGUI database. Here are the tables.| Field | Type | Null | Key | Default | Extra |
| 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
| Field | Type | Null | Key | Default | Extra |
| 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 |
userProfileData
| Field | Type | Null | Key | Default | Extra |
| userId | varchar(22) | NO | PRI | ||
| varchar(255) | YES | ||||
| firstName | varchar(255) | YES | |||
| middleName | varchar(255) | YES | |||
| lastName | varchar(255) | YES | |||
| icq | varchar(255) | YES | |||
| aim | varchar(255) | YES | |||
| msnIM | varchar(255) | YES | |||
| yahooIM | varchar(255) | YES | |||
| cellPhone | varchar(255) | YES | |||
| pager | varchar(255) | YES | |||
| emailToPager | varchar(255) | YES | |||
| language | varchar(255) | YES | |||
| homeAddress | varchar(255) | YES | |||
| homeCity | varchar(255) | YES | |||
| homeState | varchar(255) | YES | |||
| homeZip | varchar(255) | YES | |||
| homeCountry | varchar(255) | YES | |||
| homePhone | varchar(255) | YES | |||
| workAddress | varchar(255) | YES | |||
| workCity | varchar(255) | YES | |||
| workState | varchar(255) | YES | |||
| workZip | varchar(255) | YES | |||
| workCountry | varchar(255) | YES | |||
| workPhone | varchar(255) | YES | |||
| gender | varchar(255) | YES | |||
| birthdate | bigint(20) | YES | |||
| homeURL | varchar(255) | YES | |||
| workURL | varchar(255) | YES | |||
| workName | varchar(255) | YES | |||
| timeZone | varchar(255) | YES | |||
| dateFormat | varchar(255) | YES | |||
| timeFormat | varchar(255) | YES | |||
| discussionLayout | varchar(255) | YES | |||
| firstDayOfWeek | varchar(255) | YES | |||
| uiLevel | varchar(255) | YES | |||
| alias | varchar(255) | YES | |||
| signature | longtext | YES | |||
| publicProfile | int(1) | YES | |||
| publicEmail | int(1) | YES | |||
| toolbar | varchar(255) | YES | |||
| photo | varchar(22) | YES | |||
| avatar | varchar(22) | YES | |||
| department | varchar(255) | YES | |||
| allowPrivateMessages | text | YES | |||
| ableToBeFriend | int(1) | YES | |||
| showMessageOnLoginSeen | bigint(20) | YES |