Step 1 — Create a free Supabase project
Go to supabase.com → New Project → Choose a name & password → Wait ~2 mins for it to start

Step 2 — Create the audits table
In your project → SQL Editor → paste and run this:

CREATE TABLE audits (
  id TEXT PRIMARY KEY,
  auditor_name TEXT,
  centre_name TEXT,
  audit_date TEXT,
  status TEXT DEFAULT 'in_progress',
  ap_count INT DEFAULT 0,
  ci_count INT DEFAULT 0,
  audit_data TEXT,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE audits ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow all" ON audits FOR ALL USING (true) WITH CHECK (true);

Step 2b — Enable server-side PIN security Recommended
In the same SQL Editor, run the contents of supabase-pin-setup.sql (provided alongside this app). This creates the pin_config table and two Postgres functions that validate your PIN server-side — the hash never leaves the database and lockouts can't be bypassed from DevTools.

Step 3 — Get your credentials
Project Settings → API → copy Project URL and anon/public key