-- 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 idxthg1aqgvgtb3ylq1j8sx7m6xs ON blc_asset(url);
CREATE INDEX IF NOT EXISTS idxpl37cfmn81n4mkmxgv4c1imsp ON blc_asset(title);
CREATE INDEX IF NOT EXISTS idxl99c2pnk5yqaw6u6l3yb67jo2 ON blc_asset(alt_text);
CREATE INDEX IF NOT EXISTS idxsuhkeslwr3076rsxtqdiy3occ ON blc_asset(folder_context_id);
CREATE INDEX IF NOT EXISTS idxet6l5pq6eu97klecyll09gje0 ON blc_asset(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idxrd5qrpwxg2m6txoxmccuo1e86 ON blc_asset_folder(parent_folder_context_id);
CREATE INDEX IF NOT EXISTS idxf3re37i0ius4bw1fbspfovotr ON blc_asset_folder(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idxcj1s0j9fh7qpw2c8wwfoviius ON blc_file_upload_state(trk_application_context_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 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 idx7g9ofwpwgsn7b94ruv4ds5o4d ON blc_asset_tag(tag);
CREATE INDEX IF NOT EXISTS idxjsrmtlej61uxhx0yiwpb2rcrv ON blc_notification_state(acked, stopped, notification_name, change_timestamp, next_attempt);