X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FProjectParticipant.pm;h=5704af11d464867634d62612cdf5c7660a01e50b;hb=b269674b6b0e99818c3643d4fc3271a8ce83b8c6;hp=b58a66302d28998ec8998b34b667031539a41a60;hpb=03f5aaa3c601956206f0c2a142c1e19f6981b326;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/ProjectParticipant.pm b/SL/DB/MetaSetup/ProjectParticipant.pm index b58a66302..5704af11d 100644 --- a/SL/DB/MetaSetup/ProjectParticipant.pm +++ b/SL/DB/MetaSetup/ProjectParticipant.pm @@ -4,40 +4,40 @@ package SL::DB::ProjectParticipant; use strict; -use base qw(SL::DB::Object); - -__PACKAGE__->meta->setup( - table => 'project_participants', - - columns => [ - id => { type => 'serial', not_null => 1 }, - project_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 => { - class => 'SL::DB::Project', - key_columns => { project_id => 'id' }, - }, - - project_role => { - class => 'SL::DB::ProjectRole', - key_columns => { project_role_id => 'id' }, - }, - ], +use parent qw(SL::DB::Object); + +__PACKAGE__->meta->table('project_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_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 => { + class => 'SL::DB::Project', + key_columns => { project_id => 'id' }, + }, + + project_role => { + class => 'SL::DB::ProjectRole', + key_columns => { project_role_id => 'id' }, + }, ); 1;