summaryrefslogtreecommitdiff
path: root/docs/item_set_names.md
diff options
context:
space:
mode:
authorFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
committerFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
commita35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch)
tree91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/item_set_names.md
parentd8d1823802ded97300fa57405d80b16736603489 (diff)
downloadwiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz
wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2
wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip
Import DB wiki from TC 335
Diffstat (limited to 'docs/item_set_names.md')
-rw-r--r--docs/item_set_names.md108
1 files changed, 100 insertions, 8 deletions
diff --git a/docs/item_set_names.md b/docs/item_set_names.md
index 1e01f6c..360743a 100644
--- a/docs/item_set_names.md
+++ b/docs/item_set_names.md
@@ -1,8 +1,100 @@
-[Database Structure](Database-Structure) > [World-Database](World-Database) > [item_set_names](item_set_names)
-
-Column | Type | Description
---- | --- | ---
-Entry | mediumint(8) unsigned |
-Name | varchar(255) |
-InventoryType | tinyint(3) unsigned |
-VerifiedBuild | smallint(6) |
+# item\_set\_names
+
+`Back-to:World`
+
+**The \`item\_set\_names\` table**
+
+`table-no-description`
+
+**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_set_names-entry">entry</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> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#item_set_names-name">name</a></p></td>
+<td><p>varchar(255)</p></td>
+<td><p>signed</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#item_set_names-InventoryType">InventoryType</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>
+<tr class="odd">
+<td><p><a href="#item_set_names-WDBVerified">WDBVerified</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>1</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### entry
+
+Entry from item\_template
+
+### name
+
+Name of the item
+
+### InventoryType
+
+`field-no-description|3`
+
+### WDBVerified
+
+This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.
+
+If value is 0 then it has not been parsed yet.
+
+If value is above 0 then it has been parsed with WDB files from that specific client build.
+
+If value is -1 then it is just a place holder until proper data are found on WDBs.
+
+If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.