Länge des UStId-Feldes bei Kunden/Lieferanten auf 14 erweitern bzw in der Maske darau...

diff --git a/bin/mozilla/ct.pl b/bin/mozilla/ct.pl
index fed9c440226f4e24445b605cb2815edc270a67e6..896bc4aef0ffe7963d307ea4c31e7246e95d677a 100644 (file)
--- 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>
          <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>
           $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 (file)
index 0000000..dd68bcd
--- /dev/null
+++ b/sql/Pg-upgrade2/customer_vendor_ustid_length.sql
@@ -0,0 +1,12 @@
+-- @tag: customer_vendor_ustid_length
+-- @description: Setzt das Feld "ustid" in den Tabellen "customer" und "vendor" auf 14 Zeichen: zwei Zeichen Länderkürzel und bis zu zwölf Zeichen fü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;