Database changes between 9.1 and 9.2

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

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

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

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