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,
16 ALTER TABLE core_email ENGINE=InnoDB;
19 UPDATE core_email SET updated_dt = NOW();