X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FInventory.pm;h=a71f7601e75918cd8c5566fb90892f773b02a232;hb=377b705324a4c43ef21b838d4ea9d474132cf16f;hp=e2093efe82a1cf4bc0c6186625726759fcf571b0;hpb=82349c1ed1027244965c0da6ecdd8793d365d01a;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Inventory.pm b/SL/DB/MetaSetup/Inventory.pm index e2093efe8..a71f7601e 100644 --- a/SL/DB/MetaSetup/Inventory.pm +++ b/SL/DB/MetaSetup/Inventory.pm @@ -6,64 +6,62 @@ use strict; use base qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'inventory', +__PACKAGE__->meta->table('inventory'); - columns => [ - warehouse_id => { type => 'integer', not_null => 1 }, - parts_id => { type => 'integer', not_null => 1 }, - oe_id => { type => 'integer' }, - orderitems_id => { type => 'integer' }, - shippingdate => { type => 'date' }, - employee_id => { type => 'integer', not_null => 1 }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - bin_id => { type => 'integer', not_null => 1 }, - qty => { type => 'numeric', precision => 5, scale => 25 }, - trans_id => { type => 'integer', not_null => 1 }, - trans_type_id => { type => 'integer', not_null => 1 }, - project_id => { type => 'integer' }, - chargenumber => { type => 'text', default => '', not_null => 1 }, - comment => { type => 'text' }, - bestbefore => { type => 'date' }, - id => { type => 'serial', not_null => 1 }, - ], +__PACKAGE__->meta->columns( + bestbefore => { type => 'date' }, + bin_id => { type => 'integer', not_null => 1 }, + chargenumber => { type => 'text', default => '', not_null => 1 }, + comment => { type => 'text' }, + employee_id => { type => 'integer', not_null => 1 }, + id => { type => 'serial', not_null => 1 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + oe_id => { type => 'integer' }, + orderitems_id => { type => 'integer' }, + parts_id => { type => 'integer', not_null => 1 }, + project_id => { type => 'integer' }, + qty => { type => 'numeric', precision => 5, scale => 25 }, + shippingdate => { type => 'date' }, + trans_id => { type => 'integer', not_null => 1 }, + trans_type_id => { type => 'integer', not_null => 1 }, + warehouse_id => { type => 'integer', not_null => 1 }, +); - primary_key_columns => [ 'id' ], +__PACKAGE__->meta->primary_key_columns([ 'id' ]); - allow_inline_column_values => 1, +__PACKAGE__->meta->allow_inline_column_values(1); - foreign_keys => [ - bin => { - class => 'SL::DB::Bin', - key_columns => { bin_id => 'id' }, - }, +__PACKAGE__->meta->foreign_keys( + bin => { + class => 'SL::DB::Bin', + key_columns => { bin_id => 'id' }, + }, - employee => { - class => 'SL::DB::Employee', - key_columns => { employee_id => 'id' }, - }, + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, - parts => { - class => 'SL::DB::Part', - key_columns => { parts_id => 'id' }, - }, + parts => { + class => 'SL::DB::Part', + key_columns => { parts_id => 'id' }, + }, - project => { - class => 'SL::DB::Project', - key_columns => { project_id => 'id' }, - }, + project => { + class => 'SL::DB::Project', + key_columns => { project_id => 'id' }, + }, - trans_type => { - class => 'SL::DB::TransferType', - key_columns => { trans_type_id => 'id' }, - }, + trans_type => { + class => 'SL::DB::TransferType', + key_columns => { trans_type_id => 'id' }, + }, - warehouse => { - class => 'SL::DB::Warehouse', - key_columns => { warehouse_id => 'id' }, - }, - ], + warehouse => { + class => 'SL::DB::Warehouse', + key_columns => { warehouse_id => 'id' }, + }, ); 1;