ALTER TABLE BLC_RETURN_AUTH ADD VERSION NUMBER(10, 0) DEFAULT 0 NOT NULL;
ALTER TABLE BLC_ORDER_FULFILLMENT ADD VERSION NUMBER(10, 0) DEFAULT 0 NOT NULL;

-- Below sql is not needed if upgrading from 1.7.5
----
ALTER TABLE BLC_ORDER ADD FEES_TOTAL NUMBER(19, 5);
ALTER TABLE BLC_ORDER_ITEM ADD TYPE VARCHAR2(60 CHAR);
ALTER TABLE BLC_ORDER_ITEM ADD PRORATED_ORDER_ADJUSTMENTS DECIMAL(19, 5);
ALTER TABLE BLC_ORDER ADD PAYMENT_DISTRIBUTION_DETAILS CLOB NULL;
----