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

diff --git a/sql/koha/marc_functions.sql b/sql/koha/marc_functions.sql
deleted file mode 100644
index 08d5e8e..0000000
--- a/sql/koha/marc_functions.sql
+++ /dev/null
@@ -1,27 +0,0 @@
-
--- pass it the biblionumber, the position of the character to start in the leader starting at 0 
--- and the text to replace, single characer or multiple 
-DROP FUNCTION IF EXISTS m_update_leader;
-DELIMITER $
-CREATE FUNCTION
-   m_update_leader(bnumber INTEGER, ldr_position SMALLINT, new_value TEXT)
-   RETURNS BOOLEAN
-   DETERMINISTIC
-    BEGIN
-        DECLARE ldr TEXT COLLATE utf8mb4_unicode_ci DEFAULT NULL;
-        DECLARE new_value_length SMALLINT DEFAULT 1;
-        SET ldr_position = ldr_position + 1;
-        SET new_value_length = LENGTH(new_value);
-        
-        SELECT ExtractValue(metadata, '//leader') INTO ldr FROM biblio_metadata WHERE biblionumber = bnumber;
-        SET ldr = INSERT(ldr,ldr_position,new_value_length,new_value);
-        SET ldr = CONCAT('<leader>',ldr,'</leader>');
-
-        UPDATE biblio_metadata SET metadata = UpdateXML(metadata, '//leader', ldr) where biblionumber = bnumber;
-        RETURN TRUE;
-        
-    END
-$
-DELIMITER ;
-
-