aboutsummaryrefslogtreecommitdiff
path: root/sqitch
diff options
context:
space:
mode:
Diffstat (limited to 'sqitch')
-rw-r--r--sqitch/deploy/create_narinfo_fetch_records_index.sql8
-rw-r--r--sqitch/revert/create_narinfo_fetch_records_index.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/verify/create_narinfo_fetch_records_index.sql7
4 files changed, 23 insertions, 0 deletions
diff --git a/sqitch/deploy/create_narinfo_fetch_records_index.sql b/sqitch/deploy/create_narinfo_fetch_records_index.sql
new file mode 100644
index 0000000..c3547d5
--- /dev/null
+++ b/sqitch/deploy/create_narinfo_fetch_records_index.sql
@@ -0,0 +1,8 @@
+-- Deploy guix-data-service:create_narinfo_fetch_records_index to pg
+
+BEGIN;
+
+CREATE INDEX narinfo_fetch_records_narinfo_signature_data_id ON
+ narinfo_fetch_records (narinfo_signature_data_id);
+
+COMMIT;
diff --git a/sqitch/revert/create_narinfo_fetch_records_index.sql b/sqitch/revert/create_narinfo_fetch_records_index.sql
new file mode 100644
index 0000000..2da20bf
--- /dev/null
+++ b/sqitch/revert/create_narinfo_fetch_records_index.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:create_narinfo_fetch_records_index from pg
+
+BEGIN;
+
+DROP INDEX narinfo_fetch_records_narinfo_signature_data_id;
+
+COMMIT;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index d770077..e0c55c7 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -54,3 +54,4 @@ update_build_servers_build_config 2020-02-13T20:07:19Z Christopher Baines <mail@
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
+create_narinfo_fetch_records_index 2020-03-25T19:07:28Z Christopher Baines <mail@cbaines.net> # Create an index on narinfo_fetch_records
diff --git a/sqitch/verify/create_narinfo_fetch_records_index.sql b/sqitch/verify/create_narinfo_fetch_records_index.sql
new file mode 100644
index 0000000..4835797
--- /dev/null
+++ b/sqitch/verify/create_narinfo_fetch_records_index.sql
@@ -0,0 +1,7 @@
+-- Verify guix-data-service:create_narinfo_fetch_records_index on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;