Email

schema.js 2 lines

Files · 9

emits.js6 lines
index.jsx468 lines
listens.js8 lines
mailbox.js151 lines
mailbox.test.js238 lines
manifest.json96 lines
schema.js2 lines
schema.sql17 lines
style.css66 lines

12// Kept byte-for-byte equivalent to schema.sql; bundled without a runtime fetch.
export default "CREATE TABLE emails (\n  id INTEGER PRIMARY KEY AUTOINCREMENT,\n  folder TEXT NOT NULL DEFAULT 'inbox',\n  from_addr TEXT,\n  to_addr TEXT,\n  cc TEXT,\n  subject TEXT NOT NULL,\n  body TEXT NOT NULL DEFAULT '',\n  is_read INTEGER DEFAULT 0,\n  starred INTEGER DEFAULT 0 /* 1 when starred, 0 when unstarred. */,\n  created_at TEXT NOT NULL DEFAULT (datetime('now')),\n  source_key TEXT UNIQUE,\n  remote_key TEXT UNIQUE,\n  auto_send INTEGER DEFAULT 0,\n  last_error TEXT,\n  event_emitted INTEGER DEFAULT 0\n);\n";