snapshot

The snapshot command captures the current state of the url database, which is the target database.

The snapshot command has two modes:

  • When run without options, it gathers the current state of the database and shows a text-based version of the schema to STDOUT.
  • When run with the --snapshot-format=json option, it creates a JSON file that represents the current state of the url database. Alternatively, you can have a YAML-based output by using the --snapshot-format=yaml attribute.

Uses

The snapshot command is typically used when you want to see changes in your target database or keep a record of your current database state.

You can use the output of snapshot with the diff and diff-changelog commands.

Note: It is best practice to use the --snapshot-format=json option for the diff and diff-changelog commands. Otherwise, you will get only a text report of your target database. This text report cannot be used for comparison in the future.

It can also be used to compare:

  • A previous database state to an online database.
  • A previous database state to another snapshot.

Note: Running a diff command by using at least one snapshot.json file is faster than using a diff command with two online databases. However, keep in mind that a snapshot will no longer reflect the current state of the database if the database is changed with the update command or if it is changed manually.

In Liquibase Pro 4.26.0 and later, you can use the --snapshot-filters parameter to limit the types of database objects you include in your snapshot. If your database is very large, including only the objects relevant to you in the snapshot can improve the command's performance.

Syntax

To run the snapshot command, specify your driver, classpath, and URL in the Liquibase properties file. For more information, see Create and Configure a liquibase.properties File. You can also specify these properties in your command line.

Then run the snapshot command:

liquibase snapshot

To create a JSON file, add the --snapshot-format=json attribute:

liquibase --output-file=mySnapshot.json snapshot --snapshot-format=json

To only include data types you specify, add the --snapshot-filters parameter:

liquibase snapshot --snapshot-filters=catalog,index,schema,table

Parameters

Global parameters

Attribute Definition Requirement

--output-file=<string>

File path to where the command output will be written. If not specified, output goes to STDOUT. See --output-file.

 Optional

Command parameters

Attribute Definition Requirement

--url=<string>

The JDBC database connection URL. See Using JDBC URL in Liquibase.

 Required

--default-catalog-name=<string>

Name of the default catalog to use for the database connection

 Optional

--default-schema-name=<string>

Name of the default schema to use for the database connection. If defaultSchemaName is set, then objects do not have to be fully qualified. This means you can refer to just mytable instead of myschema.mytable.

Tip: In Liquibase v4.23.0+, camelCase for defaultSchemaName works successfully. If you are on an earlier version, camelCase may not work as expected.

Note: The syntax liquibase.command.defaultSchemaName is valid for v4.19.0+. For prior versions, use defaultSchemaName.

 Optional

--driver=<string>

The JDBC driver class

 Optional

--driver-properties-file=<string>

The JDBC driver properties file

 Optional

--password=<string>

Password to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

--schemas=<string>

Specifies schemas to be able to compare a multi-schema database to its snapshot

 Optional

--snapshot-filters=<string>

Liquibase Pro 4.26.0+. Controls which types of objects Liquibase includes in the snapshot. Can improve command performance. Specify multiple values in a comma-separated list. Accepted values are: catalog, checkConstraint, column, databasePackage, databasePackageBody, foreignKey, function, index, primaryKey, schema, sequence, storedProcedure, synonym, table, trigger, uniqueConstraint, and view. Default: all types.

 Optional

--snapshot-format=<string>

Output format to use. Creates a file of the specified type that represents the current state of the database. Valid values: JSON, YAML, TXT. Default: TXT.

 Optional

--username=<string>

Username to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

Global parameters

Attribute Definition Requirement

globalArgs: { output-file: "<string>" }

File path to where the command output will be written. If not specified, output goes to STDOUT. See --output-file.

 Optional

Command parameters

Attribute Definition Requirement

cmdArgs: { url: "<string>" }

The JDBC database connection URL. See Using JDBC URL in Liquibase.

 Required

cmdArgs: { default-catalog-name: "<string>" }

Name of the default catalog to use for the database connection

 Optional

cmdArgs: { default-schema-name: "<string>" }

Name of the default schema to use for the database connection. If defaultSchemaName is set, then objects do not have to be fully qualified. This means you can refer to just mytable instead of myschema.mytable.

Tip: In Liquibase v4.23.0+, camelCase for defaultSchemaName works successfully. If you are on an earlier version, camelCase may not work as expected.

