ALTER TABLE blc_return_auth ADD version INT DEFAULT 0 NOT NULL;
ALTER TABLE blc_order_fulfillment ADD version INT DEFAULT 0 NOT NULL;

-- Below sql is not needed if upgrading from 1.7.5
----
ALTER TABLE blc_order ADD fees_total DECIMAL(19, 5) DEFAULT null NULL;
ALTER TABLE blc_order_item ADD type VARCHAR(60) NULL;
ALTER TABLE blc_order_item ADD prorated_order_adjustments DECIMAL(19, 5) DEFAULT null NULL;
ALTER TABLE blc_order ADD payment_distribution_details LONGTEXT NULL;
----
