From daf345daea6e11a30c4e378243dfd0e6f7c8a31e Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 30 Apr 2014 17:50:08 +0800 Subject: [PATCH] sql/core_notify.sql --- sql/core_notify.sql | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) diff --git a/sql/core_notify.sql b/sql/core_notify.sql index e69de29b..684de9e8 100644 --- a/sql/core_notify.sql +++ b/sql/core_notify.sql @@ -0,0 +1,35 @@ + + +CREATE TABLE core_notify ( + id int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (id) +); +ALTER TABLE core_notify ADD COLUMN evtype VARCHAR(128) NOT NULL default ''; +ALTER TABLE core_notify ADD COLUMN recur_id INT(11) NOT NULL default 0; +ALTER TABLE core_notify ADD COLUMN act_when DATETIME ; +ALTER TABLE core_notify ADD COLUMN act_start DATETIME ; +ALTER TABLE core_notify ADD COLUMN onid int(11) NOT NULL DEFAULT 0; +ALTER TABLE core_notify ADD COLUMN ontable varchar(128) NOT NULL DEFAULT ''; +ALTER TABLE core_notify ADD COLUMN person_id int(11) NOT NULL DEFAULT 0; +ALTER TABLE core_notify ADD COLUMN msgid varchar(128) NOT NULL DEFAULT ''; + +ALTER TABLE core_notify ADD COLUMN sent DATETIME ; +ALTER TABLE core_notify ADD COLUMN event_id int(11) NOT NULL DEFAULT 0; +ALTER TABLE core_notify ADD COLUMN watch_id INT(11) NOT NULL DEFAULT 0; +ALTER TABLE core_notify ADD COLUMN trigger_person_id INT(11) NOT NULL DEFAULT 0; +ALTER TABLE core_notify ADD COLUMN trigger_event_id INT(11) NOT NULL DEFAULT 0; + +ALTER TABLE core_notify ADD COLUMN to_email varchar(255) NOT NULL DEFAULT ''; + + +-- old mysql.. +ALTER TABLE core_notify CHANGE COLUMN bounced event_id INT(11) NOT NULL DEFAULT 0; + +ALTER TABLE core_notify ADD INDEX lookup(act_when, msgid); +ALTER TABLE core_notify ADD INDEX lookup_a(onid, ontable, person_id, act_when, msgid, to_email); +alter table core_notify add INDEX lookup_b (sent, person_id, msgid, ontable); +ALTER TABLE core_notify add index lookup_d (person_id, msgid, ontable); + + + +-- used by email / tracker to handle alises - we have to be carefull adding to this table... -- 2.39.2