Note: The syntax liquibase.command.defaultSchemaName is valid for v4.19.0+. For prior versions, use defaultSchemaName.

 Optional

cmdArgs: { driver: "<string>" }

The JDBC driver class

 Optional

cmdArgs: { driver-properties-file: "<string>" }

The JDBC driver properties file

 Optional

cmdArgs: { password: "<string>" }

Password to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

cmdArgs: { schemas: "<string>" }

Specifies schemas to be able to compare a multi-schema database to its snapshot

 Optional

cmdArgs: { snapshot-filters: "<string>" }

Liquibase Pro 4.26.0+. Controls which types of objects Liquibase includes in the snapshot. Can improve command performance. Specify multiple values in a comma-separated list. Accepted values are: catalog, checkConstraint, column, databasePackage, databasePackageBody, foreignKey, function, index, primaryKey, schema, sequence, storedProcedure, synonym, table, trigger, uniqueConstraint, and view. Default: all types.

 Optional

cmdArgs: { snapshot-format: "<string>" }

Output format to use. Creates a file of the specified type that represents the current state of the database. Valid values: JSON, YAML, TXT. Default: TXT.

 Optional

cmdArgs: { username: "<string>" }

Username to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

Global parameters

Attribute Definition Requirement

liquibase.outputFile: <string>

File path to where the command output will be written. If not specified, output goes to STDOUT. See --output-file.

 Optional

Command parameters

Attribute Definition Requirement

liquibase.command.url: <string>

liquibase.command.snapshot.url: <string>

The JDBC database connection URL. See Using JDBC URL in Liquibase.

 Required

liquibase.command.defaultCatalogName: <string>

liquibase.command.snapshot.defaultCatalogName: <string>

Name of the default catalog to use for the database connection

 Optional

liquibase.command.defaultSchemaName: <string>

liquibase.command.snapshot.defaultSchemaName: <string>

Name of the default schema to use for the database connection. If defaultSchemaName is set, then objects do not have to be fully qualified. This means you can refer to just mytable instead of myschema.mytable.

Tip: In Liquibase v4.23.0+, camelCase for defaultSchemaName works successfully. If you are on an earlier version, camelCase may not work as expected.

Note: The syntax liquibase.command.defaultSchemaName is valid for v4.19.0+. For prior versions, use defaultSchemaName.

 Optional

liquibase.command.driver: <string>

liquibase.command.snapshot.driver: <string>

The JDBC driver class

 Optional

liquibase.command.driverPropertiesFile: <string>

liquibase.command.snapshot.driverPropertiesFile: <string>

The JDBC driver properties file

 Optional

liquibase.command.password: <string>

liquibase.command.snapshot.password: <string>

Password to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

liquibase.command.schemas: <string>

liquibase.command.snapshot.schemas: <string>

Specifies schemas to be able to compare a multi-schema database to its snapshot

 Optional

liquibase.command.snapshotFilters: <string>

liquibase.command.snapshot.snapshotFilters: <string>

Liquibase Pro 4.26.0+. Controls which types of objects Liquibase includes in the snapshot. Can improve command performance. Specify multiple values in a comma-separated list. Accepted values are: catalog, checkConstraint, column, databasePackage, databasePackageBody, foreignKey, function, index, primaryKey, schema, sequence, storedProcedure, synonym, table, trigger, uniqueConstraint, and view. Default: all types.

 Optional

liquibase.command.snapshotFormat: <string>

liquibase.command.snapshot.snapshotFormat: <string>

Output format to use. Creates a file of the specified type that represents the current state of the database. Valid values: JSON, YAML, TXT. Default: TXT.

 Optional

liquibase.command.username: <string>

liquibase.command.snapshot.username: <string>

Username to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

Global parameters

Attribute Definition Requirement

JAVA_OPTS=-Dliquibase.outputFile=<string>

File path to where the command output will be written. If not specified, output goes to STDOUT. See --output-file.

 Optional

Command parameters

Attribute Definition Requirement

JAVA_OPTS=-Dliquibase.command.url=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.url=<string>

The JDBC database connection URL. See Using JDBC URL in Liquibase.

 Required

JAVA_OPTS=-Dliquibase.command.defaultCatalogName=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.defaultCatalogName=<string>

Name of the default catalog to use for the database connection

 Optional

JAVA_OPTS=-Dliquibase.command.defaultSchemaName=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.defaultSchemaName=<string>

