From 36bbcb55bea77b0795e2592abd51a454dcbe838e Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Tue, 25 Jun 2013 11:39:20 +0200 Subject: [PATCH] =?utf8?q?MetaSetup=20update=20f=C3=BCr=20gl=20aus=20add?= =?utf8?q?=5Ffk=5Fto=5Fgl.sql?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/GLTransaction.pm | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/SL/DB/MetaSetup/GLTransaction.pm b/SL/DB/MetaSetup/GLTransaction.pm index a7d25f7bf..da1990162 100644 --- a/SL/DB/MetaSetup/GLTransaction.pm +++ b/SL/DB/MetaSetup/GLTransaction.pm @@ -17,7 +17,7 @@ __PACKAGE__->meta->setup( gldate => { type => 'date', default => 'now' }, employee_id => { type => 'integer' }, notes => { type => 'text' }, - department_id => { type => 'integer', default => '0' }, + department_id => { type => 'integer' }, taxincluded => { type => 'boolean' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, @@ -33,6 +33,11 @@ __PACKAGE__->meta->setup( allow_inline_column_values => 1, foreign_keys => [ + department => { + class => 'SL::DB::Department', + key_columns => { department_id => 'id' }, + }, + storno_obj => { class => 'SL::DB::GLTransaction', key_columns => { storno_id => 'id' }, -- 2.20.1