-- Migration: Add id_number column to users table
-- Run this file to add ID number support

USE cpp_learning_system;

-- Add id_number column to users table
ALTER TABLE users
ADD COLUMN id_number VARCHAR(50) DEFAULT NULL
AFTER user_type;

SELECT 'Migration completed! ID number column added to users table.' AS message;
