wp_calendarinstances
StaticStores calendarinstances data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INTEGER UNSIGNED | NO |
| calendarid | INTEGER UNSIGNED | NO |
| principaluri | VARBINARY(100) | YES |
| access | TINYINT(1) | NO |
| displayname | VARCHAR(100) | YES |
| uri | VARBINARY(200) | YES |
| description | TEXT | YES |
| calendarorder | INT(11) UNSIGNED | NO |
| calendarcolor | VARBINARY(10) | YES |
| timezone | TEXT | YES |
| transparent | TINYINT(1) | NO |
| share_href | VARBINARY(100) | YES |
| share_displayname | VARCHAR(100) | YES |
| share_invitestatus | TINYINT(1) | NO |
CREATE TABLE Statement
CREATE TABLE calendarinstances ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, calendarid INTEGER UNSIGNED NOT NULL, principaluri VARBINARY(100), access TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1 = owner, 2 = read, 3 = readwrite', displayname VARCHAR(100), uri VARBINARY(200), description TEXT, calendarorder INT(11) UNSIGNED NOT NULL DEFAULT '0', calendarcolor VARBINARY(10), timezone TEXT, transparent TINYINT(1) NOT NULL DEFAULT '0', share_href VARBINARY(100), share_displayname VARCHAR(100), share_invitestatus TINYINT(1) NOT NULL DEFAULT '2' COMMENT '1 = noresponse, 2 = accepted, 3 = declined, 4 = invalid', UNIQUE(principaluri, uri), UNIQUE(calendarid, principaluri), UNIQUE(calendarid, share_href) ) ENGINE
Safe to delete?
If you have uninstalled Backup, Restore and Migrate your sites with XCloner, 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_calendarinstances`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Backup, Restore and Migrate your sites with XCloner