The `base_discount_amount` field has never been in the `sales_order_grid` table

dmitry_fedyuk · February 11, 2024, 4:13pm

Magento 2.4.7-beta2

magento/magento2/blob/2.4.7-beta2/app/code/Magento/Sales/etc/db_schema.xml#L303-L341


      
          <table name="sales_order_grid" resource="sales" engine="innodb" comment="Sales Flat Order Grid">
              <column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="false"
                      comment="Entity ID"/>
              <column xsi:type="varchar" name="status" nullable="true" length="32" comment="Status"/>
              <column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
                      comment="Store ID"/>
              <column xsi:type="varchar" name="store_name" nullable="true" length="255" comment="Store Name"/>
              <column xsi:type="int" name="customer_id" unsigned="true" nullable="true" identity="false"
                      comment="Customer ID"/>
              <column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Base Grand Total"/>
              <column xsi:type="decimal" name="base_total_paid" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Base Total Paid"/>
              <column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Grand Total"/>
              <column xsi:type="decimal" name="total_paid" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Total Paid"/>
              <column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
              <column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
              <column xsi:type="varchar" name="order_currency_code" nullable="true" length="255"

This file has been truncated. show original

Magento 2.4.6

github.com

magento/magento2/blob/2.4.6/app/code/Magento/Sales/etc/db_schema.xml#L298-L336


      
          <table name="sales_order_grid" resource="sales" engine="innodb" comment="Sales Flat Order Grid">
              <column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="false"
                      comment="Entity ID"/>
              <column xsi:type="varchar" name="status" nullable="true" length="32" comment="Status"/>
              <column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
                      comment="Store ID"/>
              <column xsi:type="varchar" name="store_name" nullable="true" length="255" comment="Store Name"/>
              <column xsi:type="int" name="customer_id" unsigned="true" nullable="true" identity="false"
                      comment="Customer ID"/>
              <column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Base Grand Total"/>
              <column xsi:type="decimal" name="base_total_paid" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Base Total Paid"/>
              <column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Grand Total"/>
              <column xsi:type="decimal" name="total_paid" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Total Paid"/>
              <column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
              <column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
              <column xsi:type="varchar" name="order_currency_code" nullable="true" length="255"

This file has been truncated. show original

Magento 2.3.0

github.com

magento/magento2/blob/2.3.0/app/code/Magento/Sales/etc/db_schema.xml#L298-L336


      
          <table name="sales_order_grid" resource="sales" engine="innodb" comment="Sales Flat Order Grid">
              <column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="false"
                      comment="Entity Id"/>
              <column xsi:type="varchar" name="status" nullable="true" length="32" comment="Status"/>
              <column xsi:type="smallint" name="store_id" padding="5" unsigned="true" nullable="true" identity="false"
                      comment="Store Id"/>
              <column xsi:type="varchar" name="store_name" nullable="true" length="255" comment="Store Name"/>
              <column xsi:type="int" name="customer_id" padding="10" unsigned="true" nullable="true" identity="false"
                      comment="Customer Id"/>
              <column xsi:type="decimal" name="base_grand_total" scale="4" precision="12" unsigned="false" nullable="true"
                      comment="Base Grand Total"/>
              <column xsi:type="decimal" name="base_total_paid" scale="4" precision="12" unsigned="false" nullable="true"
                      comment="Base Total Paid"/>
              <column xsi:type="decimal" name="grand_total" scale="4" precision="12" unsigned="false" nullable="true"
                      comment="Grand Total"/>
              <column xsi:type="decimal" name="total_paid" scale="4" precision="12" unsigned="false" nullable="true"
                      comment="Total Paid"/>
              <column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment Id"/>
              <column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
              <column xsi:type="varchar" name="order_currency_code" nullable="true" length="255"

This file has been truncated. show original

dmitry_fedyuk · February 11, 2024, 4:28pm