liquibase.changelogs.v3_15_0.schema-ciba-auth-req.yml Maven / Gradle / Ivy
databaseChangeLog:
- changeSet:
id: 3.15.0-ciba-auth-req
author: GraviteeSource Team
changes:
## ciba_auth_req
###################
- createTable:
tableName: ciba_auth_requests
columns:
- column: { name: id, type: nvarchar(64), constraints: { nullable: false } }
- column: { name: client, type: nvarchar(64), constraints: { nullable: false } }
- column: { name: subject, type: nvarchar(320), constraints: { nullable: false } }
- column: { name: status, type: nvarchar(32), constraints: { nullable: false } }
- column: { name: created_at, type: timestamp(6), constraints: { nullable: false } }
- column: { name: last_access_at, type: timestamp(6), constraints: { nullable: false } }
- column: { name: expire_at, type: timestamp(6), constraints: { nullable: false } }
- column: { name: device_notifier_id, type: nvarchar(64), constraints: { nullable: true } }
- column: { name: scopes, type: clob, constraints: { nullable: true } }
- column: { name: external_information, type: clob, constraints: { nullable: true } }
- column: { name: ext_transaction_id, type: nvarchar(128), constraints: { nullable: true } }
- addPrimaryKey:
constraintName: pk_ciba_auth_requests
columnNames: id
tableName: ciba_auth_requests