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_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