account¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
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 |
| 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 |