X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/4791db863d4fa954318024ea1d79e62572ae2eb1..e214accccd89a9c8:/SL/DB/MetaSetup/Unit.pm diff --git a/SL/DB/MetaSetup/Unit.pm b/SL/DB/MetaSetup/Unit.pm index 6e05737df..d8d47afac 100644 --- a/SL/DB/MetaSetup/Unit.pm +++ b/SL/DB/MetaSetup/Unit.pm @@ -6,28 +6,26 @@ use strict; use base qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'units', - - columns => [ - name => { type => 'varchar', length => 20, not_null => 1 }, - base_unit => { type => 'varchar', length => 20 }, - factor => { type => 'numeric', precision => 5, scale => 20 }, - type => { type => 'varchar', length => 20 }, - sortkey => { type => 'integer', not_null => 1 }, - id => { type => 'serial', not_null => 1 }, - ], - - primary_key_columns => [ 'name' ], - - unique_key => [ 'id' ], - - foreign_keys => [ - unit => { - class => 'SL::DB::Unit', - key_columns => { base_unit => 'name' }, - }, - ], +__PACKAGE__->meta->table('units'); + +__PACKAGE__->meta->columns( + base_unit => { type => 'varchar', length => 20 }, + factor => { type => 'numeric', precision => 5, scale => 20 }, + id => { type => 'serial', not_null => 1 }, + name => { type => 'varchar', length => 20, not_null => 1 }, + sortkey => { type => 'integer', not_null => 1 }, + type => { type => 'varchar', length => 20 }, +); + +__PACKAGE__->meta->primary_key_columns([ 'name' ]); + +__PACKAGE__->meta->unique_keys([ 'id' ]); + +__PACKAGE__->meta->foreign_keys( + unit => { + class => 'SL::DB::Unit', + key_columns => { base_unit => 'name' }, + }, ); 1;