-- TRACKS
create table if not exists tracks (
  id uuid default gen_random_uuid() primary key,
  title text not null,
  credit text,
  audio_url text not null,
  art_url text,
  duration text,
  album_id text,
  album_title text,
  uploaded_at bigint default extract(epoch from now())*1000
);
alter table tracks enable row level security;
create policy "public read"   on tracks for select using (true);
create policy "public insert" on tracks for insert with check (true);
create policy "public delete" on tracks for delete using (true);

-- POSTS
create table if not exists posts (
  id uuid default gen_random_uuid() primary key,
  type text not null,             -- 'text' | 'image' | 'snippet' | 'track'
  content text default '',
  media_url text,
  track_id uuid references tracks(id) on delete set null,
  loop_start numeric default 0,
  loop_end numeric default 0,
  created_at bigint default extract(epoch from now())*1000
);
alter table posts enable row level security;
create policy "public read"   on posts for select using (true);
create policy "public insert" on posts for insert with check (true);
create policy "public delete" on posts for delete using (true);

-- LIKES
create table if not exists likes (
  id uuid default gen_random_uuid() primary key,
  post_id uuid not null,
  session_id text not null,
  created_at bigint default extract(epoch from now())*1000,
  unique(post_id, session_id)
);
alter table likes enable row level security;
create policy "public read"   on likes for select using (true);
create policy "public insert" on likes for insert with check (true);
create policy "public delete" on likes for delete using (true);

-- COMMENTS
create table if not exists comments (
  id uuid default gen_random_uuid() primary key,
  post_id uuid not null,
  text text not null,
  author text default 'anonymous',
  created_at bigint default extract(epoch from now())*1000
);
alter table comments enable row level security;
create policy "public read"   on comments for select using (true);
create policy "public insert" on comments for insert with check (true);