X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FAccTransaction.pm;h=29d5c3534c5319104b74833ce563516c2ee712c2;hb=21daf701fac24bbc753abae8d8f5f6b8bcf984f7;hp=9f6e6b45e1ca09c3a37b5652c4f6f04dd407c56f;hpb=f97b07787db5cacc0f90338fdb3c1237262917cb;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/AccTransaction.pm b/SL/DB/MetaSetup/AccTransaction.pm index 9f6e6b45e..29d5c3534 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,10 @@ __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 }, ], - primary_key_columns => [ 'id' ], - - allow_inline_column_values => 1, + primary_key_columns => [ 'acc_trans_id' ], foreign_keys => [ chart => {