Name of the default schema to use for the database connection. If defaultSchemaName is set, then objects do not have to be fully qualified. This means you can refer to just mytable instead of myschema.mytable.

Tip: In Liquibase v4.23.0+, camelCase for defaultSchemaName works successfully. If you are on an earlier version, camelCase may not work as expected.

Note: The syntax liquibase.command.defaultSchemaName is valid for v4.19.0+. For prior versions, use defaultSchemaName.

 Optional

JAVA_OPTS=-Dliquibase.command.driver=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.driver=<string>

The JDBC driver class

 Optional

JAVA_OPTS=-Dliquibase.command.driverPropertiesFile=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.driverPropertiesFile=<string>

The JDBC driver properties file

 Optional

JAVA_OPTS=-Dliquibase.command.password=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.password=<string>

Password to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

JAVA_OPTS=-Dliquibase.command.schemas=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.schemas=<string>

Specifies schemas to be able to compare a multi-schema database to its snapshot

 Optional

JAVA_OPTS=-Dliquibase.command.snapshotFilters=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.snapshotFilters=<string>

Liquibase Pro 4.26.0+. Controls which types of objects Liquibase includes in the snapshot. Can improve command performance. Specify multiple values in a comma-separated list. Accepted values are: catalog, checkConstraint, column, databasePackage, databasePackageBody, foreignKey, function, index, primaryKey, schema, sequence, storedProcedure, synonym, table, trigger, uniqueConstraint, and view. Default: all types.

 Optional

JAVA_OPTS=-Dliquibase.command.snapshotFormat=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.snapshotFormat=<string>

Output format to use. Creates a file of the specified type that represents the current state of the database. Valid values: JSON, YAML, TXT. Default: TXT.

 Optional

JAVA_OPTS=-Dliquibase.command.username=<string>

JAVA_OPTS=-Dliquibase.command.snapshot.username=<string>

Username to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

Global parameters

Attribute Definition Requirement

LIQUIBASE_OUTPUT_FILE=<string>

File path to where the command output will be written. If not specified, output goes to STDOUT. See --output-file.

 Optional

Command parameters

Attribute Definition Requirement

LIQUIBASE_COMMAND_URL=<string>

LIQUIBASE_COMMAND_SNAPSHOT_URL=<string>

The JDBC database connection URL. See Using JDBC URL in Liquibase.

 Required

LIQUIBASE_COMMAND_DEFAULT_CATALOG_NAME=<string>

LIQUIBASE_COMMAND_SNAPSHOT_DEFAULT_CATALOG_NAME=<string>

Name of the default catalog to use for the database connection

 Optional

LIQUIBASE_COMMAND_DEFAULT_SCHEMA_NAME=<string>

LIQUIBASE_COMMAND_SNAPSHOT_DEFAULT_SCHEMA_NAME=<string>

Name of the default schema to use for the database connection. If defaultSchemaName is set, then objects do not have to be fully qualified. This means you can refer to just mytable instead of myschema.mytable.

Tip: In Liquibase v4.23.0+, camelCase for defaultSchemaName works successfully. If you are on an earlier version, camelCase may not work as expected.

Note: The syntax liquibase.command.defaultSchemaName is valid for v4.19.0+. For prior versions, use defaultSchemaName.

 Optional

LIQUIBASE_COMMAND_DRIVER=<string>

LIQUIBASE_COMMAND_SNAPSHOT_DRIVER=<string>

The JDBC driver class

 Optional

LIQUIBASE_COMMAND_DRIVER_PROPERTIES_FILE=<string>

LIQUIBASE_COMMAND_SNAPSHOT_DRIVER_PROPERTIES_FILE=<string>

The JDBC driver properties file

 Optional

LIQUIBASE_COMMAND_PASSWORD=<string>

LIQUIBASE_COMMAND_SNAPSHOT_PASSWORD=<string>

Password to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

LIQUIBASE_COMMAND_SCHEMAS=<string>

LIQUIBASE_COMMAND_SNAPSHOT_SCHEMAS=<string>

Specifies schemas to be able to compare a multi-schema database to its snapshot

 Optional

LIQUIBASE_COMMAND_SNAPSHOT_FILTERS=<string>

LIQUIBASE_COMMAND_SNAPSHOT_SNAPSHOT_FILTERS=<string>

