blob: 930e65743441f5e9bf5fc95aeae07a7b9930306c (
plain)
1
2
3
4
5
6
7
8
9
10
|
create table profile (
data jsonb not null,
id text generated always as (data->>'id') stored,
primary key (id)
);
create index idx_profile_inbox on profile using gin ((data->'inbox'));
create index idx_profile_private_key_null
on profile ((data->>'private_key'))
where data->>'private_key' is null;
|
