diff options
Diffstat (limited to 'docs/characters.md')
| -rw-r--r-- | docs/characters.md | 156 |
1 files changed, 78 insertions, 78 deletions
diff --git a/docs/characters.md b/docs/characters.md index 02db6d5..17f1bc7 100644 --- a/docs/characters.md +++ b/docs/characters.md @@ -11,84 +11,84 @@ This table holds vital static information for each character. It is used to crea | Field | Type | Attributes | Key | Null | Default | Extra | Comment | |----------------------------|--------------|------------|-----|------|-------------------|--------|--------------------------| -| [guid][1] | int(10) | unsigned | PRI | NO | 0 | Unique | Global Unique Identifier | -| [account][2] | int(10) | unsigned | | NO | 0 | | Account Identifier | -| [name][3] | varchar(12) | signed | | NO | NULL | | | -| [race][4] | tinyint(3) | unsigned | | NO | 0 | | | -| [class][5] | tinyint(3) | unsigned | | NO | 0 | | | -| [gender][6] | tinyint(3) | unsigned | | NO | 0 | | | -| [level][7] | tinyint(3) | unsigned | | NO | 0 | | | -| [xp][8] | int(10) | unsigned | | NO | 0 | | | -| [money][9] | int(10) | unsigned | | NO | 0 | | | -| [skin][10] | tinyint(3) | unsigned | | NO | 0 | | | -| [face][11] | tinyint(3) | unsigned | | NO | 0 | | | -| [hairStyle][12] | tinyint(3) | unsigned | | NO | 0 | | | -| [hairColor][13] | tinyint(3) | unsigned | | NO | 0 | | | -| [facialStyle][14] | tinyint(3) | unsigned | | NO | 0 | | | -| [bankSlots][15] | tinyint(3) | unsigned | | NO | 0 | | | -| [restState][16] | tinyint(3) | unsigned | | NO | 0 | | | -| [playerflags][17] | int(10) | unsigned | | NO | 0 | | | -| [position_x][18] | float | signed | | NO | 0 | | | -| [position_y][19] | float | signed | | NO | 0 | | | -| [position_z][20] | float | signed | | NO | 0 | | | -| [map][21] | smallint(5) | signed | | NO | 0 | | Map Identifier | -| [instance_id][22] | int(10) | unsigned | | NO | 0 | | | -| [instance_mode_mask][23] | tinyint(3) | unsigned | | NO | 0 | | | -| [orientation][24] | float | signed | | NO | 0 | | | -| [taximask][25] | text | signed | | NO | 0 | | | -| [online][26] | tinyint(3) | unsigned | | NO | 0 | | | -| [cinematic][27] | tinyint(3) | unsigned | | NO | 0 | | | -| [totaltime][28] | int(10) | unsigned | | NO | 0 | | | -| [leveltime][29] | int(10) | unsigned | | NO | 0 | | | -| [logout_time][30] | int(10) | unsigned | | NO | 0 | | | -| [is_logout_resting][31] | tinyint(3) | unsigned | | NO | 0 | | | -| [rest_bonus][32] | float | signed | | NO | 0 | | | -| [resettalents_cost][33] | int(10) | unsigned | | NO | 0 | | | -| [resettalents_time][34] | int(10) | unsigned | | NO | 0 | | | -| [trans_x][35] | float | signed | | NO | 0 | | | -| [trans_y][36] | float | signed | | NO | 0 | | | -| [trans_z][37] | float | signed | | NO | 0 | | | -| [trans_o][38] | float | signed | | NO | 0 | | | -| [transguid][39] | mediumint(8) | unsigned | | NO | 0 | | | -| [extra_flags][40] | smallint(5) | unsigned | | NO | 0 | | | -| [extra_flags][41] | smallint(5) | unsigned | | NO | 0 | | | -| [stable_slots][42] | tinyint(3) | unsigned | | NO | 0 | | | -| [at_login][43] | smallint(5) | unsigned | | NO | 0 | | | -| [zone][44] | smallint(5) | unsigned | | NO | 0 | | | -| [death_expire_time][45] | int(10) | unsigned | | NO | 0 | | | -| [taxi_path][46] | text | signed | | YES | NULL | | | -| [arenaPoints][47] | int(10) | unsigned | | NO | 0 | | | -| [totalhonorpoints][48] | int(10) | unsigned | | NO | 0 | | | -| [todayhonorpoints][49] | int(10) | unsigned | | NO | 0 | | | -| [yesterdayhonorpoints][50] | int(10) | unsigned | | NO | 0 | | | -| [totalkills][51] | int(10) | unsigned | | NO | 0 | | | -| [todayKills][52] | smallint(5) | unsigned | | NO | 0 | | | -| [yesterdayKills][53] | smallint(5) | unsigned | | NO | 0 | | | -| [chosenTitle][54] | int(10) | unsigned | | NO | 0 | | | -| [knownCurrencies][55] | bigint(20) | unsigned | | NO | 0 | | | -| [watchedFaction][56] | int(10) | unsigned | | NO | 0 | | | -| [drunk][57] | tinyint(3) | unsigned | | NO | 0 | | | -| [health][58] | int(10) | unsigned | | NO | 0 | | | -| [power][59] | int(10) | unsigned | | NO | 0 | | | -| [power][60] | int(10) | unsigned | | NO | 0 | | | -| [power][61] | int(10) | unsigned | | NO | 0 | | | -| [power][62] | int(10) | unsigned | | NO | 0 | | | -| [power][63] | int(10) | unsigned | | NO | 0 | | | -| [power][64] | int(10) | unsigned | | NO | 0 | | | -| [power][65] | int(10) | unsigned | | NO | 0 | | | -| [latency][66] | mediumint(8) | unsigned | | NO | 0 | | | -| [talentGroupsCount][67] | tinyint(3) | unsigned | | NO | 1 | | | -| [activeTalentGroup][68] | tinyint(3) | unsigned | | NO | 0 | | | -| [exploredzones][69] | longtext | signed | | YES | NULL | | | -| [equipmentcache][70] | longtext | signed | | YES | NULL | | | -| [ammoid][71] | int(10) | unsigned | | NO | 0 | | | -| [knownTitles][72] | longtext | signed | | YES | NULL | | | -| [actionbars][73] | longtext | unsigned | | NO | 0 | | | -| [grantableLevels][74] | longtext | unsigned | | NO | 0 | | | -| [creation_date][75] | timestamp | signed | | NO | CURRENT_TIMESTAMP | | | -| [deleteInfos_Account][76] | int(10) | unsigned | | YES | NULL | | | -| [deleteInfos_Name][77] | varchar(12) | unsigned | | YES | NULL | | | -| [deleteDate][78] | int(10) | unsigned | | YES | NULL | | | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | Unique | Global Unique Identifier | +| [account][2] | INT | UNSIGNED | | NO | 0 | | Account Identifier | +| [name][3] | VARCHAR(12) | SIGNED | | NO | NULL | | | +| [race][4] | TINYINT | UNSIGNED | | NO | 0 | | | +| [class][5] | TINYINT | UNSIGNED | | NO | 0 | | | +| [gender][6] | TINYINT | UNSIGNED | | NO | 0 | | | +| [level][7] | TINYINT | UNSIGNED | | NO | 0 | | | +| [xp][8] | INT | UNSIGNED | | NO | 0 | | | +| [money][9] | INT | UNSIGNED | | NO | 0 | | | +| [skin][10] | TINYINT | UNSIGNED | | NO | 0 | | | +| [face][11] | TINYINT | UNSIGNED | | NO | 0 | | | +| [hairStyle][12] | TINYINT | UNSIGNED | | NO | 0 | | | +| [hairColor][13] | TINYINT | UNSIGNED | | NO | 0 | | | +| [facialStyle][14] | TINYINT | UNSIGNED | | NO | 0 | | | +| [bankSlots][15] | TINYINT | UNSIGNED | | NO | 0 | | | +| [restState][16] | TINYINT | UNSIGNED | | NO | 0 | | | +| [playerflags][17] | INT | UNSIGNED | | NO | 0 | | | +| [position_x][18] | FLOAT | SIGNED | | NO | 0 | | | +| [position_y][19] | FLOAT | SIGNED | | NO | 0 | | | +| [position_z][20] | FLOAT | SIGNED | | NO | 0 | | | +| [map][21] | SMALLINT | SIGNED | | NO | 0 | | Map Identifier | +| [instance_id][22] | INT | UNSIGNED | | NO | 0 | | | +| [instance_mode_mask][23] | TINYINT | UNSIGNED | | NO | 0 | | | +| [orientation][24] | FLOAT | SIGNED | | NO | 0 | | | +| [taximask][25] | text | SIGNED | | NO | 0 | | | +| [online][26] | TINYINT | UNSIGNED | | NO | 0 | | | +| [cinematic][27] | TINYINT | UNSIGNED | | NO | 0 | | | +| [totaltime][28] | INT | UNSIGNED | | NO | 0 | | | +| [leveltime][29] | INT | UNSIGNED | | NO | 0 | | | +| [logout_time][30] | INT | UNSIGNED | | NO | 0 | | | +| [is_logout_resting][31] | TINYINT | UNSIGNED | | NO | 0 | | | +| [rest_bonus][32] | FLOAT | SIGNED | | NO | 0 | | | +| [resettalents_cost][33] | INT | UNSIGNED | | NO | 0 | | | +| [resettalents_time][34] | INT | UNSIGNED | | NO | 0 | | | +| [trans_x][35] | FLOAT | SIGNED | | NO | 0 | | | +| [trans_y][36] | FLOAT | SIGNED | | NO | 0 | | | +| [trans_z][37] | FLOAT | SIGNED | | NO | 0 | | | +| [trans_o][38] | FLOAT | SIGNED | | NO | 0 | | | +| [transguid][39] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [extra_flags][40] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [extra_flags][41] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [stable_slots][42] | TINYINT | UNSIGNED | | NO | 0 | | | +| [at_login][43] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [zone][44] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [death_expire_time][45] | INT | UNSIGNED | | NO | 0 | | | +| [taxi_path][46] | text | SIGNED | | YES | NULL | | | +| [arenaPoints][47] | INT | UNSIGNED | | NO | 0 | | | +| [totalhonorpoints][48] | INT | UNSIGNED | | NO | 0 | | | +| [todayhonorpoints][49] | INT | UNSIGNED | | NO | 0 | | | +| [yesterdayhonorpoints][50] | INT | UNSIGNED | | NO | 0 | | | +| [totalkills][51] | INT | UNSIGNED | | NO | 0 | | | +| [todayKills][52] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [yesterdayKills][53] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [chosenTitle][54] | INT | UNSIGNED | | NO | 0 | | | +| [knownCurrencies][55] | BIGINT | UNSIGNED | | NO | 0 | | | +| [watchedFaction][56] | INT | UNSIGNED | | NO | 0 | | | +| [drunk][57] | TINYINT | UNSIGNED | | NO | 0 | | | +| [health][58] | INT | UNSIGNED | | NO | 0 | | | +| [power][59] | INT | UNSIGNED | | NO | 0 | | | +| [power][60] | INT | UNSIGNED | | NO | 0 | | | +| [power][61] | INT | UNSIGNED | | NO | 0 | | | +| [power][62] | INT | UNSIGNED | | NO | 0 | | | +| [power][63] | INT | UNSIGNED | | NO | 0 | | | +| [power][64] | INT | UNSIGNED | | NO | 0 | | | +| [power][65] | INT | UNSIGNED | | NO | 0 | | | +| [latency][66] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [talentGroupsCount][67] | TINYINT | UNSIGNED | | NO | 1 | | | +| [activeTalentGroup][68] | TINYINT | UNSIGNED | | NO | 0 | | | +| [exploredzones][69] | longtext | SIGNED | | YES | NULL | | | +| [equipmentcache][70] | longtext | SIGNED | | YES | NULL | | | +| [ammoid][71] | INT | UNSIGNED | | NO | 0 | | | +| [knownTitles][72] | longtext | SIGNED | | YES | NULL | | | +| [actionbars][73] | longtext | UNSIGNED | | NO | 0 | | | +| [grantableLevels][74] | longtext | UNSIGNED | | NO | 0 | | | +| [creation_date][75] | TIMESTAMP | SIGNED | | NO | CURRENT_TIMESTAMP | | | +| [deleteInfos_Account][76] | INT | UNSIGNED | | YES | NULL | | | +| [deleteInfos_Name][77] | VARCHAR(12) | UNSIGNED | | YES | NULL | | | +| [deleteDate][78] | INT | UNSIGNED | | YES | NULL | | | [1]: #guid [2]: #account |