connect 'jdbc:derby:easydb';

CREATE TABLE HASH_INFO (
  ID INT NOT NULL PRIMARY KEY
, MD5_HASH BLOB(128) NOT NULL -- MD5 digest hash value
, FOREIGN KEY (ID) REFERENCES FILE_INFO(ID)
);

CREATE INDEX IDX_HASH_INFO_MD5_HASH ON HASH_INFO(MD5_HASH);
