• Home
• io.gravitee.am.repository
• gravitee-am-repository-jdbc
• 4.5.5
• source code
• 4.5.0-scope-approval-external-user-id.yml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.changelogs.v4_5_0.4.5.0-scope-approval-external-user-id.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 4.5.0-scope-approval-external-user-id
      author: GraviteeSource Team
      validCheckSum: ANY
      preConditions:
        - onFail: MARK_RAN
      changes:
        - addColumn:
            tableName: scope_approvals
            columns:
              - column:
                  name: user_external_id
                  type: nvarchar(255)
              - column:
                  name: user_source
                  type: nvarchar(64)
        - createIndex:
            indexName: idx_scope_approvals_user_ext_id
            tableName: scope_approvals
            columns:
              - column:
                  name: user_source
              - column:
                  name: user_external_id

        - createIndex:
            columns:
              - column:
                  name: domain
              - column:
                  name: user_id
              - column:
                  name: user_source
              - column:
                  name: user_external_id
            indexName: idx_scope_approvals_domain_user_id_extid
            tableName: scope_approvals
            unique: false

        - createIndex:
            columns:
              - column:
                  name: domain
              - column:
                  name: client_id
              - column:
                  name: user_source
              - column:
                  name: user_external_id
              - column:
                  name: scope
            indexName: idx_scope_approvals_domain_client_user_id_extid_scope
            tableName: scope_approvals
            unique: false