X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FProject.pm;h=5b9926589afde4e2c2570db544aa75ba2c5abb31;hb=064d15bb6c59188be545d75e895689cdfea04ad6;hp=cef714120ac7c956e29aa6373a3fc32d8358f682;hpb=03f5aaa3c601956206f0c2a142c1e19f6981b326;p=kivitendo-erp.git 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' },