• 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_19_0.schema.yml Maven / Gradle / Ivy

databaseChangeLog:
    - changeSet:
        id: 1.19.0
        author: GraviteeSource Team
        changes:
        - createTable:
            tableName: group_roles
            columns:
                - column: {name: group_id, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: role_scope, type: int, constraints: { nullable: false } }
                - column: {name: role_name, type: nvarchar(64), constraints: { nullable: false } }

        - addPrimaryKey:
            constraintName: pk_group_roles
            columnNames: group_id, role_scope
            tableName: group_roles

        - createTable:
            tableName: dictionaries
            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: type, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: state, 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 } }
                - column: {name: deployed_at, type: timestamp(6), constraints: { nullable: true } }
                - column: {name: provider_type, type: nvarchar(64), constraints: { nullable: true } }
                - column: {name: provider_configuration, type: nvarchar(1000), constraints: { nullable: true } }
                - column: {name: trigger_rate, type: int, constraints: { nullable: true } }
                - column: {name: trigger_unit, type: nvarchar(64), constraints: { nullable: true } }

        - addPrimaryKey:
            constraintName: pk_dictionaries
            columnNames: id
            tableName: dictionaries

        - createTable:
            tableName: dictionary_property
            columns:
                - column: {name: dictionary_id, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: k, type: nvarchar(64), constraints: { nullable: false } }
                - column: {name: v, type: nvarchar(1000), constraints: { nullable: false } }

        - addPrimaryKey:
            constraintName: pk_dictionary_property
            columnNames: dictionary_id, k
            tableName: dictionary_property