{"table_name":"apbd_wps_ticket_log","full_table_name":"wp_apbd_wps_ticket_log","description":"A logging table that records activity, events, or audit history.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_apbd_wps_ticket_log` (\\n  `ticket_id` int NOT NULL DEFAULT '0',\\n  `log_id` int NOT NULL DEFAULT '0',\\n  `log_by` int unsigned NOT NULL DEFAULT '0',\\n  `log_by_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'radio(A=Staff,U=Ticket User,G=Guest Ticket User)',\\n  `log_msg` char(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `log_for` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'B' COMMENT 'bool(B=Both,U=User,A=Staff)',\\n  `ticket_status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'P' COMMENT 'drop(N=New,C=Closed,P=In-progress,R=Re-open,D=Deleted)',\\n  `entry_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  UNIQUE KEY `ticket_id` (`ticket_id`,`log_id`) USING BTREE,\\n  KEY `ticket_id_2` (`ticket_id`) USING BTREE\\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/"}}