wp_clientoctopus_events

Static

Stores clientoctopus events data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idBIGINT UNSIGNEDNO
proposal_idBIGINT UNSIGNEDNO
event_typeVARCHAR(50)NO
user_ipVARCHAR(45)YES
user_agentVARCHAR(500)YES
timestampDATETIMENO
metadataTEXTYES

CREATE TABLE Statement

CREATE TABLE wp_clientoctopus_events ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, proposal_id BIGINT UNSIGNED NOT NULL, event_type VARCHAR(50) NOT NULL, user_ip VARCHAR(45) DEFAULT NULL, user_agent VARCHAR(500) DEFAULT NULL, timestamp DATETIME NOT NULL, metadata TEXT DEFAULT NULL, PRIMARY KEY (id), KEY proposal_id (proposal_id), KEY event_type (event_type), KEY timestamp (timestamp) ) $charset_collate;" );

Safe to delete?

If you have uninstalled Client Octopus, 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_clientoctopus_events`;

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

Other tables from Client Octopus