X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/385bc4be4a927753ba4f1c7a426ede8fbed67123..80457526fe12b504d09c8ddf3db81c754c9938e2:/SL/DB/MetaSetup/TimeRecording.pm diff --git a/SL/DB/MetaSetup/TimeRecording.pm b/SL/DB/MetaSetup/TimeRecording.pm index 518a03710..4fca65738 100644 --- a/SL/DB/MetaSetup/TimeRecording.pm +++ b/SL/DB/MetaSetup/TimeRecording.pm @@ -9,6 +9,7 @@ use parent qw(SL::DB::Object); __PACKAGE__->meta->table('time_recordings'); __PACKAGE__->meta->columns( + booked => { type => 'boolean', default => 'false' }, customer_id => { type => 'integer', not_null => 1 }, description => { type => 'text', not_null => 1 }, employee_id => { type => 'integer', not_null => 1 }, @@ -16,10 +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' ]); @@ -37,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' }, @@ -46,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;