X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FProject.pm;h=4805568abca2a9212cbab00a43e50dadc3cd2145;hb=57d6293d271283b4873d98379e8432b8bb509c01;hp=a492b46ca405fcbb5f7134022bd553558f6e513f;hpb=5c5c1eef2ef26aa166f612d0718770488809b74b;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Project.pm b/SL/DB/MetaSetup/Project.pm index a492b46ca..4805568ab 100644 --- a/SL/DB/MetaSetup/Project.pm +++ b/SL/DB/MetaSetup/Project.pm @@ -6,33 +6,31 @@ use strict; use base qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'project', - - columns => [ - id => { type => 'integer', not_null => 1, sequence => 'id' }, - projectnumber => { type => 'text' }, - description => { type => 'text' }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - active => { type => 'boolean', default => 'true' }, - customer_id => { type => 'integer' }, - type => { type => 'text' }, - valid => { type => 'boolean', default => 'true' }, - ], - - primary_key_columns => [ 'id' ], - - unique_key => [ 'projectnumber' ], - - allow_inline_column_values => 1, - - foreign_keys => [ - customer => { - class => 'SL::DB::Customer', - key_columns => { customer_id => 'id' }, - }, - ], +__PACKAGE__->meta->table('project'); + +__PACKAGE__->meta->columns( + active => { type => 'boolean', default => 'true' }, + customer_id => { type => 'integer' }, + description => { type => 'text' }, + id => { type => 'integer', not_null => 1, sequence => 'id' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + projectnumber => { type => 'text' }, + type => { type => 'text' }, + valid => { type => 'boolean', default => 'true' }, +); + +__PACKAGE__->meta->primary_key_columns([ 'id' ]); + +__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' }, + }, ); 1;