{"table_name":"apbd_wps_ticket_reply","full_table_name":"wp_apbd_wps_ticket_reply","description":"Stores apbd wps ticket reply data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_apbd_wps_ticket_reply` (\\n  `ticket_id` int NOT NULL DEFAULT '0',\\n  `reply_id` int NOT NULL DEFAULT '0',\\n  `asigned_by` char(11) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'Ticket current asigned by',\\n  `replied_by` char(11) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `replied_by_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'radio(A=Staff,U=Ticket User,G=Guest Ticke User)',\\n  `reply_text` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `reply_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\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)',\\n  `is_private` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y' COMMENT 'boot(Y=Yes,N=No)',\\n  `is_user_seen` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  `seen_time` timestamp NULL DEFAULT NULL,\\n  UNIQUE KEY `ticket_id` (`ticket_id`,`reply_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/"}}