{"slug":"support-genix-lite","name":"Support Genix – Helpdesk, AI Chatbot, Knowledge Base & Customer Support Ticketing System","description":"AI-powered helpdesk & support ticket system with chatbot, knowledge base, and smart automation for WordPress.","author":"DevItems","active_installs":1000,"version":"1.4.44","wp_org_url":"https://wordpress.org/plugins/support-genix-lite/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"apbd_wps_canned_msg","full_table_name":"wp_apbd_wps_canned_msg","description":"Stores apbd wps canned msg data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_canned_msg` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` char(3) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `title` char(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `canned_msg` text COLLATE utf8mb4_unicode_520_ci COMMENT 'textarea',\\n  `entry_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `added_by` char(3) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `canned_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'T' COMMENT 'drop(T=Ticket,C=Chat)',\\n  `status` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`) USING BTREE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_chatbot_embed_token","full_table_name":"wp_apbd_wps_chatbot_embed_token","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_chatbot_embed_token` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'Display name for admin',\\n  `token` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT '64-char secure token',\\n  `allowed_domains` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Comma-separated list of allowed domains',\\n  `feature_opts` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Comma-separated feature flags',\\n  `allowed_spaces` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Comma-separated allowed KB space IDs',\\n  `allowed_categories` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Comma-separated allowed KB category IDs',\\n  `primary_color` varchar(7) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Hex color code e.g. #0bbc5c',\\n  `restrict_docs_browsing` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'Y=Restrict N=No restriction',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'A=Active, I=Inactive',\\n  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `idx_token` (`token`),\\n  KEY `idx_status` (`status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_chatbot_events","full_table_name":"wp_apbd_wps_chatbot_events","description":"Stores apbd wps chatbot events data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_chatbot_events` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `keyword_id` int unsigned NOT NULL,\\n  `founded` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `count` int NOT NULL DEFAULT '0',\\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 `keyword_id_founded_created_date` (`keyword_id`,`founded`,`created_date`),\\n  KEY `keyword_id` (`keyword_id`),\\n  KEY `founded` (`founded`),\\n  KEY `created_at` (`created_at`),\\n  KEY `created_date` (`created_date`),\\n  CONSTRAINT `fkcb_keyword_id` FOREIGN KEY (`keyword_id`) REFERENCES `wp_apbd_wps_chatbot_keywords` (`id`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_chatbot_history","full_table_name":"wp_apbd_wps_chatbot_history","description":"Stores apbd wps chatbot history data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_chatbot_history` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` int NOT NULL DEFAULT '0',\\n  `session_id` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Session ID for grouping conversations',\\n  `guest_identifier` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Hashed guest identifier',\\n  `query` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `docs_ids` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `is_stored_content` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y' COMMENT 'Whether AI response was stored',\\n  `feedback` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'drop(H=Happy,N=Neutral,U=Unhappy)',\\n  `conv_hash` char(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`id`),\\n  KEY `idx_session_id` (`session_id`),\\n  KEY `idx_user_id` (`user_id`),\\n  KEY `idx_guest_identifier` (`guest_identifier`),\\n  KEY `idx_created_at` (`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_chatbot_keywords","full_table_name":"wp_apbd_wps_chatbot_keywords","description":"Stores apbd wps chatbot keywords data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_chatbot_keywords` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `keyword` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `created_at` datetime NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `keyword` (`keyword`(191))\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_chatbot_session","full_table_name":"wp_apbd_wps_chatbot_session","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_chatbot_session` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `session_id` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `user_id` int NOT NULL DEFAULT '0',\\n  `guest_identifier` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `first_query` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `message_count` int NOT NULL DEFAULT '1',\\n  `last_feedback` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'drop(H=Helpful,N=Neutral,U=Unhelpful)',\\n  `session_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'T' COMMENT 'drop(T=Text,V=Voice)',\\n  `duration` int DEFAULT NULL,\\n  `is_starred` tinyint(1) NOT NULL DEFAULT '0',\\n  `started_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `last_activity_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `idx_session_id` (`session_id`),\\n  KEY `idx_started_at` (`started_at`),\\n  KEY `idx_user_id` (`user_id`),\\n  KEY `idx_is_starred` (`is_starred`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_custom_field","full_table_name":"wp_apbd_wps_custom_field","description":"Stores apbd wps custom field data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_custom_field` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `field_label` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `field_slug` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `help_text` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `choose_category` char(225) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'FK(wp_apbd_wps_ticket_category,id,title)',\\n  `fld_option` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `fld_order` int unsigned NOT NULL,\\n  `where_to_create` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'I' COMMENT 'radio(I=In Registartion Form,T=Ticket Open Form Category)',\\n  `create_for` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'B' COMMENT 'radio(A=Admin Only,B=Both)',\\n  `field_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'T' COMMENT 'radio(T=Textbox,N=Numeric,D=Date,S=Switch,R=Radio,W=Dropdown,E=Text/Instruction,U=URL Input)',\\n  `is_required` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `has_condition` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  `conditions` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `condition_rel` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(A=And,O=Or)',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `is_half_field` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_debug_log","full_table_name":"wp_apbd_wps_debug_log","description":"A logging table that records activity, events, or audit history.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_debug_log` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `entry_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'S' COMMENT 'radio(E=Error,S=Success)',\\n  `log_type` char(4) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'GEN' COMMENT 'drop(GEN=General,EML=Email,OTH=Others)',\\n  `title` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `log_data` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'S' COMMENT 'drop(F=Failed,S=Success)',\\n  `entry_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`) USING BTREE,\\n  KEY `entry_type` (`entry_type`) USING BTREE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_docs_analytics","full_table_name":"wp_apbd_wps_docs_analytics","description":"Stores analytics or statistics data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"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"},{"table_name":"apbd_wps_docs_search_keywords","full_table_name":"wp_apbd_wps_docs_search_keywords","description":"Stores apbd wps docs search keywords data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_docs_search_keywords` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `keyword` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `created_at` datetime NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `keyword` (`keyword`(191))\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_docs_searches_events","full_table_name":"wp_apbd_wps_docs_searches_events","description":"Stores apbd wps docs searches events data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_docs_searches_events` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `keyword_id` int unsigned NOT NULL,\\n  `founded` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `count` int NOT NULL DEFAULT '0',\\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 `keyword_id_founded_created_date` (`keyword_id`,`founded`,`created_date`),\\n  KEY `keyword_id` (`keyword_id`),\\n  KEY `founded` (`founded`),\\n  KEY `created_at` (`created_at`),\\n  KEY `created_date` (`created_date`),\\n  CONSTRAINT `fk_keyword_id` FOREIGN KEY (`keyword_id`) REFERENCES `wp_apbd_wps_docs_search_keywords` (`id`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_edd","full_table_name":"wp_apbd_wps_edd","description":"Stores apbd wps edd data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_edd` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `same_site` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `api_endpoint` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `api_public_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `api_token` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `details_btn` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `admin_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `int_order` int unsigned NOT NULL,\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_email_templates","full_table_name":"wp_apbd_wps_email_templates","description":"Stores apbd wps email templates data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_email_templates` (\\n  `k_word` char(3) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `grp` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `title` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'bool(A=Active,I=Inactive)',\\n  `subject` char(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `props` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `content` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`k_word`) USING BTREE,\\n  UNIQUE KEY `email_keyword` (`k_word`) USING BTREE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_fluentcrm","full_table_name":"wp_apbd_wps_fluentcrm","description":"Stores apbd wps fluentcrm data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_fluentcrm` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `same_site` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `webhook_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `list_ids` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `tag_ids` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `contact_status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'P' COMMENT 'drop(P=Pending,S=Subscribed,U=Unsubscribed)',\\n  `trigger_events` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `int_order` int unsigned NOT NULL,\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_imap_api_settings","full_table_name":"wp_apbd_wps_imap_api_settings","description":"Stores apbd wps imap api settings data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_imap_api_settings` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `email` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `connected_email` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `send_from` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'radio(C=Connected,D=Default)',\\n  `from_email` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `use_title` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'bool(Y=Yes,N=No)',\\n  `attach_with` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `choose_category` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `privacy_policy` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `secret_key` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_imap_settings","full_table_name":"wp_apbd_wps_imap_settings","description":"Stores apbd wps imap settings data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_imap_settings` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `wps_host` char(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `wps_port` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `secure_protocol` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `secure_protocol_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'radio(S=SSL,T=TLS)',\\n  `user_email` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `user_password` char(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `send_from` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'radio(U=User,D=Default)',\\n  `from_email` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `use_title` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'bool(Y=Yes,N=No)',\\n  `attach_with` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `choose_category` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `cron_cmd` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_incoming_webhook","full_table_name":"wp_apbd_wps_incoming_webhook","description":"Stores apbd wps incoming webhook data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_incoming_webhook` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `hash` char(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_notes","full_table_name":"wp_apbd_wps_notes","description":"Stores apbd wps notes data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_notes` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `ticket_id` int unsigned NOT NULL,\\n  `entry_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `added_by` int unsigned NOT NULL,\\n  `note_text` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_notification","full_table_name":"wp_apbd_wps_notification","description":"Stores apbd wps notification data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_notification` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` char(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `title` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `msg` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `entry_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'radio(N=Notification,M=message)',\\n  `entry_link` char(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `n_counter` decimal(2,0) unsigned NOT NULL DEFAULT '1',\\n  `is_popup_link` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  `view_time` timestamp NULL DEFAULT NULL,\\n  `entry_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `item_type` char(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `extra_param` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `msg_param` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'radio(A=Active,V=Viewed,D=Deleted)',\\n  PRIMARY KEY (`id`) USING BTREE,\\n  KEY `user_type` (`user_id`) USING BTREE,\\n  KEY `user_id_item` (`user_id`,`item_type`) USING BTREE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_role","full_table_name":"wp_apbd_wps_role","description":"Stores apbd wps role data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_role` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `parent_role` int unsigned NOT NULL DEFAULT '0',\\n  `slug` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `role_description` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `is_editable` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y' COMMENT 'bool(Y=Yes,N=No)',\\n  `is_agent` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  `cat_ids` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'FK(wp_apbd_wps_ticket_category,id,title)',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `slug_ind` (`slug`) USING BTREE\\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_role_access","full_table_name":"wp_apbd_wps_role_access","description":"Stores apbd wps role access data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_role_access` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `role_slug` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'FK(wp_apbd_wps_role,role_slug,name)',\\n  `resource_id` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `role_access` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'bool(Y=Yes,N=No)',\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `role_resource` (`resource_id`,`role_slug`) USING BTREE\\n) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_support_meta","full_table_name":"wp_apbd_wps_support_meta","description":"Stores additional metadata (key-value pairs) for apbd wps support records.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_support_meta` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `item_id` int unsigned NOT NULL,\\n  `item_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'T' COMMENT 'radio(T=Ticket,U=User)',\\n  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `meta_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'T' COMMENT 'radio(D=Default,W=WooCommerce,L=Elite Licenser,E=Envato)',\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"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","columns":[],"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"},{"table_name":"apbd_wps_ticket_assign_rule","full_table_name":"wp_apbd_wps_ticket_assign_rule","description":"Stores apbd wps ticket assign rule data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_ticket_assign_rule` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `cat_ids` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'FK(wp_apbd_wps_ticket_category,id,title)',\\n  `rule_type` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'radio(A=Assign,S=Assign Specific Agent,N=Notifiy,M=Mailbox)',\\n  `rule_id` char(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `rule_extra` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`) USING BTREE\\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_ticket_category","full_table_name":"wp_apbd_wps_ticket_category","description":"Stores apbd wps ticket category data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_ticket_category` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` char(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `parent_category` int unsigned NOT NULL DEFAULT '0' COMMENT 'FK(wp_apbd_wps_ticket_category,id,title)',\\n  `parent_category_path` char(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `show_on` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'B' COMMENT 'radio(B=Both,K=Only Knowledge,T=Only on Ticket)',\\n  `fld_order` int unsigned NOT NULL,\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`) USING BTREE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"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","columns":[],"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"},{"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","columns":[],"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"},{"table_name":"apbd_wps_ticket_tag","full_table_name":"wp_apbd_wps_ticket_tag","description":"Stores apbd wps ticket tag data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_ticket_tag` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` char(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `show_on` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'B' COMMENT 'radio(B=Both,K=Only Knowledge,T=Only on Ticket)',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'A' COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`) USING BTREE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_webhook","full_table_name":"wp_apbd_wps_webhook","description":"Stores apbd wps webhook data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_webhook` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` char(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `url` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'textarea',\\n  `on_tckt_create` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `on_client_create` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `on_tckt_replied` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `on_tckt_closed` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"apbd_wps_woocommerce","full_table_name":"wp_apbd_wps_woocommerce","description":"Stores apbd wps woocommerce data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_apbd_wps_woocommerce` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `same_site` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `store_title` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `store_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `api_consumer_key` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `api_consumer_secret` char(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `verify_email` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `verify_ssl` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `prevent_for_c` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `prevent_for_r` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `wh_ticket` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(Y=Yes,N=No)',\\n  `wh_ticket_cat` int unsigned NOT NULL,\\n  `wh_ticket_title` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `wh_ticket_desc` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `int_order` int unsigned NOT NULL,\\n  `status` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'bool(A=Active,I=Inactive)',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":30}