{"table_name":"lunexia_ip_reputation","full_table_name":"wp_lunexia_ip_reputation","description":"Stores lunexia ip reputation data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_ip_reputation ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ip_address varchar(45) NOT NULL, threat_score bigint(20) NOT NULL DEFAULT 0, last_activity datetime NOT NULL, activity_count int(10) unsigned NOT NULL DEFAULT 1, failed_logins int(10) unsigned NOT NULL DEFAULT 0, sql_injection_attempts int(10) unsigned NOT NULL DEFAULT 0, xss_attempts int(10) unsigned NOT NULL DEFAULT 0, malware_uploads int(10) unsigned NOT NULL DEFAULT 0, rate_limit_violations int(10) unsigned NOT NULL DEFAULT 0, scanner_activities int(10) unsigned NOT NULL DEFAULT 0, webshells_detected int(10) unsigned NOT NULL DEFAULT 0, notes longtext, created_at datetime NOT NULL, expires_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY ip_address (ip_address), KEY threat_score (threat_score), KEY last_activity (last_activity), KEY expires_at (expires_at) ) {$charset_collate};\"; dbDelta( $sql );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"threat_score","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"last_activity","type":"datetime","nullable":false,"primary_key":false},{"name":"activity_count","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"failed_logins","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"sql_injection_attempts","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"xss_attempts","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"malware_uploads","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"rate_limit_violations","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"scanner_activities","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"webshells_detected","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"notes","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"lunexia-htaccess-shield","name":"Lunexia .htaccess Shield","active_installs":0,"version":"3.2.1","wp_org_url":"https://wordpress.org/plugins/lunexia-htaccess-shield/"}}