Deduplicate builds and add a unique index

Duplicate builds could creep in if the code to create them ran concurrently. I
didn't exclude them initially, as I was unsure if there should be such a
restriction, but at least for now, Cuirass builds map exactly to a single
derivation, so use the same restriction here.

1 files changed, 7 insertions, 0 deletions

diff --git a/sqitch/revert/sort_out_duplicate_builds.sql b/sqitch/revert/sort_out_duplicate_builds.sql
new file mode 100644
index 0000000..153a4ef
--- /dev/null
+++ b/sqitch/revert/sort_out_duplicate_builds.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:sort_out_duplicate_builds from pg
+
+BEGIN;
+
+DROP INDEX builds_build_server_id_derivation_file_name_idx;
+
+COMMIT;