[CLOUDSTACK-9914] Alter quota_tariff to support currency values up to 5 decimal places

• Type: Improvement
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 4.9.0, 4.9.2.0, 4.9.1.0, 4.9.0.1, 4.9.3.0
• Fix Version/s: 4.10.1.0
• Component/s: Install and Setup
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Gabriel Beims Bräscher
• Reporter: Gabriel Beims Bräscher
• Created: 09/May/17 15:11
• Updated: 26/Sep/17 19:04
• Resolved: 26/Sep/17 19:04

Description

Issue: the current quota plugin does not allow configuring currency values with more than two decimal places. For instance, I would like to configure $0.0125 for using 1 CPU of clock rate 100MHz and $0.00599 for the network usage (Bytes Sent).

Solution: modify column currency_value from table cloud_usage.quota_tariff to support values up to 5 decimal places. Values with more than 5 decimal places will be displayed with scientific notation in the user interface.

SQL command: "ALTER TABLE cloud_usage.quota_tariff MODIFY currency_value DECIMAL(15,5) not null"