X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/1561b7f3d98390ba97bd5a81945f16e82d96915b..f1d33e8c42f2da428be80a6909335cf88689c1b3:/SL/DB/MetaSetup/ProjectPhaseParticipant.pm diff --git a/SL/DB/MetaSetup/ProjectPhaseParticipant.pm b/SL/DB/MetaSetup/ProjectPhaseParticipant.pm index 169181f7d..bd2e2caad 100644 --- a/SL/DB/MetaSetup/ProjectPhaseParticipant.pm +++ b/SL/DB/MetaSetup/ProjectPhaseParticipant.pm @@ -4,15 +4,15 @@ package SL::DB::ProjectPhaseParticipant; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); __PACKAGE__->meta->table('project_phase_participants'); __PACKAGE__->meta->columns( - cost_per_hour => { type => 'numeric', precision => 5, scale => 15 }, + cost_per_hour => { type => 'numeric', precision => 15, scale => 5 }, employee_id => { type => 'integer', not_null => 1 }, id => { type => 'serial', not_null => 1 }, - itime => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' }, + itime => { type => 'timestamp', default => 'now()' }, minutes => { type => 'integer', default => '0', not_null => 1 }, mtime => { type => 'timestamp' }, project_phase_id => { type => 'integer', not_null => 1 }, @@ -21,12 +21,19 @@ __PACKAGE__->meta->columns( __PACKAGE__->meta->primary_key_columns([ 'id' ]); +__PACKAGE__->meta->allow_inline_column_values(1); + __PACKAGE__->meta->foreign_keys( employee => { class => 'SL::DB::Employee', key_columns => { employee_id => 'id' }, }, + project_phase => { + class => 'SL::DB::ProjectPhase', + key_columns => { project_phase_id => 'id' }, + }, + project_role => { class => 'SL::DB::ProjectRole', key_columns => { project_role_id => 'id' },