X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2Finit_pool.sql;h=1e3639406cf1c8f79b072a1eb90e13f3a070c995;hb=342c016d08d7ed329ae707ff6fcdb39ae560c438;hp=7a6e2a490b82f46b809f556e6b08414be02b844b;hpb=9593b37685e816dbfc473b8b3e2dcf5fb5692b54;p=dak.git diff --git a/setup/init_pool.sql b/setup/init_pool.sql index 7a6e2a49..1e363940 100644 --- a/setup/init_pool.sql +++ b/setup/init_pool.sql @@ -70,6 +70,8 @@ CREATE TABLE files ( md5sum TEXT NOT NULL, location INT4 NOT NULL, -- REFERENCES location last_used TIMESTAMP, + sha1sum TEXT NOT NULL, + sha256sum TEXT NOT NULL, unique (filename, location) );