wp_clientoctopus_recurring_profiles
StaticStores clientoctopus recurring profiles data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| owner_id | BIGINT UNSIGNED | NO |
| client_id | BIGINT UNSIGNED | NO |
| title | VARCHAR(255) | NO |
| line_items | LONGTEXT | YES |
| currency | VARCHAR(3) | NO |
| discount_type | ENUM('percentage','fixed') | NO |
| discount_value | DECIMAL(10,2) | NO |
| vat_pct | DECIMAL(5,2) | NO |
| frequency | ENUM('weekly','monthly','quarterly','yearly') | NO |
| start_date | DATE | NO |
| end_date | DATE | YES |
| max_occurrences | SMALLINT UNSIGNED | YES |
| occurrences_sent | SMALLINT UNSIGNED | NO |
| next_run_date | DATE | NO |
| billing_mode | ENUM('manual','auto_charge') | NO |
| status | ENUM('active','paused','cancelled') | NO |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_clientoctopus_recurring_profiles ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, owner_id BIGINT UNSIGNED NOT NULL, client_id BIGINT UNSIGNED NOT NULL, title VARCHAR(255) NOT NULL DEFAULT '', line_items LONGTEXT DEFAULT NULL, currency VARCHAR(3) NOT NULL DEFAULT 'GBP', discount_type ENUM('percentage','fixed') NOT NULL DEFAULT 'percentage', discount_value DECIMAL(10,2) NOT NULL DEFAULT 0, vat_pct DECIMAL(5,2) NOT NULL DEFAULT 0, frequency ENUM('weekly','monthly','quarterly','yearly') NOT NULL DEFAULT 'monthly', start_date DATE NOT NULL, end_date DATE DEFAULT NULL, max_occurrences SMALLINT UNSIGNED DEFAULT NULL, occurrences_sent SMALLINT UNSIGNED NOT NULL DEFAULT 0, next_run_date DATE NOT NULL, billing_mode ENUM('manual','auto_charge') NOT NULL DEFAULT 'manual', status ENUM('active','paused','cancelled') NOT NULL DEFAULT 'active', created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY owner_id (owner_id), KEY client_id (client_id), KEY next_run_date (next_run_date), KEY status (status) ) $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_recurring_profiles`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Client Octopus