Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-2280

Increase pricing decimal length from 12,4 to 19,4

        Details

        • Type: Improvement
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 4.1.0-b1
        • Component/s: None
        • Labels:
          None

          Description

          Decimal storage for pricing/amounts are currently set to decimal(12,4). We should increase this to decimal(19,4) to better allow support for international currencies. Some currencies have a ratio of 30,000:1 compared to the USD.

          All database pricing and amounts that use this precision must be updated.

            Activity

            Ascending order - Click to sort in descending order
            tyson Tyson Phillips (Inactive) created issue -
            tyson Tyson Phillips (Inactive) made changes -
            Field Original Value New Value
            Story Points 3
            tyson Tyson Phillips (Inactive) made changes -
            Rank Ranked higher
            tyson Tyson Phillips (Inactive) made changes -
            Sprint 4.1.0 Sprint 2 [ 39 ]
            tyson Tyson Phillips (Inactive) made changes -
            Assignee Tyson Phillips [ tyson ]
            Automated transition triggered when Jonathan Reissmueller created a branch in Stash -
            Status Open [ 1 ] In Progress [ 3 ]
            jonathan Jonathan Reissmueller made changes -
            Assignee Jonathan Reissmueller [ jonathan ]
            Hide
            Permalink
            jonathan Jonathan Reissmueller added a comment -

            The blesta_reseller plugin creates a table with one such field, should I update that as well, or just the core tables?

            Show
            jonathan Jonathan Reissmueller added a comment - The blesta_reseller plugin creates a table with one such field, should I update that as well, or just the core tables?
            Automated transition triggered when Jonathan Reissmueller created pull request #253 in Stash -
            Status In Progress [ 3 ] In Review [ 5 ]
            Resolution Fixed [ 1 ]
            jonathan Jonathan Reissmueller made changes -
            Fix Version/s 4.1.0 [ 11007 ]
            Fix Version/s Short Term [ 10800 ]
            Automated transition triggered when Tyson Phillips (Inactive) merged pull request #253 in Stash -
            Status In Review [ 5 ] Closed [ 6 ]
            admin Paul Phillips made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            admin Paul Phillips made changes -
            Security Private [ 10000 ]
            admin Paul Phillips made changes -
            Summary Increase amount storage length Increase pricing decimal length from 12,4 to 19,4
            Hide
            Permalink
            admin Paul Phillips added a comment -

            Made public and clarified title

            Show
            admin Paul Phillips added a comment - Made public and clarified title
            admin Paul Phillips made changes -
            Status Reopened [ 4 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]

              People

              • Assignee:
                jonathan Jonathan Reissmueller
                Reporter:
                tyson Tyson Phillips (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  17/Jul/17

                  Agile