wp_simple_calendarobjects
StaticStores simple calendarobjects data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| uri | FROM | YES |
CREATE TABLE Statement
CREATE TABLE simple_calendarobjects ( * id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, * calendarid INT UNSIGNED NOT NULL, * uri VARBINARY(200) NOT NULL, * calendardata MEDIUMBLOB * ) * * To make this class work, you absolutely need to have the PropertyStorage * plugin enabled. * * @copyright Copyright (C) 2007-2015 fruux GmbH (https://fruux.com/). * @author Evert Pot (http://evertpot.com/) * @license http://sabre.io/license/ Modified BSD License */ class SimplePDO extends AbstractBackend { /** * pdo. * * @var \PDO */ protected $pdo; /** * Creates the backend. */ public function __construct(\PDO $pdo) { $this->pdo = $pdo; } /** * Returns a list of calendars for a principal. * * Every project is an array with the following keys: * * id, a unique id that will be used by other functions to modify the * calendar. This can be the same as the uri or a database key. * * uri. This is just the 'base uri' or 'filename' of the calendar. * * principaluri. The owner of the calendar. Almost always the same as * principalUri passed to this method. * * Furthermore it can contain webdav properties in clark notation. A very * common one is '{DAV:}displayname'. * * Many clients also require: * {urn:ietf:params:xml:ns:caldav}supported-calendar-component-set * For this property, you can just return an instance of * Sabre\CalDAV\Xml\Property\SupportedCalendarComponentSet. * * If you return {http://sabredav.org/ns}read-only and set the value to 1, * ACL will automatically be put in read-only mode. * * @param string $principalUri * * @return array */ public function getCalendarsForUser($principalUri) { // Making fields a comma-delimited list $stmt = $this->pdo->prepare('SELECT id, uri FROM simple_calendars WHERE principaluri = ? ORDER BY id ASC');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_simple_calendarobjects`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Backup, Restore and Migrate your sites with XCloner