BEGIN;
DROP TABLE IF EXISTS file_info;
CREATE TABLE file_info(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
md5 CHAR(32),
sha256 CHAR(64),
type_id TINYINT(1) UNSIGNED REFERENCES file_type(id),
host_id TINYINT(1) UNSIGNED REFERENCES file_host(id),
path VARCHAR(256) NOT NULL,
virus VARCHAR(128),
risk_score TINYINT(1),
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY(id),
UNIQUE INDEX idx_md5(md5),
UNIQUE INDEX idx_sha256(sha256)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE utf8_general_ci;
COMMIT;