projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Anzahlungs-Rg.: keine weitere Rückbuchung bei erneutem Buchen einer Schluss-Rg
[kivitendo-erp.git]
/
SL
/
DB
/
MetaSetup
/
Letter.pm
diff --git
a/SL/DB/MetaSetup/Letter.pm
b/SL/DB/MetaSetup/Letter.pm
index
b4dbe10
..
64d513e
100644
(file)
--- a/
SL/DB/MetaSetup/Letter.pm
+++ b/
SL/DB/MetaSetup/Letter.pm
@@
-11,7
+11,7
@@
__PACKAGE__->meta->table('letter');
__PACKAGE__->meta->columns(
body => { type => 'text' },
cp_id => { type => 'integer' },
__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' },
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' },
reference => { type => 'text' },
salesman_id => { type => 'integer' },
subject => { type => 'text' },
+ vendor_id => { type => 'integer' },
);
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
);
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
@@
-49,6
+50,11
@@
__PACKAGE__->meta->foreign_keys(
class => 'SL::DB::Employee',
key_columns => { salesman_id => 'id' },
},
class => 'SL::DB::Employee',
key_columns => { salesman_id => 'id' },
},
+
+ vendor => {
+ class => 'SL::DB::Vendor',
+ key_columns => { vendor_id => 'id' },
+ },
);
1;
);
1;