cart icon indicating copy to clipboard operation
cart copied to clipboard

Fix: Replace deprecated double(11,2) with decimal(10,2) in ext_tables.sql

Open kitzberger opened this issue 2 months ago • 0 comments

The ext_tables.sql file used the deprecated MySQL syntax double(11,2) for decimal fields, which causes constant schema migration prompts when running DB compare.

MySQL/MariaDB interprets double(11,2) ambiguously, and Doctrine DBAL schema comparison detected a type mismatch between the defined schema and what TYPO3 generates from TCA configuration. The TCA defines these fields as type => 'number' with format => 'decimal', which TYPO3's DefaultTcaSchema class converts to decimal(10,2).

This change replaces all occurrences of double(11,2) with decimal(10,2) to align with TYPO3's schema generation and eliminate the persistent migration warnings.

Affected fields:

  • tx_cart_domain_model_order_item: gross, net, total_gross, total_net
  • tx_cart_domain_model_order_taxclass: calc
  • tx_cart_domain_model_order_tax: tax
  • tx_cart_domain_model_order_product: price, discount, gross, net, tax
  • tx_cart_domain_model_order_discount: gross, net, tax
  • tx_cart_domain_model_order_shipping: gross, net, tax
  • tx_cart_domain_model_order_payment: gross, net, tax
  • tx_cart_domain_model_coupon: discount, cart_min_price

Resolves: #711

kitzberger avatar Oct 26 '25 13:10 kitzberger