3 -- also update the pgsql version of these!?
5 DROP FUNCTION IF EXISTS core_enum_display_name;
7 CREATE FUNCTION core_enum_display_name(in_id INT(11))
8 RETURNS VARCHAR(256) DETERMINISTIC
10 DECLARE ret VARCHAR(256);
12 SELECT display_name INTO ret FROM core_enum
13 WHERE id=in_id LIMIT 1;
22 DROP FUNCTION IF EXISTS core_enum_name;
24 CREATE FUNCTION core_enum_name(in_id INT(11))
25 RETURNS VARCHAR(256) DETERMINISTIC
27 DECLARE ret VARCHAR(256);
29 SELECT name INTO ret FROM core_enum
30 WHERE id=in_id LIMIT 1;
35 DROP FUNCTION IF EXISTS core_enum_name_to_display_name;
37 CREATE FUNCTION core_enum_name_to_display_name(in_etype VARCHAR(256), in_name VARCHAR(256))
38 RETURNS VARCHAR(256) DETERMINISTIC
40 DECLARE ret VARCHAR(256);
42 SELECT display_name INTO ret FROM core_enum
43 WHERE name=in_name AND etype=in_etype LIMIT 1;
48 DROP FUNCTION IF EXISTS core_enum_id_by_name;
50 CREATE FUNCTION core_enum_id_by_name(in_etype VARCHAR(256), in_name VARCHAR(256))
51 RETURNS INT(11) DETERMINISTIC
55 SELECT id INTO ret FROM core_enum
56 WHERE name=in_name AND etype=in_etype LIMIT 1;