-- Postgres supports `IF NOT EXISTS` syntax when creating indexes.
-- If an index already exists with the same name, it will not be duplicated.
-- However, you should still review your pre-existing indexes in advance
-- to make sure you do not already have one or more of the same indexes
-- defined under a different name. If so, you should omit them
-- from what you apply to your Postgres database.

CREATE INDEX CONCURRENTLY IF NOT EXISTS idxalj2fi17mnjua0ny1rqaremdc ON blc_acct_invite(account_id);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxe28kfmgr4c9k6jyes49mo63j0 ON blc_acct_invite(email);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxnqh476w7r82fapkmol7i3h0e0 ON blc_acct_invite(id, account_id);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxgc90woulgs7i089pv6sfh4ptp ON blc_acct_invite(email, account_id);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxhu5dj71lcgw5ngla5927nl2sn ON blc_account_member(email);