Native PostgreSQL Upgrade Script: postgres-upgrade.sql

Change 58

Adds display and preferred name columns and indexes to users.

Change 57

Recreates connector type/version uniqueness indexes with connector-host specific predicates.

Change 56

Drops old connector type/version uniqueness indexes before recreating them.

Change 55

Adds connector development object table and triggers.

Change 54

Adds CONNECTOR_DEVELOPMENT object type value.

Change 53

Adds application object table, triggers, and indexes.

Change 52

Adds APPLICATION object type value.

Change 51

Updates shadow partition creation function to disable and re-enable only user triggers.

Change 50

Adds overall confidence column and index to role analysis outlier partitions.

Change 49

Adds role analysis detected pattern and outlier partition tables, columns, and indexes.

Change 48

Adds role analysis cluster detected pattern and outlier partition container type values.

Change 47

Adds last login timestamp column and index to shadows.

Change 46

Adds target object reference columns and indexes to role analysis outliers.

Change 45

Adds shadow enable/disable timestamp and disable reason columns.

Change 44

Renames shadow kind value from ASSOCIATED to ASSOCIATION.

Change 43

Adds shadow partition management functions, partition definition table, and triggers.

Change 42

Converts shadow storage to resource-partitioned shadow tables and recreates object view.

Change 41

Adds assignment effective mark reference table and target lookup index.

Change 40

Adds ASSIGNMENT_EFFECTIVE_MARK reference type value.

Change 39

Adds task affected object reference table, foreign key, and target lookup index.

Change 38

Adds TASK_AFFECTED_OBJECT reference type value.

Change 37

Adds shadow reference attribute table and owner OID index.

Change 36

Adds role analysis outlier table and triggers.

Change 35

Adds ROLE_ANALYSIS_OUTLIER object type value.

Change 34

Updates assignment metadata primary key and adds foreign key to assignments.

Change 33

Adds assignment metadata table and updates assignment approval reference keys.

Change 32

Adds ASSIGNMENT_METADATA container type value.

Change 31

Adds ASSOCIATED shadow kind value.

Change 30

Adds schema object table and triggers.

Change 29

Adds SCHEMA object type value.

Change 28

Adds policy object table, triggers, and indexes.

Change 27

Adds POLICY object type value.

Change 26

Adds separate full object storage to assignments, operation executions, and selected reference tables.

Change 25

Updates organization closure refresh procedure to use advisory locking.

Change 24

Adds connector display name columns.

Change 23

Adds role analysis cluster and role analysis session tables, triggers, and indexes.

Change 22

Adds ROLE_ANALYSIS_CLUSTER and ROLE_ANALYSIS_SESSION object type values.

Change 21

Adds personal number column to users.

Change 20

Adds execution mode and predefined configuration enum types and task affected object columns.

Change 19

Recreates task affected object indexing table.

Change 18

Adds resource super-reference columns.

Change 17

Keeps change number reserved for replaced task affected object indexing change.

Change 16

Adds AFFECTED_OBJECTS container type value for task affected object indexing.

Change 15

Adds queryable abstract flag to resources.

Change 14

Renames approval reference indexes to use consistent naming.

Change 13

Adds simulation result, processed object, mark, and effective mark tables, triggers, functions, and indexes.

Change 12

Adds simulation, mark, and related reference/container enum values.

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 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.

Change 1

Adds triggers that mark organization closure data for refresh after organization insert, delete, or truncate.