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 {
 
-  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)  = ( 'int', 'NULL', ''     );
-  my(@perl_type) = ( 'text', 'NULL', ''  ); 
+  my @date_type  = ( 'int', 'NULL', ''     );
+  my @perl_type = ( 'text', 'NULL', ''  ); 
   my @money_type = ( 'decimal',   '', '10,2' );
 
+  my $username_len = 32; #usernamemax config file
+
   return {
 
     'agent' => {
@@ -245,6 +247,7 @@ sub tables_hashref {
         'disabled',     'char', 'NULL', 1,
         'username', 'varchar',       'NULL',     $char_d,
         '_password','varchar',       'NULL',     $char_d,
+        'ticketing_queueid', 'int', 'NULL', '',
       ],
       'primary_key' => 'agentnum',
       'unique' => [],
@@ -558,7 +561,7 @@ sub tables_hashref {
       ],
       'primary_key' => 'pkgnum',
       'unique' => [],
-      'index' => [ ['custnum'] ],
+      'index' => [ ['custnum'], ['pkgpart'] ],
     },
 
     'cust_refund' => {
@@ -1119,7 +1122,7 @@ sub tables_hashref {
       ],
       'primary_key' => 'ratedetailnum',
       'unique'      => [ [ 'ratenum', 'orig_regionnum', 'dest_regionnum' ] ],
-      'index'       => [],
+      'index'       => [ [ 'ratenum', 'dest_regionnum' ] ],
     },
 
     'rate_region' => {