You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by bh...@apache.org on 2017/08/23 19:40:52 UTC

[cloudstack] branch master updated: CLOUDSTACK-9914: Update Quota plugin to support currency values up to 5 decimal places (#2123)

This is an automated email from the ASF dual-hosted git repository.

bhaisaab pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/master by this push:
     new 57255ac  CLOUDSTACK-9914: Update Quota plugin to support currency values up to 5 decimal places (#2123)
57255ac is described below

commit 57255ac72c99ee667a4d0ce765d67acbe4cc25ac
Author: Gabriel Beims Bräscher <ga...@gmail.com>
AuthorDate: Wed Aug 23 16:40:48 2017 -0300

    CLOUDSTACK-9914: Update Quota plugin to support currency values up to 5 decimal places (#2123)
    
    Summary: this commit alters column currency_value from table
    cloud_usage.quota_tariff to support values up to 5 decimal places. The
    current implementation allows up to 2 decimal places.
    
    Issue: need to use more than 2 decimal places to define resources values
    in Quota tariff.
    
    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"
---
 setup/db/db/schema-41000to41100-cleanup.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/setup/db/db/schema-41000to41100-cleanup.sql b/setup/db/db/schema-41000to41100-cleanup.sql
index 7fea017..60bc535 100644
--- a/setup/db/db/schema-41000to41100-cleanup.sql
+++ b/setup/db/db/schema-41000to41100-cleanup.sql
@@ -18,3 +18,6 @@
 --;
 -- Schema upgrade cleanup from 4.10.0.0 to 4.11.0.0
 --;
+
+-- CLOUDSTACK-9914: Alter quota_tariff to support currency values up to 5 decimal places
+ALTER TABLE `cloud_usage`.`quota_tariff` MODIFY `currency_value` DECIMAL(15,5) not null

-- 
To stop receiving notification emails like this one, please contact
['"commits@cloudstack.apache.org" <co...@cloudstack.apache.org>'].