diff options
Diffstat (limited to 'migrations/20250713161354_account.sql')
| -rw-r--r-- | migrations/20250713161354_account.sql | 6 |
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(), |