account
Relationships
erDiagram
account {
int id
varchar name
}
account_flags {
intunsigned p_accid
}
account_ip {
int accid
varchar ip
}
account_rewards {
intunsigned account_id
intunsigned reward_id
}
bug_reports {
intunsigned account_id
varchar zone
intunsigned character_id
varchar character_name
}
sharedbank {
intunsigned acctid
mediumintunsigned augslot1
mediumintunsigned augslot2
mediumintunsigned augslot3
mediumintunsigned augslot4
mediumintunsigned augslot5
mediumint augslot6
intunsigned itemid
}
account ||--o{ account_flags : "Has-Many"
account ||--o{ account_ip : "Has-Many"
account ||--o{ account_rewards : "Has-Many"
account ||--o{ bug_reports : "Has-Many"
account ||--o{ sharedbank : "Has-Many"
erDiagram
account {
int id
varchar name
}
eventlog {
varchar accountid
varchar accountname
varchar charname
}
gm_ips {
int account_id
varchar ip_address
}
hackers {
varchar account
varchar name
varchar zone
}
petitions {
varchar accountname
varchar charname
varchar lastgm
varchar zone
}
account ||--o{ eventlog : "Has-Many"
account ||--o{ gm_ips : "One-to-One"
account ||--o{ eventlog : "Has-Many"
account ||--o{ hackers : "Has-Many"
account ||--o{ petitions : "Has-Many"
Schema
Column |
Data Type |
Description |
id |
int |
Unique Account Identifier |
name |
varchar |
Name |
charname |
varchar |
Character name last logged in on this account. |
sharedplat |
int |
Platinum in Shared Bank. |
password |
varchar |
Private loginserver password. |
status |
int |
Status |
ls_id |
varchar |
Loginserver ID |
lsaccount_id |
int |
Loginserver Account Identifier |
gmspeed |
tinyint |
GM Speed: 0 = Disabled, 1 = Enabled |
invulnerable |
tinyint |
Invulnerable: 0 = False, 1 = True |
flymode |
tinyint |
Fly Mode |
ignore_tells |
tinyint |
Ignore Tells: 0 = False, 1 = True |
revoked |
tinyint |
OOC Revoked: 0 = False, 1 = True |
karma |
int |
Karma |
minilogin_ip |
varchar |
Minilogin IP Address |
hideme |
tinyint |
Hide Me: 0 = Disabled, 1 = Enabled |
rulesflag |
tinyint |
Rules Flag |
suspendeduntil |
datetime |
Time Suspension of the Account ends |
time_creation |
int |
Time Creation UNIX Timestamp |
ban_reason |
text |
Ban Reason |
suspend_reason |
text |
Suspension Reason |
crc_eqgame |
text |
CRC for EQGame.exe |
crc_skillcaps |
text |
CRC for SkillCaps file |
crc_basedata |
text |
CRC for BaseData file |