postgres-upgrade.sql - midPoint 4.5

Change 5

Adds correlation timestamps and situation columns to shadows, including supporting indexes.

Change 4

Adds CorrelationSituationType enum type for identity matching.

Change 3

Adds m_message_template table, triggers, and indexes.

Change 2

Adds MESSAGE_TEMPLATE object type value.

m_shadow

Modified table

Adds correlation timestamps and correlation situation columns.

m_shadow_correlationStartTimestamp_idx

New index

Supports filtering by correlation start time.

m_shadow_correlationEndTimestamp_idx

New index

Supports filtering by correlation end time.

m_shadow_correlationCaseOpenTimestamp_idx

New index

Supports filtering by correlation case open time.

m_shadow_correlationCaseCloseTimestamp_idx

New index

Supports filtering by correlation case close time.

CorrelationSituationType

New enum type

Adds identity matching correlation situation values.

m_message_template

New table

Stores message template objects.

m_message_template_oid_insert_tr

New trigger

Reserves OID rows for inserted message templates.

m_message_template_update_tr

New trigger

Maintains update metadata for message templates.

m_message_template_oid_delete_tr

New trigger

Releases OID rows for deleted message templates.

m_message_template_nameOrig_idx

New index

Supports lookup by original object name.

m_message_template_nameNorm_key

New unique index

Enforces unique normalized object names.

m_message_template_policySituation_idx

New index

Supports filtering by policy situation.

m_message_template_createTimestamp_idx

New index

Supports filtering or ordering by creation time.

m_message_template_modifyTimestamp_idx

New index

Supports filtering or ordering by modification time.

ObjectType

Modified enum type

Adds MESSAGE_TEMPLATE.