From 104be5479d7c1192a73711b932e87c571e434985 Mon Sep 17 00:00:00 2001 From: Andreas Habel Date: Fri, 17 Oct 2008 12:57:33 +0000 Subject: Added SQL table definitions for item auctions. --- src/sql/mysql/createTables.sql | 69 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 69 insertions(+) (limited to 'src/sql/mysql') diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 4db80e82..a5172245 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -73,6 +73,25 @@ CREATE TABLE IF NOT EXISTS `tmw_char_skills` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- table: `tmw_items` +-- +CREATE TABLE IF NOT EXISTS `tmw_items` ( + `id` int(10) unsigned NOT NULL auto_increment, + `name` varchar(100) NOT NULL, + `description` varchar(255) NOT NULL, + `image` varchar(50) NOT NULL, + `weight` smallint(5) unsigned NOT NULL, + `itemtype` varchar(50) NOT NULL, + `effect` varchar(100) NULL, + `dyestring` varchar(50) NULL, + -- + PRIMARY KEY (`id`), + KEY `itemtype` (`itemtype`) +) ENGINE=InnoDB +DEFAULT CHARSET=utf8 +AUTO_INCREMENT=1 ; + -- -- table: `tmw_inventories` -- @@ -155,3 +174,53 @@ CREATE TABLE IF NOT EXISTS `tmw_quests` ( ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- table: `tmw_auctions` +-- + +CREATE TABLE IF NOT EXISTS `tmw_auctions` ( + `auction_id` int(10) unsigned NOT NULL auto_increment, + `auction_state` tinyint(3) unsigned NOT NULL, + `char_id` int(10) unsigned NOT NULL, + `itemclass_id` int(10) unsigned NOT NULL, + `amount` int(10) unsigned NOT NULL, + `start_time` int(10) unsigned NOT NULL, + `end_time` int(10) unsigned NOT NULL, + `start_price` int(10) unsigned NOT NULL, + `min_price` int(10) unsigned NULL, + `buyout_price` int(10) unsigned NULL, + `description` varchar(255) NULL, + -- + PRIMARY KEY (`auction_id`), + KEY (`auction_state`), + KEY (`itemclass_id`), + KEY (`char_id`), + FOREIGN KEY (`char_id`) + REFERENCES `tmw_characters` (`id`) + ON DELETE CASCADE +) ENGINE=InnoDB +DEFAULT CHARSET=utf8 +AUTO_INCREMENT=1 ; + +-- +-- table: `tmw_auction_bids` +-- + +CREATE TABLE IF NOT EXISTS `tmw_auction_bids` ( + `bid_id` int(10) unsigned NOT NULL auto_increment, + `auction_id` int(10) unsigned NOT NULL, + `char_id` int(10) unsigned NOT NULL, + `bid_time` int(10) unsigned NOT NULL, + `bid_price` int(10) unsigned NOT NULL, + -- + PRIMARY KEY (`bid_id`), + KEY (`auction_id`), + KEY (`char_id`), + FOREIGN KEY (`char_id`) + REFERENCES `tmw_characters` (`id`) + ON DELETE CASCADE +) ENGINE=InnoDB +DEFAULT CHARSET=utf8 +AUTO_INCREMENT=1 ; + -- cgit v1.2.3-60-g2f50