-
Notifications
You must be signed in to change notification settings - Fork 26
Game DB Tables
Mark edited this page Apr 2, 2020
·
2 revisions
Here we document the structures of the database tables. These tables will come mostly from the character database, but sometimes from the world database. The goal is to have a documentation where we can see which columns of which table appears in which packets. And maybe finding new columns based on the packets.
Table groups |
---|
Character database tables |
Table |
---|
Account |
This table stores the account-wide information. It doesn't store authentication data, the auth database's account table stores that, but this is separated
Field | Type | Description |
---|---|---|
id | INT(11) UNSIGNED | Unique id. |
VARCHAR(255) | The email address. | |
name | VARCHAR(64) | The username. |
level | TINYINT(3) UNSIGNED | The user level. (none, vip, admin, etc...) |
family_name | VARCHAR(64) | The account's family name. |
selected_slot | TINYINT(3) UNSIGNED | The last selected slot int he character selection. |
can_skip_bootcamp | BIT(1) | Can skip bootcamp flag. |
last_ip | VARCHAR(15) | The IP address of the last login. |
last_login | DATETIME | The date of the last login. |
created_at | TIMESTAMP | Technical, the creation time of this database row. |
DEV table description
Field | Type | Description |
---|---|---|