Indexes

CREATE TABLE fileindex (
    id INTEGER AUTO_INCREMENT PRIMARY KEY,
    path VARCHAR(2048),
    filename VARCHAR(2048),
    mtime DATE,
    volume_guid VARCHAR(128),
    volume_name VARCHAR(128),
    hash64k VARCHAR(64),
    index (path),
    index (filename),
    index (mtime)
);

and creating indexes after the table

CREATE TABLE fileindex (
    id INTEGER AUTO_INCREMENT PRIMARY KEY,
    path VARCHAR(2048),
    filename VARCHAR(2048),
    mtime DATE,
    volume_guid VARCHAR(128),
    volume_name VARCHAR(128),
    hash64k VARCHAR(64)
);
CREATE INDEX pathidx ON fileindex (path);