From 1369442fa5e820ec0b64f3fa7cc8c90cd8d386d4 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:05:10 +0800 Subject: [PATCH] mysql/core_company_get_owner.sql --- mysql/core_company_get_owner.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/mysql/core_company_get_owner.sql b/mysql/core_company_get_owner.sql index 29004bbd..7323fbf8 100644 --- a/mysql/core_company_get_owner.sql +++ b/mysql/core_company_get_owner.sql @@ -1,11 +1,11 @@ -DROP FUNCTION IF EXISTS company_get_owner; +DROP FUNCTION IF EXISTS core_company_get_owner; DELIMITER $$ -CREATE FUNCTION company_get_owner() RETURNS INT(11) DETERMINISTIC +CREATE FUNCTION core_company_get_owner() RETURNS INT(11) DETERMINISTIC BEGIN DECLARE v_id INT(11); SET v_id = 0; - SELECT id INTO v_id FROM Companies WHERE isOwner = 1 LIMIT 1; + SELECT id INTO v_id FROM core_company WHERE isOwner = 1 LIMIT 1; RETURN v_id; END $$ DELIMITER ; -- 2.39.2