From f4b96f0347ad3d19901e6a076998a86b137a677a Mon Sep 17 00:00:00 2001
From: Chaz Brown <iamparadox@netscape.net>
Date: Mon, 4 May 2009 16:46:57 -0400
Subject: fix more forgotten changes in full characters.sql

--HG--
branch : trunk
---
 sql/characters.sql | 17 +++++++++++------
 1 file changed, 11 insertions(+), 6 deletions(-)

(limited to 'sql/characters.sql')

diff --git a/sql/characters.sql b/sql/characters.sql
index 479a27d1b5f..4cab438342a 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -385,13 +385,15 @@ CREATE TABLE `character_aura` (
   `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
   `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
   `spell` int(11) unsigned NOT NULL default '0',
-  `effect_index` int(11) unsigned NOT NULL default '0',
+  `effect_mask` int(11) unsigned NOT NULL default '0',
   `stackcount` int(11) NOT NULL default '1',
-  `amount` int(11) NOT NULL default '0',
+  `amount0` int(11) NOT NULL default '0',
+  `amount1` int(11) NOT NULL default '0',
+  `amount2` int(11) NOT NULL default '0',
   `maxduration` int(11) NOT NULL default '0',
   `remaintime` int(11) NOT NULL default '0',
   `remaincharges` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`guid`,`spell`,`effect_index`)
+  PRIMARY KEY  (`guid`,`spell`,`effect_mask`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
 
 --
@@ -547,6 +549,7 @@ CREATE TABLE `character_pet` (
   `resettalents_time` bigint(20) unsigned NOT NULL default '0',
   `abdata` longtext,
   `teachspelldata` longtext,
+  `load_flags` int(3) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `owner` (`owner`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
@@ -1312,13 +1315,15 @@ CREATE TABLE `pet_aura` (
   `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
   `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
   `spell` int(11) unsigned NOT NULL default '0',
-  `effect_index` int(11) unsigned NOT NULL default '0',
+  `effect_mask` int(11) unsigned NOT NULL default '0',
   `stackcount` int(11) NOT NULL default '1',
-  `amount` int(11) NOT NULL default '0',
+  `amount0` int(11) NOT NULL default '0',
+  `amount1` int(11) NOT NULL default '0',
+  `amount2` int(11) NOT NULL default '0',
   `maxduration` int(11) NOT NULL default '0',
   `remaintime` int(11) NOT NULL default '0',
   `remaincharges` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`guid`,`spell`,`effect_index`)
+  PRIMARY KEY  (`guid`,`spell`,`effect_mask`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
 
 --
-- 
cgit v1.2.3

