Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -N -r11319 -r11320 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 11319) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 11320) @@ -971,3 +971,24 @@ PRIMARY KEY (StopWordId), KEY StopWord (StopWord) ); + +CREATE TABLE MailingLists ( + MailingId int(10) unsigned NOT NULL auto_increment, + PortalUserId int(11) NOT NULL, + `To` longtext, + ToParsed longtext, + Attachments text, + `Subject` varchar(255) NOT NULL, + MessageText longtext, + MessageHtml longtext, + `Status` tinyint(3) unsigned NOT NULL default '1', + EmailsQueued int(10) unsigned NOT NULL, + EmailsSent int(10) unsigned NOT NULL, + EmailsTotal int(10) unsigned NOT NULL, + PRIMARY KEY (MailingId), + KEY EmailsTotal (EmailsTotal), + KEY EmailsSent (EmailsSent), + KEY EmailsQueued (EmailsQueued), + KEY `Status` (`Status`), + KEY PortalUserId (PortalUserId) +); \ No newline at end of file