{"table_name":"apbd_wps_docs_analytics","full_table_name":"wp_apbd_wps_docs_analytics","description":"Stores analytics or statistics data.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_apbd_wps_docs_analytics` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` int unsigned NOT NULL DEFAULT '0',\\n  `views` int NOT NULL DEFAULT '0',\\n  `unique_views` int NOT NULL DEFAULT '0',\\n  `positive` int NOT NULL DEFAULT '0',\\n  `negative` int NOT NULL DEFAULT '0',\\n  `neutral` int NOT NULL DEFAULT '0',\\n  `score` int GENERATED ALWAYS AS ((case when ((coalesce(`positive`,0) + coalesce(`negative`,0)) > 0) then round((((coalesce(`positive`,0) - coalesce(`negative`,0)) / (coalesce(`positive`,0) + coalesce(`negative`,0))) * 100),0) else 0 end)) STORED,\\n  `created_at` datetime NOT NULL,\\n  `created_date` date GENERATED ALWAYS AS (cast(`created_at` as date)) STORED,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `post_id_created_date` (`post_id`,`created_date`),\\n  KEY `post_id` (`post_id`),\\n  KEY `created_at` (`created_at`),\\n  KEY `created_date` (`created_date`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"support-genix-lite","name":"Support Genix – Helpdesk, AI Chatbot, Knowledge Base & Customer Support Ticketing System","active_installs":1000,"version":"1.4.44","wp_org_url":"https://wordpress.org/plugins/support-genix-lite/"}}