-- Fix RLS policies for user profile creation during registration
-- The issue is that during registration, auth.uid() might not be available yet

-- Add a more permissive policy for user profile creation during registration
-- This allows inserting user profiles with the user's own ID
CREATE POLICY "Allow user profile creation during registration" ON "public"."users" 
FOR INSERT TO "anon" WITH CHECK (true);

-- Also allow authenticated users to create their own profile
CREATE POLICY "Allow authenticated user profile creation" ON "public"."users" 
FOR INSERT TO "authenticated" WITH CHECK (auth.uid() = id);

-- Refresh schema cache
NOTIFY pgrst, 'reload schema';