create table authors (
	cpanid varchar(30),
	email text,
	name text,
	primary key(cpanid)
);

create table packages (
	package varchar(255),
	version varchar(30),
	maturity text,
	filename text,
	cpanid varchar(30) references authors(cpanid),
	pathname text,
	primary key (package, version)
);