X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FOrder.pm;h=f68c276efcf8daf6874b1666bfd81344ae76bac5;hb=87e65e6c1cc64bfb2d73b6914ed2ef136861dd42;hp=e616aa3d0d82051c4f6ff97156fe4da4a11aeed0;hpb=2cf0bf46e2d6372ad8402d73e2ab1e7cc59b122e;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Order.pm b/SL/DB/MetaSetup/Order.pm index e616aa3d0..f68c276ef 100644 --- a/SL/DB/MetaSetup/Order.pm +++ b/SL/DB/MetaSetup/Order.pm @@ -28,7 +28,7 @@ __PACKAGE__->meta->setup( quonumber => { type => 'text' }, cusordnumber => { type => 'text' }, intnotes => { type => 'text' }, - department_id => { type => 'integer', default => '0' }, + department_id => { type => 'integer' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, shipvia => { type => 'text' }, @@ -53,6 +53,31 @@ __PACKAGE__->meta->setup( allow_inline_column_values => 1, foreign_keys => [ + contact => { + class => 'SL::DB::Contact', + key_columns => { cp_id => 'cp_id' }, + }, + + customer => { + class => 'SL::DB::Customer', + key_columns => { customer_id => 'id' }, + }, + + delivery_customer => { + class => 'SL::DB::Customer', + key_columns => { delivery_customer_id => 'id' }, + }, + + delivery_vendor => { + class => 'SL::DB::Vendor', + key_columns => { delivery_vendor_id => 'id' }, + }, + + department => { + class => 'SL::DB::Department', + key_columns => { department_id => 'id' }, + }, + employee => { class => 'SL::DB::Employee', key_columns => { employee_id => 'id' }, @@ -63,10 +88,30 @@ __PACKAGE__->meta->setup( key_columns => { globalproject_id => 'id' }, }, + language => { + class => 'SL::DB::Language', + key_columns => { language_id => 'id' }, + }, + + payment_terms => { + class => 'SL::DB::PaymentTerm', + key_columns => { payment_id => 'id' }, + }, + salesman => { class => 'SL::DB::Employee', key_columns => { salesman_id => 'id' }, }, + + shipto => { + class => 'SL::DB::Shipto', + key_columns => { shipto_id => 'shipto_id' }, + }, + + vendor => { + class => 'SL::DB::Vendor', + key_columns => { vendor_id => 'id' }, + }, ], );