X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/f97b07787db5cacc0f90338fdb3c1237262917cb..28d69bb85e934088a56e6e8458cd08d3794e1f8b:/SL/DB/MetaSetup/MakeModel.pm diff --git a/SL/DB/MetaSetup/MakeModel.pm b/SL/DB/MetaSetup/MakeModel.pm index cc0ae7fcb..c6499a593 100644 --- a/SL/DB/MetaSetup/MakeModel.pm +++ b/SL/DB/MetaSetup/MakeModel.pm @@ -10,12 +10,15 @@ __PACKAGE__->meta->setup( 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 }, + parts_id => { type => 'integer' }, + model => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + lastcost => { type => 'numeric', precision => 5, scale => 15 }, + lastupdate => { type => 'date' }, + sortorder => { type => 'integer' }, + make => { type => 'integer' }, + id => { type => 'serial', not_null => 1 }, ], primary_key_columns => [ 'id' ],