Modified dak to use non-braindead DM schema, and use an actual column for

[dak.git] / setup / init_pool.sql

diff --git a/setup/init_pool.sql b/setup/init_pool.sql
index 1e3639406cf1c8f79b072a1eb90e13f3a070c995..bbb82e7415e60a7f24da35840f133ee235568779 100644 (file)
--- a/setup/init_pool.sql
+++ b/setup/init_pool.sql
@@ -38,6 +38,7 @@ CREATE TABLE uid (
        id SERIAL PRIMARY KEY,
        uid TEXT UNIQUE NOT NULL,
        name TEXT
+       debian_maintainer BOOLEAN NOT NULL,
 );
 
 CREATE TABLE keyrings (
@@ -84,6 +85,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)
 );