• Home
• io.gravitee.repository
• gravitee-repository-jdbc
• 3.5.0
• source code
• schema.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_21_0.schema.yml Maven / Gradle / Ivy

databaseChangeLog:
    - changeSet:
        id: 1.21.0
        author: GraviteeSource Team
        changes:
        - dropColumn:
            tableName: users
            columnName: username

        - addColumn:
            tableName: plans
            columns:
                - column:
                    name: comment_required
                    type: boolean

        - addColumn:
            tableName: generic_notification_configs
            columns:
                - column:
                    name: use_system_proxy
                    type: boolean

        - modifyDataType:
            tableName: pages
            columnName: source_configuration
            newDataType: nvarchar(256)

        - createTable:
            tableName: identity_providers
            columns:
                - column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: name, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: description, type: nvarchar(4000), constraints: { nullable: true } }
                - column: {name: enabled, type: boolean, constraints: { nullable: false } }
                - column: {name: type, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: created_at, type: timestamp(6), constraints: { nullable: false } }
                - column: {name: updated_at, type: timestamp(6), constraints: { nullable: true } }
                - column: {name: configuration, type: nvarchar(4000), constraints: { nullable: true } }
                - column: {name: group_mappings, type: nvarchar(4000), constraints: { nullable: true } }
                - column: {name: role_mappings, type: nvarchar(4000), constraints: { nullable: true } }
                - column: {name: user_profile_mapping, type: nvarchar(4000), constraints: { nullable: true } }

        - addPrimaryKey:
            constraintName: pk_identity_providers
            columnNames: id
            tableName: identity_providers

        - createTable:
            tableName: alerts
            columns:
                - column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: name, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: description, type: nvarchar(256), constraints: { nullable: true } }
                - column: {name: reference_type, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: reference_id, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: type, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: enabled, type: boolean, constraints: { nullable: false } }
                - column: {name: metric_type, type: nvarchar(64), constraints: { nullable: true } }
                - column: {name: metric, type: nvarchar(64), constraints: { nullable: true } }
                - column: {name: threshold_type, type: nvarchar(64), constraints: { nullable: true } }
                - column: {name: threshold, type: double, constraints: { nullable: true } }
                - column: {name: plan, type: nvarchar(64), constraints: { nullable: true } }
                - column: {name: created_at, type: timestamp(6), constraints: { nullable: false } }
                - column: {name: updated_at, type: timestamp(6), constraints: { nullable: true } }

        - addPrimaryKey:
            constraintName: pk_alerts
            columnNames: id
            tableName: alerts