{"table_name":"apbd_wps_ticket","full_table_name":"wp_apbd_wps_ticket","description":"Stores apbd wps ticket data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_apbd_wps_ticket` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `ticket_track_id` char(18) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `cat_id` char(11) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `title` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `ticket_body` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `ticket_user` int NOT NULL DEFAULT '0',\\n  `opened_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `re_open_time` timestamp NULL DEFAULT NULL,\\n  `re_open_by` char(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `re_open_by_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'radio(A=Staff,U=Ticket User,G=Guest Ticket User)',\\n  `user_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'U' COMMENT 'radio(G=Guest,U=User,A=Staff)',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'drop(N=New,C=Closed,P=In-progress,R=Re-open,A=Active,I=Inactive,D=Deleted)',\\n  `assigned_on` char(11) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `assigned_date` timestamp NULL DEFAULT NULL,\\n  `last_replied_by` char(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `last_replied_by_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'radio(G=Guest,U=User,A=Staff)',\\n  `last_reply_time` timestamp NULL DEFAULT NULL,\\n  `ticket_rating` decimal(1,0) unsigned NOT NULL DEFAULT '0',\\n  `priority` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'drop(N=Normal,M=Medium,H=High)',\\n  `is_public` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  `is_open_using_email` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  `reply_counter` int unsigned NOT NULL DEFAULT '0',\\n  `is_user_seen_last_reply` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  `related_url` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `last_status_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `email_notification` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y' COMMENT 'bool(Y=Yes,N=No)',\\n  `opened_by` char(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `opened_by_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'radio(G=Guest,U=User,A=Staff)',\\n  `mailbox_id` char(11) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `mailbox_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'radio(M=Modern,T=Traditional)',\\n  PRIMARY KEY (`id`) USING BTREE,\\n  UNIQUE KEY `ticket_track_id` (`ticket_track_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/"}}