-- Migration 011: Rider live location tracking (for the admin Live Operations map)
-- Run this once on your existing database via phpMyAdmin or the mysql CLI.

ALTER TABLE users
    ADD COLUMN last_lat DECIMAL(10,7) NULL AFTER vehicle_number,
    ADD COLUMN last_lng DECIMAL(10,7) NULL AFTER last_lat,
    ADD COLUMN location_updated_at DATETIME NULL AFTER last_lng;