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

-- Below sql is not needed if upgrading from 1.7.5
----
ALTER TABLE blc_order ADD fees_total numeric(19, 5);
ALTER TABLE blc_order_item ADD type VARCHAR(60);
ALTER TABLE blc_order_item ADD prorated_order_adjustments numeric(19, 5);
ALTER TABLE blc_order ADD payment_distribution_details VARCHAR(10485760);
----