CREATE TABLE submits ( sha1 character(40), rpmname varchar(512), EVR varchar(100), packager varchar(100), url varchar(512), revision integer, status integer, submit_ts timestamp with time zone ); CREATE INDEX ON submits (sha1);