• Home
• io.gravitee.am.repository
• gravitee-am-repository-jdbc
• 4.5.0-alpha.3
• source code
• 4.2.0-update-applications-table.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.v4_2_0.4.2.0-update-applications-table.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 4.2.0-update-applications-table
      author: GraviteeSource Team
      changes:
        - addColumn:
            tableName: applications
            columns:
              - column: { name: secret_settings, type: clob, constraints: { nullable: true } }

        - createTable:
            tableName: application_client_secrets
            columns:
              - column: { name: id, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: application_id, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: name, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: created_at, type: timestamp(6), constraints: { nullable: true } }
              - column: { name: settings_id, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: secret, type: nvarchar(374), constraints: { nullable: false } }


        - addPrimaryKey:
            constraintName: pk_application_client_secrets
            columnNames: id, application_id
            tableName: application_client_secrets

        -  addForeignKeyConstraint:
             baseColumnNames:  application_id
             baseTableName:  application_client_secrets
             constraintName:  fk_application_client_secrets_appid
             onDelete: CASCADE
             onUpdate: NO ACTION
             referencedColumnNames: id
             referencedTableName: applications