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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | 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 |
