CREATE TABLE entries ( path BYTEA PRIMARY KEY, size BIGINT, sha256 BYTEA NOT NULL, md5 BYTEA NOT NULL ); CREATE INDEX ON entries(sha256); CREATE INDEX ON entries(md5);