• Home
• io.gravitee.apim.repository
• gravitee-apim-repository-jdbc
• 4.5.5
• source code
• schema-dashboards.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_0_20.schema-dashboards.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 4.0.20-dashboards-check-column-exists
      author: GraviteeSource Team
      runOnChange: true
      preConditions:
       onFail: MARK_RAN
       not:
         columnExists:
           tableName: ${gravitee_prefix}dashboards
           columnName: type
      changes:
        # ################
        # Dashboards changes
        # ################
        - addColumn:
            tableName: ${gravitee_prefix}dashboards
            columns:
              - column:
                  name: type
                  type: nvarchar(64)
        - sql:
            sql: update ${gravitee_prefix}dashboards set type = reference_type
        - addNotNullConstraint:
            tableName: ${gravitee_prefix}dashboards
            columnName: type
            columnDataType: nvarchar(64)
            defaultNullValue: PLATFORM
        - sql:
            sql: update ${gravitee_prefix}dashboards set reference_type = 'ENVIRONMENT'