From e0be5a7e3d3518be52c87a153f7962c88807ecea Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Tue, 7 Jul 2015 13:58:25 +0800
Subject: [PATCH] sync

---
 mysql/core_enum_functions.sql | 59 -----------------------------------
 1 file changed, 59 deletions(-)
 delete mode 100644 mysql/core_enum_functions.sql

diff --git a/mysql/core_enum_functions.sql b/mysql/core_enum_functions.sql
deleted file mode 100644
index 720a66c1..00000000
--- a/mysql/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
-- 
2.39.2