DB/Creature_classlevelstats: Prepare table for attack power and damage.

1 files changed, 6 insertions, 0 deletions

diff --git a/sql/updates/world/2013_12_28_00_world_creature_classlevelstats.sql b/sql/updates/world/2013_12_28_00_world_creature_classlevelstats.sql
new file mode 100644
index 00000000000..0ca50efa68b
--- /dev/null
+++ b/sql/updates/world/2013_12_28_00_world_creature_classlevelstats.sql
@@ -0,0 +1,6 @@
+ALTER TABLE creature_classlevelstats ADD attackpower SMALLINT(6) DEFAULT 0 NOT NULL;
+ALTER TABLE creature_classlevelstats ADD rangedattackpower SMALLINT(6) DEFAULT 0 NOT NULL;
+ALTER TABLE creature_classlevelstats ADD damage_base FLOAT DEFAULT 0 NOT NULL;
+ALTER TABLE creature_classlevelstats ADD damage_exp1 FLOAT DEFAULT 0 NOT NULL;
+ALTER TABLE creature_classlevelstats ADD damage_exp2 FLOAT DEFAULT 0 NOT NULL;
+ALTER TABLE creature_classlevelstats ADD `comment` BLOB;