-- Add FCM token column to staff table for Firebase Cloud Messaging notifications
-- Run this SQL script to add the fcm_token column if it doesn't exist

ALTER TABLE `staff` 
ADD COLUMN `fcm_token` VARCHAR(500) NULL AFTER `token_expires`;

-- Optional: Add index for better query performance when filtering by fcm_token
CREATE INDEX `idx_staff_fcm_token` ON `staff` (`fcm_token`);