{"table_name":"deepmacl_scans","full_table_name":"wp_deepmacl_scans","description":"Stores deepmacl scans data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_deepmacl_scans ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, scan_id VARCHAR(36) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'running', total_files INT(11) NOT NULL DEFAULT 0, threats INT(11) NOT NULL DEFAULT 0, started_at DATETIME NOT NULL, finished_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY scan_id (scan_id) ) $charset;\"; $sql_results = \"CREATE TABLE wp_deepmacl_results ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, scan_id VARCHAR(36) NOT NULL, file_path TEXT NOT NULL, threat_type VARCHAR(100) NOT NULL, severity VARCHAR(20) NOT NULL DEFAULT 'medium', status VARCHAR(20) NOT NULL DEFAULT 'new', quarantine_path TEXT DEFAULT NULL, found_at DATETIME NOT NULL, actioned_at DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY scan_id (scan_id) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_scans );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"scan_id","type":"VARCHAR(36)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"total_files","type":"INT(11)","nullable":false,"primary_key":false},{"name":"threats","type":"INT(11)","nullable":false,"primary_key":false},{"name":"started_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"finished_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"scan_id","type":"VARCHAR(36)","nullable":false,"primary_key":false},{"name":"file_path","type":"TEXT","nullable":false,"primary_key":false},{"name":"threat_type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"severity","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"quarantine_path","type":"TEXT","nullable":true,"primary_key":false},{"name":"found_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"actioned_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"deep-malware-cleaner","name":"Deep Malware Cleaner","active_installs":0,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/deep-malware-cleaner/"}}