-- Migration: Add HR role value and optional phone on Users (matches backend/models/users.js)
-- Run on existing databases before relying on Sequelize sync.

ALTER TABLE `Users`
MODIFY COLUMN `role` ENUM('user','admin','visitor','super-admin','hr') NULL;

-- If `phone` already exists, skip this statement (ignore duplicate column error).
ALTER TABLE `Users`
ADD COLUMN `phone` TEXT NULL AFTER `email`;
