{"table_name":"lunexia_geo_cache","full_table_name":"wp_lunexia_geo_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_geo_cache ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ip_address varchar(45) NOT NULL, country_code varchar(10), country_name varchar(191), region varchar(191), city varchar(191), latitude decimal(10,8), longitude decimal(11,8), asn varchar(50), hosting_provider varchar(191), is_vpn tinyint(1) DEFAULT 0, is_proxy tinyint(1) DEFAULT 0, is_datacenter tinyint(1) DEFAULT 0, threat_level varchar(20), last_lookup datetime, cache_expires datetime, created_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY ip_address (ip_address), KEY country_code (country_code), KEY asn (asn), KEY cache_expires (cache_expires) ) {$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":"country_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"country_name","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"region","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"latitude","type":"decimal(10,8)","nullable":true,"primary_key":false},{"name":"longitude","type":"decimal(11,8)","nullable":true,"primary_key":false},{"name":"asn","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"hosting_provider","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"is_vpn","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_proxy","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_datacenter","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"threat_level","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"last_lookup","type":"datetime","nullable":true,"primary_key":false},{"name":"cache_expires","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"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/"}}