],
'primary_key' => 'invnum',
'unique' => [],
- 'index' => [ ['custnum'] ],
+ 'index' => [ ['custnum'], ['_date'] ],
},
'cust_bill_event' => {
'last', 'varchar', '', $char_d,
# 'middle', 'varchar', 'NULL', $char_d,
'first', 'varchar', '', $char_d,
- 'ss', 'char', 'NULL', 11,
+ 'ss', 'varchar', 'NULL', 11,
'company', 'varchar', 'NULL', $char_d,
'address1', 'varchar', '', $char_d,
'address2', 'varchar', 'NULL', $char_d,
#'reczone', 'varchar', '', $char_d,
'reczone', 'varchar', '', 255,
'recaf', 'char', '', 2,
- 'rectype', 'char', '', 5,
+ 'rectype', 'varchar', '', 5,
#'recdata', 'varchar', '', $char_d,
'recdata', 'varchar', '', 255,
],
'addr_block' => {
'columns' => [
- 'blocknum', 'int', '', '',
+ 'blocknum', 'serial', '', '',
'routernum', 'int', '', '',
'ip_gateway', 'varchar', '', 15,
'ip_netmask', 'int', '', '',
'part_sb_field' => {
'columns' => [
- 'sbfieldpart', 'int', '', '',
+ 'sbfieldpart', 'serial', '', '',
'svcpart', 'int', '', '',
'name', 'varchar', '', $char_d,
'length', 'int', '', '',