Index: branches/RC/core/install/upgrades.sql =================================================================== diff -u -N -r11319 -r11320 --- branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 11319) +++ branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 11320) @@ -964,6 +964,27 @@ INSERT INTO ConfigurationAdmin VALUES ('CheckStopWords', 'la_Text_Website', 'la_config_CheckStopWords', 'checkbox', '', '', 10.29, 0, 0); INSERT INTO ConfigurationValues VALUES (DEFAULT, 'CheckStopWords', '0', 'In-Portal', 'in-portal:configure_general'); +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) +); + ALTER TABLE EmailQueue ADD MailingId INT UNSIGNED NOT NULL, ADD INDEX (MailingId);