psa.BackupsScheduled
Overview
The BackupsScheduled table contains scheduling information about automated backup jobs.
Column Descriptions
id – primary key that is automatically incremented
obj_id – links to id in domains or clients tables, depending on obj_type
obj_type – the type of object being backed up; can be server, client, or domain
repository – either local or ftp
last – timestamp of the last time the backup ran
period – seconds between backup runs
active – true if the backups are enabled, otherwise false
processed – currently unknown
files – limit on the number of backups to keep on the server
prefix – prefix string added to the backup filenames
email – sends the backups to e-mail account if one is present
objects – how many objects are currently being stored
split_size – file size to split the backup files
Table Structure
CREATE TABLE `BackupsScheduled` ( `id` int(10) unsigned NOT NULL auto_increment, `obj_id` int(10) unsigned NOT NULL default '0', `obj_type` enum('server','client','domain') NOT NULL default 'server', `repository` enum('local','ftp') NOT NULL default 'local', `last` datetime NOT NULL default '0000-00-00 00:00:00', `period` int(10) unsigned NOT NULL default '0', `active` enum('true','false') NOT NULL default 'true', `processed` enum('true','false') NOT NULL default 'true', `files` int(11) NOT NULL default '0', `prefix` varchar(255) character set utf8 default NULL, `email` varchar(255) character set utf8 default NULL, `objects` int(10) unsigned default NULL, `split_size` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 |