From 3783361d56e20ad3d4cf16c743b7228a97fc297a Mon Sep 17 00:00:00 2001 From: Dominik <info@profi-webdesign.com> Date: Sun, 11 Jan 2015 10:20:48 -0500 Subject: [PATCH] fix sql-update --- install/sql/incremental/upd_0067.sql | 9 +++++---- 1 files changed, 5 insertions(+), 4 deletions(-) diff --git a/install/sql/incremental/upd_0067.sql b/install/sql/incremental/upd_0067.sql index 0ce3d8c..3604460 100644 --- a/install/sql/incremental/upd_0067.sql +++ b/install/sql/incremental/upd_0067.sql @@ -1,6 +1,7 @@ ALTER TABLE `client` - ADD `web_servers` blob NOT NULL DEFAULT '' AFTER `default_webserver`, - ADD `mail_servers` blob NOT NULL DEFAULT '' AFTER `default_mailserver`, - ADD `db_servers` blob NOT NULL DEFAULT '' AFTER `default_dbserver`, - ADD `dns_servers` blob NOT NULL DEFAULT '' AFTER `default_dnsserver`; + ADD `web_servers` blob NOT NULL AFTER `default_webserver`, + ADD `mail_servers` blob NOT NULL AFTER `default_mailserver`, + ADD `db_servers` blob NOT NULL AFTER `default_dbserver`, + ADD `dns_servers` blob NOT NULL AFTER `default_dnsserver`; +UPDATE `client` SET `web_servers` = `default_webserver`, `mail_servers` = `default_mailserver`, `db_servers` = `default_dbserver`, `dns_servers` = `default_dnsserver` WHERE 1; -- Gitblit v1.9.1