X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FVendor.pm;fp=SL%2FDB%2FMetaSetup%2FVendor.pm;h=9a113fa7e8c28eccd289d34182f2a92eb2f89de4;hb=574855561514a864f554776c421e7037196e714d;hp=ef3f37f48e25c23e9cde6a31526ad5568c070ca3;hpb=493bb35d18d4733af35205ff9a0b82fc02f13c42;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm index ef3f37f48..9a113fa7e 100644 --- a/SL/DB/MetaSetup/Vendor.pm +++ b/SL/DB/MetaSetup/Vendor.pm @@ -13,25 +13,25 @@ __PACKAGE__->meta->columns( bank => { type => 'text' }, bank_code => { type => 'text' }, bcc => { type => 'text' }, - bic => { type => 'varchar', length => 100 }, + bic => { type => 'text' }, business_id => { type => 'integer' }, cc => { type => 'text' }, - city => { type => 'varchar', length => 75 }, + city => { type => 'text' }, contact => { type => 'text' }, - country => { type => 'varchar', length => 75 }, + country => { type => 'text' }, creditlimit => { type => 'numeric', precision => 15, scale => 5 }, currency_id => { type => 'integer', not_null => 1 }, delivery_term_id => { type => 'integer' }, - department_1 => { type => 'varchar', length => 75 }, - department_2 => { type => 'varchar', length => 75 }, + department_1 => { type => 'text' }, + department_2 => { type => 'text' }, depositor => { type => 'text' }, direct_debit => { type => 'boolean', default => 'false' }, discount => { type => 'float', scale => 4 }, email => { type => 'text' }, - fax => { type => 'varchar', length => 30 }, + fax => { type => 'text' }, greeting => { type => 'text' }, homepage => { type => 'text' }, - iban => { type => 'varchar', length => 100 }, + iban => { type => 'text' }, id => { type => 'integer', not_null => 1, sequence => 'id' }, itime => { type => 'timestamp', default => 'now()' }, language => { type => 'varchar', length => 5 }, @@ -43,17 +43,17 @@ __PACKAGE__->meta->columns( payment_id => { type => 'integer' }, phone => { type => 'text' }, salesman_id => { type => 'integer' }, - street => { type => 'varchar', length => 75 }, + street => { type => 'text' }, taxincluded => { type => 'boolean' }, taxnumber => { type => 'text' }, taxzone_id => { type => 'integer', default => '0', not_null => 1 }, terms => { type => 'integer', default => '0' }, - user_password => { type => 'varchar', length => 12 }, - username => { type => 'varchar', length => 50 }, + user_password => { type => 'text' }, + username => { type => 'text' }, ustid => { type => 'text' }, v_customer_id => { type => 'text' }, vendornumber => { type => 'text' }, - zipcode => { type => 'varchar', length => 10 }, + zipcode => { type => 'text' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]);