-- 008: Per-user presentation preferences (UI/UX order 2026-10-28).
-- Presentation only — kept separate from security-sensitive account fields.
-- NULL = follow the default (ar / light). Device cookies may override locally.

-- +up
ALTER TABLE users ADD COLUMN locale VARCHAR(5) NULL CHECK (locale IN ('ar','en'));
ALTER TABLE users ADD COLUMN theme VARCHAR(10) NULL CHECK (theme IN ('light','dark'));

-- +down
ALTER TABLE users DROP COLUMN IF EXISTS theme;
ALTER TABLE users DROP COLUMN IF EXISTS locale;