From 4e2d727aacc238b86b91bad012f8f42c8c47d31d Mon Sep 17 00:00:00 2001 From: Florian Schaal <florian@schaal-24.de> Date: Mon, 22 Sep 2014 09:06:10 -0400 Subject: [PATCH] corrected upd_0078.sql --- 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