From 4d84638bbea8bbf2ac381e9febc370d0e9efcd78 Mon Sep 17 00:00:00 2001 From: edward Date: Mon, 18 Jul 2016 13:30:39 +0800 Subject: [PATCH] sql/core_email.sql --- sql/core_email.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/core_email.sql b/sql/core_email.sql index df646084..c97aa8c4 100644 --- a/sql/core_email.sql +++ b/sql/core_email.sql @@ -12,10 +12,10 @@ CREATE TABLE core_email ( PRIMARY KEY (id) ); -ALTER TABLE core_email ADD COLUMN active INT(2) default 1; +ALTER TABLE core_email ADD 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 ADD COLUMN bcc_group 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) default 0; -- 2.39.2