drop table if exists Pages, Entry, Authors;

create table Pages(
	id integer primary key,
	title text not null,
	class text not null,
	UNIQUE(id, title));

create table Entry(
	id integer primary key,
	body text,
	subject text,
	modtime timestamp with time zone,
	author integer);

create table Authors(
	id integer primary key,
	name text,
	email text);

insert into Authors values(1, "Jeffrey Drake", "j@email");
insert into Pages values(1, "Thoughts", "journal");