diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-10-13 19:31:43 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-10-13 19:31:43 +0100 |
| commit | 83884ed2ea4369d88b5a323333a6c78dbc471d24 (patch) | |
| tree | 4a085a97b263cb3bb7bab44c31f3901a2bdbaecf /sqitch/verify | |
| parent | 941d1af55659eeadf4155b29176e510fd740bc4d (diff) | |
| download | data-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/verify')
| -rw-r--r-- | sqitch/verify/create_latest_build_status.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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; |