projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add cust_pkg2 index on cust_pkg.pkgpart
[freeside.git]
/
FS
/
FS
/
Schema.pm
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
c11fd05
..
aaca5ef
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-226,13
+226,15
@@
sub dbdef_dist {
sub tables_hashref {
sub tables_hashref {
- my
($char_d)
= 80; #default maxlength for text fields
+ my
$char_d
= 80; #default maxlength for text fields
#my(@date_type) = ( 'timestamp', '', '' );
#my(@date_type) = ( 'timestamp', '', '' );
- my
(@date_type)
= ( 'int', 'NULL', '' );
- my
(@perl_type)
= ( 'text', 'NULL', '' );
+ my
@date_type
= ( 'int', 'NULL', '' );
+ my
@perl_type
= ( 'text', 'NULL', '' );
my @money_type = ( 'decimal', '', '10,2' );
my @money_type = ( 'decimal', '', '10,2' );
+ my $username_len = 32; #usernamemax config file
+
return {
'agent' => {
return {
'agent' => {
@@
-245,6
+247,7
@@
sub tables_hashref {
'disabled', 'char', 'NULL', 1,
'username', 'varchar', 'NULL', $char_d,
'_password','varchar', 'NULL', $char_d,
'disabled', 'char', 'NULL', 1,
'username', 'varchar', 'NULL', $char_d,
'_password','varchar', 'NULL', $char_d,
+ 'ticketing_queueid', 'int', 'NULL', '',
],
'primary_key' => 'agentnum',
'unique' => [],
],
'primary_key' => 'agentnum',
'unique' => [],
@@
-558,7
+561,7
@@
sub tables_hashref {
],
'primary_key' => 'pkgnum',
'unique' => [],
],
'primary_key' => 'pkgnum',
'unique' => [],
- 'index' => [ ['custnum'] ],
+ 'index' => [ ['custnum']
, ['pkgpart']
],
},
'cust_refund' => {
},
'cust_refund' => {
@@
-1119,7
+1122,7
@@
sub tables_hashref {
],
'primary_key' => 'ratedetailnum',
'unique' => [ [ 'ratenum', 'orig_regionnum', 'dest_regionnum' ] ],
],
'primary_key' => 'ratedetailnum',
'unique' => [ [ 'ratenum', 'orig_regionnum', 'dest_regionnum' ] ],
- 'index' => [],
+ 'index' => [
[ 'ratenum', 'dest_regionnum' ]
],
},
'rate_region' => {
},
'rate_region' => {