Portfolio Manager

CREATE TABLE IF NOT EXISTS public.projects (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  title text NOT NULL,
  tag text NOT NULL,
  img text,
  url text,
  desc text,
  owner text NOT NULL CHECK (owner IN ('aan','nabila')),
  published boolean DEFAULT true,
  created_at timestamp with time zone DEFAULT now()
);

-- RLS
ALTER TABLE public.projects ENABLE ROW LEVEL SECURITY;
CREATE POLICY "read all" ON public.projects FOR SELECT USING (true);
CREATE POLICY "insert anon" ON public.projects FOR INSERT WITH CHECK (true);
CREATE POLICY "update anon" ON public.projects FOR UPDATE USING (true) WITH CHECK (true);
CREATE POLICY "delete anon" ON public.projects FOR DELETE USING (true);

Untuk keamanan produksi, sebaiknya pakai auth/dashboard tertutup dan batasi policy.