Database changes between 6.0 and 6.2
Connector for Sharepoint
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 | 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 |
Status: New
Description: The import summary now has a collection of warnings. This collection (SynchronizationLog instances) is maintained by the ImportWarnings table.
Status: Updated
New columns:
| Name | Type | Allow nulls | Description |
| original_owner | uniqueidentifier | NULL | 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 |
Table: sf_ec_product_attribute
Status: Updated
New columns:
| 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. |
Table: sf_ec_cart_order
Status: Updated
New columns:
| 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:
| 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. |
Table: sf_ec_cart_detail
Status: Updated
Removed columns:
| 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
Status: Updated
Removed columns:
| Name | Type | Allow Nulls | Description |
| voa_version | smallint | NULL | Because of removing the optimistic locking check forconcurrentchanges on this table. |
Table: sf_ec_wishlist Status: Updated
Removed columns:
| 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
Status: Updated
Removed columns:
| Name | Type | Allow Nulls | Description |
| voa_version | smallint | NULL | Because of removing the optimistic locking check forconcurrentchanges on this table. |
Forums Module
Status: Updated
New columns:
| 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. |
Status: Updated
New columns:
| 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 |
Status: New
Description: Holds thumbnail profiles related to each library
Status: Updated
New columns:
| 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. |
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. |
Table: sf_media_thumbnails
New columns:
| 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 |
Removed columns:
| Name | Reason |
| sf_media_thumbnails_id | Primary key changed from int to guid |
| size | Obsolete.Use the nme instead. |
Notification Service
Table: sf_ntf_msg_jb_xcldd_rslvd_kys_
Status: New
Description: Handles the excluded subscribers list functionality
Status: Updated
New columns:
| Name | Type | Allow Nulls | Description |
| dyn_subsription_list_id | uniqueidentifier | NULL | This column is related to the excluded subscribers list functionality |
Pages functionality
Status: Updated
New columns:
| 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. |
Status: Updated
New indexes:
| Name | Type | Description |
| idx_sf_pd_pers_master_id | Nonclustered | Added for optimization purpose |
Status: Updated
New indexes:
| Name | Type | Description |
| idx_sf_bjct_dta_sibling_id | Nonclustered | Added for optimization purpose |
Table: sf_presentation_data
Status: Updated
New columns:
| 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. |
Status: Updated
Updated indexes:
| Name | Type | Description |
| idx_sf_permissions | Nonclustered | Added for optimization purpose |
Resposnive Design module
Table: sf_rdsgn_nav_trnsfrmtn
Status: New
Description: Table for many to many relationship between MediaQuery and Navigation Transformations config elements.
Site Sync module
Table: sf_site_sync_log_entry
Status: Updated
New columns:
| 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. |
Table: sf_site_sync_summary
Status: Updated
New columns:
| Name | Type | Allow Nulls | Description |
| server_id | varchar(255) | NULL | The ID of the target server. |
Dashboard Module
Table: sf_dashboard_log
Status: New
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).
Comments Module
Table: sf_cs_comments
Status: New
Description: Stores information about comments.
Table: sf_cs_threads
Status: New
Description: Stores information about threads.
Table: sf_cs_groups
Status: New
Description: Stores information about groups.