wp_apbd_wps_docs_analytics

CREATE TABLE Statement

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

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_apbd_wps_docs_analytics`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Support Genix – Helpdesk, AI Chatbot, Knowledge Base & Customer Support Ticketing System