File indexing completed on 2024-04-28 17:16:13 

0001 CREATE TABLE `member_download_anonymous`
0002 (
0003     `id`                   INT(11)             NOT NULL AUTO_INCREMENT,
0004     `user`          VARCHAR(255)        NOT NULL,
0005     `project_id`           INT(11)             NOT NULL,
0006     `file_id`              INT(11)             NOT NULL,
0007     `downloaded_timestamp` TIMESTAMP           NULL DEFAULT CURRENT_TIMESTAMP,
0008     PRIMARY KEY (`id`),
0009     INDEX `idx_time` (`downloaded_timestamp`),
0010     INDEX `idx_projectid` (`project_id`),
0011     INDEX `idx_fingerprint` (`user`)
0012 )
0013     COLLATE = 'latin1_swedish_ci'
0014     ENGINE = MyISAM
0015 ;