1 files changed, 15 insertions, 0 deletions
diff --git a/sqitch/deploy/change_package_derivations_by_guix_revision_range_target.sql b/sqitch/deploy/change_package_derivations_by_guix_revision_range_target.sql
new file mode 100644
index 0000000..7ba90c7
--- /dev/null
+++ b/sqitch/deploy/change_package_derivations_by_guix_revision_range_target.sql
@@ -0,0 +1,15 @@
+-- Deploy guix-data-service:change_package_derivations_by_guix_revision_range_target to pg
+
+BEGIN;
+
+UPDATE package_derivations_by_guix_revision_range SET target = '' WHERE system = target;
+
+DELETE FROM package_derivations_by_guix_revision_range WHERE target IN (
+  'aarch64-linux',
+  'armhf-linux',
+  'i686-linux',
+  'mips64el-linux',
+  'x86_64-linux'
+);
+
+COMMIT;