4 files changed, 29 insertions, 0 deletions
diff --git a/sqitch/deploy/git_branches.sql b/sqitch/deploy/git_branches.sql
new file mode 100644
index 0000000..4b926b5
--- /dev/null
+++ b/sqitch/deploy/git_branches.sql
@@ -0,0 +1,13 @@
+-- Deploy guix-data-service:git_branches to pg
+
+BEGIN;
+
+CREATE TABLE git_branches (
+    name character varying NOT NULL,
+    commit character varying,
+    git_repository_id integer NOT NULL,
+    datetime timestamp without time zone NOT NULL,
+    CONSTRAINT name_commit PRIMARY KEY(name, commit)
+);
+
+COMMIT;
diff --git a/sqitch/revert/git_branches.sql b/sqitch/revert/git_branches.sql
new file mode 100644
index 0000000..f04a167
--- /dev/null
+++ b/sqitch/revert/git_branches.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:git_branches from pg
+
+BEGIN;
+
+DROP TABLE git_branches;
+
+COMMIT;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index 97c152b..9e1c540 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -6,3 +6,4 @@ appschema 2019-04-13T11:43:59Z Christopher Baines <mail@cbaines.net> # Add schem
 buildstatus_enum [appschema] 2019-04-13T11:56:37Z Christopher Baines <mail@cbaines.net> # Creates the buildstatus enum
 initial_import 2019-04-13T13:06:28Z Christopher Baines <mail@cbaines.net> # Import the manually managed database schema
 git_repositories 2019-05-04T19:03:38Z Christopher Baines <mail@cbaines.net> # Add a git_repositories table
+git_branches 2019-05-05T14:53:12Z Christopher Baines <mail@cbaines.net> # Add a git_branches table
diff --git a/sqitch/verify/git_branches.sql b/sqitch/verify/git_branches.sql
new file mode 100644
index 0000000..2fec6f0
--- /dev/null
+++ b/sqitch/verify/git_branches.sql
@@ -0,0 +1,8 @@
+-- Verify guix-data-service:git_branches on pg
+
+BEGIN;
+
+SELECT name, commit, git_repository_id, datetime
+  FROM git_branches WHERE FALSE;
+
+ROLLBACK;