From a64eb6b08f2f8d22cf129fba39e1bb2c66bb3fad Mon Sep 17 00:00:00 2001 From: rtkay123 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(-) 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