diff options
author | jeff <jeff> | 2009-11-20 17:33:40 +0000 |
---|---|---|
committer | jeff <jeff> | 2009-11-20 17:33:40 +0000 |
commit | 62bfeae993beb7f98d50d319360f1fece128982b (patch) | |
tree | 6c97d81c0983b672dfeb15aeaf00f8be58cf4dec /FS/FS/Schema.pm | |
parent | 457cf05ffc31212de613249c95a8ab05aed34f47 (diff) |
invoice formatting: add sections for usage, add sections per svc_phone, add folding like line items into one #6592
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r-- | FS/FS/Schema.pm | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index f4cbe1d30..553ddc2a8 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -573,7 +573,9 @@ sub tables_hashref { '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', @@ -2010,9 +2012,11 @@ sub tables_hashref { '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' => [], @@ -2125,6 +2129,7 @@ sub tables_hashref { 'categorynum', 'serial', '', '', '', '', 'categoryname', 'varchar', '', $char_d, '', '', 'weight', 'int', 'NULL', '', '', '', + 'condense', 'char', 'NULL', 1, '', '', 'disabled', 'char', 'NULL', 1, '', '', ], 'primary_key' => 'categorynum', |