• Home
• io.gravitee.am.repository
• gravitee-am-repository-jdbc
• 4.2.21
• source code
• schema-app-scope-settings.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.v3_12_0.schema-app-scope-settings.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 3.12.0-AppScopeSettings-Table
      author: GraviteeSource Team
      changes:

        ## scopes
        ###################
        - createTable:
            tableName: application_scope_settings
            columns:
              - column: { name: application_id, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: scope, type: nvarchar(255), constraints: { nullable: false } }
              - column: { name: is_default, type: boolean, constraints: { nullable: false }, defaultValueBoolean: false }
              - column: { name: scope_approval, type: integer, constraints: { nullable: true } }

        - createIndex:
            columns:
              - column:
                  name: application_id
            indexName: idx_ass_app_id
            tableName: application_scope_settings
            unique: false

        # Scopes
        ##############
        - addColumn:
            tableName: scopes
            columns:
              - column: { name: parameterized, type: boolean, constraints: { nullable: false }, defaultValueBoolean: false }