diff options
| author | Vincent-Michael <vincent_michael@gmx.de> | 2016-09-08 11:52:35 +0200 |
|---|---|---|
| committer | Vincent-Michael <vincent_michael@gmx.de> | 2016-09-08 11:52:35 +0200 |
| commit | 32f78473a493dacf1170887ed2fcb2895caa151f (patch) | |
| tree | d8180fb389d40b8af077a9d11a59aeb6b6659d29 | |
| parent | f94785b28f563960c31923428861c5c96430f50d (diff) | |
DB/Hotfixes: Updated hotfixes creature_difficulty table structure for 7.0.3
| -rw-r--r-- | sql/updates/hotfixes/6.x/2016_09_08_00_hotfixes.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/6.x/2016_09_08_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_09_08_00_hotfixes.sql new file mode 100644 index 00000000000..e9ff18e295e --- /dev/null +++ b/sql/updates/hotfixes/6.x/2016_09_08_00_hotfixes.sql @@ -0,0 +1,12 @@ +ALTER TABLE `hotfixes`.`creature_difficulty` + CHANGE `Flags1` `Flags1` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `CreatureID`, + CHANGE `Flags2` `Flags2` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `Flags1`, + CHANGE `Flags3` `Flags3` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `Flags2`, + CHANGE `Flags4` `Flags4` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `Flags3`, + CHANGE `Flags5` `Flags5` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `Flags4`, + ADD COLUMN `Flags6` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `Flags5`, + ADD COLUMN `Flags7` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `Flags6`, + CHANGE `FactionID` `FactionTemplateID` SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `Expansion` `Expansion` TINYINT(4) DEFAULT 0 NOT NULL, + CHANGE `MinLevel` `MinLevel` TINYINT(4) DEFAULT 0 NOT NULL, + CHANGE `MaxLevel` `MaxLevel` TINYINT(4) DEFAULT 0 NOT NULL; |