diff options
| author | rtkay123 <dev@kanjala.com> | 2025-07-15 08:42:09 +0200 |
|---|---|---|
| committer | rtkay123 <dev@kanjala.com> | 2025-07-15 08:42:09 +0200 |
| commit | a64eb6b08f2f8d22cf129fba39e1bb2c66bb3fad (patch) | |
| tree | 75ec0eddb6192305d5f68062dc7d796053d60473 /migrations/20250713161354_account.sql | |
| parent | fb1c6dd357260808121e7f7b3b9e5cc200820b62 (diff) | |
| download | sellershut-a64eb6b08f2f8d22cf129fba39e1bb2c66bb3fad.tar.bz2 sellershut-a64eb6b08f2f8d22cf129fba39e1bb2c66bb3fad.zip | |
fix: explicit uuid
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(), |