blob: aeec6188af52eff2237e69a4bcbdf1604d7e08f9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
create type actor_kind as enum ('application', 'group', 'organization', 'person', 'service');
create table profile (
ap_id text primary key,
username varchar(15),
description varchar(255),
inbox text not null,
role actor_kind not null default 'person',
outbox text,
picture text,
public_key text not null,
private_key text,
created_at timestamptz not null default now(),
last_refreshed_at timestamptz not null default now()
)
|
