Release Notes › Announcements › Announcements for 12.5 › Database Schema Changes

Database Schema Changes

For the current version of CA DataMinder, the database schema version is 3.60. This version includes the following changes to support the new database security models:

New tables and related indexes

Wgn3IssueTrigger

Wgn3Role

Wgn3ResourceType

Wgn3Resource

Wgn3ResourceRole

Wgn3UserRole

New table

TMP_WGN3POLICYRLS

Performance optimizations

Wgn3Trigger table

New index: IX_WGN3TRIGGER_POLICYID

Wgn3UserGroup table

New columns:

• EffectiveStartDate
• EffectiveEndDate

New Indexes:

• IX_WGN3USERDATEGROUP
• IX_WGN3GROUPDATEGUSER

TMP_WGN3ADDRRLS

(Oracle only) Removed indexes:

• IX_TMP_WGN3ADDRRLS_GROUP
• IX_TMP_WGN3ADDRRLS_USER

Note: Full schema details are available in the CA DataMinder Database Schema and Views Reference Guide.