-- Adds a per-user dark/light theme preference column, set from the header
-- toggle (ThemeController::update) and read server-side when rendering
-- layouts/app.blade.php's <html data-theme="...">.
--
-- MySQL doesn't support IF NOT EXISTS on ADD COLUMN — safe to run once;
-- re-running will error with "Duplicate column name", which is harmless.

ALTER TABLE users ADD COLUMN theme VARCHAR(5) NOT NULL DEFAULT 'light' AFTER role;
