projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
6689354
)
DataObjects/core.sql
author
Alan Knowles
<alan@roojs.com>
Wed, 14 Nov 2012 06:07:20 +0000
(14:07 +0800)
committer
Alan Knowles
<alan@roojs.com>
Wed, 14 Nov 2012 06:07:20 +0000
(14:07 +0800)
DataObjects/core.sql
patch
|
blob
|
history
diff --git
a/DataObjects/core.sql
b/DataObjects/core.sql
index
aa0b3ee
..
5a266f5
100644
(file)
--- 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 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);
ALTER TABLE core_notify_recur ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt);