DB/Creatures: Drop unused movement data

(cherry picked from commit 78635f640ee3b632a487a50dcf492ae62c2a0933)

1 files changed, 4 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_03_28_02_world_2024_03_28_00_world.sql b/sql/updates/world/cata_classic/2024_03_28_02_world_2024_03_28_00_world.sql
new file mode 100644
index 00000000000..d602488bff3
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_03_28_02_world_2024_03_28_00_world.sql
@@ -0,0 +1,4 @@
+UPDATE `creature_template_movement` SET `InteractionPauseTimer`=NULL WHERE `InteractionPauseTimer`=0;
+UPDATE `creature_template_movement` SET `Chase`=0 WHERE `Chase` IS NULL;
+UPDATE `creature_template_movement` SET `Random`=0 WHERE `Random` IS NULL;
+DELETE FROM `creature_template_movement` WHERE `HoverInitiallyEnabled` IS NULL AND `Chase`=0 AND `Random`=0 AND `InteractionPauseTimer` IS NULL;