connect 'jdbc:derby:easydb';

CREATE TABLE FILE_MANAGE_INFO (
  ID INT NOT NULL PRIMARY KEY -- Last ID = 2^32-1 = 2147483648-1
, MODIFIED BIGINT NOT NULL -- last modified
, FOREIGN KEY (ID) REFERENCES FILE_INFO(ID) -- file id
);

CREATE INDEX IDX_FILE_INFO_MODIFIED ON FILE_INFO(MODIFIED);

