X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FMakeModel.pm;h=e13461a6d78b8f972e4a3576b128174db52d33c8;hb=5d1790289c565ace01143d524538bd505859a57c;hp=7d724e861d8896fd9acbdfaf11b762b25f2d9043;hpb=b8b112a39bd601b0bc717646d78de470631da22a;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/MakeModel.pm b/SL/DB/MetaSetup/MakeModel.pm index 7d724e861..e13461a6d 100644 --- a/SL/DB/MetaSetup/MakeModel.pm +++ b/SL/DB/MetaSetup/MakeModel.pm @@ -4,19 +4,19 @@ package SL::DB::MakeModel; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); __PACKAGE__->meta->table('makemodel'); __PACKAGE__->meta->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 }, - lastcost => { type => 'numeric', precision => 5, scale => 15 }, + 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' }, ); @@ -24,7 +24,12 @@ __PACKAGE__->meta->primary_key_columns([ 'id' ]); __PACKAGE__->meta->allow_inline_column_values(1); -# __PACKAGE__->meta->initialize; +__PACKAGE__->meta->foreign_keys( + vendor => { + class => 'SL::DB::Vendor', + key_columns => { make => 'id' }, + }, +); 1; ;