1 files changed, 13 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;