From 27405870e0d331fcd73845d200a061600dcfdd00 Mon Sep 17 00:00:00 2001 From: jackpoz Date: Sun, 23 Aug 2020 14:56:20 +0200 Subject: DB/Misc: Add new view vw_disables_with_labels that shows labels instead of numbers from disables table (cherry picked from commit 6d295629cf01cc23e9c6c521c767a4fa6fd0eb41) --- .../2022_02_03_09_world_2020_08_23_00_world.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/master/2022_02_03_09_world_2020_08_23_00_world.sql (limited to 'sql') 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); -- cgit v1.2.3