Liquibase uses the DATABASECHANGELOG table to track which changesets have been run.
The table tracks each changeset as a row, identified by a combination of the “id”, “author”, and “filename” columns.
There is no primary key on the table. This is to avoid any database-specific restrictions on key lengths. The composite of “id”, “author”, and “filename” is unique across all rows of the table.
|Column||Standard Data Type||Description|
|ID||VARCHAR(255)||Value from the changeset "id" attribute.|
|AUTHOR||VARCHAR(255)||Value from the changeset "author" attribute.|
|FILENAME||VARCHAR(255)||Path to the changelog. This may be an absolute path or a relative path depending on how the changelog was passed to Liquibase. For best results, it should be a relative path. The `logicalFilePath` attribute can be used [on the changelog](/documentation/databasechangelog.html) or [on individual changesets](/documentation/changeset.html).|
|DATEEXECUTED||DATETIME||Date/time of when the changeset was executed. Used with ORDEREXECUTED to determine rollback order.|
|ORDEREXECUTED||INT||Order that the changesets were executed. Used in addition to DATEEXECUTED to ensure order is correct even when the databases datetime supports poor resolution.
NOTE: The values are only guaranteed to be increasing within an individual update run. There are times where they will restart at zero.
|EXECTYPE||VARCHAR(10)||Description of how the changeset was executed. Possible values include "EXECUTED", "FAILED", "SKIPPED", "RERAN", and "MARK_RAN".|
|MD5SUM||VARCHAR(35)||Checksum of the changeset when it was executed. Used on each run to ensure there have been no unexpected changes to changesets in the changelog file.|
|DESCRIPTION||VARCHAR(255)||Short auto-generated human readable description of changeset|
|COMMENTS||VARCHAR(255)||Value from the changeset "comment" attribute|
|TAG||VARCHAR(255)||Tracks which changeset correspond to tag operations.|
|LIQUIBASE||VARCHAR(20)||Version of Liquibase used to execute the changeset.|
|CONTEXTS||VARCHAR(255)||Context(s) used to execute the changeset.|
|LABELS||VARCHAR(255)||Label(s) used to execute the changeset.|
|DEPLOYMENT_ID||VARCHAR(10)||changesets deployed together will have the same unique identifier.|