X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/fb03d191f53516cbf1022e755665556e7f1acb82..c9370086d4e1dd6051847ecdd7a0c85bbf9fc2a1:/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 },