projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add svc_external
[freeside.git]
/
FS
/
bin
/
freeside-setup
diff --git
a/FS/bin/freeside-setup
b/FS/bin/freeside-setup
index
80b74c1
..
fce8bc7
100755
(executable)
--- a/
FS/bin/freeside-setup
+++ b/
FS/bin/freeside-setup
@@
-342,7
+342,7
@@
sub tables_hash_hack {
],
'primary_key' => 'agentnum',
'unique' => [],
],
'primary_key' => 'agentnum',
'unique' => [],
- 'index' => [ ['typenum'] ],
+ 'index' => [ ['typenum']
, ['diabled']
],
},
'agent_type' => {
},
'agent_type' => {
@@
-408,7
+408,7
@@
sub tables_hash_hack {
],
'primary_key' => 'eventpart',
'unique' => [],
],
'primary_key' => 'eventpart',
'unique' => [],
- 'index' => [ ['payby'] ],
+ 'index' => [ ['payby']
, ['disabled'],
],
},
'cust_bill_pkg' => {
},
'cust_bill_pkg' => {
@@
-567,7
+567,7
@@
sub tables_hash_hack {
],
'primary_key' => 'paynum',
'unique' => [],
],
'primary_key' => 'paynum',
'unique' => [],
- 'index' => [ [ 'custnum' ], [ 'paybatch' ] ],
+ 'index' => [ [ 'custnum' ], [ 'paybatch' ]
, [ 'payby' ], [ '_date' ]
],
},
'cust_bill_pay' => {
},
'cust_bill_pay' => {
@@
-718,10
+718,11
@@
sub tables_hash_hack {
'columns' => [
'refnum', 'serial', '', '',
'referral', 'varchar', '', $char_d,
'columns' => [
'refnum', 'serial', '', '',
'referral', 'varchar', '', $char_d,
+ 'disabled', 'char', 'NULL', 1,
],
'primary_key' => 'refnum',
'unique' => [],
],
'primary_key' => 'refnum',
'unique' => [],
- 'index' => [],
+ 'index' => [
['disabled']
],
},
'part_svc' => {
},
'part_svc' => {
@@
-1119,6
+1120,17
@@
sub tables_hash_hack {
'index' => [ [ 'svcnum' ] ],
},
'index' => [ [ 'svcnum' ] ],
},
+ 'svc_external' => {
+ 'columns' => [
+ 'svcnum', 'int', '', '',
+ 'id', 'int', '', '',
+ 'title', 'varchar', 'NULL', $char_d,
+ ],
+ 'primary_key' => 'svcnum',
+ 'unique' => [],
+ 'index' => [],
+ },
+
);
%tables;
);
%tables;