Liquibase Pro 4.26.0+. Controls which types of objects Liquibase includes in the snapshot. Can improve command performance. Specify multiple values in a comma-separated list. Accepted values are: catalog, checkConstraint, column, databasePackage, databasePackageBody, foreignKey, function, index, primaryKey, schema, sequence, storedProcedure, synonym, table, trigger, uniqueConstraint, and view. Default: all types.

 Optional

LIQUIBASE_COMMAND_SNAPSHOT_FORMAT=<string>

LIQUIBASE_COMMAND_SNAPSHOT_SNAPSHOT_FORMAT=<string>

Output format to use. Creates a file of the specified type that represents the current state of the database. Valid values: JSON, YAML, TXT. Default: TXT.

 Optional

LIQUIBASE_COMMAND_USERNAME=<string>

LIQUIBASE_COMMAND_SNAPSHOT_USERNAME=<string>

Username to connect to the target database.

Tip: It is a best practice to store sensitive data in a Secrets Management tool with Liquibase Pro.

 Optional

Note: The username and password attributes are not required for connections and systems which use alternate means of authentication. Also, you can specify database credentials as part of the url attribute.

Using snapshot in the diff-changelog commands

You can use the JSON format snapshot file in the diff and diff-changelog commands. One of the typical workflows is the following:

  1. Make sure your local environment is up-to-date by getting the latest changelog from source control.
  2. Configure the Liquibase properties file to point to a local development database and run the update command to ensure your target database matches the changelog file.
  3. Take a snapshot of the local development database by running the snapshot command:
    4. liquibase --output-file=myschemaSnapshot.json snapshot --snapshot-format=json
  4. Manually change the local development database if needed.
  5. Append changes to the changelog by running the diff-changelog command:
    6. liquibase diff-changelog --reference-url=jdbc:oracle:thin://localhost:9090/mem:test --url="offline:oracle?snapshot=mySnapshot.json"

    Note: If you want to see changes without appending them to the changelog file, add --changelog-file=mydiffchangelog.xml to the diff-changelog command:

    liquibase diff-changelog --reference-url=jdbc:oracle:thin://localhost:9090/mem:test --url="offline:oracle?snapshot=mySnapshot.json" --changelog-file=mydiffchangelog.xml

    Note: The format for the URL is the following: "offline:<db_type>?snapshot=<path/to/snapshot.json>" (with quotes). Use the name of your database type from the list of the supported databases in place of <db_type> and the path relative to where the command is running in place of <path/to/snapshot.json>.

  6. Review the changelog file to ensure that it matches your expectations of the manual changes that were made.
  7. Mark the manual changes as deployed in the local development database by running the changelog-sync command:
    8. liquibase changelog-sync
  8. Commit the changes to the source control.

Liquibase Open Source snapshot categories:

  • Catalog
  • Column
  • Foreign Key
  • Index
  • Primary Key
  • Schema
  • Sequence
  • Unique Constraints
  • View

Liquibase Pro snapshot categories:

  • Package
  • Package Body
  • Procedures
  • Function
  • Trigger
  • Synonyms
  • Check Constraints

When running the snapshot command with the --snapshot-format attribute, the output can be as follows:

Liquibase Community 4.9.1 by Liquibase
Output saved to C:\Users\Amber Williams\Documents\Maven_h2\mySnapshot.json
Liquibase command 'snapshot' was executed successfully.

When running the snapshot command without indicating the --snapshot-format, you receive the following output:

Liquibase Community 4.9.1 by Liquibase
Database snapshot for jdbc:h2:tcp://localhost:9090/mem:dev
-----------------------------------------------------------------
Database type: H2
Database version: 2.1.210 (2022-01-17)
Database user: DBUSER
Included types:
liquibase.structure.core.Catalog
liquibase.structure.core.Column
liquibase.structure.core.ForeignKey
liquibase.structure.core.Index
liquibase.structure.core.PrimaryKey
liquibase.structure.core.Schema
liquibase.structure.core.Sequence
liquibase.structure.core.Table
liquibase.structure.core.UniqueConstraint
liquibase.structure.core.View
liquibase.structure.core.Index:
PRIMARY_KEY_6
columns:
ID
table: COMPANY
unique: true
PRIMARY_KEY_D
columns:
ID
table: DATABASECHANGELOGLOCK
unique: true
PRIMARY_KEY_C
columns:
ID
table: PERSON
unique: true

