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 8.2 and 9.0

Added tables
Table Change Details
sf_files_monitor_data New table The fluent mapping is moved to new assembly - Telerik,Sitefinity.Frontend.Data.dll. The database scheme stays the same as before.
sf_media_file_links New table Stores the links to media files for a given culture.
Up to Sitefinity CMS 8.2 this information has been part of the sf_media_content table and the file link was only one for all cultures. In 9.0 can have more than one link for a media content item - one for each culture.
sf_module_vrsn
 New table

A new entity has been introduced - ModuleVersion. It is used to keep application modules information in the database: id, name, version, previous version, error message (previously kept in SystemConfig). The entity is mapped to a database table - sf_module_vrsn;
sf_media_file_urls New table Up to Sitefinity CMS 8.2 the URLs to the media files are generated based on the media content URLsm stored in sf_url_data (appending an extension). In Sitefinity CMS 9.0 you may have different URLs for media content item and media file. The information for file URLs is stored in sf_media_file_urls table.
sf_pckgng_pckgs New table Used for storing generated and applied packages

Updated tables
Table Change Details
sf_dynamic_content
 New column: include_in_sitemap
 Type: TINYINT
sf_media_thumbnails
 New column: culture
Type: VARCHAR (255)
 In Sitefinity CMS 9.0 thumbnails are stored per culture.
sf_notif_msg_template
 Changed column: subject
Change: NVARCHAR (80) to NVARCHAR (255)
 Type: NVARCHAR (255)
sf_media_content

New column: media_file_url_name

Removed columns: total_size, mime_type, number_of_chunks, file_path, file_id, width, height, extension, height2, width2, chunk_size

Columns are moved in: sf_media_file_links

 Stores base information to generate URL for the file. The same column is used for each language version (with suffix in the name) to persist the culture specific part of the base URL name of the file.

Back To Top

Next: Database changes between 8.0 and 8.1