-- Fix type mismatches: DECIMAL -> DOUBLE PRECISION for f64 compatibility
-- DECIMAL/NUMERIC maps to rust_decimal::Decimal, not f64

ALTER TABLE chains
    ALTER COLUMN default_pass_threshold TYPE DOUBLE PRECISION;

ALTER TABLE contract_evaluations
    ALTER COLUMN overall_score TYPE DOUBLE PRECISION;

ALTER TABLE chain_contract_definitions
    ALTER COLUMN pass_threshold TYPE DOUBLE PRECISION;