adding m_ for koha functions and an update_leader function

[migration-tools.git] / sql / koha / general_functions.sql

diff --git a/sql/koha/general_functions.sql b/sql/koha/general_functions.sql
index 6998171..8dd0817 100644 (file)
--- a/sql/koha/general_functions.sql
+++ b/sql/koha/general_functions.sql
@@ -1,7 +1,7 @@
-DROP FUNCTION IF EXISTS split_string;
+DROP FUNCTION IF EXISTS m_split_string;
 DELIMITER $
 CREATE FUNCTION 
-   split_string (s TEXT, del VARCHAR(10), i INT)
+   m_split_string (s TEXT, del VARCHAR(10), i INT)
    RETURNS TEXT
    DETERMINISTIC
     BEGIN
@@ -16,10 +16,10 @@ CREATE FUNCTION
 $
 DELIMITER ;
 
-DROP FUNCTION IF EXISTS string_segment_count;
+DROP FUNCTION IF EXISTS m_string_segment_count;
 DELIMITER $
 CREATE FUNCTION 
-   string_segment_count(s TEXT, del VARCHAR(10))
+   m_string_segment_count(s TEXT, del VARCHAR(10))
    RETURNS TEXT
    DETERMINISTIC
     BEGIN
@@ -29,3 +29,17 @@ CREATE FUNCTION
     END
 $
 DELIMITER ;
+
+DROP FUNCTION IF EXISTS m_remove_bracketed_text;
+DELIMITER $
+CREATE FUNCTION 
+   m_remove_bracketed_text(str TEXT)
+   RETURNS TEXT
+   DETERMINISTIC
+    BEGIN
+    RETURN REPLACE(str, SUBSTRING(str, LOCATE('(', str), LENGTH(str) - LOCATE(')', REVERSE(str)) - LOCATE('(', str) + 2), '');
+    END
+$
+DELIMITER ;
+
+