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_banned bandate bigint 19 0
ip_banned bandate bigint 19
account_banned unbandate bigint 19 0
ip_banned unbandate bigint 19
realmcharacters acctid bigint unsigned 20
account id bigint unsigned 20  √  Identifier
account mutetime bigint unsigned 20 0
uptime starttime bigint unsigned 20 0
uptime uptime bigint unsigned 20 0
realmd_db_version required_7546_02_realmd_uptime bit 1  √  null
realmlist population float unsigned 12 0
account_banned id int 10 0 Account id
realmlist port int 10 8085
account failed_logins int unsigned 10 0
realmlist id int unsigned 10  √ 
realmcharacters realmid int unsigned 10 0
uptime realmid int unsigned 10
account s longtext 2147483647  √  null
account sessionkey longtext 2147483647  √  null
account v longtext 2147483647  √  null
uptime maxplayers smallint unsigned 5 0
account email text 65535  √  null
account joindate timestamp 19 CURRENT_TIMESTAMP
account last_login timestamp 19 0000-00-00 00:00:00
account_banned active tinyint 3 1
account online tinyint 3 0
realmlist allowedSecurityLevel tinyint unsigned 3 0
realmlist color tinyint unsigned 3 2
account expansion tinyint unsigned 3 0
account gmlevel tinyint unsigned 3 0
realmlist icon tinyint unsigned 3 0
account locale tinyint unsigned 3 0
account locked tinyint unsigned 3 0
realmcharacters numchars tinyint unsigned 3 0
realmlist timezone tinyint unsigned 3 0
account last_ip varchar 30 127.0.0.1
realmlist address varchar 32 127.0.0.1
ip_banned ip varchar 32 127.0.0.1
realmlist name varchar 32
account username varchar 32
account sha_pass_hash varchar 40
account_banned bannedby varchar 50
ip_banned bannedby varchar 50 [Console]
uptime startstring varchar 64
account_banned banreason varchar 255
ip_banned banreason varchar 255 no reason