Core/Blackmarket: Implemented black market

3 files changed, 47 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`
 --
 
diff --git a/sql/updates/characters/2016_04_11_01_characters.sql b/sql/updates/characters/2016_04_11_01_characters.sql
new file mode 100644
index 00000000000..bdc6532b1e2
--- /dev/null
+++ b/sql/updates/characters/2016_04_11_01_characters.sql
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS `blackmarket_auctions`;
+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;
diff --git a/sql/updates/world/2016_04_11_02_world.sql b/sql/updates/world/2016_04_11_02_world.sql
new file mode 100644
index 00000000000..2c362b80564
--- /dev/null
+++ b/sql/updates/world/2016_04_11_02_world.sql
@@ -0,0 +1,12 @@
+DROP TABLE IF EXISTS `blackmarket_template`;
+CREATE TABLE `blackmarket_template` (
+  `marketId` int(10) NOT NULL DEFAULT '0',
+  `sellerNpc` mediumint(8) NOT NULL DEFAULT '0',
+  `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `quantity` int(10) NOT NULL DEFAULT '1',
+  `minBid` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `duration` int(10) NOT NULL DEFAULT '0',
+  `chance` float NOT NULL DEFAULT '0',
+  `bonusListIDs` text,
+  PRIMARY KEY (`marketId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;