From 83884ed2ea4369d88b5a323333a6c78dbc471d24 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Tue, 13 Oct 2020 19:31:43 +0100
Subject: Add a latest_build_status table

This will avoid many queries trying to figure out what the latest build status
is, which will hopefuly simplify queries as well as improving performance.
---
 sqitch/verify/create_latest_build_status.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sqitch/verify/create_latest_build_status.sql

(limited to 'sqitch/verify')

diff --git a/sqitch/verify/create_latest_build_status.sql b/sqitch/verify/create_latest_build_status.sql
new file mode 100644
index 0000000..a272972
--- /dev/null
+++ b/sqitch/verify/create_latest_build_status.sql
@@ -0,0 +1,7 @@
+-- Verify guix-data-service:create_latest_build_status on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
-- 
cgit v1.2.3