12345678910111213141516171819 |
- 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;
|