migrations/20260202155213_follow.sql


1
2
3
4
5
6

create table follow (
  follower_ap_id text not null references profile(ap_id) on delete cascade,
  followee_ap_id text not null references profile(ap_id) on delete cascade,
  followed_at timestamptz not null default now(),
  primary key (follower_ap_id, followee_ap_id)
)