supabase-schema.sql

-- Run this in your Supabase SQL Editor
-- Dashboard → SQL Editor → New Query → paste and run

create table if not exists orders (
  id          bigserial primary key,
  created_at  timestamptz default now(),
  order_type  text not null check (order_type in ('delivery','pickup')),
  items       jsonb not null,
  total       numeric not null,
  customer_name    text not null,
  customer_number  text not null,
  customer_address text,
  payment_method   text not null,
  notes       text,
  status      text not null default 'pending'
    check (status in ('pending','preparing','ready','completed','cancelled'))
);

-- Allow anonymous inserts (customer orders)
alter table orders enable row level security;

create policy "Anyone can insert orders"
  on orders for insert
  with check (true);

-- Only authenticated (admin via service key or anon with policy) can read
create policy "Anyone can read orders"
  on orders for select
  using (true);

-- Allow updates (for status changes)
create policy "Anyone can update orders"
  on orders for update
  using (true);

-- Enable realtime
alter publication supabase_realtime add table orders;