diff options
| author | ivan <ivan> | 2008-09-15 07:18:57 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2008-09-15 07:18:57 +0000 |
| commit | dcc553538ede04c0783bc92d3942c905c29131c1 (patch) | |
| tree | bff35615cfa95478c0ee1bfb757ecb228da2c78f /FS/FS/Schema.pm | |
| parent | f9befdcb5ce8cf5dc5b9cacb6fe04ce29ed3cb80 (diff) | |
add internal did database & ability to query for availability, plus upload tool
Diffstat (limited to 'FS/FS/Schema.pm')
| -rw-r--r-- | FS/FS/Schema.pm | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index c0fd4666a..22bd19ef3 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -2112,10 +2112,19 @@ sub tables_hashref { 'state', 'char', 'NULL', 2, '', '', 'npa', 'char', '', 3, '', '', 'nxx', 'char', 'NULL', 3, '', '', + 'station', 'char', 'NULL', 4, '', '', + 'svcnum', 'int', 'NULL', '', '', '', + 'availbatch', 'varchar', 'NULL', $char_d, '', '', ], 'primary_key' => 'availnum', 'unique' => [], - 'index' => [ [ 'exportnum', 'countrycode', 'state' ] ], + 'index' => [ [ 'exportnum', 'countrycode', 'state' ], #npa search + [ 'exportnum', 'countrycode', 'npa' ], #nxx search + [ 'exportnum', 'countrycode', 'npa', 'nxx' ],#station search + [ 'exportnum', 'countrycode', 'npa', 'nxx', 'station' ], # # + [ 'svcnum' ], + [ 'availbatch' ], + ], }, 'reason_type' => { |