Skip to content

Instantly share code, notes, and snippets.

@alexanderfefelov
Created February 1, 2014 22:44
Show Gist options
  • Save alexanderfefelov/8760150 to your computer and use it in GitHub Desktop.
Save alexanderfefelov/8760150 to your computer and use it in GitHub Desktop.
Liquibase 3.1.1
CREATE TABLE PUBLIC.DATABASECHANGELOG (
ID VARCHAR(255) NOT NULL,
AUTHOR VARCHAR(255) NOT NULL,
FILENAME VARCHAR(255) NOT NULL,
DATEEXECUTED TIMESTAMP NOT NULL,
ORDEREXECUTED INTEGER NOT NULL,
EXECTYPE VARCHAR(10) NOT NULL,
MD5SUM VARCHAR(35),
DESCRIPTION VARCHAR(255),
COMMENTS VARCHAR(255),
TAG VARCHAR(255),
LIQUIBASE VARCHAR(20)
);
CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (
ID INTEGER NOT NULL,
LOCKED BOOLEAN NOT NULL,
LOCKGRANTED TIMESTAMP,
LOCKEDBY VARCHAR(255),
CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)
);
CREATE INDEX PRIMARY_KEY_D ON PUBLIC.DATABASECHANGELOGLOCK (ID);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment