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 10.2 and 11.0

This article contains list of changes to the database between the current and the previous release. This includes new and deleted tables, as well as changes in table columns.

Database changes are recorded in the UpgradeTrace.log file during upgrade.
For more information, see Log changes to the database during upgrades.

Changed mapping files
File Type of change Description 
SchedulingFluentMapping.cs Added  scheduledTaskDataMapping.HasProperty(p => p.Owner).ToColumn("owner").IsNullable();
ContentLocationsFluentMapping.cs  Added  locationMapping.HasProperty(p => p.ControlId).ToColumn("control_id");
FolderFluentMapping.cs  Added  folderMapping.HasProperty(p => p.LastModified).IsCalculatedOn(DateTimeAutosetMode.InsertAndUpdate).IsNullable();
TaxonomiesFluentMapping.cs
 Added  taxonMapping.HasProperty(p => p.Status).ToColumn("status");
Added  taxonMapping.HasIndex(p => new { p.Status }).WithName("idx_sf_taxon_status");
UserProfileFluentMapping.cs  Added  sitefinityProfileMapping.HasProperty(p => p.Preferences).IsLongText(this.Context, false);
ContentBaseFluentMapping.cs Updated from  approvalTrackingRecordMapping.HasProperty(p => p.Note).IsNullable();
Updated to  approvalTrackingRecordMapping.HasProperty(p => p.Note).IsLongText(context).IsNullable();
PublishingFluentMapping.cs Updated from  pipeSettingsMapping.HasProperty(p => p.AdditionalData).HasValueLength(1000).WithLoadBehavior(LoadBehavior.Eager);
Updated to  pipeSettingsMapping.HasProperty(p => p.AdditionalData).WithValueOpenAccessType(OpenAccessType.UnicodeStringInfiniteLength).WithLoadBehavior(LoadBehavior.Eager);
NewslettersFluentMapping.cs Updated from listMapping.HasProperty(p => p.WelcomeMessageSubject).IsNullable();
Updated to  listMapping.HasProperty(p => p.WelcomeMessageSubject).IsNullable().IsText(this.Context, true);
ListsFluentMapping.cs Removed  listMapping.HasAssociation<Telerik.Sitefinity.Lists.Model.ListItem>(p => p.ListItems).WithOpposite(p => p.Parent).ToColumn("parent_id").IsManaged().IsDependent().OrderBy("ordinal ascending");
Added  listItemMapping.HasAssociation<List>(p => p.Parent).ToColumn("parent_id");

Database schema changes
Table Change Description Details 
[sf_approval_tracking_record]  Updated column From

[note] VARCHAR (255) NULL

 to  

[note] NVARCHAR (MAX) NULL

Users can now enter long text comments when rejecting an item that requires approval.

 
[sf_cnt_locations] Added column  [control_id] UNIQUEIDENTIFIER NULL  Used to uniquely identify the content location for each widget for each content type on a page. 
[sf_folders] Added column  [last_modified] DATETIME NULL  Used for sorting the most recent libraries. 
[sf_list_items] Removed index 

NONCLUSTERED INDEX [idx_sf_list_items_parent_id]

ON [dbo].[sf_list_items]([parent_id] ASC); 

Removed index.
[sf_pblshng_pp_sttngs_ddtnl_dta] Updated column  From

[val] VARCHAR (1000) NULL

 to  

[val] NVARCHAR (MAX) NULL

Users can now enter additional fields for search index that are longer than 1000 characters.

 
[sf_scheduled_tasks] Added column  [owner]UNIQUEIDENTIFIER NULL 

Added new column:  owner.

 
[sf_sitefinity_profile] Added column  [preferences] VARCHAR (MAX) NULL 

Added new column: preferences.

 
[sf_taxa] Added column  [status] INT NOT NULL

Added new column: status.

 
[sf_taxa]  Added index

NONCLUSTERED INDEX [idx_sf_taxon_status]

 ON [dbo].[sf_taxa]([status] ASC)

Added new index for status column.
[sf_lst]  Updated column 

From [welcome_message_subject] VARCHAR (255) NULL 

to

[welcome_message_subject] NVARCHAR (255) NULL

Now the Welcome message subject allows non-ACII characters.

 
This section contains:

Back To Top