Table
|
Change
|
Description
|
Details
|
sf_users
|
Added column
|
[ext_id]
[nvarchar](255) NULL
|
Stores the id of the user in the external provider
|
sf_idsrv_claims
|
Added column
|
[ext_provider_name]
[nvarchar](255) NOT NULL
|
Stores the name of the external provider (unique key combined with ext_id)
|
sf_idsrv_claims
|
Added column
|
[ext_id]
[nvarchar](255) NOT NULL
|
Stores the id of the user in the external provider (unique key combined with ext_provider_name)
|
sf_idsrv_claims
|
Updated column
|
From
[email] [varchar](255) NOT NULL
To
[email] [varchar](255) NULL
|
Before claims where stored by email but now they are stored by unique combination of ext_id & ext_provider_name
|
sf_workflow_definition
|
Updated table
|
From
sf_workflow_definition
To
sf_wfl_definition
|
Stores workflow definitions
|
sf_workflow_definition
|
Removed column
|
[culture_scope] [varchar] (2000) NULL
|
|
sf_workflow_definition
|
Removed column
|
[snd_frst_lvl_mail_notification] [tinyint] NOT NULL
|
|
sf_workflow_definition
|
Removed column
|
[snd_scnd_lvl_mail_notification] [tinyint] NOT NULL
|
|
sf_wfl_definition
|
Added column
|
[allow_notes] [tynyint] NULL
|
Stores the value controlling whether notes are enabled
|
sf_wrkflw_dfntn_ddtnl_frst_lvln
|
Removed table
|
|
|
sf_wrkflw_dfntn_ddtnl_scnd_lvl
|
Removed table
|
|
|
sf_workflow_scope
|
Updated table
|
From
sf_workflow_scope
To
sf_wfl_scope
|
Stores workflow scopes
|
sf_workflow_scope
|
Removed column
|
[title] [varchar] (255) NULL
|
|
sf_workflow_scope
|
Removed column
|
[parent_id] [uniqueidentifier] NULL
|
|
sf_workflow_scope
|
Removed column
|
[content_filter_expression] [varchar] (255) NULL
|
|
sf_workflow_scope
|
Removed column
|
[content_type] [varchar] (255) NULL
|
|
sf_wfl_scope
|
Updated column
|
From
[id2] [uniqueidentifier] NULL
To
[workflow_definition_id] [uniqueidentifier] NULL
|
Stores the Id of the workflow definition
|
sf_wfl_type_scope
|
Added table
|
|
Stores the workflow type scopes – single record for each content type defined in the workflow
|
sf_wfl_type_scope
|
Added column
|
[id] [PK][uniqueidentifier] NOT NULL
|
Stores the id
|
sf_wfl_type_scope
|
Added column
|
[scope_id] [uniqueidentifier] NULL
|
Stores the scope id
|
sf_wfl_type_scope
|
Added column
|
[content_type] [varchar] (255) NULL
|
Stores the content type
|
sf_wfl_type_scope
|
Added column
|
[content_filter] [varchar] (max) NULL
|
Stores the content filter
|
sf_wfl_type_scope
|
Added column
|
[include_children] [tynyint] NULL
|
Stores the value indicating whether the type scope will include children of the selected items in the content filter
|
sf_wfl_type_scope
|
Added column
|
[app_name] [varchar] (255) NULL
|
Stores the app name
|
sf_wfl_type_scope
|
Added column
|
[voa_version] [smallint] NOT NULL
|
Stores the voa version
|
sf_wfl_type_scope
|
Added column
|
[last_modified] [datetime] NOT NULL
|
Stores the date when the item was last modified
|
sf_wfl_level
|
Added table
|
|
Stores the worfklow levels
|
sf_wfl_level
|
Added column
|
[id] [PK][uniqueidentifier] NOT NULL
|
Stores the id
|
sf_wfl_level
|
Added column
|
[ordinal] [real] NOT NULL
|
Stores the ordinal of the level
|
sf_wfl_level
|
Added column
|
[workflow_definition_id] [uniqueidentifier] NULL
|
Stores the id of the workflow definition
|
sf_wfl_level
|
Added column
|
[action_name] [varchar] (255) null
|
Stores the action name of the workflow level
|
sf_wfl_level
|
Added column
|
[notify_approvers] [tynyint] NOT NULL
|
Stores the value indicating whether level approvers will be notified by email
|
sf_wfl_level
|
Added column
|
[notify_administrators] [tynyint] NOT NULL
|
Stores the value indicating whether administrators will be notified by email
|
sf_wfl_level
|
Added column
|
[app_name] [varchar] (255) null
|
Stores the app name
|
sf_wfl_level
|
Added column
|
[voa_version] [smallint] NOT NULL
|
Stores the voa version
|
sf_wfl_level
|
Added column
|
[last_modified] [datetime] NOT NULL
|
Stores the date when the item was last modified
|
sf_wfl_lvl_cstm_mil_recipients
|
Added table
|
|
Stores the custom email recipients for the level to be notified
|
sf_wfl_lvl_cstm_mil_recipients
|
Added column
|
[id] [PK] [FK][uniqueidentifier] NOT NULL
|
Stores the id of the workflow level
|
sf_wfl_lvl_cstm_mil_recipients
|
Added column
|
[seq] [PK][int] NOT NULL
|
Stores the ordinal
|
sf_wfl_lvl_cstm_mil_recipients
|
Added column
|
[val] [varchar] (255) null
|
Stores the email to wich an email should be sent
|
sf_workflow_permission
|
Updated table
|
From
sf_workflow_permission
To
sf_wfl_permission
|
Stores the data which users/roles have the permission to execute the workflow level
|
sf_workflow_permission
|
Removed column
|
[id2] [uniqueidentifier] NULL
|
|
sf_wfl_permission
|
Added column
|
[workflow_level_id] [uniqueidentifier] NULL
|
Stores the workflow level id
|
sf_pblshng_pnt_sttngs_stp_kywr
|
Removed table
|
|
|
sf_workflow_scope_selected_ids
|
Removed table
|
|
|
sf_wrkflw_dfntn_prmssnst_bjct_
|
Updated table
|
From
sf_wrkflw_dfntn_prmssnst_bjct_
To
sf_wfl_dfntn_prmssnst_bjct_ttl
|
|
sf_wrkflw_dfntn_sf_permissions
|
Updated table
|
From
sf_wrkflw_dfntn_sf_permissions
To
sf_wfl_dfnition_sf_permissions
|
|
sf_wrkflw_dfntn_spprtd_prmssn_
|
Updated table
|
From
sf_wrkflw_dfntn_spprtd_prmssn_
To
sf_wfl_dfntn_spprtd_prmssn_sts
|
|
sf_config_variables
|
Updated column
|
From
[id] [PK] [uniqueidentifier] NOT NULL
To
[id] [uniqueidentifier] NULL
|
|
sf_config_variables
|
Updated column
|
From
[app_name] [varchar255] NULL
To
[app_name] [PK]
[varchar255] NOT NULL
|
|
sf_mb_dynamic_module_field
|
Added column
|
[recommended_characters_count] [int] NULL
|
|
sf_meta_fields
|
Added column
|
[recommended_characters_count] [int] NULL
|
|
sf_object_data
|
Added column
|
[place_holder] [varchar](50) NULL
|
|
sf_publishing_pipe_settings
|
Removed column
|
[user_name_reference2] [varchar](255) NULL
|
|
sf_publishing_pipe_settings
|
Removed column
|
[app_id_reference] [int] NULL
|
|
sf_publishing_point
|
Updated column
|
From
[is_template] [tinyint] NOT NULL
To
[is_template] [tinyint] NULL
|
|
sf_publishing_point_settings
|
Added column
|
[item_filter_strategy] [int] NULL
|
|
sf_users
|
Added column
|
[ext_id] [nvarchar](255) NULL
|
|
voa_keygen
|
|
|
|
sf_mbl_frmt_cntnt_types
|
Added table
|
|
|
sf_mbl_frmt_cntnt_types
|
Added column
|
[siteId] [uniqueidentifier] NULL
|
|
sf_mbl_frmt_cntnt_types
|
Added column
|
[name] [varchar](255) NULL
|
|
sf_mbl_frmt_cntnt_types
|
Added column
|
[last_modified] [datetime] NOT NULL
|
|
sf_mbl_frmt_cntnt_types
|
Added column
|
[id] [PK] [uniqueidentifier] NOT NULL
|
|
sf_mbl_frmt_cntnt_types
|
Added column
|
[fullName] [varchar](255) NULL
|
|
sf_mbl_frmt_cntnt_types
|
Added column
|
[displayName] [varchar](255) NULL
|
|
sf_mbl_frmt_cntnt_types
|
Added column
|
[app_name] [varchar](255) NULL
|
|
sf_mbl_frmt_dfntns
|
Added table
|
|
|
sf_mbl_frmt_dfntns
|
Added column
|
[siteId] [uniqueidentifier] NULL
|
|
sf_mbl_frmt_dfntns
|
Added column
|
[setting_name] [varchar](255) NULL
|
|
sf_mbl_frmt_dfntns
|
Added column
|
[name] [varchar](255) NULL
|
|
sf_mbl_frmt_dfntns
|
Added column
|
[last_modified] [datetime] NOT NULL
|
|
sf_mbl_frmt_dfntns
|
Added column
|
[id] [PK] [uniqueidentifier] NOT NULL
|
|
sf_mbl_frmt_dfntns
|
Added column
|
[app_name] [varchar](255) NULL
|
|
sf_mbl_frmt_dfntns
|
Added column
|
[active] [tinyint] NOT NULL
|
|
sf_mbl_frmt_sf_mbl_cntnt_typs
|
Added table
|
|
|
sf_mbl_frmt_sf_mbl_cntnt_typs
|
Added column
|
[id] [PK] [FK] [uniqueidentifier]
|
|
sf_mbl_frmt_sf_mbl_cntnt_typs
|
Added column
|
[id2] [PK] [FK] [uniqueidentifier]
|
|
sf_mbl_frmt_templates
|
Added table
|
|
|
sf_mbl_frmt_templates
|
Added column
|
[use_custom_canonical_url] [tinyint] NOT NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[template_name] [varchar](255) NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[mbl_frmt_dfntn_id] [uniqueidentifier] NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[mbl_frmt_cntnt_type_id] [uniqueidentifier] NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[layout_template_name] [varchar](255) NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[last_modified] [datetime] NOT NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[id] [PK] [uniqueidentifier] NOT NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[custom_canonical_url_format] [varchar](255) NULL
|
|
sf_mbl_frmt_templates
|
Added column
|
[app_name] [varchar](255) NULL
|
|
sf_oc_dependencies
|
Added table
|
|
|
sf_oc_dependencies
|
Added column
|
[type_name] [varchar](255) NULL
|
|
sf_oc_dependencies
|
Added column
|
[item_key] [varchar](255) NULL
|
|
sf_oc_dependencies
|
Added column
|
[id] [PK] [uniqueidentifier] NOT NULL
|
|
sf_oc_dependencies
|
Added column
|
[cache_key] [varchar](255) NULL
|
|
sf_oc_dependencies
|
Added column
|
[voa_version] [smallint] NOT NULL
|
|
sf_oc_items
|
Added table
|
|
|
sf_oc_items
|
Added column
|
[site_id] [uniqueidentifier] NULL
|
|
sf_oc_items
|
Added column
|
[key] [PK] [uniqueidentifier] NOT NULL
|
|
sf_oc_items
|
Added column
|
[e_tag] [nvarchar](255) NULL
|
|
sf_oc_items
|
Added column
|
[date_modified] [datetime] NULL
|
|
sf_oc_items
|
Added column
|
[voa_version] [smallint] NOT NULL
|
|