From 8157bbb1b5f001f62f65d495f0bb61f497b3c3a9 Mon Sep 17 00:00:00 2001 From: Edward Date: Wed, 19 Feb 2014 12:08:53 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 19 ------------------- 1 file changed, 19 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 5e97561e..ea28e507 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -474,22 +474,3 @@ CREATE TABLE core_mailing_list_message ( 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