}
+ my $primary_key_col = $tableobj->column($tableobj->primary_key)
+ or die "$table: primary key declared as ". $tableobj->primary_key.
+ ", but no column of that name\n";
+
my $historynum_type = ( $tableobj->column($tableobj->primary_key)->type
=~ /^(bigserial|bigint|int8)$/i
? 'bigserial'
'invnum', 'int', 'NULL', '', '', '',
'manual', 'char', 'NULL', 1, '', '',
'discount_term','int', 'NULL', '', '', '',
+ 'failure_status','varchar','NULL', 16, '', '',
],
'primary_key' => 'paypendingnum',
'unique' => [ [ 'payunique' ] ],
'amount', @money_type, '', '',
'currency', 'char', 'NULL', 3, '', '',
'status', 'varchar', 'NULL', $char_d, '', '',
+ 'failure_status','varchar', 'NULL', 16, '', '',
'error_message', 'varchar', 'NULL', $char_d, '', '',
],
'primary_key' => 'paybatchnum',
'index' => [ [ 'devicepart' ], [ 'svcnum' ], ],
},
+ 'vend_main' => {
+ 'columns' => [
+ 'vendnum', 'serial', '', '', '', '',
+ 'vendname', 'varchar', '', $char_d, '', '',
+ 'classnum', 'int', '', '', '', '',
+ 'disabled', 'char', 'NULL', 1, '', '',
+ ],
+ 'primary_key' => 'vendnum',
+ 'unique' => [ ['vendname', 'disabled'] ],
+ 'index' => [],
+ },
+
+ 'vend_class' => {
+ 'columns' => [
+ 'classnum', 'serial', '', '', '', '',
+ 'classname', 'varchar', '', $char_d, '', '',
+ 'disabled', 'char', 'NULL', 1, '', '',
+ ],
+ 'primary_key' => 'classnum',
+ 'unique' => [],
+ 'index' => [ ['disabled'] ],
+ },
+
+ 'vend_bill' => {
+ 'columns' => [
+ 'vendbillnum', 'serial', '', '', '', '',
+ 'vendnum', 'int', '', '', '', '',
+ '_date', @date_type, '', '',
+ 'charged', @money_type, '', '',
+ ],
+ 'primary_key' => 'vendbillnum',
+ 'unique' => [],
+ 'index' => [ ['vendnum'], ['_date'], ],
+ },
+
+ 'vend_pay' => {
+ 'columns' => [
+ 'vendpaynum', 'serial', '', '', '', '',
+ 'vendnum', 'int', '', '', '', '',
+ '_date', @date_type, '', '',
+ 'paid', @money_type, '', '',
+ ],
+ 'primary_key' => 'vendpaynum',
+ 'unique' => [],
+ 'index' => [ [ 'vendnum' ], [ '_date' ], ],
+ },
+
+ 'vend_bill_pay' => {
+ 'columns' => [
+ 'vendbillpaynum', 'serial', '', '', '', '',
+ 'vendbillnum', 'int', '', '', '', '',
+ 'vendpaynum', 'int', '', '', '', '',
+ 'amount', @money_type, '', '',
+ #? '_date', @date_type, '', '',
+ ],
+ 'primary_key' => 'vendbillpaynum',
+ 'unique' => [],
+ 'index' => [ [ 'vendbillnum' ], [ 'vendpaynum' ] ],
+ },
+
%{ tables_hashref_torrus() },
# tables of ours for doing torrus virtual port combining