From 104be5479d7c1192a73711b932e87c571e434985 Mon Sep 17 00:00:00 2001
From: Andreas Habel <mail@exceptionfault.de>
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/createTables.sql')

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 4db80e8..a517224 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 

