From: Sven Schöling <s.schoeling@linet-services.de>
Date: Tue, 25 Jun 2013 10:00:42 +0000 (+0200)
Subject: Metasetup für taykeys aus tax_constraints.pl
X-Git-Tag: release-3.1.0beta1~266
X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/commitdiff_plain/93787f77f19ff64df53a6877b7f732b74eab1606

Metasetup für taykeys aus tax_constraints.pl
---

diff --git a/SL/DB/MetaSetup/TaxKey.pm b/SL/DB/MetaSetup/TaxKey.pm
index 087903fa8..3dc0895cb 100644
--- a/SL/DB/MetaSetup/TaxKey.pm
+++ b/SL/DB/MetaSetup/TaxKey.pm
@@ -11,16 +11,23 @@ __PACKAGE__->meta->setup(
 
   columns => [
     id        => { type => 'integer', not_null => 1, sequence => 'id' },
-    chart_id  => { type => 'integer' },
-    tax_id    => { type => 'integer' },
-    taxkey_id => { type => 'integer' },
+    chart_id  => { type => 'integer', not_null => 1 },
+    tax_id    => { type => 'integer', not_null => 1 },
+    taxkey_id => { type => 'integer', not_null => 1 },
     pos_ustva => { type => 'integer' },
-    startdate => { type => 'date' },
+    startdate => { type => 'date', not_null => 1 },
   ],
 
   primary_key_columns => [ 'id' ],
 
+  unique_key => [ 'chart_id', 'startdate' ],
+
   foreign_keys => [
+    chart => {
+      class       => 'SL::DB::Chart',
+      key_columns => { chart_id => 'id' },
+    },
+
     tax => {
       class       => 'SL::DB::Tax',
       key_columns => { tax_id => 'id' },