Select a site

IMPORTANT: This version of Sitefinity CMS is out of support and the respective product documentation is no longer maintained and can be outdated. Use the version selector to view a supported product version.

Database changes between 9.2 and 10.0

Added tables
Table Change Description Details
[sf_idsrv_claims]
 Added Added for the new authentication with Identity Server.
 Persists the Identity Server claims.
[sf_idsrv_consents]
 Added Added for the new authentication with Identity Server.
 Persists the Identity Server consents, containing the records of subject with his allowed scopes for specific client.
[sf_idsrv_keys]
 Added Added for the new authentication with Identity Server. Persists the Identity Server data keys, containing the info about consent items and tokens for specific subject and client.
[sf_idsrv_tokens]
 Added Added for the new authentication with Identity Server. Persists the tokens, issued by Identity Server.

Modified tables
Table Change Description Details
[sf_content_link]
 Changed column
 [child_item_additional_info] is now  NVARCHAR (1024)
  
[sf_failed_deliveries]
 Changed column
 [description] is now NVARCHAR (255)
 Support for Unicode symbols for email campaigns
[sf_notif_subscr_list]
 Changed column
 [title] is now NVARCHAR (255)
 Support for Unicode symbols for email campaigns
[sf_notif_subscribers]
 Changed column
 [first_name] is now NVARCHAR (255)
 Support for Unicode symbols for email campaigns
[sf_notif_subscribers]
 Changed column
 [last_name] is now NVARCHAR (255)
 Support for Unicode symbols for email campaigns
[sf_ntf_sbscrbrs_cstm_prperties]
 Changed column
 [val]  is now  NVARCHAR (255)
 Support for Unicode symbols for email campaigns
[sf_page_data]
 Changed column
 [sliding_expiration] NULL
 Allow null values, lazy loading. Deprecated use. Stored whether the cached page output should expire depending on the last time it was accessed. Now managed through the PageData.OutputCacheProfile property 
[sf_page_data]
 Changed column
 [cache_output] TINYINT
 Allow null values, lazy loading. Deprecated use. Stored whether the page output should be cached. Now managed through the PageData.OutputCacheProfile property
[sf_page_data] Changed column
 [cache_duration] INT
 Allow null values, lazy loading. Deprecated use. Stored the amount of time the page output should be cached. Now managed through the PageData.OutputCacheProfile property
[sf_pckgng_addn_lnks]
 Added column
 [addtnl_info]
 Added to track config elements added from add-ons for the purpose of deleting add-ons. This is used to delete the config elements that originated from a given add-on. 
[sf_pckgng_addns]
 Added column
 [addn_key]
 Add-on key is used as part of the for the purpose of deleting add-ons. It is a mapping between filesystem and database for tracking each add-on. This tracking allows for safe deployment on NLB environments after Add-on deletion.
[sf_pckgng_addns]
 Created index
 CREATE UNIQUE NONCLUSTERED INDEX [idx_name] 

ON [dbo].[sf_pckgng_addns]([name] ASC); 

GO
 Index is created to optimize getting Add-Ons by name
[sf_users]
 Added columns
 [ext_provider_name]
 Persists the name of the external provider that was used to create this user
[sf_users] Created index
 CREATE NONCLUSTERED INDEX [sf_idx_email] 

ON [dbo].[sf_users]([email] ASC); 

GO
 Index is created to optimize getting user by email.

Back To Top

Next: Database changes between 9.1 and 9.2