אלעד וייטמן

create table if not exists profiles (
  id uuid references auth.users primary key,
  full_name text,
  onboarding_done boolean default false,
  updated_at timestamptz default now()
);

create table if not exists journal_logs (
  id uuid default gen_random_uuid() primary key,
  user_id uuid references profiles(id) on delete cascade,
  title text,
  content text,
  tags text[],
  created_at timestamptz default now()
);

create table if not exists waitlist (
  id uuid default gen_random_uuid() primary key,
  email text unique not null,
  created_at timestamptz default now()
);

alter table journal_logs enable row level security;
alter table profiles enable row level security;
alter table waitlist enable row level security;

create policy if not exists "own logs" on journal_logs
  for all using (auth.uid() = user_id);
create policy if not exists "own profile" on profiles
  for all using (auth.uid() = id);
create policy if not exists "insert waitlist" on waitlist
  for insert with check (true);