Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 57485556

Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt

  • ID 574855561514a864f554776c421e7037196e714d
  • Vorgänger 493bb35d
  • Nachfolger ffbde3ef

DB-Schema-Anpassungen für »Spaltentyp Text anstelle von varchar() in diversen Tabellen«

Unterschiede anzeigen:

SL/DB/MetaSetup/Customer.pm
13 13 
  bank                      => { type => 'text' },
14 14 
  bank_code                 => { type => 'text' },
15 15 
  bcc                       => { type => 'text' },
16 
  bic                       => { type => 'varchar', length => 100 },
16 
  bic                       => { type => 'text' },
17 17 
  business_id               => { type => 'integer' },
18 18 
  c_vendor_id               => { type => 'text' },
19 19 
  cc                        => { type => 'text' },
20 
  city                      => { type => 'varchar', length => 75 },
20 
  city                      => { type => 'text' },
21 21 
  contact                   => { type => 'text' },
22 
  country                   => { type => 'varchar', length => 75 },
22 
  country                   => { type => 'text' },
23 23 
  creditlimit               => { type => 'numeric', default => '0', precision => 15, scale => 5 },
24 24 
  currency_id               => { type => 'integer', not_null => 1 },
25 25 
  customernumber            => { type => 'text' },
26 26 
  delivery_term_id          => { type => 'integer' },
27 
  department_1              => { type => 'varchar', length => 75 },
28 
  department_2              => { type => 'varchar', length => 75 },
27 
  department_1              => { type => 'text' },
28 
  department_2              => { type => 'text' },
29 29 
  depositor                 => { type => 'text' },
30 30 
  direct_debit              => { type => 'boolean', default => 'false' },
31 31 
  discount                  => { type => 'float', scale => 4 },
32 32 
  email                     => { type => 'text' },
33 
  fax                       => { type => 'varchar', length => 30 },
33 
  fax                       => { type => 'text' },
34 34 
  greeting                  => { type => 'text' },
35 35 
  homepage                  => { type => 'text' },
36 36 
  hourly_rate               => { type => 'numeric', precision => 8, scale => 2 },
37 
  iban                      => { type => 'varchar', length => 100 },
37 
  iban                      => { type => 'text' },
38 38 
  id                        => { type => 'integer', not_null => 1, sequence => 'id' },
39 39 
  itime                     => { type => 'timestamp', default => 'now()' },
40 40 
  klass                     => { type => 'integer', default => '0' },
41 
  language                  => { type => 'varchar', length => 5 },
41 
  language                  => { type => 'text' },
42 42 
  language_id               => { type => 'integer' },
43 43 
  mandate_date_of_signature => { type => 'date' },
44 44 
  mandator_id               => { type => 'text' },
......
49 49 
  payment_id                => { type => 'integer' },
50 50 
  phone                     => { type => 'text' },
51 51 
  salesman_id               => { type => 'integer' },
52 
  street                    => { type => 'varchar', length => 75 },
52 
  street                    => { type => 'text' },
53 53 
  taxincluded               => { type => 'boolean' },
54 54 
  taxincluded_checked       => { type => 'boolean' },
55 55 
  taxnumber                 => { type => 'text' },
56 56 
  taxzone_id                => { type => 'integer', default => '0', not_null => 1 },
57 57 
  terms                     => { type => 'integer', default => '0' },
58 58 
  user_password             => { type => 'text' },
59 
  username                  => { type => 'varchar', length => 50 },
59 
  username                  => { type => 'text' },
60 60 
  ustid                     => { type => 'text' },
61 
  zipcode                   => { type => 'varchar', length => 10 },
61 
  zipcode                   => { type => 'text' },
62 62 
);
63 63 

  		




  64
  64
  
    
__PACKAGE__->meta->primary_key_columns([ 'id' ]);


  		












Auch abrufbar als:  Unified diff