From cdcf6a4caa66095c07ef9d6d3ebc7c795a046e1e Mon Sep 17 00:00:00 2001 From: rtkay123 Date: Mon, 2 Feb 2026 18:21:48 +0200 Subject: chore: initial migrations --- migrations/20260202155213_follow.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 migrations/20260202155213_follow.sql (limited to 'migrations/20260202155213_follow.sql') diff --git a/migrations/20260202155213_follow.sql b/migrations/20260202155213_follow.sql new file mode 100644 index 0000000..384287f --- /dev/null +++ b/migrations/20260202155213_follow.sql @@ -0,0 +1,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) +) -- cgit v1.2.3