Run this SQL once in your Supabase dashboard → SQL Editor to create the hail reports table:
CREATE TABLE hail_reports (
id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
report_date date NOT NULL UNIQUE,
title text,
deploy_now int DEFAULT 0,
research_count int DEFAULT 0,
monitor_count int DEFAULT 0,
html_content text NOT NULL,
created_at timestamptz DEFAULT now()
);
-- Allow public read/write via anon key
ALTER TABLE hail_reports ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow all" ON hail_reports
FOR ALL USING (true) WITH CHECK (true);
After running this SQL, click Save Current Report to save today's report to the database. Future reports can be uploaded via Upload Report HTML.
Create Hail Report
Saves to the hail site and bodyshop network. Expires in 15 days unless kept.