CREATE TABLE IF NOT EXISTS contact_manual_suppressions (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(255) NOT NULL,
  reason VARCHAR(50) NOT NULL,
  source VARCHAR(50) NOT NULL DEFAULT 'AUTORESPONSE',
  effective_date DATE NULL,
  replacement_email VARCHAR(255) NULL,
  evidence_file VARCHAR(500) NULL,
  confidence VARCHAR(20) NULL,
  active TINYINT(1) NOT NULL DEFAULT 1,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uq_contact_manual_suppressions_email (email),
  KEY idx_contact_manual_suppressions_active (active),
  KEY idx_contact_manual_suppressions_reason (reason)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;