11 lines
686 B
SQL
11 lines
686 B
SQL
|
-- MokoSuiteBackup 01.35.00 — SFTP support with key file storage
|
||
|
|
|
||
|
|
ALTER TABLE `#__mokosuitebackup_profiles`
|
||
|
|
ADD COLUMN `sftp_host` VARCHAR(255) NOT NULL DEFAULT '' AFTER `ftp_ssl`,
|
||
|
|
ADD COLUMN `sftp_port` INT(5) UNSIGNED NOT NULL DEFAULT 22 AFTER `sftp_host`,
|
||
|
|
ADD COLUMN `sftp_username` VARCHAR(255) NOT NULL DEFAULT '' AFTER `sftp_port`,
|
||
|
|
ADD COLUMN `sftp_password` VARCHAR(255) NOT NULL DEFAULT '' AFTER `sftp_username`,
|
||
|
|
ADD COLUMN `sftp_key_data` MEDIUMTEXT AFTER `sftp_password`,
|
||
|
|
ADD COLUMN `sftp_passphrase` VARCHAR(255) NOT NULL DEFAULT '' AFTER `sftp_key_data`,
|
||
|
|
ADD COLUMN `sftp_path` VARCHAR(512) NOT NULL DEFAULT '/backups' AFTER `sftp_passphrase`;
|