diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_07_24_01_world.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/sql/updates/world/3.3.5/2020_07_24_01_world.sql b/sql/updates/world/3.3.5/2020_07_24_01_world.sql index 7f783406990..6529ae7572e 100644 --- a/sql/updates/world/3.3.5/2020_07_24_01_world.sql +++ b/sql/updates/world/3.3.5/2020_07_24_01_world.sql @@ -9,6 +9,7 @@ DROP VIEW IF EXISTS `vw_smart_scripts_with_labels`; DELIMITER $$ CREATE FUNCTION `fn_smart_scripts_event_type`(event_type TINYINT(3)) RETURNS CHAR(50) DETERMINISTIC + SQL SECURITY INVOKER BEGIN RETURN CASE event_type WHEN 0 THEN 'SMART_EVENT_UPDATE_IC' @@ -100,6 +101,7 @@ CREATE FUNCTION `fn_smart_scripts_event_type`(event_type TINYINT(3)) CREATE FUNCTION `fn_smart_scripts_action_type`(action_type TINYINT(3)) RETURNS CHAR(50) DETERMINISTIC + SQL SECURITY INVOKER BEGIN RETURN CASE action_type WHEN 0 THEN 'SMART_ACTION_NONE' @@ -248,6 +250,7 @@ CREATE FUNCTION `fn_smart_scripts_action_type`(action_type TINYINT(3)) CREATE FUNCTION `fn_smart_scripts_target_type`(target_type TINYINT(3)) RETURNS CHAR(50) DETERMINISTIC + SQL SECURITY INVOKER BEGIN RETURN CASE target_type WHEN 0 THEN 'SMART_TARGET_NONE' @@ -288,7 +291,7 @@ CREATE FUNCTION `fn_smart_scripts_target_type`(target_type TINYINT(3)) DELIMITER ; -- Create the view -CREATE VIEW `vw_smart_scripts_with_labels` AS +CREATE SQL SECURITY INVOKER VIEW `vw_smart_scripts_with_labels` AS (SELECT `entryorguid`, `source_type`, `id`, |