'otaker', 'varchar', '', 32, '', '',
'filename', 'varchar', '', 32, '', '',
'mime_type', 'varchar', '', 32, '', '',
+ 'title', 'varchar', 'NULL', 32, '', '',
'body', 'blob', 'NULL', '', '', '',
- 'disabled', @date_type, '', '',
+ 'disabled', 'varchar', 'NULL', '10', '',
],
'primary_key' => 'attachnum',
'unique' => [],
'amount', 'decimal', 'NULL', '10,4', '', '',
'format', 'char', 'NULL', 1, '', '',
'classnum', 'int', 'NULL', '', '', '',
+ 'duration', 'int', 'NULL', '', 0, '',
'phonenum', 'varchar', 'NULL', 15, '', '',
+ 'regionname', 'varchar', 'NULL', $char_d, '', '',
'detail', 'varchar', '', 255, '', '',
],
'primary_key' => 'detailnum',
],
'primary_key' => 'prefixnum',
'unique' => [],
- 'index' => [ [ 'countrycode' ], [ 'regionnum' ] ],
+ 'index' => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ],
},
'usage_class' => {
'columns' => [
- 'classnum', 'serial', '', '', '', '',
- 'classname', 'varchar', '', $char_d, '', '',
- 'disabled', 'char', 'NULL', 1, '', '',
+ 'classnum', 'serial', '', '', '', '',
+ 'weight', 'int', 'NULL', '', '', '',
+ 'classname', 'varchar', '', $char_d, '', '',
+ 'format', 'varchar', 'NULL', $char_d, '', '',
+ 'disabled', 'char', 'NULL', 1, '', '',
],
'primary_key' => 'classnum',
'unique' => [],
'categorynum', 'serial', '', '', '', '',
'categoryname', 'varchar', '', $char_d, '', '',
'weight', 'int', 'NULL', '', '', '',
+ 'condense', 'char', 'NULL', 1, '', '',
'disabled', 'char', 'NULL', 1, '', '',
],
'primary_key' => 'categorynum',
#an indexed place to put big numbers
'cdrid', 'bigint', 'NULL', '', '', '',
- #i should become a table
+ #old
'cdrbatch', 'varchar', 'NULL', 255, '', '',
- #'cdrbatchnum', 'int', 'NULL', '', '', '',
+ #new
+ 'cdrbatchnum', 'int', 'NULL', '', '', '',
],
'primary_key' => 'acctid',
],
},
- #'cdr_batch' => {
- # 'columns' => [
- # 'cdrbatchnum', 'serial', '', '', '', '',
- # 'cdrbatch', 'varchar', 'NULL', 255, '', '',
- # '_date', @date_type, '', '',
- # ],
- # 'primary_key' => 'cdrbatchnum',
- # 'unique' => [ [ 'cdrbatch' ] ],
- # 'index' => [],
- #},
+ 'cdr_batch' => {
+ 'columns' => [
+ 'cdrbatchnum', 'serial', '', '', '', '',
+ 'cdrbatch', 'varchar', 'NULL', 255, '', '',
+ '_date', @date_type, '', '',
+ ],
+ 'primary_key' => 'cdrbatchnum',
+ 'unique' => [ [ 'cdrbatch' ] ],
+ 'index' => [],
+ },
'cdr_termination' => {
'columns' => [