X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/1deb1fbe7e1c00bb64df6e8d47023c1e429af8f6..80457526fe12b504d09c8ddf3db81c754c9938e2:/SL/DB/MetaSetup/TimeRecording.pm diff --git a/SL/DB/MetaSetup/TimeRecording.pm b/SL/DB/MetaSetup/TimeRecording.pm index cb3bdd50a..4fca65738 100644 --- a/SL/DB/MetaSetup/TimeRecording.pm +++ b/SL/DB/MetaSetup/TimeRecording.pm @@ -17,11 +17,11 @@ __PACKAGE__->meta->columns( id => { type => 'serial', not_null => 1 }, itime => { type => 'timestamp', default => 'now()', not_null => 1 }, mtime => { type => 'timestamp', default => 'now()', not_null => 1 }, + part_id => { type => 'integer' }, payroll => { type => 'boolean', default => 'false' }, project_id => { type => 'integer' }, staff_member_id => { type => 'integer', not_null => 1 }, start_time => { type => 'timestamp', not_null => 1 }, - type_id => { type => 'integer' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); @@ -39,6 +39,11 @@ __PACKAGE__->meta->foreign_keys( key_columns => { employee_id => 'id' }, }, + part => { + class => 'SL::DB::Part', + key_columns => { part_id => 'id' }, + }, + project => { class => 'SL::DB::Project', key_columns => { project_id => 'id' }, @@ -48,11 +53,6 @@ __PACKAGE__->meta->foreign_keys( class => 'SL::DB::Employee', key_columns => { staff_member_id => 'id' }, }, - - type => { - class => 'SL::DB::TimeRecordingType', - key_columns => { type_id => 'id' }, - }, ); 1;