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 |
|
|