-- Run this in phpMyAdmin / MySQL if `php artisan migrate` is not available.
-- Safe to run once; skip statements that error if column already exists.

-- tbl_patients
ALTER TABLE `tbl_patients` ADD COLUMN `is_vaccination` TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE `tbl_patients` ADD COLUMN `is_nf` TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE `tbl_patients` ADD COLUMN `patient_category` VARCHAR(100) NOT NULL DEFAULT 'general';

-- tbl_queue_managements
ALTER TABLE `tbl_queue_managements` MODIFY `PatientType` VARCHAR(100) NULL DEFAULT NULL;
ALTER TABLE `tbl_queue_managements` ADD COLUMN `is_vaccination` TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE `tbl_queue_managements` ADD COLUMN `patient_category` VARCHAR(100) NOT NULL DEFAULT 'general';
ALTER TABLE `tbl_queue_managements` ADD COLUMN `queue_type` VARCHAR(32) NOT NULL DEFAULT 'doctor';

-- tbl_queue_managements_temp
ALTER TABLE `tbl_queue_managements_temp` MODIFY `PatientType` VARCHAR(100) NULL DEFAULT NULL;
ALTER TABLE `tbl_queue_managements_temp` ADD COLUMN `is_vaccination` TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE `tbl_queue_managements_temp` ADD COLUMN `patient_category` VARCHAR(100) NOT NULL DEFAULT 'general';
ALTER TABLE `tbl_queue_managements_temp` ADD COLUMN `queue_type` VARCHAR(32) NOT NULL DEFAULT 'doctor';
