X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FMakeModel.pm;h=e13461a6d78b8f972e4a3576b128174db52d33c8;hb=2144dd8e1a7ed9da5f164d87165d3dce01b8f53b;hp=cc0ae7fcb60b4bb3f01993beb7e91143e8de4984;hpb=6cf3f7762efd40bee49a2b8f11bb4ab6915d9071;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/MakeModel.pm b/SL/DB/MetaSetup/MakeModel.pm index cc0ae7fcb..e13461a6d 100644 --- a/SL/DB/MetaSetup/MakeModel.pm +++ b/SL/DB/MetaSetup/MakeModel.pm @@ -4,23 +4,31 @@ package SL::DB::MakeModel; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'makemodel', +__PACKAGE__->meta->table('makemodel'); - columns => [ - parts_id => { type => 'integer' }, - model => { type => 'text' }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - make => { type => 'integer' }, - id => { type => 'serial', not_null => 1 }, - ], +__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' ]); - primary_key_columns => [ 'id' ], +__PACKAGE__->meta->allow_inline_column_values(1); - allow_inline_column_values => 1, +__PACKAGE__->meta->foreign_keys( + vendor => { + class => 'SL::DB::Vendor', + key_columns => { make => 'id' }, + }, ); 1;