Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 5d3143fc

Von Bernd Blessmann vor mehr als 12 Jahren hinzugefügt

  • ID 5d3143fc42cc8b1f3f003a1c495ba773ecaad593
  • Vorgänger 822b71c2
  • Nachfolger aeb4f5d5

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

Unterschiede anzeigen:

SL/Controller/CsvImport/CustomerVendor.pm
182 182 
           city           => 75,
183 183 
           country        => 75,
184 184 
           contact        => 75,
185 
           phone          => 30,
186 185 
           fax            => 30,
187 186 
           account_number => 15,
188 187 
           bank_code      => 10,
SL/DB/MetaSetup/Customer.pm
19 19 
    city           => { type => 'varchar', length => 75 },
20 20 
    country        => { type => 'varchar', length => 75 },
21 21 
    contact        => { type => 'text' },
22 
    phone          => { type => 'varchar', length => 30 },
22 
    phone          => { type => 'text' },
23 23 
    fax            => { type => 'varchar', length => 30 },
24 24 
    homepage       => { type => 'text' },
25 25 
    email          => { type => 'text' },
SL/DB/MetaSetup/Vendor.pm
19 19 
    city           => { type => 'varchar', length => 75 },
20 20 
    country        => { type => 'varchar', length => 75 },
21 21 
    contact        => { type => 'varchar', length => 75 },
22 
    phone          => { type => 'varchar', length => 30 },
22 
    phone          => { type => 'text' },
23 23 
    fax            => { type => 'varchar', length => 30 },
24 24 
    homepage       => { type => 'text' },
25 25 
    email          => { type => 'text' },
sql/Pg-upgrade2/customer_vendor_phone_no_limits.sql
1 
-- @tag: customer_vendor_phone_no_limits
2 
-- @description: Keine Längenbeschränkung für Spalte phone in den Tabellen customer und vendor.
3 
-- @depends: release_2_7_0
4 
-- @charset: utf-8
5 

  		




  
  6
  
    
ALTER TABLE customer ALTER COLUMN phone TYPE text;


  		




  
  7
  
    
ALTER TABLE vendor   ALTER COLUMN phone TYPE text;


  		












  

    
      templates/webpages/ct/form_header.html
    
  





  131
  131
  
    

  		




  132
  132
  
    
     <tr>


  		




  133
  133
  
    
      <th align="right" nowrap>[% 'Phone' | $T8 %]</th>


  		




  134
  
  
    
      <td><input name="phone" size="30" maxlength="30" value="[% HTML.escape(phone) %]"></td>


  		




  
  134
  
    
      <td><input name="phone" size="30" value="[% HTML.escape(phone) %]"></td>


  		




  135
  135
  
    
     </tr>


  		




  136
  136
  
    

  		




  137
  137
  
    
     <tr>


  		












Auch abrufbar als:  Unified diff