SchemaSpy Analysis of realmd - Columns UnifiedDB Login Database Generated by
SchemaSpy
Generated by SchemaSpy on Fri Feb 11 23:18 MST 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

realmd contains 46 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
account email text 65535  √  null
account expansion tinyint unsigned 3 0
account failed_logins int unsigned 10 0
account gmlevel tinyint unsigned 3 0
account id bigint unsigned 20  √  Identifier
account joindate timestamp 19 CURRENT_TIMESTAMP
account last_ip varchar 30 127.0.0.1
account last_login timestamp 19 0000-00-00 00:00:00
account locale tinyint unsigned 3 0
account locked tinyint unsigned 3 0
account mutetime bigint unsigned 20 0
account online tinyint 3 0
account s longtext 2147483647  √  null
account sessionkey longtext 2147483647  √  null
account sha_pass_hash varchar 40
account username varchar 32
account v longtext 2147483647  √  null
account_banned active tinyint 3 1
account_banned bandate bigint 19 0
account_banned bannedby varchar 50
account_banned banreason varchar 255
account_banned id int 10 0 Account id
account_banned unbandate bigint 19 0
ip_banned bandate bigint 19
ip_banned bannedby varchar 50 [Console]
ip_banned banreason varchar 255 no reason
ip_banned ip varchar 32 127.0.0.1
ip_banned unbandate bigint 19
realmcharacters acctid bigint unsigned 20
realmcharacters numchars tinyint unsigned 3 0
realmcharacters realmid int unsigned 10 0
realmd_db_version required_7546_02_realmd_uptime bit 1  √  null
realmlist address varchar 32 127.0.0.1
realmlist allowedSecurityLevel tinyint unsigned 3 0
realmlist color tinyint unsigned 3 2
realmlist icon tinyint unsigned 3 0
realmlist id int unsigned 10  √ 
realmlist name varchar 32
realmlist population float unsigned 12 0
realmlist port int 10 8085
realmlist timezone tinyint unsigned 3 0
uptime maxplayers smallint unsigned 5 0
uptime realmid int unsigned 10
uptime startstring varchar 64
uptime starttime bigint unsigned 20 0
uptime uptime bigint unsigned 20 0