X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2Finit_pool.sql;h=1e3639406cf1c8f79b072a1eb90e13f3a070c995;hb=401921180ecf3207da22af8110c738ee1ca785de;hp=7a6e2a490b82f46b809f556e6b08414be02b844b;hpb=3203b8ab4cec37837e3ff2d38ed64c49332ccc3e;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) );