diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_08_14_01_world_creature_template.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_14_01_world_creature_template.sql b/sql/updates/world/2014_08_14_01_world_creature_template.sql new file mode 100644 index 00000000000..8889a424b62 --- /dev/null +++ b/sql/updates/world/2014_08_14_01_world_creature_template.sql @@ -0,0 +1,16 @@ +ALTER TABLE `creature_template` + DROP COLUMN `mindmg`, + DROP COLUMN `maxdmg`, + DROP COLUMN `attackpower`, + DROP COLUMN `minrangedmg`, + DROP COLUMN `maxrangedmg`, + DROP COLUMN `rangedattackpower`, + CHANGE `baseattacktime` `BaseAttackTime` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `rangeattacktime` `RangeAttackTime` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + ADD COLUMN `BaseVariance` FLOAT DEFAULT 1 NOT NULL AFTER `RangeAttackTime`, + ADD COLUMN `RangeVariance` FLOAT DEFAULT 1 NOT NULL AFTER `BaseVariance`, + CHANGE `Health_mod` `HealthModifier` FLOAT DEFAULT 1 NOT NULL, + CHANGE `Mana_mod` `ManaModifier` FLOAT DEFAULT 1 NOT NULL, + CHANGE `Armor_mod` `ArmorModifier` FLOAT DEFAULT 1 NOT NULL, + CHANGE `dmg_multiplier` `DamageModifier` FLOAT DEFAULT 1 NOT NULL AFTER `ArmorModifier`, + ADD COLUMN `ExperienceModifier` FLOAT DEFAULT 1 NOT NULL AFTER `DamageModifier`; |