From 8cf1d7db707b54f5584d8c4af057cfeac36ba8d5 Mon Sep 17 00:00:00 2001
From: zephyrus <zephyrus@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Wed, 5 Mar 2008 02:16:34 +0000
Subject: - Added the auctiondb structure

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12294 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/main.sql             | 27 +++++++++++++++++++++++++++
 sql-files/upgrade_svn12294.sql | 26 ++++++++++++++++++++++++++
 2 files changed, 53 insertions(+)
 create mode 100644 sql-files/upgrade_svn12294.sql

(limited to 'sql-files')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index f3d1a947c..4b3b551cd 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -1,3 +1,30 @@
+--
+-- Table structure for table `auction`
+--
+
+DROP TABLE IF EXISTS `auction`;
+CREATE TABLE `auction` (
+  `auction_id` bigint(20) unsigned NOT NULL auto_increment,
+  `seller_id` int(11) unsigned NOT NULL default '0',
+  `seller_name` varchar(30) NOT NULL default '',
+  `buyer_id` int(11) unsigned NOT NULL default '0',
+  `buyer_name` varchar(30) NOT NULL default '',
+  `price` int(11) unsigned NOT NULL default '0',
+  `buynow` int(11) unsigned NOT NULL default '0',
+  `hours` smallint(6) NOT NULL default '0',
+  `timestamp` int(11) unsigned NOT NULL default '0',
+  `nameid` int(11) unsigned NOT NULL default '0',
+  `item_name` varchar(50) NOT NULL default '',
+  `type` smallint(6) NOT NULL default '0',
+  `refine` tinyint(3) unsigned NOT NULL default '0',
+  `attribute` tinyint(4) unsigned NOT NULL default '0',
+  `card0` smallint(11) NOT NULL default '0',
+  `card1` smallint(11) NOT NULL default '0',
+  `card2` smallint(11) NOT NULL default '0',
+  `card3` smallint(11) NOT NULL default '0',
+  PRIMARY KEY  (`auction_id`)
+) ENGINE=MyISAM;
+
 --
 -- Table structure for table `cart_inventory`
 --
diff --git a/sql-files/upgrade_svn12294.sql b/sql-files/upgrade_svn12294.sql
new file mode 100644
index 000000000..7405687b3
--- /dev/null
+++ b/sql-files/upgrade_svn12294.sql
@@ -0,0 +1,26 @@
+--
+-- Table structure for table `auction`
+--
+
+DROP TABLE IF EXISTS `auction`;
+CREATE TABLE `auction` (
+  `auction_id` bigint(20) unsigned NOT NULL auto_increment,
+  `seller_id` int(11) unsigned NOT NULL default '0',
+  `seller_name` varchar(30) NOT NULL default '',
+  `buyer_id` int(11) unsigned NOT NULL default '0',
+  `buyer_name` varchar(30) NOT NULL default '',
+  `price` int(11) unsigned NOT NULL default '0',
+  `buynow` int(11) unsigned NOT NULL default '0',
+  `hours` smallint(6) NOT NULL default '0',
+  `timestamp` int(11) unsigned NOT NULL default '0',
+  `nameid` int(11) unsigned NOT NULL default '0',
+  `item_name` varchar(50) NOT NULL default '',
+  `type` smallint(6) NOT NULL default '0',
+  `refine` tinyint(3) unsigned NOT NULL default '0',
+  `attribute` tinyint(4) unsigned NOT NULL default '0',
+  `card0` smallint(11) NOT NULL default '0',
+  `card1` smallint(11) NOT NULL default '0',
+  `card2` smallint(11) NOT NULL default '0',
+  `card3` smallint(11) NOT NULL default '0',
+  PRIMARY KEY  (`auction_id`)
+) ENGINE=MyISAM;
\ No newline at end of file
-- 
cgit v1.2.3-60-g2f50