Database Schema Changes 26.2.x

+ More

Table of Contents

Version 26.2.x Database Schema Changes Deleted Tables Added Tables Deleted Columns Changed Columns Added Columns

Version 26.2.x Database Schema Changes

Deleted Tables

Table	Column
`SPSNewActivityReassignmentPickupMode`	`DisplayString`
	`Hidden`
	`ID`
	`Image`
	`Position`
	`TimeStamp`
	`Value`
`SPSNewActivityReassignmentPickupMode-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`

Added Tables

Table	Column
`DWPEncryptionCertificateClass`	`Content`
	`Description`
	`Expression-ObjectID`
	`ID`
	`NotAfter`
	`NotBefore`
	`Password`
	`TimeStamp`
	`TypeID`
`DWPFileInfoTemp`	`Expression-ObjectID`
	`FileName`
	`ID`
	`LifeTime`
	`TimeStamp`
	`TypeID`
	`UploadComplete`
	`UploadedAt`
`DWPGlobalConfigurationClassAiAgents`	`ConfidenceThreshold`
	`Expression-ObjectID`
	`ID`
	`ImageAnalysisEnabled`
	`MaxFollowUpsCount`
	`PerformPreparationOfAutoResolvedTicket`
	`ServiceDetectionAdvisoryMode`
	`ServiceDetectionEnabled`
	`ShowAutoResolutionJournalEntryToEndUser`
	`TicketPreparationEnabled`
	`TicketResolutionAdvisoryMode`
	`TicketResolutionEnabled`
	`TicketRoutingAdvisoryMode`
	`TicketRoutingEnabled`
	`TimeStamp`
	`UsedInTypeSPSGlobalConfigurationType`
`DWPScriptDefinitionClassBase`	`Description`
	`Expression-ObjectID`
	`ID`
	`Isolated`
	`LongRunning`
	`Name`
	`Purpose`
	`RequireDataLayer`
	`Script`
	`Timeout`
	`TimeStamp`
	`TypeID`
`DWPScriptDefinitionClassParameter`	`DefaultValue`
	`Description`
	`EntityName`
	`Expression-ObjectID`
	`ID`
	`IsMultiple`
	`IsOutput`
	`Name`
	`Position`
	`Required`
	`Schema`
	`TimeStamp`
	`Title`
	`Type`
	`UsedInTypeDWPScriptDefinitionType`
`DWPScriptDefinitionClassParameter-CI`	`Description`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
	`Title`
`DWPScriptDefinitionParameterType`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`DWPScriptDefinitionParameterType-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`DWPScriptDefinitionPickupPurpose`	`DisplayString`
	`Hidden`
	`ID`
	`Position`
	`TimeStamp`
	`Value`
`DWPScriptDefinitionPickupPurpose-CI`	`DisplayString`
	`ID`
	`LCID`
	`Owner`
	`TimeStamp`
`ESMActivityClassServiceLevelHistoryRecords`	`ContractStatus`
	`EndPoint`
	`Expression-ObjectID`
	`ID`
	`NetWorkingTime`
	`PausedMinutes`
	`Pausings`
	`ReactionPoint`
	`ReassignmentReason`
	`ServiceContract`
	`SolutionPoint`
	`StartPoint`
	`TimeStamp`
	`UsedInTypeSPSActivityTypeBase`
	`UsedInTypeSPSActivityTypeIncident`
	`UsedInTypeSPSActivityTypeServiceRequest`
	`UsedInTypeSPSActivityTypeTicket`
`ESMActivityClassServiceLevelHistoryRecords-CI`	`ID`
	`LCID`
	`Owner`
	`ReassignmentReason`
	`TimeStamp`
`EventPublication`	`ContentType`
	`Payload`
	`PublishedAt`
	`Topic`
	`TtlExpiresAt`
`EventSubscription`	`AwaiterHost`
	`AwaiterMarker`
	`CreatedAt`
	`Resolved`
	`SubscriptionId`
	`Topic`
	`TtlExpiresAt`
`SchemaRelation-DWPScriptDefinitionClassBase2DWPScriptDefinitionClassBase0`	`ID`
	`IncludeScripts`
	`TimeStamp`
	`UsedInScripts`
`SchemaRelation-DWPScriptDefinitionClassBase2SPSRemoteAgentClassBase`	`Capabilities`
	`ID`
	`ScriptDefinitions`
	`TimeStamp`
`SchemaRelation-ESMActivityClassOlaHistoryRecords2SPSScRoleClassBase`	`ID`
	`RecipientRole`
	`ServiceLevelHistoryRecords`
	`TimeStamp`
`SchemaRelation-ESMActivityClassOlaHistoryRecords2SPSUserClassBase`	`ID`
	`Recipient`
	`ServiceLevelHistoryRecords`
	`TimeStamp`
`SchemaRelation-SPSRemoteAgentClassBase2PLBEEngineClassBase` `TimeStamp`	`Engines`
	`ID`
	`RequiredCapabilities`

Deleted Columns

Table	Column
`DwpContentWidgetAdaptiveCardTypePickup`	`IsClass`
`SPSGlobalConfigurationClassServiceDesk`	`DefaultNewActivityDelegationMode`
`SPSUserClassBase`	`NewActivityDelegationMode`

Changed Columns

Table	Column	Change
`PDRDataQueryClassBase`	`Priority`	Default: `((0)) <> ((1000))`
`SPSGlobalConfigurationClassServiceDesk`	`DefaultActivityDelegationMode`	Default: `((1)) <> ((5))`

Added Columns

Table	Column
`DWPActionGroupPickup`	`Color`
`DWPFeatureTracking`	`IsUserAnonymized`
`PDRApplicationClassBase`	`ShowActionsAsPanel`
`PDRApplicationClassBase`	`SimpleDatasetViews`
`PDRConfigurationPackageClassBase`	`LicenseItems`
`PDRConfigurationPackageClassBase`	`Sandboxed`
`PDRThemeClassBase`	`AiColorFrom`
	`AiColorMid`
	`AiColorTo`
`PLBEEngineClassBase`	`ForceIsolatedProcess`
`SPSActivityClassBase`	`ActiveOlaRecord`
`SPSActivityPickupPriority`	`Icon`
`SPSArticleClassBase`	`DefaultUserPrice`
	`DefaultUserPrice__CC`
	`MaximumUserPrice`
	`MinimumUserPrice`
	`UserDefinedPricing`
`SPSEmailClassBase`	`HasEmbeddedImages`
`SPSGlobalConfigurationClassBase`	`AnonymizeFeatureTrackingUser`
`SPSGlobalConfigurationClassMailBox`	`EncryptionCertificate`
`SPSGlobalConfigurationClassServiceDesk`	`AutoAssignOlaAtCreation`
`SPSUserClassBase`	`DeactivatedByDelegation`
`SVCShoppingCartClassItem`	`UserPrice`
`SVCShoppingCartClassItem`	`UserPrice__CC`

Database Schema Changes 26.2.x

Contact Us

Version 26.2.x Database Schema Changes

Deleted Tables

Added Tables

Deleted Columns

Changed Columns

Added Columns

Related Articles