Lx-Office ERP, branch master updated. release-2.7.0-172-g5d3143f

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Lx-Office ERP".

The branch master has been updated
       via  5d3143fc42cc8b1f3f003a1c495ba773ecaad593 (commit)
      from  822b71c22ca6dbe4fe024babaf6a8f0be8d3c4e9 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 5d3143fc42cc8b1f3f003a1c495ba773ecaad593
Author: Bernd Blessmann <bibi <at> online.de>
Date:   Fri Jul 27 10:52:35 2012 +0200

    Keine Längenbeschränkung für Spalte phone in den Tabellen customer und vendor.

-----------------------------------------------------------------------

Summary of changes:
 SL/Controller/CsvImport/CustomerVendor.pm          |    1 -
 SL/DB/MetaSetup/Customer.pm                        |    2 +-
 SL/DB/MetaSetup/Vendor.pm                          |    2 +-
 .../customer_vendor_phone_no_limits.sql            |    7 +++++++
 templates/webpages/ct/form_header.html             |    2 +-
 5 files changed, 10 insertions(+), 4 deletions(-)
 create mode 100644 sql/Pg-upgrade2/customer_vendor_phone_no_limits.sql

Full change list:
diff --git a/SL/Controller/CsvImport/CustomerVendor.pm b/SL/Controller/CsvImport/CustomerVendor.pm
index c0d9ca2..02d8483 100644
--- a/SL/Controller/CsvImport/CustomerVendor.pm
+++ b/SL/Controller/CsvImport/CustomerVendor.pm
 <at>  <at>  -182,7 +182,6  <at>  <at>  sub field_lengths {
            city           => 75,
            country        => 75,
            contact        => 75,
-           phone          => 30,
            fax            => 30,
            account_number => 15,
            bank_code      => 10,
diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index 8735268..722ff9d 100644
--- a/SL/DB/MetaSetup/Customer.pm
+++ b/SL/DB/MetaSetup/Customer.pm
 <at>  <at>  -19,7 +19,7  <at>  <at>  __PACKAGE__->meta->setup(
     city           => { type => 'varchar', length => 75 },
     country        => { type => 'varchar', length => 75 },
     contact        => { type => 'text' },
-    phone          => { type => 'varchar', length => 30 },
+    phone          => { type => 'text' },
     fax            => { type => 'varchar', length => 30 },
     homepage       => { type => 'text' },
     email          => { type => 'text' },
diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm
index 6511ea2..387b2d8 100644
--- a/SL/DB/MetaSetup/Vendor.pm
+++ b/SL/DB/MetaSetup/Vendor.pm
 <at>  <at>  -19,7 +19,7  <at>  <at>  __PACKAGE__->meta->setup(
     city           => { type => 'varchar', length => 75 },
     country        => { type => 'varchar', length => 75 },
     contact        => { type => 'varchar', length => 75 },
-    phone          => { type => 'varchar', length => 30 },
+    phone          => { type => 'text' },
     fax            => { type => 'varchar', length => 30 },
     homepage       => { type => 'text' },
     email          => { type => 'text' },
diff --git a/sql/Pg-upgrade2/customer_vendor_phone_no_limits.sql b/sql/Pg-upgrade2/customer_vendor_phone_no_limits.sql
new file mode 100644
index 0000000..30998ea
--- /dev/null
+++ b/sql/Pg-upgrade2/customer_vendor_phone_no_limits.sql
 <at>  <at>  -0,0 +1,7  <at>  <at> 
+--  <at> tag: customer_vendor_phone_no_limits
+--  <at> description: Keine Längenbeschränkung für Spalte phone in den Tabellen customer und vendor.
+--  <at> depends: release_2_7_0
+--  <at> charset: utf-8
+
+ALTER TABLE customer ALTER COLUMN phone TYPE text;
+ALTER TABLE vendor   ALTER COLUMN phone TYPE text;
diff --git a/templates/webpages/ct/form_header.html b/templates/webpages/ct/form_header.html
index 8263d87..bdf22df 100644
--- a/templates/webpages/ct/form_header.html
+++ b/templates/webpages/ct/form_header.html
 <at>  <at>  -131,7 +131,7  <at>  <at> 

      <tr>
       <th align="right" nowrap>[% 'Phone' | $T8 %]</th>
-      <td><input name="phone" size="30" maxlength="30" value="[% HTML.escape(phone) %]"></td>
+      <td><input name="phone" size="30" value="[% HTML.escape(phone) %]"></td>
      </tr>

      <tr>

hooks/post-receive
--

-- 
Lx-Office ERP

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Lx-office-svn mailing list
Lx-office-svn <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/lx-office-svn