Email

schema.sql 17 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

1234567891011121314151617CREATE TABLE emails (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  folder TEXT NOT NULL DEFAULT 'inbox',
  from_addr TEXT,
  to_addr TEXT,
  cc TEXT,
  subject TEXT NOT NULL,
  body TEXT NOT NULL DEFAULT '',
  is_read INTEGER DEFAULT 0,
  starred INTEGER DEFAULT 0 /* 1 when starred, 0 when unstarred. */,
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  source_key TEXT UNIQUE,
  remote_key TEXT UNIQUE,
  auto_send INTEGER DEFAULT 0,
  last_error TEXT,
  event_emitted INTEGER DEFAULT 0
);