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

databaseChangeLog:
    - changeSet:
        id: 1.18.0-pageconfiguration-mssql
        author: GraviteeSource Team
        preConditions:
            onFail: MARK_RAN
            dbms:
               type: mssql
        changes:
        - addColumn:
            tableName: ${gravitee_prefix}pages
            columns:
                - column: {name: parent_id, type: nvarchar(64), constraints: { nullable: true } }
        - createTable:
            tableName: ${gravitee_prefix}page_configuration
            columns:
                - column: {name: page_id, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: k, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: v, type: nvarchar(200), constraints: { nullable: false } }

        - addPrimaryKey:
            constraintName: pk_${gravitee_prefix}page_configuration
            columnNames: page_id, k, v
            tableName: ${gravitee_prefix}page_configuration

        - dropColumn:
            columnName: configuration_try_it_url
            tableName: ${gravitee_prefix}pages
        - dropColumn:
            columnName: configuration_try_it
            tableName: ${gravitee_prefix}pages