-- Add user preferences columns to ldw_user
-- avatar_path: relative path to uploaded avatar image (stored in public/uploads/avatars/)
-- theme: light or dark mode preference

ALTER TABLE ldw_user
    ADD COLUMN avatar_path VARCHAR(255) DEFAULT NULL AFTER email,
    ADD COLUMN theme ENUM('light', 'dark') NOT NULL DEFAULT 'light' AFTER avatar_path;