CREATE TABLE IF NOT EXISTS email_settings (
  id TEXT PRIMARY KEY,
  account_id TEXT NOT NULL,
  smtp_host TEXT DEFAULT '',
  smtp_port INTEGER DEFAULT 587,
  smtp_user TEXT DEFAULT '',
  smtp_pass TEXT DEFAULT '',
  smtp_from_name TEXT DEFAULT '',
  smtp_from_email TEXT DEFAULT '',
  smtp_encryption TEXT DEFAULT 'TLS',
  smtp_enabled BOOLEAN DEFAULT false,
  created_at BIGINT,
  updated_at BIGINT
);
CREATE UNIQUE INDEX IF NOT EXISTS email_settings_account_id_idx
  ON email_settings(account_id);