From fb1c6dd357260808121e7f7b3b9e5cc200820b62 Mon Sep 17 00:00:00 2001
From: rtkay123 <dev@kanjala.com>
Date: Tue, 15 Jul 2025 07:18:19 +0200
Subject: chore: account table

---
 migrations/20250713161354_account.sql | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 migrations/20250713161354_account.sql

diff --git a/migrations/20250713161354_account.sql b/migrations/20250713161354_account.sql
new file mode 100644
index 0000000..4fdb61d
--- /dev/null
+++ b/migrations/20250713161354_account.sql
@@ -0,0 +1,23 @@
+create table account (
+    id varchar(36) primary key,
+    username varchar(30) not null,
+    inbox text not null,
+    outbox text,
+    local boolean,
+    ap_id text not null unique,
+    private_key text,
+    public_key text not null
+);
+
+create table following (
+    id varchar(36) primary key,
+    follower text references account(ap_id) on delete cascade,
+    followee text references account(ap_id) on delete cascade,
+    created_at timestamptz not null default now(),
+    constraint unique_following unique (follower, followee)
+);
+create index "following_pagination" on "following" ("created_at" asc);
+
+create unique index unique_username_local
+    on account (username)
+    where local = true;
-- 
cgit v1.2.3