| Table |
Change |
Description |
Details |
|
sf_blogs
|
[landing_page_id]
UNIQUEIDENTIFIER
NULL
|
Removed column
|
|
|
sf_ec_product
|
[voa_class]
INT
NOT NULL
|
Added column
|
|
|
sf_forum_posts
|
CREATE NONCLUSTERED INDEX [idx_sf_posts_last_modified]
ON [dbo].[sf_forum_posts]([last_modified] DESC);
GO
|
Added index
|
Improve performance of RSS Feeds
|
|
sf_mb_dynamic_module
|
[origin]
VARCHAR (255)
NULL
|
Added column
|
New column is added to persist the origin of the dynamic modules. It is used for the purpose of the Add-ons.
|
|
sf_mb_dynamic_module_field
|
[origin]
VARCHAR (255)
NULL
|
Added column
|
New column is added to persist the origin of the dynamic module fields. It is used for the purpose of the Add-ons.
|
|
sf_mb_dynamic_module_type
|
[origin]
VARCHAR (255)
NULL
|
Added column
|
New column is added to persist the origin of the dynamic module types. It is used for the purpose of the Add-ons.
|
|
sf_meta_fields
|
[origin]
VARCHAR (255)
NULL
|
Added column
|
New column is added to persist the origin of the meta types. It is used for the purpose of the Add-ons.
|
|
sf_meta_types
|
[origin]
VARCHAR (255)
NULL
|
Added column
|
New column is added to persist the origin of the meta typesmodul. It is used for the purpose of the Add-ons.
|
|
sf_pckgng_pckgs
|
[version]
UNIQUEIDENTIFIER
NOT NULL
|
Added column
|
New column is added to persist the latest installed version of a package (Add-on or deployment package).
|
|
sf_sites
|
[site_configuration_mode]
INT
NOT NULL
|
Added column
|
Specifies current mode of the site, whether it is configured to be updated manually or via deployment package.
|
|
sf_stat_sentence
|
CREATE NONCLUSTERED INDEX [IX_sf_stat_sntnc_subject_key]
ON [dbo].[sf_stat_sentence]([subject_key] ASC);
GO
|
Added index
|
Improves performance on user login when Personalization module is enabled.
|
|
sf_pckgng_addn_lnks
|
|
New table
|
New table is introduced to persist the relation between add-ons and the items (dynamic modules, content items, page templates, forms,etc) installed from the add-on.
|
|
sf_pckgng_addns
|
|
New table
|
New table is introduced to persist the data for the add-ons installed in the system.
|
|
sf_pckgng_addns_err_stts
|
|
New table
|
New table is introduced to persist the error state of the add-ons.
|
|
sf_pckgng_addns_stts
|
|
New table
|
New table is introduced to persist the status of the add-ons per site.
|
|
sf_xml_config_items
|
|
New table
|
|
|
sf_diag_OperationLog
|
|
Removed table
|
The data is now stored in sf_diag_sample_logs
|
|
sf_diag_QueryLog
|
|
Removed table
|
The data is now stored in sf_diag_sample_logs
|
|
sf_diag_sample_logs
|
|
New table
|
New table introduced to persist the collected data for all profiled operations.
|
|
sf_diag_MultiplePageCompilationsReport
|
|
New stored procedure
|
Provides analyzed data for page compilations
|
|
sf_diag_MultiplePageExecutionsReport
|
|
New stored procedure
|
Provides analyzed data for page compilations
|
|
sf_diag_report_RunBigResultSetAnalysis
|
|
Recreated stored procedure
|
|
|
sf_diag_report_RunLongQueryAnalysis
|
|
Recreated stored procedure
|
|
|
sf_diag_RunNPlusOneAnalysis
|
|
Recreated stored procedure
|
|