postgres-upgrade.sql - midPoint 4.6

Last modified 01 Jul 2026 12:22 UTC
Table of Contents

Changes

Change Description

Change 11

Adds connector availability flag.

Change 10

Adds resource template flag.

Change 9

Adds focus identity container table and normalized focus data indexing.

Change 8

Adds fuzzy string matching extension and FOCUS_IDENTITY container type value for smart correlation.

Change 7

Adds administrative availability status column to resources.

Change 6

Adds AdministrativeAvailabilityStatusType enum type.

Change 11

Since version: 4.6

Adds connector availability flag.

Object Change type Description

m_connector

Modified table

Adds connector availability flag.

Change 10

Since version: 4.6

Adds resource template flag.

Object Change type Description

m_resource

Modified table

Adds resource template flag.

Change 9

Since version: 4.6

Adds focus identity container table and normalized focus data indexing.

Object Change type Description

m_focus_identity

New table

Stores focus identity containers for correlation.

m_focus_identity_sourceResourceRefTargetOid_idx

New index

Supports lookup of focus identities by source resource.

m_focus

Modified table

Adds normalized focus data storage.

m_focus_normalizedData_idx

New index

Supports filtering by normalized focus data.

Change 8

Since version: 4.6

Adds fuzzy string matching extension and FOCUS_IDENTITY container type value for smart correlation.

Object Change type Description

fuzzystrmatch

New extension

Enables fuzzy string matching used by smart correlation.

ContainerType

Modified enum type

Adds FOCUS_IDENTITY.

Change 7

Since version: 4.6

Adds administrative availability status column to resources.

Object Change type Description

m_resource

Modified table

Adds administrative availability status column.

Change 6

Since version: 4.6

Adds AdministrativeAvailabilityStatusType enum type.

Object Change type Description

AdministrativeAvailabilityStatusType

New enum type

Adds administrative availability values for resources.
Was this page helpful?
YES NO
Thanks for your feedback