diff options
| author | maximius <none@none> | 2009-11-01 17:53:07 -0800 |
|---|---|---|
| committer | maximius <none@none> | 2009-11-01 17:53:07 -0800 |
| commit | b257a28fa9a9177df32845db8171d376bd6d4404 (patch) | |
| tree | d1093029c66fc36a705aa0f344ba3a4fb77e36d5 /sql/characters.sql | |
| parent | 2b2b2a1d0ec0e8942b27047f6706f29775a00eb8 (diff) | |
*Cleanup, fix many cases of unoptimized loops, potential crashes, excessively large data types, unnecessary or wrong casts, non-standardized function calls, and so on..
*Proper Maexxna Web Spray locations (old locations sent players flying into the air)
--HG--
branch : trunk
Diffstat (limited to 'sql/characters.sql')
| -rw-r--r-- | sql/characters.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index 8ff9616c487..80b164ba143 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -444,14 +444,14 @@ 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_mask` int(11) unsigned NOT NULL default '0', - `stackcount` int(11) NOT NULL default '1', + `effect_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', `maxduration` int(11) NOT NULL default '0', `remaintime` int(11) NOT NULL default '0', - `remaincharges` int(11) NOT NULL default '0', + `remaincharges` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`guid`,`spell`,`effect_mask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; @@ -1492,14 +1492,14 @@ 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_mask` int(11) unsigned NOT NULL default '0', - `stackcount` int(11) NOT NULL default '1', + `effect_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', `maxduration` int(11) NOT NULL default '0', `remaintime` int(11) NOT NULL default '0', - `remaincharges` int(11) NOT NULL default '0', + `remaincharges` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`guid`,`spell`,`effect_mask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; |