Import DB wiki from TC 335

1 files changed, 178 insertions, 14 deletions

diff --git a/docs/auctionhouse.md b/docs/auctionhouse.md
index 8e54700..e8830cb 100644
--- a/docs/auctionhouse.md
+++ b/docs/auctionhouse.md
@@ -1,14 +1,178 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [auctionhouse](auctionhouse)
-
-Column | Type | Description
---- | --- | ---
-Id | int(10) unsigned | 
-Auctioneerguid | int(10) unsigned | 
-Itemguid | int(10) unsigned | 
-Itemowner | int(10) unsigned | 
-Buyoutprice | int(10) unsigned | 
-Time | int(10) unsigned | 
-Buyguid | int(10) unsigned | 
-Lastbid | int(10) unsigned | 
-Startbid | int(10) unsigned | 
-Deposit | int(10) unsigned | 
+# auctionhouse
+
+`Back-to:Characters`
+
+**The \`auctionhouse\` table**
+
+Contains all information about the currently ongoing auctions in the auction houses. It controls what items are put up for auction and who put it up, who is the highest bidder, etc.
+
+This table is used by Trinity while running and not a table that you would usually edit.
+
+**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="#auctionhouse-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>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#auctionhouse-auctioneerguid">auctioneerguid</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="#auctionhouse-itemguid">itemguid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p>UNI</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="#auctionhouse-itemowner">itemowner</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="#auctionhouse-buyoutprice">buyoutprice</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="#auctionhouse-time">time</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="#auctionhouse-buyguid">buyguid</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="#auctionhouse-lastbid">lastbid</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="#auctionhouse-startbid">startbid</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="#auctionhouse-deposit">deposit</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>
+
+**Description of the fields**
+
+### id
+
+Unique identifier for every auction.
+
+### auctioneerguid
+
+The GUID of the creature where the auction item was added. See creature.guid
+
+### itemguid
+
+The GUID of the item that is up for auction. See item\_instance.guid
+
+### itemowner
+
+The GUID of the owner of the item up for auction. See characters.guid
+
+### buyoutprice
+
+The buyout price of the item in copper. Divide by 100 to get silver and by 100 again to get gold.
+
+### time
+
+The time when the auction will end, measured in [Unix time](http://en.wikipedia.org/wiki/Unix_time) (number of seconds from 00:00 Jan 1, 1970).
+
+### buyguid
+
+The GUID of the highest bidder. See characters.guid
+
+### lastbid
+
+The amount of copper of the last bid put on the item.
+
+### startbid
+
+The amount of copper of the starting bid.
+
+### deposit
+
+The amount of copper spent on the deposit.