add index to rate_prefix.npa for a performance improvement on CDR billing, RT#6386

[freeside.git] / FS / FS / Schema.pm

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 553ddc2..690cba5 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -380,8 +380,9 @@ sub tables_hashref {
         'otaker',    'varchar', '', 32, '', '',
         'filename',  'varchar', '', 32, '', '',
         'mime_type', 'varchar', '', 32, '', '',
+        'title',     'varchar', 'NULL', 32, '', '',
         'body',      'blob', 'NULL', '', '', '',
-        'disabled',  @date_type, '', '',
+        'disabled',  'varchar', 'NULL', '10', '',
       ],
       'primary_key' => 'attachnum',
       'unique'      => [],
@@ -2007,7 +2008,7 @@ sub tables_hashref {
       ],
       'primary_key' => 'prefixnum',
       'unique'      => [],
-      'index'       => [ [ 'countrycode' ], [ 'regionnum' ] ],
+      'index'       => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ],
     },
 
     'usage_class' => {