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);

-- Row Level Security (required — Supabase flags public tables without RLS)
ALTER TABLE email_settings ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "anon_all" ON email_settings;
CREATE POLICY "anon_all" ON email_settings
  FOR ALL TO anon USING (true) WITH CHECK (true);