-- 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 idxosj785tkew6sxuw6sd26k70qk ON blc_application_catalog(context_id);
CREATE INDEX IF NOT EXISTS idxlj2n3wdt6u930s8c5g28hh0yr ON blc_application_catalog(application_id);
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 idx3b08854ote03j6quut23m4udk ON blc_order(customer_id);
CREATE INDEX IF NOT EXISTS idxmxe1i41u3ksbvbw3lol0m0sn5 ON blc_order(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idx17qpx028lb4c5hdwiwxd1gbqw ON blc_order_fulfill_item_tax_detail(transaction_id);
CREATE INDEX IF NOT EXISTS fk1ewfxupk0ol1fjrlrdvvucmfy_idx ON blc_order_fulfill_item_tax_detail(fulfillment_item_id);
CREATE INDEX IF NOT EXISTS idx35qsqkn51kt4rywmdi1vamdk7 ON blc_order_fulfillment(order_id);
CREATE INDEX IF NOT EXISTS idx9mt3oihq3jmllfuv8rmnikia9 ON blc_order_fulfillment(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idx2tkdks09mh5jykeotm17vmcbw ON blc_order_fulfillment_item(order_fulfillment_id);
CREATE INDEX IF NOT EXISTS idxgygk764or9io1b8g80c2ch6v8 ON blc_order_fulfillment_note(order_fulfillment_context_id);
CREATE INDEX IF NOT EXISTS fkgi0gu1f14t21cda3qyop5mobv_idx ON blc_order_item(order_id);
CREATE INDEX IF NOT EXISTS idxi0l1xcvpjx3s4wfstit0r1b0q ON blc_order_note(order_context_id);
CREATE INDEX IF NOT EXISTS idxkm4y3qj3jh2mpt0rt6l6vscl8 ON blc_resource_lock(token);
CREATE INDEX IF NOT EXISTS idx5sh09rkf6n9pht6nth7jf26kl ON blc_return_auth(order_id);
CREATE INDEX IF NOT EXISTS fken1a07dpla99icvgws8bgfdid_idx ON blc_return_confirmation(return_auth_item_id);
CREATE INDEX IF NOT EXISTS fksxk3jvexnqxdtgq1xk334xakg_idx ON blc_return_auth_item(return_auth_id);
CREATE INDEX IF NOT EXISTS idxusrmtlej61uxhx0yiwpb2rcrv ON blc_notification_state(acked, stopped, notification_name, change_timestamp, next_attempt);