JezK
Edit File: fix_workflow_schema_s4.php
<?php // fix_workflow_schema_s4.php — Update sessions.status ENUM for radiology workflow require_once __DIR__ . '/config/config.php'; require_once __DIR__ . '/config/db.php'; $pdo = db(); // Update sessions.status ENUM to include radiology workflow stages $pdo->exec("ALTER TABLE sessions MODIFY COLUMN `status` ENUM('scheduled','pending_imaging','imaging_done','report_generated','delivered','completed','cancelled') NOT NULL DEFAULT 'scheduled'"); echo "sessions.status ENUM updated with radiology workflow stages.\n"; // Ensure sessions.notes column exists (could be clinical_notes in older versions) $scols = $pdo->query("DESCRIBE sessions")->fetchAll(PDO::FETCH_COLUMN); if (!in_array('notes', $scols) && !in_array('clinical_notes', $scols)) { $pdo->exec("ALTER TABLE sessions ADD COLUMN `notes` TEXT NULL AFTER `daily_token`"); echo "Added notes column to sessions.\n"; } else { echo "notes/clinical_notes column already exists in sessions.\n"; } echo "\nWorkflow schema update complete.\n";