From 95f559de4505bbeeb325d688f8a154b00d4a5a68 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Mon, 24 Jun 2013 18:52:50 +0200 Subject: [PATCH] =?utf8?q?MetaSetup=20update=20f=C3=BCr=20acc=5Ftrans?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/AccTransaction.pm | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/SL/DB/MetaSetup/AccTransaction.pm b/SL/DB/MetaSetup/AccTransaction.pm index db89491cf..e16dfd116 100644 --- a/SL/DB/MetaSetup/AccTransaction.pm +++ b/SL/DB/MetaSetup/AccTransaction.pm @@ -17,10 +17,10 @@ __PACKAGE__->meta->setup( transdate => { type => 'date', default => 'now' }, gldate => { type => 'date', default => 'now' }, source => { type => 'text' }, - cleared => { type => 'boolean', default => 'false' }, - fx_transaction => { type => 'boolean', default => 'false' }, - ob_transaction => { type => 'boolean', default => 'false' }, - cb_transaction => { type => 'boolean', default => 'false' }, + cleared => { type => 'boolean', default => 'false', not_null => 1 }, + fx_transaction => { type => 'boolean', default => 'false', not_null => 1 }, + ob_transaction => { type => 'boolean', default => 'false', not_null => 1 }, + cb_transaction => { type => 'boolean', default => 'false', not_null => 1 }, project_id => { type => 'integer' }, memo => { type => 'text' }, taxkey => { type => 'integer' }, @@ -32,6 +32,8 @@ __PACKAGE__->meta->setup( primary_key_columns => [ 'acc_trans_id' ], + allow_inline_column_values => 1, + foreign_keys => [ chart => { class => 'SL::DB::Chart', -- 2.20.1