From e3c9027e366887b290b0e7e2667d4baba564f070 Mon Sep 17 00:00:00 2001 From: "G. Richardson" Date: Sun, 1 Feb 2015 21:59:36 +0100 Subject: [PATCH] MetaSetup Dateien aktualisiert --- SL/DB/MetaSetup/PriceRuleItem.pm | 2 ++ SL/DB/MetaSetup/RequirementSpecPart.pm | 2 +- SL/DB/MetaSetup/TaxzoneChart.pm | 6 +++--- 3 files changed, 6 insertions(+), 4 deletions(-) diff --git a/SL/DB/MetaSetup/PriceRuleItem.pm b/SL/DB/MetaSetup/PriceRuleItem.pm index ade1d5a28..d1fe5063e 100644 --- a/SL/DB/MetaSetup/PriceRuleItem.pm +++ b/SL/DB/MetaSetup/PriceRuleItem.pm @@ -11,6 +11,8 @@ __PACKAGE__->meta->table('price_rule_items'); __PACKAGE__->meta->columns( custom_variable_configs_id => { type => 'integer' }, id => { type => 'serial', not_null => 1 }, + itime => { type => 'timestamp' }, + mtime => { type => 'timestamp' }, op => { type => 'text' }, price_rules_id => { type => 'integer', not_null => 1 }, type => { type => 'text' }, diff --git a/SL/DB/MetaSetup/RequirementSpecPart.pm b/SL/DB/MetaSetup/RequirementSpecPart.pm index b29ae4204..c4627ae5a 100644 --- a/SL/DB/MetaSetup/RequirementSpecPart.pm +++ b/SL/DB/MetaSetup/RequirementSpecPart.pm @@ -9,8 +9,8 @@ use base qw(SL::DB::Object); __PACKAGE__->meta->table('requirement_spec_parts'); __PACKAGE__->meta->columns( - id => { type => 'serial', not_null => 1 }, description => { type => 'text', not_null => 1 }, + id => { type => 'serial', not_null => 1 }, part_id => { type => 'integer', not_null => 1 }, position => { type => 'integer', not_null => 1 }, qty => { type => 'numeric', not_null => 1, precision => 15, scale => 5 }, diff --git a/SL/DB/MetaSetup/TaxzoneChart.pm b/SL/DB/MetaSetup/TaxzoneChart.pm index 3bcdbceee..d11587a35 100644 --- a/SL/DB/MetaSetup/TaxzoneChart.pm +++ b/SL/DB/MetaSetup/TaxzoneChart.pm @@ -9,12 +9,12 @@ use base qw(SL::DB::Object); __PACKAGE__->meta->table('taxzone_charts'); __PACKAGE__->meta->columns( - id => { type => 'serial', not_null => 1 }, - taxzone_id => { type => 'integer', not_null => 1 }, buchungsgruppen_id => { type => 'integer', not_null => 1 }, - income_accno_id => { type => 'integer', not_null => 1 }, expense_accno_id => { type => 'integer', not_null => 1 }, + id => { type => 'serial', not_null => 1 }, + income_accno_id => { type => 'integer', not_null => 1 }, itime => { type => 'timestamp', default => 'now()' }, + taxzone_id => { type => 'integer', not_null => 1 }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); -- 2.20.1