wp_apbd_wps_ticket

CREATE TABLE Statement

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

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_apbd_wps_ticket`;

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