From 469b836114cd1530d93aa946f6f6e1f995e091ab Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Fri, 16 Jan 2015 23:32:41 +0100
Subject: Core/Auras: Fixed saving all aura effect values to database

---
 sql/base/characters_database.sql | 107 +++++++++++++++++++++++++++------------
 1 file changed, 75 insertions(+), 32 deletions(-)

(limited to 'sql/base/characters_database.sql')

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 88327122f26..aa5ec6f9c5a 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -483,22 +483,16 @@ DROP TABLE IF EXISTS `character_aura`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_aura` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `caster_guid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier',
-  `item_guid` binary(16) NOT NULL DEFAULT '0',
-  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `effect_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `recalculate_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `stackcount` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `amount0` int(11) NOT NULL DEFAULT '0',
-  `amount1` int(11) NOT NULL DEFAULT '0',
-  `amount2` int(11) NOT NULL DEFAULT '0',
-  `base_amount0` int(11) NOT NULL DEFAULT '0',
-  `base_amount1` int(11) NOT NULL DEFAULT '0',
-  `base_amount2` int(11) NOT NULL DEFAULT '0',
-  `maxduration` int(11) NOT NULL DEFAULT '0',
-  `remaintime` int(11) NOT NULL DEFAULT '0',
-  `remaincharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`,`effect_mask`)
+  `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier',
+  `itemGuid` binary(16) NOT NULL,
+  `spell` int(10) unsigned NOT NULL,
+  `effectMask` int(10) unsigned NOT NULL,
+  `recalculateMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `stackCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `maxDuration` int(11) NOT NULL DEFAULT '0',
+  `remainTime` int(11) NOT NULL DEFAULT '0',
+  `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -511,6 +505,34 @@ LOCK TABLES `character_aura` WRITE;
 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
+-- Table structure for table `character_aura_effect`
+--
+
+DROP TABLE IF EXISTS `character_aura_effect`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `character_aura_effect` (
+  `guid` bigint(20) unsigned NOT NULL,
+  `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier' ,
+  `itemGuid` binary(16) NOT NULL,
+  `spell` int(10) unsigned NOT NULL ,
+  `effectMask` int(10) unsigned NOT NULL,
+  `effectIndex` tinyint(3) unsigned NOT NULL,
+  `amount` int(11) NOT NULL DEFAULT 0,
+  `baseAmount` int(11) NOT NULL DEFAULT 0,
+PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`,`effectIndex`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
+
+--
+-- Dumping data for table `character_aura_effect`
+--
+
+LOCK TABLES `character_aura_effect` WRITE;
+/*!40000 ALTER TABLE `character_aura_effect` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_aura_effect` ENABLE KEYS */;
+UNLOCK TABLES;
+
 --
 -- Table structure for table `character_banned`
 --
@@ -2476,22 +2498,16 @@ DROP TABLE IF EXISTS `pet_aura`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `pet_aura` (
-  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `caster_guid` binary(16) NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
-  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `effect_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `recalculate_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `stackcount` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `amount0` mediumint(8) NOT NULL,
-  `amount1` mediumint(8) NOT NULL,
-  `amount2` mediumint(8) NOT NULL,
-  `base_amount0` mediumint(8) NOT NULL,
-  `base_amount1` mediumint(8) NOT NULL,
-  `base_amount2` mediumint(8) NOT NULL,
-  `maxduration` int(11) NOT NULL DEFAULT '0',
-  `remaintime` int(11) NOT NULL DEFAULT '0',
-  `remaincharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`spell`,`effect_mask`)
+  `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier',
+  `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier',
+  `spell` int(10) unsigned NOT NULL,
+  `effectMask` int(10) unsigned NOT NULL,
+  `recalculateMask` int(10) unsigned NOT NULL DEFAULT 0,
+  `stackCount` tinyint(3) unsigned NOT NULL DEFAULT 1,
+  `maxDuration` int(11) NOT NULL DEFAULT 0,
+  `remainTime` int(11) NOT NULL DEFAULT 0,
+  `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`guid`,`spell`,`effectMask`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -2504,6 +2520,33 @@ LOCK TABLES `pet_aura` WRITE;
 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
+-- Table structure for table `pet_aura_effect`
+--
+
+DROP TABLE IF EXISTS `pet_aura_effect`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `pet_aura_effect` (
+  `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier',
+  `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier' ,
+  `spell` int(10) unsigned NOT NULL,
+  `effectMask` int(10) unsigned NOT NULL,
+  `effectIndex` tinyint(3) unsigned NOT NULL,
+  `amount` int(11) NOT NULL DEFAULT 0,
+  `baseAmount` int(11) NOT NULL DEFAULT 0,
+PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`,`effectIndex`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
+
+--
+-- Dumping data for table `pet_aura_effect`
+--
+
+LOCK TABLES `pet_aura_effect` WRITE;
+/*!40000 ALTER TABLE `pet_aura_effect` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pet_aura_effect` ENABLE KEYS */;
+UNLOCK TABLES;
+
 --
 -- Table structure for table `pet_spell`
 --
-- 
cgit v1.2.3

