{"table_name":"isoft_fmf_download_log","full_table_name":"wp_isoft_fmf_download_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_isoft_fmf_download_log ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, download_id BIGINT UNSIGNED NOT NULL, file_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED DEFAULT NULL, user_login VARCHAR(60) DEFAULT NULL, ip_address VARCHAR(45) DEFAULT NULL, user_agent VARCHAR(500) DEFAULT NULL, referer VARCHAR(2048) DEFAULT NULL, license_id_at_download BIGINT UNSIGNED DEFAULT NULL, downloaded_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, log_date DATE NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (id), INDEX idx_download_id (download_id), INDEX idx_file_id (file_id), INDEX idx_user_id (user_id), INDEX idx_license_at_download (license_id_at_download), INDEX idx_downloaded_at (downloaded_at), INDEX idx_log_date (log_date) ) $charset_collate;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"download_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"file_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"user_login","type":"VARCHAR(60)","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"user_agent","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"referer","type":"VARCHAR(2048)","nullable":true,"primary_key":false},{"name":"license_id_at_download","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"downloaded_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"log_date","type":"DATE","nullable":false,"primary_key":false}],"plugin":{"slug":"isoft-fm-foundation","name":"I-Soft File Manager: Foundation","active_installs":0,"version":"0.11.0","wp_org_url":"https://wordpress.org/plugins/isoft-fm-foundation/"}}