X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/7196276bca4a155d1bcc3947859bc7d4ec1edcd6..53593baa211863fbf66540cf1bcc36c8fb37257f:/SL/DB/MetaSetup/LetterDraft.pm diff --git a/SL/DB/MetaSetup/LetterDraft.pm b/SL/DB/MetaSetup/LetterDraft.pm index 8b9782e75..d395cfbdc 100644 --- a/SL/DB/MetaSetup/LetterDraft.pm +++ b/SL/DB/MetaSetup/LetterDraft.pm @@ -11,7 +11,7 @@ __PACKAGE__->meta->table('letter_draft'); __PACKAGE__->meta->columns( body => { type => 'text' }, cp_id => { type => 'integer' }, - customer_id => { type => 'integer', not_null => 1 }, + customer_id => { type => 'integer' }, date => { type => 'date' }, employee_id => { type => 'integer' }, greeting => { type => 'text' }, @@ -23,6 +23,7 @@ __PACKAGE__->meta->columns( reference => { type => 'text' }, salesman_id => { type => 'integer' }, subject => { type => 'text' }, + vendor_id => { type => 'integer' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); @@ -49,6 +50,11 @@ __PACKAGE__->meta->foreign_keys( class => 'SL::DB::Employee', key_columns => { salesman_id => 'id' }, }, + + vendor => { + class => 'SL::DB::Vendor', + key_columns => { vendor_id => 'id' }, + }, ); 1;