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)
24 VALUES ('admin', 'TBD', 'TBD');