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 Index: branches/RC/core/install/remove_schema.sql =================================================================== diff -u -N -r11290 -r11320 --- branches/RC/core/install/remove_schema.sql (.../remove_schema.sql) (revision 11290) +++ branches/RC/core/install/remove_schema.sql (.../remove_schema.sql) (revision 11320) @@ -63,4 +63,5 @@ DROP TABLE Visits; DROP TABLE ImportCache; DROP TABLE RelatedSearches; -DROP TABLE StopWords; \ No newline at end of file +DROP TABLE StopWords; +DROP TABLE MailingLists; \ No newline at end of file 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);