-- Link a diseases row to an ICD-11 entity URI so curated admin content appears on ICD detail URLs.
-- Run once: mysql -u USER -p DB_NAME < server/database/add_diseases_icd11_uri.sql

ALTER TABLE diseases
  ADD COLUMN icd11_uri VARCHAR(768) NULL AFTER content;

ALTER TABLE diseases
  ADD UNIQUE KEY uq_diseases_icd11_uri (icd11_uri);
