Permalink
Switch branches/tags
Find file
Fetching contributors…
Cannot retrieve contributors at this time
14 lines (11 sloc) 366 Bytes
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);