liquibase.structure.core.PrimaryKey:
CONSTRAINT_6
backingIndex: PRIMARY_KEY_6
columns:
ID
table: COMPANY
PK_DATABASECHANGELOGLOCK
backingIndex: PRIMARY_KEY_D
columns:
ID
table: DATABASECHANGELOGLOCK
CONSTRAINT_8
backingIndex: PRIMARY_KEY_C
columns:
ID
table: PERSON

liquibase.structure.core.Table:
COMPANY
columns:
ADDRESS1
nullable: true
order: 3
type: CHARACTER VARYING(50)
ADDRESS2
nullable: true
order: 4
type: CHARACTER VARYING(50)
CITY
nullable: true
order: 5
type: CHARACTER VARYING(30)
ID
autoIncrementInformation: GENERATED null AUTO INCREMENT START WITH 1 INCREMENT BY 1
nullable: false
order: 1
type: INTEGER
NAME
nullable: false
order: 2
type: CHARACTER VARYING(50)
default_tablespace: false
indexes:
PRIMARY_KEY_6
columns:
ID
unique: true
primaryKey: CONSTRAINT_6
backingIndex: PRIMARY_KEY_6
columns:
ID
DATABASECHANGELOG
columns:
AUTHOR
nullable: false
order: 2
type: CHARACTER VARYING(255)
COMMENTS
nullable: true
order: 9
type: CHARACTER VARYING(255)
CONTEXTS
nullable: true
order: 12
type: CHARACTER VARYING(255)
DATEEXECUTED
nullable: false
order: 4
type: TIMESTAMP
DEPLOYMENT_ID
nullable: true
order: 14
type: CHARACTER VARYING(10)
DESCRIPTION
nullable: true
order: 8
type: CHARACTER VARYING(255)
EXECTYPE
nullable: false
order: 6
type: CHARACTER VARYING(10)
FILENAME
nullable: false
order: 3
type: CHARACTER VARYING(255)
ID
nullable: false
order: 1
type: CHARACTER VARYING(255)
LABELS
nullable: true
order: 13
type: CHARACTER VARYING(255)
LIQUIBASE
nullable: true
order: 11
type: CHARACTER VARYING(20)
MD5SUM
nullable: true
order: 7
type: CHARACTER VARYING(35)
ORDEREXECUTED
nullable: false
order: 5
type: INTEGER
TAG
nullable: true
order: 10
type: CHARACTER VARYING(255)
default_tablespace: false
DATABASECHANGELOGLOCK
columns:
ID
nullable: false
order: 1
type: INTEGER
LOCKED
nullable: false
order: 2
type: BOOLEAN
LOCKEDBY
nullable: true
order: 4
type: CHARACTER VARYING(255)
LOCKGRANTED
nullable: true
order: 3
type: TIMESTAMP
default_tablespace: false
indexes:
PRIMARY_KEY_D
columns:
ID
unique: true
primaryKey: PK_DATABASECHANGELOGLOCK
backingIndex: PRIMARY_KEY_D
columns:
ID
PERSON
columns:
ADDRESS1
nullable: true
order: 3
type: CHARACTER VARYING(50)
ADDRESS2
nullable: true
order: 4
type: CHARACTER VARYING(50)
CITY
nullable: true
order: 5
type: CHARACTER VARYING(30)
COUNTRY
nullable: true
order: 6
type: CHARACTER VARYING(2)
ID
autoIncrementInformation: GENERATED null AUTO INCREMENT START WITH 1 INCREMENT BY 1
nullable: false
order: 1
type: INTEGER
NAME
nullable: false
order: 2
type: CHARACTER VARYING(50)
default_tablespace: false
indexes:
PRIMARY_KEY_C
columns:
ID
unique: true
primaryKey: CONSTRAINT_8
backingIndex: PRIMARY_KEY_C
columns:
ID

Liquibase command 'snapshot' was executed successfully.

The snapshot command produces a JSON file that contains all your objects and places the file in the same directory as your changelog.

