diff options
| author | Chaz Brown <iamparadox@netscape.net> | 2009-05-04 16:46:57 -0400 |
|---|---|---|
| committer | Chaz Brown <iamparadox@netscape.net> | 2009-05-04 16:46:57 -0400 |
| commit | f4b96f0347ad3d19901e6a076998a86b137a677a (patch) | |
| tree | 6436dd89618bc279cae121d315ebe4ba424eb033 | |
| parent | 61972025a2b19c2a49acd338183d930fc5ac033d (diff) | |
fix more forgotten changes in full characters.sql
--HG--
branch : trunk
| -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'; -- |