account
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| account_id | table index | int(10) unsigned | NO | PRI | NULL | auto_increment |
| account_parent | for hierarchical accounts, the account_id of the parent to this one, if account_parent = account_id, this is the top level account | int(10) unsigned | NO | MUL | 0 | |
| account_default_channel | channel_id of channel to connect on login | int(10) unsigned | NO | MUL | 0 | |
| account_salt | complexity token for account_password | char(32) | NO | |||
| account_password | hashed password for this account | char(255) | NO | |||
| account_email | essentially the login ID, although it is usually possible to login with a channel address | char(255) | NO | MUL | ||
| account_external | Currently unused | char(255) | NO | MUL | ||
| account_language | default language (closest available browser-accept language when account was created) | char(16) | NO | en | ||
| account_created | timestamp of account creation | datetime | NO | 0000-00-00 00:00:00 | ||
| account_lastlog | timestamp of last login (or daily update if "remember me" is in effect) | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| account_flags | see notes | int(10) unsigned | NO | MUL | 0 | |
| account_roles | see notes | int(10) unsigned | NO | MUL | 0 | |
| account_reset | verification token for password reset | char(255) | NO | |||
| account_expires | timestamp when account expires and will be deleted | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| account_expire_notified | timestamp of last warning of account expiration | datetime | NO | 0000-00-00 00:00:00 | ||
| account_service_class | service class for this account, determines what if any limits/restrictions are in place | char(32) | NO | MUL | ||
| account_level | future use | int(10) unsigned | NO | MUL | 0 | |
| account_password_changed | timestamp of last password change - to limit account deletion for 48 hours to prevent malicious activity | datetime | NO | MUL | 0000-00-00 00:00:00 |
Notes:
Account Flags
define ( 'ACCOUNT_OK', 0x0000 ); define ( 'ACCOUNT_UNVERIFIED', 0x0001 ); define ( 'ACCOUNT_BLOCKED', 0x0002 ); define ( 'ACCOUNT_EXPIRED', 0x0004 ); define ( 'ACCOUNT_REMOVED', 0x0008 ); define ( 'ACCOUNT_PENDING', 0x0010 );
Account roles
define ( 'ACCOUNT_ROLE_SYSTEM', 0x0002 ); // 2 - this is the special system account define ( 'ACCOUNT_ROLE_DEVELOPER', 0x0004 ); define ( 'ACCOUNT_ROLE_ADMIN', 0x1000 ); // 4096 - this account is an administrator