Skip to content

account

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

Diagram Edit

Relationships

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

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
expansion tinyint Expansion
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