{"slug":"xcloner-backup-and-restore","name":"Backup, Restore and Migrate your sites with XCloner","description":"XCloner is a backup plugin that allows you to safely back up and restore your WordPress sites. You can send site backups to SFTP, Dropbox, Amazon, Goo …","author":"watchful","active_installs":10000,"version":"4.8.6","wp_org_url":"https://wordpress.org/plugins/xcloner-backup-and-restore/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"addressbooks","full_table_name":"wp_addressbooks","description":"Stores addressbooks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE addressbooks (\\n id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\\n principaluri VARCHAR(255),\\n displayname VARCHAR(255),\\n uri VARCHAR(200),\\n description TEXT,\\n synctoken INT(11) UNSIGNED NOT NULL DEFAULT '1',\\n UNIQUE(principaluri, uri)\\n ) ENGINE"},{"table_name":"cache","full_table_name":"wp_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS `cache` (\\n\\t\\t\\t\\t`key` varchar(500) not null,\\n\\t\\t\\t\\t`value` text not null,\\n\\t\\t\\t\\t`expiration` integer(11),\\n\\t\\t\\t\\tPRIMARY KEY (`key`)\\n\\t\\t\\t)\\n\\t\\t\");"},{"table_name":"calendarinstances","full_table_name":"wp_calendarinstances","description":"Stores calendarinstances data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER UNSIGNED","nullable":false,"primary_key":true},{"name":"calendarid","type":"INTEGER UNSIGNED","nullable":false,"primary_key":false},{"name":"principaluri","type":"VARBINARY(100)","nullable":true,"primary_key":false},{"name":"access","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"displayname","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"uri","type":"VARBINARY(200)","nullable":true,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"calendarorder","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"calendarcolor","type":"VARBINARY(10)","nullable":true,"primary_key":false},{"name":"timezone","type":"TEXT","nullable":true,"primary_key":false},{"name":"transparent","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"share_href","type":"VARBINARY(100)","nullable":true,"primary_key":false},{"name":"share_displayname","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"share_invitestatus","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"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"},{"table_name":"calendars","full_table_name":"wp_calendars","description":"Stores calendars data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER UNSIGNED","nullable":false,"primary_key":true},{"name":"synctoken","type":"INTEGER UNSIGNED","nullable":false,"primary_key":false},{"name":"components","type":"VARBINARY(21)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE calendars ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, synctoken INTEGER UNSIGNED NOT NULL DEFAULT '1', components VARBINARY(21) ) ENGINE"},{"table_name":"calendarsubscriptions","full_table_name":"wp_calendarsubscriptions","description":"Stores calendarsubscriptions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE calendarsubscriptions (\\n id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\\n uri VARCHAR(200) NOT NULL,\\n principaluri VARCHAR(100) NOT NULL,\\n source TEXT,\\n displayname VARCHAR(100),\\n refreshrate VARCHAR(10),\\n calendarorder INT(11) UNSIGNED NOT NULL DEFAULT '0',\\n calendarcolor VARCHAR(10),\\n striptodos TINYINT(1) NULL,\\n stripalarms TINYINT(1) NULL,\\n stripattachments TINYINT(1) NULL,\\n lastmodified INT(11) UNSIGNED,\\n UNIQUE(principaluri, uri)\\n);"},{"table_name":"cards","full_table_name":"wp_cards","description":"Stores cards data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"addressbookid","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"carddata","type":"MEDIUMBLOB","nullable":true,"primary_key":false},{"name":"uri","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"lastmodified","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false},{"name":"etag","type":"VARBINARY(32)","nullable":true,"primary_key":false},{"name":"size","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE cards ( id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, addressbookid INT(11) UNSIGNED NOT NULL, carddata MEDIUMBLOB, uri VARCHAR(200), lastmodified INT(11) UNSIGNED, etag VARBINARY(32), size INT(11) UNSIGNED NOT NULL ) ENGINE"},{"table_name":"completed","full_table_name":"wp_completed","description":"Stores completed data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS `completed` (\\n\\t\\t\\t\\t`path` varchar(500) not null,\\n\\t\\t\\t\\t`expiration` integer(11),\\n\\t\\t\\t\\tPRIMARY KEY (`path`)\\n\\t\\t\\t)\\n\\t\\t\");"},{"table_name":"propertystorage","full_table_name":"wp_propertystorage","description":"Stores propertystorage data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"path","type":"VARBINARY(1024)","nullable":false,"primary_key":false},{"name":"name","type":"VARBINARY(100)","nullable":false,"primary_key":false},{"name":"valuetype","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"value","type":"MEDIUMBLOB","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE propertystorage ( id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, path VARBINARY(1024) NOT NULL, name VARBINARY(100) NOT NULL, valuetype INT UNSIGNED, value MEDIUMBLOB );"},{"table_name":"schedulingobjects","full_table_name":"wp_schedulingobjects","description":"Stores schedulingobjects data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"principaluri","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"calendardata","type":"MEDIUMBLOB","nullable":true,"primary_key":false},{"name":"uri","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"lastmodified","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false},{"name":"etag","type":"VARCHAR(32)","nullable":true,"primary_key":false},{"name":"size","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS schedulingobjects ( id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, principaluri VARCHAR(255), calendardata MEDIUMBLOB, uri VARCHAR(200), lastmodified INT(11) UNSIGNED, etag VARCHAR(32), size INT(11) UNSIGNED NOT NULL ) ENGINE"},{"table_name":"simple_calendarobjects","full_table_name":"wp_simple_calendarobjects","description":"Stores simple calendarobjects data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"uri","type":"FROM","nullable":true,"primary_key":false}],"create_sql":"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');"},{"table_name":"simple_calendars","full_table_name":"wp_simple_calendars","description":"Stores simple calendars data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE simple_calendars ( * id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, * uri VARBINARY(200) NOT NULL, * principaluri VARBINARY(200) NOT NULL * );"},{"table_name":"xcloner_scheduler","full_table_name":"wp_xcloner_scheduler","description":"Stores xcloner scheduler data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":12}