'transaction_id', 'int', '', '', '', '',
'_date', @date_type, '', '',
'seconds', 'int', '', '', '', '', #uhhhh
+ 'support', 'int', '', '', '', '',
],
'primary_key' => 'svcrtid',
'unique' => [],
'status', 'varchar', '', $char_d, '', '',
'statustext', 'text', 'NULL', '', '', '',
'svcnum', 'int', 'NULL', '', '', '',
+ 'secure', 'char', 'NULL', 1, '', '', # Y = needs to be run on machine
+ # w/private key
],
'primary_key' => 'jobnum',
'unique' => [],