gistfile1.txt

-- Using text, for ease of working with:

CREATE TABLE file_hash (
  hash_id integer PRIMARY KEY,
  file_id integer REFERENCES file,
  md5 text UNIQUE,
  sha1 text UNIQUE,
  photodna text UNIQUE
);

-- Using bytea, for space and speed benefits:

CREATE TABLE file_hash (
  hash_id integer PRIMARY KEY,
  file_id integer REFERENCES file,
  md5 bytea UNIQUE,
  sha1 bytea UNIQUE,
  photodna bytea UNIQUE
);