...
| Code Block |
|---|
| language | yml |
|---|
| title | Anchor Table Example |
|---|
| collapse | true |
|---|
|
databaseChangeLog:
- changeSet:
id: 1-1
author: cps
changes:
- createTable:
columns:
- column:
autoIncrement: true
constraints:
nullable: false
primaryKey: true
primaryKeyName: anchor_pkey
name: id
type: BIGINT
- column:
name: name
type: TEXT
- column:
name: schema_set_id
type: INTEGER
- column:
constraints:
nullable: false
name: dataspace_id
type: INTEGER
tableName: anchor |
...
To add a new table, under the latest change-set add a new change-set, incrementing the ID by one.
| Code Block |
|---|
| language | yml | title | Anchor Table Example |
|---|
| collapse | true |
|---|
|
- changeSet:
id: 1-38
author: cps |
...
| Code Block |
|---|
| language | yml |
|---|
| title | Anchor Test Table Example |
|---|
| collapse | true |
|---|
|
- changeSet:
id: 1-38
author: cps
changes:
- createTable:
columns:
- column:
autoIncrement: true
constraints:
nullable: false
primaryKey: true
primaryKeyName: test_table_pkey
name: id
type: INTEGER
- column:
constraints:
nullable: false
name: column_1
type: TEXT
tableName: test_table |
...
