wp_clientoctopus_booking_calendar_events

Static

Stores clientoctopus booking calendar events data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idBIGINT UNSIGNEDNO
booking_idBIGINT UNSIGNEDNO
providerENUM('google','microsoft','apple')NO
external_event_idVARCHAR(500)NO
created_atDATETIMEYES

CREATE TABLE Statement

CREATE TABLE wp_clientoctopus_booking_calendar_events ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, booking_id BIGINT UNSIGNED NOT NULL, provider ENUM('google','microsoft','apple') NOT NULL, external_event_id VARCHAR(500) NOT NULL, created_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY booking_provider (booking_id, provider), KEY booking_id (booking_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_booking_calendar_events`;

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

Other tables from Client Octopus