DB/Misc: Add new view vw_disables_with_labels that shows labels instead of numbers from disables table

(cherry picked from commit 6d295629cf01cc23e9c6c521c767a4fa6fd0eb41)

1 files changed, 26 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_02_03_09_world_2020_08_23_00_world.sql b/sql/updates/world/master/2022_02_03_09_world_2020_08_23_00_world.sql
new file mode 100644
index 00000000000..1c77738405b
--- /dev/null
+++ b/sql/updates/world/master/2022_02_03_09_world_2020_08_23_00_world.sql
@@ -0,0 +1,26 @@
+--
+-- Drop previous functions/views if any
+DROP VIEW IF EXISTS `vw_disables_with_labels`;
+
+-- Create the view
+CREATE SQL SECURITY INVOKER VIEW `vw_disables_with_labels` AS
+(SELECT (
+        CASE
+            WHEN `sourceType` = 0 THEN 'DISABLE_TYPE_SPELL'
+        WHEN `sourceType` = 1 THEN 'DISABLE_TYPE_QUEST'
+        WHEN `sourceType` = 2 THEN 'DISABLE_TYPE_MAP'
+        WHEN `sourceType` = 3 THEN 'DISABLE_TYPE_BATTLEGROUND'
+        WHEN `sourceType` = 4 THEN 'DISABLE_TYPE_ACHIEVEMENT_CRITERIA'
+        WHEN `sourceType` = 5 THEN 'DISABLE_TYPE_OUTDOORPVP'
+        WHEN `sourceType` = 6 THEN 'DISABLE_TYPE_VMAP'
+        WHEN `sourceType` = 7 THEN 'DISABLE_TYPE_MMAP'
+        WHEN `sourceType` = 8 THEN 'DISABLE_TYPE_LFG_MAP'
+            ELSE `sourceType`
+        END
+    ) AS `sourceType`,
+    `entry`,
+    `flags`,
+    `params_0`,
+    `params_1`,
+    `comment`
+ FROM disables);