X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FProjectPhaseParticipant.pm;h=bd2e2caad25d45ebc0f9434fb89372cf004229f2;hb=2144dd8e1a7ed9da5f164d87165d3dce01b8f53b;hp=be974954264bca8744ad4cd880812ed78cca23c1;hpb=03f5aaa3c601956206f0c2a142c1e19f6981b326;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/ProjectPhaseParticipant.pm b/SL/DB/MetaSetup/ProjectPhaseParticipant.pm index be9749542..bd2e2caad 100644 --- a/SL/DB/MetaSetup/ProjectPhaseParticipant.pm +++ b/SL/DB/MetaSetup/ProjectPhaseParticipant.pm @@ -4,35 +4,40 @@ package SL::DB::ProjectPhaseParticipant; use strict; -use base qw(SL::DB::Object); - -__PACKAGE__->meta->setup( - table => 'project_phase_participants', - - columns => [ - id => { type => 'serial', not_null => 1 }, - project_phase_id => { type => 'integer', not_null => 1 }, - employee_id => { type => 'integer', not_null => 1 }, - project_role_id => { type => 'integer', not_null => 1 }, - minutes => { type => 'integer', default => '0', not_null => 1 }, - cost_per_hour => { type => 'numeric', precision => 5, scale => 15 }, - itime => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' }, - mtime => { type => 'timestamp' }, - ], - - primary_key_columns => [ 'id' ], - - foreign_keys => [ - employee => { - class => 'SL::DB::Employee', - key_columns => { employee_id => 'id' }, - }, - - project_role => { - class => 'SL::DB::ProjectRole', - key_columns => { project_role_id => 'id' }, - }, - ], +use parent qw(SL::DB::Object); + +__PACKAGE__->meta->table('project_phase_participants'); + +__PACKAGE__->meta->columns( + 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 => 'now()' }, + minutes => { type => 'integer', default => '0', not_null => 1 }, + mtime => { type => 'timestamp' }, + project_phase_id => { type => 'integer', not_null => 1 }, + project_role_id => { type => 'integer', not_null => 1 }, +); + +__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' }, + }, ); 1;