Napisz do nas

Porozmawiajmy o Twoich potrzebach — odpiszemy w ciągu 24 godzin.

Krok 1. Wejdź na supabase.com → Start your project (przez GitHub jest najszybciej).

Krok 2. Nowy projekt: New project → nazwa certli, silne hasło bazy, region EU (Frankfurt). Poczekaj ~2 min.

Krok 3. Idź do Settings → API i skopiuj:
Project URL i anon public key.

Krok 4. Otwórz plik certli.html w edytorze i zastąp wartości SUPA_URL i SUPA_KEY swoimi kluczami:

const SUPA_URL = ’https://twojprojekt.supabase.co’;
const SUPA_KEY = ’eyJhbGci…’;

Krok 5. W Supabase: Authentication → URL Configuration → dodaj adres swojej strony do Site URL.

Krok 6. Uruchom poniższy SQL w SQL Editor:

— 1. Organizations create table if not exists organizations ( id uuid primary key default gen_random_uuid(), name text not null, owner_id uuid references auth.users(id), created_at timestamptz not null default now() ); alter table organizations enable row level security; create policy „owner access” on organizations for all using (owner_id = auth.uid()); — 2. Members create table if not exists organization_members ( id uuid primary key default gen_random_uuid(), organization_id uuid not null references organizations(id) on delete cascade, user_id uuid not null references auth.users(id) on delete cascade, role text not null default 'member’, created_at timestamptz not null default now(), unique(organization_id, user_id) ); alter table organization_members enable row level security; create policy „self access” on organization_members for all using (user_id = auth.uid()); — 3. Certificates create table if not exists certificates ( id uuid primary key default gen_random_uuid(), organization_id uuid not null references organizations(id) on delete cascade, name text not null default ”, domain text not null, type text not null default 'ssl’, source text not null default 'manual’, expiry_date timestamptz, status text not null default 'pending’, auto_renew_enabled boolean not null default true, last_checked_at timestamptz, created_at timestamptz not null default now() ); alter table certificates enable row level security; create policy „org members manage certs” on certificates for all using ( organization_id in ( select organization_id from organization_members where user_id = auth.uid() ) ); — 4. Alerts create table if not exists alerts ( id uuid primary key default gen_random_uuid(), certificate_id uuid references certificates(id) on delete cascade, organization_id uuid not null references organizations(id) on delete cascade, type text not null, message text not null, severity text not null default 'warning’, created_at timestamptz not null default now(), read_at timestamptz ); alter table alerts enable row level security; create policy „org alerts” on alerts for all using ( organization_id in ( select organization_id from organization_members where user_id = auth.uid() ) );

📋 Kopiuj SQL

Rozumiem, zaczynam →