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

Bulk import from TC 335 of DB doc

1 files changed, 234 insertions, 18 deletions

diff --git a/docs/item_instance.md b/docs/item_instance.md
index 8cdea1c..8f255b0 100644
--- a/docs/item_instance.md
+++ b/docs/item_instance.md
@@ -1,18 +1,234 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [item_instance](item_instance)
-
-Column | Type | Description
---- | --- | ---
-Guid | int(10) unsigned | 
-ItemEntry | mediumint(8) unsigned | 
-Owner_guid | int(10) unsigned | 
-CreatorGuid | int(10) unsigned | 
-GiftCreatorGuid | int(10) unsigned | 
-Count | int(10) unsigned | 
-Duration | int(10) | 
-Charges | tinytext | 
-Flags | mediumint(8) unsigned | 
-Enchantments | text | 
-RandomPropertyId | smallint(5) | 
-Durability | smallint(5) unsigned | 
-PlayedTime | int(10) unsigned | 
-Text | text | 
+# item\_instance
+
+`Back-to:Characters`
+
+**The \`item\_instance\` table**
+
+This table holds individual item instance information for all items currently equipped in some kind of character bag or bank, in auctionhouses, in guild banks or in mails.
+
+**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="#item_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="#item_instance-itemEnry">itemEntry</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>
+<tr class="even">
+<td><p><a href="#item_instance-owner_guid">owner_guid</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="#item_instance-creatorGuid">creatorGuid</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="#item_instance-giftCreatorGuid">giftCreatorGuid</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="#item_instance-count">count</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>1</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#item_instance-duration">duration</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="#item_instance-charges">charges</a></p></td>
+<td><p>tinytext</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>YES</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#item_instance-flags">flags</a></p></td>
+<td><p>mediunint(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>
+<tr class="odd">
+<td><p><a href="#item_instance-enchantments">enchantments</a></p></td>
+<td><p>text</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>
+<tr class="even">
+<td><p><a href="#item_instance-randomPropertyId">randomPropertyId</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>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#item_instance-durability">durability</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> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#item_instance-playedTime">playedTime</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="#item_instance-text">text</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>YES</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### guid
+
+The GUID of the item. This number is unique for each item instance.
+
+### itemEnry
+
+[Item](item_template_2130222.html#item_template-entry) entry.
+
+### owner\_guid
+
+The GUID of the character who has ownership of this item. See [characters.guid](2129969.html#characters(table)-guid)
+
+### creatorGuid
+
+[GUID](2129969.html#characters(table)-guid) of character who created the item.
+
+### giftCreatorGuid
+
+[GUID](2129969.html#characters(table)-guid) of character who created the [item](character_gifts_2129986.html#character_gifts-item_guid).
+
+### count
+
+Current number of item copies in the stack.
+
+### duration
+
+`field-no-description|6`
+
+### charges
+
+`The number of charges for each of the five possible spellcharges on an item,  specified via five space separated integers.`
+
+### flags
+
+`field-no-description|8`
+
+### enchantments
+
+Enchantments from SpellItemEnchantment.dbc
+
+### randomPropertyId
+
+`field-no-description|10`
+
+### durability
+
+Current item durability.
+
+### playedTime
+
+Time in seconds
+
+### text
+
+The text contained in that specific item.
+
+data-anchor=