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

        Hide
        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?
        Hide
        admin Paul Phillips added a comment -

        Made public and clarified title

        Show
        admin Paul Phillips added a comment - Made public and clarified title

          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