liquibase.changelogs.v1_23_0.schema.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.23.0
        author: GraviteeSource Team
        changes:
        - createTable:
              tableName: page_metadata
              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_metadata
              columnNames: page_id, k, v
              tableName: page_metadata

        - addColumn:
              tableName: views
              columns:
                  - column:
                      name: picture
                      type: nclob

        - addColumn:
            tableName: groups
            columns:
              - column:
                  name: max_invitation
                  type: int
              - column:
                  name: lock_api_role
                  type: boolean
              - column:
                  name: lock_application_role
                  type: boolean
              - column:
                  name: system_invitation
                  type: boolean
              - column:
                  name: email_invitation
                  type: boolean

        - createTable:
            tableName: invitations
            columns:
              - column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: reference_type, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: reference_id, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: email, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: api_role, type: nvarchar(64), constraints: { nullable: true } }
              - column: {name: application_role, 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_invitations
            columnNames: id
            tableName: invitations

        - dropNotNullConstraint:
            columnDataType: nvarchar(64)
            columnName: name
            tableName: pages

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