3 name varchar(20) not null,
4 fedi_name varchar(40) not null,
5 preferred_username varchar(20),
6 password_encrypted text not null,
9 admin boolean default false not null,
10 banned boolean default false not null,
11 published timestamp not null default now(),
13 unique(name, fedi_name)
16 create table user_ban (
17 id serial primary key,
18 user_id int references user_ on update cascade on delete cascade not null,
19 published timestamp not null default now(),
23 insert into user_ (name, fedi_name, password_encrypted) values ('admin', 'TBD', 'TBD');