Index: branches/unlabeled/unlabeled-1.11.2/core/install/install_schema.sql =================================================================== diff -u -r8217 -r8227 --- branches/unlabeled/unlabeled-1.11.2/core/install/install_schema.sql (.../install_schema.sql) (revision 8217) +++ branches/unlabeled/unlabeled-1.11.2/core/install/install_schema.sql (.../install_schema.sql) (revision 8227) @@ -70,12 +70,17 @@ ); CREATE TABLE EmailQueue ( - Subject text, - toaddr text, - fromaddr text, - message blob, - headers blob, - queued timestamp NOT NULL + EmailQueueId int(10) unsigned NOT NULL auto_increment, + ToEmail varchar(255) NOT NULL default '', + `Subject` varchar(255) NOT NULL default '', + MessageHeaders text, + MessageBody longtext, + Queued int(10) unsigned NOT NULL default '0', + SendRetries int(10) unsigned NOT NULL default '0', + LastSendRetry int(10) unsigned NOT NULL default '0', + PRIMARY KEY (EmailQueueId), + KEY LastSendRetry (LastSendRetry), + KEY SendRetries (SendRetries) ); CREATE TABLE EmailSubscribers (