-- Oracle does not support `IF NOT EXISTS` syntax when creating indexes.
-- You should review your database for any of the indexes described here that pre-exist,
-- and omit them from what you apply to your Oracle database.

CREATE INDEX IDXALJ2FI17MNJUA0NY1RQAREMDC ON BLC_ACCT_INVITE(ACCOUNT_ID) ONLINE;
CREATE INDEX IDXE28KFMGR4C9K6JYES49MO63J0 ON BLC_ACCT_INVITE(EMAIL) ONLINE;
CREATE INDEX IDXGC90WOULGS7I089PV6SFH4PTP ON BLC_ACCT_INVITE(EMAIL, ACCOUNT_ID) ONLINE;
CREATE INDEX IDXNQH476W7R82FAPKMOL7I3H0E0 ON BLC_ACCT_INVITE(ID, ACCOUNT_ID) ONLINE;
CREATE INDEX IDXHU5DJ71LCGW5NGLA5927NL2SN ON BLC_ACCOUNT_MEMBER(EMAIL) ONLINE;