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' },

Auch abrufbar als: Unified diff