{"table_name":"block_protocol_entities","full_table_name":"wp_block_protocol_entities","description":"Stores block protocol entities data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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');","columns":[{"name":"entity_type_id","type":"text","nullable":false,"primary_key":false},{"name":"properties","type":"json","nullable":true,"primary_key":false},{"name":"created_by_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_by_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"right_entity_id","type":"char(36)","nullable":true,"primary_key":false},{"name":"left_to_right_order","type":"int UNSIGNED","nullable":true,"primary_key":false},{"name":"right_to_left_order","type":"int UNSIGNED","nullable":true,"primary_key":false}],"plugin":{"slug":"blockprotocol","name":"Block Protocol","active_installs":10,"version":"0.0.9","wp_org_url":"https://wordpress.org/plugins/blockprotocol/"}}