| field
|
type
|
foreign key
|
description
|
| id
|
int(10)
|
N
|
unique account id
|
| username
|
varchar(50)
|
N
|
Login name for the account
|
| password
|
varchar(32)
|
N
|
The MD5 encrypted password.
|
| last_login
|
datetime
|
N
|
The last login time this account was used.
|
| created_date
|
datetime
|
N
|
The date this account was created
|
| last_login_ip
|
varchar(16)
|
N
|
The IP address last used to login with this account.
|
| security_level
|
tinyint(3)
|
N
|
The Security Level of this account.
|
| verificationid
|
varchar(32)
|
N
|
The verification id used in the URL to activate/reset account.
|
| country
|
varchar(64)
|
N
|
The country this user is from.
|
| gender
|
varchar(1)
|
N
|
The gender of the player.
|
| birth
|
int(4)
|
N
|
The year this player was born.
|
| status
|
char(1)
|
N
|
The status of this account. (A)ctive (U)nactive.
|
| spam_points
|
int
|
N
|
The amount of spam points this account has accumulated.
|
| advisor_points
|
int
|
N
|
The number of advisor points this account has accumulated.
|
| comments
|
text
|
N
|
Additional comments about account.
|
| realname
|
varchar(64)
|
N
|
The real name of the person using account.
|
| advisor_ban
|
tinyint(1)
|
N
|
|
| operating_system
|
varchar(32)
|
N
|
|
| graphics_card
|
varchar(64)
|
N
|
|
| graphics_version
|
varchar(32)
|
N
|
|