{
	"snapshot": {
		"created": "2022-05-06T13:25:10.798",
		"database": {
			"productVersion": "2.1.210 (2022-01-17)",
			"shortName": "h2",
			"majorVersion": "2",
			"minorVersion": "1",
			"user": "DBUSER",
			"productName": "H2",
			"url": "jdbc:h2:tcp://localhost:9090/mem:dev"
		},
		"objects": {
			"liquibase.structure.core.Catalog": [
			{
				"catalog": {
					"default": true,
					"name": "DEV",
					"snapshotId": "e6cc100"
				}
			}],
			"liquibase.structure.core.Column": [
			{
				"column": {
					"name": "ADDRESS1",
					"nullable": true,
					"order": "3!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc133",
					"snapshotId": "e6cc137",
					"type": {
						"characterOctetLength": "50!{java.lang.Integer}",
						"columnSize": "50!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "ADDRESS1",
					"nullable": true,
					"order": "3!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc102",
					"snapshotId": "e6cc106",
					"type": {
						"characterOctetLength": "50!{java.lang.Integer}",
						"columnSize": "50!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "ADDRESS2",
					"nullable": true,
					"order": "4!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc133",
					"snapshotId": "e6cc138",
					"type": {
						"characterOctetLength": "50!{java.lang.Integer}",
						"columnSize": "50!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "ADDRESS2",
					"nullable": true,
					"order": "4!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc102",
					"snapshotId": "e6cc107",
					"type": {
						"characterOctetLength": "50!{java.lang.Integer}",
						"columnSize": "50!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "AUTHOR",
					"nullable": false,
					"order": "2!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc113",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "CITY",
					"nullable": true,
					"order": "5!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc133",
					"snapshotId": "e6cc139",
					"type": {
						"characterOctetLength": "30!{java.lang.Integer}",
						"columnSize": "30!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "CITY",
					"nullable": true,
					"order": "5!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc102",
					"snapshotId": "e6cc108",
					"type": {
						"characterOctetLength": "30!{java.lang.Integer}",
						"columnSize": "30!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "COMMENTS",
					"nullable": true,
					"order": "9!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc120",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "CONTEXTS",
					"nullable": true,
					"order": "12!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc123",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "COUNTRY",
					"nullable": true,
					"order": "6!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc102",
					"snapshotId": "e6cc109",
					"type": {
						"characterOctetLength": "2!{java.lang.Integer}",
						"columnSize": "2!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "DATEEXECUTED",
					"nullable": false,
					"order": "4!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc115",
					"type": {
						"characterOctetLength": "26!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "93!{java.lang.Integer}",
						"typeName": "TIMESTAMP"
					}
				}
			},
			{
				"column": {
					"name": "DEPLOYMENT_ID",
					"nullable": true,
					"order": "14!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc125",
					"type": {
						"characterOctetLength": "10!{java.lang.Integer}",
						"columnSize": "10!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "DESCRIPTION",
					"nullable": true,
					"order": "8!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc119",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "EXECTYPE",
					"nullable": false,
					"order": "6!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc117",
					"type": {
						"characterOctetLength": "10!{java.lang.Integer}",
						"columnSize": "10!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "FILENAME",
					"nullable": false,
					"order": "3!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc114",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"autoIncrementInformation": {
						"incrementBy": "1!{java.math.BigInteger}",
						"startWith": "1!{java.math.BigInteger}"
					},
					"name": "ID",
					"nullable": false,
					"order": "1!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc133",
					"snapshotId": "e6cc135",
					"type": {
						"characterOctetLength": "32!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "4!{java.lang.Integer}",
						"radix": "2!{java.lang.Integer}",
						"typeName": "INTEGER"
					}
				}
			},
			{
				"column": {
					"name": "ID",
					"nullable": false,
					"order": "1!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc112",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "ID",
					"nullable": false,
					"order": "1!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc126",
					"snapshotId": "e6cc128",
					"type": {
						"characterOctetLength": "32!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "4!{java.lang.Integer}",
						"radix": "2!{java.lang.Integer}",
						"typeName": "INTEGER"
					}
				}
			},
			{
				"column": {
					"autoIncrementInformation": {
						"incrementBy": "1!{java.math.BigInteger}",
						"startWith": "1!{java.math.BigInteger}"
					},
					"name": "ID",
					"nullable": false,
					"order": "1!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc102",
					"snapshotId": "e6cc104",
					"type": {
						"characterOctetLength": "32!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "4!{java.lang.Integer}",
						"radix": "2!{java.lang.Integer}",
						"typeName": "INTEGER"
					}
				}
			},
			{
				"column": {
					"name": "LABELS",
					"nullable": true,
					"order": "13!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc124",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "LIQUIBASE",
					"nullable": true,
					"order": "11!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc122",
					"type": {
						"characterOctetLength": "20!{java.lang.Integer}",
						"columnSize": "20!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "LOCKED",
					"nullable": false,
					"order": "2!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc126",
					"snapshotId": "e6cc129",
					"type": {
						"characterOctetLength": "1!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "16!{java.lang.Integer}",
						"typeName": "BOOLEAN"
					}
				}
			},
			{
				"column": {
					"name": "LOCKEDBY",
					"nullable": true,
					"order": "4!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc126",
					"snapshotId": "e6cc131",
					"type": {
						"characterOctetLength": "255!{java.lang.Integer}",
						"columnSize": "255!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "LOCKGRANTED",
					"nullable": true,
					"order": "3!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc126",
					"snapshotId": "e6cc130",
					"type": {
						"characterOctetLength": "26!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "93!{java.lang.Integer}",
						"typeName": "TIMESTAMP"
					}
				}
			},
			{
				"column": {
					"name": "MD5SUM",
					"nullable": true,
					"order": "7!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc118",
					"type": {
						"characterOctetLength": "35!{java.lang.Integer}",
						"columnSize": "35!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "NAME",
					"nullable": false,
					"order": "2!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc133",
					"snapshotId": "e6cc136",
					"type": {
						"characterOctetLength": "50!{java.lang.Integer}",
						"columnSize": "50!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "NAME",
					"nullable": false,
					"order": "2!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc102",
					"snapshotId": "e6cc105",
					"type": {
						"characterOctetLength": "50!{java.lang.Integer}",
						"columnSize": "50!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "12!{java.lang.Integer}",
						"typeName": "CHARACTER VARYING"
					}
				}
			},
			{
				"column": {
					"name": "ORDEREXECUTED",
					"nullable": false,
					"order": "5!{java.lang.Integer}",
					"relation": "liquibase.structure.core.Table#e6cc111",
					"snapshotId": "e6cc116",
					"type": {
						"characterOctetLength": "32!{java.lang.Integer}",
						"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
						"dataTypeId": "4!{java.lang.Integer}",
						"radix": "2!{java.lang.Integer}",
						"typeName": "INTEGER"
					}
				}
			},
			{
				"column": {
				"name": "TAG",
				"nullable": true,
				"order": "10!{java.lang.Integer}",
				"relation": "liquibase.structure.core.Table#e6cc111",
				"snapshotId": "e6cc121",
				"type": {
					"characterOctetLength": "255!{java.lang.Integer}",
					"columnSize": "255!{java.lang.Integer}",
					"columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
					"dataTypeId": "12!{java.lang.Integer}",
					"typeName": "CHARACTER VARYING"
				}
			}
		}],
		"liquibase.structure.core.Index": [
			{
				"index": {
					"columns": [
						"liquibase.structure.core.Column#e6cc135"
					],
					"name": "PRIMARY_KEY_6",
					"snapshotId": "e6cc134",
					"table": "liquibase.structure.core.Table#e6cc133",
					"unique": true
				}
			},
			{
				"index": {
					"columns": [
						"liquibase.structure.core.Column#e6cc104"
					],
					"name": "PRIMARY_KEY_C",
					"snapshotId": "e6cc103",
					"table": "liquibase.structure.core.Table#e6cc102",
					"unique": true
				}
			},
			{
				"index": {
					"columns": [
						"liquibase.structure.core.Column#e6cc128"
					],
					"name": "PRIMARY_KEY_D",
					"snapshotId": "e6cc127",
					"table": "liquibase.structure.core.Table#e6cc126",
					"unique": true
				}
			}
		],
		"liquibase.structure.core.PrimaryKey": [
			{
				"primaryKey": {
					"backingIndex": "liquibase.structure.core.Index#e6cc134",
					"columns": [
						"liquibase.structure.core.Column#e6cc135"
					],
					"name": "CONSTRAINT_6",
					"snapshotId": "e6cc140",
					"table": "liquibase.structure.core.Table#e6cc133"
				}
			},
			{
				"primaryKey": {
					"backingIndex": "liquibase.structure.core.Index#e6cc103",
					"columns": [
						"liquibase.structure.core.Column#e6cc104"
					],
					"name": "CONSTRAINT_8",
					"snapshotId": "e6cc110",
					"table": "liquibase.structure.core.Table#e6cc102"
				}
			},
			{
				"primaryKey": {
					"backingIndex": "liquibase.structure.core.Index#e6cc127",
					"columns": [
						"liquibase.structure.core.Column#e6cc128"
					],
					"name": "PK_DATABASECHANGELOGLOCK",
					"snapshotId": "e6cc132",
					"table": "liquibase.structure.core.Table#e6cc126"
				}
			}
		],
		"liquibase.structure.core.Schema": [
			{
			"schema": {
				"catalog": "liquibase.structure.core.Catalog#e6cc100",
				"default": true,
				"name": "PUBLIC",
				"snapshotId": "e6cc101"
			}
		}],
		"liquibase.structure.core.Table": [
			{
				"table": {
					"columns": [
						"liquibase.structure.core.Column#e6cc135",
						"liquibase.structure.core.Column#e6cc136",
						"liquibase.structure.core.Column#e6cc137",
						"liquibase.structure.core.Column#e6cc138",
						"liquibase.structure.core.Column#e6cc139"
					],
					"default_tablespace": false,
					"indexes": [
						"liquibase.structure.core.Index#e6cc134"
					],
					"name": "COMPANY",
					"primaryKey": "liquibase.structure.core.PrimaryKey#e6cc140",
					"schema": "liquibase.structure.core.Schema#e6cc101",
					"snapshotId": "e6cc133"
				}
			},
			{
				"table": {
					"columns": [
						"liquibase.structure.core.Column#e6cc112",
						"liquibase.structure.core.Column#e6cc113",
						"liquibase.structure.core.Column#e6cc114",
						"liquibase.structure.core.Column#e6cc115",
						"liquibase.structure.core.Column#e6cc116",
						"liquibase.structure.core.Column#e6cc117",
						"liquibase.structure.core.Column#e6cc118",
						"liquibase.structure.core.Column#e6cc119",
						"liquibase.structure.core.Column#e6cc120",
						"liquibase.structure.core.Column#e6cc121",
						"liquibase.structure.core.Column#e6cc122",
						"liquibase.structure.core.Column#e6cc123",
						"liquibase.structure.core.Column#e6cc124",
						"liquibase.structure.core.Column#e6cc125"
					],
					"default_tablespace": false,
					"name": "DATABASECHANGELOG",
					"schema": "liquibase.structure.core.Schema#e6cc101",
					"snapshotId": "e6cc111"
				}
			},
			{
				"table": {
					"columns": [
						"liquibase.structure.core.Column#e6cc128",
						"liquibase.structure.core.Column#e6cc129",
						"liquibase.structure.core.Column#e6cc130",
						"liquibase.structure.core.Column#e6cc131"
					],
					"default_tablespace": false,
					"indexes": [
						"liquibase.structure.core.Index#e6cc127"
					],
					"name": "DATABASECHANGELOGLOCK",
					"primaryKey": "liquibase.structure.core.PrimaryKey#e6cc132",
					"schema": "liquibase.structure.core.Schema#e6cc101",
					"snapshotId": "e6cc126"
				}
			},
			{
				"table": {
					"columns": [
						"liquibase.structure.core.Column#e6cc104",
						"liquibase.structure.core.Column#e6cc105",
						"liquibase.structure.core.Column#e6cc106",
						"liquibase.structure.core.Column#e6cc107",
						"liquibase.structure.core.Column#e6cc108",
						"liquibase.structure.core.Column#e6cc109"
					],
					"default_tablespace": false,
					"indexes": [
						"liquibase.structure.core.Index#e6cc103"
					],
					"name": "PERSON",
					"primaryKey": "liquibase.structure.core.PrimaryKey#e6cc110",
					"schema": "liquibase.structure.core.Schema#e6cc101",
					"snapshotId": "e6cc102"
				}
			}
		]},
		"snapshotControl": {
			"snapshotControl": {
				"includedType": [
					"liquibase.structure.core.Catalog",
					"liquibase.structure.core.Column",
					"liquibase.structure.core.ForeignKey",
					"liquibase.structure.core.Index",
					"liquibase.structure.core.PrimaryKey",
					"liquibase.structure.core.Schema",
					"liquibase.structure.core.Sequence",
					"liquibase.structure.core.Table",
					"liquibase.structure.core.UniqueConstraint",
					"liquibase.structure.core.View"
				]
			}
		}
	}
}

Related links