-- MySql does not support `IF NOT EXISTS` syntax when creating indexes.
-- You should review your database for any of the indexes described here that pre-exist,
-- and omit them from what you apply to your MySql database.

CREATE INDEX FKkpucbcmxk6j1ci1dnpqjosf9b ON blc_transaction(credit_account_id);
CREATE INDEX IDX7i0i5vcl1dkkwuq5dyc88wem5 ON blc_notification_state(acked);
CREATE INDEX IDXd5p9gms1oxiaeophbhxgh5kb6 ON blc_transaction(source_entity_id);
CREATE INDEX IDXg339ltarhjlb53kie6i4whu91 ON blc_transaction(transaction_reference_id);
CREATE INDEX IDXgfaqe3xmq5q4yh78mix1g04fy ON blc_notification_state(container);
CREATE INDEX IDXkhw3abx99me0gvygy8f9wnru8 ON blc_credit_account(owning_user_ref);
CREATE INDEX IDXkm4y3qj3jh2mpt0rt6l6vscl8 ON blc_resource_lock(token);
CREATE INDEX IDXn4j14my27tsau5wg9f8r4r05x ON blc_transaction(request_id);
CREATE INDEX IDXov0vi6lbue0lbvdew039hx3uq ON blc_credit_account(account_number);
