{"slug":"analytical-spam-filter","name":"Analytical Spam Filter","description":"Block WordPress comment spam, trackback spam, and pingback spam through intelligent analytics instead of interactive challenge response tests.","author":"John Dalesandro","active_installs":10,"version":"1.0.13","wp_org_url":"https://wordpress.org/plugins/analytical-spam-filter/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"analytical_spam_filter_content_history","full_table_name":"wp_analytical_spam_filter_content_history","description":"Stores analytical spam filter content history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"hash_val","type":"binary(64)","nullable":false,"primary_key":false},{"name":"time","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_analytical_spam_filter_content_history ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, hash_val binary(64) NOT NULL, time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) {$charset_collate};\"; include_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"},{"table_name":"analytical_spam_filter_submitter_history","full_table_name":"wp_analytical_spam_filter_submitter_history","description":"Stores analytical spam filter submitter history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"submitter","type":"varbinary(16)","nullable":false,"primary_key":false},{"name":"time","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_analytical_spam_filter_submitter_history ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, submitter varbinary(16) NOT NULL, time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) {$charset_collate};\"; include_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"}],"table_count":2}