CREATE INDEX selfservice_login_flows_nid_idx ON selfservice_login_flows (nid ASC);
DROP INDEX selfservice_login_flows_nid_id_idx ON selfservice_login_flows;
DROP INDEX selfservice_login_flows_id_nid_idx ON selfservice_login_flows;

CREATE INDEX selfservice_errors_nid_idx ON selfservice_errors (nid ASC);
DROP INDEX selfservice_errors_errors_nid_id_idx ON selfservice_errors;

CREATE INDEX selfservice_recovery_flows_nid_idx ON selfservice_recovery_flows (nid ASC);
CREATE INDEX selfservice_recovery_flows_recovered_identity_id_idx ON selfservice_recovery_flows (recovered_identity_id ASC);
DROP INDEX selfservice_recovery_flows_nid_id_idx ON selfservice_recovery_flows;
DROP INDEX selfservice_recovery_flows_id_nid_idx ON selfservice_recovery_flows;
DROP INDEX selfservice_recovery_flows_recovered_identity_id_nid_idx ON selfservice_recovery_flows;

CREATE INDEX selfservice_registration_flows_nid_idx ON selfservice_registration_flows (nid ASC);
DROP INDEX selfservice_registration_flows_nid_id_idx ON selfservice_registration_flows;
DROP INDEX selfservice_registration_flows_id_nid_idx ON selfservice_registration_flows;

CREATE INDEX selfservice_settings_flows_nid_idx ON selfservice_settings_flows (nid ASC);
CREATE INDEX selfservice_settings_flows_identity_id_idx ON selfservice_settings_flows (identity_id ASC);
DROP INDEX selfservice_settings_flows_nid_id_idx ON selfservice_settings_flows;
DROP INDEX selfservice_settings_flows_id_nid_idx ON selfservice_settings_flows;
DROP INDEX selfservice_settings_flows_identity_id_nid_idx ON selfservice_settings_flows;

CREATE INDEX selfservice_verification_flows_nid_idx ON selfservice_verification_flows (nid ASC);
DROP INDEX selfservice_verification_flows_nid_id_idx ON selfservice_verification_flows;
DROP INDEX selfservice_verification_flows_id_nid_idx ON selfservice_verification_flows;
