From 01c6f9032792898c22b718f100ec88e4d8155ecf Mon Sep 17 00:00:00 2001 From: Marius Burkard <m.burkard@pixcept.de> Date: Wed, 02 Mar 2016 05:19:14 -0500 Subject: [PATCH] - added line to guidelines --- 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