Warning, file /webapps/ocs-webserver/sql_code/20180122_member_dl_history.sql was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).
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 ;