X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/03f5aaa3c601956206f0c2a142c1e19f6981b326..5723fbf943e494ce9ffd6f9fc44251eb04d3362c:/SL/DB/MetaSetup/Project.pm?ds=inline diff --git a/SL/DB/MetaSetup/Project.pm b/SL/DB/MetaSetup/Project.pm index cef714120..5b9926589 100644 --- a/SL/DB/MetaSetup/Project.pm +++ b/SL/DB/MetaSetup/Project.pm @@ -25,7 +25,6 @@ __PACKAGE__->meta->columns( projectnumber => { type => 'text' }, start_date => { type => 'date' }, timeframe => { type => 'boolean', default => 'false', not_null => 1 }, - type => { type => 'text' }, valid => { type => 'boolean', default => 'true' }, ); @@ -36,16 +35,6 @@ __PACKAGE__->meta->unique_keys([ 'projectnumber' ]); __PACKAGE__->meta->allow_inline_column_values(1); __PACKAGE__->meta->foreign_keys( - customer => { - class => 'SL::DB::Customer', - key_columns => { customer_id => 'id' }, - }, - - project_type => { - class => 'SL::DB::ProjectType', - key_columns => { project_type_id => 'id' }, - }, - billable_customer => { class => 'SL::DB::Customer', key_columns => { billable_customer_id => 'id' }, @@ -56,6 +45,11 @@ __PACKAGE__->meta->foreign_keys( key_columns => { customer_id => 'id' }, }, + project_status => { + class => 'SL::DB::ProjectStatus', + key_columns => { project_status_id => 'id' }, + }, + project_type => { class => 'SL::DB::ProjectType', key_columns => { project_type_id => 'id' },