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