From 0269573d9f6d3f54f22ca957d953fa8de256ba2f Mon Sep 17 00:00:00 2001 From: Florian Schaal <florian@schaal-24.de> Date: Tue, 04 Nov 2014 02:26:31 -0500 Subject: [PATCH] updated db-queries to the new query form --- install/sql/incremental/upd_dev_collection.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql index b5c72be..e60ae02 100644 --- a/install/sql/incremental/upd_dev_collection.sql +++ b/install/sql/incremental/upd_dev_collection.sql @@ -1,5 +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