2 DROP FUNCTION IF EXISTS core_enum_display_name;
4 CREATE FUNCTION core_enum_display_name(in_id INT(11))
5 RETURNS VARCHAR(256) DETERMINISTIC
7 DECLARE ret VARCHAR(256);
9 SELECT display_name INTO ret FROM core_enum
10 WHERE id=in_id LIMIT 1;
15 DROP FUNCTION IF EXISTS core_enum_name;
17 CREATE FUNCTION core_enum_name(in_id INT(11))
18 RETURNS VARCHAR(256) DETERMINISTIC
20 DECLARE ret VARCHAR(256);
22 SELECT name INTO ret FROM core_enum
23 WHERE id=in_id LIMIT 1;
28 DROP FUNCTION IF EXISTS core_enum_id_by_name;
30 CREATE FUNCTION core_enum_id_by_name(in_name VARCHAR(256))
31 RETURNS INT(11) DETERMINISTIC
35 SELECT id INTO ret FROM core_enum
36 WHERE name=in_name LIMIT 1;