8 lines
235 B
MySQL
8 lines
235 B
MySQL
|
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));
|