X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d0118dc6303e04507a77f3dde2c2bf0565ecb388..d17e1b9d1b761bb19d0cb79a742ea70a07028998:/SL/DB/MetaSetup/Customer.pm diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm index d65b0b37b..1537bf6c3 100644 --- a/SL/DB/MetaSetup/Customer.pm +++ b/SL/DB/MetaSetup/Customer.pm @@ -20,7 +20,7 @@ __PACKAGE__->meta->columns( city => { type => 'varchar', length => 75 }, contact => { type => 'text' }, country => { type => 'varchar', length => 75 }, - creditlimit => { type => 'numeric', default => '0', precision => 5, scale => 15 }, + creditlimit => { type => 'numeric', default => '0', precision => 15, scale => 5 }, currency_id => { type => 'integer', not_null => 1 }, customernumber => { type => 'text' }, delivery_term_id => { type => 'integer' }, @@ -28,11 +28,12 @@ __PACKAGE__->meta->columns( department_2 => { type => 'varchar', length => 75 }, depositor => { type => 'text' }, direct_debit => { type => 'boolean', default => 'false' }, - discount => { type => 'float', precision => 4 }, + discount => { type => 'float', scale => 4 }, email => { type => 'text' }, fax => { type => 'varchar', length => 30 }, greeting => { type => 'text' }, homepage => { type => 'text' }, + hourly_rate => { type => 'numeric', precision => 2, scale => 8 }, iban => { type => 'varchar', length => 100 }, id => { type => 'integer', not_null => 1, sequence => 'id' }, itime => { type => 'timestamp', default => 'now()' }, @@ -89,11 +90,6 @@ __PACKAGE__->meta->foreign_keys( class => 'SL::DB::PaymentTerm', key_columns => { payment_id => 'id' }, }, - - salesman => { - class => 'SL::DB::Employee', - key_columns => { salesman_id => 'id' }, - }, ); 1;