-- DentalCare 0.5.9.8.24: structured chairside vital-sign capture.
ALTER TABLE `{{prefix}}vital_signs`
  ADD COLUMN `oxygen_saturation` DECIMAL(5,2) NULL AFTER `respiratory_rate`,
  ADD COLUMN `height_cm` DECIMAL(7,2) NULL AFTER `weight_kg`,
  ADD COLUMN `bmi` DECIMAL(6,2) NULL AFTER `height_cm`,
  ADD COLUMN `bp_arm` ENUM('left','right','other') NULL AFTER `blood_pressure_diastolic`,
  ADD COLUMN `bp_position` ENUM('seated','standing','supine','other') NULL AFTER `bp_arm`,
  ADD COLUMN `bp_cuff_size` VARCHAR(30) NULL AFTER `bp_position`,
  ADD COLUMN `bp_device_type` ENUM('automatic','manual','other') NULL AFTER `bp_cuff_size`,
  ADD COLUMN `bp_measurement_confirmed` TINYINT(1) NOT NULL DEFAULT 0 AFTER `bp_device_type`,
  ADD COLUMN `bp_repeat_systolic` SMALLINT UNSIGNED NULL AFTER `bp_measurement_confirmed`,
  ADD COLUMN `bp_repeat_diastolic` SMALLINT UNSIGNED NULL AFTER `bp_repeat_systolic`,
  ADD COLUMN `bp_repeat_after_minutes` SMALLINT UNSIGNED NULL AFTER `bp_repeat_diastolic`,
  ADD COLUMN `bp_symptoms_reviewed` TINYINT(1) NOT NULL DEFAULT 0 AFTER `bp_repeat_after_minutes`,
  ADD COLUMN `bp_symptoms` VARCHAR(500) NULL AFTER `bp_symptoms_reviewed`,
  ADD COLUMN `measurement_notes` TEXT NULL AFTER `medical_changes`;
