qw( name type null length default local )
} );
- if ( $column->type eq 'serial' ) {
+ if ( $column->type =~ /^(\w*)SERIAL$/i ) {
$column->type('int');
$column->null('NULL');
}
'classnum', 'int', 'NULL', '', '', '',
'pay_weight', 'real', 'NULL', '', '', '',
'credit_weight', 'real', 'NULL', '', '', '',
+ 'agentnum', 'int', 'NULL', '', '', '',
+
],
'primary_key' => 'pkgpart',
'unique' => [],
- 'index' => [ [ 'promo_code' ], [ 'disabled' ] ],
+ 'index' => [ [ 'promo_code' ], [ 'disabled' ], [ 'agentnum' ], ],
},
# 'part_title' => {
],
'primary_key' => 'refnum',
'unique' => [],
- 'index' => [ ['disabled'] ],
+ 'index' => [ ['disabled'], ['agentnum'], ],
},
'part_svc' => {
'index' => [ ['username'], ['domsvc'] ],
},
- 'svc_acct_rt_transaction' => {
+ 'acct_rt_transaction' => {
'columns' => [
'svcrtid', 'int', '', '', '', '',
'svcnum', 'int', '', '', '', '',
'transaction_id', 'int', '', '', '', '',
'_date', @date_type, '', '',
'seconds', 'int', '', '', '', '', #uhhhh
+ 'support', 'int', '', '', '', '',
],
'primary_key' => 'svcrtid',
'unique' => [],
'catchall', 'int', 'NULL', '', '', '',
'parent_svcnum', 'int', 'NULL', '', '', '',
'registrarnum', 'int', 'NULL', '', '', '',
- 'registrarkey', 'varchar', 'NULL', '', '', '',
+ 'registrarkey', 'varchar', 'NULL', 512, '', '',
'setup_date', @date_type, '', '',
'renewal_interval', 'int', 'NULL', '', '', '',
'expiration_date', @date_type, '', '',
'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' => [],
###
'acctid', 'bigserial', '', '', '', '',
- 'calldate', 'TIMESTAMP with time zone', '', '', \'now()', '',
+ #'calldate', 'TIMESTAMP with time zone', '', '', \'now()', '',
+ 'calldate', 'timestamp', '', '', \'now()', '',
'clid', 'varchar', '', $char_d, \"''", '',
'src', 'varchar', '', $char_d, \"''", '',
'dst', 'varchar', '', $char_d, \"''", '',
'cdr_type' => {
'columns' => [
'cdrtypenum' => 'serial', '', '', '', '',
- 'cdrtypename' => 'varchar', '', '', '', '',
+ 'cdrtypename' => 'varchar', '', $char_d, '', '',
],
'primary_key' => 'cdrtypenum',
'unique' => [],
'cdr_carrier' => {
'columns' => [
'carrierid' => 'serial', '', '', '', '',
- 'carriername' => 'varchar', '', '', '', '',
+ 'carriername' => 'varchar', '', $char_d, '', '',
],
'primary_key' => 'carrierid',
'unique' => [],
'usernum', 'int', '', '', '', '',
'prefname', 'varchar', '', $char_d, '', '',
'prefvalue', 'text', 'NULL', '', '', '',
+ 'expiration', @date_type, '', '',
],
'primary_key' => 'prefnum',
'unique' => [],
'rightnum', 'serial', '', '', '', '',
'righttype', 'varchar', '', $char_d, '', '',
'rightobjnum', 'int', '', '', '', '',
- 'rightname', 'varchar', '', '', '', '',
+ 'rightname', 'varchar', '', $char_d, '', '',
],
'primary_key' => 'rightnum',
'unique' => [ [ 'righttype', 'rightobjnum', 'rightname' ] ],
'confnum', 'serial', '', '', '', '',
'agentnum', 'int', 'NULL', '', '', '',
'name', 'varchar', '', $char_d, '', '',
- 'value', 'varchar', 'NULL', '', '', '', # Pg specific
+ 'value', 'long varbinary', 'NULL', '', '', '',
],
'primary_key' => 'confnum',
'unique' => [ [ 'agentnum', 'name' ]],