X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FProjectPhaseParticipant.pm;h=bd2e2caad25d45ebc0f9434fb89372cf004229f2;hb=97a6f6d623a9810e1d324f44a5f8bcd12294f5d3;hp=169181f7daacea82e63dcc0f7cec2090511ece04;hpb=1561b7f3d98390ba97bd5a81945f16e82d96915b;p=kivitendo-erp.git 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' },