-- SUPABASE SQL SETUP FOR WEEKLY SCOREBOARD -- Run this in your Supabase SQL Editor -- 1. Create the new dedicated weekly table CREATE TABLE IF NOT EXISTS public.weekly_storage ( id bigint PRIMARY KEY, content text, created_at timestamp with time zone DEFAULT now() ); -- 2. Insert the starting rows -- Row 1: The current weekly score INSERT INTO public.weekly_storage (id, content) VALUES (1, '0'); -- Row 2: The reset tracker (set to an old date to trigger immediate sync) INSERT INTO public.weekly_storage (id, content) VALUES (2, '2000-01-01'); -- 3. Enable RLS (Optional but recommended) ALTER TABLE public.weekly_storage ENABLE ROW LEVEL SECURITY; -- 4. Create a public access policy CREATE POLICY "Public Access" ON public.weekly_storage FOR ALL TO anon USING (true) WITH CHECK (true);