X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/a3511b2d8974c72e4d26b2d85c5cf1cd711ccb6f..13a7879c8ccbd967869e2eeeae76065c6cb4c4f0:/SL/DB/MetaSetup/Vendor.pm diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm index 067e21ada..ef3f37f48 100644 --- a/SL/DB/MetaSetup/Vendor.pm +++ b/SL/DB/MetaSetup/Vendor.pm @@ -9,15 +9,15 @@ use base qw(SL::DB::Object); __PACKAGE__->meta->table('vendor'); __PACKAGE__->meta->columns( - account_number => { type => 'varchar', length => 15 }, + account_number => { type => 'text' }, bank => { type => 'text' }, - bank_code => { type => 'varchar', length => 10 }, + bank_code => { type => 'text' }, bcc => { type => 'text' }, bic => { type => 'varchar', length => 100 }, business_id => { type => 'integer' }, cc => { type => 'text' }, city => { type => 'varchar', length => 75 }, - contact => { type => 'varchar', length => 75 }, + contact => { type => 'text' }, country => { type => 'varchar', length => 75 }, creditlimit => { type => 'numeric', precision => 15, scale => 5 }, currency_id => { type => 'integer', not_null => 1 }, @@ -37,7 +37,7 @@ __PACKAGE__->meta->columns( language => { type => 'varchar', length => 5 }, language_id => { type => 'integer' }, mtime => { type => 'timestamp' }, - name => { type => 'varchar', length => 75, not_null => 1 }, + name => { type => 'text', not_null => 1 }, notes => { type => 'text' }, obsolete => { type => 'boolean', default => 'false' }, payment_id => { type => 'integer' }, @@ -50,7 +50,7 @@ __PACKAGE__->meta->columns( terms => { type => 'integer', default => '0' }, user_password => { type => 'varchar', length => 12 }, username => { type => 'varchar', length => 50 }, - ustid => { type => 'varchar', length => 14 }, + ustid => { type => 'text' }, v_customer_id => { type => 'text' }, vendornumber => { type => 'text' }, zipcode => { type => 'varchar', length => 10 },