15 lines
598 B
SQL
15 lines
598 B
SQL
CREATE TABLE IF NOT EXISTS mail_preferences (
|
|
id INTEGER PRIMARY KEY CHECK (id = 1),
|
|
messages_per_page INTEGER NOT NULL DEFAULT 50,
|
|
mark_read_delay_ms INTEGER NOT NULL DEFAULT 0,
|
|
remote_images TEXT NOT NULL DEFAULT 'ask',
|
|
preferred_body TEXT NOT NULL DEFAULT 'auto',
|
|
thread_mode TEXT NOT NULL DEFAULT 'threaded',
|
|
collapse_quotes INTEGER NOT NULL DEFAULT 1,
|
|
show_snippets INTEGER NOT NULL DEFAULT 1,
|
|
default_sort TEXT NOT NULL DEFAULT 'date_desc',
|
|
updated_at TEXT NOT NULL DEFAULT (datetime('now'))
|
|
);
|
|
|
|
INSERT OR IGNORE INTO mail_preferences (id) VALUES (1);
|