Fixup: SQL type

1 files changed, 11 insertions, 0 deletions

diff --git a/makima/migrations/20260205200000_fix_decimal_to_float.sql b/makima/migrations/20260205200000_fix_decimal_to_float.sql
new file mode 100644
index 0000000..499cd6f
--- /dev/null
+++ b/makima/migrations/20260205200000_fix_decimal_to_float.sql
@@ -0,0 +1,11 @@
+-- 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;