-- ===================================================================
-- Migration: add the 'super_admin' role
-- ===================================================================
-- Run this ONCE against your existing database (phpMyAdmin → SQL tab,
-- with your database selected in the left sidebar → paste → Go).
-- It only widens the role column's allowed values — no data is
-- changed or lost, and existing users keep their current role.
-- ===================================================================

ALTER TABLE users
    MODIFY COLUMN role ENUM('requester','manager','finance_admin','admin','super_admin')
    NOT NULL DEFAULT 'requester';
