diff options
Diffstat (limited to 'sql/updates/0.6/2765_auctionHouse.sql')
| -rw-r--r-- | sql/updates/0.6/2765_auctionHouse.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/0.6/2765_auctionHouse.sql b/sql/updates/0.6/2765_auctionHouse.sql new file mode 100644 index 00000000000..7b9b56ab03a --- /dev/null +++ b/sql/updates/0.6/2765_auctionHouse.sql @@ -0,0 +1,17 @@ +DROP TABLE IF EXISTS `auctionhouse`; +CREATE TABLE `auctionhouse` ( + `id` bigint(20) unsigned NOT NULL default '0', + `auctioneerguid` int(32) NOT NULL default '0', + `itemguid` int(32) NOT NULL default '0', + `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', + `itemowner` int(32) NOT NULL default '0', + `buyoutprice` int(32) NOT NULL default '0', + `time` bigint(40) NOT NULL default '0', + `buyguid` int(32) NOT NULL default '0', + `lastbid` int(32) NOT NULL default '0', + `startbid` int(32) NOT NULL default '0', + `deposit` int(11) NOT NULL default '0', + `location` tinyint(3) unsigned NOT NULL default '3', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + |