wp_clientoctopus_user_meta
StaticStores additional metadata (key-value pairs) for clientoctopus user records.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT | NO |
| user_id | INT | NO |
| plan | ENUM('free','pro','agency') | NO |
| ai_usage_count | INT | NO |
| ai_usage_month | VARCHAR(7) | YES |
| billing_cycle_start | DATE | YES |
| billing_cycle_end | DATE | YES |
| stripe_customer_id | VARCHAR(255) | YES |
| team_seats_used | INT | NO |
| storage_used_mb | INT | NO |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_clientoctopus_user_meta ( id INT NOT NULL AUTO_INCREMENT, user_id INT NOT NULL, plan ENUM('free','pro','agency') NOT NULL DEFAULT 'free', ai_usage_count INT NOT NULL DEFAULT 0, ai_usage_month VARCHAR(7) DEFAULT NULL, billing_cycle_start DATE DEFAULT NULL, billing_cycle_end DATE DEFAULT NULL, stripe_customer_id VARCHAR(255) DEFAULT NULL, team_seats_used INT NOT NULL DEFAULT 1, storage_used_mb INT NOT NULL DEFAULT 0, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY user_id (user_id), KEY plan (plan), KEY ai_usage_month (ai_usage_month), KEY billing_cycle_start (billing_cycle_start) ) $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_user_meta`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Client Octopus