-- Migration: 0005_add_profile_fields_to_users
-- Mini App integration phase. Adds the academic profile fields the
-- Mini App form collects. Kept as its own focused migration rather
-- than reopening 0001, per the project's "one migration per phase,
-- reviewable independently" convention.

ALTER TABLE users
    ADD COLUMN major VARCHAR(128) NULL AFTER conversation_state,
    ADD COLUMN university VARCHAR(128) NULL AFTER major,
    ADD COLUMN semester TINYINT UNSIGNED NULL AFTER university;