Merge pull request #8 from azerothcore/tc-bulk-import

Bulk import from TC 335 of DB doc

1 files changed, 195 insertions, 0 deletions

diff --git a/docs/character_battleground_data.md b/docs/character_battleground_data.md
new file mode 100644
index 0000000..d7961d3
--- /dev/null
+++ b/docs/character_battleground_data.md
@@ -0,0 +1,195 @@
+# character\_battleground\_data
+
+`Back-to:Characters`
+
+**The \`character\_battleground\_data\` table**
+
+This table holds information for each character in a battleground. Also hold info about their last position before joining the battleground.
+
+**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="#character_battleground_data-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>Global Unique Identifier</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_battleground_data-instanceId">instanceId</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>Instance Identifier</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_battleground_data-team">team</a></p></td>
+<td><p>smallint(5)</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="#character_battleground_data-joinX">joinX</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</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="even">
+<td><p><a href="#character_battleground_data-joinY">joinY</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</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="#character_battleground_data-joinZ">joinZ</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</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="even">
+<td><p><a href="#character_battleground_data-joinO">joinO</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</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="#character_battleground_data-joinMapId">joinMapId</a></p></td>
+<td><p>smallint(5)</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>Map Identifier</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_battleground_data-taxiStart">taxiStart</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>
+<tr class="odd">
+<td><p><a href="#character_battleground_data-taxiEnd">taxiEnd</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>
+<tr class="even">
+<td><p><a href="#character_battleground_data-mountSpell">mountSpell</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> </p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### guid
+
+The character guid. See [characters.guid](2129969.html#characters(table)-id).
+
+### instanceId
+
+This is the battleground instanceId. It's shared with [instance.id](instance_2130197.html#instance-id), but instead of putting data in that table, it's here.
+
+### team
+
+teamId:
+
+469 - Alliance
+
+67 - Horde
+0 - GM
+
+### joinX
+
+Character's last X position before joining a battleground.
+
+### joinY
+
+Character's last Y position before joining a battleground.
+
+### joinZ
+
+Character's last Z position before joining a battleground.
+
+### joinO
+
+Character's last orientation bbefore joining a battleground.
+
+### joinMapId
+
+Character's last mapId before joining a battleground.
+
+### taxiStart
+
+Character's last taxi node before joining a battleground.
+
+### taxiEnd
+
+Character's heading taxi node before joining a battleground.
+
+### mountSpell
+
+The mount spell ID. See Spell.dbc column 1