psa.BackupsScheduled

Overview

The BackupsScheduled table contains scheduling information related to automated backups.

Column Descriptions

id
obj_id
obj_type
repository
last
period
active
processed
rotation
prefix
email
split_size
suspend
with_content
backup_day
backup_time
content_type

Table Structure
CREATE TABLE `BackupsScheduled` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `obj_id` int(10) unsigned NOT NULL,
  `obj_type` enum('server','reseller','client','domain') NOT NULL,
  `repository` enum('local','ftp') NOT NULL DEFAULT 'local',
  `last` datetime DEFAULT NULL,
  `period` int(10) unsigned NOT NULL,
  `active` enum('true','false') NOT NULL,
  `processed` enum('true','false') NOT NULL,
  `rotation` int(11) NOT NULL DEFAULT '0',
  `prefix` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `split_size` int(10) unsigned NOT NULL DEFAULT '0',
  `suspend` enum('true','false') NOT NULL DEFAULT 'false',
  `with_content` enum('true','false') NOT NULL DEFAULT 'true',
  `backup_day` int(10) unsigned NOT NULL DEFAULT '0',
  `backup_time` time NOT NULL DEFAULT '00:00:00',
  `content_type` enum('backup_content_all_at_domain','backup_content_vhost_only','backup_content_mail_only') DEFAULT 'backup_content_all_at_domain',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

Related documentation

Leave a comment

Your comment