X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2Finit_pool.sql;h=8797acd59b33c4c6b88c2ac6f4edbdef1459baa8;hb=ef8dcbe8251167f9c922959a67f626615b421c81;hp=e09cc98636697809fa415ac6e23b5955ba86f38c;hpb=8f11bdd18377414f41c4fbede628f122de5dad2d;p=dak.git diff --git a/setup/init_pool.sql b/setup/init_pool.sql index e09cc986..8797acd5 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,