-- Per SMTP account IMAP settings for inbound campaign replies

ALTER TABLE company_smtp_accounts
  ADD COLUMN imap_enabled TINYINT(1) NOT NULL DEFAULT 0 AFTER notes,
  ADD COLUMN imap_host VARCHAR(255) NULL AFTER imap_enabled,
  ADD COLUMN imap_port INT NOT NULL DEFAULT 993 AFTER imap_host,
  ADD COLUMN imap_secure TINYINT(1) NOT NULL DEFAULT 1 AFTER imap_port,
  ADD COLUMN imap_username VARCHAR(255) NULL AFTER imap_secure,
  ADD COLUMN imap_password_encrypted TEXT NULL AFTER imap_username,
  ADD COLUMN imap_mailbox VARCHAR(120) NOT NULL DEFAULT 'INBOX' AFTER imap_password_encrypted,
  ADD COLUMN imap_last_poll_at DATETIME NULL AFTER imap_mailbox;

ALTER TABLE email_imap_processed
  ADD COLUMN smtp_account_id INT NULL AFTER id,
  ADD INDEX idx_imap_smtp_account (smtp_account_id);