CREATE TABLE IF NOT EXISTS galleries ( id SERIAL, vanity char(12) NOT NULL, title varchar(128), description varchar(4096) NOT NULL, datetime timestamp with time zone NOT NULL, PRIMARY KEY (id) ); CREATE TABLE IF NOT EXISTS images ( id SERIAL, vanity char(12) NOT NULL, title varchar(128), filename varchar(64) NOT NULL, thumb_filename varchar(64) NOT NULL, datetime timestamp with time zone NOT NULL, PRIMARY KEY (id) );