wp_clientoctopus_ai_usage_logs

Static

A logging table that records activity, events, or audit history.

Column Definitions

ColumnTypeNullable
🔑idINTNO
user_idINTNO
proposal_idINTYES
actionVARCHAR(50)YES
tokens_inputINTYES
tokens_outputINTYES
cost_usdDECIMAL(10,4)YES
timestampDATETIMEYES
monthVARCHAR(7)YES

CREATE TABLE Statement

CREATE TABLE wp_clientoctopus_ai_usage_logs ( id INT NOT NULL AUTO_INCREMENT, user_id INT NOT NULL, proposal_id INT DEFAULT NULL, action VARCHAR(50) DEFAULT NULL, tokens_input INT DEFAULT NULL, tokens_output INT DEFAULT NULL, cost_usd DECIMAL(10,4) DEFAULT NULL, timestamp DATETIME DEFAULT NULL, month VARCHAR(7) DEFAULT NULL, PRIMARY KEY (id), KEY user_month (user_id, month), KEY timestamp (timestamp), KEY proposal_id (proposal_id), KEY action (action) ) $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_ai_usage_logs`;

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

Other tables from Client Octopus