-- Run once on existing databases (optional descriptions for public symptom browse)
CREATE TABLE IF NOT EXISTS symptom_browse_descriptions (
  norm_key VARCHAR(191) NOT NULL PRIMARY KEY,
  description TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS symptom_browse_exclusions (
  norm_key VARCHAR(191) NOT NULL PRIMARY KEY,
  display_label VARCHAR(512) NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);