From a64eb6b08f2f8d22cf129fba39e1bb2c66bb3fad Mon Sep 17 00:00:00 2001
From: rtkay123 <dev@kanjala.com>
Date: Tue, 15 Jul 2025 08:42:09 +0200
Subject: fix: explicit uuid

---
 migrations/20250713161354_account.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

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

diff --git a/migrations/20250713161354_account.sql b/migrations/20250713161354_account.sql
index 4fdb61d..367cc7b 100644
--- a/migrations/20250713161354_account.sql
+++ b/migrations/20250713161354_account.sql
@@ -1,16 +1,16 @@
 create table account (
-    id varchar(36) primary key,
+    id uuid primary key,
     username varchar(30) not null,
     inbox text not null,
     outbox text,
-    local boolean,
+    local boolean not null,
     ap_id text not null unique,
     private_key text,
     public_key text not null
 );
 
 create table following (
-    id varchar(36) primary key,
+    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(),
-- 
cgit v1.2.3

