/* RAIET v1.24 — realtime ready, live matches and simple location foundation.
   Run once after 007_ready_check.sql. */

ALTER TABLE user_profiles
    ADD COLUMN location_text VARCHAR(120) NOT NULL DEFAULT '' AFTER bio;

ALTER TABLE lobbies
    MODIFY COLUMN status ENUM('open','in_match','closed') NOT NULL DEFAULT 'open',
    ADD COLUMN match_started_at DATETIME NULL AFTER ready_check_started_at,
    ADD KEY idx_lobbies_live_match (status, match_started_at);
