X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FProject.pm;h=f651042a575a918f0dd0bdc72404dbe97c459e06;hb=deb4d2dbb676d7d6f69dfe7815d6e0cb09bd4a44;hp=135d7c8db9ee3534de4edeb753cfc9b0c5ad74f2;hpb=35bd55ae9e1249e11f18ebb6580a7037acdf8087;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Project.pm b/SL/DB/MetaSetup/Project.pm index 135d7c8db..f651042a5 100644 --- a/SL/DB/MetaSetup/Project.pm +++ b/SL/DB/MetaSetup/Project.pm @@ -4,14 +4,14 @@ package SL::DB::Project; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); __PACKAGE__->meta->table('project'); __PACKAGE__->meta->columns( active => { type => 'boolean', default => 'true' }, billable_customer_id => { type => 'integer' }, - budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 }, + budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, budget_minutes => { type => 'integer', default => '0', not_null => 1 }, customer_id => { type => 'integer' }, description => { type => 'text' }, @@ -19,13 +19,12 @@ __PACKAGE__->meta->columns( id => { type => 'integer', not_null => 1, sequence => 'id' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, - order_value => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 }, - project_status_id => { type => 'integer' }, + order_value => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, + project_status_id => { type => 'integer', not_null => 1 }, project_type_id => { type => 'integer', not_null => 1 }, 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' },