Core/Creatures: Implemented Basic Creature Scaling (#20026)

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_07_29_00_world.sql b/sql/updates/world/master/2017_07_29_00_world.sql
new file mode 100644
index 00000000000..9307960390f
--- /dev/null
+++ b/sql/updates/world/master/2017_07_29_00_world.sql
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS `creature_template_scaling`;
+CREATE TABLE `creature_template_scaling` (
+  `Entry` MEDIUMINT (8) UNSIGNED NOT NULL,
+  `LevelScalingMin` SMALLINT (5) UNSIGNED NOT NULL DEFAULT 0,
+  `LevelScalingMax` SMALLINT (5) UNSIGNED NOT NULL DEFAULT 0,
+  `LevelScalingDelta` SMALLINT (5) NOT NULL DEFAULT 0,
+  `VerifiedBuild` SMALLINT (5) DEFAULT NULL,
+  PRIMARY KEY (`Entry`)
+);