-- إصلاح صلاحيات جدول الفيديوهات
DROP POLICY IF EXISTS "insert videos" ON public.videos;
DROP POLICY IF EXISTS "delete videos" ON public.videos;
DROP POLICY IF EXISTS "update videos" ON public.videos;
DROP POLICY IF EXISTS "anyone can view videos" ON public.videos;
DROP POLICY IF EXISTS "public videos" ON public.videos;

CREATE POLICY "videos_select" ON public.videos FOR SELECT USING (true);
CREATE POLICY "videos_insert" ON public.videos FOR INSERT WITH CHECK (true);
CREATE POLICY "videos_delete" ON public.videos FOR DELETE USING (true);
CREATE POLICY "videos_update" ON public.videos FOR UPDATE USING (true);

-- إصلاح صلاحيات جدول المستخدمين
DROP POLICY IF EXISTS "users can view own profile" ON public.profiles;
DROP POLICY IF EXISTS "admins can view all profiles" ON public.profiles;

CREATE POLICY "profiles_select" ON public.profiles FOR SELECT USING (true);
CREATE POLICY "profiles_insert" ON public.profiles FOR INSERT WITH CHECK (auth.uid() = id);
CREATE POLICY "profiles_update" ON public.profiles FOR UPDATE USING (auth.uid() = id);
CREATE POLICY "profiles_delete" ON public.profiles FOR DELETE USING (auth.uid() = id);