Spaltentyp Text anstelle von varchar() in diversen Tabellen Teil 2

[kivitendo-erp.git] / SL / DB / MetaSetup / RequirementSpec.pm

diff --git a/SL/DB/MetaSetup/RequirementSpec.pm b/SL/DB/MetaSetup/RequirementSpec.pm
index bb37ba6..667f39a 100644 (file)
--- a/SL/DB/MetaSetup/RequirementSpec.pm
+++ b/SL/DB/MetaSetup/RequirementSpec.pm
@@ -10,18 +10,19 @@ __PACKAGE__->meta->table('requirement_specs');
 
 __PACKAGE__->meta->columns(
   customer_id             => { type => 'integer' },
-  hourly_rate             => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 8 },
+  hourly_rate             => { type => 'numeric', default => '0', not_null => 1, precision => 8, scale => 2 },
   id                      => { type => 'serial', not_null => 1 },
   is_template             => { type => 'boolean', default => 'false' },
   itime                   => { type => 'timestamp', default => 'now()' },
   mtime                   => { type => 'timestamp' },
   previous_fb_number      => { type => 'integer', not_null => 1 },
+  previous_picture_number => { type => 'integer', default => '0', not_null => 1 },
   previous_section_number => { type => 'integer', not_null => 1 },
   project_id              => { type => 'integer' },
   status_id               => { type => 'integer' },
-  time_estimation         => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
+  time_estimation         => { type => 'numeric', default => '0', not_null => 1, precision => 12, scale => 2 },
   title                   => { type => 'text', not_null => 1 },
-  type_id                 => { type => 'integer' },
+  type_id                 => { type => 'integer', not_null => 1 },
   working_copy_id         => { type => 'integer' },
 );