From: Alan Knowles Date: Sat, 28 Jan 2012 08:15:30 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=78fc0f669b95612a4368b75f90f51509dc3c0900 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 7f7924a0..e93cf1cf 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -301,7 +301,7 @@ alter table core_enum ADD INDEX lookup(seqid, active, name, etype); DELIMITER $$ -DROP TRIGGER core_enum_insert IF EXISTS $$ +DROP TRIGGER IF EXISTS core_enum_insert $$ CREATE TRIGGER core_enum_insert AFTER INSERT ON core_enum FOR EACH ROW BEGIN @@ -309,7 +309,7 @@ FOR EACH ROW BEGIN END; $$ -DROP TRIGGER core_enum_update IF EXISTS $$ +DROP TRIGGER IF EXISTS core_enum_update $$ CREATE TRIGGER core_enum_update AFTER UPDATE ON core_enum FOR EACH ROW BEGIN