'index' => [ ['custnum'], ['_date'], ['statementnum'], ['agent_invid'] ],
},
+ #for importing invoices from a legacy system for display purposes only
+ # no effect upon balance
+ 'legacy_cust_bill' => {
+ 'columns' => [
+ 'legacyinvnum', 'serial', '', '', '', '',
+ 'legacyid', 'varchar', 'NULL', $char_d, '', '',
+ 'custnum', 'int', '', '', '', '',
+ '_date', @date_type, '', '',
+ 'charged', @money_type, '', '',
+ 'content_pdf', 'blob', 'NULL', '', '', '',
+ 'content_html', 'text', 'NULL', '', '', '',
+ ],
+ 'primary_key' => 'legacyinvnum',
+ 'unique' => [],
+ 'index' => [ ['legacyid', 'custnum'], ],
+ },
+
'cust_statement' => {
'columns' => [
'statementnum', 'serial', '', '', '', '',
'billday', 'int', 'NULL', '', '', '',
'edit_subject', 'char', 'NULL', 1, '', '',
'locale', 'varchar', 'NULL', 16, '', '',
+ 'calling_list_exempt', 'char', 'NULL', 1, '', '',
],
'primary_key' => 'custnum',
'unique' => [ [ 'agentnum', 'agent_custid' ] ],
'pay_batch' => { #batches of payments to an external processor
'columns' => [
- 'batchnum', 'serial', '', '', '', '',
- 'payby', 'char', '', 4, '', '', # CARD/CHEK
- 'status', 'char', 'NULL', 1, '', '',
- 'download', @date_type, '', '',
- 'upload', @date_type, '', '',
+ 'batchnum', 'serial', '', '', '', '',
+ 'agentnum', 'int', 'NULL', '', '', '',
+ 'payby', 'char', '', 4, '', '', # CARD/CHEK
+ 'status', 'char', 'NULL', 1, '', '',
+ 'download', @date_type, '', '',
+ 'upload', @date_type, '', '',
],
'primary_key' => 'batchnum',
'unique' => [],
'index' => [],
},
- 'cust_pay_batch' => { #what's this used for again? list of customers
- #in current CARD batch? (necessarily CARD?)
+ 'cust_pay_batch' => { #list of customers in current CARD/CHEK batch
'columns' => [
'paybatchnum', 'serial', '', '', '', '',
'batchnum', 'int', '', '', '', '',
'nas' => {
'columns' => [
- 'nasnum', 'serial', '', '', '', '',
- 'nas', 'varchar', '', $char_d, '', '',
- 'nasip', 'varchar', '', 15, '', '',
- 'nasfqdn', 'varchar', '', $char_d, '', '',
- 'last', 'int', '', '', '', '',
+ 'nasnum', 'serial', '', '', '', '',
+ 'nasname', 'varchar', '', 128, '', '',
+ 'shortname', 'varchar', 'NULL', 32, '', '',
+ 'type', 'varchar', '', 30, 'other', '',
+ 'ports', 'int', 'NULL', '', '', '',
+ 'secret', 'varchar', '', 60, 'secret', '',
+ 'server', 'varchar', 'NULL', 64, '', '',
+ 'community', 'varchar', 'NULL', 50, '', '',
+ 'description', 'varchar', '', 200, 'RADIUS Client', '',
],
'primary_key' => 'nasnum',
- 'unique' => [ [ 'nas' ], [ 'nasip' ] ],
- 'index' => [ [ 'last' ] ],
+ 'unique' => [ [ 'nasname' ], ],
+ 'index' => [],
},
-# 'session' => {
-# 'columns' => [
-# 'sessionnum', 'serial', '', '', '', '',
-# 'portnum', 'int', '', '', '', '',
-# 'svcnum', 'int', '', '', '', '',
-# 'login', @date_type, '', '',
-# 'logout', @date_type, '', '',
-# ],
-# 'primary_key' => 'sessionnum',
-# 'unique' => [],
-# 'index' => [ [ 'portnum' ] ],
-# },
+ 'export_nas' => {
+ 'columns' => [
+ 'exportnasnum', 'serial', '', '', '', '',
+ 'exportnum', 'int', '', '', '', '',
+ 'nasnum', 'int', '', '', '', '',
+ ],
+ 'primary_key' => 'exportnasnum',
+ 'unique' => [ [ 'exportnum', 'nasnum' ] ],
+ 'index' => [ [ 'exportnum' ], [ 'nasnum' ] ],
+ },
'queue' => {
'columns' => [