110_create_flyway_schema_history_table.sql

-- Table: webapi.flyway_schema_history

-- DROP TABLE webapi.flyway_schema_history;

CREATE TABLE webapi.flyway_schema_history
(
  installed_rank integer NOT NULL,
  version character varying(50),
  description character varying(200) NOT NULL,
  type character varying(20) NOT NULL,
  script character varying(1000) NOT NULL,
  checksum integer,
  installed_by character varying(100) NOT NULL,
  installed_on timestamp without time zone NOT NULL DEFAULT now(),
  execution_time integer NOT NULL,
  success boolean NOT NULL,
  CONSTRAINT flyway_schema_history_pk PRIMARY KEY (installed_rank)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE webapi.flyway_schema_history
  OWNER TO postgres;

-- Index: webapi.flyway_schema_history_s_idx

-- DROP INDEX webapi.flyway_schema_history_s_idx;

CREATE INDEX flyway_schema_history_s_idx
  ON webapi.flyway_schema_history
  USING btree
  (success);