4 files changed, 60 insertions, 0 deletions
diff --git a/sqitch/deploy/lint_warnings.sql b/sqitch/deploy/lint_warnings.sql
new file mode 100644
index 0000000..1051b74
--- /dev/null
+++ b/sqitch/deploy/lint_warnings.sql
@@ -0,0 +1,41 @@
+-- Deploy guix-data-service:lint_warnings to pg
+
+BEGIN;
+
+CREATE TABLE lint_checkers (
+  id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
+  name varchar NOT NULL,
+  description varchar NOT NULL,
+  network_dependent boolean NOT NULL,
+  UNIQUE (name, description, network_dependent)
+);
+
+CREATE TABLE lint_warning_messages (
+  id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
+  locale varchar NOT NULL,
+  message varchar NOT NULL,
+  UNIQUE (locale, message)
+);
+
+CREATE TABLE lint_warning_message_sets (
+  id integer NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
+  message_ids integer[] NOT NULL,
+  UNIQUE (message_ids)
+);
+
+CREATE TABLE lint_warnings (
+  id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
+  lint_checker_id integer NOT NULL,
+  package_id integer NOT NULL REFERENCES packages (id),
+  location_id integer NOT NULL REFERENCES locations (id),
+  lint_warning_message_set_id integer NOT NULL REFERENCES lint_warning_message_sets (id),
+  UNIQUE (lint_checker_id, package_id, location_id, lint_warning_message_set_id)
+);
+
+CREATE TABLE guix_revision_lint_warnings (
+  lint_warning_id integer NOT NULL REFERENCES lint_warnings (id),
+  guix_revision_id integer NOT NULL REFERENCES guix_revisions (id),
+  PRIMARY KEY (lint_warning_id, guix_revision_id)
+);
+
+COMMIT;
diff --git a/sqitch/revert/lint_warnings.sql b/sqitch/revert/lint_warnings.sql
new file mode 100644
index 0000000..ea36d37
--- /dev/null
+++ b/sqitch/revert/lint_warnings.sql
@@ -0,0 +1,11 @@
+-- Revert guix-data-service:lint_warnings from pg
+
+BEGIN;
+
+DROP TABLE guix_revision_lint_warnings;
+DROP TABLE lint_warnings;
+DROP TABLE lint_warning_message_sets;
+DROP TABLE lint_warning_messages;
+DROP TABLE lint_checkers;
+
+COMMIT;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index 541074c..fb234ae 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -18,3 +18,4 @@ change_load_new_guix_revision_job_logs_contents_to_be_nullable 2019-07-07T20:10:
 fix_duplicated_licenses 2019-07-30T05:48:17Z Christopher Baines <mail@cbaines.net> # Fix duplicated licenses, and add constraints
 change_git_branches_primary_key 2019-08-05T18:57:41Z Christopher Baines <mail@cbaines.net> # Change the git_branches primary key to include the git_repository_id,\nas this will allow having the same branch in different repositories.
 remove_duplicate_load_new_guix_revision_jobs 2019-08-05T19:06:36Z Christopher Baines <mail@cbaines.net> # Remove duplicate load_new_guix_revision_jobs
+lint_warnings 2019-08-18T17:10:12Z Christopher Baines <mail@cbaines.net> # Store lint warnings
diff --git a/sqitch/verify/lint_warnings.sql b/sqitch/verify/lint_warnings.sql
new file mode 100644
index 0000000..5af9a76
--- /dev/null
+++ b/sqitch/verify/lint_warnings.sql
@@ -0,0 +1,7 @@
+-- Verify guix-data-service:lint_warnings on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;