X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/6cf3f7762efd40bee49a2b8f11bb4ab6915d9071..7635f647ec7dcdef51684b21601ee0930ea2bc5b:/SL/DB/MetaSetup/AccTransaction.pm?ds=sidebyside

diff --git a/SL/DB/MetaSetup/AccTransaction.pm b/SL/DB/MetaSetup/AccTransaction.pm
index 9f6e6b45e..db89491cf 100644
--- a/SL/DB/MetaSetup/AccTransaction.pm
+++ b/SL/DB/MetaSetup/AccTransaction.pm
@@ -10,7 +10,7 @@ __PACKAGE__->meta->setup(
   table   => 'acc_trans',
 
   columns => [
-    acc_trans_id   => { type => 'bigint', sequence => 'acc_trans_id_seq' },
+    acc_trans_id   => { type => 'bigint', not_null => 1, sequence => 'acc_trans_id_seq' },
     trans_id       => { type => 'integer', not_null => 1 },
     chart_id       => { type => 'integer', not_null => 1 },
     amount         => { type => 'numeric', precision => 5, scale => 15 },
@@ -26,12 +26,11 @@ __PACKAGE__->meta->setup(
     taxkey         => { type => 'integer' },
     itime          => { type => 'timestamp', default => 'now()' },
     mtime          => { type => 'timestamp' },
-    id             => { type => 'integer', not_null => 1, sequence => 'acc_trans_id_seq1' },
+    tax_id         => { type => 'integer', not_null => 1 },
+    chart_link     => { type => 'text', not_null => 1 },
   ],
 
-  primary_key_columns => [ 'id' ],
-
-  allow_inline_column_values => 1,
+  primary_key_columns => [ 'acc_trans_id' ],
 
   foreign_keys => [
     chart => {
@@ -43,6 +42,11 @@ __PACKAGE__->meta->setup(
       class       => 'SL::DB::Project',
       key_columns => { project_id => 'id' },
     },
+
+    tax => {
+      class       => 'SL::DB::Tax',
+      key_columns => { tax_id => 'id' },
+    },
   ],
 );