X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FTax.pm;h=b0dc314b8df717399fdab5713b79c40276ba0d47;hb=57d6293d271283b4873d98379e8432b8bb509c01;hp=793b649a3729d5fde9c9cba97cc0e192debf5bf9;hpb=6cf3f7762efd40bee49a2b8f11bb4ab6915d9071;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Tax.pm b/SL/DB/MetaSetup/Tax.pm index 793b649a3..b0dc314b8 100644 --- a/SL/DB/MetaSetup/Tax.pm +++ b/SL/DB/MetaSetup/Tax.pm @@ -6,23 +6,29 @@ use strict; use base qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'tax', - - columns => [ - chart_id => { type => 'integer' }, - rate => { type => 'numeric', precision => 5, scale => 15 }, - taxnumber => { type => 'text' }, - taxkey => { type => 'integer' }, - taxdescription => { type => 'text' }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - id => { type => 'integer', not_null => 1, sequence => 'id' }, - ], - - primary_key_columns => [ 'id' ], - - allow_inline_column_values => 1, +__PACKAGE__->meta->table('tax'); + +__PACKAGE__->meta->columns( + chart_categories => { type => 'text', not_null => 1 }, + chart_id => { type => 'integer' }, + id => { type => 'integer', not_null => 1, sequence => 'id' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + rate => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 }, + taxdescription => { type => 'text', not_null => 1 }, + taxkey => { type => 'integer', not_null => 1 }, + taxnumber => { type => 'text' }, +); + +__PACKAGE__->meta->primary_key_columns([ 'id' ]); + +__PACKAGE__->meta->allow_inline_column_values(1); + +__PACKAGE__->meta->foreign_keys( + chart => { + class => 'SL::DB::Chart', + key_columns => { chart_id => 'id' }, + }, ); 1;