X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FCustomer.pm;h=00bdb258f4089fd02a342fc5ca3e716c80dc0320;hb=a5ba22d29e683629d731fc0bfdfb72719e59a0b9;hp=93f63b7ee4ea4a25c29b81582e30f80f24decc65;hpb=f9676efea9ccfa01df2a57dca9c45cc8fde0d09e;p=kivitendo-erp.git

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index 93f63b7ee..00bdb258f 100644
--- a/SL/DB/MetaSetup/Customer.pm
+++ b/SL/DB/MetaSetup/Customer.pm
@@ -11,14 +11,14 @@ __PACKAGE__->meta->setup(
 
   columns => [
     id             => { type => 'integer', not_null => 1, sequence => 'id' },
-    name           => { type => 'varchar', length => 75, not_null => 1 },
+    name           => { type => 'text', not_null => 1 },
     department_1   => { type => 'varchar', length => 75 },
     department_2   => { type => 'varchar', length => 75 },
     street         => { type => 'varchar', length => 75 },
     zipcode        => { type => 'varchar', length => 10 },
     city           => { type => 'varchar', length => 75 },
     country        => { type => 'varchar', length => 75 },
-    contact        => { type => 'varchar', length => 75 },
+    contact        => { type => 'text' },
     phone          => { type => 'varchar', length => 30 },
     fax            => { type => 'varchar', length => 30 },
     homepage       => { type => 'text' },
@@ -33,8 +33,8 @@ __PACKAGE__->meta->setup(
     bcc            => { type => 'text' },
     business_id    => { type => 'integer' },
     taxnumber      => { type => 'text' },
-    account_number => { type => 'varchar', length => 15 },
-    bank_code      => { type => 'varchar', length => 10 },
+    account_number => { type => 'text' },
+    bank_code      => { type => 'text' },
     bank           => { type => 'text' },
     language       => { type => 'varchar', length => 5 },
     datevexport    => { type => 'integer' },
@@ -50,10 +50,10 @@ __PACKAGE__->meta->setup(
     payment_id     => { type => 'integer' },
     taxzone_id     => { type => 'integer', default => '0', not_null => 1 },
     greeting       => { type => 'text' },
-    ustid          => { type => 'varchar', length => 14 },
-    direct_debit   => { type => 'boolean', default => 'false' },
+    ustid          => { type => 'text' },
     iban           => { type => 'varchar', length => 100 },
     bic            => { type => 'varchar', length => 100 },
+    direct_debit   => { type => 'boolean', default => 'false' },
   ],
 
   primary_key_columns => [ 'id' ],