CREATE TABLE files ( hash CHAR(12) NOT NULL, detected_type VARCHAR(64) NOT NULL, create_time BIGINT UNSIGNED NOT NULL, access_time BIGINT UNSIGNED NOT NULL, access_count INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(hash));