SQL Connector Database Changes between 7.0.6 and 8

What changes have been made to the SQL Tables and SQL Stored Procedures between MailSite SP v7.0.6 and v8.0.1

Important Information
=====================

Below are the changes which have been made to the Stored procedures for MailSite.  The changes marked in Blue are additions, Red are removals and Grey is for items that have not changed but makes the changes more readable. Before installing the updates please review the changes.  These changes will not cause any service issues if the procedure is not updated.

Tables.sql Changes

Tables Affected	New Columns added to the Table
DomainProperties	GreylistRemit CalendarRemit EnabledCalendarPlugins
MailboxProperties	PersonalizationExpress GreylistType EnabledCalendarPlugins CalendarFeatures CalendarType

Procedures.sql Changes

Procedure Affected	New properties added to the procedures
OpenMailbox	MailboxProperties.PersonalizationExpress MailboxProperties.GreylistType MailboxProperties.EnabledCalendarPlugins MailboxProperties.CalendarType MailboxProperties.CalendarFeatures
OpenDomain	DomainProperties.GreylistRemit DomainProperties.EnabledCalendarPlugins DomainProperties.CalendarRemit
OpenDomain2	DomainProperties.GreylistRemit DomainProperties.EnabledCalendarPlugins DomainProperties.CalendarRemit
CountMailboxes	-- Get the id of the default domain and exclude the mailboxtemplate DECLARE @DefaultDomainId int SELECT @DefaultDomainId = DomainId FROM DomainNames WHERE DomainName =             (SELECT convert(varchar(255), PropStringValue)              FROM MailServerProperties              WHERE ServerRoleId = 0 AND ServiceName = 'server' AND PropertyName = 'defaultdomainname')   IF @Domain = ''       SELECT COUNT(*)              FROM dbo.MailNames WITH (NOLOCK)              WHERE              WHERE ( (MailNames.PrincipalName = 1) AND (MailNames.MailboxId IS NOT NULL)              AND (MailNames.MailboxId IS NOT NULL)              AND (MailNames.DomainId != @DefaultDomainId OR MailName != 'mailboxtemplate')