{"table_name":"hubapp_analytics","full_table_name":"wp_hubapp_analytics","description":"Stores analytics or statistics data.","detection_method":"both","confidence":"high","create_sql":"CREATE TABLE `wp_hubapp_analytics` (\\n  `id` bigint NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint NOT NULL,\\n  `visit_date` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `user_ip` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `user_agent` text COLLATE utf8mb4_unicode_520_ci,\\n  `referer` text COLLATE utf8mb4_unicode_520_ci,\\n  `is_logged_in` tinyint(1) DEFAULT '0',\\n  `user_id` bigint DEFAULT NULL,\\n  `country` varchar(2) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `session_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `post_id` (`post_id`),\\n  KEY `visit_date` (`visit_date`),\\n  KEY `user_ip` (`user_ip`),\\n  KEY `is_logged_in` (`is_logged_in`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"hubapp","name":"HubApp (AI Hub) – Platform for AI Agents","active_installs":10,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/hubapp/"}}