Added dm-upload-allowed flag to exist, and added support for all

[dak.git] / setup / init_pool.sql

diff --git a/setup/init_pool.sql b/setup/init_pool.sql
index 7a6e2a490b82f46b809f556e6b08414be02b844b..6d295dbf1c60a0a032f6f6fbb3221a1a3597160a 100644 (file)
--- 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)
 );
 
@@ -82,6 +84,7 @@ CREATE TABLE source (
         file INT4 UNIQUE NOT NULL, -- REFERENCES files
        install_date TIMESTAMP NOT NULL,
        sig_fpr INT4 NOT NULL, -- REFERENCES fingerprint
+        dm-upload-allowed BOOLEAN NOT NULL,
        unique (source, version)
 );