fix: explicit uuid

1 files changed, 3 insertions, 3 deletions

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(),