Database changes between 6.3 and 7.0
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 |
Table: OAImportConfigurations
Status: Updated
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
Status: Updated
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
Status: Updated
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
Table: sf_content_link
Status: Updated
Description: New columns
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
Status: Updated
Description: New column
New column:
| Name |
Type |
Allow nulls |
Description |
Affects |
| user_id |
UNIQUEIDENTIFIER |
NULL |
|
Ecommerce module |
Table: sf_ec_product
Status: Updated
Description: Deleted column
Deleted column:
| Name |
Type |
Allow nulls |
Description |
Affects |
| voa_class |
INT |
NOT NULL |
|
Ecommerce module |
Table: sf_form_entry
Status: Updated
Description: New columns
New columns:
| 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
Status: Updated
Description: New columns
New columns:
| 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
Status: Updated
Description: New columns
New columns:
| 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
Status: Updated
Description: Deleted several columns and added new one. Fix page node - page data relationship; move metadata properties from page data to page node.
Deleted columns:
| 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
New column:
| 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
Table: sf_page_node
Status: Updated
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
New columns:
| 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
Status: Updated
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
Removed table
[sf_page_language_link] - Used for multilingual split pages to maintain the relation between split page data items. It is not used anymore.
Site Sync Module
Table: sf_site_sync_server
Status: New
Table: sf_site_sync_log_entry
Status: Updated
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
)
Table: sf_site_sync_summary
Status: Updated
Description: Added new index to improve performance.
CREATE NONCLUSTERED INDEX [sf_site_sync_summary] ON [dbo].[sf_site_sync_summary]
(
[server_id] ASC
)
Dashboard
Table: sf_dashboard_log
Status: Updated
Description: Added new index to improve performance.
CREATE NONCLUSTERED INDEX [sf_dashboard_log] ON [sf_dashboard_log]
(
[timestamp] ASC,
[item_type] ASC,
[item_id] ASC
)
Table: sf_dashboard_watchlist
Status: Updated
Description: Added new index to improve performance.
CREATE NONCLUSTERED INDEX [sf_dashboard_watchlist] ON [dbo].[sf_dashboard_watchlist]
(
[user_id] ASC,
[dashboard_log_entry_id] ASC
)