diff options
| author | Christopher Baines <mail@cbaines.net> | 2019-09-26 23:45:07 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2019-09-27 17:28:46 +0100 |
| commit | 43bc7cab917a09698ee75687ada31b74cf732baf (patch) | |
| tree | 3a2c9edff1848c52e697f07433a809b76cf5aaf8 /sqitch/revert | |
| parent | 465f262deddb30f542cd02407948f1fef9d68991 (diff) | |
| download | data-service-43bc7cab917a09698ee75687ada31b74cf732baf.tar data-service-43bc7cab917a09698ee75687ada31b74cf732baf.tar.gz | |
Add a new table to store package versions by revision ranges
This isn't new information, but derived from information already in the
database. It's collected here to make querying faster.
The table is updated when each new revision is entered.
Diffstat (limited to 'sqitch/revert')
| -rw-r--r-- | sqitch/revert/package_versions_by_guix_revision_range.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/revert/package_versions_by_guix_revision_range.sql b/sqitch/revert/package_versions_by_guix_revision_range.sql new file mode 100644 index 0000000..5e270d2 --- /dev/null +++ b/sqitch/revert/package_versions_by_guix_revision_range.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:package_versions_by_guix_revision_range from pg + +BEGIN; + +DROP TABLE package_versions_by_guix_revision_range; + +COMMIT; |