mallard 0.6.0.3 → 0.6.0.4

raw patch · 3 files changed

+25/−1 lines, 3 files

Files

mallard.cabal +2/−1
sql/mallard/0000-setup.sql +10/−0
sql/mallard/0001-applied-migrations.sql +13/−0

mallard.cabal view

@@ -1,5 +1,5 @@ name:               mallard-version:            0.6.0.3+version:            0.6.0.4 synopsis:           Database migration and testing as a library. description:        Please see README.md homepage:           https://github.com/AndrewRademacher/mallard@@ -14,6 +14,7 @@  extra-source-files:     README.md+    sql/mallard/*.sql  library     hs-source-dirs:    lib

+ sql/mallard/0000-setup.sql view

@@ -0,0 +1,10 @@+CREATE SCHEMA mallard;++SET search_path TO mallard;++CREATE TABLE migrator_version(+	version 		bigint   			NOT NULL,+	applied_on		timestamptz 		NOT NULL DEFAULT now(),+	+	PRIMARY KEY (version)+);

+ sql/mallard/0001-applied-migrations.sql view

@@ -0,0 +1,13 @@+SET search_path TO mallard;++CREATE TABLE applied_migrations(+    id              bigserial       NOT NULL,+    name            text            NOT NULL,+    description     text            NOT NULL,+    requires        text[]          NOT NULL,+    checksum        bytea           NOT NULL,+    script_text     text            NOT NULL,+    applied_on      timestamptz     NOT NULL DEFAULT now(),++    PRIMARY KEY (id)+);