DROP TRIGGER IF EXISTS security_events_set_updated_at ON security_events;
DROP TRIGGER IF EXISTS auth_lockouts_set_updated_at ON auth_lockouts;

DROP INDEX IF EXISTS security_events_user_created_at_idx;
DROP INDEX IF EXISTS security_events_type_created_at_idx;
DROP INDEX IF EXISTS security_events_status_created_at_idx;
DROP TABLE IF EXISTS security_events;

DROP INDEX IF EXISTS auth_lockouts_remote_ip_active_idx;
DROP INDEX IF EXISTS auth_lockouts_identifier_active_idx;
DROP TABLE IF EXISTS auth_lockouts;

DROP INDEX IF EXISTS auth_login_attempts_success_created_at_idx;
DROP INDEX IF EXISTS auth_login_attempts_remote_ip_created_at_idx;
DROP INDEX IF EXISTS auth_login_attempts_identifier_created_at_idx;
DROP TABLE IF EXISTS auth_login_attempts;