[midPoint-git] [Evolveum/midpoint] 44d97d: MID-7074: Added m_connector unique indexes to lega...

[Tony Tkáčik]

  Branch: refs/heads/master
  Home:   https://github.com/Evolveum/midpoint
  Commit: 44d97d48626655da06dd7e39571cce8e67dd2bbc
      https://github.com/Evolveum/midpoint/commit/44d97d48626655da06dd7e39571cce8e67dd2bbc
  Author: Tony Tkacik <tonydamage at gmail.com>
  Date:   2021-10-07 (Thu, 07 Oct 2021)

  Changed paths:
    M config/sql/generic-old/oracle-4.4-all.sql
    M config/sql/generic-old/oracle-upgrade-4.0-4.4.sql
    M config/sql/generic-old/oracle-upgrade-4.3-4.4.sql
    M config/sql/generic-old/postgresql-4.4-all.sql
    M config/sql/generic-old/postgresql-upgrade-4.0-4.4.sql
    M config/sql/generic-old/postgresql-upgrade-4.3-4.4.sql
    M config/sql/generic-old/sqlserver-4.4-all.sql
    M config/sql/generic-old/sqlserver-upgrade-4.0-4.4.sql
    M config/sql/generic-old/sqlserver-upgrade-4.3-4.4.sql

  Log Message:
  -----------
  MID-7074: Added m_connector unique indexes to legacy repo sql scripts

Added connectortype, version, host unique indexes to postgresql, sqlserver
and oracle. Note that indexes has different definition for each database
based on database behaviour for unique indexes with null values allowed.

PostgreSql: One index for host is null, one index for where host is not null.
Oracle: host null value is mapped to 0
SQLServer: one index, sql server treats multiple nulls as same value.