From f7c5820cdac7e13d95586b9ff2775ca5198118c6 Mon Sep 17 00:00:00 2001
From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Sat, 13 Jan 2007 10:58:28 +0000
Subject: [PATCH] =?utf8?q?L=C3=A4nge=20des=20UStId-Feldes=20bei=20Kunden/L?=
 =?utf8?q?ieferanten=20auf=2014=20erweitern=20bzw=20in=20der=20Maske=20dar?=
 =?utf8?q?auf=20beschr=C3=A4nken=20(zwei=20Zeichen=20L=C3=A4nderk=C3=BCrze?=
 =?utf8?q?l=20+=20bis=20zu=2012=20Zeichen=20f=C3=BCr=20die=20Nummer).?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 bin/mozilla/ct.pl                                |  2 +-
 sql/Pg-upgrade2/customer_vendor_ustid_length.sql | 12 ++++++++++++
 2 files changed, 13 insertions(+), 1 deletion(-)
 create mode 100644 sql/Pg-upgrade2/customer_vendor_ustid_length.sql

diff --git a/bin/mozilla/ct.pl b/bin/mozilla/ct.pl
index fed9c4402..896bc4aef 100644
--- a/bin/mozilla/ct.pl
+++ b/bin/mozilla/ct.pl
@@ -964,7 +964,7 @@ sub form_header {
 	  <th align=right>| . $locale->text('Tax Number / SSN') . qq|</th>
 	  <td><input name=taxnumber size=20 value="$form->{taxnumber}"></td>
           <th align=right>| . $locale->text('USt-IdNr.') . qq|</th>
-	  <td><input name="ustid" maxlength="12" size="20" value="$form->{ustid}"></td>
+	  <td><input name="ustid" maxlength="14" size="20" value="$form->{ustid}"></td>
           $customer
 	</tr>
         <tr>
diff --git a/sql/Pg-upgrade2/customer_vendor_ustid_length.sql b/sql/Pg-upgrade2/customer_vendor_ustid_length.sql
new file mode 100644
index 000000000..dd68bcd20
--- /dev/null
+++ b/sql/Pg-upgrade2/customer_vendor_ustid_length.sql
@@ -0,0 +1,12 @@
+-- @tag: customer_vendor_ustid_length
+-- @description: Setzt das Feld &quot;ustid&quot; in den Tabellen &quot;customer&quot; und &quot;vendor&quot; auf 14 Zeichen: zwei Zeichen L&auml;nderk&uuml;rzel und bis zu zw&ouml;lf Zeichen f&uuml;r die Nummer.
+-- @depends:
+ALTER TABLE customer ADD COLUMN tmp varchar(14);
+UPDATE customer SET tmp = ustid;
+ALTER TABLE customer DROP COLUMN ustid;
+ALTER TABLE customer RENAME tmp TO ustid;
+
+ALTER TABLE vendor ADD COLUMN tmp varchar(14);
+UPDATE vendor SET tmp = ustid;
+ALTER TABLE vendor DROP COLUMN ustid;
+ALTER TABLE vendor RENAME tmp TO ustid;
-- 
2.20.1