X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=73392e86c5e5ae9ef9c6fa95b7a60dc39ab2a878;hb=f8f4c51eaa6f5aa3d49672fe7a17f19fa22494c0;hp=0b54282ef3b52464eec3398e4da3e6dc2772f8c5;hpb=940401c77b8455dd47b57e06dcfedd7514c24a7c;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 0b54282ef..73392e86c 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1803,7 +1803,7 @@ sub tables_hashref { 'cgp_rule_condition' => { 'columns' => [ 'ruleconditionnum', 'serial', '', '', '', '', - 'condition', 'varchar', '', $char_d, '', '', + 'conditionname', 'varchar', '', $char_d, '', '', 'op', 'varchar', 'NULL', $char_d, '', '', 'params', 'varchar', 'NULL', 255, '', '', 'rulenum', 'int', '', '', '', '', @@ -2799,10 +2799,11 @@ sub tables_hashref { 'svc_pbx' => { 'columns' => [ - 'svcnum', 'int', '', '', '', '', - 'id', 'int', 'NULL', '', '', '', - 'title', 'varchar', 'NULL', $char_d, '', '', - 'max_extensions', 'int', 'NULL', '', '', '', + 'svcnum', 'int', '', '', '', '', + 'id', 'int', 'NULL', '', '', '', + 'title', 'varchar', 'NULL', $char_d, '', '', + 'max_extensions', 'int', 'NULL', '', '', '', + 'max_simultaneous', 'int', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', 'unique' => [], @@ -2848,6 +2849,41 @@ sub tables_hashref { 'index' => [['listnum'],['svcnum'],['contactemailnum'],['email']], }, + 'bill_batch' => { + 'columns' => [ + 'batchnum', 'serial', '', '', '', '', + 'status', 'char', 'NULL','1', '', '', + 'pdf', 'blob', 'NULL', '', '', '', + ], + 'primary_key' => 'batchnum', + 'unique' => [], + 'index' => [], + }, + + 'cust_bill_batch' => { + 'columns' => [ + 'billbatchnum', 'serial', '', '', '', '', + 'batchnum', 'int', '', '', '', '', + 'invnum', 'int', '', '', '', '', + ], + 'primary_key' => 'billbatchnum', + 'unique' => [], + 'index' => [ [ 'batchnum' ], [ 'invnum' ] ], + }, + + 'cust_bill_batch_option' => { + 'columns' => [ + 'optionnum', 'serial', '', '', '', '', + 'billbatchnum', 'int', '', '', '', '', + 'optionname', 'varchar', '', $char_d, '', '', + 'optionvalue', 'text', 'NULL', '', '', '', + ], + 'primary_key' => 'optionnum', + 'unique' => [], + 'index' => [ [ 'billbatchnum' ], [ 'optionname' ] ], + }, + + # name type nullability length default local