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.
Table: sync_sourceSharepointListName_DestinationSitefinityDocumentLibraryName
Status: Updated
New columns:
Name Type Allow nulls Description voa_version int NULL Maintains the version of a row in this table
Name
Type
Allow nulls
Description
voa_version
int
NULL
Maintains the version of a row in this table
Updated Fields:
Name Type Allow nulls Update Description sf_last_modified datettimeoffset(7) NULL The type of the column is changed to datettimeoffset(7) and the column allows null value sp_last_modified datettimeoffset(7) NULL The type of the column is changed to datettimeoffset(7) and the column allows null value
Update Description
sf_last_modified
datettimeoffset(7)
The type of the column is changed to datettimeoffset(7) and the column allows null value
sp_last_modified
Table: ImportWarnings
Status: New
Description: The import summary now has a collection of warnings. This collection (SynchronizationLog instances) is maintained by the ImportWarnings table.
Table: sf_ec_product
Name Type Allow nulls Description original_owner uniqueidentifier NULL Added in order for keep the real initial owner or author of the product.
original_owner
uniqueidentifier
Added in order for keep the real initial owner or author of the product.
New indexes:
Name Type Description idx_sf_products_app_name Nonclustered Added for optimization purpose idx_sf_products_org_cnt_id Nonclustered Added for optimization purpose idx_sf_products_pub_date Nonclustered Added for optimization purpose idx_sf_products_clr_type Nonclustered Added for optimization purpose
idx_sf_products_app_name
Nonclustered
Added for optimization purpose
idx_sf_products_org_cnt_id
idx_sf_products_pub_date
idx_sf_products_clr_type
Table: sf_ec_product_attribute
Name Type Allow nulls Description ordinal real NOT NULL Added in order for keep the order of the attributes used in the backend and frontend when showing attributes.
ordinal
real
NOT NULL
Added in order for keep the order of the attributes used in the backend and frontend when showing attributes.
Table: sf_ec_cart_order
Name Type Allow Nulls Description shipping_service_code nvarchar NULL Added in order for keep the real code of the service chosen and not using only the title/name of it as before.
Removed columns:
Table: sf_ec_cart_detail
Name Type Allow Nulls Description voa_version smallint NULL Because of removing the optimistic locking check for concurrentchanges on this table.
Table: sf_ec_cart_discount
Name Type Allow Nulls Description voa_version smallint NULL Because of removing the optimistic locking check forconcurrentchanges on this table.
Table: sf_ec_wishlist_detail
Table: sf_forums
Name Type Allow Nulls Description icon_id uniqueidentifier NULL Holds the iconId of the forum. is_locked tinyint NOT NULL Indicates whether the forum is locked for new posts.
Allow Nulls
icon_id
Holds the iconId of the forum.
is_locked
tinyint
Indicates whether the forum is locked for new posts.
Table: sf_forum_groups
Name Type Allow Nulls Description url_name_ uniqueidentifier NULL Holds the url of the forum group. is_locked tinyint NOT NULL Indicates whether the thread is locked for new posts
url_name_
Holds the url of the forum group.
Indicates whether the thread is locked for new posts
Table: sf_lbraries_thumbnail_profiles
Status: New Description: Holds thumbnail profiles related to each library
Description: Holds thumbnail profiles related to each library
Table: sf_media_content
Name Type Allow Nulls Description lgcy_tmb_strg tinyint NOT NULL Indicates if the media content is using the old legacy way use for loading thumbnails. Used by items stored in exterbal blob storage with not regenerated thumbnails after upgrade. tmb_regen tinyint NOT NULL Indicates that the thumbnails for this media content need to be regenerated.
lgcy_tmb_strg
Indicates if the media content is using the old legacy way use for loading thumbnails. Used by items stored in exterbal blob storage with not regenerated thumbnails after upgrade.
tmb_regen
Indicates that the thumbnails for this media content need to be regenerated.
Table: sf_libraries
Status: Updated New columns:
Name Type Allow Nulls Description tmb_regen tinyint NOT NULL Indicates that the thumbnails for this library need to be regenerated. Set to true when a regenerate thumbnails task is started, or after upgrade for libraries using blob storage different than Database.
Indicates that the thumbnails for this library need to be regenerated. Set to true when a regenerate thumbnails task is started, or after upgrade for libraries using blob storage different than Database.
Table: sf_media_thumbnails
Name Type Allow Nulls Description id uniqueidentifier Primary key nme varchar(10) NULL Holds the name of the thumbnail corresponding to the name of the thumbnail profile set for the library file_id uniqueidentifier NULL Holds the id of the blob data total_size bigint NOT NULL The total size of the thumbnail blob data in bytes typ int NOT NULL The type of the thumbnail: 0-Custom (for the furute usage for custom uploaded thumbnails), 1-System (Always generated regardless of thumbnal profiles selected for the library), 3-Autogenerated (generated based on the profiles selected for the library) number_of_chunks int NOT NULL Stored number of chunks. Used only when the blob data is stored in ChunkedBlobStorageProvider uploaded tinyint NOT NULL Stores flag if uploade. Used only when the blob data is stored in ChunkedBlobStorageProvider chunk_size int NOT NULL Stores the size of the chunk. Used only when the blob data is stored in ChunkedBlobStorageProvider width int NULL The width in the thumbnail image in pixels height int NULL The height of the thumbnail image in pixels
id
Primary key
nme
varchar(10)
Holds the name of the thumbnail corresponding to the name of the thumbnail profile set for the library
file_id
Holds the id of the blob data
total_size
bigint
The total size of the thumbnail blob data in bytes
typ
The type of the thumbnail: 0-Custom (for the furute usage for custom uploaded thumbnails), 1-System (Always generated regardless of thumbnal profiles selected for the library), 3-Autogenerated (generated based on the profiles selected for the library)
number_of_chunks
Stored number of chunks. Used only when the blob data is stored in ChunkedBlobStorageProvider
uploaded
Stores flag if uploade. Used only when the blob data is stored in ChunkedBlobStorageProvider
chunk_size
Stores the size of the chunk. Used only when the blob data is stored in ChunkedBlobStorageProvider
width
The width in the thumbnail image in pixels
height
The height of the thumbnail image in pixels
Name Reason sf_media_thumbnails_id Primary key changed from int to guid size Obsolete.Use the nme instead.
Reason
sf_media_thumbnails_id
Primary key changed from int to guid
size
Obsolete.Use the nme instead.
Table: sf_ntf_msg_jb_xcldd_rslvd_kys_
Status: New Description: Handles the excluded subscribers list functionality
Description: Handles the excluded subscribers list functionality
Table: sf_notif_msg_job
Name Type Allow Nulls Description dyn_subsription_list_id uniqueidentifier NULL This column is related to the excluded subscribers list functionality
dyn_subsription_list_id
This column is related to the excluded subscribers list functionality
Table: sf_page_node
Name Type Allow Nulls Description enable_default_canonical_url tinyint NULL Indicates if the canonical URL tag will be added on this page; if there are no widgets on it that will add it automatically. If not set - the global settings will take place.
enable_default_canonical_url
Indicates if the canonical URL tag will be added on this page; if there are no widgets on it that will add it automatically. If not set - the global settings will take place.
Table: sf_page_data
Status: Updated New indexes:
Name Type Description idx_sf_pd_pers_master_id Nonclustered Added for optimization purpose
idx_sf_pd_pers_master_id
Table: sf_object_data
Name Type Description idx_sf_bjct_dta_sibling_id Nonclustered Added for optimization purpose
idx_sf_bjct_dta_sibling_id
Table: sf_presentation_data
Name Type Allow Nulls Description name_for_developers varchar (255) NULL Keeps the Developer name value of the template. It is used to get the template by name instead of GUID ID.
name_for_developers
varchar (255)
Keeps the Developer name value of the template. It is used to get the template by name instead of GUID ID.
Table: sf_permissions
Updated indexes:
Name Type Description idx_sf_permissions Nonclustered Added for optimization purpose
idx_sf_permissions
Table: sf_rdsgn_nav_trnsfrmtn
Status: New Description: Table for many to many relationship between MediaQuery and Navigation Transformations config elements.
Description: Table for many to many relationship between MediaQuery and Navigation Transformations config elements.
Table: sf_site_sync_log_entry
Name Type Allow Nulls Description timestamp datetime NULL Log entry modification time. user_id uniqueidentifier NULL The ID of the user causing the logged event.
timestamp
datetime
Log entry modification time.
user_id
The ID of the user causing the logged event.
Table: sf_site_sync_summary
Name Type Allow Nulls Description server_id varchar(255) NULL The ID of the target server.
server_id
varchar(255)
The ID of the target server.
Table: sf_dashboard_log
Status: New Description: Stores information about items that are shown on the dashboard.
Description: Stores information about items that are shown on the dashboard.
Table: sf_dashboard_watchlist
Status: New Description: Keeps track which user (user_id) is subscribed for which dashboard log entry (dashboard_log_entry_id).
Table: sf_cs_comments
Description: Stores information about comments.
Table: sf_cs_threads
Description: Stores information about threads.
Table: sf_cs_groups
Description: Stores information about groups.
Back To Top
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important