X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=init_pool.sql;h=6d3b6e4913c1bb1bae818c4b26b02cb022bb88a4;hb=fc1e81cf87861694e19b96afa8dd849dd967343c;hp=7676f7c07490de5d7d3ab7417fc8c30d62ddc81b;hpb=aaf347b08ea7117ab6489f0f139f4337d47f2b8c;p=dak.git diff --git a/init_pool.sql b/init_pool.sql index 7676f7c0..6d3b6e49 100644 --- a/init_pool.sql +++ b/init_pool.sql @@ -24,7 +24,7 @@ CREATE TABLE architecture ( ); CREATE TABLE maintainer ( - id SERIAL PRIMARY KEY, + id SERIAL PRIMARY KEY, name TEXT UNIQUE NOT NULL ); @@ -80,19 +80,19 @@ CREATE TABLE binaries ( CREATE TABLE suite ( id SERIAL PRIMARY KEY, suite_name TEXT NOT NULL, - version TEXT NOT NULL, + version TEXT, origin TEXT, label TEXT, policy_engine TEXT, description TEXT ); - + CREATE TABLE suite_architectures ( suite INT4 NOT NULL, -- REFERENCES suite architecture INT4 NOT NULL, -- REFERENCES architecture unique (suite, architecture) ); - + CREATE TABLE bin_associations ( id SERIAL PRIMARY KEY, suite INT4 NOT NULL, -- REFERENCES suite @@ -124,7 +124,7 @@ CREATE TABLE override_type ( ); CREATE TABLE override ( - package TEXT NOT NULL, + package TEXT NOT NULL, suite INT4 NOT NULL, -- references suite component INT4 NOT NULL, -- references component priority INT4, -- references priority