X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fkoha%2Fgeneral_functions.sql;fp=sql%2Fkoha%2Fgeneral_functions.sql;h=0000000000000000000000000000000000000000;hp=8dd08174e55c6b577b04b01bca403caa1513a015;hb=1a0cb0a0ee2d0dcde1b138171042f4e20bc4019e;hpb=86da5ac84fdad19571c27beb89bc375b6dc04c92

diff --git a/sql/koha/general_functions.sql b/sql/koha/general_functions.sql
deleted file mode 100644
index 8dd0817..0000000
--- a/sql/koha/general_functions.sql
+++ /dev/null
@@ -1,45 +0,0 @@
-DROP FUNCTION IF EXISTS m_split_string;
-DELIMITER $
-CREATE FUNCTION 
-   m_split_string (s TEXT, del VARCHAR(10), i INT)
-   RETURNS TEXT
-   DETERMINISTIC
-    BEGIN
-        DECLARE n INT ;
-        SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
-        IF i > n THEN
-            RETURN NULL ;
-        ELSE
-            RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(s, del, i) , del , -1 ) ;        
-        END IF;
-    END
-$
-DELIMITER ;
-
-DROP FUNCTION IF EXISTS m_string_segment_count;
-DELIMITER $
-CREATE FUNCTION 
-   m_string_segment_count(s TEXT, del VARCHAR(10))
-   RETURNS TEXT
-   DETERMINISTIC
-    BEGIN
-        DECLARE n INT ;
-        SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
-        RETURN n;
-    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 ;
-
-