File indexing completed on 2024-03-24 06:03:45
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 ;