\echo Whiskey create.pgsql $Id$
drop database if exists whiskey;
drop user if exists whiskey;

create user whiskey with password 'whiskey';
create database whiskey owner whiskey;

\c whiskey;

create table users (
	username text,
	password text,
	encrypted boolean,
	email text,
	icon_url text,
	image_url text,
	created_at bigint,
	updated_at bigint,
	publickey text,
	privatekey text,
	admin boolean
);
create table follows (
	username text,
	follows text
);
create table followers (
	username text,
	follower text
);
create table misc (
	key text,
	value text
);
alter table users owner to whiskey;
alter table follows owner to whiskey;
alter table followers owner to whiskey;
alter table misc owner to whiskey;