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

---
 SL/DB/MetaSetup/Tax.pm | 24 ++++++++++++++++--------
 1 file changed, 16 insertions(+), 8 deletions(-)

diff --git a/SL/DB/MetaSetup/Tax.pm b/SL/DB/MetaSetup/Tax.pm
index 793b649a3..de8538e71 100644
--- a/SL/DB/MetaSetup/Tax.pm
+++ b/SL/DB/MetaSetup/Tax.pm
@@ -10,19 +10,27 @@ __PACKAGE__->meta->setup(
   table   => 'tax',
 
   columns => [
-    chart_id       => { type => 'integer' },
-    rate           => { type => 'numeric', precision => 5, scale => 15 },
-    taxnumber      => { type => 'text' },
-    taxkey         => { type => 'integer' },
-    taxdescription => { type => 'text' },
-    itime          => { type => 'timestamp', default => 'now()' },
-    mtime          => { type => 'timestamp' },
-    id             => { type => 'integer', not_null => 1, sequence => 'id' },
+    chart_id         => { type => 'integer' },
+    rate             => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
+    taxnumber        => { type => 'text' },
+    taxkey           => { type => 'integer', not_null => 1 },
+    taxdescription   => { type => 'text', not_null => 1 },
+    itime            => { type => 'timestamp', default => 'now()' },
+    mtime            => { type => 'timestamp' },
+    id               => { type => 'integer', not_null => 1, sequence => 'id' },
+    chart_categories => { type => 'text', not_null => 1 },
   ],
 
   primary_key_columns => [ 'id' ],
 
   allow_inline_column_values => 1,
+
+  foreign_keys => [
+    chart => {
+      class       => 'SL::DB::Chart',
+      key_columns => { chart_id => 'id' },
+    },
+  ],
 );
 
 1;
-- 
2.20.1