-- 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 idx7mkg2redtamsithw0ktjlo47o ON blc_cart(customer_id);
CREATE INDEX IF NOT EXISTS idxlwtvp3a4ytsnleva1i32a8fmv ON blc_cart(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idxddm7ppvtyfaahj1iqr20436vx ON blc_item_list(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idx4eqtfjr97a5a92n8amquh7xmh ON blc_item_list_access_rule(item_list_id);
CREATE INDEX IF NOT EXISTS idx5f9mmnu5qk9b3prvxjhkq80gl ON blc_item_list_access_rule(value);
CREATE INDEX IF NOT EXISTS idxr3lyrd2sf61f95scyvhhlqf8a ON blc_item_list_access_rule(trk_application_context_id);
CREATE INDEX IF NOT EXISTS idxk2gjdkiji94xkadw5v6tk2vda ON blc_item_list_item(item_list_id);
CREATE INDEX IF NOT EXISTS idxox15en3jelcqwr252ey9bgpg1 ON blc_item_list_item(trk_customer_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 idxlsrmtlej61uxhx0yiwpb2rcrv ON blc_notification_state(acked, stopped, notification_name, change_timestamp, next_attempt);
