From e3133e844ed9d98b28fce3fd3fb00ada0c2abaf8 Mon Sep 17 00:00:00 2001 From: Till Brehm <tbrehm@ispconfig.org> Date: Wed, 09 Jul 2014 14:34:21 -0400 Subject: [PATCH] FS#3558: Add firstname field for clients and resellers. --- install/sql/incremental/upd_dev_collection.sql | 10 ++++++++++ 1 files changed, 10 insertions(+), 0 deletions(-) diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql index e69de29..e60ae02 100644 --- a/install/sql/incremental/upd_dev_collection.sql +++ b/install/sql/incremental/upd_dev_collection.sql @@ -0,0 +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