X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=ac585108e55203cdde4d108632d3b4cea15df53f;hb=c22d84e565ab16db142395dce2e8621624eff140;hp=9074ae433647dfe39f42518e029cdda5a5149bcc;hpb=522d56b651bee0d586fbb5daa3196042bc6a9d8e;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 9074ae433..ac585108e 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -7418,6 +7418,26 @@ sub tables_hashref { ], }, + 'rt_field_charge' => { + 'columns' => [ + 'rtfieldchargenum', 'serial', '', '', '', '', + 'pkgnum', 'int', '', '', '', '', + 'ticketid', 'int', '', '', '', '', + 'rate', @money_type, '', '', + 'units', 'decimal', '', '10,4', '', '', + 'charge', @money_type, '', '', + '_date', @date_type, '', '', + ], + 'primary_key' => 'rtfieldchargenum', + 'unique' => [], + 'index' => [ ['pkgnum', 'ticketid'] ], + 'foreign_keys' => [ + { columns => [ 'pkgnum' ], + table => 'cust_pkg', + }, + ], + }, + # name type nullability length default local #'new_table' => {