-- Migration: Add timezone column to users table
-- Date: 2026-04-03
-- Description: Stores each user's IANA timezone (e.g. 'Africa/Accra') so that
--              date filtering and display always use the user's local time,
--              independent of the device's clock or timezone setting.

ALTER TABLE users
ADD COLUMN timezone VARCHAR(100) NOT NULL DEFAULT 'UTC';
