SchemaSpy Analysis of realmd - Columns UnifiedDB Login Database | Generated by SchemaSpy |
Generated by SchemaSpy on Fri Feb 11 23:18 MST 2011 |
| ||||||
|
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 | 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 |