{"table_name":"isoft_fmf_files","full_table_name":"wp_isoft_fmf_files","description":"Stores isoft fmf files data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_isoft_fmf_files ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, download_id BIGINT UNSIGNED NOT NULL, file_type ENUM('local','external') NOT NULL DEFAULT 'local', title VARCHAR(255) NOT NULL DEFAULT '', description TEXT, file_path VARCHAR(500) DEFAULT NULL, file_name VARCHAR(255) DEFAULT NULL, file_size BIGINT UNSIGNED DEFAULT 0, file_mime VARCHAR(100) DEFAULT NULL, file_hash VARCHAR(64) DEFAULT NULL, external_url VARCHAR(2048) DEFAULT NULL, is_mirror TINYINT(1) NOT NULL DEFAULT 0, is_missing TINYINT(1) NOT NULL DEFAULT 0, missing_since DATETIME NULL DEFAULT NULL, inode BIGINT UNSIGNED NULL DEFAULT NULL, download_count BIGINT UNSIGNED NOT NULL DEFAULT 0, sort_order INT NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), INDEX idx_download_id (download_id), INDEX idx_file_type (file_type), INDEX idx_file_hash (file_hash), INDEX idx_is_missing (is_missing) ) $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_type","type":"ENUM('local','external')","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"file_path","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"file_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"file_size","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"file_mime","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"file_hash","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"external_url","type":"VARCHAR(2048)","nullable":true,"primary_key":false},{"name":"is_mirror","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"is_missing","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"missing_since","type":"DATETIME","nullable":true,"primary_key":false},{"name":"inode","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"download_count","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"sort_order","type":"INT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","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/"}}