wp_clientoctopus_calendar_connections

Static

Stores clientoctopus calendar connections data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idBIGINT UNSIGNEDNO
owner_idBIGINT UNSIGNEDNO
providerENUM('google','microsoft','apple')NO
statusENUM('connected','disconnected')NO
account_labelVARCHAR(255)YES
apple_usernameVARCHAR(255)YES
apple_password_encTEXTYES
provider_metaTEXTYES
last_synced_atDATETIMEYES
created_atDATETIMEYES
updated_atDATETIMEYES

CREATE TABLE Statement

CREATE TABLE wp_clientoctopus_calendar_connections ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, owner_id BIGINT UNSIGNED NOT NULL, provider ENUM('google','microsoft','apple') NOT NULL, status ENUM('connected','disconnected') NOT NULL DEFAULT 'connected', account_label VARCHAR(255) DEFAULT NULL, apple_username VARCHAR(255) DEFAULT NULL, apple_password_enc TEXT DEFAULT NULL, provider_meta TEXT DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY owner_provider (owner_id, provider), KEY owner_id (owner_id) ) $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_calendar_connections`;

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

Other tables from Client Octopus