| 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 | 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 |