sqitch/sqlite/deploy/more_indexes_on_builds_and_derivation_inputs.sql


1
2
3
4
5
6
7
8

-- Deploy guix-build-coordinator:more_indexes_on_builds_and_derivation_inputs to sqlite

BEGIN;

CREATE INDEX derivation_inputs_derivation_output_id ON derivation_inputs (derivation_output_id);
CREATE INDEX builds_unprocessed ON builds (processed) WHERE processed = 0;

COMMIT;