schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

-- spam table
create table IF not exists spam
(
    user    TEXT,
    domain  TEXT,
    ts      TEXT,
    message TEXT,
    primary key (domain, ts)
);

-- indicies
create index if not exists domain_tx_idx
    on spam (domain, ts);

create index if not exists user_domain_idx
    on spam (user, domain);