Skip to main content

2024.1.1 to 2024.1.2

1. System Tables: Updated Constraints and Definitions​

What changed​

The system tables ASYS_AUDIT, ASYS_VERSIONHISTORY, and ASYS_UIDRESOLVER have been updated:

  • ASYS_AUDIT: Introduced a new primary key on columns ATIMESTAMP and AUSER.
  • ASYS_VERSIONHISTORY: Introduced a new primary key on columns TABLE_NAME and VERSION.
  • ASYS_UIDRESOLVER: Added to the Liquibase changelog files.

Why it matters​

Defining explicit primary keys ensures data integrity and improves performance during lookups and joins. Including ASYS_UIDRESOLVER in Liquibase allows for consistent schema management across environments.

Update your environment using the Liquibase changelogs for your system alias or use the in-tool functionality:

  1. Navigate to your system configuration.
  2. Double-click your system.
  3. Right-click on _____SYSTEMALIAS.
  4. Select Organize from the context menu.

Ensure that any custom data operations or migrations account for the new primary key constraints.