From 15b6c96c6dda28c90a0de1acd5526f7548943381 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Sat, 28 Jan 2012 16:11:55 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index ad86026b..25d31bbc 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -299,23 +299,22 @@ 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 | +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 ( id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) -- 2.39.2