From: Alan Knowles Date: Sat, 28 Jan 2012 08:12:06 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=0a69d16b1ad71f11b9082514906db8e51dff4600 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 25d31bbc..71157efb 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -305,12 +305,14 @@ CREATE TRIGGER core_enum_insert AFTER INSERT ON core_enum FOR EACH ROW BEGIN CALL core_enum_seqmax(NEW.etype); END; +$$ CREATE TRIGGER core_enum_update AFTER UDPATE ON core_enum FOR EACH ROW BEGIN CALL core_enum_seqmax(NEW.etype); END; $$ + DELIMITER ;