From 4e474016034dcf82f68b0a6cd507220bc1b37da8 Mon Sep 17 00:00:00 2001 From: Edward Date: Wed, 19 Feb 2014 12:08:18 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 09bddea2..5e97561e 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -457,5 +457,39 @@ ALTER TABLE core_notify_recur ADD INDEX lookup(person_id, dtstart, dtend, tz, -- old design.. ALTER TABLE core_notify_recur CHANGE COLUMN tz tz varchar(64) NOT NULL; + + + +CREATE TABLE core_mailing_list_message ( + id INT(11) NOT NULL AUTO_INCREMENT , + subject TEXT NULL , + bodytext TEXT NULL , + plaintext TEXT NULL , + name VARCHAR(255) NOT NULL DEFAULT '', + updated_dt DATETIME NOT NULL , + from_email VARCHAR(254) NULL DEFAULT '' + from_name VARCHAR(254) NULL DEFAULT '', + owner_id INT(11) NOT NULL DEFAULT 0, + is_system INT(2) NOT NULL DEFAULT 1, + PRIMARY KEY (id) +); + +ALTER TABLE crm_mailing_list_message ADD COLUMN plaintext TEXT NULL; +ALTER TABLE crm_mailing_list_message ADD COLUMN name VARCHAR(255) NOT NULL DEFAULT ''; +ALTER TABLE crm_mailing_list_message ADD COLUMN updated_dt DATETIME NOT NULL; +-- ALTER TABLE crm_mailing_list_message ADD COLUMN exclude_list VARCHAR(254) NULL DEFAULT ''; + +ALTER TABLE crm_mailing_list_message ADD COLUMN from_email VARCHAR(254) NULL DEFAULT ''; + +ALTER TABLE crm_mailing_list_message ADD COLUMN from_name VARCHAR(254) NULL DEFAULT ''; + +ALTER TABLE crm_mailing_list_message ADD COLUMN owner_id INT(11) NOT NULL DEFAULT 0 ; + + +-- drop the useless column +ALTER TABLE crm_mailing_list_message DROP COLUMN issue_dt; +ALTER TABLE crm_mailing_list_message DROP COLUMN notify_generated; +ALTER TABLE crm_mailing_list_message DROP COLUMN status_id; +ALTER TABLE crm_mailing_list_message DROP COLUMN exclude_list; -- 2.39.2