From: Alan Knowles <alan@roojs.com>
Date: Sat, 28 Jan 2012 08:13:20 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=850819a226ef6c070bd0a5fa6f3f5ecc10de472c

DataObjects/core.sql
---

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);