diff options
| author | Francesco Borzì <borzifrancesco@gmail.com> | 2019-02-26 18:08:42 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-02-26 18:08:42 +0100 |
| commit | 07f4555b2d68397c612ec5ee6611844e4f6d9d21 (patch) | |
| tree | 4eb8139adec79c179419c12bc4da04e463f04c3a /docs/character_instance.md | |
| parent | 5de5a3ccf64a174adcec3070cd3bfeb6f6897254 (diff) | |
| parent | 49bdd146a2c870a4a2e5ae8fd77e90204d950fc8 (diff) | |
| download | wiki-07f4555b2d68397c612ec5ee6611844e4f6d9d21.tar.gz wiki-07f4555b2d68397c612ec5ee6611844e4f6d9d21.tar.bz2 wiki-07f4555b2d68397c612ec5ee6611844e4f6d9d21.zip | |
Merge pull request #8 from azerothcore/tc-bulk-import
Bulk import from TC 335 of DB doc
Diffstat (limited to 'docs/character_instance.md')
| -rw-r--r-- | docs/character_instance.md | 86 |
1 files changed, 78 insertions, 8 deletions
diff --git a/docs/character_instance.md b/docs/character_instance.md index d081832..ee819b2 100644 --- a/docs/character_instance.md +++ b/docs/character_instance.md @@ -1,8 +1,78 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_instance](character_instance) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -Instance | int(10) unsigned | -Permanent | tinyint(3) unsigned | -Extended | tinyint(3) unsigned | +# character\_instance + +`Back-to:Characters` + +**The \`character\_instance\` table** + +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="#character_instance-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="#character_instance-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="#character_instance-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> + +**Description of the fields** + +### guid + +The GUID of the character. See [characters.guid](http://collab.kpsn.org/display/tc/Characters+tc2#Characterstc2-guid) + +### instance + +The instance ID. See [instance.id](http://collab.kpsn.org/display/tc/Instance+tc2#Instancetc2-id) + +### permanent + +Boolean 0 or 1 controlling if the player has been bound to the instance. A player is bound to the instance only when he (or his party/raid) kills a creature with the CREATURE\_FLAG\_EXTRA\_INSTANCE\_BIND flag set in the [flags\_extras](http://collab.kpsn.org/display/tc/creature_template#creature_template-flags_extra) field. |