From 4f48f12f23fbc22d21176d98a19d819921843822 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 30 Apr 2014 17:50:03 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 35 ----------------------------------- 1 file changed, 35 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index c7521585..574d69e7 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -204,41 +204,6 @@ ALTER TABLE translations ADD INDEX qlookup (module, tfile, tlang, tkey); - -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... - CREATE TABLE core_person_alias ( id int(11) NOT NULL AUTO_INCREMENT, -- 2.39.2