diff options
Diffstat (limited to 'sqitch/deploy/builds_add_derivation_output_details_set_id.sql')
-rw-r--r-- | sqitch/deploy/builds_add_derivation_output_details_set_id.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sqitch/deploy/builds_add_derivation_output_details_set_id.sql b/sqitch/deploy/builds_add_derivation_output_details_set_id.sql new file mode 100644 index 0000000..452c6aa --- /dev/null +++ b/sqitch/deploy/builds_add_derivation_output_details_set_id.sql @@ -0,0 +1,19 @@ +-- Deploy guix-data-service:builds_add_derivation_output_details_set_id to pg + +BEGIN; + +ALTER TABLE builds + ADD COLUMN derivation_output_details_set_id integer + NULL + REFERENCES derivation_output_details_sets (id); + +UPDATE builds SET derivation_output_details_set_id = ( + SELECT derivations_by_output_details_set.derivation_output_details_set_id + FROM derivations_by_output_details_set + WHERE derivations_by_output_details_set.derivation_id = builds.derivtion_id +); + +CREATE INDEX builds_derivation_output_details_set_id ON + builds (derivation_output_details_set_id); + +COMMIT; |