From: Mark Hymers <mhy@debian.org>
Date: Sat, 16 Aug 2008 01:50:15 +0000 (+0000)
Subject: add sha1sum and sha256sum columns
X-Git-Url: https://git.decadent.org.uk/gitweb/?p=dak.git;a=commitdiff_plain;h=401921180ecf3207da22af8110c738ee1ca785de

add sha1sum and sha256sum columns

Signed-off-by: Mark Hymers <mhy@debian.org>
---

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)
 );