Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r15225 -r15230 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15225) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15230) @@ -389,14 +389,18 @@ CREATE TABLE EmailLog ( EmailLogId int(11) NOT NULL AUTO_INCREMENT, - fromuser varchar(200) DEFAULT NULL, - addressto varchar(255) DEFAULT NULL, - `subject` varchar(255) DEFAULT NULL, - `timestamp` bigint(20) DEFAULT '0', - `event` varchar(100) DEFAULT NULL, + `From` varchar(255) NOT NULL DEFAULT '', + `To` varchar(255) NOT NULL DEFAULT '', + OtherRecipients text, + `Subject` varchar(255) NOT NULL DEFAULT '', + HtmlBody longtext, + TextBody longtext, + SentOn int(11) DEFAULT NULL, + EventName varchar(255) NOT NULL DEFAULT '', EventParams text, + AccessKey varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (EmailLogId), - KEY `timestamp` (`timestamp`) + KEY `timestamp` (SentOn) ); CREATE TABLE SystemCache (