-DROP FUNCTION IF EXISTS company_get_name;
+DROP FUNCTION IF EXISTS core_company_get_name;
DELIMITER $$
-CREATE FUNCTION company_get_name(in_id INT(11)) RETURNS VARCHAR(254) DETERMINISTIC
+CREATE FUNCTION core_company_get_name(in_id INT(11)) RETURNS VARCHAR(254) DETERMINISTIC
BEGIN
DECLARE v_ret VARCHAR(254);
SET v_ret= '';
- SELECT name INTO v_ret FROM Companies WHERE id = in_id LIMIT 1;
+ SELECT name INTO v_ret FROM core_company WHERE id = in_id LIMIT 1;
RETURN v_ret;
END $$
DELIMITER ;
\ No newline at end of file