From fced44c5b07333ec124010c4ebf33d67c4d553c7 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Sat, 28 Jan 2012 16:09:48 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 16 +++++++++++++++- 1 file changed, 15 insertions(+), 1 deletion(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index c602c38f..ad86026b 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -299,7 +299,21 @@ alter table core_enum ADD COLUMN seqmax int(11) NOT NULL DEFAULT 0; alter table core_enum ADD INDEX lookup(seqid, active, name, etype); - +DELIMITER | + +CREATE TRIGGER core_enum_insert AFTER INSERT ON core_enum +FOR EACH ROW BEGIN + CALL core_enum_seqmax(NEW.etype); +END; +| +DELIMITER ; + +CREATE TRIGGER core_enum_update AFTER UDPATE ON core_enum +FOR EACH ROW BEGIN + CALL core_enum_seqmax(NEW.etype); +END; +| +DELIMITER ; CREATE TABLE translations ( -- 2.39.2