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

[kivitendo-erp.git] / SL / DB / MetaSetup / Contact.pm

diff --git a/SL/DB/MetaSetup/Contact.pm b/SL/DB/MetaSetup/Contact.pm
index 8a749bb..7f82175 100644 (file)
--- a/SL/DB/MetaSetup/Contact.pm
+++ b/SL/DB/MetaSetup/Contact.pm
@@ -16,21 +16,21 @@ __PACKAGE__->meta->columns(
   cp_email       => { type => 'text' },
   cp_fax         => { type => 'text' },
   cp_gender      => { type => 'character', length => 1 },
-  cp_givenname   => { type => 'varchar', length => 75 },
+  cp_givenname   => { type => 'text' },
   cp_id          => { type => 'integer', not_null => 1, sequence => 'id' },
   cp_mobile1     => { type => 'text' },
   cp_mobile2     => { type => 'text' },
-  cp_name        => { type => 'varchar', length => 75 },
-  cp_phone1      => { type => 'varchar', length => 75 },
-  cp_phone2      => { type => 'varchar', length => 75 },
-  cp_position    => { type => 'varchar', length => 75 },
+  cp_name        => { type => 'text' },
+  cp_phone1      => { type => 'text' },
+  cp_phone2      => { type => 'text' },
+  cp_position    => { type => 'text' },
   cp_privatemail => { type => 'text' },
   cp_privatphone => { type => 'text' },
   cp_project     => { type => 'text' },
   cp_satfax      => { type => 'text' },
   cp_satphone    => { type => 'text' },
   cp_street      => { type => 'text' },
-  cp_title       => { type => 'varchar', length => 75 },
+  cp_title       => { type => 'text' },
   cp_zipcode     => { type => 'text' },
   itime          => { type => 'timestamp', default => 'now()' },
   mtime          => { type => 'timestamp' },