Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision c9370086

Von Kivitendo Admin vor mehr als 10 Jahren hinzugefügt

  • ID c9370086d4e1dd6051847ecdd7a0c85bbf9fc2a1
  • Vorgänger 293c7b64
  • Nachfolger 00ad7b56

Lange Datenbankfelder bei bestimmten Lieferantenfeldern

Analog zu Commit 72ad92fd die Feldlänge bei bestimmten Datenbankfelder
erhöht (vorher varchar, jetzt text)
account_number bank_code ustid name contact

Unterschiede anzeigen:

SL/DB/MetaSetup/Vendor.pm
9 9 
__PACKAGE__->meta->table('vendor');
10 10 

  		




  11
  11
  
    
__PACKAGE__->meta->columns(


  		




  12
  
  
    
  account_number   => { type => 'varchar', length => 15 },


  		




  
  12
  
    
  account_number   => { type => 'text' },


  		




  13
  13
  
    
  bank             => { type => 'text' },


  		




  14
  
  
    
  bank_code        => { type => 'varchar', length => 10 },


  		




  
  14
  
    
  bank_code        => { type => 'text' },


  		




  15
  15
  
    
  bcc              => { type => 'text' },


  		




  16
  16
  
    
  bic              => { type => 'varchar', length => 100 },


  		




  17
  17
  
    
  business_id      => { type => 'integer' },


  		




  18
  18
  
    
  cc               => { type => 'text' },


  		




  19
  19
  
    
  city             => { type => 'varchar', length => 75 },


  		




  20
  
  
    
  contact          => { type => 'varchar', length => 75 },


  		




  
  20
  
    
  contact          => { type => 'text' },


  		




  21
  21
  
    
  country          => { type => 'varchar', length => 75 },


  		




  22
  22
  
    
  creditlimit      => { type => 'numeric', precision => 15, scale => 5 },


  		




  23
  23
  
    
  currency_id      => { type => 'integer', not_null => 1 },


  		




  ......




  37
  37
  
    
  language         => { type => 'varchar', length => 5 },


  		




  38
  38
  
    
  language_id      => { type => 'integer' },


  		




  39
  39
  
    
  mtime            => { type => 'timestamp' },


  		




  40
  
  
    
  name             => { type => 'varchar', length => 75, not_null => 1 },


  		




  
  40
  
    
  name             => { type => 'text', not_null => 1 },


  		




  41
  41
  
    
  notes            => { type => 'text' },


  		




  42
  42
  
    
  obsolete         => { type => 'boolean', default => 'false' },


  		




  43
  43
  
    
  payment_id       => { type => 'integer' },


  		




  ......




  50
  50
  
    
  terms            => { type => 'integer', default => '0' },


  		




  51
  51
  
    
  user_password    => { type => 'varchar', length => 12 },


  		




  52
  52
  
    
  username         => { type => 'varchar', length => 50 },


  		




  53
  
  
    
  ustid            => { type => 'varchar', length => 14 },


  		




  
  53
  
    
  ustid            => { type => 'text' },


  		




  54
  54
  
    
  v_customer_id    => { type => 'text' },


  		




  55
  55
  
    
  vendornumber     => { type => 'text' },


  		




  56
  56
  
    
  zipcode          => { type => 'varchar', length => 10 },


  		












  

    
      sql/Pg-upgrade2/vendor_long_entries.sql
    
  





  
  1
  
    
-- @tag: vendor_long_entries


  		




  
  2
  
    
-- @description: Lange Spalten für Lieferantentabelle


  		




  
  3
  
    
-- @depends: release_3_1_0


  		




  
  4
  
    

  		




  
  5
  
    
ALTER TABLE vendor ALTER COLUMN account_number TYPE text;


  		




  
  6
  
    
ALTER TABLE vendor ALTER COLUMN bank_code TYPE text;


  		




  
  7
  
    
ALTER TABLE vendor ALTER COLUMN ustid TYPE text;


  		




  
  8
  
    
ALTER TABLE vendor ALTER COLUMN name TYPE text;


  		




  
  9
  
    
ALTER TABLE vendor ALTER COLUMN contact TYPE text;


  		




  
  10
  
    

  		












Auch abrufbar als:  Unified diff