aboutsummaryrefslogtreecommitdiff
path: root/sqitch/revert
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-10-13 19:31:43 +0100
committerChristopher Baines <mail@cbaines.net>2020-10-13 19:31:43 +0100
commit83884ed2ea4369d88b5a323333a6c78dbc471d24 (patch)
tree4a085a97b263cb3bb7bab44c31f3901a2bdbaecf /sqitch/revert
parent941d1af55659eeadf4155b29176e510fd740bc4d (diff)
downloaddata-service-83884ed2ea4369d88b5a323333a6c78dbc471d24.tar
data-service-83884ed2ea4369d88b5a323333a6c78dbc471d24.tar.gz
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.
Diffstat (limited to 'sqitch/revert')
-rw-r--r--sqitch/revert/create_latest_build_status.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/revert/create_latest_build_status.sql b/sqitch/revert/create_latest_build_status.sql
new file mode 100644
index 0000000..1afce28
--- /dev/null
+++ b/sqitch/revert/create_latest_build_status.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:create_latest_build_status from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;