diff options
| -rw-r--r-- | sql/characters.sql | 17 |
1 files changed, 11 insertions, 6 deletions
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'; -- |