From: Alan Knowles <alan@roojs.com>
Date: Wed, 14 Nov 2012 06:07:20 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=e21eaebd3c3e93fa2470f120cc1e2432dce4864c

DataObjects/core.sql
---

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index aa0b3eeb..5a266f5c 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -432,6 +432,7 @@ ALTER TABLE  core_notify_recur  ADD COLUMN ontable varchar(128)  NOT NULL defaul
 ALTER TABLE  core_notify_recur  ADD COLUMN last_event_id  int(11)  default 0;
 ALTER TABLE  core_notify_recur  ADD COLUMN method varchar(128) default '';     
 
+ALTER TABLE  core_notify_recur  ADD COLUMN method_id  int(11)  default 0;
 
 ALTER TABLE  core_notify_recur  ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt);