Upgrade Guide › Upgrading Databases › Database Schema Changes

Database Schema Changes

If you are upgrading your CA DLP servers to 14.0, note the following changes to the database schema.

For the current version of CA DLP, the database schema version is 3.70. This version includes various changes to support internationalization of the CA DLP product, faster search and report performance, and CA DLP integration with BusinessObjects Enterprise.

New Tables and Related Indexes

WGN3ClassificationBASE

WGN3ClassificationBASE.PK_WGN3ClassificationBASE

WGNWellKnownStringBASE

WGNWellKnownStringBASE.PK_WGNWellKnownStringBase

WGN3StringI18N

WGN3StringI18N.PK_WGN3StringI18N

Performance Optimizations

Wgn3Event Table

New column: QueryFlags

New Index: IX_Wgn3Event_QueryFlags

Wgn3EventParticipant Table

New column: QueryFlags

New Index: IX_Wgn3EventParty_QueryFlags

Role

WGNReportingUser

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