sqitch/deploy/add_derivation_source_file_nars.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

-- Deploy guix-data-service:add_derivation_source_file_nars to pg

BEGIN;

CREATE TABLE derivation_source_file_nars (
    derivation_source_file_id integer PRIMARY KEY REFERENCES derivation_source_files (id),
    compression varchar NOT NULL,
    hash_algorithm varchar NOT NULL,
    hash varchar NOT NULL,
    uncompressed_size integer NOT NULL,
    data bytea NOT NULL
);

COMMIT;