AccountsTable

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