summaryrefslogtreecommitdiff
path: root/FS/FS/Schema.pm
diff options
context:
space:
mode:
authorJonathan Prykop <jonathan@freeside.biz>2016-07-16 15:43:42 -0500
committerJonathan Prykop <jonathan@freeside.biz>2016-08-14 19:16:38 -0500
commit0edd5b9d5c03f02341b1004888f0f712c8defb47 (patch)
tree6b0de01c7062d45ff852a88966e5764efb762ced /FS/FS/Schema.pm
parent630a48c51cc20dd2e2c2a09a61999e5a0ae3e5ba (diff)
RT#38973: Bill for time worked on ticket resolution [checkpoint, not ready for backport]
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r--FS/FS/Schema.pm20
1 files changed, 20 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 7d92d65..b09266b 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -7438,6 +7438,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' => {