projects
/
Pman.Core
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
29004bbd759ac7119dbc1ffc7ba386c7fecfc34a
[Pman.Core]
/
mysql
/
company_get_owner.sql
1
DROP FUNCTION IF EXISTS company_get_owner;
2
3
DELIMITER $$
4
CREATE FUNCTION company_get_owner() RETURNS INT(11) DETERMINISTIC
5
BEGIN
6
DECLARE v_id INT(11);
7
SET v_id = 0;
8
SELECT id INTO v_id FROM Companies WHERE isOwner = 1 LIMIT 1;
9
RETURN v_id;
10
END $$
11
DELIMITER ;
12