liquibase.changelogs.v1_18_0.schema-pages.yml Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of gravitee-repository-jdbc Show documentation

There is a newer version: 3.9.2

Show newest version

databaseChangeLog:
    - changeSet:
        id: 1.18.0-pageconfiguration
        author: GraviteeSource Team
        preConditions:
            onFail: MARK_RAN
            not:
                dbms:
                  type: mssql
        changes:
        - addColumn:
            tableName: pages
            columns:
                - column: {name: parent_id, type: nvarchar(64), constraints: { nullable: true } }
        - createTable:
            tableName: 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_page_configuration
            columnNames: page_id, k, v
            tableName: page_configuration

        - sql:
            comment: Move tryIt to a the dedicated table
            sql: >
              insert into page_configuration (page_id, k, v)
              select id, 'tryIt', configuration_try_it
              from pages
              where configuration_try_it is true

        - sql:
            comment: Move tryItURL to a the dedicated table
            sql: >
              insert into page_configuration (page_id, k, v)
              select id, 'tryItURL', configuration_try_it_url
              from pages
              where configuration_try_it_url is not null

        - dropColumn:
            columnName: configuration_try_it_url
            tableName: pages
        - dropColumn:
            columnName: configuration_try_it
            tableName: pages