katao-coop-tilleul/data/sql/patch_2018-11-14_gestion-decimales.sql

SET AUTOCOMMIT = 0;
START TRANSACTION;

ALTER TABLE `katao_product` ADD `authorize_decimal` INTEGER(1) default 0 AFTER `unit_price_euro`;

ALTER TABLE `katao_cart_product` MODIFY `quantity` FLOAT;
ALTER TABLE `katao_cart_product` MODIFY `quantity_delivered` FLOAT;
ALTER TABLE `katao_cart_product` MODIFY `quantity_adjusted` FLOAT;

ALTER TABLE `katao_order_product` MODIFY `quantity` FLOAT;
ALTER TABLE `katao_order_product` MODIFY `quantity_received` FLOAT;
ALTER TABLE `katao_order_product` MODIFY `quantity_delivered` FLOAT;

ALTER TABLE `katao_invoice_product` MODIFY `quantity` FLOAT;
ALTER TABLE `katao_invoice_product` MODIFY `quantity_delivered` FLOAT;

ALTER TABLE `katao_supplier_invoice_product` MODIFY `quantity` FLOAT;

COMMIT;