 -- Associate key/value data with an individual file.  It is possible for a
 -- single file to have many different key/value data pieces, or none.
 create table file_key_values (
+    id integer primary key,
     file_id integer references files(id) not null,
     key_val_id integer references key_val(id) not null
 );

-- file to be a part of several builds at the same time, and for a single build
-- to contain several files.
create table build_files (
    build_id integer references build(id) not null,
    file_id integer references files(id) not null
);

);

create table group_requirements (
    id integer primary key,
    group_id integer references groups(id) not null,
    req_id integer references requirements(id) not null
);
