drop sequence pydar2_rpmlocation_idseq;
drop sequence pydar2_rpmfile_idseq;
create sequence pydar2_rpmlocation_idseq;
create sequence pydar2_rpmfile_idseq;

drop table pydar2_rpmlocation;
drop table pydar2_rpmfile;

create table pydar2_rpmlocation (
    id integer unique not null default nextval('pydar2_rpmlocation_idseq'),
    path varchar(512) not null
);

create table pydar2_rpmfile (
    id integer unique not null default nextval('pydar2_rpmfile_idseq'),
    locationid integer not null,
    rpmname varchar(512) not null,
    path varchar(512) not null,  
    addtimestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    specrpmepoch varchar(128) not null,
    specrpmname varchar(128) not null,
    specrpmversion varchar(128) not null,
    specrpmrelease varchar(128),
    filemd5s varchar(512) not null,
    svncmtrev integer,
    specfileid integer
);