Hello, I somehow managed to mess up my auth schema or smth and now I cannot login or create users. The error i see in the console is "GET /auth/oauth?error=server_error&error_code=unexpected_failure&error_description=Database+error+saving+new+user&next=%2F 307".
The error happens when I click on the oauth sign in flow. I think I might have deleted something on accident from the auth schema.
Luckily I had no useful data in my db. Is there a way to completely reset the database to what it was before and then rerun my migrations ?
I wanted to clear all users so I run the following:
delete from auth.users;delete from auth.identities;delete from auth.sessions;delete from auth.refresh_tokens;
delete from auth.users;delete from auth.identities;delete from auth.sessions;delete from auth.refresh_tokens;
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.