blob: 452c6aa17144ad56fa9000acf69fefde59b675c4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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;
|