VidSimplify / manual_user_sync.sql
Adityahulk
Restoring repo state for deployment
6fc3143
-- Run this in Supabase SQL Editor to manually insert your current user
-- This will sync your existing authenticated user to the public.users table
INSERT INTO public.users (id, email, full_name, avatar_url, credits)
SELECT
id,
email,
raw_user_meta_data->>'full_name',
raw_user_meta_data->>'avatar_url',
5
FROM auth.users
WHERE id NOT IN (SELECT id FROM public.users)
ON CONFLICT (id) DO NOTHING;