Run these SQL commands in your Supabase SQL Editor to create the required tables:

-- Run this in Supabase SQL Editor (supabase.com → your project → SQL Editor)

CREATE TABLE products (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  name TEXT NOT NULL,
  category TEXT NOT NULL,
  description TEXT,
  price NUMERIC NOT NULL,
  old_price NUMERIC,
  badge TEXT,
  visible BOOLEAN DEFAULT true,
  created_at TIMESTAMPTZ DEFAULT now()
);

CREATE TABLE announcements (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  text TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT now()
);

-- Enable public read access (so website can show products without login)
ALTER TABLE products ENABLE ROW LEVEL SECURITY;
ALTER TABLE announcements ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Public read products" ON products FOR SELECT USING (true);
CREATE POLICY "Public read announcements" ON announcements FOR SELECT USING (true);
CREATE POLICY "Anon insert products" ON products FOR INSERT WITH CHECK (true);
CREATE POLICY "Anon update products" ON products FOR UPDATE USING (true);
CREATE POLICY "Anon delete products" ON products FOR DELETE USING (true);
CREATE POLICY "Anon insert announcements" ON announcements FOR INSERT WITH CHECK (true);
CREATE POLICY "Anon delete announcements" ON announcements FOR DELETE USING (true);

After running this SQL, paste your Supabase URL and key in the settings above and click "Save & Connect".