/
schema.yml
30 lines (29 loc) · 1.45 KB
/
schema.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
databaseChangeLog:
- changeSet:
id: 4.4.0
author: GraviteeSource Team
changes:
# ################
# Integration changes
# ################
- createTable:
tableName: ${gravitee_prefix}integrations
columns:
- column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: name, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: description, type: nvarchar(256), constraints: { nullable: true } }
- column: {name: provider, type: nvarchar(16), constraints: { nullable: false } }
- column: {name: environment_id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: created_at, type: timestamp(6), constraints: { nullable: false }, defaultValueComputed: CURRENT_TIMESTAMP(6) }
- column: {name: updated_at, type: timestamp(6), constraints: { nullable: false }, defaultValueComputed: CURRENT_TIMESTAMP(6) }
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}integrations
columnNames: id
tableName: ${gravitee_prefix}integrations
- createIndex:
indexName: idx_${gravitee_prefix}integrations_environment_id
columns:
- column:
name: environment_id
type: nvarchar(64)
tableName: ${gravitee_prefix}integrations