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