diff options
| author | ivan <ivan> | 2009-03-24 06:31:06 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-03-24 06:31:06 +0000 |
| commit | 5bc96f1f56a0549bcf2cebdea0ad4bcae815d021 (patch) | |
| tree | f87cecab6f17473a9625a5d78ad883aec7e82aca | |
| parent | 9006e983ebf98b2000a812ab01f99dcb2335534c (diff) | |
add indices for analyzing cc failures, RT#3843
| -rw-r--r-- | FS/FS/Schema.pm | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 7307165da..745cf674b 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -398,7 +398,9 @@ sub tables_hashref { 'primary_key' => 'eventnum', #no... there are retries now #'unique' => [ [ 'eventpart', 'invnum' ] ], 'unique' => [], - 'index' => [ ['invnum'], ['status'], ['eventpart'] ], + 'index' => [ ['invnum'], ['status'], ['eventpart'], + ['statustext'], ['_date'], + ], }, 'part_bill_event' => { @@ -495,7 +497,9 @@ sub tables_hashref { 'primary_key' => 'eventnum', #no... there are retries now #'unique' => [ [ 'eventpart', 'invnum' ] ], 'unique' => [], - 'index' => [ ['eventpart'], ['tablenum'], ['status'] ], + 'index' => [ ['eventpart'], ['tablenum'], ['status'], + ['statustext'], ['_date'], + ], }, 'cust_bill_pkg' => { |