From 69fe55ad54468948c13af520a498ed4aeac194ed Mon Sep 17 00:00:00 2001
From: rtkay123 <dev@kanjala.com>
Date: Thu, 17 Jul 2025 14:00:40 +0200
Subject: chore: convert to workspace

---
 migrations/20250713161354_account.sql | 43 -----------------------------------
 1 file changed, 43 deletions(-)
 delete mode 100644 migrations/20250713161354_account.sql

(limited to 'migrations/20250713161354_account.sql')

diff --git a/migrations/20250713161354_account.sql b/migrations/20250713161354_account.sql
deleted file mode 100644
index 1b967b8..0000000
--- a/migrations/20250713161354_account.sql
+++ /dev/null
@@ -1,43 +0,0 @@
-create table account (
-    id uuid primary key,
-    username varchar(30) not null,
-    inbox text not null,
-    outbox text,
-    local boolean not null,
-    ap_id text not null unique,
-    private_key text,
-    avatar_url text,
-    description text,
-    user_type text not null check (
-        user_type IN ('PERSON', 'APPLICATION', 'GROUP', 'ORGANIZATION', 'SERVICE')
-    ),
-    created_at timestamptz not null default now(),
-    updated_at timestamptz not null default now(),
-    public_key text not null
-);
-
-create table following (
-    id uuid 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;
-
-create or replace function set_updated_at()
-returns trigger as $$
-begin
-  new.updated_at := now();
-  return new;
-end;
-$$ language plpgsql;
-
-create trigger trigger_set_updated_at
-before update on account
-for each row
-execute function set_updated_at();
-- 
cgit v1.2.3

