Skip to content



    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"

    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"

Relationship Type Local Key Relates to Table Foreign Key
Has-Many id account_flags p_accid
Has-Many id account_ip accid
Has-Many id account_rewards account_id
Has-Many id bug_reports account_id
Has-Many id sharedbank acctid
Has-Many id eventlog accountid
One-to-One id gm_ips account_id
Has-Many name eventlog accountname
Has-Many name hackers account
Has-Many name petitions accountname


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