reference-guide:database:base_user
Table: _base_user
- Type: Core platform.
- In a nutshell: _base_user tables stores general user related data.
Structure
- id – integer number each user is assigned within database (userID).
- email – email entered by user during registration/profile edit.
- username – username entered by user during registration/profile edit.
- password – encrypted user password.
- joinStamp – Unix TimeStamp formated date/time when user joined your site.
- activityStamp – Unix TimeStamp formated date/time when user has been active last time.
- accountType – hashed value of an account type selected by user upon registration
- emailVerify – numerical value indicating whether user's email is verified or not.
- 1 = verified
- 0 = unverified.
| id int(11) | email varchar(128) | username varchar(32 | password varchar(64) | joinStamp int(11) | activityStamp int(11) | accountType varchar(32) | emailVerify tinyint(2) | joinIp int(11) |
| {$id} | {$email} | {$username} | {$password} | {$joinStamp} | {$activityStamp} | {$accountType} | 0 OR 1 | {$joinIp} |
reference-guide/database/base_user.txt · Last modified: 2017/06/07 09:11 by 127.0.0.1