Table realmd.account
Account System

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigint unsigned 20  √ 
characters.account_data.account Defined in XML R
characters.character_tutorial.account Defined in XML R
characters.characters.account Defined in XML R
characters.petition_sign.player_account Defined in XML R
account_banned.id Defined in XML R
realmcharacters.acctid Defined in XML R
Identifier
username varchar 32
sha_pass_hash varchar 40
gmlevel tinyint unsigned 3 0
sessionkey longtext 2147483647  √  null
v longtext 2147483647  √  null
s longtext 2147483647  √  null
email text 65535  √  null
joindate timestamp 19 CURRENT_TIMESTAMP
last_ip varchar 30 127.0.0.1
failed_logins int unsigned 10 0
locked tinyint unsigned 3 0
last_login timestamp 19 0000-00-00 00:00:00
online tinyint 3 0
expansion tinyint unsigned 3 0
mutetime bigint unsigned 20 0
locale tinyint unsigned 3 0

Table contained 4 rows at Fri Feb 11 23:18 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
gmlevel Performance Asc idx_gmlevel
username Must be unique Asc idx_username

Close relationships  within of separation: