projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
remove unnecessary spaces
[kivitendo-erp.git]
/
SL
/
DB
/
MetaSetup
/
Price.pm
diff --git
a/SL/DB/MetaSetup/Price.pm
b/SL/DB/MetaSetup/Price.pm
index
29c0de3
..
a0c2639
100644
(file)
--- a/
SL/DB/MetaSetup/Price.pm
+++ b/
SL/DB/MetaSetup/Price.pm
@@
-10,13
+10,15
@@
__PACKAGE__->meta->table('prices');
__PACKAGE__->meta->columns(
id => { type => 'serial', not_null => 1 },
__PACKAGE__->meta->columns(
id => { type => 'serial', not_null => 1 },
- parts_id => { type => 'integer' },
+ parts_id => { type => 'integer'
, not_null => 1
},
price => { type => 'numeric', precision => 15, scale => 5 },
price => { type => 'numeric', precision => 15, scale => 5 },
- pricegroup_id => { type => 'integer' },
+ pricegroup_id => { type => 'integer'
, not_null => 1
},
);
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
);
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
+__PACKAGE__->meta->unique_keys([ 'parts_id', 'pricegroup_id' ]);
+
__PACKAGE__->meta->foreign_keys(
parts => {
class => 'SL::DB::Part',
__PACKAGE__->meta->foreign_keys(
parts => {
class => 'SL::DB::Part',