Mannu
596cfcca34
Read-only mirror of the client's existing system as it stood before our work began. Taken from matthijsexpand@149.210.159.152 (TransIP VPS, Lelystad NL) with the client's written permission. Contents: - home-weddingcaketopper/ Next.js app, proxy.py, supabase schema - var-www/ static webroots for all three domains - etc-nginx/ vhost configs (previously unversioned, server-only) Excluded: node_modules (704M, regenerable), .next (17M, regenerable), and env file contents (present on local disk, gitignored — see README). Not our IP. Not covered by the proposal's assignment clause.
24 lines
796 B
SQL
24 lines
796 B
SQL
create extension if not exists pgcrypto;
|
|
create table if not exists orders (
|
|
id uuid primary key default gen_random_uuid(),
|
|
created_at timestamptz default now(),
|
|
product text not null default 'bruidspaar-taarttopper',
|
|
email text not null,
|
|
name text not null,
|
|
style text not null,
|
|
wedding_date text,
|
|
notes text,
|
|
status text default 'new',
|
|
payment_status text default 'pending',
|
|
preview_url text,
|
|
adyen_session_id text
|
|
);
|
|
create table if not exists uploads (
|
|
id uuid primary key default gen_random_uuid(),
|
|
created_at timestamptz default now(),
|
|
order_id uuid references orders(id) on delete cascade,
|
|
image_url text not null,
|
|
path text
|
|
);
|
|
-- Maak in Supabase Storage een public bucket: order-uploads
|
|
-- Voor live gebruik: maak uploads privé en gebruik signed URLs.
|