Merge branch 'master' of http://wagnertech.de/git/mfinanz

[mfinanz.git] / SL / DB / MetaSetup / Part.pm

diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm
index ef6ed69f5aaee46b54c96f76608c40d3329b5c21..eacff8fd219ced8cb795299b0603866639cf4eba 100644 (file)
--- a/SL/DB/MetaSetup/Part.pm
+++ b/SL/DB/MetaSetup/Part.pm
@@ -29,8 +29,10 @@ __PACKAGE__->meta->columns(
   mtime              => { type => 'timestamp' },
   not_discountable   => { type => 'boolean', default => 'false' },
   notes              => { type => 'text' },
-  obsolete           => { type => 'boolean', default => 'false' },
+  obsolete           => { type => 'boolean', default => 'false', not_null => 1 },
   onhand             => { type => 'numeric', default => '0', precision => 25, scale => 5 },
+  order_locked       => { type => 'boolean', default => 'false' },
+  order_qty          => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
   part_type          => { type => 'enum', check_in => [ 'part', 'service', 'assembly', 'assortment' ], db_type => 'part_type_enum', not_null => 1 },
   partnumber         => { type => 'text', not_null => 1 },
   partsgroup_id      => { type => 'integer' },
@@ -41,6 +43,7 @@ __PACKAGE__->meta->columns(
   sellprice          => { type => 'numeric', precision => 15, scale => 5 },
   shop               => { type => 'boolean', default => 'false' },
   stockable          => { type => 'boolean', default => 'false' },
+  tariff_code        => { type => 'text' },
   unit               => { type => 'varchar', length => 20, not_null => 1 },
   ve                 => { type => 'integer' },
   warehouse_id       => { type => 'integer' },