projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT#34960: Quotations [billpkgnum removal--missed a spot]
[freeside.git]
/
FS
/
FS
/
Schema.pm
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
7dc54f7
..
60c8e9a
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-735,8
+735,9
@@
sub tables_hashref {
#void fields
'void_date', @date_type, '', '',
#void fields
'void_date', @date_type, '', '',
- 'reason', 'varchar', 'NULL', $char_d, '', '',
- 'void_usernum', 'int', 'NULL', '', '', '',
+ 'reason', 'varchar', 'NULL', $char_d, '', '',
+ 'reasonnum', 'int', 'NULL', '', '', '',
+ 'void_usernum', 'int', 'NULL', '', '', '',
],
'primary_key' => 'invnum',
'unique' => [ [ 'custnum', 'agent_invid' ] ], #agentnum? huh
],
'primary_key' => 'invnum',
'unique' => [ [ 'custnum', 'agent_invid' ] ], #agentnum? huh
@@
-750,6
+751,9
@@
sub tables_hashref {
{ columns => [ 'statementnum' ],
table => 'cust_statement', #_void? both?
},
{ columns => [ 'statementnum' ],
table => 'cust_statement', #_void? both?
},
+ { columns => [ 'reasonnum' ],
+ table => 'reason',
+ },
{ columns => [ 'void_usernum' ],
table => 'access_user',
references => [ 'usernum' ],
{ columns => [ 'void_usernum' ],
table => 'access_user',
references => [ 'usernum' ],
@@
-1197,8
+1201,9
@@
sub tables_hashref {
'feepart', 'int', 'NULL', '', '', '',
#void fields
'void_date', @date_type, '', '',
'feepart', 'int', 'NULL', '', '', '',
#void fields
'void_date', @date_type, '', '',
- 'reason', 'varchar', 'NULL', $char_d, '', '',
- 'void_usernum', 'int', 'NULL', '', '', '',
+ 'reason', 'varchar', 'NULL', $char_d, '', '',
+ 'reasonnum', 'int', 'NULL', '', '', '',
+ 'void_usernum', 'int', 'NULL', '', '', '',
],
'primary_key' => 'billpkgnum',
'unique' => [],
],
'primary_key' => 'billpkgnum',
'unique' => [],
@@
-1209,6
+1214,9
@@
sub tables_hashref {
{ columns => [ 'invnum' ],
table => 'cust_bill_void',
},
{ columns => [ 'invnum' ],
table => 'cust_bill_void',
},
+ { columns => [ 'reasonnum' ],
+ table => 'reason',
+ },
#pkgnum 0 and -1 are used for special things
#{ columns => [ 'pkgnum' ],
# table => 'cust_pkg',
#pkgnum 0 and -1 are used for special things
#{ columns => [ 'pkgnum' ],
# table => 'cust_pkg',
@@
-1965,15
+1973,15
@@
sub tables_hashref {
'quotation_pkg_detail' => {
'columns' => [
'detailnum', 'serial', '', '', '', '',
'quotation_pkg_detail' => {
'columns' => [
'detailnum', 'serial', '', '', '', '',
- '
billpkgnum', 'int', '', '', '', '', # actually links to quotationpkgnum
+ '
quotationpkgnum', 'int', '', '', '', '',
'format', 'char', 'NULL', 1, '', '', # not used for anything
'detail', 'varchar', '', 255, '', '',
],
'primary_key' => 'detailnum',
'unique' => [],
'format', 'char', 'NULL', 1, '', '', # not used for anything
'detail', 'varchar', '', 255, '', '',
],
'primary_key' => 'detailnum',
'unique' => [],
- 'index' => [ [ '
bill
pkgnum' ] ],
+ 'index' => [ [ '
quotation
pkgnum' ] ],
'foreign_keys' => [
'foreign_keys' => [
- { columns => [ '
bill
pkgnum' ],
+ { columns => [ '
quotation
pkgnum' ],
table => 'quotation_pkg',
references => [ 'quotationpkgnum' ],
},
table => 'quotation_pkg',
references => [ 'quotationpkgnum' ],
},
@@
-1985,8
+1993,8
@@
sub tables_hashref {
'quotationpkgdiscountnum', 'serial', '', '', '', '',
'quotationpkgnum', 'int', '', '', '', '',
'discountnum', 'int', '', '', '', '',
'quotationpkgdiscountnum', 'serial', '', '', '', '',
'quotationpkgnum', 'int', '', '', '', '',
'discountnum', 'int', '', '', '', '',
- 'setup
_amount', @money_typen,
'', '',
- '
recur_amount', @money_typen,
'', '',
+ 'setup
recur', 'varchar', 'NULL', $char_d,
'', '',
+ '
amount', @money_typen,
'', '',
#'end_date', @date_type, '', '',
],
'primary_key' => 'quotationpkgdiscountnum',
#'end_date', @date_type, '', '',
],
'primary_key' => 'quotationpkgdiscountnum',
@@
-2523,6
+2531,7
@@
sub tables_hashref {
#void fields
'void_date', @date_type, '', '',
'reason', 'varchar', 'NULL', $char_d, '', '',
#void fields
'void_date', @date_type, '', '',
'reason', 'varchar', 'NULL', $char_d, '', '',
+ 'reasonnum', 'int', 'NULL', '', '', '',
'void_usernum', 'int', 'NULL', '', '', '',
],
'primary_key' => 'paynum',
'void_usernum', 'int', 'NULL', '', '', '',
],
'primary_key' => 'paynum',
@@
-2544,6
+2553,9
@@
sub tables_hashref {
{ columns => [ 'gatewaynum' ],
table => 'payment_gateway',
},
{ columns => [ 'gatewaynum' ],
table => 'payment_gateway',
},
+ { columns => [ 'reasonnum' ],
+ table => 'reason',
+ },
{ columns => [ 'void_usernum' ],
table => 'access_user',
references => [ 'usernum' ],
{ columns => [ 'void_usernum' ],
table => 'access_user',
references => [ 'usernum' ],