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/Contact.pm
16 16 
  cp_email       => { type => 'text' },
17 17 
  cp_fax         => { type => 'text' },
18 18 
  cp_gender      => { type => 'character', length => 1 },
19 
  cp_givenname   => { type => 'varchar', length => 75 },
19 
  cp_givenname   => { type => 'text' },
20 20 
  cp_id          => { type => 'integer', not_null => 1, sequence => 'id' },
21 21 
  cp_mobile1     => { type => 'text' },
22 22 
  cp_mobile2     => { type => 'text' },
23 
  cp_name        => { type => 'varchar', length => 75 },
24 
  cp_phone1      => { type => 'varchar', length => 75 },
25 
  cp_phone2      => { type => 'varchar', length => 75 },
26 
  cp_position    => { type => 'varchar', length => 75 },
23 
  cp_name        => { type => 'text' },
24 
  cp_phone1      => { type => 'text' },
25 
  cp_phone2      => { type => 'text' },
26 
  cp_position    => { type => 'text' },
27 27 
  cp_privatemail => { type => 'text' },
28 28 
  cp_privatphone => { type => 'text' },
29 29 
  cp_project     => { type => 'text' },
30 30 
  cp_satfax      => { type => 'text' },
31 31 
  cp_satphone    => { type => 'text' },
32 32 
  cp_street      => { type => 'text' },
33 
  cp_title       => { type => 'varchar', length => 75 },
33 
  cp_title       => { type => 'text' },
34 34 
  cp_zipcode     => { type => 'text' },
35 35 
  itime          => { type => 'timestamp', default => 'now()' },
36 36 
  mtime          => { type => 'timestamp' },
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' ]);


  		












  

    
      SL/DB/MetaSetup/Vendor.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
  
    
  cc               => { type => 'text' },


  		




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


  		




  
  19
  
    
  city             => { type => 'text' },


  		




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


  		




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


  		




  
  21
  
    
  country          => { type => 'text' },


  		




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


  		




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


  		




  24
  24
  
    
  delivery_term_id => { type => 'integer' },


  		




  25
  
  
    
  department_1     => { type => 'varchar', length => 75 },


  		




  26
  
  
    
  department_2     => { type => 'varchar', length => 75 },


  		




  
  25
  
    
  department_1     => { type => 'text' },


  		




  
  26
  
    
  department_2     => { type => 'text' },


  		




  27
  27
  
    
  depositor        => { type => 'text' },


  		




  28
  28
  
    
  direct_debit     => { type => 'boolean', default => 'false' },


  		




  29
  29
  
    
  discount         => { type => 'float', scale => 4 },


  		




  30
  30
  
    
  email            => { type => 'text' },


  		




  31
  
  
    
  fax              => { type => 'varchar', length => 30 },


  		




  
  31
  
    
  fax              => { type => 'text' },


  		




  32
  32
  
    
  greeting         => { type => 'text' },


  		




  33
  33
  
    
  homepage         => { type => 'text' },


  		




  34
  
  
    
  iban             => { type => 'varchar', length => 100 },


  		




  
  34
  
    
  iban             => { type => 'text' },


  		




  35
  35
  
    
  id               => { type => 'integer', not_null => 1, sequence => 'id' },


  		




  36
  36
  
    
  itime            => { type => 'timestamp', default => 'now()' },


  		




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


  		




  ......




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


  		




  44
  44
  
    
  phone            => { type => 'text' },


  		




  45
  45
  
    
  salesman_id      => { type => 'integer' },


  		




  46
  
  
    
  street           => { type => 'varchar', length => 75 },


  		




  
  46
  
    
  street           => { type => 'text' },


  		




  47
  47
  
    
  taxincluded      => { type => 'boolean' },


  		




  48
  48
  
    
  taxnumber        => { type => 'text' },


  		




  49
  49
  
    
  taxzone_id       => { type => 'integer', default => '0', not_null => 1 },


  		




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


  		




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


  		




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


  		




  
  51
  
    
  user_password    => { type => 'text' },


  		




  
  52
  
    
  username         => { type => 'text' },


  		




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


  		




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


  		




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


  		




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


  		




  
  56
  
    
  zipcode          => { type => 'text' },


  		




  57
  57
  
    
);


  		




  58
  58
  
    

  		




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


  		












Auch abrufbar als:  Unified diff