From: Moritz Bunkus Date: Mon, 14 Dec 2015 11:43:36 +0000 (+0100) Subject: Rose-Schema für fbf7532 aktualisiert X-Git-Tag: release-3.4.1~523 X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/commitdiff_plain/5b77c5df6b012e57517d21d7ecb89d1511da2fbe?ds=inline;hp=-c Rose-Schema für fbf7532 aktualisiert Mea culpa :) --- 5b77c5df6b012e57517d21d7ecb89d1511da2fbe 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; ;