DataObjects/zcore_functions.sql

diff --git a/DataObjects/core_enum_functions.sql b/DataObjects/core_enum_functions.sql
deleted file mode 100644 (file)
index 720a66c..0000000
--- a/DataObjects/core_enum_functions.sql
+++ /dev/null
@@ -1,59 +0,0 @@
-
-
--- also update the pgsql version of these!?
-
-DROP FUNCTION IF EXISTS core_enum_display_name;
-DELIMITER $$
-CREATE FUNCTION core_enum_display_name(in_id INT(11))
-        RETURNS VARCHAR(256) DETERMINISTIC
-    BEGIN
-        DECLARE ret  VARCHAR(256);
-        SET ret  = '';
-        SELECT display_name INTO ret FROM core_enum
-            WHERE id=in_id LIMIT 1;
-        RETURN ret;
-    END $$
-DELIMITER ;
-
-
-
-
-
-DROP FUNCTION IF EXISTS core_enum_name;
-DELIMITER $$
-CREATE FUNCTION core_enum_name(in_id INT(11))
-        RETURNS VARCHAR(256) DETERMINISTIC
-    BEGIN
-        DECLARE ret  VARCHAR(256);
-        SET ret  = '';
-        SELECT name INTO ret FROM core_enum
-            WHERE id=in_id LIMIT 1;
-        RETURN ret;
-    END $$
-DELIMITER ;
-
-DROP FUNCTION IF EXISTS core_enum_name_to_display_name;
-DELIMITER $$
-CREATE FUNCTION core_enum_name_to_display_name(in_etype VARCHAR(256), in_name VARCHAR(256))
-        RETURNS VARCHAR(256) DETERMINISTIC
-    BEGIN
-        DECLARE ret VARCHAR(256);
-        SET ret  = '';
-        SELECT display_name INTO ret FROM core_enum
-            WHERE name=in_name AND etype=in_etype LIMIT 1;
-        RETURN ret;
-    END $$
-DELIMITER ;
-
-DROP FUNCTION IF EXISTS core_enum_id_by_name;
-DELIMITER $$
-CREATE FUNCTION core_enum_id_by_name(in_etype VARCHAR(256), in_name VARCHAR(256))
-        RETURNS INT(11) DETERMINISTIC
-    BEGIN
-        DECLARE ret  INT(11);
-        SET ret  = '';
-        SELECT id INTO ret FROM core_enum
-            WHERE name=in_name AND etype=in_etype LIMIT 1;
-        RETURN ret;
-    END $$
-DELIMITER ;
\ No newline at end of file