X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FMakeModel.pm;h=e13461a6d78b8f972e4a3576b128174db52d33c8;hb=9fda7972d8dd37f1a760a7b430b638c202aac2b7;hp=c6499a5936c10a791f3d0557173a2ea655361c3b;hpb=d14a38bbaa7fcd371998b43bf389f56908575c7c;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/MakeModel.pm b/SL/DB/MetaSetup/MakeModel.pm index c6499a593..e13461a6d 100644 --- a/SL/DB/MetaSetup/MakeModel.pm +++ b/SL/DB/MetaSetup/MakeModel.pm @@ -4,26 +4,31 @@ package SL::DB::MakeModel; use strict; -use base qw(SL::DB::Object); - -__PACKAGE__->meta->setup( - table => 'makemodel', - - columns => [ - parts_id => { type => 'integer' }, - model => { type => 'text' }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - lastcost => { type => 'numeric', precision => 5, scale => 15 }, - lastupdate => { type => 'date' }, - sortorder => { type => 'integer' }, - make => { type => 'integer' }, - id => { type => 'serial', not_null => 1 }, - ], - - primary_key_columns => [ 'id' ], - - allow_inline_column_values => 1, +use parent qw(SL::DB::Object); + +__PACKAGE__->meta->table('makemodel'); + +__PACKAGE__->meta->columns( + id => { type => 'serial', not_null => 1 }, + itime => { type => 'timestamp', default => 'now()' }, + lastcost => { type => 'numeric', precision => 15, scale => 5 }, + lastupdate => { type => 'date' }, + make => { type => 'integer' }, + model => { type => 'text' }, + mtime => { type => 'timestamp' }, + parts_id => { type => 'integer' }, + sortorder => { type => 'integer' }, +); + +__PACKAGE__->meta->primary_key_columns([ 'id' ]); + +__PACKAGE__->meta->allow_inline_column_values(1); + +__PACKAGE__->meta->foreign_keys( + vendor => { + class => 'SL::DB::Vendor', + key_columns => { make => 'id' }, + }, ); 1;