diff options
| author | Killyana <morphone1@gmail.com> | 2019-03-17 16:57:05 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-03-17 16:57:05 +0100 |
| commit | c76931c2c095f09b587038ac1ebd1a4fea96dbcf (patch) | |
| tree | 73fef00f06132254b44485d06f7a4618a1274333 | |
| parent | ebe56ce802a8c2dc33f9c9d8f69ddd813a6169a0 (diff) | |
DB: Linux complains
| -rw-r--r-- | sql/updates/world/3.3.5/2019_03_17_01_world.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/updates/world/3.3.5/2019_03_17_01_world.sql b/sql/updates/world/3.3.5/2019_03_17_01_world.sql index 32cf7adee88..3b993c9886c 100644 --- a/sql/updates/world/3.3.5/2019_03_17_01_world.sql +++ b/sql/updates/world/3.3.5/2019_03_17_01_world.sql @@ -13,6 +13,6 @@ INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`, DELETE `ctm` FROM `creature_template_movement` `ctm` INNER JOIN `creature_template` `ct` ON `ctm`.`CreatureId` = `ct`.`difficulty_entry_1`; DELETE `ctm` FROM `creature_template_movement` `ctm` INNER JOIN `creature_template` `ct` ON `ctm`.`CreatureId` = `ct`.`difficulty_entry_2`; DELETE `ctm` FROM `creature_template_movement` `ctm` INNER JOIN `creature_template` `ct` ON `ctm`.`CreatureId` = `ct`.`difficulty_entry_3`; -INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_1` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_1` > 0) `CT` ON `CTM`.`CreatureId` = `CT`.`entry`; -INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_2` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_2` > 0) `CT` ON `CTM`.`CreatureId` = `CT`.`entry`; -INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_3` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_3` > 0) `CT` ON `CTM`.`CreatureId` = `CT`.`entry`; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_1` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_1` > 0) `ct` ON `ctm`.`CreatureId` = `ct`.`entry`; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_2` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_2` > 0) `ct` ON `ctm`.`CreatureId` = `ct`.`entry`; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_3` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_3` > 0) `ct` ON `ctm`.`CreatureId` = `ct`.`entry`; |