Database changes between 7.2 and 7.3
New tables
Table: [sf_cs_comments]
Description: Part of Sitefinity’s comments service.
CREATE TABLE [dbo].[sf_cs_comments](
[status] [nvarchar](100) NULL,
[resolve_key] [nvarchar](255) NOT NULL,
[rating] [numeric](20, 10) NULL,
[parent_thread_id] [uniqueidentifier] NOT NULL,
[message] [nvarchar](max) NULL,
[last_modified_by_name] [varchar](255) NULL,
[last_modified_by_email] [varchar](255) NULL,
[last_modified_by] [uniqueidentifier] NULL,
[last_modified] [datetime] NULL,
[date_created] [datetime] NULL,
[custom_data] [nvarchar](1024) NULL,
[author_name] [nvarchar](255) NULL,
[author_ip_address] [nvarchar](255) NULL,
[author_id] [uniqueidentifier] NULL,
[author_email] [nvarchar](255) NULL)
GO
Table: [sf_cs_groups]
Description: Part of Sitefinity’s comments service.
CREATE TABLE [dbo].[sf_cs_groups](
[title] [nvarchar](255) NULL,
[resolve_key] [nvarchar](255) NULL,
[last_modified] [datetime] NOT NULL,
[id] [uniqueidentifier] NOT NULL,
[description] [nvarchar](255) NULL,
[date_created] [datetime] NULL,
[author_name] [nvarchar](255) NULL,
[author_id] [uniqueidentifier] NULL,
[author_email] [nvarchar](255) NULL)
GO
Table: [sf_cs_threads]
Description: Part of Sitefinity’s comments service.
CREATE TABLE [dbo].[sf_cs_threads](
[type] [nvarchar](255) NULL,
[title] [nvarchar](255) NULL,
[resolve_key] [nvarchar](255) NULL,
[require_authentication] [tinyint] NOT NULL,
[require_approval] [tinyint] NOT NULL,
[parent_group_id] [uniqueidentifier] NOT NULL,
[last_modified] [datetime] NOT NULL,
[language] [nvarchar](10) NULL,
[is_closed] [tinyint] NOT NULL,
[id] [uniqueidentifier] NOT NULL,
[date_created] [datetime] NULL,
[data_source] [nvarchar](255) NULL,
[comments_count] [int] NOT NULL,
[behavior] [nvarchar](100) NULL,
[average_rating] [numeric](20, 10) NULL,
[author_name] [nvarchar](255) NULL,
[author_id] [uniqueidentifier] NULL,
[author_email] [nvarchar](255) NULL)
GO
Table: [sf_dynmc_cntent_sf_permissions]
Description: Used for granular permissions of dynamic content items.
CREATE TABLE [dbo].[sf_dynmc_cntent_sf_permissions](
[base_id] [uniqueidentifier] NOT NULL,
[id] [uniqueidentifier] NOT NULL)
GO
Table: [sf_content_link_attrbutes]
Status: Updated
Description: Removed index
Changed column:
| Name |
Description |
| idx_sf_cntnt_lnk_attrbutes_val |
The index is not available in the latest installation.
The index, however, is not deleted from projects that are upgraded to Sitefinity CMS 7.3. This does not result in any errors or does not break anything in the projects.
|
Table: [sf_dynamic_content]
Status: Updated
Description: New columns
Name
|
Type |
Allow Nulls |
Affects |
| inherits_permissions |
TINYINT |
NOT NULL |
Dynamic content items |
| can_inherit_permissions |
TINYINT |
NOT NULL |
Dynamic content items |
Table: [sf_form_description_attrbutes]
Status: Updated
Description: Removed index
Changed column:
Name
|
Description |
| idx_sf_frm_dscrptn_ttrbtes_val |
The index is not available in the latest installation.
The index, however, is not deleted from projects that are upgraded to Sitefinity CMS 7.3. This does not result in any errors or does not break anything in the projects.
|
Table: [sf_object_data]
Status: Updated
Description: New column
| Name |
Type |
Allow Nulls |
Affects |
| strategy |
SMALLINT |
NOT NULL |
Pages |
Table: [sf_page_data_attrbutes]
Status: Updated
Description: Removed index
Changed column:
Name
|
Description |
| idx_sf_page_data_attrbutes_val |
The index is not available in the latest installation.
The index, however, is not deleted from projects that are upgraded to Sitefinity CMS 7.3. This does not result in any errors or does not break anything in the projects.
|
Table: [sf_page_node_attrbutes]
Status: Updated
Description: Removed index
Changed column:
Name
|
Description |
| idx_sf_page_node_attrbutes_val |
The index is not available in the latest installation.
The index, however, is not deleted from projects that are upgraded to Sitefinity CMS 7.3. This does not result in any errors or does not break anything in the projects.
|
Table: [sf_pblshng_pp_sttngs_ddtnl_dta]
Status: Updated
Description: Removed index
Changed column:
| Name |
Description |
| idx_sf_pblshng_pp_sttngs_ddtnl |
The index is not available in the latest installation.
The index, however, is not deleted from projects that are upgraded to Sitefinity CMS 7.3. This does not result in any errors or does not break anything in the projects.
|
Table: [sf_publishing_point]
Status: Updated
Description: New column
| Name |
Type |
Allow Nulls |
Affects |
| is_shared_with_all_sites |
TINYINT |
NOT NULL |
All modules that have mappings for storing publishing points. |
Table: [sf_taxa_attrbutes]
Status: Updated
Description: Removed index
Changed column:
| Name |
Description |
| idx_sf_taxa_attrbutes_val |
The index is not available in the latest installation.
The index, however, is not deleted from projects that are upgraded to Sitefinity CMS 7.3. This does not result in any errors or does not break anything in the projects.
|
Table: [SyncTask]
Status: Updated
Description: New column
| Name |
Type |
Allow Nulls |
Affects |
| FatalityThreshold |
INT |
NOT NULL |
OpenAccess |
Description: Changed column
The type of the ConfigurationId column is changed from VARCHAR (255) to NVARCHAR (64).
| Name |
Type |
Allow Nulls |
Affects |
| ConfigurationId |
NVARCHAR(64) |
NULL |
OpenAccess |