All Downloads are FREE. Search and download functionalities are using the official Maven repository.

liquibase.changelogs.v3_11_0.schema-par.yml Maven / Gradle / Ivy

There is a newer version: 4.6.0-alpha.2
Show newest version
databaseChangeLog:
  - changeSet:
      id: 3.11.0-PAR-Table
      author: GraviteeSource Team
      changes:

        ## pushed_authorization_requests
        ###################
        - createTable:
            tableName: pushed_authorization_requests
            columns:
              - column: { name: id, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: domain, type: nvarchar(255), constraints: { nullable: false } }
              - column: { name: client, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: parameters, type: clob, constraints: { nullable: false } }
              - column: { name: created_at, type: timestamp(6), constraints: { nullable: true } }
              - column: { name: expire_at, type: timestamp(6), constraints: { nullable: true } }

        - addPrimaryKey:
            constraintName: pk_par
            columnNames: id
            tableName: pushed_authorization_requests

        - createIndex:
            columns:
              - column:
                  name: expire_at
            indexName: idx_par_expire
            tableName: pushed_authorization_requests
            unique: false




© 2015 - 2024 Weber Informatics LLC | Privacy Policy