{"slug":"isoft-fm-foundation","name":"I-Soft File Manager: Foundation","description":"Document and download manager with real on-disk folder organization, per-department access control, and multi-file downloads.","author":"chillic","active_installs":0,"version":"0.11.0","wp_org_url":"https://wordpress.org/plugins/isoft-fm-foundation/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"isoft_fmf_download_daily","full_table_name":"wp_isoft_fmf_download_daily","description":"Stores isoft fmf download daily data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"download_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"log_date","type":"DATE","nullable":false,"primary_key":false},{"name":"count","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_isoft_fmf_download_daily ( download_id BIGINT UNSIGNED NOT NULL, log_date DATE NOT NULL, count BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (download_id, log_date), INDEX idx_log_date (log_date) ) $charset_collate;\" );"},{"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","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}],"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;\" );"},{"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","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}],"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;\" );"},{"table_name":"isoft_fmf_licenses","full_table_name":"wp_isoft_fmf_licenses","description":"Stores isoft fmf licenses data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"full_text","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"url","type":"VARCHAR(2048)","nullable":true,"primary_key":false},{"name":"is_default","type":"TINYINT(1)","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}],"create_sql":"CREATE TABLE wp_isoft_fmf_licenses ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL, description TEXT, full_text LONGTEXT, url VARCHAR(2048) DEFAULT NULL, is_default TINYINT(1) 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), UNIQUE INDEX idx_slug (slug) ) $charset_collate;\" );"}],"table_count":4}