-- Migration: Add year_level and section to students
-- Run this file to add student year level and section support

USE cpp_learning_system;

-- Add year_level and section columns to users table (for students only)
ALTER TABLE users
ADD COLUMN year_level VARCHAR(20) DEFAULT NULL AFTER user_type,
ADD COLUMN section VARCHAR(50) DEFAULT NULL AFTER year_level;

SELECT 'Migration completed! Year level and section columns added.' AS message;
