From 93787f77f19ff64df53a6877b7f732b74eab1606 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Sven=20Sch=C3=B6ling?= <s.schoeling@linet-services.de>
Date: Tue, 25 Jun 2013 12:00:42 +0200
Subject: [PATCH] =?utf8?q?Metasetup=20f=C3=BCr=20taykeys=20aus=20tax=5Fcon?=
 =?utf8?q?straints.pl?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 SL/DB/MetaSetup/TaxKey.pm | 15 +++++++++++----
 1 file changed, 11 insertions(+), 4 deletions(-)

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' },
-- 
2.39.5