From 5b77c5df6b012e57517d21d7ecb89d1511da2fbe Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Mon, 14 Dec 2015 12:43:36 +0100 Subject: [PATCH] =?utf8?q?Rose-Schema=20f=C3=BCr=20fbf7532=20aktualisiert?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Mea culpa :) --- SL/DB/MetaSetup/Buchungsgruppe.pm | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/SL/DB/MetaSetup/Buchungsgruppe.pm b/SL/DB/MetaSetup/Buchungsgruppe.pm index fde083ab3..e89cb4b1c 100644 --- a/SL/DB/MetaSetup/Buchungsgruppe.pm +++ b/SL/DB/MetaSetup/Buchungsgruppe.pm @@ -11,11 +11,18 @@ __PACKAGE__->meta->table('buchungsgruppen'); __PACKAGE__->meta->columns( description => { type => 'text' }, id => { type => 'integer', not_null => 1, sequence => 'id' }, - inventory_accno_id => { type => 'integer' }, + inventory_accno_id => { type => 'integer', not_null => 1 }, sortkey => { type => 'integer', not_null => 1 }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); +__PACKAGE__->meta->foreign_keys( + inventory_accno => { + class => 'SL::DB::Chart', + key_columns => { inventory_accno_id => 'id' }, + }, +); + 1; ; -- 2.20.1