SQL Connector Database Changes between 6.1.22 and 7.0
Document ID: 10354
Synopsis
This document will out line all the changes that we have made between the different version.
More Information
SQL Connector Database Changes between 6.1.22 and 7.0
This document will out line all the changes that we have made between the different version.
MailSite Table Changes from 6.1.22 to 7.0. The version of Tables.sql used to create this list is Version 74
| Table | Changes Made |
| MailServerRoles | CONSTRAINT UX_MailServerRolesServerRoleId UNIQUE NONCLUSTERED (ServerRoleId) |
| ServerAliases | CONSTRAINT PK_ServerAliases PRIMARY KEY NONCLUSTERED (Id) changed to CONSTRAINT PK_ServerAliases PRIMARY KEY CLUSTERED (Id) |
| DomainProperties | New Field - QuotaLimit, QuotaLimitTime, QuotaTrigger, QuotaTriggerTime, HostName, DisableDomain, QuotaRealTime |
| MailboxProperties | New Field - MailHomeId, MobileCarrierId, MobileCapability, SMSEnabled |
| MailListProperties | New Field - DigestIntro, Members_Group, Members_GroupType |
| MailServerListPropertyTypes | New Table |
| MailServerAddressProperties | New Table |
| MailServerSubnetProperties | New Table |
| DomainListPropertyTypes | New Table |
| DomainAddressProperties | New Table |
| DomainSubnetProperties | New Table |
| MailboxListPropertyTypes | New Table |
| MailboxAddressProperties | New Table |
| MailboxSubnetProperties | New Table |
MailSite Procedure Changes from 6.1.22 to 7.0. The version of Procedures.sql used to create this list is Version 131
| Procedure Name | Changes Made |
| OpenMailbox | New Fields Added - MobileCarrierId, SMSEnabled, MailHomeId |
| OpenDomain | New Fields Added - QuotaLimit, QuotaLimitTime, QuotaTrigger, QuotaTriggerTime, DisableDomain |
| GetServerAliases | Add these Entries in Bold - SELECT Id,Mask,Target FROM dbo.ServerAliases (TABLOCK, REPEATABLEREAD) ORDER BY Id |
| RenameMailbox | Add these Entries in Bold - FROM dbo.MailboxAddressProperties MAP WITH (TABLOCK) |
| AddMailboxSubnetProperty | Add these Entries in Bold - FROM dbo.MailboxSubnetProperties MSP WITH (TABLOCK) |
| GetServerAliases | Add these Entries in Bold - SELECT Id,Mask,Target FROM dbo.ServerAliases WITH (TABLOCK, REPEATABLEREAD) ORDER BY Id |
| CountSelectedMailboxes | Add these Entries - -- Build a temporary table with the ids of template mailboxes, if any, for the domains SELECT DomainId, MailboxId INTO #T1 FROM MailNames WHERE MailName = 'mailboxtemplate' AND MailboxId IS NOT NULL AND PrincipalName = 1 -- We know that each domain only has one mailboxtemplate so create a cheap unique -- index so that SQL Server knows that too. This prevents the creation of a temporary -- Worktable and cuts execution time by 29% with 30000 mailboxes. CREATE UNIQUE INDEX Index1 ON #T1 (DomainId) SELECT @selstmt='SELECT COUNT(*) FROM MailboxProperties INNER JOIN MailNames ON MailNames.MailboxId = MailboxProperties.MailboxId INNER JOIN DomainNames ON DomainNames.DomainId = MailNames.DomainId LEFT JOIN #T1 ON #T1.DomainId = MailNames.DomainId LEFT JOIN MailboxProperties TemplateMailboxProperties ON TemplateMailboxProperties.MailboxId = #T1.MailboxId ' -- Clean up the temporary table. Index is removed automatically. DROP TABLE #T1 |
| CountSelectedMailboxes | Removed these Entries in bold - SELECT @selstmt='SELECT COUNT(*) FROM MailboxProperties ,MailNames,DomainNames SELECT @whereclause = '(MailNames.PrincipalName=1) AND (DomainNames.PrincipalName=1) AND (MailNames.DomainId=DomainNames.DomainId) AND (MailboxProperties.MailboxId = MailNames.MailboxId) ' |
| dbo.fn_Max | New Function |
| GetMailboxIdProperty | New Procedure |
| IncrementMailboxProperty | New Procedure |
| SetMailboxIdSizeInfo2 | New Procedure |
| AdjustMailboxIdSizeInfo | New Procedure |
| AdjustMailboxIdSizeInfo2 | New Procedure |
| CalculateDomainSizeInfo | New Procedure |
| LookupMailboxAddressProperty | New Procedure |
| GetMailboxAddressProperty | New Procedure |
| AddMailboxAddressProperty | New Procedure |
| RemoveMailboxAddressProperty | New Procedure |
| RemoveAllMailboxAddressProperty | New Procedure |
| LookupMailboxSubnetProperty | New Procedure |
| LookupMailboxAddressInSubnetProperty | New Procedure |
| GetMailboxSubnetProperty | New Procedure |
| AddMailboxSubnetProperty | New Procedure |
| UpdateMailboxSubnetProperty | New Procedure |
| RemoveMailboxSubnetProperty | New Procedure |
| RemoveAllMailboxSubnetProperty | New Procedure |
| OpenDomain2 | New Procedure |
| IncrementDomainProperty | New Procedure |
| LookupDomainAddressProperty | New Procedure |
| GetDomainAddressProperty | New Procedure |
| AddDomainAddressProperty | New Procedure |
| RemoveDomainAddressProperty | New Procedure |
| RemoveAllDomainAddressProperty | New Procedure |
| LookupDomainSubnetProperty | New Procedure |
| LookupDomainAddressInSubnetProperty | New Procedure |
| GetDomainSubnetProperty | New Procedure |
| AddDomainSubnetProperty | New Procedure |
| UpdateDomainSubnetProperty | New Procedure |
| RemoveDomainSubnetProperty | New Procedure |
| RemoveAllDomainSubnetProperty | New Procedure |
| LookupServerAddressProperty | New Procedure |
| GetServerAddressProperty | New Procedure |
| AddServerAddressProperty | New Procedure |
| RemoveServerAddressProperty | New Procedure |
| RemoveAllServerAddressProperty | New Procedure |
| LookupServerSubnetProperty | New Procedure |
| LookupServerAddressInSubnetProperty | New Procedure |
| GetServerSubnetProperty | New Procedure |
| AddServerSubnetProperty | New Procedure |
| UpdateServerSubnetProperty | New Procedure |
| RemoveServerSubnetProperty | New Procedure |
| RemoveAllServerSubnetProperty | New Procedure |
| GenerateMailboxTrafficReport | New Procedure |