From f757771128c7c9414a35ac2743ff123934a8b211 Mon Sep 17 00:00:00 2001 From: Falko Timme <ft@falkotimme.com> Date: Fri, 09 Jan 2015 10:39:04 -0500 Subject: [PATCH] - Made sure SQL backups from servers that differ from the server where the website is on can be restored. A download of the backup is not possible in such a case, therefore I hide the "Download" button. --- install/sql/incremental/upd_dev_collection.sql | 7 +++++++ 1 files changed, 7 insertions(+), 0 deletions(-) diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql index 68cb3ba..e60ae02 100644 --- a/install/sql/incremental/upd_dev_collection.sql +++ b/install/sql/incremental/upd_dev_collection.sql @@ -1,3 +1,10 @@ ALTER TABLE `mail_user` CHANGE `uid` `uid` int(11) NOT NULL DEFAULT '5000', CHANGE `gid` `gid` int(11) NOT NULL DEFAULT '5000'; + +ALTER TABLE `client_template` ADD `default_mailserver` INT(11) NOT NULL DEFAULT 1; +ALTER TABLE `client_template` ADD `default_webserver` INT(11) NOT NULL DEFAULT 1; +ALTER TABLE `client_template` ADD `default_dnsserver` INT(11) NOT NULL DEFAULT 1; +ALTER TABLE `client_template` ADD `default_slave_dnsserver` INT(11) NOT NULL DEFAULT 1; +ALTER TABLE `client_template` ADD `default_dbserver` INT(11) NOT NULL DEFAULT 1; +ALTER TABLE `client` ADD `contact_firstname` VARCHAR( 64 ) NOT NULL DEFAULT '' AFTER `gender`; -- Gitblit v1.9.1