X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FOrder.pm;h=05512cd631e66f8ef5f7c01ee618a0f6ee23b8ea;hb=d482851e1d8edce7fc2e80bdaf47a4defa70da36;hp=3595026b08e5e117825737985cee3ce84e12b51e;hpb=b1b4e6878345cc1a8b590dd7362e4a50048f2417;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Order.pm b/SL/DB/MetaSetup/Order.pm index 3595026b0..05512cd63 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,11 +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' }, @@ -68,11 +88,26 @@ __PACKAGE__->meta->setup( key_columns => { globalproject_id => 'id' }, }, + language => { + class => 'SL::DB::Language', + key_columns => { language_id => 'id' }, + }, + + payment => { + 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' },