wp_block_protocol_entities
StaticStores block protocol entities data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| entity_type_id | text | NO |
| properties | json | YES |
| created_by_id | bigint(20) UNSIGNED | NO |
| created_at | datetime | NO |
| updated_by_id | bigint(20) UNSIGNED | NO |
| updated_at | datetime | NO |
| right_entity_id | char(36) | YES |
| left_to_right_order | int UNSIGNED | YES |
| right_to_left_order | int UNSIGNED | YES |
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.