Pflichtenhefte: Meta-Setups nach RDBO-Update neu gebaut

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index 1537bf6c3088aa9075eb16877d61c1463bf3bb93..ea5e3281bad6fdee717ff9d445f2cedfdbc934fd 100644 (file)
--- a/SL/DB/MetaSetup/Customer.pm
+++ b/SL/DB/MetaSetup/Customer.pm
@@ -33,7 +33,7 @@ __PACKAGE__->meta->columns(
   fax                       => { type => 'varchar', length => 30 },
   greeting                  => { type => 'text' },
   homepage                  => { type => 'text' },
-  hourly_rate               => { type => 'numeric', precision => 2, scale => 8 },
+  hourly_rate               => { type => 'numeric', precision => 8, scale => 2 },
   iban                      => { type => 'varchar', length => 100 },
   id                        => { type => 'integer', not_null => 1, sequence => 'id' },
   itime                     => { type => 'timestamp', default => 'now()' },

diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm
index 942810c3409f81ccacf1b34461e0f084a24f690d..5242ccea71bb8048f23c4e088f758c658e87a4bc 100644 (file)
--- a/SL/DB/MetaSetup/Default.pm
+++ b/SL/DB/MetaSetup/Default.pm
@@ -28,7 +28,7 @@ __PACKAGE__->meta->columns(
   coa                                     => { type => 'text' },
   company                                 => { type => 'text' },
   currency_id                             => { type => 'integer', not_null => 1 },
-  customer_hourly_rate                    => { type => 'numeric', precision => 2, scale => 8 },
+  customer_hourly_rate                    => { type => 'numeric', precision => 8, scale => 2 },
   customernumber                          => { type => 'text' },
   datev_check_on_ap_transaction           => { type => 'boolean', default => 'true' },
   datev_check_on_ar_transaction           => { type => 'boolean', default => 'true' },

diff --git a/SL/DB/MetaSetup/Project.pm b/SL/DB/MetaSetup/Project.pm
index 9351a24b7aa2427cc8e22fa9677b7c7fdb2f4a0a..255cc93d8a9581bc5952501f7b2d4f6559355cdd 100644 (file)
--- a/SL/DB/MetaSetup/Project.pm
+++ b/SL/DB/MetaSetup/Project.pm
@@ -11,7 +11,7 @@ __PACKAGE__->meta->table('project');
 __PACKAGE__->meta->columns(
   active               => { type => 'boolean', default => 'true' },
   billable_customer_id => { type => 'integer' },
-  budget_cost          => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
+  budget_cost          => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
   budget_minutes       => { type => 'integer', default => '0', not_null => 1 },
   customer_id          => { type => 'integer' },
   description          => { type => 'text' },
@@ -19,7 +19,7 @@ __PACKAGE__->meta->columns(
   id                   => { type => 'integer', not_null => 1, sequence => 'id' },
   itime                => { type => 'timestamp', default => 'now()' },
   mtime                => { type => 'timestamp' },
-  order_value          => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
+  order_value          => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
   project_status_id    => { type => 'integer', not_null => 1 },
   project_type_id      => { type => 'integer', not_null => 1 },
   projectnumber        => { type => 'text' },

diff --git a/SL/DB/MetaSetup/ProjectParticipant.pm b/SL/DB/MetaSetup/ProjectParticipant.pm
index 92dbd1a14de75512de97371a66b4ed10dc027016..9058aa5d9b6f19f01b82c374a808874ba6db4916 100644 (file)
--- a/SL/DB/MetaSetup/ProjectParticipant.pm
+++ b/SL/DB/MetaSetup/ProjectParticipant.pm
@@ -9,7 +9,7 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('project_participants');
 
 __PACKAGE__->meta->columns(
-  cost_per_hour   => { type => 'numeric', precision => 5, scale => 15 },
+  cost_per_hour   => { type => 'numeric', precision => 15, scale => 5 },
   employee_id     => { type => 'integer', not_null => 1 },
   id              => { type => 'serial', not_null => 1 },
   itime           => { type => 'timestamp', default => 'now()' },

diff --git a/SL/DB/MetaSetup/ProjectPhase.pm b/SL/DB/MetaSetup/ProjectPhase.pm
index a5fd71849a312a989a01096605506ba55b49f7bd..20df6763005898887d2de944cd8a05416072fae6 100644 (file)
--- a/SL/DB/MetaSetup/ProjectPhase.pm
+++ b/SL/DB/MetaSetup/ProjectPhase.pm
@@ -9,11 +9,11 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('project_phases');
 
 __PACKAGE__->meta->columns(
-  budget_cost           => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
+  budget_cost           => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
   budget_minutes        => { type => 'integer', default => '0', not_null => 1 },
   description           => { type => 'text', not_null => 1 },
   end_date              => { type => 'date' },
-  general_cost_per_hour => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
+  general_cost_per_hour => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
   general_minutes       => { type => 'integer', default => '0', not_null => 1 },
   id                    => { type => 'serial', not_null => 1 },
   itime                 => { type => 'timestamp', default => 'now()' },

diff --git a/SL/DB/MetaSetup/ProjectPhaseParticipant.pm b/SL/DB/MetaSetup/ProjectPhaseParticipant.pm
index 83789803210ef802cfe474fafa7c4caeb758b08a..73c0f04b98ef1be68acb15eab0a94872c1394bd7 100644 (file)
--- a/SL/DB/MetaSetup/ProjectPhaseParticipant.pm
+++ b/SL/DB/MetaSetup/ProjectPhaseParticipant.pm
@@ -9,7 +9,7 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('project_phase_participants');
 
 __PACKAGE__->meta->columns(
-  cost_per_hour    => { type => 'numeric', precision => 5, scale => 15 },
+  cost_per_hour    => { type => 'numeric', precision => 15, scale => 5 },
   employee_id      => { type => 'integer', not_null => 1 },
   id               => { type => 'serial', not_null => 1 },
   itime            => { type => 'timestamp', default => 'now()' },

diff --git a/SL/DB/MetaSetup/ProjectStatus.pm b/SL/DB/MetaSetup/ProjectStatus.pm
index 4162812f3f5217b6029c29d551377b9bf5b43ddc..e7f4a4ca0341c76822ba123dfedf4d661e74dd0e 100644 (file)
--- a/SL/DB/MetaSetup/ProjectStatus.pm
+++ b/SL/DB/MetaSetup/ProjectStatus.pm
@@ -10,7 +10,7 @@ __PACKAGE__->meta->table('project_statuses');
 
 __PACKAGE__->meta->columns(
   description => { type => 'text', not_null => 1 },
-  id          => { type => 'serial', not_null => 1 },
+  id          => { type => 'integer', not_null => 1, sequence => 'project_status_id_seq' },
   itime       => { type => 'timestamp', default => 'now()' },
   mtime       => { type => 'timestamp' },
   name        => { type => 'text', not_null => 1 },

diff --git a/SL/DB/MetaSetup/RequirementSpec.pm b/SL/DB/MetaSetup/RequirementSpec.pm
index c13400c23f1bed6711647aa94c5c17c973aa6d49..448816a88d21124d8e3eab7d940eb5a3a7d26af1 100644 (file)
--- a/SL/DB/MetaSetup/RequirementSpec.pm
+++ b/SL/DB/MetaSetup/RequirementSpec.pm
@@ -10,7 +10,7 @@ __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()' },
@@ -20,7 +20,7 @@ __PACKAGE__->meta->columns(
   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' },
   working_copy_id         => { type => 'integer' },

diff --git a/SL/DB/MetaSetup/RequirementSpecItem.pm b/SL/DB/MetaSetup/RequirementSpecItem.pm
index 63e4eecdac149b2f01cd8744411831161a8a7c0b..79c1ca0b28a0eef08d5ed7a8f4ea458779126074 100644 (file)
--- a/SL/DB/MetaSetup/RequirementSpecItem.pm
+++ b/SL/DB/MetaSetup/RequirementSpecItem.pm
@@ -24,7 +24,7 @@ __PACKAGE__->meta->columns(
   position             => { type => 'integer', not_null => 1 },
   requirement_spec_id  => { type => 'integer', not_null => 1 },
   risk_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' },
 );