-- ===================================================== -- SIMPARTS — Setup completo Supabase -- Copia tutto e incolla in: Supabase → SQL Editor → Run -- ===================================================== -- ── PRODOTTI ── create table if not exists products ( id bigint primary key generated always as identity, name text not null, description text, price text, stock text default 'av', -- 'av' | 'lw' | 'ot' badge text, -- 'nuovo' | 'top' | 'limited' photos jsonb default '[]', print_notes text, production_cost numeric default 0, related_products jsonb default '[]', links jsonb default '[]', orders_count int default 0, created_at timestamptz default now() ); -- ── ORDINI ── create table if not exists orders ( id bigint primary key generated always as identity, customer_name text, customer_phone text, items jsonb, total numeric, note text, order_number text, status text default 'in-sospeso', -- 'in-sospeso' | 'confermato' | 'in-preparazione' | 'spedito' | 'consegnato' shipping_status text default 'non-spedito', tracking_number text, carrier text, created_at timestamptz default now() ); -- ── RECENSIONI ── create table if not exists reviews ( id bigint primary key generated always as identity, product_id bigint, product_name text, customer_name text, customer_token text, -- token anonimo per limitare 1 rec per cliente per prodotto rating int check (rating between 1 and 5), content text, approved boolean default false, created_at timestamptz default now() ); -- Indice univoco: 1 sola recensione per token+prodotto create unique index if not exists reviews_unique_token on reviews (customer_token, product_id); -- ── SPESE ── create table if not exists expenses ( id bigint primary key generated always as identity, description text, amount numeric, category text, -- 'filamento' | 'attrezzatura' | 'spedizione' | 'altro' date date default current_date, created_at timestamptz default now() ); -- ── VENDITE ── create table if not exists sales ( id bigint primary key generated always as identity, product_name text, amount numeric, note text, date date default current_date, created_at timestamptz default now() ); -- ── LISTA D'ATTESA ── create table if not exists waitlist ( id bigint primary key generated always as identity, product_id bigint, product_name text, email text not null, created_at timestamptz default now() ); -- ── POSTAZIONI CLIENTI ── create table if not exists customer_setups ( id bigint primary key generated always as identity, customer_name text not null, location text, -- es. 'Milano', 'Roma' description text, photo_url text, -- base64 o URL approved boolean default false, products_used jsonb default '[]', -- array di nomi prodotti usati created_at timestamptz default now() ); -- ── ROW LEVEL SECURITY ── alter table products enable row level security; alter table orders enable row level security; alter table reviews enable row level security; alter table expenses enable row level security; alter table sales enable row level security; alter table waitlist enable row level security; alter table customer_setups enable row level security; -- ── POLICY: accesso pubblico con chiave anon ── -- (sicuro perché la chiave anon è read/write ma non permette drop/alter) drop policy if exists "public access" on products; drop policy if exists "public access" on orders; drop policy if exists "public access" on reviews; drop policy if exists "public access" on expenses; drop policy if exists "public access" on sales; drop policy if exists "public access" on waitlist; drop policy if exists "public access" on customer_setups; create policy "public access" on products for all using (true) with check (true); create policy "public access" on orders for all using (true) with check (true); create policy "public access" on reviews for all using (true) with check (true); create policy "public access" on expenses for all using (true) with check (true); create policy "public access" on sales for all using (true) with check (true); create policy "public access" on waitlist for all using (true) with check (true); create policy "public access" on customer_setups for all using (true) with check (true); -- ===================================================== -- SE HAI GIA' ESEGUITO IL VECCHIO SQL, aggiungi solo -- le colonne mancanti con questi comandi: -- ===================================================== -- alter table orders add column if not exists shipping_status text default 'non-spedito'; -- alter table orders add column if not exists order_number text; -- alter table orders add column if not exists internal_notes text; -- alter table orders add column if not exists outcome text; -- alter table orders add column if not exists shipping_cost numeric default 0; -- alter table products add column if not exists related_products jsonb default '[]'; -- alter table orders add column if not exists tracking_number text; -- alter table orders add column if not exists carrier text; -- alter table products add column if not exists production_cost numeric default 0; -- alter table orders add column if not exists orders_count int default 0; -- alter table reviews add column if not exists customer_token text; -- alter table products add column if not exists orders_count int default 0; -- create unique index if not exists reviews_unique_token on reviews (customer_token, product_id); -- create table if not exists customer_setups ( ... vedi sopra ... ); -- alter table customer_setups enable row level security; -- create policy "public access" on customer_setups for all using (true) with check (true);