-- 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 idxc33gpiktcmmun1orfuo6ktf8y ON blc_menu(context_id);
CREATE INDEX IF NOT EXISTS idxig0xtoijg8qidnlfysotny6j2 ON blc_menu(name);
CREATE INDEX IF NOT EXISTS idxcy8m55bpau14yl58qfncak7hj ON blc_menu(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idxm1d6f26h0mflxhbh8gbbhdwbh ON blc_menu(trk_sandbox_context_id);
CREATE INDEX IF NOT EXISTS idxtgva61b1rotshb23nqko5q4mu ON blc_menu(trk_sandbox_name);
CREATE INDEX IF NOT EXISTS idxcc5naoagmtnxxgn10tb7yu8a2 ON blc_menu_item(context_id);
CREATE INDEX IF NOT EXISTS idxgr4g6tirabm0rvcs5dfdhbkyi ON blc_menu_item(label);
CREATE INDEX IF NOT EXISTS idx5yc7kg8qusmay2159cmanw8vx ON blc_menu_item(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idx6nqmhfo1rs304giixudqn0dxt ON blc_menu_item(parent_menu_item_context_id);
CREATE INDEX IF NOT EXISTS idxb51diedgp6jadbfbnnbwp79k1 ON blc_menu_item(parent_menu_context_id);
CREATE INDEX IF NOT EXISTS idxbhvvq0cdbkdpk9s15seboben1 ON blc_menu_item(trk_sandbox_context_id);
CREATE INDEX IF NOT EXISTS idxp576wl7qfshj1g8b1nu14rd0y ON blc_menu_item(trk_sandbox_name);
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 idxkm4y3qj3jh2mpt0rt6l6vscl8 ON blc_resource_lock(token);
CREATE INDEX IF NOT EXISTS idx4g14mrkab7tl3rd54ikx57k55 ON blc_translation(context_id);
CREATE INDEX IF NOT EXISTS idxgqgqttrr6uevhl0mjfwvfo4j1 ON blc_translation(trk_sandbox_context_id);
CREATE INDEX IF NOT EXISTS idxmttybtsh30xho30olqopnhs26 ON blc_translation(trk_sandbox_name);
CREATE INDEX IF NOT EXISTS idxhawx2xhnhqoqd7mct9qm7ces ON blc_translation(trk_catalog_context_id);
CREATE INDEX IF NOT EXISTS idxiwmmb8q1xtfycw8strr12ospk ON blc_translation(trk_parent_cat_context_id);
CREATE INDEX IF NOT EXISTS idxay3ff6dyxatoqm7lwxmualc9v ON blc_translation(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idxh167c7f9ai480kx8gn7ww1f4h ON blc_translation(entity_type, entity_id, locale);
CREATE INDEX IF NOT EXISTS idxfs58rfg82kx9qhvjb8idlxxdo ON blc_translation(entity_type, entity_id, entity_field, locale);
CREATE INDEX IF NOT EXISTS idxrsrmtlej61uxhx0yiwpb2rcrv ON blc_notification_state(acked, stopped, notification_name, change_timestamp, next_attempt);