-- ============================================================================
--  2026_sprint30f_hotfix.sql — فاز ۳ هات‌فیکسِ یکپارچگی
--  ثبتِ ساختاریِ دستیار و مشارکتِ پزشک روی خدمتِ انجام‌شده (پرستاری).
--  ۱۰۰٪ ADDITIVE / idempotent / بدونِ DELIMITER (سازگار با cPanel).
-- ============================================================================
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

SET @c:=(SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='cw_performed_services' AND COLUMN_NAME='assistant_id');
SET @s:=IF(@c=0,"ALTER TABLE `cw_performed_services` ADD COLUMN `assistant_id` INT UNSIGNED DEFAULT NULL",'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st;

SET @c:=(SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='cw_performed_services' AND COLUMN_NAME='doctor_involved');
SET @s:=IF(@c=0,"ALTER TABLE `cw_performed_services` ADD COLUMN `doctor_involved` TINYINT(1) NOT NULL DEFAULT 0",'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st;

SET FOREIGN_KEY_CHECKS = 1;
-- ROLLBACK: ALTER TABLE `cw_performed_services` DROP COLUMN `assistant_id`, DROP COLUMN `doctor_involved`;