Database Schema Changes 12.0.x
Version 12.0.4
12.0.4.3192 (22.03.2024)
Added Tables
| Table | Column |
|---|---|
| DWPCertificatesSyncResult | ErrorMessage |
| ID | |
| LastSyncDate | |
| TimeStamp | |
| DWPLoginPageConfigurationClass | BackgroundColor |
| BackgroundImage | |
| ButtonColor | |
| ButtonTextColor | |
| Expression-ObjectID | |
| ID | |
| LeftForegroundColor | |
| LeftForegroundImage | |
| Logo | |
| RightForegroundColor | |
| RightForegroundImage | |
| RightForegroundImageBehaviour | |
| ShowRightPanel | |
| TextColor | |
| TimeStamp | |
| UsedInTypeSPSGlobalConfigurationType | |
| WelcomeText | |
| WelcomeTitle | |
| WelcomeTitleColor | |
| DWPLoginPageConfigurationClass-CI | ID |
| LCID | |
| Owner | |
| TimeStamp | |
| WelcomeText | |
| WelcomeTitle | |
| SPSEnvironmentTypePickup | DiaplayString |
| Hidden | |
| ID | |
| Position | |
| TimeStamp | |
| Value | |
| SPSEnvironmentTypePickup-CI | DiaplayString |
| ID | |
| LCID | |
| Owner | |
| TimeStamp |
Added Columns
| Table | Column |
|---|---|
| PDRThemeClassBase | IsAvailable |
| SPSArticleClassBase | OneFromOptionalRequired |
| SPSGlobalConfigurationClassBase | EnvironmentType |
Changed Columns
| Cgange type | TABLE_NAME | COLUMN_NAME | CharacterLengthDifferent |
|---|---|---|---|
| column changed | DWPLoginPageConfigurationClass | Logo | From 100 to -1 |
Version 12.0.3
12.0.3.3107 (05.02.2024)
Deleted Attributes
| Table | Attribute |
|---|---|
| SPSSecurityGroupClassMember | Sid |
12.0.3.3092 (Technical Preview; 20.12.2023)
New Tables
| Table | Attribute |
|---|---|
| DWPActionGroupPickup | DisplayString |
| Hidden | |
| Icon | |
| ID | |
| Position | |
| TimeStamp | |
| Value | |
| DWPActionGroupPickup-CI | DisplayString |
| ID | |
| LCID | |
| Owner | |
| TimeStamp | |
| PDRCustomFilterExpressions | DataDefinition |
| FilterExpression | |
| ID | |
| TimeStamp |
Changed Attributes
| Table | Attribute | Change |
|---|---|---|
| SPSAccountClassAD | HomeDriveUNCPath | Length increased from 255 to 4000 |
| SPSAccountClassAD | TSHomeDriveUNCPath | Length increased from 255 to 4000 |
New Attributes
| Table | Attribute |
|---|---|
| LCMLicenseDemandClassBase | ConfirmationMissingTaskCreated |
| PDRActionClassBase | Group |
| PDRNavigationItemClassBase | ShowStructureInNavigation |
| SPSArticleCategoryClassBase | Icon |
| SPSGenericConnectorConfigurationClassAzureAD | PrefillPersonsEmail |
| SPSGlobalConfigurationClassBase | ForceNewLookForEveryone |
| TelemetryEnabled | |
| SPSSecurityGroupClassMember | Sid |
| PDRThemeClassBase | BaseLayoutColor |
Version 12.0.2
12.0.2.1197 (Technical Release; 02.10.2023)
Deleted Attributes
| Table | Attribute |
|---|---|
| WFPPromotionsTable | Culture |
12.0.2.1193 (Release candidate; 26.09.2023)
New Attributes
| Table | Attribute |
|---|---|
| SPSArticleClassBase | DeclineBookingIfAllChildrenDeclined |
| SPSGlobalConfigurationClassBase | AllowParameterizedFiltersOnly |
| SPSRemoteAgentClassBase | Name |
Deleted Tables
| Table | Attribute |
|---|---|
| AspNetViewState | Date |
| Expire | |
| ID |
Deleted Attributes
| Table | Attribute |
|---|---|
| SPSAlertingConfiguration | SuiteURL |
| SPSGlobalConfigurationClassContractManagement | UseUuxLinksInEmails |
| SPSGlobalConfigurationClassLicenseManagement | UseUuxLinksInEmails |
| SPSGlobalConfigurationClassServiceCatalog | UseUuxLinksInEmails |
| SPSGlobalConfigurationClassServiceDesk | UseUuxLinksInEmails |
| WFPPromotionsTable | Culture |
Version 12.0.1
12.0.1.1174 (21.09.2023)
New Tables
| Table | Attribute |
|---|---|
| DWPAzureADCustomFilterPickup | DisplayString |
| GraphFilterExpression | |
| Hidden | |
| ID | |
| Position | |
| TimeStamp | |
| Type | |
| Value | |
| DWPAzureADCustomFilterPickup-CI | DisplayString |
| ID | |
| LCID | |
| Owner | |
| TimeStamp | |
| DWPAzureADCustomFilterTypePickup | DisplayString |
| Hidden | |
| ID | |
| Position | |
| TimeStamp | |
| Value | |
| DWPAzureADCustomFilterTypePickup-CI | DisplayString |
| ID | |
| LCID | |
| Owner | |
| TimeStamp |
12.0.1.1162 (31.08.2023)
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassSecurity | Saml2LoginSign |
| SPSGlobalConfigurationClassServiceDesk | InheritTaskOwnershipFromInitiator |
12.0.1.1124 (Technical Preview; 03.07.2023)
New Attributes
| Table | Attribute |
|---|---|
| PDRActionClassBase | ReloadPageOnSuccess |
| PDRAudienceClass | UsedInTypePDRDataQueryType |
| PDRDataQueryClassBase | PrimaryFilter |
| PDRDataQueryClassBase | Priority |
| PDRThemeClassBase | IsActiveForNewUi |
| SPSActivityClassGroupTicket | KnownError |
| SPSGlobalConfigurationClassServiceDesk | DaysAllowedToReopenClosedTicket |
Version 12.0
12.0.0.1050 (Release Candidate; 28.03.2023)
New Tables
| Table | Attribute |
|---|---|
| SchemaRelation-SVCDecisionMakerGroupClassBase2SPSSecurityClassRole | DecisionMakerGroups |
| ID | |
| Roles | |
| TimeStamp | |
| SchemaRelation-SVCDecisionMakerGroupClassBase2SPSUserClassBase | DecisionMakerGroupss |
| ID | |
| TimeStamp | |
| Users | |
| SVCDecisionMakerGroupClassBase | Description |
| Expression-ObjectID | |
| Expressions | |
| ID | |
| Name | |
| TimeStamp | |
| TypeID | |
| SVCDecisionMakerGroupClassBase-CI | ID |
| LCID | |
| Name | |
| Owner | |
| TimeStamp |
New Attributes
| Table | Attribute |
|---|---|
| SPSGlobalConfigurationClassBase | HistoryConsolidationUseAuditService |
| HistoryServiceConnection | |
| SPSInventoryClassBase | UsedInTypeSPSPrinterType |
| SPSRatingSummaryClassBase | UsedInTypeSPSArticleTypeGroup |
| UsedInTypeSPSArticleTypeService | |
| UsedInTypeSVCServiceTypeBundle | |
| UsedInTypeSVCServiceTypeConfigGroup |
Changed Attributes
| Table | Attribute | Change |
|---|---|---|
| PDRAsyncOperationClass | OperationName | Size increased from 100 to 1000 |