1 CREATE TABLE core_email (
2 id INT(11) NOT NULL AUTO_INCREMENT ,
6 name VARCHAR(255) NOT NULL DEFAULT '',
7 updated_dt DATETIME NOT NULL ,
8 from_email VARCHAR(254) NULL DEFAULT '',
9 from_name VARCHAR(254) NULL DEFAULT '',
10 owner_id INT(11) NOT NULL DEFAULT 0,
11 is_system INT(2) NOT NULL DEFAULT 1,
15 ALTER TABLE core_email ADD COLUMN active INT(2) default 1;
17 -- need to store BCC data here.
18 ALTER TABLE core_email ADD COLUMN bcc_group INT(11) default 0;
20 -- each email template should have a test class with a static method ::test_{name}
21 ALTER TABLE core_email ADD COLUMN test_class VARCHAR(254) default 0;
27 UPDATE core_email SET updated_dt = NOW() where updated_dt IS NULL;