Add trigger to create new users in public.users when auth.users table added to

[gabestein]

If I understand correctly, I think you could query the user by email via prisma, since we're duplicating supabase auth users in the public.auth.

Nm, I see. I think the right way to do this is to setup a trigger that automatically creates the user in public.auth. That's what supabase, etc., recommend, and I'm not sure why we're only doing an update trigger. I'll add this next week.

Originally posted by @gabestein in https://github.com/pubpub/v7/issues/71#issuecomment-1710591738