rest/schema.sql at main · nin0chat/rest · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
create table users
(
    id                         varchar(18) not null
        primary key,
    username                   varchar(32) not null
        constraint unique_username
            unique,
    email                      varchar     not null
        constraint unique_email
            unique,
    password                   varchar     not null,
    activated                  boolean default false,
    role                       integer default 0,
    pfp                        varchar,
    communicationdisableduntil bigint
);

create table bots
(
    id       varchar(18) not null
        constraint bots_pk
            primary key,
    owner_id varchar(18) not null
);

create table tokens
(
    id    varchar(18) not null
    token varchar     not null,
    seed  integer     not null
);

create index tokens_id_seed_token_index
    on tokens (id, seed, token);

create table email_verifications
(
    id    varchar(18) not null
    token varchar     not null
);