-- YugabyteDb 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 YugabyteDb database.

CREATE INDEX IF NOT EXISTS idx7i0i5vcl1dkkwuq5dyc88wem5 ON blc_notification_state(acked);
CREATE INDEX IF NOT EXISTS idxgfaqe3xmq5q4yh78mix1g04fy ON blc_notification_state(container);
CREATE INDEX IF NOT EXISTS idxmb5ixjylopr5dwig7jehaouae ON blc_payment(owner_id);
CREATE INDEX IF NOT EXISTS idx95tygwbgox126dfii1sf0wy7q ON blc_payment_transaction(transaction_reference_id);
CREATE INDEX IF NOT EXISTS idx87rtkhuech0jf5qn3932jfki1 ON blc_payment_transaction(source_entity_id);
CREATE INDEX IF NOT EXISTS idxtjvikdatat8etrnqk13yqxfdf ON blc_payment_transaction(request_id);
CREATE INDEX IF NOT EXISTS fkeqnspi0p8wrsjjrgxovtc4m5c_idx ON blc_payment_transaction(payment_id);
CREATE INDEX IF NOT EXISTS idxkm4y3qj3jh2mpt0rt6l6vscl8 ON blc_resource_lock(token);
CREATE INDEX IF NOT EXISTS idxsupnqyofpbpog4tt7yvjay10e ON blc_saved_payment_method(owning_user_id);
CREATE INDEX IF NOT EXISTS idx437xmdg8bk2i0we7mqkoo4own ON blc_saved_payment_method(originating_payment_id);
CREATE INDEX IF NOT EXISTS idxvsrmtlej61uxhx0yiwpb2rcrv ON blc_notification_state(acked, stopped, notification_name, change_timestamp, next_attempt);
