X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FAssembly.pm;h=87ffae6e373d894445a4532935914a4370630474;hb=b944282768f7d90bf6bdf8db576fe539bb88481d;hp=801662db65fb1ca6352643cd66e94e10748928cf;hpb=60c5177dec0a6bf86e6b3da763b251233e40ce4d;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Assembly.pm b/SL/DB/MetaSetup/Assembly.pm index 801662db6..87ffae6e3 100644 --- a/SL/DB/MetaSetup/Assembly.pm +++ b/SL/DB/MetaSetup/Assembly.pm @@ -4,24 +4,34 @@ package SL::DB::Assembly; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'assembly', +__PACKAGE__->meta->table('assembly'); - columns => [ - id => { type => 'integer' }, - parts_id => { type => 'integer' }, - qty => { type => 'float', precision => 4 }, - bom => { type => 'boolean' }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - assembly_id => { type => 'serial', not_null => 1 }, - ], +__PACKAGE__->meta->columns( + assembly_id => { type => 'serial', not_null => 1 }, + bom => { type => 'boolean' }, + id => { type => 'integer', not_null => 1 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + parts_id => { type => 'integer', not_null => 1 }, + qty => { type => 'float', scale => 4 }, +); + +__PACKAGE__->meta->primary_key_columns([ 'assembly_id' ]); + +__PACKAGE__->meta->allow_inline_column_values(1); - primary_key_columns => [ 'assembly_id' ], +__PACKAGE__->meta->foreign_keys( + assembly_part => { + class => 'SL::DB::Part', + key_columns => { id => 'id' }, + }, - allow_inline_column_values => 1, + part => { + class => 'SL::DB::Part', + key_columns => { parts_id => 'id' }, + }, ); 1;