From: Jan Büren <jan@lx-office-hosting.de>
Date: Wed, 11 Jan 2012 14:30:35 +0000 (+0100)
Subject: Merge branch 'master' of vc.linet-services.de:public/lx-office-erp
X-Git-Tag: release-2.7.0beta1~61^2~1^2
X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/commitdiff_plain/6eee850259ed40762406faecaa0cd302bcdf10c6?hp=c584ce44b987f707d9a444926bb8e1c74993d104

Merge branch 'master' of vc.linet-services.de:public/lx-office-erp
---

diff --git a/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql b/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql
new file mode 100644
index 000000000..725e374a7
--- /dev/null
+++ b/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql
@@ -0,0 +1,8 @@
+-- @tag: warehouse_alter_chargenumber
+-- @description: Chargennummber von NULL auf '' aktualisieren
+-- @depends: release_2_6_3
+-- @charset: utf-8
+UPDATE inventory set chargenumber='' where chargenumber IS NULL;
+ALTER TABLE inventory ALTER COLUMN chargenumber SET NOT NULL;
+ALTER TABLE inventory ALTER COLUMN chargenumber SET  default '';
+