-- Add PIN column for Kiosk Mode
-- This allows users to authenticate using a simple PIN on a shared device.
-- The PIN should be stored as a hash.
ALTER TABLE `users` ADD `pin` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Hashed PIN for Kiosk Mode' AFTER `role`;