Select a site

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.

Database changes between 7.3 and 8.0

New tables

Table: sf_wrkflw_dfntn_ddtnl_frst_lvl

Description: Stores the additional first level email recipients when an item is sent for approval (for 2 step workflow) or publishing (for 1 step workflow)

CREATE TABLE [dbo].[sf_wrkflw_dfntn_ddtnl_frst_lvl](
    [id] [uniqueidentifier] NOT NULL,
    [seq] [int] NOT NULL,
    [val] [varchar](255) NULL,
    CONSTRAINT [pk_sf_wrkflw_dfntn_dd_436CF226] PRIMARY KEY CLUSTERED
    (
        [id] ASC,
        [seq] ASC
    )
    WITH (
        PAD_INDEX  = OFF,
        STATISTICS_NORECOMPUTE  = OFF,
        IGNORE_DUP_KEY = OFF,
        ALLOW_ROW_LOCKS  = ON,
        ALLOW_PAGE_LOCKS  = ON
    )
    ON [PRIMARY]
) ON [PRIMARY]
GO
 
SET ANSI_PADDING OFF
GO
 
ALTER TABLE [dbo].[sf_wrkflw_dfntn_ddtnl_frst_lvl]
    WITH CHECK ADD  CONSTRAINT [ref_sf_wrkflw_dfntn_d_6A239D1A]
    FOREIGN KEY([id])
    REFERENCES [dbo].[sf_workflow_definition] ([id])
GO
 
ALTER TABLE [dbo].[sf_wrkflw_dfntn_ddtnl_frst_lvl]
    CHECK CONSTRAINT [ref_sf_wrkflw_dfntn_d_6A239D1A]
GO

Table: sf_wrkflw_dfntn_ddtnl_scnd_lvl

Description: Stores the additional second level email recipients when an item is sent for publishing through the workflow.

CREATE TABLE [dbo].[sf_wrkflw_dfntn_ddtnl_scnd_lvl](
    [id] [uniqueidentifier] NOT NULL,
    [seq] [int] NOT NULL,
    [val] [varchar](255) NULL,
    CONSTRAINT [pk_sf_wrkflw_dfntn_dd_6936DCD4] PRIMARY KEY CLUSTERED (
        [id] ASC,
        [seq] ASC
    )
    WITH (
        PAD_INDEX  = OFF,
        STATISTICS_NORECOMPUTE  = OFF,
        IGNORE_DUP_KEY = OFF,
        ALLOW_ROW_LOCKS  = ON,
        ALLOW_PAGE_LOCKS  = ON
    ) ON [PRIMARY]
) ON [PRIMARY]
GO
 
SET ANSI_PADDING OFF
GO
 
ALTER TABLE [dbo].[sf_wrkflw_dfntn_ddtnl_scnd_lvl] 
    WITH CHECK ADD  CONSTRAINT [ref_sf_wrkflw_dfntn_d_FA8BA617] FOREIGN KEY([id])
    REFERENCES [dbo].[sf_workflow_definition] ([id])
GO
 
ALTER TABLE [dbo].[sf_wrkflw_dfntn_ddtnl_scnd_lvl]
    CHECK CONSTRAINT [ref_sf_wrkflw_dfntn_d_FA8BA617]
GO

Updated tables

Table: sf_schema_vrsns

Description: Changed column

The type of the cultures column was changed from varchar(1000) to varchar(2000).
Name Type Allow nulls Description Affects
cultures VARCHAR (2000) NULL

Table: sf_taxonomies

Description: New column

The column root_id was added to sf_taxonomies.
Name Type Allow nulls Description Affects
root_id UNIQUEIDENTIFIER NULL

Table: sf_workflow_definition

Description: New columns

  • New column culture_scope: stores a comma separated value of the cultures for which the current workflow definition is to be applied.
  • New column allw_pblshers_to_skip_workflow: indicates whether last level approvers will entirely skip workflow and go to the last step.
  • New column custom_xamlx_url: a URL which overrides the default XAMLX file path
Name Type Allow nulls Description Affects
culture_scope VARCHAR (2000) NULL

allw_pblshers_to_skip_workflow TINYINT NOT NULL

custom_xamlx_url NVARCHAR (255) NULL

Table: sf_workflow_scope

Description: New column

The column provider_name was added to sf_workflow_scope.
Name Type Allow nulls Description Affects
provider_name VARCHAR (255) NULL

Table: sf_folders

Description: New column

The column cover_id was added to sf_folders.
Name Type Allow nulls Description Affects
cover_id uniqueidentifier NULL

Table: sf_libraries

Description: New column

The column cover_id was added to sf_libraries.
Name Type Allow nulls Description Affects
cover_id uniqueidentifier NULL

Back To Top

Next: Database changes between 7.2 and 7.3