wp_directrelay_approvals

Static

Stores directrelay approvals data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idBIGINT UNSIGNEDNO
ticket_uuidCHAR(36)NO
post_idBIGINT UNSIGNEDYES
token_hashVARCHAR(255)NO
statusVARCHAR(20)NO
payloadLONGTEXTNO
editor_feedbackTEXTYES
reviewer_user_idBIGINT UNSIGNEDYES
expires_atDATETIMENO
created_atDATETIMENO
resolved_atDATETIMEYES

CREATE TABLE Statement

CREATE TABLE wp_directrelay_approvals ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ticket_uuid CHAR(36) NOT NULL, key_id BIGINT UNSIGNED NOT NULL, post_id BIGINT UNSIGNED DEFAULT NULL, token_hash VARCHAR(255) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'pending', payload LONGTEXT NOT NULL, editor_feedback TEXT DEFAULT NULL, reviewer_user_id BIGINT UNSIGNED DEFAULT NULL, expires_at DATETIME NOT NULL, created_at DATETIME NOT NULL, resolved_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY uq_ticket (ticket_uuid), KEY idx_status (status), KEY idx_post (post_id), KEY idx_key (key_id), KEY idx_expires (expires_at) ) $c;" );

Safe to delete?

If you have uninstalled DirectRelay – n8n WordPress Plugin: Workflow Automation, REST API, Webhooks & AI Agents, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_directrelay_approvals`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from DirectRelay – n8n WordPress Plugin: Workflow Automation, REST API, Webhooks & AI Agents