Metasetup für taykeys aus tax_constraints.pl

diff --git a/SL/DB/MetaSetup/TaxKey.pm b/SL/DB/MetaSetup/TaxKey.pm
index 087903fa8b4b789be701487cea546f8e7f8a359f..3dc0895cbaf08d126f741c72e36bb828b2d97dbc 100644 (file)
--- 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' },
 
   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' },
     pos_ustva => { type => 'integer' },

-    startdate => { type => 'date' },
+    startdate => { type => 'date', not_null => 1 },

   ],
 
   primary_key_columns => [ 'id' ],
 
   ],
 
   primary_key_columns => [ 'id' ],
 

+  unique_key => [ 'chart_id', 'startdate' ],
+

   foreign_keys => [
   foreign_keys => [

+    chart => {
+      class       => 'SL::DB::Chart',
+      key_columns => { chart_id => 'id' },
+    },
+

     tax => {
       class       => 'SL::DB::Tax',
       key_columns => { tax_id => 'id' },
     tax => {
       class       => 'SL::DB::Tax',
       key_columns => { tax_id => 'id' },