From 850819a226ef6c070bd0a5fa6f3f5ecc10de472c Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Sat, 28 Jan 2012 16:13:20 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index ce324cc7..7f7924a0 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -301,12 +301,16 @@ alter table core_enum ADD INDEX lookup(seqid, active, name, etype); DELIMITER $$ +DROP TRIGGER core_enum_insert IF EXISTS $$ + CREATE TRIGGER core_enum_insert AFTER INSERT ON core_enum FOR EACH ROW BEGIN CALL core_enum_seqmax(NEW.etype); END; $$ +DROP TRIGGER core_enum_update IF EXISTS $$ + CREATE TRIGGER core_enum_update AFTER UPDATE ON core_enum FOR EACH ROW BEGIN CALL core_enum_seqmax(NEW.etype); -- 2.39.2