aboutsummaryrefslogtreecommitdiff
path: root/sqitch
diff options
context:
space:
mode:
Diffstat (limited to 'sqitch')
-rw-r--r--sqitch/pg/deploy/derivation_outputs_derivation_name_index.sql7
-rw-r--r--sqitch/pg/revert/derivation_outputs_derivation_name_index.sql7
-rw-r--r--sqitch/pg/verify/derivation_outputs_derivation_name_index.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/sqlite/deploy/derivation_outputs_derivation_name_index.sql7
-rw-r--r--sqitch/sqlite/revert/derivation_outputs_derivation_name_index.sql7
-rw-r--r--sqitch/sqlite/verify/derivation_outputs_derivation_name_index.sql7
7 files changed, 43 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/derivation_outputs_derivation_name_index.sql b/sqitch/pg/deploy/derivation_outputs_derivation_name_index.sql
new file mode 100644
index 0000000..65ee9b0
--- /dev/null
+++ b/sqitch/pg/deploy/derivation_outputs_derivation_name_index.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:derivation_outputs_derivation_name_index to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/derivation_outputs_derivation_name_index.sql b/sqitch/pg/revert/derivation_outputs_derivation_name_index.sql
new file mode 100644
index 0000000..2dfadfd
--- /dev/null
+++ b/sqitch/pg/revert/derivation_outputs_derivation_name_index.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:derivation_outputs_derivation_name_index from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/verify/derivation_outputs_derivation_name_index.sql b/sqitch/pg/verify/derivation_outputs_derivation_name_index.sql
new file mode 100644
index 0000000..c1b5a6a
--- /dev/null
+++ b/sqitch/pg/verify/derivation_outputs_derivation_name_index.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:derivation_outputs_derivation_name_index on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index a062e08..509802d 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -12,3 +12,4 @@ output_metadata 2020-04-23T14:26:15Z Christopher Baines <mail@cbaines.net> # Cre
derivation_outputs_output_index 2020-04-28T17:49:19Z Christopher Baines <mail@cbaines.net> # Add an index on derivation_outputs.output
allocator_related_indexes 2020-04-29T16:59:14Z Christopher Baines <mail@cbaines.net> # Add a few indexes that should speed up build allocation
unprocessed_hook_events 2020-05-08T12:55:28Z Christopher Baines <mail@cbaines.net> # Add a new table unprocessed_hook_events
+derivation_outputs_derivation_name_index 2020-05-10T16:24:05Z Christopher Baines <mail@cbaines.net> # Add an index on derivation_outputs.derivation_name
diff --git a/sqitch/sqlite/deploy/derivation_outputs_derivation_name_index.sql b/sqitch/sqlite/deploy/derivation_outputs_derivation_name_index.sql
new file mode 100644
index 0000000..b564ef6
--- /dev/null
+++ b/sqitch/sqlite/deploy/derivation_outputs_derivation_name_index.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:derivation_outputs_derivation_name_index to sqlite
+
+BEGIN;
+
+CREATE INDEX derivation_outputs_derivation_name_idx ON derivation_outputs (derivation_name);
+
+COMMIT;
diff --git a/sqitch/sqlite/revert/derivation_outputs_derivation_name_index.sql b/sqitch/sqlite/revert/derivation_outputs_derivation_name_index.sql
new file mode 100644
index 0000000..d915d2d
--- /dev/null
+++ b/sqitch/sqlite/revert/derivation_outputs_derivation_name_index.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:derivation_outputs_derivation_name_index from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/verify/derivation_outputs_derivation_name_index.sql b/sqitch/sqlite/verify/derivation_outputs_derivation_name_index.sql
new file mode 100644
index 0000000..5871242
--- /dev/null
+++ b/sqitch/sqlite/verify/derivation_outputs_derivation_name_index.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:derivation_outputs_derivation_name_index on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;