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.0 and 7.1

New Tables

Table: [sf_rbin_item]

Description: Part of the new Recycle Bin module. 

CREATE TABLE [dbo].[sf_rbin_item] (
 
    [owner]                     UNIQUEIDENTIFIER NULL,
 
    [last_modified]             DATETIME         NOT NULL,
 
    [id]                        UNIQUEIDENTIFIER NOT NULL,
 
    [del_item_wrkfl_status]     VARCHAR (255)    NULL,
 
    [del_item_type_name]        VARCHAR (255)    NULL,
 
    [del_item_title]            VARCHAR (255)    NULL,
 
    [del_item_site_id]          UNIQUEIDENTIFIER NULL,
 
    [del_item_prvdr_name]       VARCHAR (255)    NULL,
 
    [del_item_parent_type_name] VARCHAR (255)    NULL,
 
    [del_item_titles_path]      VARCHAR (255)    NULL,
 
    [del_item_lang]             VARCHAR (255)    NULL,
 
    [del_item_id]               UNIQUEIDENTIFIER NULL,
 
    [date_created]              DATETIME         NOT NULL,
 
    [app_name]                  VARCHAR (255)    NULL,
 
    [voa_version]               SMALLINT         NOT NULL,
 
    CONSTRAINT [pk_sf_rbin_item] PRIMARY KEY CLUSTERED ([id] ASC)
 
);
 
GO
 
  
 
CREATE NONCLUSTERED INDEX [idx_sf_rbin_item_type]
 
    ON [dbo].[sf_rbin_item]([del_item_type_name] ASC);
 
GO

Table: sf_blog_posts

Status: Updated

Description: New column added

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL
Blogs module

Table: sf_blogs

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL Blogs module

Table: sf_commnt

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL Comments

Table: sf_content_items

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL All content modules

Table: sf_control_properties

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
flags INT NOT NULL

Table: sf_draft_pages

Status: Updated

Description: New column

Name  Type  Allow nulls  Description  Affects 
 flags  INT  NOT NULL    Pages

Table: sf_dynamic_content

Status: Updated

Description: New columns

Name Type Allow nulls Description Affects
was_published TINYINT NULL Module builder
item_default_url NVARCHAR (510) NULL Module builder

Table: sf_ec_product

Status: Updated

Description: New column

New column:

Name Type Allow nulls Description Affects
rating NUMERIC (20, 10) NULL eCommerce module

Table: sf_ec_product_type

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
has_customer_defined_price TINYINT NOT NULL eCommerce module

Table: sf_events

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL Events module

Table: sf_form_description

Status: Updated

Description: New column

 Name Type  Allow nulls  Description  Affects 
 include_in_sitemap TINYINT NOT NULL
Forms module

Table:  sf_forums

Status: Updated

Description: New column

 Name Type  Allow nulls  Description  Affects 
 include_in_sitemap  TINYINT  NOT NULL    Forums module

Table: sf_libraries

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL
Videos, Images, Documents

Table: sf_list_items

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL
Lists module

Table: sf_lists

Status: Updated

Description: New column.

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL
Listsmodule

Table: sf_media_content

Status: Updated

Description: New column

Name Type Allow nulls Description Affects
include_in_sitemap TINYINT NOT NULL
Images, Videos, Documents
 was_published TINYINT NULL  

Images, Videos, Documents

Table: sf_meta_types

Status: Updated

Description: New column

 Name Type  Allow nulls  Description  Affects 
parent_type_id UNIQUEIDENTIER NULL    

Table: sf_news_items

Status: Updated

Description: New columns

Name  Type  Allow nulls  Description  Affects 
include_in_sitemap TINYINT NOT NULL    
was_published TINYINT NULL    

Table: sf_object_data

Status: Updated

Description: New column

Name Type  Allow nulls  Description Affects
vrsn INT NOT NULL    

Table: sf_page_data

Status: Updated

Description: New column

Name  Type  Allow nulls  Description  Affects 
flags INT NOT NULL   Pages

Table: sf_page_node

Status: Updated

Description: New columns

Name Type  Allow nulls  Description  Affects 
priority REAL NOT NULL   Pages
previous_parent_id UNIQUEIDENTIFIER NULL   Pages
is_deleted TINYINT NOT NULL   Pages
include_in_sitemap TINYINT NULL   Pages

Back To Top

Next: Database changes between 6.3 and 7.0