Organizer Control Panel

📍 Kit Collection & 🚌 Bus Routes Manager

মোবাইল ফোন ও সকল ভিজিটরের ডিভাইসে একসাথে সেটিংস (অন/অফ/তারিখ) লাইভ আপডেট করতে আপনার Supabase Dashboard -> SQL Editor-এ গিয়ে নিচের কোডটি রান করুন:

-- 1. EVENT SETTINGS TABLE
create table if not exists public.event_settings (
  id text primary key,
  data jsonb,
  reg_close_date text,
  reg_status text,
  status_10k text,
  status_5k text,
  race_date text,
  updated_at timestamp with time zone default now()
);
alter table public.event_settings enable row level security;
create policy "Allow all access to event_settings" on public.event_settings for all using (true) with check (true);

-- 2. VOLUNTEERS TABLE
create table if not exists public.volunteers (
  id uuid default gen_random_uuid() primary key,
  vol_id text unique not null,
  name text not null,
  phone text not null,
  email text not null,
  dept_batch text not null,
  gender text not null,
  blood text,
  tshirt text not null,
  preferred_role text not null,
  experience text,
  availability text not null,
  status text not null default 'Pending',
  created_at timestamp with time zone default now()
);
alter table public.volunteers enable row level security;
create policy "Allow public insert on volunteers" on public.volunteers for insert with check (true);
create policy "Allow public read on volunteers" on public.volunteers for select using (true);
create policy "Allow admin full access on volunteers" on public.volunteers for all using (true) with check (true);