mirror of
https://github.com/GRFreire/nthmail.git
synced 2026-01-08 12:29:38 +00:00
a88e5e90dc
this way, when the inbox route is called, there is no need to parse all mails neither request them from db just so it can have their subject
11 lines
221 B
SQL
11 lines
221 B
SQL
pragma journal_mode = wal;
|
|
|
|
CREATE TABLE mails (
|
|
id integer not null primary key,
|
|
arrived_at integer not null,
|
|
rcpt_addr text not null,
|
|
from_addr text not null,
|
|
subject text,
|
|
data blob not null
|
|
);
|