aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorGigi1237 <luigi.sciolla@gmail.com>2015-08-22 20:29:17 +0200
committerShauren <shauren.trinity@gmail.com>2016-04-11 18:22:09 +0200
commitc19172cad9a3302b7f5c8d5ca1d96de9a7311847 (patch)
tree674d46c12b63b15a726909093f082aaa58128f7b /sql/base
parent116c8070769b32b67400b4506a2e5b999764185a (diff)
Core/Blackmarket: Implemented black market
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql26
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 23e7bb77d25..d5117954f5c 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -240,6 +240,32 @@ LOCK TABLES `banned_addons` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `blackmarket_auctions`
+--
+
+DROP TABLE IF EXISTS `blackmarket_auctions`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `blackmarket_auctions` (
+ `marketId` int(10) NOT NULL DEFAULT '0',
+ `currentBid` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `time` int(10) NOT NULL DEFAULT '0',
+ `numBids` int(10) NOT NULL DEFAULT '0',
+ `bidder` bigint(20) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`marketId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `blackmarket_auctions`
+--
+
+LOCK TABLES `blackmarket_auctions` WRITE;
+/*!40000 ALTER TABLE `blackmarket_auctions` DISABLE KEYS */;
+/*!40000 ALTER TABLE `blackmarket_auctions` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `bugreport`
--