CREATE TABLE preference (
id INTEGER PRIMARY KEY AUTOINCREMENT,
email_type TEXT DEFAULT 'full',
email_freq TEXT DEFAULT 'on_new',
email_limit INT DEFAULT 0,
email_sent INT DEFAULT 0,
email_sent_timestamp INTEGER,
show_passing INT DEFAULT 1
);
INSERT INTO preference (id) VALUES (1);
INSERT INTO preference (id) VALUES (2);