X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2Finit_pool.sql;h=7a6e2a490b82f46b809f556e6b08414be02b844b;hb=aa83ebb15882823869b109d370e24ef3efd730f8;hp=9925148cfcd9638d66e025a10d03178c72f20c87;hpb=aa70864fc391f7ebbf5bb67e14653ad68f6778fa;p=dak.git diff --git a/setup/init_pool.sql b/setup/init_pool.sql index 9925148c..7a6e2a49 100644 --- a/setup/init_pool.sql +++ b/setup/init_pool.sql @@ -28,6 +28,12 @@ CREATE TABLE maintainer ( name TEXT UNIQUE NOT NULL ); +CREATE TABLE src_uploaders ( + id SERIAL PRIMARY KEY, + source INT4 NOT NULL REFERENCES source, + maintainer INT4 NOT NULL REFERENCES maintainer +); + CREATE TABLE uid ( id SERIAL PRIMARY KEY, uid TEXT UNIQUE NOT NULL,