Шаг 1. Зайдите на
supabase.com → создайте бесплатный аккаунт → новый проект.
Шаг 2. В проекте откройте
SQL Editor и выполните этот запрос:
CREATE TABLE lots (
id bigint generated always as identity primary key,
farm text, name text, phone text, region text,
sort text, vol numeric, price numeric,
delivery_date date, comment text,
is_closed boolean default false,
created_at timestamptz default now()
);
CREATE TABLE demands (
id bigint generated always as identity primary key,
buyer text, contact text, sort text, region text,
vol numeric, price numeric,
need_by date, comment text,
created_at timestamptz default now()
);
CREATE TABLE deals (
id bigint generated always as identity primary key,
lot_id bigint, farm text, name text, phone text,
sort text, vol numeric, price numeric,
delivery_date date, region text, comment text,
created_at timestamptz default now()
);
ALTER TABLE lots ENABLE ROW LEVEL SECURITY;
ALTER TABLE demands ENABLE ROW LEVEL SECURITY;
ALTER TABLE deals ENABLE ROW LEVEL SECURITY;
CREATE POLICY "public read lots" ON lots FOR SELECT USING (true);
CREATE POLICY "public insert lots" ON lots FOR INSERT WITH CHECK (true);
CREATE POLICY "public update lots" ON lots FOR UPDATE USING (true);
CREATE POLICY "public read demands" ON demands FOR SELECT USING (true);
CREATE POLICY "public insert demands" ON demands FOR INSERT WITH CHECK (true);
CREATE POLICY "public read deals" ON deals FOR SELECT USING (true);
CREATE POLICY "public insert deals" ON deals FOR INSERT WITH CHECK (true);
Шаг 3. Зайдите в
Project Settings → API. Скопируйте
Project URL и
anon public key.
Шаг 4. Вставьте их ниже и нажмите «Подключить».
✅ Подключено! Данные теперь общие для всех пользователей.