-- ============================================
-- PastPaper Master — Make score fields numeric
-- Version: 006
-- Date: 2026-04-10
-- ============================================

ALTER TABLE paper_questions
  ALTER COLUMN score TYPE NUMERIC
  USING score::NUMERIC;

ALTER TABLE papers
  ALTER COLUMN total_score TYPE NUMERIC
  USING total_score::NUMERIC;

ALTER TABLE user_attempts
  ALTER COLUMN score_given TYPE NUMERIC
  USING score_given::NUMERIC;