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.
Table: sf_events
Status: Updated
Description: Added a new column
New Column:
Name Type Allow nulls Description Affects timezone_id VARCHAR (255) NULL Added new column Events module
Name
Table: OAImportConfigurations
Description: Max characters of the types are increased from VARCHAR (255) to VARCHAR (2000).
Name Type Allow nulls Description Affects BaseConnectionString VARCHAR (2000) NULL SourceConnectionString VARCHAR (2000) NULL DestinationConnectionString VARCHAR (2000) NULL
Table: OASyncImportSummary
Description: Deleted columns
Deleted columns:
Name Type Allow nulls Description Affects Reads INT NOT NULL Inserts INT NOT NULL Updates INT NOT NULL Deletes INT NOT NULL
Table: OASyncListSummary
Description: New columns and new index are added
New columns:
Name Type Allow nulls Description Affects SourceDeletes INT NOT NULL SourceInserts INT NOT NULL SourceReads INT NOT NULL SourceUpdates INT NOT NULL DestinationDeletes INT NOT NULL DestinationInserts INT NOT NULL DestinationReads INT NOT NULL DestinationUpdates INT NOT NULL BaseDeletes INT NOT NULL BaseInserts INT NOT NULL BaseReads INT NOT NULL BaseUpdates INT NOT NULL
New index:
GO CREATE NONCLUSTERED INDEX [idx_OASyncLstSmmry_ImprtSmmary] ON [dbo].[OASyncListSummary]([ImportSummary] ASC); GO
GO
CREATE
NONCLUSTERED
INDEX
[idx_OASyncLstSmmry_ImprtSmmary]
ON
[dbo].[OASyncListSummary]([ImportSummary]
ASC
);
Table: sf_content_link
Description: New columns
Name Type Allow nulls Description Affects available_for_temp TINYINT NOT NULL Indicates whether a particular link is available for the temp version of the of the related item. Related data available_for_master TINYINT NOT NULL Indicates whether a particular link is available for the temp version of the of the related item. Realated data available_for_live TINYINT NOT NULL Indicates whether a particular link is available for the temp version of the of the related item. Related data
Table: sf_ec_cart_order
Description: New column
New column:
Name Type Allow nulls Description Affects user_id UNIQUEIDENTIFIER NULL Ecommerce module
Table: sf_ec_product
Description: Deleted column
Deleted column:
Name Type Allow nulls Description Affects voa_class INT NOT NULL Ecommerce module
Table: sf_form_entry
Name Type Allow nulls Description Affects source_site_name VARCHAR (255) NULL Forms module source_site_id UNIQUEIDENTIFIER NULL Forms module
Table: sf_mb_dynamic_module_field
Name Type Allow nulls Description Affects related_content_type VARCHAR (255) NULL Module builder related_content_provider VARCHAR (255) NULL Module builder frontend_widget_type_name VARCHAR (255) NULL Module builder frontend_widget_label VARCHAR (255) NULL Module builder
Table: sf_object_data
Name Type Allow nulls Description Affects is_overrided_control TINYINT NULL editable TINYINT NULL base_control_id UNIQUEIDENTIFIER NULL enable_override_for_control TINYINT NULL enable_override_for_control2 TINYINT NULL
Table: sf_page_data
Description: Deleted several columns and added new one. Fix page node - page data relationship; move metadata properties from page data to page node.
Name Type Allow nulls Description Affects ui_culture VARCHAR (255) NULL Pages translation_initialized TINYINT NOT NULL Pages require_ssl TINYINT NOT NULL Pages page_languagelink_id UNIQUEIDENTIFIER NULL Pages localization_strategy SMALLINT NULL Pages keywords NVARCHAR (500) NULL Pages html_title_ NVARCHAR (500) NULL Pages crawlable TINYINT NOT NULL Pages voa_version SMALLINT NOT NULL Pages
Removed query to create index:
CREATE NONCLUSTERED INDEX [idx_sf_pg_dt_pg_lnguagelink_id] ON [dbo].[sf_page_data]([page_languagelink_id] ASC); GO
[idx_sf_pg_dt_pg_lnguagelink_id]
[dbo].[sf_page_data]([page_languagelink_id]
Name Type Allow nulls Description Affects page_node_id UNIQUEIDENTIFIER NULL
Added new index:
CREATE NONCLUSTERED INDEX [idx_sf_page_data_page_node_id] ON [dbo].[sf_page_data]([page_node_id] ASC); GO
[idx_sf_page_data_page_node_id]
[dbo].[sf_page_data]([page_node_id]
Table: sf_page_node
Description: Deleted index and added new columns. Fix page node - page data relationship; move metadata properties from page data to page node. Add the ability to configure if the page should be included in the internal search index (different configuration from crawl-able by external search engines)
Deleted index:
CREATE NONCLUSTERED INDEX [idx_sf_page_node_content_id] ON [dbo].[sf_page_node]([content_id] ASC); GO
[idx_sf_page_node_content_id]
[dbo].[sf_page_node]([content_id]
Name Type Allow nulls Description Affects require_ssl TINYINT NOT NULL Pages loc_strtgy SMALLINT NULL Pages keywords_ NVARCHAR (500) NULL Pages inc_in_srch_idx TINYINT NOT NULL Pages html_title_ NVARCHAR (500) NULL Pages crawlable_ TINYINT NOT NULL Pages
Table: sf_taxonomy_statistic
Description: Added new index to improve performance for taxonomy statistics.
GO CREATE NONCLUSTERED INDEX [idx_sf_taxonomy_statistic] ON [dbo].[sf_taxonomy_statistic]([data_item_type] ASC, [taxon_id] ASC, [statistic_type] ASC, [item_provider_name] ASC); GO
[idx_sf_taxonomy_statistic]
[dbo].[sf_taxonomy_statistic]([data_item_type]
, [taxon_id]
, [statistic_type]
, [item_provider_name]
[sf_page_language_link] - Used for multilingual split pages to maintain the relation between split page data items. It is not used anymore.
Table: sf_site_sync_server
Status: New
Table: sf_site_sync_log_entry
Description: Added new index to improve performance.
CREATE NONCLUSTERED INDEX [sf_site_sync_log_entry] ON [dbo].[sf_site_sync_log_entry] ( [type_name] ASC, [serverId] ASC, [provider] ASC, [item_id] ASC )
[sf_site_sync_log_entry]
[dbo].[sf_site_sync_log_entry]
(
[type_name]
,
[serverId]
[provider]
[item_id]
)
Table: sf_site_sync_summary
CREATE NONCLUSTERED INDEX [sf_site_sync_summary] ON [dbo].[sf_site_sync_summary] ( [server_id] ASC )
[sf_site_sync_summary]
[dbo].[sf_site_sync_summary]
[server_id]
Table: sf_dashboard_log
CREATE NONCLUSTERED INDEX [sf_dashboard_log] ON [sf_dashboard_log] ( [timestamp] ASC, [item_type] ASC, [item_id] ASC )
[sf_dashboard_log]
[
timestamp
]
[item_type]
Table: sf_dashboard_watchlist
CREATE NONCLUSTERED INDEX [sf_dashboard_watchlist] ON [dbo].[sf_dashboard_watchlist] ( [user_id] ASC, [dashboard_log_entry_id] ASC )
[sf_dashboard_watchlist]
[dbo].[sf_dashboard_watchlist]
[user_id]
[dashboard_log_entry_id]
Back To Top
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important