File indexing completed on 2024-04-21 06:00:36 

0001 CREATE TABLE `member_download_history`
0002 (
0003     `id`                   INT(11)             NOT NULL AUTO_INCREMENT,
0004     `member_id`            VARCHAR(255)        NOT NULL,
0005     `project_id`           INT(11)             NOT NULL,
0006     `file_id`              INT(11)             NOT NULL,
0007     `file_name`            VARCHAR(255)        NOT NULL,
0008     `file_type`            VARCHAR(255)        NOT NULL,
0009     `file_size`            BIGINT(20) UNSIGNED NOT NULL,
0010     `downloaded_timestamp` TIMESTAMP           NULL DEFAULT CURRENT_TIMESTAMP,
0011     PRIMARY KEY (`id`),
0012     INDEX `idx_time` (`downloaded_timestamp`),
0013     INDEX `idx_projectid` (`project_id`),
0014     INDEX `idx_memberid` (`member_id`)
0015 )
0016     COLLATE = 'latin1_swedish_ci'
0017     ENGINE = MyISAM
0018 ;