wp_block_protocol_entities

Static

Stores block protocol entities data created by this plugin.

Column Definitions

ColumnTypeNullable
entity_type_idtextNO
propertiesjsonYES
created_by_idbigint(20) UNSIGNEDNO
created_atdatetimeNO
updated_by_idbigint(20) UNSIGNEDNO
updated_atdatetimeNO
right_entity_idchar(36)YES
left_to_right_orderint UNSIGNEDYES
right_to_left_orderint UNSIGNEDYES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_block_protocol_entities` ( -- common data across all entities entity_id char(36) NOT NULL, entity_type_id text NOT NULL, properties json, created_by_id bigint(20) UNSIGNED NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_by_id bigint(20) UNSIGNED NOT NULL, updated_at datetime NOT NULL, -- metadata for entities which represent links only left_entity_id char(36) REFERENCES `wp_block_protocol_entities` (entity_id) ON DELETE CASCADE, right_entity_id char(36) REFERENCES `wp_block_protocol_entities` (entity_id) ON DELETE CASCADE, left_to_right_order int UNSIGNED, right_to_left_order int UNSIGNED, PRIMARY KEY (entity_id), INDEX (left_entity_id), INDEX (right_entity_id), INDEX (created_at), INDEX (updated_at) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

Safe to delete?

If you have uninstalled Block Protocol, 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_block_protocol_entities`;

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