ALTER TABLE BLC_ORDER ADD ACCOUNT_HIERARCHY CLOB;
ALTER TABLE BLC_ORDER ADD ACCOUNT_ID VARCHAR2(36 CHAR);
ALTER TABLE BLC_ORDER ADD APPROVER_EMAIL VARCHAR2(255 CHAR);
ALTER TABLE BLC_ORDER ADD ROOT_ACCOUNT_ID VARCHAR2(36 CHAR);