-- MariaDB 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 MariaDB database.

ALTER ONLINE TABLE blc_transaction ADD INDEX IF NOT EXISTS FKkpucbcmxk6j1ci1dnpqjosf9b (credit_account_id)
ALTER ONLINE TABLE blc_notification_state ADD INDEX IF NOT EXISTS IDX7i0i5vcl1dkkwuq5dyc88wem5 (acked)
ALTER ONLINE TABLE blc_transaction ADD INDEX IF NOT EXISTS IDXd5p9gms1oxiaeophbhxgh5kb6 (source_entity_id)
ALTER ONLINE TABLE blc_transaction ADD INDEX IF NOT EXISTS IDXg339ltarhjlb53kie6i4whu91 (transaction_reference_id)
ALTER ONLINE TABLE blc_notification_state ADD INDEX IF NOT EXISTS IDXgfaqe3xmq5q4yh78mix1g04fy (container)
ALTER ONLINE TABLE blc_credit_account ADD INDEX IF NOT EXISTS IDXkhw3abx99me0gvygy8f9wnru8 (owning_user_ref)
ALTER ONLINE TABLE blc_resource_lock ADD INDEX IF NOT EXISTS IDXkm4y3qj3jh2mpt0rt6l6vscl8 (token)
ALTER ONLINE TABLE blc_transaction ADD INDEX IF NOT EXISTS IDXn4j14my27tsau5wg9f8r4r05x (request_id)
ALTER ONLINE TABLE blc_credit_account ADD INDEX IF NOT EXISTS IDXov0vi6lbue0lbvdew039hx3uq (account_number)