diff options
| author | Brian <runningnak3d@gmail.com> | 2010-01-21 18:51:00 -0700 |
|---|---|---|
| committer | Brian <runningnak3d@gmail.com> | 2010-01-21 18:51:00 -0700 |
| commit | 268aa045932dae72d5d6ced7658f31b820fbfde6 (patch) | |
| tree | 15366e6785c9223386038891eb5fed739df4d1ec | |
| parent | ea3b11f8c22a3eef0725bba4ed05888e72c9851e (diff) | |
* SQL need to restore the *structure* of the DB after the backout
* from the previous commit
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/7147_world_creature_classlevelstats.sql | 4 | ||||
| -rw-r--r-- | sql/updates/7147_world_creature_template.sql | 10 |
2 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/7147_world_creature_classlevelstats.sql b/sql/updates/7147_world_creature_classlevelstats.sql new file mode 100644 index 00000000000..6b10bb9806c --- /dev/null +++ b/sql/updates/7147_world_creature_classlevelstats.sql @@ -0,0 +1,4 @@ +ALTER TABLE `creature_classlevelstats` +DROP COLUMN `basedmg`, +DROP COLUMN `baserangeddmg`; + diff --git a/sql/updates/7147_world_creature_template.sql b/sql/updates/7147_world_creature_template.sql new file mode 100644 index 00000000000..2f46ba513f0 --- /dev/null +++ b/sql/updates/7147_world_creature_template.sql @@ -0,0 +1,10 @@ +ALTER TABLE `creature_template` +DROP COLUMN `dmg_Mod`, +DROP COLUMN `rangeddmg_Mod`; +ADD COLUMN `mindmg` float NOT NULL DEFAULT '0' AFTER `rank`, +ADD COLUMN `maxdmg` float NOT NULL DEFAULT '0' AFTER `mindmg`, +ADD COLUMN `attackpower` int(10) unsigned NOT NULL DEFAULT '0' AFTER `dmgschool`, +ADD COLUMN `minrangedmg` float NOT NULL DEFAULT '0' AFTER `trainer_race`, +ADD COLUMN `maxrangedmg` float NOT NULL DEFAULT '0' AFTER `minrangedmg`, +ADD COLUMN `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `maxrangedmg`; + |