From: Alan Knowles Date: Sat, 28 Jan 2012 08:18:57 +0000 (+0800) Subject: DataObjects/core_functions.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=af53cc33d93d6f186e5d4aba8aa45633bf563abb DataObjects/core_functions.sql --- diff --git a/DataObjects/core_functions.sql b/DataObjects/core_functions.sql index 4f6a5ee3..6934437f 100644 --- a/DataObjects/core_functions.sql +++ b/DataObjects/core_functions.sql @@ -18,7 +18,7 @@ DELIMITER ; DROP FUNCTION IF EXISTS core_enum_seqmax; DELIMITER $$ -CREATE PROCEDURE core_enum_seqmax_update( etype varchar(128)) +CREATE FUNCTION core_enum_seqmax( etype varchar(128)) BEGIN DECLARE seqmax INT(11); SELECT MAX(seqid) +1 INTO seqmax FROM core_enum WHERE