aboutsummaryrefslogtreecommitdiff
path: root/sqitch
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-03-24 20:44:57 +0000
committerChristopher Baines <mail@cbaines.net>2020-03-24 20:44:57 +0000
commitca0d3ee7543b64eca32422a8e29f5f853923750f (patch)
tree94f60c514b3f205cd859adc649f53525cf19cd45 /sqitch
parent102f7a0536b76f60c06aa42ef1677ca76a4b18a7 (diff)
downloaddata-service-ca0d3ee7543b64eca32422a8e29f5f853923750f.tar
data-service-ca0d3ee7543b64eca32422a8e29f5f853923750f.tar.gz
Stop using package_versions_by_guix_revision_range
It's been replaced by the package_derivations_by_guix_revision_range table.
Diffstat (limited to 'sqitch')
-rw-r--r--sqitch/deploy/drop_package_versions_by_guix_revision_range.sql7
-rw-r--r--sqitch/revert/drop_package_versions_by_guix_revision_range.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/verify/drop_package_versions_by_guix_revision_range.sql7
4 files changed, 22 insertions, 0 deletions
diff --git a/sqitch/deploy/drop_package_versions_by_guix_revision_range.sql b/sqitch/deploy/drop_package_versions_by_guix_revision_range.sql
new file mode 100644
index 0000000..f954349
--- /dev/null
+++ b/sqitch/deploy/drop_package_versions_by_guix_revision_range.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-data-service:drop_package_versions_by_guix_revision_range to pg
+
+BEGIN;
+
+DROP TABLE package_versions_by_guix_revision_range;
+
+COMMIT;
diff --git a/sqitch/revert/drop_package_versions_by_guix_revision_range.sql b/sqitch/revert/drop_package_versions_by_guix_revision_range.sql
new file mode 100644
index 0000000..31a0169
--- /dev/null
+++ b/sqitch/revert/drop_package_versions_by_guix_revision_range.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:drop_package_versions_by_guix_revision_range from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index 975d7ee..d770077 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -53,3 +53,4 @@ channel_instance_derivations 2020-02-10T07:59:03Z Christopher Baines <mail@cbain
update_build_servers_build_config 2020-02-13T20:07:19Z Christopher Baines <mail@cbaines.net> # Update build_servers_build_config values
make_some_constraints_deferrable 2020-02-16T10:54:22Z Christopher Baines <mail@cbaines.net> # Make some constraints deferrable
guix_revision_system_test_derivations_add_system 2020-03-19T21:30:33Z Christopher Baines <mail@cbaines.net> # Add a system column to the guix_revision_system_test_derivations table
+drop_package_versions_by_guix_revision_range 2020-03-24T20:40:38Z Christopher Baines <mail@cbaines.net> # Drop package_versions_by_guix_revision_range
diff --git a/sqitch/verify/drop_package_versions_by_guix_revision_range.sql b/sqitch/verify/drop_package_versions_by_guix_revision_range.sql
new file mode 100644
index 0000000..489f443
--- /dev/null
+++ b/sqitch/verify/drop_package_versions_by_guix_revision_range.sql
@@ -0,0 +1,7 @@
+-- Verify guix-data-service:drop_package_versions_by_guix_revision_range on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;