diff options
| author | jackpoz <giacomopoz@gmail.com> | 2020-07-24 19:57:06 +0200 |
|---|---|---|
| committer | jackpoz <giacomopoz@gmail.com> | 2020-07-24 19:57:06 +0200 |
| commit | 5b46ed3ff7d8c88e24dbdeebd1b910bec1225fef (patch) | |
| tree | ab417ed03ae935226d4be2a8db0aa012c0587e7f | |
| parent | c164c257ae0586bdebb9b81ecb965d9d07eabfef (diff) | |
DB/Misc: Update view and functions to work when importing TDB
| -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`, |