-- 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 idxkhw3abx99me0gvygy8f9wnru8 ON blc_credit_account(owning_user_ref);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx7i0i5vcl1dkkwuq5dyc88wem5 ON blc_notification_state(acked);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxgfaqe3xmq5q4yh78mix1g04fy ON blc_notification_state(container);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxkm4y3qj3jh2mpt0rt6l6vscl8 ON blc_resource_lock(token);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxg339ltarhjlb53kie6i4whu91 ON blc_transaction(transaction_reference_id);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxd5p9gms1oxiaeophbhxgh5kb6 ON blc_transaction(source_entity_id);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxn4j14my27tsau5wg9f8r4r05x ON blc_transaction(request_id);
CREATE INDEX CONCURRENTLY IF NOT EXISTS fkkpucbcmxk6j1ci1dnpqjosf9b_idx ON blc_transaction(credit_account_id);
CREATE INDEX CONCURRENTLY IF NOT EXISTS idxov0vi6lbue0lbvdew039hx3uq ON blc_credit_account(account_number);
