create table packages ( id int, package varchar(256), format varchar(32), diffgz varchar(1024), loc varchar(1024), type varchar(32), version varchar(256), updated int ); create table releases ( id int, name varchar(32), md5sum varchar(32), updated int ); create table components ( id int, name varchar(32), updated int ); create table pkg_rel ( rel_id int, comp_id int, pkg_id int );