diff options
40 files changed, 475 insertions, 2537 deletions
diff --git a/docs/account_access.md b/docs/account_access.md index e988002..604fb48 100644 --- a/docs/account_access.md +++ b/docs/account_access.md @@ -8,64 +8,15 @@ This table holds security access level for any realm in [realmlist](realmlist) t **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#id">id</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#gmlevel">gmlevel</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#realmid">RealmID</a></p></td> -<td><p>int(11)</p></td> -<td><p>signed</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><div class="preformatted panel" style="border-width: 1px;"> -<div class="preformattedContent panelContent"> -<pre><code>-1</code></pre> -</div> -</div></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------|------------|------------|-----|------|---------|-------|---------| +| [id][1] | int(10) | unsigned | PRI | NO | | | | +| [gmlevel][2] | tinyint(3) | unsigned | | NO | | | | +| [RealmID][3] | int(11) | signed | PRI | NO | -1 | | | + +[1]: #id +[2]: #gmlevel +[3]: #realmid **Description of the fields** diff --git a/docs/areatrigger_involvedrelation.md b/docs/areatrigger_involvedrelation.md index 530270a..293fe66 100644 --- a/docs/areatrigger_involvedrelation.md +++ b/docs/areatrigger_involvedrelation.md @@ -10,50 +10,13 @@ If there is a record in the table for a quest, then the quest will not be comple **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comments</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#id">id</a></p></td> -<td><p>mediumint(8)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p>Identifier</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#quest">quest</a></p></td> -<td><p>mediumint(8)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p>Quest Identifier</p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comments | +|------------|--------------|------------|-----|------|---------|-------|------------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier | +| [quest][2] | mediumint(8) | unsigned | | NO | 0 | | Quest Identifier | + +[1]: #id +[2]: #quest **Description of the fields** diff --git a/docs/battleground_deserters.md b/docs/battleground_deserters.md index eaccff7..4861124 100644 --- a/docs/battleground_deserters.md +++ b/docs/battleground_deserters.md @@ -8,60 +8,15 @@ This table holds datas about BattleGrounds deserters. To enable storing this kin **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#guid">guid</a></p></td> -<td><p>int</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td> </td> -<td> </td> -<td> </td> -<td> </td> -</tr> -<tr class="odd"> -<td><p><a href="#type">type</a></p></td> -<td><p>tinyint</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td> </td> -<td> </td> -<td> </td> -<td> </td> -</tr> -<tr class="even"> -<td><p><a href="#datetime">datetime</a></p></td> -<td><p>datetime</p></td> -<td> </td> -<td> </td> -<td> </td> -<td> </td> -<td> </td> -<td> </td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------|----------|------------|-----|------|---------|-------|---------| +| [guid][1] | int | unsigned | | | | | | +| [type][2] | tinyint | unsigned | | | | | | +| [datetime][3] | datetime | | | | | | | + +[1]: #guid +[2]: #type +[3]: #datetime **Description of the fields** @@ -71,18 +26,14 @@ Link to characters.guid ### type -**0** = player leaves the BG - -**1** = player is kicked from BG because offline - -**2** = player is invited to join and refuses to do it - -**3** = player is invited to join and do nothing (time expires) - -**4** = player is invited to join and logs out +| Value | Description | +|-------|---------------------------------------------------------| +| 0 | player leaves the BG | +| 1 | player is kicked from BG because offline | +| 2 | player is invited to join and refuses to do it | +| 3 | player is invited to join and do nothing (time expires) | +| 4 | player is invited to join and logs out | ### datetime date and time of the event - - diff --git a/docs/character_account_data.md b/docs/character_account_data.md index b12c3df..b7dea2b 100644 --- a/docs/character_account_data.md +++ b/docs/character_account_data.md @@ -8,70 +8,17 @@ Contains data about character settings. **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#guid">guid</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#type">type</a></p></td> -<td><p>int(3)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#time">time</a></p></td> -<td><p>bigint(10)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#data">data</a></p></td> -<td><p>blob</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------|------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [type][2] | int(3) | unsigned | PRI | NO | 0 | | | +| [time][3] | bigint(10) | unsigned | | NO | 0 | | | +| [data][4] | blob | signed | | NO | | | | + +[1]: #guid +[2]: #type +[3]: #time +[4]: #data **Description of the fields** @@ -81,11 +28,13 @@ The character global unique identifier. See [Characters.guid](2129969.html#chara ### type -- 1 = Config cache per character -- 3 = Bindings cache per character -- 5 = Macros cache per character -- 6 = Layout cache per character -- 7 = Chat cache per character +| Value | Description | +|-------|------------------------------| +| 1 | Config cache per character | +| 3 | Bindings cache per character | +| 5 | Macros cache per character | +| 6 | Layout cache per character | +| 7 | Chat cache per character | ### time diff --git a/docs/character_achievement.md b/docs/character_achievement.md index 1b2356c..5bc3d54 100644 --- a/docs/character_achievement.md +++ b/docs/character_achievement.md @@ -10,59 +10,15 @@ This table holds information on the achievements a character has earned / comple **Structure** -<table> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#guid">guid</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#achievement">achievement</a></p></td> -<td><p>smallint(5)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -</tr> -<tr class="even"> -<td><p><a href="#date">date</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p><br /> -</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|-------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | | +| [achievement][2] | smallint(5) | unsigned | PRI | NO | | | | +| [date][3] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #achievement +[3]: #date **Description of the fields** @@ -76,4 +32,4 @@ The ID of the achievement from [Achievement.dbc](Achievement). ### date -The date/time when this achievement was earned, in Unix time. See [Unix Timestamp Calculator](http://www.unixtimestamp.com/index.php)
\ No newline at end of file +The date/time when this achievement was earned, in Unix time. See [Unix Timestamp Calculator](http://www.unixtimestamp.com/index.php) diff --git a/docs/character_achievement_progress.md b/docs/character_achievement_progress.md index 7e58a2f..f662f02 100644 --- a/docs/character_achievement_progress.md +++ b/docs/character_achievement_progress.md @@ -8,70 +8,17 @@ **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#guid">guid</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>"</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#criteria">criteria</a></p></td> -<td><p>smallint(5)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>"</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#counter">counter</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>"</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#date">date</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------|-------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | | +| [criteria][2] | smallint(5) | unsigned | PRI | NO | | | | +| [counter][3] | int(10) | unsigned | | NO | | | | +| [date][4] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #criteria +[3]: #counter +[4]: #date **Description of the fields** diff --git a/docs/character_arena_stats.md b/docs/character_arena_stats.md index 8c805b9..d2e0820 100644 --- a/docs/character_arena_stats.md +++ b/docs/character_arena_stats.md @@ -8,60 +8,15 @@ This table holds information about character's matchmaker rating in all team typ **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#guid">guid</a></p></td> -<td><p>int(10)</p></td> -<td><p>signed</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#slot">slot</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>signed</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#matchmakerrating">matchmakerRating</a></p></td> -<td><p>smallint(5)</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------------|-------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | signed | PRI | NO | | | | +| [slot][2] | tinyint(3) | signed | PRI | NO | | | | +| [matchmakerRating][3] | smallint(5) | signed | | NO | | | | + +[1]: #guid +[2]: #slot +[3]: #matchmakerrating **Description of the fields** @@ -73,11 +28,11 @@ The GUID of the character. See characters.guid Arena slot index: -0 - 2v2 - -1 - 3v3 - -2 - 5v5 +| Value | Description | +|-------|-------------| +| 0 | 2v2 | +| 1 | 3v3 | +| 2 | 5v5 | ### matchmakerRating diff --git a/docs/character_instance.md b/docs/character_instance.md index f1c43f3..a29ad1c 100644 --- a/docs/character_instance.md +++ b/docs/character_instance.md @@ -8,60 +8,15 @@ Contains the instance data for characters. **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#guid">guid</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#instance">instance</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#permanent">permanent</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [instance][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [permanent][3] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #instance +[3]: #permanent **Description of the fields** diff --git a/docs/character_queststatus_daily.md b/docs/character_queststatus_daily.md index 8bbc83d..994355b 100644 --- a/docs/character_queststatus_daily.md +++ b/docs/character_queststatus_daily.md @@ -8,60 +8,15 @@ Holds information on the daily quest status of every player. The quest must have **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> |