-- Add violation tracking to submissions table
USE cpp_learning_system;

ALTER TABLE submissions
ADD COLUMN violation_count INT DEFAULT 0 AFTER status,
ADD COLUMN is_auto_submitted BOOLEAN DEFAULT FALSE AFTER violation_count;

-- Display success message
SELECT 'Violation tracking column added successfully!' AS message;
