X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2Finit_pool.sql;h=bbb82e7415e60a7f24da35840f133ee235568779;hb=3b1f0efc3965793443da9260e8f80f895b7dccd1;hp=1e3639406cf1c8f79b072a1eb90e13f3a070c995;hpb=e79e9a1395528354b5978fc4b92a8fcdd1559d70;p=dak.git diff --git a/setup/init_pool.sql b/setup/init_pool.sql index 1e363940..bbb82e74 100644 --- 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) );