From cdff75003cb21e487805780704791b69e20ebd3c Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 14 Mar 2018 17:49:05 +0800 Subject: [PATCH] sql/core_email.sql --- sql/core_email.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sql/core_email.sql b/sql/core_email.sql index d3a74dd7..5001c70f 100644 --- a/sql/core_email.sql +++ b/sql/core_email.sql @@ -16,15 +16,15 @@ ALTER TABLE core_email ADD COLUMN active INT(2) NOT NULL DEFAULT 1; ALTER TABLE core_email MODIFY COLUMN active INT(2) NOT NULL DEFAULT 1; -- need to store BCC data here. -ALTER TABLE core_email ADD COLUMN bcc_group INT(11) NOT NULL DEFAULT 0; -ALTER TABLE core_email MODIFY COLUMN bcc_group INT(11) NOT NULL DEFAULT 0; +ALTER TABLE core_email ADD COLUMN bcc_group_id INT(11) NOT NULL DEFAULT 0; +ALTER TABLE core_email MODIFY COLUMN bcc_group_id INT(11) NOT NULL DEFAULT 0; -- each email template should have a test class with a static method ::test_{name} ALTER TABLE core_email ADD COLUMN test_class VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_email MODIFY COLUMN test_class VARCHAR(254) NOT NULL DEFAULT ''; -ALTER TABLE core_email CHANGE COLUMN in_group to_group INT(11) NOT NULL DEFAULT -1; -ALTER TABLE core_email ADD COLUMN to_group INT(11) NOT NULL DEFAULT -1; +ALTER TABLE core_email CHANGE COLUMN in_group to_group_id INT(11) NOT NULL DEFAULT -1; +ALTER TABLE core_email ADD COLUMN to_group_id INT(11) NOT NULL DEFAULT -1; UPDATE core_email SET updated_dt = NOW() where updated_dt IS NULL; -- 2.39.2