From 91a9ba43498ffcd6149854eaa6b071d8b16e4cf3 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Sun, 1 Sep 2019 13:35:23 +0100
Subject: Add a new table guix_revision_lint_checkers

To associate a set of lint checkers with a specific revision. While there is
the association through the lint warnings, that only works for checkers where
there are lint warnings for that revision.

Therefore, to allow finding all the checkers for a specific revision, also
associate them directly with the revision.
---
 sqitch/deploy/guix_revision_lint_checkers.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 sqitch/deploy/guix_revision_lint_checkers.sql

(limited to 'sqitch/deploy/guix_revision_lint_checkers.sql')

diff --git a/sqitch/deploy/guix_revision_lint_checkers.sql b/sqitch/deploy/guix_revision_lint_checkers.sql
new file mode 100644
index 0000000..21c5a79
--- /dev/null
+++ b/sqitch/deploy/guix_revision_lint_checkers.sql
@@ -0,0 +1,11 @@
+-- Deploy guix-data-service:guix_revision_lint_checkers to pg
+
+BEGIN;
+
+CREATE TABLE guix_revision_lint_checkers (
+  lint_checker_id integer NOT NULL REFERENCES lint_checkers (id),
+  guix_revision_id integer NOT NULL REFERENCES guix_revisions (id),
+  PRIMARY KEY (lint_checker_id, guix_revision_id)
+);
+
+COMMIT;
-- 
cgit v1.2.3

