{"table_name":"aidf_crawler_log","full_table_name":"wp_aidf_crawler_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_aidf_crawler_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, bot_name varchar(50) NOT NULL, bot_ua varchar(500) NOT NULL DEFAULT '', url_path varchar(500) NOT NULL DEFAULT '', status_code smallint(5) unsigned NOT NULL DEFAULT 200, created_at datetime NOT NULL, PRIMARY KEY (id), KEY bot_date (bot_name, created_at), KEY date_idx (created_at) ) $charset_collate; CREATE TABLE wp_aidf_crawler_summary ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, bot_name varchar(50) NOT NULL, log_date date NOT NULL, hit_count int(10) unsigned NOT NULL DEFAULT 0, top_page varchar(500) NOT NULL DEFAULT '', status_200 int(10) unsigned NOT NULL DEFAULT 0, status_403 int(10) unsigned NOT NULL DEFAULT 0, status_other int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY bot_day (bot_name, log_date), KEY date_idx (log_date) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"bot_name","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"bot_ua","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"url_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"status_code","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"bot_name","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"log_date","type":"date","nullable":false,"primary_key":false},{"name":"hit_count","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"top_page","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"status_200","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"status_403","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"status_other","type":"int(10) unsigned","nullable":false,"primary_key":false}],"plugin":{"slug":"ai-discovery-files","name":"AI Discovery Files – llms.txt & AI Visibility","active_installs":10,"version":"1.3.7","wp_org_url":"https://wordpress.org/plugins/ai-discovery-files/"}}